What Is an Amortization Table? A Complete Guide
An amortization table is a structured schedule that shows how a fixed, periodic payment is allocated between interest and principal over the life of a loan. It is a practical map of repayment: each row represents one period (often a month), and the columns track payment amount, interest cost for that period, principal repaid, and the remaining balance.
Lenders rely on amortization tables to compute payments and disclose terms; borrowers use them to understand the true cost of borrowing, plan budgets, and assess the impact of extra payments. In short, the table transforms abstract loan terms into a transparent, step-by-step payoff plan.
Definition and Core Idea
In consumer finance, amortization refers to the gradual reduction of a debt through regular, level payments that cover both interest and principal. An amortization table, sometimes called an “amortization schedule,” lays out this reduction period by period.
Although the payment size is typically constant for fixed-rate loans, the composition changes: at the beginning, more of the payment goes to interest and less to principal; later, as the balance shrinks, interest falls and principal repayment accelerates.
Where You Will See Amortization Tables
Amortization tables are standard for installment loans: mortgages, auto loans, personal loans, and student loans (when on fixed repayment plans). Adjustable-rate mortgages (ARMs) may produce multiple tables as the interest rate resets.
Some loans, such as interest-only or balloon loans, do not fully amortize across the payment term; in those cases the table clarifies when principal is (or is not) being repaid and what remains due at maturity.
The Mathematics of Amortization
At the center is the fixed payment formula. For a loan with present value PV, periodic interest rate r (for example, monthly rate), and number of periods n, the payment P that fully amortizes the loan is:
P = r × PV ÷ (1 − (1 + r)−n)
Each period, interest equals the current balance times r. The principal portion is whatever remains of P after covering that interest:
Interestt = Balancet−1 × r
Principalt = P − Interestt
Balancet = Balancet−1 − Principalt
This logic is exactly what the amortization table lists for every period until the balance reaches zero (subject to rounding adjustments in the final payment).
What the Table Typically Includes
Though formats vary slightly, most tables display these columns:
- Period: the payment number (e.g., 1 to 360 for a 30-year monthly mortgage).
- Payment: the fixed periodic amount due.
- Interest: the interest charged for the period based on the outstanding balance.
- Principal: the portion of the payment that reduces the balance.
- Ending Balance: the remaining loan balance after the payment.
A well-constructed table may also include running totals for interest and principal so you can see cumulative costs at any point in time.
Reading the Table: A Short Example
Suppose a borrower takes a $1,000 loan at a 12% annual rate with monthly payments over 12 months. The monthly rate is 1% (0.01). Using the formula above, the monthly payment is approximately $88.85. The early payments are interest-heavy; by the end, nearly all of the payment goes to principal. The first three rows look like this (rounded to cents):
| Period | Payment ($) | Interest ($) | Principal ($) | Ending Balance ($) |
|---|---|---|---|---|
| 1 | 88.85 | 10.00 | 78.85 | 921.15 |
| 2 | 88.85 | 9.21 | 79.64 | 841.51 |
| 3 | 88.85 | 8.42 | 80.43 | 761.08 |
This pattern continues until the balance reaches zero. Notice that the payment remains $88.85 each month, but interest steadily declines and principal steadily increases. A full table would show all 12 periods, cumulative interest, and a final minor rounding adjustment if necessary.
Fixed-Rate, Adjustable-Rate, and Other Variations
Fixed-rate loans use a single payment amount computed from one interest rate and one amortization term, so the table is straightforward and predictable. Adjustable-rate loans periodically reset the rate; each reset point produces a new payment calculation and a new segment of the amortization table. Some products involve negative amortization, where payments are temporarily smaller than the accrued interest; the table will reveal a rising balance and highlight the eventual payment increase required to amortize the debt. Finally, biweekly payment plans apply half-payments every two weeks; this results in the equivalent of one extra full payment per year, shortening the schedule and reducing total interest, and the table (or a calculator) should be configured for 26 periods per year to model it accurately.
How Extra Payments Change the Table
Extra principal payments are a powerful way to shorten the life of a loan and reduce interest cost. In an amortization table, you would record an additional line item for “extra principal” in any chosen period, then recompute the subsequent interest charges based on the lower balance. The periodic payment on a fixed-rate mortgage usually stays the same unless you recast the loan; as a result, more of each subsequent payment goes to principal and the loan pays off earlier. The table quantifies this benefit precisely, period by period.
Building an Amortization Table in a Spreadsheet
You can construct one quickly in Excel or Google Sheets:
Inputs: loan amount (PV), annual interest rate, term in years, and payments per year (for monthly, use 12). Compute the periodic rate with =AnnualRate/PaymentsPerYear and the number of periods with =Years*PaymentsPerYear. Compute the payment with =PMT(PeriodicRate, Periods, -PV) (the negative sign returns a positive payment).
Row setup: In row 1, set Beginning Balance to PV. For each row t: Interest = Beginning Balance × PeriodicRate; Principal = Payment − Interest; Ending Balance = Beginning Balance − Principal. Copy these formulas down for all periods. Optionally add Cumulative Interest = previous Cumulative Interest + current Interest, and Cumulative Principal = previous + current.
Checks: The Ending Balance of the final row should be near zero (small residuals occur due to rounding). If your last row shows a few cents, adjust the final principal cell to bring the balance exactly to zero.
Why Amortization Tables Matter
For borrowers, the table provides clarity. It answers practical questions: How much interest do I pay in the first year? What happens if I add $50 per month? When will I break even if I plan to sell or refinance? For lenders and accountants, the table supplies a transparent basis for interest revenue recognition and payoff calculations. In personal financial planning, it is a cornerstone tool for comparing loan options and aligning debt service with cash flow.
Common Pitfalls and How to Avoid Them
Confusing APR and periodic rate. Annual Percentage Rate (APR) can include certain costs and is not always the same as the nominal rate used to compute payments. Always convert the nominal annual rate to a periodic rate for calculations.
Ignoring compounding frequency. If payments are monthly, use a monthly rate; if biweekly, use a biweekly rate. Mixing frequencies yields incorrect results.
Rounding too early. Round for display, not for calculation. Keep full precision in the formulas to prevent drift across many periods.
Assuming all loans amortize. Interest-only, balloon, and some lines of credit do not reduce principal in the same way. Verify your loan type before relying on a standard schedule.
Amortization Tables vs. Accounting Amortization
In lending, amortization describes paying down debt. In accounting, amortization describes expensing the cost of an intangible asset (such as a patent) over its useful life. The spreadsheet mechanics look similar—cost allocated across periods—but the purpose differs: one tracks a declining loan balance; the other allocates an asset’s cost against revenue. When people say “amortization table,” they almost always mean the loan version described in this guide.
Frequently Asked Questions
Is an “amortization table” the same thing as an “amortization schedule”?
Yes. In consumer finance, the terms are used interchangeably to describe the period-by-period breakdown of payments into interest and principal with the remaining balance shown after each payment.
How do I convert an annual interest rate to the periodic rate for my table?
Divide the nominal annual rate by the number of payments per year. For example, a 6% annual rate with monthly payments uses a monthly rate of 0.06 ÷ 12 = 0.005 (0.5%).
What happens if I make extra principal payments—do I need a new table?
You can add an “extra principal” column and recompute subsequent rows using the reduced balance. Unless your lender recasts the loan to lower the scheduled payment, the benefit shows up as earlier payoff and lower total interest.
Why do early payments feel “interest-heavy” even though the payment never changes?
Interest is calculated on the outstanding balance, which is largest at the start. As the balance shrinks, interest per period declines and more of the fixed payment is freed to reduce principal.
Can I use an amortization table for a loan with changing interest rates?
Yes, but you will need to segment the schedule at each reset. Recalculate the payment using the new rate and remaining term, then continue the table from that point forward.
Do all loans amortize completely to zero by the final payment?
No. Interest-only loans, balloon loans, and negative-amortization products do not reduce principal in a standard way. An amortization table will make that clear by showing minimal or no principal reduction during certain periods and any large balance due at maturity.
Bottom line: an amortization table is the clearest way to see how a loan is paid off. It translates rates and terms into a concrete schedule you can plan around, stress-test with extra payments, and use to compare alternatives confidently.
What is the main purpose of an amortization table?
An amortization table helps borrowers see how each payment is divided between interest and principal. It also shows the remaining balance after each payment, making it easier to understand the total cost of borrowing.
Why do early payments in an amortization table go mostly toward interest?
Because interest is charged on the outstanding balance, the loan costs more to finance at the beginning when the balance is largest. As the balance decreases, the interest portion shrinks and more of each payment goes toward principal.
Can extra payments change the amortization schedule?
Yes, making extra payments reduces the outstanding balance faster, which lowers the interest charged in future periods. This shortens the loan term and saves money on total interest paid.
Are amortization tables only for mortgages?
No, they can be used for any installment loan such as auto loans, personal loans, or student loans. Any loan with fixed payments over time can be represented with an amortization table.
How can I create an amortization table on my own?
You can use spreadsheet software like Excel or Google Sheets by applying the PMT formula and calculating principal and interest for each period. Many free online calculators also generate tables automatically with just the loan details entered.
Contents