Understanding the Mathematics of Personal Finance

RULE OF 78

This rule is sometimes called the sum-of-digits method. I’ll explain where both of these names came from shortly. As you shall see, any loan bearing this type of prepayment penalty is to be avoided. Various states have a legislation limiting its use. Hopefully, by the time you’re reading this, the practice will have been banned universally.

The rule of 78 payoff calculation used to be very popular with automobile loans. I understand it is uncommon today. As long as it remains legal, however, you’ll see it being used—principally among somewhat unscrupulous dealers who offer “sub­prime” loans to people who don’t have good credit, probably at an exorbitant interest rate.

I’ll use the auto loan of Table 5.1 as my first example. The spreadsheet Ch5PrepaymentPenalties. xls is used to calculate these examples. The data input area to the left of the green line is identical to the data input area in the previous chapters’ spreadsheets, so I needn’t repeat it in detail. Also, the first six columns to the right of the green line are identical to the same columns in the previous chapters’ spread­sheets. Since there are so many numbers to calculate, this spreadsheet is quite wide and you’ll have to scroll a bit to see everything. If you like, you can shrink the width or hide the columns carrying intermediate calculates (such as shares) to see the results easily.

The first number I need is the sum of the digits of the payment numbers: 1 + 2 + 3 + ... + 35 + 36 = 666. If you were to do this for a 1-year loan, you’d get 1 + 2 + 3 + .. . + 11 +12 = 78, hence the name (although I’m pretty sure there aren’t many 1-year auto or other similar loans).

Next, assuming the loan was to be fully paid off, I need the sum of all the inter­est components of the monthly payments. In Table 5.1i this is the sum of all the numbers in the column labeled interest, which is equal to $1,921.64.

Divide the sum of the interest payments by the sum of the payment numbers and call the result the interest fraction:

1,921 64

Interest fraction = ’ ' = 2.885.

666

So far, all I’ve done is to calculate an odd parameter, the interest fraction. Now I’m going to multiply this interest fraction by the payment number, but in reverse order, and call this the number of shares.

For payment number 1, I’ll multiply the interest fraction by 36, from which I get (2.885)(36) = 103.87. For payment number 2, I’ll have (2.885)(35) = 100.99.

Table 5.2 is a repeat of Table 5.1 but with the fake balance column removed and several new columns, including a shares column, added.

