PLEASE SHOW WORK IN EXCEL

|You want to save for your retirement, but you have zero savings now. To live comfortably, you decide you will need to have $3,000,131.75 by the time you are age 67. Suppose that today (December 14th) is your 28th birthday, and you decide that, beginning on your 29th birthday and continuing on every birthday up to and including your 67th birthday, you will put the same amount into a savings account. a. If you can earn 4% on your savings compounded annually, how much must you save each year to have $3,000,131.75 in your account on your 67th birthday? b. Suppose that you decide to save some amount every month on the 14th of the month to accumulate $3,000,131.75. How much must you save each month if you earn 4% APR (Annual Percentage Rate), but your savings is compounded monthly instead of annually. C. Suppose that you have accumulated $3,000,131.75 in your savings account (on which you are earning 4% compounded annually) at age 67 (after you have made your last monthly contribution). How much can you withdraw monthly (at the end of each month), starting one month after your 67th birthday and continuing every month until your 97th birthday, after which you plan to have nothing left in the account? d. Because your income will increase over your lifetime, you decide to put in a smaller amount one year from today and let your annual contributions grow by 3% each year, so that you will have accumulated $3,000,131.75 by your 67th birthday. How much must you put into your account one year from today if you will let your annual contributions grow by 3% each year? (For this part d, assume that you are making annual contributions, not monthly ones.) Part d of the problem may take you much more time than the other parts of the