An interest payment table shows how each loan payment splits into interest and principal over time, letting you see the exact interest charge for any period and the remaining balance. You enter your loan amount, annual interest rate (APR), and term, and the table breaks down every payment by period, interest portion, principal portion, and outstanding balance.
Formula
The table is built from the standard level-payment formula. For a fixed-rate loan with monthly payments, the periodic interest rate is r = APR / 1200 (APR in percent per year, divided by 12 months and by 100 to convert to a decimal). The monthly payment is:
PMT = P × r / (1 − (1 + r)^(−n))
- P = loan principal (amount borrowed, in dollars)
- r = monthly interest rate (APR / 1200, as a decimal)
- n = total number of payments (years × 12)
- PMT = fixed monthly payment (dollars)
For each period k (1 to n), the interest portion is Ik = Bk−1 × r, where Bk−1 is the balance before that payment. The principal portion is PMT − Ik, and the new balance is Bk = Bk−1 − (PMT − Ik).
Worked Example
Using the default values from the calculator: loan amount $20,000, APR 8%, term 5 years (60 months).
- Monthly rate: r = 8 / 1200 = 0.0066667 (0.66667% per month)
- Number of payments: n = 5 × 12 = 60
- Payment: PMT = 20000 × 0.0066667 / (1 − (1.0066667)^(−60))
- Compute (1.0066667)^(−60) ≈ 0.67121, so denominator ≈ 1 − 0.67121 = 0.32879
- Numerator = 20000 × 0.0066667 = 133.334
- PMT = 133.334 / 0.32879 ≈ 405.53 (rounded to cents)
So the monthly payment is $405.53. Total paid over 60 months = $405.53 × 60 = $24,331.80. Total interest = $24,331.80 − $20,000 = $4,331.80.
In the first payment, interest = $20,000 × 0.0066667 = $133.33, so principal = $405.53 − $133.33 = $272.20, and the new balance = $20,000 − $272.20 = $19,727.80. Each subsequent payment repeats this with the reduced balance.
Assumptions
- Fixed interest rate for the entire term (no rate changes).
- Payments are made at the end of each month (ordinary annuity).
- Interest compounds monthly at APR / 12, which is the standard for most amortizing loans.
- No fees, taxes, insurance, PMI, or escrow amounts are included.
- The payment is rounded to the nearest cent, and all totals use that rounded payment.
How to Read an Interest Payment Table
Each row of the table corresponds to one payment period (usually a month). The columns typically show:
- Payment number – which period it is (1 to n)
- Payment amount – the fixed monthly payment
- Interest portion – the part of that payment that goes to interest
- Principal portion – the part that reduces the loan balance
- Remaining balance – what you still owe after that payment
Early in the loan, the interest portion is large and the principal portion is small. As the balance decreases, the interest portion shrinks and the principal portion grows. The final payment reduces the balance to zero.
Why the Interest Portion Changes
Interest is calculated on the current outstanding balance, not on the original loan amount. Because you pay down principal gradually, the balance subject to interest decreases each month. That is why the interest portion declines over time while the principal portion increases, even though the total payment stays constant.
For example, in the $20,000, 8%, 5-year loan, the first month’s interest is $133.33. By the 30th payment, the balance is roughly $10,500, so interest is about $70.00. By the last payment, interest is only a few dollars.
Common Mistakes and Misconceptions
- Using the APR as a monthly rate – Always divide by 12 (and by 100) to get the monthly decimal rate. An 8% APR means 0.6667% per month, not 8% per month.
- Ignoring rounding – The payment is rounded to cents; using the unrounded payment in calculations can make the final balance slightly off.
- Assuming interest is calculated on the original amount – That would be simple interest, not amortized interest. The table uses the declining balance.
- Forgetting that the table is for fixed-rate loans – Variable-rate or interest-only loans have different structures.
How to Choose a Loan Term Based on the Table
An interest payment table helps you compare different terms side by side. For the same loan amount and rate, a shorter term (e.g., 3 years) will have higher monthly payments but much lower total interest. A longer term (e.g., 7 years) will have lower monthly payments but higher total interest.
For example, with $20,000 at 8%:
- 3-year term: payment ≈ $626.73, total interest ≈ $2,562.28
- 5-year term: payment ≈ $405.53, total interest ≈ $4,331.80
- 7-year term: payment ≈ $311.24, total interest ≈ $6,144.16
These numbers come from the same formula – you can change the term in the calculator to see the trade-off. The table shows exactly how much extra interest you pay for the convenience of a lower monthly payment.
Limitations of an Interest Payment Table
An amortization table assumes you make every payment on time and in full. If you pay extra, miss payments, or refinance, the table no longer matches your actual loan. The table also does not include any fees or charges that may be added to your balance, such as origination fees or late penalties. For adjustable-rate loans, the table would need to be recalculated each time the rate changes.
Frequently Asked Questions
What is the difference between an interest payment table and an amortization schedule?
They are essentially the same thing. An amortization schedule is the complete list of payments showing principal, interest, and balance for each period. An interest payment table is a common name for that same schedule, often focusing on the interest portion column.
How do I calculate the total interest from the table?
Add up all the interest portions from every row, or simply multiply the monthly payment by the number of payments and subtract the original loan amount. For the example above: $405.53 × 60 − $20,000 = $4,331.80.
Can I use an interest payment table for a car loan or a mortgage?
Yes, the same amortization formula works for any fixed-rate installment loan, including auto loans, personal loans, and fixed-rate mortgages. The only difference is the term and the rate, both of which you enter into the calculator.
Why does my bank’s statement show a slightly different interest amount than my table?
Banks may round the interest to the nearest cent at each step, or they may use a slightly different day-count method (e.g., actual days in the month). The table uses monthly compounding at APR/12, which is standard but may differ by a few cents from a lender’s exact calculation.
What happens if I make an extra payment?
An extra payment reduces the principal balance directly, which means less interest is charged in subsequent months. The loan will be paid off earlier than the original schedule, and the total interest will be lower. You can use an extra-payment calculator to see the effect.
This result is an estimate for educational purposes; your lender’s disclosure provides the exact figures for your loan.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- QNB Car Loan Payment Calculator and Guide$405.53
- VA Down Payment Assistance Calculator and Guide$15,000.00
- Car Loan Payment Calculator and Formula$405.53
- Low Down Payment Home Loans: Costs and Trade-Offs$405.53
- Down Payment vs Advance Payment: Key Differences
- DIB Bank Car Loan Calculator and Payment Guide$405.53