Question

Once you graduate college and start working, you expect that you'll be able to save $8 thousand every year at the start of each year, an amount that will grow with inflation. Inflation is anticipated to be 2% per year. You think you will need $1 million of invested assets, as measured in today's purchasing power, in order to reach financial independence. You also anticipate an average nominal rate of return on your investment of 8.3%. How long will it take you to reach your goal? Round up to the next whole year.

Hint: set up a spreadsheet with the timeline, and extend it until you reach your goal.

You can either work with nominal dollars, and adjust your target and deposit amounts for inflation, or just work with the real rate of return. If doing the latter, you can try using the annuity equation.

Bonus: Now that you have your setup, tweak the amount you save and see how it affects the time to goal.

Answer 1

First we calculate the real interest rate then

then PV of each of the payments is calculated and it can be seen that it takes 36 years to hit the one million target

At the end of 35th year he had saved you can see that he is 8362.45 $ short of his target