What an amortization schedule shows
An amortization schedule lists every payment over the life of your loan and breaks each one into interest and principal, with the remaining balance after each. It reveals how early payments are mostly interest and later payments mostly principal.
How it's calculated
Each month, interest = balance × (APR ÷ 12). The rest of your fixed payment reduces principal. We repeat until the balance reaches zero, rounding to the cent. Extra and biweekly payments shorten the schedule. Full detail on the methodology page.
When to use it
Use it to understand exactly where your money goes, to see the effect of extra payments, or to verify a lender's figures. To model early payoff specifically, try the payoff calculator.
Common mistakes to avoid
- Confusing the loan amount with the vehicle price — the schedule is built on the financed amount.
- Expecting equal principal each month — principal rises over time as interest falls.
How to read an amortization schedule
Each row in the schedule is one month of the loan. The principal column is the portion of that month's payment that actually pays down the car; the interest column is what the lender keeps as compensation for lending you the money; the balance column is what you still owe after that month's payment is applied. Early rows are heavy on interest because the balance is large; later rows are heavy on principal because the balance has fallen and the same APR is applied to a smaller number. The total of the interest column across every row is the total interest you pay over the life of the loan.
What the schedule reveals that the payment doesn't
Two loans with the same monthly payment can hide very different cost profiles. A loan with a higher APR and a longer term might land at the same monthly payment as a shorter-term loan at a lower APR — but the interest column tells you which one actually costs more. The amortization table is the only honest way to compare two loan offers when only the monthly payment matches, because it strips the deal down to the part that always matters: how much principal you're paying off each month and how much interest you're paying for the privilege.
The schedule also makes the front-loaded nature of auto-loan interest concrete. On a typical $30,000 / 7% / 60-month loan, the first month's payment is roughly $175 interest and $419 principal; the final month's payment is roughly $3 interest and $591 principal. Same dollar amount, completely different split. That's why an extra dollar paid in month 1 reduces all subsequent interest charges, while an extra dollar paid in month 58 only saves a few cents.
Using the schedule for early-payoff planning
Want to pay your loan off by a specific date? Find the row for that month — the balance column tells you the lump-sum payoff at that point (subject to small daily-interest accruals between billing dates). To pay off sooner without a lump sum, the payoff calculator models extra monthly payments, a single lump sum, or a biweekly schedule and regenerates the full amortization table at the accelerated pace.
How the calculator handles rounding
Every row rounds to the cent. We use the standard banker's rounding rule (round to even on a tie) and adjust the final payment up or down by a fraction of a cent so the closing balance is exactly zero — the same convention lenders use. The result is that your real lender's payoff letter should match the calculator within a few cents, with the small remaining difference attributable to daily-interest accrual versus the calculator's monthly model.
Exporting and saving the schedule
The Download CSV button exports the full schedule (period, principal, interest, balance) for any loan. Open it in Excel, Numbers, or Google Sheets to add columns of your own — for example, a running total of interest paid to date, a projected payoff column if you accelerate, or a column for the date each payment is due. Nothing is sent to a server; the CSV is generated client-side from the same calculation that produced the on-screen table.
Frequently asked questions
What is an amortization schedule?+
A table showing every loan payment split into principal and interest, with the running balance. It shows how the loan is paid down over time.
Why is most of my early payment interest?+
Interest is charged on the outstanding balance, which is highest at the start. As the balance falls, the interest portion shrinks and more of each payment goes to principal.
Can I download the schedule?+
Yes. Open the amortization table and use the Download CSV button to save the full schedule for your records or a spreadsheet.
Reviewed for accuracy
Priya Shankar, CFP® — Reviewing Editor
Priya is a CERTIFIED FINANCIAL PLANNER™ who reviews AutoLoanWise content for technical accuracy. She works with consumer borrowers on debt strategy, credit, and large-purchase decisions.
. See our methodology for the formulas behind every result.