You are planning your retirement in 10 years. You currently have $163,000 in a b
ID: 2642614 • Letter: Y
Question
You are planning your retirement in 10 years. You currently have $163,000 in a bond account and $603,000 in a stock account. You plan to add $7,700 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.25 percent and the bond account will earn a return of 7.75 percent. When you retire, you plan to withdraw an equal amount for each of the next 22 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 7 percent.
How much can you withdraw each year in your retirement? (Enter rounded answer as directed, but do not use rounded numbers in intermediate calculations.Round your answer to 2 decimal places (e.g., 32.16).)
You are planning your retirement in 10 years. You currently have $163,000 in a bond account and $603,000 in a stock account. You plan to add $7,700 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.25 percent and the bond account will earn a return of 7.75 percent. When you retire, you plan to withdraw an equal amount for each of the next 22 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 7 percent.
You are planning your retirement in 10 years. You currently have $163,000 in a bond account and $603,000 in a stock account. You plan to add $7,700 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.25 percent and the bond account will earn a return of 7.75 percent. When you retire, you plan to withdraw an equal amount for each of the next 22 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 7 percent. How much can you withdraw each year in your retirement? (Enter rounded answer as directed, but do not use rounded numbers in intermediate calculations.Round your answer to 2 decimal places (e.g., 32.16).)Explanation / Answer
Amount accumulated at retirement:
Bond account = -FV(0.0775,10,7700,163000) = 454074
Stock account = 603000 * (1 + .1125)^10 = 1751126
Total amount accumulated = 454074 + 1751126 = 2205,200
Annual withdrawal (Using Excel based formula):
=PMT(0.07,22,-2205200,0)
= 199,362.81
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.