Loans, Sinking Funds, and Compounding Periods

Match the interest rate to the payment period, and every loan becomes a uniform series.

You finance a $60,000 truck at 6% compounded monthly, paying $1,160 a month for 5 years. Three years in, you've made 36 payments, $41,760 in all, and you want to pay off the rest. Subtract, and you owe $18,240. You call the bank, and the bank says $26,173.

The bank isn't cheating. By the end of this Lesson you can get its number in one line and say where the other $7,933 went. First, though, you need to know what "6% compounded monthly" really means.

The factors count periods, not years

Every factor asks for a rate and a count of periods, and it has no idea how long a period is. It could be a year, a quarter, or a month. The Handbook's Engineering Economics definitions say as much: ii is the interest rate per interest period, and nn is the number of compounding periods.

So what does "6% compounded monthly" mean? The bank isn't charging 6% of anything. It charges 0.5% a month, and the 6 is just 0.5 times 12, quoted per year because people like comparing yearly numbers. The Handbook calls that yearly label the nominal annual interest rate, rr, and the number of compounding periods per year mm. The rate that does the work is r/mr/m:

i=rmn=m×yearsi = \frac{r}{m} \qquad n = m \times \text{years}

Make those two conversions before you touch a factor. Put $1,000 in an account paying 12% compounded monthly for 3 years. Then i=1%i = 1\% and n=36n = 36, so:

F=1,000(1+0.01)36=$1,431F = 1{,}000(1 + 0.01)^{36} = \$1{,}431

Mismatch them and the answer goes off the rails: 12% with n=36n = 36 gives over $59,000, and 1% with n=3n = 3 gives a mere $1,030.

The Handbook's Interest Rate Tables include 0.5%, 1%, 1.5%, and 2%, which are handy monthly rates. Past n=25n = 25, though, they list only 30, 40, 50, 60, and 100, so 36 months, or 360, takes the factor formula.

What a year of compounding really costs

A nominal rate leaves something out: inside the year, interest earns interest. Take $1,000 at a nominal 12%. Compounded yearly, it sits still for twelve months and then jumps 12%. Compounded quarterly, it jumps 3% four times, and each jump is 3% of a slightly bigger sum. Compounded monthly, it takes twelve 1% steps.

$1,000 $1,020 $1,040 $1,060 $1,080 $1,100 $1,120 $1,140 0 3 6 9 12 Month Balance Monthly: $1,126.83 Quarterly: $1,125.51 Yearly: $1,120.00
$1,000 at a nominal 12% for one year

Where the year ends up, written as a single rate, is the effective annual rate. One period multiplies the money by 1+r/m1 + r/m, and a year holds mm of those. The Handbook prints the result under Non-Annual Compounding, as the annual effective interest rate:

ie=(1+rm)m−1i_e = \left(1 + \frac{r}{m}\right)^m - 1

Monthly, 12% nominal is (1.01)12−1=12.68%(1.01)^{12} - 1 = 12.68\%. Daily, with m=365m = 365, it only reaches 12.75%, so slicing the year thinner helps less and less. With m=1m = 1, nothing compounds inside the year and the two rates match. For any larger mm, the effective rate comes out higher than the nominal rate, so nominal rates with different compounding can't be compared directly. To compare quotes, turn each one into its effective rate.

Checkpoint
1 of 2

A bank quotes 9% compounded monthly. What is the effective annual rate, in percent?

%

When payments and compounding disagree

Now a wrinkle. You deposit money every quarter into an account paying 12% compounded monthly. The factors need a rate per payment period, since AA is one amount per period. A month's 1% covers too little time, and 12%/4=3%12\%/4 = 3\% ignores the compounding inside the quarter. The rate for one quarter is three 1% steps in a row:

One payment period: (1.01)3 − 1 = 3.03% 1% 1% 1% A A A A 0 3 6 9 12 Month
Three compounding periods in one payment period
iquarter=(1.01)3−1=3.03%i_{\text{quarter}} = (1.01)^3 - 1 = 3.03\%

