| Phase 2 Individual Project |
| Student Name: | | JD |
| Current age you will be using for this project: | | | | | 33 |
| Part 1 -- Calculation of future value for this lifestyle |
| Present value of life style (given in problem scenario) |
| Average rate of inflation (given in problem scenario) |
| Years until retirement (retirement age - current age) | | | | | | | years |
| Future value of life style |
| Part 2 -- Calculation of 5-year rate of return on Top 500 stocks |
| Top 500 stock value five years ago |
| Top 500 stock value now |
| Number of periods (given in problem scenario) | | | | | | | years |
| 5-year rate of return on Top 500 stocks |
| Time required for investment to double (Rule of 72) | | | | | | | years |
| Part 3 -- Calculation of investment required today to reach retirement fund need |
| Future value of retirement account (given in problem) |
| 5-year rate of return on Top 500 stocks |
| Years until retirement (retirement age - current age) | | | | | | | years |
| Present value of required investment |
| Part 4 -- Calculate the amount required at retirement to support the lifestyle after inflation adjustment |
| Future value of retirement lifestyle (from Part 1) |
| Rate of return on an annuity (given in problem scenario) |
| Number of years in retirement (expectancy - retirement age) |
| Amount required at retirement to support life style |
| Part 5 -- Calculation of annual contribution required to meet the retirement goal |
| Future value of the retirement account (from Part 4) |
| 5-year rate of return on Top 500 stocks (from Part 2) |
| Years until retirement (retirement age - current age) |
| Annual contribution required to meet the retirement goal |
jd69162
project_template.xlsx
