You are planning for retirement. Use the following information to answer the question.

How much will you need at retirement if you assume that the amount you will spend in retirement is the average of the first and last years expenses in retirement?

a. The expected inflation rate from now until retirement is expected to be 2.9%.

b. Your current income/expenses are $100,000 and that is the same standard of living you will have in retirement.

c. You can expect to earn 5.5% on your money in retirement.

d. You are 35 when you graduate and expect to work until you are 65.

e. Your life expectancy is 84.

f. You will leave your heirs $1,000,000 upon your death.

This is all of the info provided. Please show formulas and formatting in Excel.