Help for Accumulation Planning Worksheet

This model helps you plan for retirement, or any other time when you need a funded investment balance.

Target Year for Accumulation:  The year by which you need the funding.

Assumed Inflation Rate:  What you think the annual inflation rate will be between the current year and the measurement year.

After-Tax Rate of Investment Return:  The rate that think your investment will earn each year on a compounded basis.

Amount of Capital Desired:  The amount of funds you will need, at today's purchasing power at the measurement year.

Capital Currently Available:  The amount of funds you will need, after inflation, at the measurement year.

Amount Present Capital will Grow to During Accumulation Period:  What your present funds will grow to by the measurement year.

Estimated Balance Required to Fund Capital:  The shortfall (surplus) required to reach your accumulation goal at the measurement year.

Single Payment Required to Grow:  The amount you would have to invest today to meet the shortfall at the measurement year.

Annual Contribution Required to Grow:  The amount you would have to invest each year to meet the shortfall at the measurement year.