, me late has a taste all w much the site years and weather File Home Insert Formulas Data Arial | 10 ' ' B I B11 fi B A 1 Required annuity payments 2 3 Retirement income today 4 Years to retirement 5 Years of retirement 6 Inflation rate 7 Savings 8 Rate of return 9 10 Calculate value of savings in 10 years: 11 Savings at t = 10 12 $45,000 10 25 3.00% $135,000 7.00% Formulas #N/A #NA 13 Calculate value of fixed retirement income in 10 years: 14 Retirement income at t = 10 15 Calculate value of 25 beginning-of-year retirement 16 payments at t =10: 17. Retirement payments at t = 10 18 19 Calculate net amount needed at t = 10: 20 Value of retirement payments 21 Value of savings 22 Net amount needed #N/A #N/A #N/A #N/A #N/A 24 Calculate annual savings needed for next 10 years: 25 Annual savings needed for retirement 26 27 28 29 30