This shares calculation is where the injustice comes about. If you add up all the entries in the shares column, you get $1,921.64. Similarly, if you add up all the entries in the interest column (new column #4), you get the same number. However, look at the total interest (Tot Int) column—this is a running total of the interest payments—and the “earned interest” column—a running total of the shares column. The name earned interest was coined by the people who came up with this procedure. It doesn’t mean what it says. The shares column loads the interest payments up front, early in the loan, so that “earned interest” isn’t really earned interest accrued; it’s a conveniently faked number.

The payoff number is calculated by adding together the true balance and the difference between the earned interest and the actual total interest. For example, after payment number 12,

Payoff = $10,392.96 + $1,056.03 - $1,033.51 = $10,415.49.

Compare this with the actual payoff at the same time, which is $10,392.96. The actual prepayment penalty is the difference between the payoff and the balance, which, after payment number 12, is $22.53.

Figure 5.1 shows the prepayment penalty for this loan versus the payment number. As the figure shows, 1 year into the loan, the prepayment penalty peaks at about $22.

At this point, you’re probably wondering if all of this was worth the trouble; $22 is not a huge amount of money, and I did say that the lender is often entitled to some prepayment penalty.

Now consider a $300,000, 15-year loan at the same interest rate (8%). Figure 5.2 shows the prepayment penalty as a function of payment number for this loan. About 5 years into the loan, this penalty is almost $12,000! When you consider that the administrative and bookkeeping costs of this loan aren’t much different from that of the previous example, this is one very, very large prepayment penalty.

While I’ve provided an online worksheet for calculating rule of 78 prepayment penalties, the rule of thumb is that you don’t want to be dealing with a lender who asks for this in the loan agreement. If it’ s a small several t year loan such as the example in Table 5.2’ then you can probably live with it because the amount isn’t very large. In general, however, it’s close to robbery.

Table 5.2 Auto Loan with Rule of 78 Prepayment Penalty Added

Подпись: 0 15,000.00 0.00 0.00 1 14,629.95 100.00 100.00 2 14,257.44 97.53 197.53 3 13,882.45 95.05 292.58 4 13,504.95 92.55 385.13 5 13,124.94 90.03 475.17 6 12,742.39 87.50 562.66 7 12,357.30 84.95 647.61 8 11,969.63 82.38 730.00 9 11,579.38 79.80 809.79 10 11,186.53 77.20 886.99 11 10,791.07 74.58 961.57 12 10,392.96 71.94 1,033.51 13 9,992.20 69.29 1,102.79 14 9,588.77 66.61 1,169.41 15 9,182.65 63.93 1,233.33 16 8,773.82 61.22 1,294.55 17 8,362.27 58.49 1,353.04 18 7,947.97 55.75 1,408.79 19 7,530.91 52.99 1,461.78 20 7,111.07 50.21 1,511.98 21 6,688.44 47.41 1,559.39 22 6,262.98 44.59 1,603.98 23 5,834.69 41.75 1,645.73 24 5,403.54 38.90 1,684.63 25 4,969.52 36.02 1,720.66 26 4,532.60 33.13 1,753.79 27 4,092.77 30.22 1,784.00 28 3,650.01 27.29 1,811.29 29 3,204.30 24.33 1,835.62 30 2,755.62 21.36 1,856.98 31 2,303.94 18.37 1,875.35 32 1,849.26 15.36 1,890.71 33 1,391.54 12.33 1,903.04 34 930.77 9.28 1,912.32 35 466.93 6.21 1,918.52 36 0.00 3.11 1,921.64
Подпись: 103.87 103.87 14,633.83 3.87 100.99 204.86 14,264.77 7.33 98.10 302.96 13,892.82 10.38 95.22 398.18 13,518.00 13.04 92.33 490.51 13,140.28 15.34 89.45 579.95 12,759.68 17.29 86.56 666.51 12,376.20 18.90 83.67 750.19 11,989.82 20.19 80.79 830.98 11,600.57 21.18 77.90 908.88 11,208.43 21.89 75.02 983.90 10,813.40 22.33 72.13 1,056.03 10,415.49 22.53 69.25 1,125.28 10,014.69 22.49 66.36 1,191.65 9,611.01 22.24 63.48 1,255.12 9,204.44 21.79 60.59 1,315.72 8,794.99 21.16 57.71 1,373.42 8,382.65 20.38 54.82 1,428.24 7,967.43 19.45 51.94 1,480.18 7,549.32 18.40 49.05 1,529.23 7,128.32 17.25 46.17 1,575.40 6,704.44 16.01 43.28 1,618.68 6,277.68 14.70 40.39 1,659.07 5,848.03 13.34 37.51 1,696.58 5,415.49 11.95 34.62 1,731.20 4,980.07 10.55 31.74 1,762.94 4,541.76 9.16 28.85 1,791.80 4,100.57 7.79 25.97 1,817.77 3,656.49 6.48 23.08 1,840.85 3,209.53 5.23 20.20 1,861.05 2,759.68 4.06 17.31 1,878.36 2,306.95 3.00 14.43 1,892.78 1,851.33 2.07 11.54 1,904.33 1,392.82 1.28 8.66 1,912.98 931.43 0.66 5.77 1,918.75 467.16 0.23 2.89 1,921.64 0.00 0.00

Pmt Nr Balance Interest Tot Int Shares Earned Payoff Penalty ($) ($) ($) interest ($) ($) ($)

image061

Payment number

Figure 5.1 Prepayment penalty versus payment number with data from Table 5.2.

image062

Payment number

Figure 5.2 Prepayment penalty versus payment number for a large loan example.

Добавить комментарий

Understanding the Mathematics of Personal Finance

PAYING OFF A LOAN VERY SLOWLY

This section uses a little math, but I’ll go through it slowly in small steps. As with the previous section, this section is not necessary if you don’t want to …

Taxation and Inflation

John Lennon once said, “Life is what happens to you while you’re busy making other plans.” Both taxation and inflation, it seems, are parts of life—they happen to you while …

PARI-MUTUEL BETTING

The pari-mutuel machine system used at race tracks offers a different approach to gambling. A roulette wheel owner is never sure what his or her daily operating cost will be; …

Как с нами связаться:

Украина:
г.Александрия
тел./факс +38 05235  77193 Бухгалтерия

+38 050 457 13 30 — Рашид - продажи новинок
e-mail: msd@msd.com.ua
Схема проезда к производственному офису:
Схема проезда к МСД

Партнеры МСД

Контакты для заказов оборудования:

Внимание! На этом сайте большинство материалов - техническая литература в помощь предпринимателю. Так же большинство производственного оборудования сегодня не актуально. Уточнить можно по почте: Эл. почта: msd@msd.com.ua

+38 050 512 1194 Александр
- телефон для консультаций и заказов спец.оборудования, дробилок, уловителей, дражираторов, гереторных насосов и инженерных решений.