The instructor wants the answers in an excel formula format, not just a number. If you're not able to provide a formula, show me your work and I should be able to make it into a formula.

Retirement plan chapter 5 Excel STUDENT-1 [Read-Only] - Excel Sign in -0 File Home Insert Draw Page Layout Formulas Data Review View Power PivotTell me what you want to do E13 1 Required annuity payments INPUTS 3 4 5 6 7 8 Retirement income today Years to retirement Years of retirement Inflation rate Savings Rate of return ?. $155,000 HINTS 10 Calculate value of savings in 10 years: 11 Savings att 10 12 13 Calculate value of fixed retirement income in 10 years: 14 Retirement income att-10 15 16 Calculate value of 25 beginning-of-year retirement payments at t-10: 17 Retirement payments att-10 18 19 Calculate net amount needed at t 10: 20 Value of retirement payments 21 Value of savings 22 Net amount needed Formulas Formulas?Are the number of arguments S3??,941.37 $89,542.38 5958,695.55 Pv(???? 5958,695.55 53??,941.37 $591,754.18 24 Calculate annual savings needed for next 10 years: 25 Annual savings needed for retirement 26 27 538,949.31 -PMT(????) ProblemPerpnfatio Perp Inflation Ready ? ??. + 100% 1:49 PM 6/27/2018