I f you decide to make a payment that is larger than your regular payment, your balance will be reduced by an extra amount. Your lender should reduce your balance, and hence the accrued interest until your loan is paid off, accordingly. Similarly, if you make a payment that is smaller than your regular payment, some corrections must be made. In this latter case, penalties might be added to the balance as well as corrections to the calculations.
Different lenders handle these situations differently. This makes it impossible for me to discuss or present a spreadsheet that will handle the general case. Instead, I ’ ll just show a couple of possibilities here. What I ’ m doing is mathematically correct, but remember that it might not apply directly to your loan.
l ’ ll use the same loan as shown in Table 3.7 і Suppose that in May 2006, I received a good income tax refund and I want to apply my newfound extra money to my loan. For payment number 10, I’ll pay $10,000 instead of my regular $3,134.17.
Table 3.9 The Amortization Spreadsheet with Extra Payments Inserted
On my spreadsheet, just type $10,000 in for the correct payment as shown in Table 3.9. (If you haven’t done it already, please take a minute and read the information in Chapter 15 on how to reestablish the original spreadsheet calculations after you’ve changed them.) As you can see, the payments after the $10,000 payment reflect the change and correctly show the new regular payment necessary to exactly pay off the loan at the end of 180 months. The balance, interest, and total interest per year columns are also correct.
Just to show what can be done, I changed payment 15 to a payment of $2,000.00. Again, the spreadsheet automatically corrected all of its calculations to reflect this change.