Question

Ms. Frank is planning for a 25-year retirement period and wishes to withdraw a portion of her savings at the end of each year. She plans to withdraw $10 000 at the end of the first year, and then to increase the amount of the withdrawal by $1000 each year, to offset inflation. How much money should she have in her savings account at the start of the retirement period, if the bank pays (a) 9'10, (b) 7:%, per year, compounded annually

Answer 1

I guess the interest rates are 9.10% and 7% per year.

a) $173,369.67

b) $217,212.31

Step-by-step explanation:

the total distributions received by Ms. Frank are:

year distribution

1 10000

2 11000

3 12000

4 13000

5 14000

6 15000

7 16000

8 17000

9 18000

10 19000

11 20000

12 21000

13 22000

14 23000

15 24000

16 25000

17 26000

18 27000

19 28000

20 29000

21 30000

22 31000

23 32000

24 33000

25 34000

Using excel, I calculated the present value of this annuity using the different discount rates (using present value function)

a) $173,369.67

b) $217,212.31