I need to solve on Excel sheet please

Exercise 2: Calculating Time Value of Monev in Excel This assignment is designed to familiarize you with the use of Excel functions to make time value of money calculations in order to answer questions related to a retirement needs analysis. StatementofFacts - Jennifer Wilson (age 47) has hired you to help her plan for her future retirement - She plans to retire in 20 years when she will be 67 and live to age 100 (33 years in retirement) - Her yearly income is $35,000 - Her current yearly spending is $30,000 and she plans to maintain this level in retirement - Inflation is projected to be 3% per year - She currently has saved $100,000 for her retirement - Her investments are projected to grow at 8% per year - Inflation-adjusted rate of return =[(1+ investment return rate 1+ inflation rate )1]100 - Her inflation-adjusted rate of return is projected to be 4.85% per year: [(1.081.03)1]100 Using Excel Functions to Make Time Value of Money Calculations - Step One - Calculating the Future Value of the Yearly Spending Needed: Determine the future value of Jennifer's annual spending needed for her first year of retirement and then solve for the future value of this amount 1. Layout the worksheet in a format similar to how the lecture slides illustrate to calculate the Future Value of a Single Amount 2. Present Value = current yearly spending, but the amount should be negative as it reflects cash spending / outflows 3. Rate of Interest =3% (inflation rate) 4. Number of Years = years to retirement 5. Type = payment due at the end of the period (0) - Step Two - Calculating the Present Value of the Series of Future Spending Payments: Solve for the present value of the amount Jennifer will need for retirement 1. Layout the worksheet in a format similar to how the lecture slides illustrate to calculate the Present Value of an Annuity Due 2. Annual Annuity Payment = calculated in Step One (link cell to the value from Step One), but the amount should be negative as it reflects cash spending / outflows 3. Rate of Interest =4.85% (inflation-adjusted rate of return) 4. Number of Years = years spent in retirement 5. Type = payment due at the beginning of the period (1) Step Three - Calculate the Amount Needed to be Saved Annually Solve for the annual payment needed for Jennifer to achieve the future value for her needed retirement fund 1. Layout the worksheet in a format similar to how the lecture slides illustrate to calculate the Annual Deposits Amount to Accumulate a Future Sum and add a row for Present Value 2. Present Value = amount already accumulated, but the amount should be negative as it reflects cash spending / outflows 3. Future Value = amount needed to support retirement spending (link cell to the value from Step Two) 4. Rate of Interest =8% (investment growth rate) 5. Number of Years = years to retirement 6. Type = payment due at the end of the period (0)