Question

You are planning your retirement in 10 years. You currently have $166,000 in a bond account and $606,000 in a stock account. You plan to add $7,400 per year at the end of each of the next 10 years to your bond account. The stock account will earn a return of 11 percent and the bond account will earn a return of 7.5 percent. When you retire, you plan to withdraw an equal amount for each of the next 24 years at the end of each year and have nothing left. Additionally, when you retire you will transfer your money to an account that earns 6.75 percent.

How much can you withdraw each year in your retirement?

Answer 1

A B C 1 $166,000 value after 10 years 2 Add: $7,400 deposits value after 10 years 342,131.24 166000*(1+7.5%)^10 104,688.45 FV(7.5%,10,-7400,0,0) $ $ 3 4 Bond A/c balance after 10 years 5 Add: 6 Stock A/c balance after 10 years $ 446,819.69 1,720,689.12 -606000*(1+11%)^10 $ 7 8 Total amount after 10 years $ 2,167,508.80 10 Annual withdrawal amount $184,854.82 -PMT(6.75%,24,-2167508.8,0,0)

*Please rate thumbs up