An auto loan amortization schedule shows how each scheduled payment is divided between interest and principal, and how the balance declines over time. Enter the amount financed, annual APR, and term to estimate the monthly payment and total interest; the schedule itself can then be built from those figures, subject to the loan’s actual terms.
Formula
The calculator uses the standard fixed-payment loan formula. It first calculates a level monthly payment, rounded to the nearest cent, then estimates total interest as all scheduled payments minus the amount borrowed.
- p = amount financed, in dollars.
- apr = annual percentage rate entered as a percentage per year.
- r = monthly interest rate, calculated as apr / 1200.
- n = number of monthly payments, calculated as years × 12.
- pmt = monthly payment, in dollars.
- int = total scheduled interest, in dollars.
In symbols, the payment is pmt = round[p × r / (1 − (1 + r)−n), 2]. Total interest is int = pmt × n − p. This is a calculation of regular, on-time payments under a fixed-rate model. It does not calculate a lender’s complete account ledger or a daily-payoff quote.
Worked Example
Using the defaults—$20,000 financed, 8% APR, and a five-year term:
- Convert the APR to a monthly rate: 8 / 1200 = 0.0066667, or about 0.66667% per month.
- Convert the term to payments: 5 × 12 = 60 months.
- Apply the payment formula: $20,000 × 0.0066667 / [1 − (1.0066667)−60] = about $405.53 per month after rounding to cents.
- Multiply the rounded payment by the number of payments: $405.53 × 60 = $24,331.80.
- Subtract principal: $24,331.80 − $20,000 = $4,331.80 total estimated interest.
The displayed payment and interest are estimates from the stated formula. Calculations made by a lender can differ because of payment dates, rounding, fees, or contract terms.
Assumptions
- The interest rate stays fixed for the entire modeled term.
- Payments are equal, made monthly, and paid at the end of each monthly period.
- Interest is modeled monthly at APR / 12.
- The calculation excludes fees, taxes, insurance, optional products, and other amounts unless they are included in the amount financed.
How an Auto Amortization Schedule Works
An amortization schedule is a month-by-month accounting of a loan’s payment, interest charge, principal reduction, and remaining balance. For a conventional fixed-payment installment loan, interest is charged on the outstanding balance. Early in repayment, that balance is larger, so more of a level payment goes to interest. As principal declines, the interest portion generally shrinks and the principal portion grows.
For example, with the default figures, the first month’s approximate interest is $20,000 × 0.0066667, or $133.33. From the $405.53 payment, about $272.20 reduces principal, leaving a balance near $19,727.80. The next month’s interest is calculated on that lower balance. Small differences in a real schedule can result from the lender’s day-count and rounding methods.
The calculator above gives the regular payment and total interest, not a row for every month. To create a schedule, repeat these steps for each payment period:
- Multiply the opening balance by the periodic interest rate to estimate that month’s interest.
- Subtract the interest from the payment to find the principal reduction.
- Subtract the principal reduction from the opening balance to find the next balance.
A final payment may be adjusted slightly in an actual account to bring the balance to zero. The formula assumes the same rounded payment every month, so its ending balance can differ by a small amount from a servicer’s ledger.
What to Include in the Amount Financed
“Loan amount” means the amount on which interest is calculated—not necessarily the vehicle’s advertised price or the total a buyer pays over the life of the loan. An auto transaction may involve a down payment, trade-in value, taxes, registration costs, fees, or optional products. Whether any of those amounts are included in the financed principal depends on the signed transaction documents.
For a useful estimate, enter the principal actually being financed and obtain the APR and term from the lender’s written figures. Do not treat a quoted vehicle price as the loan amount without accounting for the down payment, trade-in, and any amounts added to financing. The calculator does not determine which charges apply or how a contract defines them.
Reading the Result and Common Mistakes
- APR is entered as a percentage. Enter 8 for 8%, not 0.08. The formula converts the annual percentage to a monthly decimal rate.
- Term is in years. A five-year term becomes 60 monthly payments. If a lender gives a term in months, divide by 12 before entering it.
- Total interest uses the rounded payment. This follows the calculator’s stated convention; rounding each month in a real account can produce a slightly different total.
- Principal is not the same as total payments. The payment total includes both principal and interest. Fees or other financed charges may affect the starting principal.
- Extra payments change the path. Additional principal payments can reduce the balance and interest if applied to principal under the loan’s terms. This calculator does not model them or any payment restrictions.
A longer term generally means more scheduled payment periods, while a lower payment by itself does not show the total borrowing cost. For comparing calculations, hold the principal and APR constant when examining the effect of a different term. The calculator does not account for depreciation, vehicle value, insurance costs, or household budgets.
Limits and Related Questions
This is a mathematical estimate, not a payoff quote, credit decision, or full contract analysis. It assumes a fixed rate, regular monthly timing, and no missed or irregular payments. Variable rates, payment holidays, late charges, fees added after origination, and lender-specific interest conventions are outside the model. For an exact balance on a particular date, request a payoff figure from the lender; accrued interest and account adjustments can make it different from the schedule’s remaining principal.
Frequently Asked Questions
What is an auto loan amortization schedule?
An auto loan amortization schedule lists each planned payment and shows how much is allocated to interest and principal, along with the estimated balance after payment.
Does an amortization schedule show the exact payoff amount?
No. A schedule estimates balances under its assumptions. A payoff quote for a specific date may include interest accrued since the last payment and contract-specific adjustments, so obtain it from the lender.
Why is more of the early payment interest?
Interest is calculated on the outstanding principal. The balance is generally highest at the start, so the interest charge is larger; as principal is repaid, the interest portion falls.
Can I use this calculator for a used-car loan?
Yes, if the loan follows the same basic fixed-rate, equal-monthly-payment structure. Enter the actual amount financed, APR, and term; the calculator does not determine a vehicle’s price or other transaction costs.
Will an extra payment lower total interest?
It can under loan terms that apply the extra amount to principal, because a lower balance can accrue less interest. The timing and handling of extra payments vary, and this calculator does not include them.
The result is an estimate, and the lender’s disclosure gives the exact figures.
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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 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
- Amortization Schedule by Month: Payment and Balance$405.53
- Amortization Schedule by Hand: Formula and Example$405.53
- Amortization Schedule Based on Payment Amount$405.53
- Amortization Schedule Calculator: Payments and Balance$405.53
- Adjustable Rate Amortization Schedule Calculator$405.53
- Amortization Schedule: Annual Payments in Excel$5,009.13