A loan 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 your loan amount, interest rate, and term, and the schedule shows every payment from the first to the last, including the remaining balance after each one. This page includes a calculator that generates the schedule’s key figures—your monthly payment and total interest—plus a full explanation of how the schedule works.
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 percentage rate (APR) divided by 12, expressed as a decimal (e.g., 8% APR → 0.08/12 = 0.0066667)
- n = total number of monthly payments = loan term in years × 12
The formula assumes a fixed interest rate for the entire term and that payments are made at the end of each month. The total interest is simply the monthly payment times the number of payments, minus the principal.
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 number of payments: n = 5 × 12 = 60
- Compute (1 + r)^n = (1.0066667)^60 ≈ 1.48985
- Compute the numerator: 0.0066667 × 1.48985 ≈ 0.0099323
- Compute the denominator: 1.48985 – 1 = 0.48985
- Divide numerator by denominator: 0.0099323 / 0.48985 ≈ 0.020276
- Multiply by principal: 20000 × 0.020276 ≈ 405.52
So the monthly payment is $405.52 (rounded to the nearest cent). Total paid over 60 months = 405.52 × 60 = $24,331.20. Total interest = 24,331.20 – 20,000 = $4,331.20. These match the calculator’s outputs.
Assumptions
- Fixed interest rate for the entire loan term.
- Payments are made monthly at the end of each period.
- Interest compounds monthly at a rate equal to APR/12.
- The calculation does not include fees, taxes, insurance, PMI, or escrow amounts.
- All payments are made on time and in full; missed or partial payments change the schedule.
How to Read an Amortization Schedule
An amortization schedule lists each payment number, the payment amount, the interest portion, the principal portion, and the remaining balance. Early in the schedule, a large share of each payment goes to interest because the outstanding balance is high. As the balance decreases, the interest portion shrinks and the principal portion grows. For example, in the $20,000 loan above, the first payment’s interest is 20,000 × 0.0066667 = $133.33, so the principal reduction is 405.52 – 133.33 = $272.19. By the last payment, the interest is only a few dollars and almost the entire payment reduces the principal.
You can use the schedule to see how much you still owe at any point, which is useful if you plan to sell the collateral, pay off the loan early, or refinance. The remaining balance after any payment is calculated using the formula: Balance = P(1+r)^k – M[((1+r)^k – 1)/r], where k is the number of payments made.
Common Mistakes and Misconceptions
- Using the APR as a monthly rate: Always divide the annual rate by 12. An 8% APR is 0.6667% per month, not 8% per month.
- Confusing APR with the nominal rate: APR includes certain fees and reflects the true cost, but for the schedule, the monthly rate is still APR/12 as long as the rate is fixed.
- Rounding too early: If you round the monthly payment to the nearest cent before computing total interest, the total may differ by a few cents. The calculator rounds the payment first and uses that rounded value for totals, so it matches the schedule exactly.
- Assuming equal interest and principal splits: The split changes every month; it is not 50/50 except at a specific point in the loan’s life.
- Thinking extra payments reduce future payments: Unless you recast the loan, extra payments reduce the principal and shorten the term, but the required monthly payment stays the same.
Why the Schedule Matters
An amortization schedule gives you a clear picture of how a loan is paid down over time. It helps you see the total interest cost, track your equity in an asset, and understand how much you would save by making extra payments. For example, paying an extra $50 per month on the $20,000 loan at 8% would shorten the term by about 10 months and save roughly $700 in interest—though this varies with the specific loan terms. The schedule also shows the payoff balance at any time, which is the amount you would need to pay to settle the loan early.
How to Use the Calculator
Enter your loan amount, annual interest rate (APR), and loan term in years. The calculator returns the monthly payment and total interest. To see the full schedule, you can use the monthly payment to construct the table manually or use a spreadsheet. Many lenders provide an amortization schedule when you take out a loan, but you can also generate one yourself using the formula for the remaining balance after each payment.
Keep in mind that the calculator assumes a fixed rate and level payments. If you have an adjustable-rate mortgage or a loan with a balloon payment, the schedule will be different. Also, if your loan includes fees that are rolled into the principal, the APR may be higher than the nominal rate, but the payment calculation uses the actual principal and the contractual interest rate.
Frequently Asked Questions
What is the difference between an amortization schedule and a payment schedule?
They are essentially the same thing. An amortization schedule is a payment schedule that breaks down each payment into interest and principal and shows the remaining balance. Some payment schedules might only list the payment amount and due date, but an amortization schedule provides the full breakdown.
How do I calculate the remaining balance after a certain number of payments?
Use the formula: Balance = P(1+r)^k – M[((1+r)^k – 1)/r], where k is the number of payments made. For example, after 12 payments on the $20,000 loan at 8% for 5 years, the balance is approximately $16,612. You can also subtract the total principal paid from the original amount.
Does making extra payments change the amortization schedule?
Yes. An extra payment reduces the principal, which means less interest accrues in future months. The schedule is recalculated; either the term shortens (keeping the same monthly payment) or the payment amount decreases (if the lender recasts the loan). The calculator does not model extra payments, but you can use the formula to estimate the impact.
Why is the interest portion higher at the beginning of the loan?
Because interest is calculated on the outstanding principal, which is largest at the start. As you pay down the principal, the interest charge decreases, allowing more of your payment to go toward principal. This is standard for amortized loans.
What is a negative amortization?
Negative amortization occurs when your payment is less than the interest due, so the unpaid interest is added to the principal, and the balance increases over time. This can happen with certain adjustable-rate mortgages or payment-option loans. It is not modeled by this calculator, which assumes a fully amortizing payment.
Can I use this calculator for a mortgage, auto loan, or personal loan?
Yes, as long as the loan has a fixed interest rate and equal monthly payments. The formula is the same for any amortizing loan. For mortgages, remember that property taxes, insurance, and PMI are not included in the payment calculation.
This calculator provides an estimate for educational purposes. Your lender’s amortization schedule, which includes any fees or adjustments, will give 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