Please include an excel spreadsheet with all formulas. Thank you!

Question 1. We will begin by considering a fairly straightforward situation. Suppose you are are purchasing a new home and need to borrow $450,000 from a mortgage lender. The mortgage lender quotes you a rate of 3.80% APR for a 30-year fixed rate mortgage. (a.) Assuming that your payment will be due at the beginning of each month, calculate what your mortgage payments will be. (b.) Produce an amortization table which shows how much of your mortgage payment is allocated to interest service and how much is dedicated to paying down the principal of the loan each month. - Hint: We did this in class, but assumed payments happened at the end of the month. So you will have to modify what we did slighly. Just think carefully about how the timing of the cash flows changes. . (c.) Calculate the mortgage payment amount if the mortgage had its payments due at the end of the month. (d.) Compare the amounts you found in parts (a.) and (c.). Does it makes sense which one is higher? Briefly explain the underlying logic