O POCHOPEWellnesses you need to edit story in die Electing tro D H M Beginning Balance Years late 1 Monthly Pays F 2,300.00 18.COM Dolls S SIDE $ 5 S - Montoya Tetail Tata 31 38326 2.12.14 5.4 G Month Beginning Balance interest Charee Balance after interest Payment Debt Portion End Balance 15 2.000.005 10.00 5 2,030.00 $ 300.00 S 170.00 5 1,800.00 1,820.00 1.82.49 200.00 $ 172.555 1657.65 1557455 24.88 1.682.31S 200.00 5 175.145 1.48231 1AK31$ 22235 1,504,50 200.00 172. 1,104.54 1.0050 S 19.575 232411 S 200.00 S 180035 1.124.11 1,124 16.65 1.140.975 200,00 IRL 145 40.97 9000 : 14.11 S 955085 20.00 185.89 $ 755.08 5 PS 1135 76.45 00:00 13.5 566.41 5$ 850 $ 574,95 $ 200.00 $ 191.50 $ 174.91 105 276 5.25 13:35 200,00 194.55 100 11 S 18035 2.71 $ T25 187,265 1055 12 s $ 5 S 5 IS 3 S S 145 5 S 15 S S 13 SIS 175 S 1 S S 33S $ 5 SES 21 5 225 SIS 215 5 ES SA $ SS 5 5 20.5 S $ 5. 5 $ $ 5 SN SISENE SS SSC S. 5 04 25 $ 5 5 5 S $ 5 $ s S NS 2 5 ERIRE ES 5 5 $ Whett D Type here to search O II e E G Ed x] du Mortgages You decide to buy a house! The home is priced at $279,000 and the bank has agreed to finance your home at 51% for 30 years. (Note Excel approximations do not include property taxes or insurance) Use the Amortization Worksheet and Module 2 Formula Sheet to answer the following questions: 8. What is the monthly payment? 9 How much of the first payment is interest? How much of that first payment actually goes to reducing the principal? 10. At which month did you pay approximately half of the mortgage? Is this halfway through your mortgage? Let's explore making extra payments on your mortgage Change the payment value in cell B3 to be $100 more than it is now 11. If you pay just $100 more each month, when will you make your last payment? 12. How much time does that cut off of your mortgage (how many months do you not have to make a mortgage payment)? 13. If you make the payments which are $100 larger, how much do you pay over the life of the loan? 14. If you made the originally payments, without paying an extra s100 per month, how much do you pay over the life of the loan? over the life of the 15. Therefore, by paying an additional $100 per month, you will save mortgage