Problem 1 (20 marks)

You are planning for your retirement. You expect to earn a monthly salary of $7,000 starting on the 1st month after you retire, which will be able to provide comfortably for your daily expenses through your retirement years. You are currently 33 and plan on retiring when you become 64, and you expect to live 20 years after retirement. In addition to providing a salary for your retirement you would like to buy a house by the time you reach 55. The house you dream of would cost you $1,650,000. Now you have a down payment of $50,000 (ignore closing costs). In addition you would like to offer yourself a retirement gift, a Mercedes that you would buy brand new to serve you through your retirement years. The car is expected to cost you $76,000. It will be purchased when you reach 64 years of age. Assume you can earn 12% compounded monthly from now until you retire, and the rate will change to 6% monthly compounding after that.

(Please provide all the equation and step by step or Excel.xml in google drive )

(Please don't copy from another places, the answer will upload to Turnitin)

1. How much should you save per month to be able to buy the car when you retire? (5 marks)
2. How much should you save per month to be able to buy the house at the age of 55? (5 marks)
3. Therefore, how much do you need to save in TOTAL per month if you can earn 12% compounded monthly from now till you buy your house taking into account your retirement expenses? (5 marks)
4. d. And how much do you need to save in TOTAL per month after you buy your house until you retire taking into account your retirement expenses? (5 marks)