A copy of an amortization schedule is a table that lists each loan payment, showing the split between interest and principal, plus the remaining balance after every payment. You can get one from your lender, your online account, or by generating it yourself with a calculator or spreadsheet. This article explains what the schedule contains, how to read it, and the best ways to obtain an accurate copy for any loan.
Formula
The monthly payment for a fixed-rate, fully amortizing loan is calculated with the standard formula:
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.0066667)
- n = total number of payments = loan term in years × 12
To build the full schedule, for each payment k (from 1 to n):
- Interest portion = previous balance × r
- Principal portion = M – interest portion
- New balance = previous balance – principal portion
The last payment may be slightly different due to rounding; lenders adjust it to bring the balance to zero.
Worked Example
Using the default values: loan amount $20,000, APR 8%, term 5 years (60 months).
- Monthly rate r = 8 / 1200 = 0.0066667
- n = 5 × 12 = 60
- Payment = 20000 × [0.0066667 × (1.0066667)^60] / [(1.0066667)^60 – 1]
- (1.0066667)^60 ≈ 1.48985
- Payment = 20000 × [0.0066667 × 1.48985] / [1.48985 – 1] = 20000 × 0.0099323 / 0.48985 ≈ 20000 × 0.020276 = 405.52
The monthly payment is $405.52. Total paid over 60 months = 405.52 × 60 = $24,331.20. Total interest = $24,331.20 – $20,000 = $4,331.20. The first payment’s interest is 20000 × 0.0066667 = $133.33, so the principal portion is 405.52 – 133.33 = $272.19, leaving a balance of $19,727.81. Each subsequent row follows the same pattern.
Assumptions
- Fixed interest rate for the entire term (no rate changes).
- Payments are made at the end of each month, starting one month after the loan origination.
- Interest compounds monthly at the annual rate divided by 12.
- No fees, taxes, insurance, PMI, or escrow amounts are included in the payment calculation.
What an Amortization Schedule Shows
Each row of the schedule typically includes:
- Payment number (1, 2, 3, …)
- Payment date (if the lender provides it)
- Total payment amount (constant for a fixed-rate loan)
- Interest paid in that period
- Principal paid in that period
- Remaining balance after the payment
Early payments are mostly interest; later payments are mostly principal. For example, in the $20,000 loan above, the first payment applies $133.33 to interest and $272.19 to principal. By the 60th payment, interest is only about $2.68 and principal is $402.84.
How to Get a Copy from Your Lender
Most lenders provide amortization schedules in one of these ways:
- Online account: Log in to your loan portal and look for a “Schedule,” “Amortization,” or “Payment Breakdown” tab. You can often download a PDF or export to CSV.
- Request by phone or email: Customer service can mail or email a copy. Some lenders charge a fee for a paper copy, but digital copies are usually free.
- Monthly statements: Your statement shows the current payment’s interest and principal split, but not the full future schedule.
- Loan origination documents: Your initial loan contract often includes a full amortization schedule as an attachment.
If the lender does not provide one, you can create your own using the formula above or a spreadsheet. Many free online calculators (like the one on this page) generate the schedule for any loan amount, rate, and term.
Common Mistakes and Misconceptions
One common mistake is assuming the schedule is accurate for loans with variable rates. If your rate changes, the schedule becomes outdated; you need a new schedule after each rate adjustment. Another misconception is that making extra payments simply shortens the term—in reality, extra payments reduce the principal faster, which reduces total interest, but the monthly payment stays the same unless you recast the loan. Also, some people confuse the amortization schedule with an escrow statement; the schedule only covers principal and interest, not property taxes or insurance.
When creating your own schedule, rounding errors can accumulate. Use full precision in calculations and round only the final displayed values. Also, verify that the final payment brings the balance to exactly zero; if not, adjust the last payment.
Alternatives and When to Use Them
If you need a quick estimate of total interest or payoff date, a simple loan calculator may suffice. For detailed tax planning or to track equity, a full schedule is better. For loans with biweekly payments or extra payments, you may need a more advanced calculator that allows additional payments. For adjustable-rate mortgages, the initial schedule is only a projection; the actual schedule changes with each rate reset.
Frequently Asked Questions
Q: Can I get a copy of my amortization schedule for free?
Most lenders provide digital copies free of charge through their online portals or upon request. Some may charge a small fee for paper copies mailed to you.
Q: Does the amortization schedule include property taxes and insurance?
No, the schedule only shows principal and interest. If your monthly payment includes escrow for taxes and insurance, those amounts are separate and not part of the amortization table.
Q: What if I make extra payments? Does the schedule change?
Yes, extra payments reduce the principal faster, which lowers the interest on subsequent payments. The schedule will be shorter than the original, unless you request a recast to keep the same term with lower payments.
Q: Why does my last payment differ from the others?
Due to rounding, the final payment is adjusted to clear the remaining balance exactly. It is often slightly different (higher or lower) than the regular payment.
Q: Is the amortization schedule the same as a payoff statement?
No. A payoff statement gives the exact amount needed to pay off the loan as of a specific date, including any interest accrued to that date. The schedule shows the planned payments over the full term.
Q: Can I use the schedule to calculate how much interest I’ll save with extra payments?
Yes, by comparing the total interest on the original schedule with a revised schedule that includes extra payments, you can see the savings. Many online calculators do this automatically.
This result is an estimate based on the inputs you provide; your lender’s official disclosure will show 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