Please show all formulas and work done for every problem

The purpose of this project is to investigate the cost of a home mortgage. A couple has decided to purchase a home. The negotiated price is $175,000 The couple can pay the standard 20% down payment, and the rest will be financed at the annual interest rate of 4.5% for a 30-year loan. Some questions: 1. Is a mortgage agreement a type of annuity? 2. Calculate the down payment. 3. Calculate the amount to be borrowed (amortized) 4. Calculate the monthly payment. 5. Since there will be 360 monthly payments, how much will actually be paid for the home? Don't forget to add in the down payment. 6. How much of your result from Question 5 is interest? 7. Complete the ammortization table below for all 360 payments. As you complete the rows, pay attention to the amount of interest and the amount of principal that is paid each month. Some hints: Complete rows 1 and 2 of the table, then copy row 2 over and over in order to finish the table at the 360th row. As you copy the rows, make sure that the monthly payment amount does not change. Your monthly payment amount is an absolute cell reference. You do not have to enter each period number individually. In the first row of your table, enter 1. In the second row of your table, enter a formula, "-cell + 1". Then copy that cell formula down the column of your table