A car financing amortization table shows each monthly payment split into interest and principal over the life of your auto loan, along with the remaining balance after each payment. You enter the loan amount, interest rate (APR), and loan term, and the table tells you exactly how much of each payment goes toward interest, how much reduces what you owe, and what your balance is at any point. This guide explains how to read and use that table, how the numbers are calculated, and what it means for your total borrowing cost.
Formula
The amortization table is built on the standard level-payment formula used for most fixed-rate auto loans:
Monthly payment (M) = P × (r × (1 + r)^n) / ((1 + r)^n − 1)
Where:
- P = loan amount (principal) in dollars
- r = monthly interest rate = APR / 1200 (APR is the annual percentage rate in percent, divided by 12 months and by 100 to convert to a decimal)
- n = total number of monthly payments = loan term in years × 12
For each payment number k (from 1 to n), the table uses these steps:
- Interest for month k = previous balance × r
- Principal portion = monthly payment − interest for that month
- New balance = previous balance − principal portion
The payment is rounded to the nearest cent, and every subsequent calculation uses that rounded value, so the final balance may be a few cents off from zero—that is normal.
Worked Example
Using the calculator defaults: loan amount = $20,000, APR = 8%, term = 5 years.
- Monthly rate: r = 8 / 1200 = 0.0066666667
- Number of payments: n = 5 × 12 = 60
- Monthly payment: M = 20000 × (0.0066666667 × (1.0066666667)^60) / ((1.0066666667)^60 − 1)
- (1.0066666667)^60 ≈ 1.4898457
- Numerator: 20000 × (0.0066666667 × 1.4898457) ≈ 20000 × 0.0099323 ≈ 198.646
- Denominator: 1.4898457 − 1 = 0.4898457
- M ≈ 198.646 / 0.4898457 ≈ 405.53 (rounded to the cent)
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, matching the calculator output.
Now look at the first few rows of the amortization table:
- Payment 1: interest = 20000 × 0.0066666667 ≈ $133.33; principal = 405.53 − 133.33 = $272.20; new balance = 20000 − 272.20 = $19,727.80
- Payment 2: interest = 19727.80 × 0.0066666667 ≈ $131.52; principal = 405.53 − 131.52 = $274.01; new balance = 19,727.80 − 274.01 = $19,453.79
- Payment 3: interest ≈ $129.69; principal ≈ $275.84; new balance ≈ $19,177.95
Notice the interest portion decreases each month while the principal portion increases—that is the hallmark of amortization.
Assumptions
- The loan has a fixed interest rate for the entire term (no variable-rate changes).
- Payments are made at the end of each month, starting one month after the loan is issued.
- Interest compounds monthly at a rate equal to APR divided by 12.
- The table does not include fees, taxes, dealer add-ons, insurance, or any other charges that might be rolled into the loan.
- If you pay extra or miss a payment, the actual amortization will differ from this table.
How to Read the Table
Each row in a typical amortization table shows:
- Payment number (e.g., 1, 2, 3…)
- Payment amount (the fixed monthly payment)
- Interest paid in that payment
- Principal paid in that payment
- Remaining balance after that payment
Reading the table tells you how much of your money is going toward interest at any stage. Early payments are interest-heavy; later payments are principal-heavy. For example, in the worked example above, the first payment’s interest is $133.33 (about 33% of the payment), while the last payment’s interest is only about $2.69.
Why the Interest Portion Shrinks
Interest is calculated on the current outstanding balance. Since you are paying down the principal each month, the balance shrinks, so the interest charged on that smaller balance also shrinks. The monthly payment stays the same, so the freed-up money goes toward principal. This is why the principal portion grows over time.
This also means that if you make extra principal payments early, you save more interest than if you make the same extra payment later, because you reduce the balance that would otherwise accrue interest for many future months.
How to Build Your Own Table
You can create an amortization table in a spreadsheet with these steps:
- Enter the loan amount, APR, and term.
- Calculate the monthly payment using the formula above.
- For each month, compute interest = previous balance × (APR/1200), principal = payment − interest, new balance = previous balance − principal.
- Repeat for the number of months in the term.
Spreadsheet programs often have built-in functions like PMT and IPMT that do this automatically. The key is to use the same monthly rate and to round the payment to the cent for consistency.
Common Misconceptions
- “The interest rate is the same as the APR.” APR includes certain fees and costs, so it may be slightly higher than the nominal interest rate. For auto loans, the difference is usually small, but always use the APR for calculations.
- “If I pay extra, I just shorten the term.” Extra payments reduce the principal, which lowers the balance and the interest charged. The term may shorten if you continue paying the same amount, but the payment amount itself does not change unless you recast the loan.
- “The total interest shown is what I’ll pay if I make all payments on time.” Yes, assuming no fees and no prepayment penalties. If you pay late, extra interest may accrue.
- “The table shows the payoff amount at any time.” The remaining balance is close to the payoff amount, but lenders may add a per-diem interest charge for the days between the statement date and the payoff date.
Frequently Asked Questions
How do I calculate the monthly payment on a car loan?
Use the formula: payment = P × (r × (1 + r)^n) / ((1 + r)^n − 1), where P is the loan amount, r is the monthly rate (APR/1200), and n is the number of months. For a $20,000 loan at 8% APR for 60 months, the payment is $405.53.
Why is the interest portion higher in the first month?
Because interest is charged on the full loan amount at the start. As you pay down principal, the balance decreases, so the interest on that smaller balance is lower. The payment stays the same, so more of it goes to principal each month.
Does the amortization table change if I make extra payments?
Yes. Extra principal payments reduce the balance faster, which lowers the interest charged in subsequent months. The table would need to be recalculated with the new balance and remaining term. Many lenders allow you to make extra payments without penalty, but check your loan contract.
What is the difference between the interest rate and APR?
The interest rate is the cost of borrowing the principal. APR includes the interest rate plus certain fees and costs, expressed as a yearly rate. For auto loans, APR is typically the more accurate figure for comparing loans because it reflects the total cost.
Can I use the table to find my payoff amount?
The remaining balance in the table is a good estimate, but the actual payoff amount may be slightly higher because lenders add interest for the days between the last payment and the payoff date. Contact your lender for the exact payoff figure.
What happens if I miss a payment?
Missing a payment can result in late fees and may cause the interest to accrue on the unpaid amount, which changes the amortization schedule. The lender may also report the late payment to credit bureaus. It is best to contact your lender immediately if you anticipate a missed payment.
This amortization table is an educational estimate. Your lender’s loan disclosure will show the exact payment schedule, interest charges, and payoff terms for your specific 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
- Debt Ratio Benchmarks: What Is a Good Debt Ratio?24.0 %
- Debt Ratio Calculation Formula & How to Use It25.00 %
- Car Loan Calculator: Estimate Your Monthly Payment$405.53
- Calculate My Payoff Date: Loan Payoff Calculator
- Student Loan Interest Deduction Limit: 2025 Rules$405.53
- Car Loan EMI Calculator Month Wise$405.53