Required: Solve these question in Microsoft Excel
1. You want to retire on the day you have $1,000,000 is your savings account. You expect to earn 4 percent compounded monthly, on your money during your retirement. Your plan is to withdraw $4500 a month as retirement income from this account. How many years can you be retired until you run out of money?
2. you are able to pay mortgage payments of $675 a month for thirty years. the interest rate is 9.5 percent, compounded monthly, What price can you afford to buy if you have $5000 cash available as a down payment.
Note: Solve these question in MS Excel