Question

Problem 5-57 Spreadsheet Problem (LG5-2, LG5-9) Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65. For the first ten years, she contributes $3,600 per year. She increases the contribution rate to $5,600 per year in years 11 through 20. This is followed by increases to $10,600 per year in years 21 through 30 and to $15,600 per year for the last ten years. This money earns a return of 9 percent. First compute the value of the retirement plan when she turns age 65. (Round your answer to 2 decimal places.) Value Compute the annual payment she would receive over the next 40 years if the wealth was converted to an annuity payment at 8 percent. (Round your answer to 2 decimal places.) Annual payment

Answer 1

1.
=3600/9%*(1.09^10-1)*1.09^30+5600/9%*(1.09^10-1)*1.09^20+10600/9%*(1.09^10-1)*1.09^10+15600/9%*(1.09^10-1)
=1820757.12605

2.
=1820757.12605*8%/(1-1/1.08^40)
=152688.98664