RAP

Your father is 50 years old and will retire in 10 years. He expects to ve for 25 years after her until the. He wants of retirement income that has the same purchasing power at the time he retires a $50,000 has today. (The real value of his retirement come will dinero esseramentine will begin the devertret 10 years from today at home he will receive 24 additional anal gayments Annual Wation is expected to the currenys 595.000 saved, and he expect to anyon his savings. The data has been in the crosoft Excel Online Nebelow. Open the spreadsheet and perform the required anys tower the question belon Open saadsheet Hochmuth save during each of the next 10 years and of year deposits to meet his time it Do not round your intermediate akulation und your answer to the art cont Check My Word Hesablon B D E F F G H A 1 Required annuity payments 2 Retirement income today 4 Years to retirement Years of retirement Inflation rate 7 Savings Rate of return 9 10 Calculate value of savings in 10 years. 11 Savings at t = 10 12 co OWN $50,000 10 25 4.00% $95,000 9.00% Formulas #N/A #N/A #NA 13 Calculate value of fixed retirement income in 10 years: 14 Retirement income att = 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 att = 10: 20 Value of retirement payments 21 Value of savings 22 Net amount needed 23 24 Calculate annual savings needed for next 10 years: 25 Annual savings needed for retirement 26 WN/A #N/A #N/A #N/A 27