Steve is buying home that costs $500,000. You have been offered a 30-year mortgage that requires a 20% down payment for the house. The loan is to be repaid in equal monthly installments. The APR of the mortgage is 4%. Compute the EAR and the amount of your monthly payment on the mortgage. Show all calculations. you need to find the amount of the monthly payment in two different ways: 1) using the built-in Excel function 2) using the annuity formula