1. Your generous grandmother has just announced that she’s opened a savings account for you with a deposit of $ 10,000. Moreover, she intends to make nine more similar gifts, at the end of this year, next year, etc. If the savings account pays 8% interest, how much will you have accumulated at the end of 10 years (1 year after the last gift)? (See spreadsheet attached separately)

2. What is the present value of a series of four payments, each $1,000, to be made at the end of years 1,2,3,and 4? Assume that the interest rate is 14%

3. Anuradha Dixit just turned 55. Anuradha is planning to retire in 10 years, and she currently has $500,000 in her pension fund. Based on the longevity pattern of her family, she assumes that she will live 20 years past he retirement rate; during each of these years she desire to withdraw $100,000 from he pension fund. If the interest rate is 5% annually how much will Anuradha have to save annualy for the next 10 years? Assume that the first deposit to her pension fund will be today, followed by nine more annual deposits, and that the annual withdrawls fromage 65 will occur at the beginning of each year.

Use the following spreadsheet (the numbers are not correct) and Goal Seek to find an answer. (See spreadsheet attached separately)

4. Your annual salary is $100,000. You are offered two options for a severance package. Option 1 pays you 6 months’ salary now. Option 2 pays you and your heirs $6,000 per year forever (first payment at the end of this year). If your required return is 11% which option should you choose?

The following questions correspond to the questions above.

1. The total future value will be…?
2. The total PVs for all years is….?
3. How much is annual withdrawn at the age of 57?
4. How much is account balance at the beginning of age 84?
5. How much is the account balance at end of age 84?
6. How much is the value of alternative 1?
7. How much is the value of alternative 2?

Spreadsheets for individual questions

#1
Year Gift Future Value
0 10,000 in year 10
1 10,000 21589.24997
2 10,000 19990.04627
3 10,000 18509.3021
4 10,000 17138.24269
5 10,000 15868.74323
6 10,000 14693.28077
7 10,000 13604.8896
8 10,000 12597.12
9 10,000 11664

SUM: 145654.8746
FV FUNCTION:

#2
Interest rate 14%

Year Payment PV
1 1,000 877.1929825
2 1,000 769.4675285
3 1,000 674.9715162
4 1,000 592.0802774

Total 2913.712304
NPV function

#3
Annual desired pension payout 100,000

Annual payment 10,000

Interest rate 5%

Your age Account balance beginning of year Deposit or withdrawl beginning of year Interset earned during year Total in account end of year
55 500,000 10,000 25,500 535,500
56 535,500 10,000 27,275 572,775
57 572,775 10,000 29,139 611,914
58 611,914 10,000 31,096 653,010
59 653,009 10,000 33,150 696,159
60 696,160 10,000 35,308 741,468
61 741,468 10,000 37,573 789,041
62 789,041 10,000 39,952 838,993
63 838,993 10,000 42,450 891,443
64 891,443 10,000 45,072 946,515
65 946,515 -100,000 42,326 888,841
66 888,841 -100,000 39,442 828,283
67 828,283 -100,000 36,414 764,697
68 764,697 -100,000 33,235 697,932
69 697,932 -100,000 29,897 627,829
70 627,829 -100,000 26,391 554,220
71 554,220 -100,000 22,711 476,931
72 476,931 -100,000 18,847 395,778
73 395,778 -100,000 14,789 310,567
74 310,566 -100,000 10,528 221,094
75 221,095 -100,000 6,055 127,150
76 127,150 -100,000 1,357 28,507
77 28,507 -100,000 -3,575 -75,068
78 -75,068 -100,000 -8,753 -183,821
79 -183,821 -100,000 -14,191 -298,012
80 -298,012 -100,000 -19,901 -417,913
81 -417,913 -100,000 -25,896 -543,809
82 -543,808 -100,000 -32,190 -675,998
83 -675,999 -100,000 -38,800 -814,799
84 -814,799 -100,000 -45,740 -960,539

1. Your generous grandmother has just announced that she’s opened...