MindTap - Cengage Learning Excel Online Student Work + c o about blank G Apps Sunset Estate-Ov... VitalSource Back... Home My WLC Th Dashboard Login x Excel template Saved Simplified Ribbon File Home Insert Formulas Data Review View Help Tell me what you want to do Editing Comments Arial B 10 Av ... = ... Merge General $ B D E F G H 1 3 L M N O P Q R 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 $60,000 10 25 5.00% $100,000 8.00% 10 Calculate value of savings in 10 years: 11 Savings at t = 10 12 Formulas #NIA #NIA #NIA 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 nel amount needed at t= 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 27 28 29 30 #NIA #NIA #NIA #NIA Sheet1 Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + MindTap - Cengage Learning Excel Online Student Work + c o about blank G Apps Sunset Estate-Ov... VitalSource Back... Home My WLC Th Dashboard Login x Excel template Saved Simplified Ribbon File Home Insert Formulas Data Review View Help Tell me what you want to do Editing Comments Arial B 10 Av ... = ... Merge General $ B D E F G H 1 3 L M N O P Q R 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 $60,000 10 25 5.00% $100,000 8.00% 10 Calculate value of savings in 10 years: 11 Savings at t = 10 12 Formulas #NIA #NIA #NIA 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 nel amount needed at t= 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 27 28 29 30 #NIA #NIA #NIA #NIA Sheet1 Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% +