Nest Egg Calculator: How Much Will I Have at Age X?

Supply Chen Management

So we’ve all heard that “if you save and invest ‘X dollars’ every year starting at ‘age Y’ you’ll be a millionaire”.  How much will your retirement nest egg amount to at age 50? 60? 70?  Find out in seconds through this predictive simulation calculator!

traditional-iraInstructions:

  1. Click “Run Pen” to activate the interactive Pen
  2. Once activated, enter your current age, starting balance, and yearly contribution
  3. Click “Simulate Again” for a new simulation

The assumptions are as follows:

  • Rate of Return is calculated via =norm.dist(RAND(),mean,std dev) function to help simulate variability
  • Annual return ranges based off normal distribution with a mean of 1.07 (7% annual gain) and .13 standard deviation (95% (+/- 2std dev) of all years will be between -19% and +33%)
  • In today’s dollars, 7% real return as n approaches infinity
  • n = 50 simulations
  • Percentiles will create a decent inner-quartile range

If you notice errors or have any questions…

View original post 36 more words

Advertisements