You are trying to determine how much you need in order to retire comfortably. If you were to retire today, you could live on $8,000 per month. But you will retire in 30 years and with expected inflation of 3% per year, you want a starting monthly retirement income that will have the same purchasing power when you retire as $8,000 has now. You anticipate living for 25 years in retirement. The first retirement check will come at the end of your first month of retirement and all of the checks will be of the same size. You expect to earn 9% on your investments. You have already accumulated $40,000 in your retirement account. How much must you save at the end of each month between now and the day you retire, with your first savings deposit in one month, in order to fund your retirement? (Hint: the first step is to figure out how much your retirement income needs to be.)

Please show your answer in Excel

a.$942.06

b.$1,036.27

c.$1,139.89

d.$1,253.88

e.$1,379.27