How to Read a Loan Amortization Schedule (and Why Early Payments Are Mostly Interest)
What an Amortization Schedule Shows
An amortization schedule lists every payment on a fixed-rate installment loan and splits each one into interest and principal. The payment stays the same every month, but the split changes. Early on, most of the payment covers interest. Near the end, almost all of it reduces the balance. Reading the schedule tells you how fast you are actually building equity, what an early payoff saves, and why refinancing late in a loan rarely helps.
The Monthly Payment Formula
For a fixed-rate loan that is fully paid off over its term:
M = P × r ÷ (1 − (1 + r)^−n)
- P = principal (amount borrowed)
- r = monthly interest rate = annual rate ÷ 12
- n = number of monthly payments
Worked example: $25,000 at 6.9% for 5 years.
- r = 0.069 ÷ 12 = 0.00575
- n = 5 × 12 = 60
- (1.00575)^−60 = 0.70892
- M = 25,000 × 0.00575 ÷ (1 − 0.70892) = 143.75 ÷ 0.29108 = $493.85
Over 60 payments you pay $29,631.08 in total, of which $4,631.08 is interest. This matches what the loan calculator on the QuickToolApp home page returns for the same inputs.
Month by Month: How Each Payment Splits
Each month, interest = remaining balance × r. The rest of the payment reduces the balance. Month 1 interest is 25,000 × 0.00575 = $143.75, so $350.10 goes to principal.
| Month | Payment | Interest | Principal | Balance after |
|---|---|---|---|---|
| 1 | $493.85 | $143.75 | $350.10 | $24,649.90 |
| 2 | $493.85 | $141.74 | $352.11 | $24,297.78 |
| 3 | $493.85 | $139.71 | $354.14 | $23,943.65 |
| 4 | $493.85 | $137.68 | $356.18 | $23,587.47 |
| 5 | $493.85 | $135.63 | $358.22 | $23,229.25 |
| 6 | $493.85 | $133.57 | $360.28 | $22,868.96 |
| ... | ||||
| 55 | $493.85 | $16.70 | $477.15 | $2,427.23 |
| 56 | $493.85 | $13.96 | $479.89 | $1,947.33 |
| 57 | $493.85 | $11.20 | $482.65 | $1,464.68 |
| 58 | $493.85 | $8.42 | $485.43 | $979.25 |
| 59 | $493.85 | $5.63 | $488.22 | $491.03 |
| 60 | $493.85 | $2.82 | $491.03 | $0.00 |
Cents can differ slightly from a lender's schedule because lenders round each month's interest to the cent and adjust the final payment.
Why Interest Front-Loads
Interest is charged on what you still owe, and you owe the most at the start. As principal falls, so does the interest, which leaves more of the fixed payment for principal, which shrinks the balance faster. Grouped by year:
| Year | Interest paid | Principal paid | Share of payments going to interest |
|---|---|---|---|
| 1 | $1,589.57 | $4,336.64 | 27% |
| 2 | $1,280.68 | $4,645.53 | 22% |
| 3 | $949.80 | $4,976.41 | 16% |
| 4 | $595.35 | $5,330.86 | 10% |
| 5 | $215.68 | $5,710.53 | 4% |
On a 5-year loan the effect is moderate. On a 30-year mortgage it is dramatic: at today's rates most of each payment in the first decade can be interest. See the 15-year vs 30-year mortgage guide for those numbers.
Practical consequences: after two years, 40% of the way through the term, you still owe $16,017.81, about 64% of the original balance. That matters if you plan to sell a car early, since vehicles often lose value faster than the balance falls. And paying extra early saves far more than paying extra late.
Effect of an Extra $100 a Month
Paying $593.85 instead of $493.85, with the extra $100 applied to principal from month 1:
| Scenario | Months to pay off | Total interest |
|---|---|---|
| Scheduled payment | 60 | $4,631.08 |
| +$100 per month | 49 (last payment about $202) | $3,706.88 |
| Difference | 11 months sooner | $924.20 saved |
Before doing this, confirm with your lender that extra payments go to principal and that there is no prepayment penalty. Many lenders apply extra money to the next scheduled payment unless you specify otherwise.
APR vs Interest Rate vs Fees
The formula above uses the interest rate. The annual percentage rate (APR) is a broader measure that also folds in certain fees, such as origination or some closing charges. The US Truth in Lending Act requires lenders to disclose it so offers can be compared on the same basis. The Consumer Financial Protection Bureau explains the difference: if two loans have the same interest rate, the one with higher fees has the higher APR.
- Use the interest rate to reproduce the lender's monthly payment and schedule.
- Use the APR to compare total borrowing cost between offers.
- Entering the APR into a payment calculator gives a slightly higher payment than the real one. That is a reasonable conservative estimate, but it will not match the lender's figures to the cent.
For auto loans specifically, the CFPB also explains how amortization affects your loan.
Doing It in QuickToolApp
- Open the QuickToolApp home page and scroll to the Loan Calculator card.
- Enter Loan Amount 25000, Interest 6.9, Term 5 years.
- Press Calculate. You should see Monthly $493.85, Total Interest $4,631.08 and Total Paid $29,631.08.
- To compare terms, change only one input at a time (for example 4 years, then 6) and note each result.
The calculator models principal and interest only, in whole years, and does not show a full schedule or extra payments. Use the formula and method above, or a spreadsheet, for those. Our loan estimate guide covers scenario comparison and costs the calculator leaves out.
FAQ
Why does my statement show a different interest amount than this table?
Many auto loans accrue interest daily (simple interest). Paying a few days late increases that month's interest; paying early reduces it. The monthly table is an approximation of that process.
Does making one extra payment a year help?
Yes. On this loan, one extra $493.85 payment at the end of each year, applied to principal, finishes the loan in 56 months instead of 60 and cuts interest by about $350.
Is a longer term ever better?
A longer term lowers the monthly payment but raises total interest, and it keeps you owing more than the car is worth for longer. It can make sense for cash-flow reasons, but compare total cost, not just the monthly figure.