Answer with Excel, please!

2. Youre given with a mortgage from your credit union to buy a house that costs $620,000. Suppose you pay $124,000 for down payment and the current average market interest rate is 2.8% for the 15-year mortgage. Answer the following questions:

1. What is the monthly payment if there is no pre-payment penalty?

2. Suppose the credit union says that if youd like to retire the loan earlier, say at the end of the 7th year, you need to pay (say) $361,000 for the rest of the loan, would you take it given that you have no difficulty to generate the cash flow? Why or why not?

3. Suppose that the credit union also offers you another possible payment program that is they will give you a low 1.2% interest rate for the first 6 years and with a lump-sum payment at the end of the 6th year as $532,000. (The lump-sum payment is a one-time payment that you must pay it off or, you need to re-finance by then.) What is your monthly payment for the first 5 years?

4. Suppose you follow the original mortgage in (a) without any refinancing or prepayment, and after 5 years of payments, you discover the current market interest rate for mortgage drops to 1.8% APR. Instead of paying off the mortgage, you are about to refinance your mortgage for a 15-year mortgage instead. What is your monthly payment for your mortgage now? Is re-financing good for you?