Car Loan Amortization Table Calculator

This car loan amortization calculator estimates your monthly payment and total interest from the loan amount, annual percentage rate (APR), and term. Enter those three figures to see the level payment and the interest paid over the full scheduled term; the table below explains how each payment changes the balance.

Formula

A standard fixed-rate, fully amortizing car loan uses a level monthly payment. The payment formula is:

Payment = P × r / [1 − (1 + r)−n]

• P is the amount borrowed, in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 12 ÷ 100, or APR ÷ 1,200.
• n is the number of monthly payments: loan term in years × 12.
• Payment is the scheduled monthly principal-and-interest amount, in dollars.

Total interest is calculated as monthly payment × n − P. The calculator uses the formula’s unrounded payment internally for the displayed payment and total-interest calculation. A real lender may round each scheduled payment and interest charge to cents, so its final figures can differ slightly.

Worked Example

Using the calculator’s defaults: a $20,000 loan, 8% APR, and a five-year term.

1. Monthly rate: r = 8 ÷ 1,200 = 0.0066667.
2. Number of payments: n = 5 × 12 = 60.
3. Monthly payment: 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53.
4. Total of scheduled payments, using the unrounded formula payment: approximately $24,331.80.
5. Total interest: approximately $24,331.80 − $20,000 = $4,331.80.

The displayed payment and interest are rounded to cents. Multiplying the displayed $405.53 by 60 gives $24,331.80 after rounding, matching the example; actual lender statements can reflect payment-level rounding and other contract details.

Assumptions

• The interest rate is fixed for the entire term.
• Payments are made monthly, at the end of each period, beginning one month after borrowing.
• Interest accrues monthly using the APR divided by 12; the calculator treats APR as a nominal annual rate.
• The estimate excludes fees, taxes, insurance, optional products, and any other charges not entered as part of the loan amount.

How to Read an Amortization Table

An amortization table lays out each scheduled payment by due date or payment number. A detailed table commonly includes the opening balance, payment, interest portion, principal portion, and closing balance. The opening balance for the first row is the amount borrowed. For each later row, the opening balance is the prior row’s closing balance.

For a monthly period, estimate interest by multiplying the opening balance by the monthly rate. Subtract that interest from the payment to find the principal reduction. Then subtract the principal reduction from the opening balance to get the new balance. For example, on the default loan, the first month’s interest is about $133.33 ($20,000 × 0.0066667); the remainder of a $405.53 payment, about $272.20, reduces principal. The next month’s interest is slightly lower because the balance has fallen.

Early payments therefore devote a larger share to interest, while later payments devote more to principal. The scheduled payment stays level when the rate and payment schedule stay fixed, but the split changes from month to month. This is normal amortization, not a separate charge for paying early.

Using the Estimate for a Car Purchase

Enter the amount actually financed, rather than automatically using the vehicle’s advertised price. A down payment or trade-in value may reduce the amount borrowed; items added to the contract may increase it. Use the APR and term shown in the lender’s disclosure or a written quote, rather than treating the sample 8% as a current market rate.

• Loan amount: check whether the figure includes any financed taxes, fees, or optional products.
• APR: enter it as a percentage, so 8 means 8%, not 0.08.
• Term: enter the number of years; the calculator converts it to monthly payments.

The result is a principal-and-interest estimate, not necessarily the complete monthly cost of owning or insuring a vehicle. A lender’s required payment, payment dates, and contract terms are the relevant figures for an actual loan.

Common Differences and Limits

A calculator’s result may not match a lender’s schedule exactly. The lender may use a different first-payment date, daily interest accrual, payment rounding, or a different amount financed. Fees and optional items can also affect the contract balance or total paid. Compare the inputs and assumptions before interpreting a difference as an error.

An amortization table describes scheduled payments; it does not automatically model extra payments, skipped or late payments, refinancing, or a changing rate. Extra principal payments can alter future interest and payoff timing, but how they are applied depends on the loan terms and servicer process. The fixed-rate formula also does not show the vehicle’s value, depreciation, insurance, fuel, maintenance, or taxes.

One common misconception is that a lower monthly payment necessarily means less interest overall. A longer term spreads repayment across more months and can increase total interest, even though the scheduled payment may be lower. Compare the amount financed, term, APR, payment, and total of payments together; this arithmetic does not determine which terms to choose.

Frequently Asked Questions

What does an amortization table for a car loan show?
It shows how each scheduled payment is divided between interest and principal and how the remaining balance changes over time.

Why is more of my first car payment interest?
Interest for a period is calculated on the opening balance. That balance is largest at the start, so the interest portion tends to be larger early in a level-payment loan.

Does this calculator include a down payment?
No separate down-payment field is included. Subtract a down payment or trade-in credit from the purchase amount when determining the amount financed, and account for any other items included in the loan.

Can I use this table if I make extra payments?
The standard calculation assumes only the same scheduled monthly payment. Extra payments are not represented, and their effect depends on when they are made and how the lender applies them.

Why does my lender’s payoff amount differ from the table balance?
A table estimates scheduled balances. A payoff figure may account for interest accrued since the last payment, contract-specific charges, payment timing, or rounding; request the exact payoff amount from the lender.

This result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Qualifying Income for Self Assessment Explained
• NCS AP Benefits: Qualifying Income Explained
• Qualifying Income for Pension Contributions Explained

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