On May 31, 2019, you closed on your new condominium and obtained a $280,000, thirty-year mortgage at an APR of
3.6%. The first monthly payment was due at that time (May 31, 2019), and then monthly thereafter (this is an "annuity in advance" or an "annuity due").
a. What was the amount of your required monthly payment?
b. Assuming that you made all payments exactly when due, how much interest did you pay on the mortgage in the calendar year ending December 31, 2019?
c. How much interest would you pay in 2020 if you made all of your scheduled payments exactly when due?
d. If the interest rate were to decrease to 3.0% after seventy-two payments (six years), what would be the amount of your new monthly payment? (the life of the mortgage would be unchanged).
***No excel please