Please show work in excel, show formulas used and content of cells for an upvote:

Suppose you want to retire in 27 years, that you are making $66,000 per year today, and you are deferring 10% of your monthly gross income into your retirement plan.

a) With an assumed 2.8% annual inflation rate from now until you retire, what net annual income will you need in your first year of retirement to maintain todays lifestyle?

b) If your investment account earns a nominal rate of 7.9% per year, compounded daily, what is the effective interest rate, or annual percentage yield, of your investment account?

c) Since you plan to live for another 37 years after you retire and you want to continue the income calculated in part (a), ignoring inflation during retirement, how much should you have in your investments on retirement day, with the expectation that your account will continue to earn the interest rate found in part b? Assume social security has been exhausted, you have no pension available, and you can only rely on your own personal investments to support you in retirement.

d) Suppose that youve accumulated $115,000 toward your retirement so far today. How much money should you deposit into that account every year in order to reach your goal?