That's the effective-rate idea again, with a quarter standing in for the year. The Handbook prints the effective rate only for a full year, so you build this one yourself: (1+r/m)c−1(1 + r/m)^{c} - 1, where cc is the number of compounding periods in one payment period. Then count nn in payment periods. The rate won't be in the tables, so use the factor formulas and keep a few extra digits in your calculator's memory. A single sum has no payment period to match, so it sticks with r/mr/m and compounding periods.

Worked Example Quarterly deposits, monthly compounding
1 of 4

A firm deposits $5,000 at the end of every quarter for 3 years in an account paying 12% compounded monthly. How much is in the account right after the last deposit?

Some questions test these rules in words.

Checkpoint

Which statements about interest rates are true?

A.
At a given nominal rate, compounding more often lowers the effective annual rate.
B.
When interest compounds more often than yearly, the effective annual rate exceeds the nominal rate.
C.
A 5-year loan at 6% compounded monthly with monthly payments uses i = 6% and n = 60.
D.
With monthly payments, the interest rate and the number of periods must both be stated in months.
E.
A rate compounded once a year has an effective annual rate equal to its nominal rate.

A loan is a row with a lump at the front

With the rate sorted out, every loan and savings plan here is one row of equal payments with one lump at one end. The end tells you which factors apply.

A loan: the lump is at the front 0 1 2 3 n End of period A A A A P loan received A/P finds A. P/A finds P. A sinking fund: the lump is at the back 0 1 2 3 n End of period A A A A F target amount A/F finds A. F/A finds F.
One row, two ends

A loan is the top row, seen from the borrower's side. The bank hands you PP at time 0, and the payments start one period later. That's exactly where P/A lands, so the amount you borrow is the present worth of your payments at the loan's rate. To find the payment, spread that lump with A/P, the Handbook's Capital Recovery factor, at the per-period rate. One caution: at small rates, the tables' four decimals leave A/P only three significant digits. Dividing by P/A, its reciprocal, keeps more.

Worked Example The truck payment
1 of 3

A $60,000 loan at 6% compounded monthly is repaid in equal monthly payments over 5 years. Find the payment.

Run the same row the other way to find the largest loan a payment can carry: P=A(P/A, i, n)P = A(P/A,\ i,\ n). A fund you draw down is the same row with the roles swapped. You hand the bank a lump, and the bank pays you equal installments until the account hits zero, so the withdrawal is A=P(A/P, i, n)A = P(A/P,\ i,\ n).

Checkpoint
1 of 2

A contractor can afford $2,500 a month on a 5-year equipment loan at 12% compounded monthly. What is the largest loan?

A.
$150,000
B.
$112,388
C.
$108,144
D.
$20,810

A sinking fund is a row with a lump at the back

Now move the lump to the back. A water district knows it must replace a pump in 10 years, and it doesn't want the whole bill landing in one budget. So it makes equal deposits into an account, a sinking fund, that grows to the pump's cost by the day it's due. That's the bottom row of the figure. The lump is a future amount sitting on the last deposit, so the Handbook's Uniform Series Sinking Fund factor, A/F, spreads it into deposits. F/A runs the other way: given the deposits into a reserve or retirement fund, it finds what they've grown to.

Five questions and the factor each one needs
You knowYou wantFactor
Loan amountPaymentA/P
Affordable paymentLargest loanP/A
Fund balance todayUniform withdrawalA/P
Target amountDepositA/F
DepositAmount accumulatedF/A
Worked Example Saving up for a pump
1 of 3

A water district must replace a pump in 10 years at a cost of $400,000. Its reserve account pays 6% per year. What equal year-end deposit does it need?

What you still owe

Back to the truck. Subtracting payments from the loan was tempting, but only part of each payment cut the debt. The Handbook prints no balance formula, and you don't need one, thanks to an argument you can run in your head.

