2. Suppose your parents will pay for your down payment, complete the Mortgage Payment Table using the following values: House Price: $300,000 Down Payment: 10% Interest Rate: 9% per year. Length of Payment: 30 years. First Payment: 1/15/2018 3. Print area A9:E25 with spreadsheet frames. (This is only part of the whole Mortgage Payment Table.) Make sure that your printout will fit into one page, centered, and properly labeled. Please print only the specified area, not the whole spreadsheet. 4. Again, suppose that your parents will pay for your down payment, change the assumption figures to the following values, and redo the Mortgage Payment Table. House Price: $450,000 Down Payment: 20% Interest Rate: 7.5% per year. Length of Mortgage: 15 years. First Payment: 1/15/2018 5. Print area A9:E25 without spreadsheet frames. Again, print the area into one page in good format. 6. Print cell formulas for Cells A12:E13. 7. Mortgage lenders have the "36/28" rule in their mortgage decisions. The "36/28" rule suggests that a borrower's monthly mortgage payment does not exceed 28% of his/her gross monthly income, and that the total monthly payments do not exceed 36% of the gross monthly income. Refer back to Step 2, if a borrower is to qualify for the mortgage application for the house s/he has in mind, how much should the minimum gross monthly and annual incomes be in order for the borrower to qualify? (You need to show your computations to support your answer.) 8. Suppose that, in addition to the house mortgage, the borrower also has a 5-year 4.9% car loan of $18,000, and monthly payment of $345 to pay back his/her college student loans, how much should the minimum gross monthly and annual incomes be in order for the borrower to qualify the mortgage loan in Step 4 above using the 36/28 rule