Money & Pricing Tables
Loan Payment Table
A loan payment table answers a question that a full amortisation schedule buries: what does this debt cost me every month, per thousand borrowed? Once you know that number, scaling to any loan amount is one multiplication, and comparing two offers becomes a subtraction instead of a spreadsheet.
The mechanics are worth understanding because they explain the shape of the table. Each payment is fixed, but the split between interest and principal changes every month. Interest is charged on the outstanding balance, so early payments are almost all interest; as the balance falls, more of each payment goes to principal. A longer term lowers the monthly payment but raises the total interest, because the balance stays high for longer.
The tables below use fixed-rate, fully amortising loans with monthly payments — the standard structure for mortgages, car loans and personal loans. Variable-rate loans use the same arithmetic but with a rate that resets, so the payment in the table only holds until the first reset.
One caution before you compare anything: the payment here is principal and interest only. Property tax, homeowners insurance, mortgage insurance and lender fees are all separate, and on a typical mortgage they add 20–30% to the monthly figure. A payment table is the right tool for comparing loan structures and the wrong tool for building a household budget.
Monthly payment per $1,000 borrowed
| Term (years) | 3% | 4% | 5% | 6% | 7% | 8% | 9% | 10% | 12% |
|---|---|---|---|---|---|---|---|---|---|
| 5 | 17.97 | 18.42 | 18.87 | 19.33 | 19.80 | 20.28 | 20.76 | 21.25 | 22.24 |
| 10 | 9.66 | 10.12 | 10.61 | 11.10 | 11.61 | 12.13 | 12.67 | 13.22 | 14.35 |
| 15 | 6.91 | 7.40 | 7.91 | 8.44 | 8.99 | 9.56 | 10.14 | 10.75 | 12.00 |
| 20 | 5.55 | 6.06 | 6.60 | 7.16 | 7.75 | 8.36 | 9.00 | 9.65 | 11.01 |
| 25 | 4.74 | 5.28 | 5.85 | 6.44 | 7.07 | 7.72 | 8.39 | 9.09 | 10.53 |
| 30 | 4.22 | 4.77 | 5.37 | 6.00 | 6.65 | 7.34 | 8.05 | 8.78 | 10.29 |
Fixed-rate, fully amortising, monthly payments. Multiply by the number of thousands borrowed: $250,000 at 6% over 30 years is 250 × $6.00 = $1,498.88.
Total interest paid per $1,000 borrowed
| Term (years) | 3% | 4% | 5% | 6% | 7% | 8% | 9% | 10% | 12% |
|---|---|---|---|---|---|---|---|---|---|
| 5 | 78 | 105 | 132 | 160 | 188 | 217 | 246 | 275 | 335 |
| 10 | 159 | 215 | 273 | 332 | 393 | 456 | 520 | 586 | 722 |
| 15 | 243 | 331 | 423 | 519 | 618 | 720 | 826 | 934 | 1,160 |
| 20 | 331 | 454 | 584 | 719 | 861 | 1,007 | 1,159 | 1,316 | 1,643 |
| 25 | 423 | 584 | 754 | 933 | 1,120 | 1,315 | 1,518 | 1,726 | 2,160 |
| 30 | 518 | 719 | 933 | 1,158 | 1,395 | 1,642 | 1,897 | 2,159 | 2,703 |
The number that surprises people: at 8% over 30 years you pay more interest than principal. At 3% over 15 years you pay about a quarter of the principal.
Payment sensitivity: how much a 1-point rate cut saves per $100,000
| Rate change | Term 15 years | Term 30 years |
|---|---|---|
| 4% → 3% | −$49.11 | −$55.81 |
| 5% → 4% | −$51.11 | −$59.41 |
| 6% → 5% | −$53.06 | −$62.73 |
| 7% → 6% | −$54.97 | −$65.75 |
| 8% → 7% | −$56.82 | −$68.46 |
Monthly saving on a $100,000 loan from cutting the rate by one percentage point. On a 30-year term the saving is smaller per month but lasts twice as long.
How to Use These Tables
- Divide your loan amount by 1,000, then multiply by the figure in the table. A $320,000 mortgage at 6% over 30 years is 320 × $6.00 = $1,918.56 a month.
- Compare total interest, not monthly payment. The second table shows that the cheapest monthly payment is often the most expensive loan.
- For a term between two rows, use the longer term as an upper bound on the payment — the true figure is slightly higher than the longer-term row and lower than the shorter one.
- Add taxes, insurance and any fees before comparing to your budget. The principal-and-interest figure is never the full monthly cost of owning a home.
Common Questions
How much is a $200,000 mortgage at 6% for 30 years?
The factor is $6.00 per $1,000, so the payment is 200 × $6.00 = $1,199.10 a month. Total repayments are $431,676, of which $231,676 is interest — more than the amount borrowed.
Does a longer term always cost more?
In total interest, yes, always, at any positive rate. In monthly cash flow it costs less. The trade is real: a 30-year loan at 6% has a payment about 16% lower than a 20-year loan but total interest roughly 61% higher.
Why does the interest share of the payment start so high?
Because interest is charged on the balance, and the balance is at its maximum in month one. On a 30-year loan at 6%, the first payment is 83% interest. By year 15 it is about 59%, and in the final year almost none.
How much does one percentage point matter?
On a $100,000 30-year loan, going from 6% to 5% saves about $63 a month, or roughly $22,600 over the life of the loan. On a 15-year term the monthly saving is smaller at about $53, and the total saving is much smaller — about $9,550 — because the loan ends sooner.
Do these figures include fees?
No. Origination fees, closing costs and insurance are separate, and on a mortgage they can add 2–5% of the loan amount. The APR quoted by lenders folds those costs in, which is why APR is higher than the note rate.
More Money & Pricing Tables
Sources
- Mortgage calculator and amortisation explanation — Consumer Financial Protection Bureau
- What is a mortgage APR? — Consumer Financial Protection Bureau
- Consumer credit — outstanding balances and interest rates — Board of Governors of the Federal Reserve System
Filed with Finance calculations.