An amortization schedule is a table that shows each monthly payment on a loan, split into the portion that goes toward interest and the portion that reduces the principal balance. You enter the loan amount, interest rate, and term, and the schedule lists every payment from the first to the last, along with the remaining balance after each one. It answers the practical question: exactly where does my money go each month, and how fast do I actually own more of the asset?
Formula
The monthly payment for a fixed-rate loan is calculated with the standard amortization formula:
M = P × [ r(1 + r)^n ] / [ (1 + r)^n – 1 ]
- M = monthly payment (in dollars)
- P = principal, the original loan amount (in dollars)
- r = monthly interest rate = annual percentage rate (APR) ÷ 12, expressed as a decimal (e.g., 8% APR → 0.08/12 = 0.006666…)
- n = total number of payments = loan term in years × 12
Once you have the payment, each row of the schedule is built recursively:
- Interest for the month = current balance × r
- Principal for the month = M – interest
- New balance = previous balance – principal
The formula assumes the rate is fixed for the whole term and that you make exactly one payment per month on the same day each month.
Worked Example
Using the calculator defaults: loan amount $20,000, APR 8%, term 5 years.
- Monthly rate: r = 8 / 1200 = 0.0066667 (as a decimal, 0.08/12 = 0.0066667)
- Number of payments: n = 5 × 12 = 60
- Payment = 20000 × [0.0066667 × (1.0066667)^60] / [(1.0066667)^60 – 1]
- (1.0066667)^60 ≈ 1.48985
- Numerator: 0.0066667 × 1.48985 ≈ 0.0099323
- Denominator: 1.48985 – 1 = 0.48985
- Payment = 20000 × (0.0099323 / 0.48985) ≈ 20000 × 0.020276 ≈ 405.53
- Total paid = 405.53 × 60 = 24,331.80
- Total interest = 24,331.80 – 20,000 = 4,331.80
The calculator rounds the payment to $405.53 and shows total interest of $4,331.80, matching the example exactly.
Assumptions
- The interest rate is fixed for the entire loan term.
- Payments are made monthly, at the end of each month (standard for most loans).
- Interest compounds monthly at the rate APR ÷ 12.
- The schedule does not include property taxes, insurance, PMI, origination fees, prepayment penalties, or any other charges unless you add them separately.
How to Read an Amortization Schedule
Each row of the schedule has four key numbers: payment number, payment amount, interest portion, principal portion, and remaining balance. In the early months, interest eats up most of the payment. For the $20,000 loan above, the first payment of $405.53 includes $133.33 in interest and only $272.20 in principal. By the 60th payment, interest has dropped to about $2.69 and principal is $402.84. This is called front-loaded interest: you pay more interest early because the balance is highest then. As the balance shrinks, the interest portion shrinks and the principal portion grows.
The schedule also shows the total interest paid over the life of the loan, which is the sum of all the interest rows. For the example, that total is $4,331.80. That number is often surprising because it is about 22% of the original loan amount.
Why the Early Payments Are Mostly Interest
This is the most common source of confusion. People think that if they borrow $20,000 at 8% for 5 years, they should pay off the loan evenly, $333 per month toward principal. But the interest is calculated on the current balance, not the original amount. In month 1, the balance is $20,000, so interest = 20,000 × 0.0066667 = $133.33. That leaves only $272.20 to reduce the balance. In month 2, the balance is $19,727.80, so interest = $131.52, leaving $274.01 in principal. The shift is gradual but steady. By the halfway point (month 30), the balance is about $11,080, and the payment splits roughly $73.87 interest and $331.66 principal.
This structure is not a trick; it is the mathematical consequence of charging interest on the outstanding balance. It means that if you pay extra early in the term, you save a disproportionate amount of interest, because that extra payment eliminates principal that would otherwise generate interest for years.
How to Build Your Own Schedule
You can create a schedule in a spreadsheet with three columns: payment number, interest, principal, balance. Start with the original balance. For each row:
- Interest = balance × (APR/12)
- Principal = monthly payment – interest
- New balance = previous balance – principal
- Repeat until the balance reaches zero (the last payment may be slightly different due to rounding).
For the example, the first row would be: payment 1, interest $133.33, principal $272.20, balance $19,727.80. The last row (payment 60) will have a balance of $0.00 after rounding. If you want to see the effect of extra payments, add an extra principal amount to any row and recalculate the remaining rows with the lower balance.
Common Mistakes and Misconceptions
- Using the APR as the monthly rate. Always divide by 12. An 8% APR is not 8% per month; it is about 0.667% per month.
- Forgetting to round the payment to cents. The formula gives a long decimal; your lender charges a specific cent amount. Always round to two decimals and use that rounded number for the schedule.
- Assuming the interest is simple. Most loans compound monthly, so the interest in each period is based on the remaining balance, not the original principal.
- Thinking the total interest is just rate × principal × years. That would be $20,000 × 0.08 × 5 = $8,000, but because you pay down the principal, the actual interest is much lower ($4,331.80).
- Ignoring the effect of extra payments. A single extra payment of $500 in month 1 would reduce total interest by more than $500 × 0.08 × 5, because it shortens the term and reduces the balance for all subsequent months.
Why the Schedule Matters for Your Decisions
An amortization schedule lets you compare loans with different rates and terms. A longer term lowers the monthly payment but increases total interest. For example, the same $20,000 at 8% for 10 years has a payment of $242.66 and total interest of $9,119.22. The 5-year loan costs $405.53 per month but only $4,331.80 in interest. The schedule makes this trade-off visible.
It also helps you understand the impact of extra payments. If you add $50 to each monthly payment on the 5-year loan, you would pay off the loan in about 54 months instead of 60, and save roughly $300 in interest. The exact numbers depend on when you make the extra payment; making it early has a bigger effect.
Limits of the Standard Schedule
The classic amortization schedule assumes a fixed rate and equal payments. It does not apply directly to adjustable-rate mortgages (ARMs), where the rate changes after an initial period, or to interest-only loans, where you pay only interest for a set number of years. For those, you need a schedule that recalculates the payment when the rate changes. The schedule also assumes you never miss a payment and that the payment is made on the exact due date. Late fees or a grace period can shift the interest calculation slightly. Finally, the schedule does not include any fees or insurance that might be part of your actual monthly obligation; those are separate costs.
Frequently Asked Questions
How do I calculate the monthly payment without a calculator?
You can use the formula M = P × [r(1+r)^n] / [(1+r)^n – 1]. For a $20,000 loan at 8% for 5 years, r = 0.0066667, n = 60, and (1+r)^n = 1.48985. Then M = 20000 × [0.0066667 × 1.48985] / [1.48985 – 1] = 20000 × 0.0099323 / 0.48985 = 405.53. You need a scientific calculator for the exponent, but the arithmetic is straightforward.
What does “amortization” actually mean?
Amortization comes from the Latin word for “to die” or “to kill off.” In finance, it means gradually paying off a debt over time through scheduled payments. Each payment reduces the principal, and the loan is “killed off” by the end of the term.
Why does the interest portion decrease over time?
Because interest is calculated on the remaining balance. Early on, the balance is large, so the interest is high. As you pay down principal, the balance shrinks, so the interest charged on that smaller balance is lower. The payment stays the same, so the extra money goes toward principal.
Can I use an amortization schedule for a credit card?
Not directly. Credit cards usually have a minimum payment that changes as the balance changes, and the interest rate can vary. An amortization schedule works best for fixed-rate, fixed-term loans like mortgages, auto loans, and personal loans. For credit cards, you need a different calculation that accounts for the minimum payment and daily compounding.
What happens if I make an extra payment?
An extra payment reduces the principal balance immediately. That means the next month’s interest is calculated on a smaller balance, so more of your regular payment goes to principal. The loan is paid off sooner, and the total interest paid is lower. You can see this by recalculating the schedule with the lower balance.
Is the total interest the same as the APR times the loan amount?
No. The APR is an annual rate, but you are paying down the principal over time. The total interest is the sum of the interest portions of each payment, which is always less than the simple product of rate, principal, and term. For a 5-year, $20,000 loan at 8%, simple interest would be $8,000, but the actual total interest is $4,331.80.
The result from this calculator is an estimate based on the inputs you provide. Your lender’s official disclosure will show the exact payment and total interest, including any fees or adjustments.
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