Excel template - Saved Home Insert Data Review View Help Tell me what you want to do C D Required annuity payments $50,000 25 Retirement income today Years to retirement Years of retirement Inflation rate Savings Rate of return 5.00% $140,000 7.00% Formulas Calculate value of savings in 10 years: Savings att - 10 Calculate value of fixed retirement income in 10 years: Retirement income att - 10 Calculate value of 25 beginning-of-year retirement payments att 10: Retirement payments at t = 10 NA Calculate net amount needed at t = 10: Value of retirement payments Value of savings Net amount needed #N/A #N/A #N/A Calculate annual savings needed for next 10 years: Annual savings needed for retirement #N/A