Question: For the initial scenario, assume your current age, $1,000 current savings, a retirement age of 62, a life expectancy of 90 years, an inflation

For the initial scenario, assume your current age, $1,000 current savings, a

 

For the initial scenario, assume your current age, $1,000 current savings, a retirement age of 62, a life expectancy of 90 years, an inflation rate of 2.5%, an investment portfolio return of 8% and current purchasing power of income of $85,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 62 and waiting until age 70. Then answer these two questions: Which would you personally prefer and why? How will affect your investing strategy for the next 20 years? your choice 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.

Step by Step Solution

3.40 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

20 PVH19H9H181 A B D F G H K L M N Inputs 4 5 Assume Current Age 23 B Age of Retirement Years to ret... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!