for annual income you are welcome to put any desired amount but, I prefer 60,000 for low 80,000 medium and 100,000 for high and for years 15 years for all there columns. Please refer to an excel sheet

A B C D F G

Annual income Years to retirement calculate future assumed annual retirement fund $$ goal

desired now (use same number t value of annual $$ interest rate upon (the big pot of money or

throughout) income adjusted for 2% retirement the nest egg you will live on

annual inflation (use 7%) its interest D/F

E.G. 50,000 19 years 72841 7 % 1,040,579

Low 60,000 15 years ? 7% ?

Medium 80,000 years ? 7% ?

High 100,000 15 years ? 7% ?

Calculate how much you want (desire, need) for your retirement fund (the nest egg, in $$$$$$$$$$).Create the following spreadsheet in Excel (instructions below):

In column B, input your assumptions regarding your desired annual income now (for you to retire in comfort now, in today's dollars).Input a low, medium, and high scenario (one per line).

In column C, input your estimated years to retirement; use the SAME number for each row.

In column D, calculate the Future Value of your annual income (for each scenario).Use EXCEL!

In column F, we input an assumed average annual interest rate you will earn as Interest Income on your retirement account, upon retirement.(Assume you will be earning interest at a mixed rate of7%)

In column G, calculate E/F.