I need all the answers on the excel, along with the formulas used. Please help me

Prof. Washington has a self-managed retirement plan through his University and would like to retire in 10 years and wonders if his current and future planned savings will provide adequate future retirement income. Here's his information and goals.

? Prof. Washington wants a 25-year retirement annuity that begins 10 years from todaywith an equal annual payment equal to $70,000 today inflated at 3% annually over 10 years.

His first retirement annuity payment would occur 10 years from today.He realizes hispurchasing power will decrease over time during retirement.

? Prof. Washington currently has $280,000 in his University retirement account. He expectsthese savings and any future deposits into his University and any other retirement account will earn 7.5% compounded annually. Also, he expects to earn this same 7.5% annual return after he retires.

Answer the following questions to help Prof. Washington finalize his retirement planning.

1. What is Prof. Business' desired annual retirement income in the first year, i.e., the retirement income he wants 10 years from today?

2. Assuming that inflation is zero from year 10, how much will Prof. Washington need 10years from today to fund his desired retirement annuity?

3. Assume that inflation is zero from year 10. In addition to the $280,000 balance today,Prof. Washington will fund his future retirement goal from question 2 by making 10 annual equal deposits at 7.5% compounded annually into his retirement accounts starting a year from today (the last deposit will be made when Prof. Washington retires). How large does this annual deposit need to be in addition to the initial $280,000 invested in Prof. Business' retirement fund?

4. Assume that inflation is 3% during the entire period, even after retirement. -I got rid of some unnecessary sentences here- Prof. Washington is worried about his purchasingpower eroding during retirement. He would like his first retirement withdrawal to be equal to the amount you found in #1, and then he increase each successive retirement withdrawal by 3% annually over the remaining 24 withdrawals. How much will Prof. Washington need now at retirement given Prof. Washington's 7.5% expected return?

5. In addition to the $280,000 balance today, Prof. Washington will fund his adjusted future retirement goal from question 4 by making 10 annual equal deposits at 7.5% compounded annually into his retirement accounts starting a year from today (the last deposit will be made when Prof. Washington retires). How large does this annual deposit need to be in addition to the initial $280,000 invested in Prof. Washington's retirement fund?