Required annuity payments Retirement income today Years to retirement Years of retirement $55,000 10 25 Inflation rate 3.00% Savings $110,000 Rate of retur 10.00% Calculate value of savings in 10 years: Savings at t=10 Formulas #N/A Calculate value of fixed retirement income in 10 years: Retirement income at t=10 #N/A Calculate value of 25 beginning-of-year retirement Spayments at t=10: Retirement payments at t=10 #N/A 8 9 Calculate net amount needed at t=10: 20 Value of retirement payments 1 Value of savings 22 Net amount needed 23 24 Calculate annual savings needed for next 10 years 25 Annual savings needed for retirement BSheet #N/A #N/A #N/A N/A