Question 1201083
a) Create an Amortization table on Excel with the following headers:
Months Payment Applied to Interest Applied to Loan Balance


<img src = "http://theo.x10hosting.com/2023/041303.jpg">



<img src = "http://theo.x10hosting.com/2023/041304.jpg">



<img src = "http://theo.x10hosting.com/2023/041305.jpg">



b) What is the total amount in interest you pay if you pay off the loan as scheduled?
$183,267.24


c) What interest do you pay in the first year (first 12 months)?
$10,118.27


d) What interest do you pay in the last year (last 12 months)?
$220.25


e) If you pay an extra $125 per payment from the beginning of the loan, when will you have it
paid off? 
paid off by end of month 302.


f)How much will you save on total interest if you do this?
$33,698.76