Picture the moment just after payment 36. The bank has a choice: keep collecting your remaining 24 payments, or take one check today and walk away. At the loan's rate, those are the same money when the check equals the present worth of the payments still to come. So that's the check it will accept, and that check is your balance. After kk of nn payments:

Balance=A (P/A, i, n−k)\text{Balance} = A\,(P/A,\ i,\ n - k)

The location rule makes this land in the right place. The next payment is number k+1k + 1, so the P/A lump falls one period earlier, exactly at kk.

0 12 24 48 60 36 Month $60,000 Balance = $1,160 (P/A, 0.5%, 24) = $26,173 36 payments made 24 still owed, $1,160 each
The truck loan just after payment 36

For the truck, 24 payments remain:

Balance=1,160 (P/A, 0.5%, 24)=1,160(22.5629)=$26,173\text{Balance} = 1{,}160\,(P/A,\ 0.5\%,\ 24) = 1{,}160(22.5629) = \$26{,}173

There's the bank's number, in one line. Notice that the 36 payments you already made appear nowhere in it. All that matters is what's still ahead.

Checkpoint
1 of 2

A $25,000 loan at 12% compounded monthly has 60 monthly payments of $556. What is the balance right after payment 40?

A.
$2,760
B.
$18,256
C.
$10,033
D.
$8,333

Where each payment goes

Each payment does two jobs, in a fixed order. First it covers the period's interest, which is ii times the balance just before the payment. Whatever's left cuts the balance. The Handbook prints none of this, but it follows from what a per-period rate is.

Interest=i×(balance just before)Principal=A−Interest\text{Interest} = i \times (\text{balance just before}) \qquad \text{Principal} = A - \text{Interest}

On the truck, payment 1 owes 0.005(60,000)=$3000.005(60{,}000) = \$300 of interest, so $860 of the $1,160 goes to principal. By payment 37, the balance is down to $26,173, so interest is only $131 and principal is $1,029. As the balance falls, the interest falls with it, and each payment cuts the debt faster than the last.

0 200 400 600 800 1,000 1,200 1 12 24 36 48 60 Payment number Dollars per payment 1 37 60 Interest Principal Payment 1: $300 interest, $860 principal Payment 37: $131 interest, $1,029 principal Payment 60: $6 interest, $1,154 principal
Where each $1,160 goes on the truck loan

That settles the opening puzzle. Your $41,760 cut the debt by only $33,827, from $60,000 to $26,173. The other $7,933 was interest.

Total interest takes none of this work. Every dollar you pay is either principal or interest, so over the whole loan:

Total interest=nA−P=60(1,160)−60,000=$9,600\text{Total interest} = nA - P = 60(1{,}160) - 60{,}000 = \$9{,}600
Checkpoint
1 of 3

A $40,000 loan at 12% compounded monthly runs for 5 years, with payments of $890 a month. What is the total interest paid?

A.
$13,400
B.
$24,000
C.
$53,400
D.
$4,800

Recap

  • Factors count periods. Before using one, state the rate and nn per payment period: i=r/mi = r/m and n=m×yearsn = m \times \text{years} when they line up.
  • The effective annual rate, ie=(1+r/m)m−1i_e = (1 + r/m)^m - 1, exceeds the nominal rate whenever m>1m > 1. Compare quotes by it. When a payment period spans several compounding periods, compound across them, as in (1.01)3−1(1.01)^3 - 1 for a quarter.
  • A loan's lump sits at the front (A/P and P/A), and a sinking fund's sits at the back (A/F and F/A). A fund you draw down works like a loan.
  • The balance after kk payments is the present worth of the payments still owed: A(P/A, i, n−k)A(P/A,\ i,\ n - k).
  • A payment covers interest on the balance just before it, and the rest is principal. Total interest is nA−PnA - P.