5 Excell Spreadsheets accompanying Economics with Calculus
            by Michael C. Lovell, Wesleyan University

Life Insurance: This spreadsheet calculates the value of a life insurance policy purchased at the specified age .
    One year term policy pays $1,000 if the insured dies within one year; zero otherwise.
    Single payment life policy pays $1,000 at the end of the year in which the insured dies.
    The value of these policies depends in part on the rate of interest as well as life expectancy.
    (Supplements Appendix, Chapter 8.1 Compound Interest)
Annuity Calculations: Table shows the value of a life annuity paying $1,000 from the year of purchase until the insured dies.
    (Supplements Appendix, Chapter 8.1 Compound Interest)

Business Cycle:  Shows how the time path generated by the Multiplier-Accelerator model of the Business cycle depends on the systems parameters: the marginal propensity to consume and the desired capital/output ratio.
    (Supplements Chapter 9.4)

Stock Market 1: Risk or Return:   Shows the tradeoff between risk and return generated by a hypothetical two security stock market.   (Supplements Chapter 11.2.4 on the stock Market)
Stock Market 2: TIAA-CREF versus Vanguard: Compares the returns offered investors  by  TIAA-CREF and Vanguard.  TIAA-CREF was established through the initiative of  Andrew Carnegie to help college faculty finance their retirement.  Vanguard pioneered  index funds.  (Supplements Chapter 11.2.4 on the stock Market)

Return to Economics with Calculus