An interest rate amortization schedule shows each loan payment split between interest and principal over the life of the loan, so you can see exactly how much of each payment goes toward interest versus paying down the balance. You enter the loan amount, annual interest rate (APR), and loan term, and the schedule gives you the monthly payment, total interest, and a breakdown of every payment. This page includes a calculator that builds that schedule and explains the math behind it.
Formula
The monthly payment for a fixed-rate loan is calculated using the standard amortization formula:
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 APR ÷ 12 (as a decimal, e.g., 8% APR → 0.08/12 = 0.006667)
- n = total number of payments = loan term in years × 12
The schedule itself is built by applying each payment in two steps: first, the interest owed for the month is calculated as the current balance × r; second, the rest of the payment reduces the principal. The new balance becomes the old balance minus the principal portion, and the process repeats for each month.
Worked Example
Using the calculator defaults: loan amount = $20,000, APR = 8%, term = 5 years.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667.
- Total payments: n = 5 × 12 = 60.
- Plug into the formula: M = 20000 × [0.0066667(1.0066667)^60] / [(1.0066667)^60 – 1].
- (1.0066667)^60 ≈ 1.48985. Numerator: 20000 × 0.0066667 × 1.48985 ≈ 198.65. Denominator: 1.48985 – 1 = 0.48985. M ≈ 198.65 / 0.48985 ≈ 405.53.
- Total paid over 60 months: 405.53 × 60 = $24,331.80.
- Total interest: $24,331.80 – $20,000 = $4,331.80.
So the monthly payment is $405.53, total interest is $4,331.80, and the schedule would show the first payment split as $133.33 interest and $272.20 principal, with the interest portion shrinking each month.
Assumptions
- The interest rate is fixed for the entire term.
- Payments are made at the end of each month (ordinary annuity).
- Interest compounds monthly at APR ÷ 12.
- No fees, taxes, insurance, PMI, or escrow are included.
How to Read an Amortization Schedule
Each row of a schedule represents one payment period. The columns typically show: payment number, payment amount, interest paid, principal paid, and remaining balance. Early in the schedule, interest consumes a large share of the payment; later, the principal share grows. For example, in the $20,000 loan above, the first payment has $133.33 interest and $272.20 principal, while the 60th payment has about $2.68 interest and $402.85 principal.
You can also use the schedule to track how the balance decreases over time, which is useful for estimating how much you still owe at a given point, or for planning extra payments. The total interest column shows the lifetime cost of borrowing at that rate and term.
Common Mistakes and Misconceptions
- Using the APR directly as a monthly rate: Always divide the annual rate by 12. Using 8% as a monthly rate would produce a wildly wrong payment.
- Rounding too early: If you round the monthly payment to the cent before calculating totals, the total interest may differ by a few cents. The calculator rounds the payment first, then multiplies by the number of payments.
- Ignoring the effect of extra payments: Making an extra payment reduces the principal, which shortens the term and reduces total interest, but the standard schedule assumes no extra payments. You can recalculate with a lower balance or shorter term to see the effect.
- Thinking the interest portion is fixed: In a standard amortizing loan, the interest portion decreases each month because it is calculated on the remaining balance, not the original amount.
- Confusing amortization with simple interest: Some loans (like certain credit cards) use daily simple interest, which is different. This schedule applies to installment loans with level payments.
How to Choose a Loan Term
The term of a loan directly affects both the monthly payment and the total interest. A shorter term (e.g., 3 years instead of 5) results in a higher monthly payment but significantly less total interest, because the balance is paid down faster and less time is given for interest to accrue. Conversely, a longer term lowers the monthly payment but increases total interest.
To compare options, you can use the calculator to run different terms with the same loan amount and rate. For example, a $20,000 loan at 8% for 3 years has a monthly payment of about $626.73 and total interest of about $2,562.28, while the 5-year term has a payment of $405.53 and total interest of $4,331.80. The difference in monthly payment is $221.20, but the 5-year loan costs $1,769.52 more in interest.
When to Use This Calculator
Use this calculator when you want to estimate the monthly payment and total interest for a fixed-rate installment loan, such as a car loan, personal loan, or fixed-rate mortgage. It is also helpful for comparing different loan offers by entering the rate and term each lender quotes you.
Keep in mind that this calculator assumes a fixed rate and level payments. If you have a variable-rate loan, an interest-only period, or a balloon payment, the schedule will differ. For those cases, you would need a more complex calculator or a lender’s amortization table.
Frequently Asked Questions
What is the difference between an amortization schedule and a payment schedule?
An amortization schedule is a type of payment schedule that specifically shows the split between interest and principal for each payment. A generic payment schedule might just list payment dates and amounts, but an amortization schedule includes the breakdown of how each payment is allocated, which is essential for understanding how your balance decreases.
How do I calculate the interest portion for a specific month?
Multiply the remaining balance at the start of that month by the monthly interest rate (APR ÷ 12). For example, if your balance is $15,000 and the monthly rate is 0.006667, the interest for that month is $100. The principal portion is then the monthly payment minus that interest amount.
Does making extra payments change the amortization schedule?
Yes. An extra payment directly reduces the principal, which means less interest accrues in subsequent months. The loan may be paid off early, and the total interest will be lower. However, the standard schedule does not show this; you would need to recalculate with the reduced balance or use an extra-payment calculator.
Why does the interest portion decrease over time?
Because interest is calculated on the remaining principal balance. As you make payments, the balance decreases, so the interest charged each month becomes smaller. The payment amount stays the same, so the extra money goes toward reducing the principal, which accelerates the balance decline.
Can I use this calculator for a mortgage with property taxes and insurance?
No. This calculator only covers principal and interest. Property taxes, homeowners insurance, and PMI are separate costs that are often escrowed into the monthly payment. You would need to add those amounts to the principal and interest payment to get the full monthly housing cost.
The result from this calculator is an estimate for educational purposes; the lender’s amortization disclosure provides the exact figures for your specific 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