Loans, Sinking Funds, and Compounding Periods
Match the interest rate to the payment period, and every loan becomes a uniform series.
Before this Lesson
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.
A row of equal payments collapses to one lump. P/A and A/P move between the row and a lump one period before its first payment. F/A and A/F move between the row and a lump on its last payment. For more, see Uniform Series and Equivalence.
P/A and F/A are their reciprocals.
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: is the interest rate per interest period, and 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, , and the number of compounding periods per year . The rate that does the work is :
Make those two conversions before you touch a factor. Put $1,000 in an account paying 12% compounded monthly for 3 years. Then and , so:
Mismatch them and the answer goes off the rails: 12% with gives over $59,000, and 1% with 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 , 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.
Where the year ends up, written as a single rate, is the effective annual rate. One period multiplies the money by , and a year holds of those. The Handbook prints the result under Non-Annual Compounding, as the annual effective interest rate:
Monthly, 12% nominal is . Daily, with , it only reaches 12.75%, so slicing the year thinner helps less and less. With , nothing compounds inside the year and the two rates match. For any larger , 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.
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 is one amount per period. A month's 1% covers too little time, and ignores the compounding inside the quarter. The rate for one quarter is three 1% steps in a row:
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: , where is the number of compounding periods in one payment period. Then count 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 and compounding periods.
Some questions test these rules in words.
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 is the top row, seen from the borrower's side. The bank hands you 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.
Run the same row the other way to find the largest loan a payment can carry: . 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 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.
| You know | You want | Factor |
|---|---|---|
| Loan amount | Payment | A/P |
| Affordable payment | Largest loan | P/A |
| Fund balance today | Uniform withdrawal | A/P |
| Target amount | Deposit | A/F |
| Deposit | Amount accumulated | F/A |
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 of payments:
The location rule makes this land in the right place. The next payment is number , so the P/A lump falls one period earlier, exactly at .
For the truck, 24 payments remain:
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.
Where each payment goes
Each payment does two jobs, in a fixed order. First it covers the period's interest, which is 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.
On the truck, payment 1 owes 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.
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: