An amortization schedule is a table that shows each loan payment, split into the interest portion and the principal portion, along with the remaining balance after each payment. You run one by calculating the periodic payment using the loan amount, interest rate, and term, then applying that payment to the loan balance month by month. The result is a full breakdown of every payment from the first to the last, which is useful for understanding how much interest you pay and how your balance declines over time.
Formula
The standard amortization formula for a fixed-rate loan is:
M = P × [ r(1 + r)^n ] / [ (1 + r)^n − 1 ]
Where:
- M = monthly payment (in dollars)
- P = principal loan amount (in dollars)
- r = monthly interest rate = annual rate / 12 (as a decimal, e.g., 8% / 12 = 0.006667)
- n = total number of payments = term in years × 12
To build the schedule, for each payment period k (from 1 to n):
- Interest for period k = previous balance × r
- Principal for period k = M − interest
- New balance = previous balance − principal
The formula assumes a fixed interest rate and equal monthly payments. The loan is fully paid off after the last payment, leaving a balance of zero (or a small rounding difference).
Worked Example
Using the default values from the calculator: P = $20,000, APR = 8%, term = 5 years.
- Monthly rate r = 8 / 1200 = 0.0066667
- Number of payments n = 5 × 12 = 60
- Monthly payment M = 20000 × [0.0066667 × (1.0066667)^60] / [(1.0066667)^60 − 1]
- (1.0066667)^60 = 1.48985 (approximately)
- M = 20000 × [0.0066667 × 1.48985] / [1.48985 − 1] = 20000 × [0.009932] / [0.48985] = 20000 × 0.020276 = 405.52
- Monthly payment = $405.52 (rounded to the nearest cent)
- Total paid = 60 × 405.52 = $24,331.20
- Total interest = 24,331.20 − 20,000 = $4,331.20
The first payment: interest = 20000 × 0.0066667 = $133.33, principal = 405.52 − 133.33 = $272.19, new balance = 20000 − 272.19 = $19,727.81. The last payment reduces the balance to zero.
Assumptions
- Fixed interest rate for the entire term (no rate changes).
- Payments are made at the end of each month (standard for most loans).
- Interest compounds monthly at APR / 12.
- The schedule does not include fees, taxes, insurance, PMI, or escrow amounts; those are separate costs.
- The payment is rounded to the cent, which can cause the final balance to be a few cents off unless adjusted.
How to Build an Amortization Schedule Yourself
You can run an amortization schedule with a spreadsheet or by hand. Here are the steps:
- Calculate the monthly payment using the formula above.
- Start with the original loan balance.
- For each payment period, compute interest = balance × monthly rate.
- Compute principal = payment − interest.
- Subtract principal from the balance to get the new balance.
- Repeat for each period until the balance reaches zero.
In a spreadsheet, you can set up columns for Payment Number, Payment, Interest, Principal, and Balance. Use a formula that references the previous balance. For example, in Excel, if the balance is in cell B2, the interest in C2 would be =B2*$B$1 (where $B$1 holds the monthly rate). Then principal = payment − interest, and new balance = previous balance − principal. Drag the rows down for all periods.
Reading the Schedule: Key Insights
An amortization schedule reveals several patterns:
- Early payments are mostly interest. In the example, the first payment has $133.33 interest and only $272.19 principal. By the last payment, interest is about $2.68 and principal is $402.84.
- Total interest is significant. Over 5 years at 8%, you pay $4,331.20 in interest on a $20,000 loan. That is over 21% of the principal.
- Balance declines slowly at first. After 30 payments (halfway through the term), the balance is still about $11,000, not $10,000, because more interest is paid upfront.
- Extra payments reduce total interest. If you pay an extra $50 per month, you shorten the term and save interest. The schedule lets you see the effect by recalculating with a lower balance.
Common Mistakes When Running a Schedule
- Using the annual rate instead of the monthly rate. Always divide by 12. For 8% APR, the monthly rate is 0.006667, not 0.08.
- Forgetting to convert the term to months. A 5-year loan has 60 payments, not 5.
- Rounding too early. If you round the payment to $405.52 but use $405.52 in every row, the final balance may be off by a few cents. That is fine; you can adjust the last payment.
- Ignoring payment date. If payments are made at the beginning of the month instead of the end, the schedule changes slightly. Most loans use end-of-month payments.
- Using a simple interest formula. Some loans use simple interest (interest = principal × rate × time), but amortized loans use compound interest on the declining balance.
Why Use an Amortization Schedule?
An amortization schedule helps you see the true cost of a loan. It answers questions like:
- How much interest will I pay over the life of the loan?
- What is my balance after 3 years if I want to sell the house or refinance?
- How much of my payment goes to principal vs. interest each month?
- How much will I save if I make extra payments?
It is also essential for accounting: for mortgages, the interest portion is tax-deductible in many places (check your local rules), and the schedule tells you exactly how much interest you paid each year.
Amortization vs. Other Payment Methods
Not all loans are amortized. Some alternatives:
- Interest-only loans: You pay only interest for a period, then payments jump to include principal. The balance does not decrease during the interest-only phase.
- Balloon loans: You make small payments for a while, then a huge final payment (the balloon) covers the remaining principal.
- Simple interest loans: Interest is calculated daily on the outstanding balance, so paying early reduces interest more quickly. Auto loans often use this method.
- Negative amortization: Your payment is less than the interest charged, so the balance grows. This is rare and often risky.
For a standard fixed-rate mortgage or personal loan, amortization is the norm. The schedule gives you a clear, predictable path to full repayment.
Frequently Asked Questions
What is the difference between an amortization schedule and a loan payment calculator?
A loan payment calculator typically just gives you the monthly payment and total interest. An amortization schedule goes further, showing every payment broken down into interest and principal, plus the remaining balance after each payment. It is like a detailed map of the loan.
Can I use an amortization schedule for a variable-rate loan?
Not directly. The standard schedule assumes a fixed rate. For a variable-rate loan, you would need to recalculate the payment each time the rate changes, which produces a new schedule. Some lenders provide a schedule based on the current rate, but it is only an estimate for the full term.
How do extra payments affect the amortization schedule?
Extra payments reduce the principal balance faster, which lowers the interest charged on subsequent months. You can either keep the same payment amount and shorten the term, or recalculate a lower payment for the remaining term. Either way, total interest decreases. To see the effect, you would run a new schedule with the lower balance.
Why does my amortization schedule show a small balance at the end?
This happens because the payment is rounded to the nearest cent. For example, the exact payment might be $405.528, but you pay $405.53. Over 60 payments, the overpayment causes the balance to reach zero before the last payment, or the last payment is slightly less. Lenders adjust the final payment to exactly zero.
Is the amortization schedule the same as a mortgage statement?
No. A mortgage statement shows your current balance, payment due, and escrow details. An amortization schedule is a projection of future payments. The actual balance may differ if you make extra payments, miss payments, or have escrow adjustments. The schedule is a planning tool, not a billing document.
The result from any amortization calculator is an estimate; your lender’s disclosure provides the exact figures for your loan.
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 | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 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
- Personal Loans Interest Free? The Real Answer$405.53
- Personal Loan 0% Interest: Is It Real?$405.53
- Personal Loan Zero Interest: Is It Real?$405.53
- Only Loans LLC: What It Is and How It Works$405.53
- Personal Loan and Interest Only Option?$133.33
- No Interest Personal Loan? What It Really Means$405.53