Solve the question using excel formula and Please show the excel input steps for the answers.

D A B 1 Deliverable 1: Retirement 2 Each Question is worth 40 points. Complete the following spreadsheet by filling in shaded area. 3 4 Retirem ent Planning 5 A couple will retire in 50 years; they plan to spend about $30,000 a year in retirement, 6 7 which should last about 25 years. They believe that they can earn 8 percent interest on retirement savings. 8 9 a. If they make annual payments into a savings plan, how much will they need to save 10 each year? Assume the first payment comes in 1 year. 11 12 13 Annual Expenditure During Retirement Period 14 Number of Years in Retirement 15 Interest/Return on Retirement Savings & Investments 16 17 Retirement Savings Goal in 50 years 18 Number of Years to Achieve Retirement Savings Goal 19 Annual Deposits Required to Achieve Goal Input value. Input value. Input value Input value