In this lab, we will compare 3 different loan options. Suppose that you are buying a house for $205,000. The loan is at a fixed APR of 3.5% for 30 years. Option 1: Making a down payment 1. If a 10% down payment is required, calculate this amount: What amount remains to be financed (this will be your loan amount)? (Please write this value in the chart below in the first row under "Balance".) 2. Use the "Loan Payment Formula" to calculate your monthly payment: (Note that property tax and homeowner's insurance will usually be added to the monthly payment, but we will look at just the payment on the principal for comparison purposes.) 3. A table of principal and interest payments over the life of a loan is called an amortization table. Amortization tables can be built by hand but are ideally built witha spreadsheet or using an online tool. Go to Canvas and use the "Amortization Table Spreadsheet for Chapter 4 Lab" to complete the Amortization Table below. 4. To use the spreadsheet, enter the loan amount or "balance" from part (2) as the "Loan Amount". Then enter the number of years and interest rate. The spreadsheet will automatically fill. You do NOT have to record the entire spreadsheet, just record the rows that correspond with the table below. Pay attention to what each column means as you will analyze this info later in this lab. Payment # | Monthly | Principal | Interest Paid! Total Paid Balance Payment Interest N/A N/A N/A N/A 360 Explain two interesting things you notice from looking at the amortization table. order to receive full credit, you must use complete sentences. In s. 6. Use the amortization table and record how much total interest you paid Calculate the total you paid over the life of the loan (Remember you paid 10% down, so add that in!). 7. Option 2: Paying $25 extra toward your monthly payment 8. In the spreadsheet, enter that you will now be paying "additional monthly PMT" of $25. This will update the values in the spreadsheet early will you pay off the mortgage? How much total interest will you pay using Option 2 of paying the extra $25 each month? 9. 10. Calculate the total paid over the life of the loan for Option 2 11. How much does paying that extra $25 per month save you over the life of the loan compared to (#7) in Option 1? Option 3: NO Down Payment 12. You realize that you can't afford the down payment and surprisingly find a bank that will allow you to finance the entire cost of the house ($205,000) at the same 3.5% APR. Calculate your new monthly payment using the spreadsheet: (Change the "Loan Amount" and change the "additional monthly PMT" back to $0.) 13. Use the amortization table and record how much total interest you paid. 14. Calculate the total paid over the life of the loan: 15. How much more do you pay over the life of the loan by putting nothing down compared to when you put 10% down in (#7) in Option 1? ,- 16. Explain at least 2 things you've observed from making the above comparisons (down payment vs. no down payment; adding extra $25 per month to your payment). In order to receive full credit, you must use complete sentences