Yes, amortization schedules are free to generate on many websites, including this one, and you can also create one yourself in a spreadsheet at no cost. You enter your loan amount, interest rate, and term, and the calculator returns a full payment-by-payment breakdown showing principal, interest, and remaining balance. Below, we explain what an amortization schedule is, how to read one, where to find free tools, and what to watch out for.
Formula
The calculator uses the standard amortization formula for a fixed-rate loan with equal monthly payments:
M = P × (r × (1 + r)^n) / ((1 + r)^n − 1)
- M = monthly payment (in dollars)
- P = principal loan amount (in dollars)
- r = monthly interest rate (annual rate divided by 12, expressed as a decimal)
- n = total number of monthly payments (term in years × 12)
For example, an 8% annual rate becomes r = 0.08 / 12 = 0.0066667. The formula gives the fixed payment that pays off the loan exactly over n months.
Worked Example
Using the default values from the calculator: P = $20,000, APR = 8%, term = 5 years (n = 60 months).
- Monthly rate r = 8 / 1200 = 0.0066667.
- Compute (1 + r)^n = (1.0066667)^60 ≈ 1.4898457.
- Payment M = 20000 × (0.0066667 × 1.4898457) / (1.4898457 − 1) = 20000 × (0.0099323) / 0.4898457 ≈ 20000 × 0.020276 = 405.52.
- Total paid = 405.52 × 60 = $24,331.20.
- Total interest = $24,331.20 − $20,000 = $4,331.20.
The calculator shows a monthly payment of $405.52 and total interest of $4,331.20, matching the manual calculation.
Assumptions
- Fixed interest rate for the entire term.
- Payments are made monthly at the end of each period.
- Interest compounds monthly at APR / 12.
- No fees, taxes, insurance, PMI, or escrow are included.
What Is an Amortization Schedule?
An amortization schedule is a table that lists each loan payment over the life of the loan. For each payment, it shows:
- The payment number (e.g., 1, 2, 3…)
- The total payment amount (fixed for a standard loan)
- How much of that payment goes to interest
- How much goes to principal
- The remaining balance after the payment
Early in the schedule, most of each payment goes to interest because the balance is high. As the balance decreases, the interest portion drops and the principal portion grows. By the final payment, the balance reaches zero.
How to Get a Free Amortization Schedule
There are several ways to obtain one without paying:
- Online calculators – Many financial websites, including this one, offer free amortization calculators. You enter the loan amount, rate, and term, and the tool generates the full schedule instantly.
- Spreadsheet software – Programs like Microsoft Excel or Google Sheets have built-in functions (PMT, PPMT, IPMT) that let you build your own schedule. You can find templates online or create one manually.
- Your lender – When you take out a loan, the lender typically provides an amortization schedule as part of the loan documents. This is usually free and is the most authoritative version for your specific loan.
Be cautious of websites that charge a fee for a basic amortization schedule—there is no reason to pay for something you can get for free. However, some paid services offer additional features like extra payment scenarios or printable reports; those are optional.
How to Read an Amortization Schedule
Reading the schedule is straightforward once you understand the columns. Here’s an example for a $10,000 loan at 6% APR for 3 years (monthly payment ≈ $304.22):
| Payment # | Payment | Interest | Principal | Balance |
|---|---|---|---|---|
| 1 | $304.22 | $50.00 | $254.22 | $9,745.78 |
| 2 | $304.22 | $48.73 | $255.49 | $9,490.29 |
| … | … | … | … | … |
| 36 | $304.22 | $1.51 | $302.71 | $0.00 |
Notice that the interest in payment 1 is $50 (0.5% of $10,000), and it decreases each month. The principal portion increases accordingly. The total interest paid over the life of this loan is about $951.90.
Common Mistakes and Misconceptions
People often make errors when using amortization schedules:
- Ignoring rounding – The payment is rounded to cents, but the schedule may use the unrounded payment internally. This can cause a small discrepancy in the final balance (usually a few cents). Use the rounded payment consistently.
- Using the wrong rate – The APR is an annual rate; you must divide by 12 to get the monthly rate. Using the annual rate directly will produce a wildly incorrect payment.
- Forgetting the term in months – A 5-year loan is 60 months, not 5. Always convert years to months.
- Assuming extra payments are automatically applied – If you make an extra payment, you must tell the lender to apply it to principal, not to the next payment. Otherwise, the schedule won’t reflect the reduced interest.
Alternatives to a Full Schedule
Sometimes you don’t need the entire 360-row table. Here are simpler alternatives:
- Just the monthly payment – Use the PMT formula to get the payment amount without the full breakdown.
- Total interest only – Multiply the payment by the number of months and subtract the principal.
- Payoff date with extra payments – Use a calculator that shows how many months you’ll save by adding a fixed extra amount each month.
- Amortization for a specific year – If you need to know the interest paid in a tax year, you can generate the schedule and sum the interest for those months.
Frequently Asked Questions
Do I have to pay for an amortization schedule?
No. You can get one free from many online calculators, spreadsheet templates, or from your lender. Some software or services may charge for advanced features, but a basic schedule is widely available at no cost.
Can I create my own amortization schedule in Excel?
Yes. Use the PMT function to get the payment, then use IPMT and PPMT functions to calculate interest and principal for each period. You can also use a template from Microsoft’s template gallery or other free sources.
What is the difference between an amortization schedule and a loan statement?
A loan statement shows your current balance and recent transactions. An amortization schedule is a projection of all future payments. The schedule assumes you make every payment on time; your actual statement may differ if you miss payments or make extra payments.
Does an amortization schedule include taxes and insurance?
No, unless the calculator specifically includes them. Standard schedules only cover principal and interest. If you have escrow for property taxes and insurance, those are separate payments and won’t appear in the basic schedule.
Why does the interest portion decrease over time?
Interest is calculated on the remaining balance. As you pay down principal, the balance shrinks, so the interest charged each month decreases. The payment stays the same, so the principal portion grows.
Can I use an amortization schedule to see how extra payments help?
Yes. If you add an extra payment to principal, the balance drops faster, reducing total interest and shortening the loan term. Many calculators let you input an extra monthly amount to see the effect. Just remember to instruct your lender to apply the extra amount to principal.
Remember that this calculator provides an estimate based on the inputs you provide; your lender’s official amortization schedule will reflect the exact terms, fees, and payment dates of 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