5. Good news: You will almost certainly be a millionaire by the time you retire in 40 years. Bad news: The inflation rate over your lifetime will average about 3.8%.

a. What will be the real value of $1 million by the time you retire in terms of todays dollars? (Enter your answers in whole dollars, not in millions. Do not round intermediate calculations. Round your answer to 2 decimal places. )

b. What real annuity (in todays dollars) will $1 million support if the real interest rate at retirement is 2.8% and the annuity must last for 10 years? (Enter your answers in whole dollars, not in millions. Do not round intermediate calculations. Round your answer to 2 decimal places.)

USE EXCEL