Question
Create an Excel worksheet to calculate how much someone needs to save each year from now until retirement. Assume that anyone using your worksheet will
Create an Excel worksheet to calculate how much someone needs to save each year from now until retirement. Assume that anyone using your worksheet will live on a fixed income during retirement. For the initial scenario, assume you are 19, zero current savings, a retirement age of 60, a life expectancy of 95 years, an inflation rate of 3.5%, an investment portfolio return of 9% and current purchasing power of income of $75,000. Set up your worksheet to compute and show the user: (a) How much they will need to have the day they retire in order to fund their retirement with no additional contributions, (b) How much they will need to invest in the fund each year until retirement to reach that goal. On a second worksheet in the same Excel file, do a second scenario with retirement age of 70 and make a text section in which you explain the differences between retiring at age 60 and waiting until age 70. Which would you personally prefer and why? How will your choice affect your investing strategy for the next 20 years?
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