Question 1 You are purchasing a house for $400,000 and have 20% as down payment. The bank is offering a 30-year fixed loan at an APR of 4.0%. Use two (2) decimal places for dollar amounts in your answers. Answer the following: a) Using the Excel template shown below, prepare an amortization schedule for the length of the loan. b) How much total interest did you pay in the first year of the loan? c) How much of your principal balance was reduced in the first year? d) How much total interest did you pay in the 15th year of the loan? e) How much of your principal balance was reduced in the 15th year? f) How much interest did you pay in the last year of the loan? g) When would the loan be paid off if you added an extra $200 each month starting with the first payment? h) What is the amount of the last payment under this scenario (g)