Question
Use the following information regarding your retirement planning: You plan to work (and save) for 35 years, then retire (and spend money from your retirement
Use the following information regarding your retirement planning:
You plan to work (and save) for 35 years, then retire (and spend money from your retirement account) for 15 years. After these 50 years, you would like your retirement saving account balance to have $275,000. You currently have $30,000 in your retirement account.
You plan to save $2,900 in year 1, and you will increase this amount by 2.5% a year
You want your retirement spending to increase by 1.5% per year
You expect to earn a rate of return of 5% during your working years and 4% during retirement
Cash flows occur at the end of each year
To solve this problem, find the amount that you spend your first year of retirement.
Please use excel sheet to solve it and provide the formula inside of the excel sheet, thanks!!!!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started