IRREGULAR PAYMENTS

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

Pmt Nr

Mnth

Year

Balance ($)

Payment ($)

Interest ($)

Tot Int/Year ($)

0

7

2005

350,000.00

0.00

0.00

0.00

1

8

2005

348,890.00

3,134.17

2,024.17

2,024.17

2

9

2005

347,773.57

3,134.17

2,017.75

4,041.91

3

10

2005

346,650.69

3,134.17

2,011.29

6,053.20

4

11

2005

345,521.32

3,134.17

2,004.80

8,058.00

5

12

2005

344,385.42

3,134.17

1,998.26

10,056.27

6

1

2006

343,242.94

3,134.17

1,991.70

1,991.70

7

2

2006

342,093.86

3,134.17

1,985.09

3,976.78

8

3

2006

340,938.13

3,134.17

1,978.44

5,955.23

9

4

2006

339,775.72

3,134.17

1,971.76

7,926.99

10

5

2006

331,740.76

10,000.00

1,965.04

9,892.02

11

6

2006

330,588.71

3,070.62

1,918.57

11,810.59

12

7

2006

329,429.99

3,070.62

1,911.90

13,722.49

13

8

2006

328,264.57

3,070.62

1,905.20

15,627.70

14

9

2006

327,092.42

3,070.62

1,898.46

17,526.16

15

10

2006

326,984.10

2,000.00

1,891.68

19,417.85

16

11

2006

325,794.45

3,080.71

1,891.06

21,308.90

17

12

2006

324,597.93

3,080.71

1,884.18

23,193.08

18

1

2007

323,394.48

3,080.71

1,877.26

1,877.26

19

2

2007

322,184.07

3,080.71

1,870.30

3,747.56

20

3

2007

320,966.66

3,080.71

1,863.30

5,610.85

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 informa­tion 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.

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>