This calculator instantly creates an amortization schedule for a fixed-rate loan. You enter the loan amount, annual interest rate (APR), and loan term in years, and it returns your monthly payment, total interest, and a full breakdown of principal and interest for each payment. The schedule shows how each payment is split and how the balance declines over time.
Formula
The standard amortization formula calculates a level monthly payment that fully repays the loan over the term. The payment is constant, but the split between interest and principal changes each month. The formula is:
Monthly Payment = P × (r × (1 + r)^n) / ((1 + r)^n – 1)
Where:
- P = loan principal (the amount borrowed, in dollars)
- r = monthly interest rate = annual rate / 12 (as a decimal, e.g., 8% / 12 = 0.006667)
- n = total number of monthly payments = loan term in years × 12
The total interest is simply the monthly payment times the number of payments, minus the principal: Total Interest = (Payment × n) – P.
To build the schedule, for each payment k (from 1 to n):
- Interest portion = current balance × r
- Principal portion = monthly payment – interest portion
- New balance = previous balance – principal portion
After the final payment, the balance should be $0.00 (rounding may leave a few cents).
Worked Example
Using the default values: 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
- Compute the payment factor: (1 + r)^n = (1.0066667)^60 ≈ 1.4898457
- Payment = 20000 × (0.0066667 × 1.4898457) / (1.4898457 – 1) = 20000 × (0.0099323) / 0.4898457 ≈ 20000 × 0.020276 = 405.52
- Monthly payment = $405.52 (rounded to cents)
- Total paid = 405.52 × 60 = $24,331.20
- Total interest = 24,331.20 – 20,000 = $4,331.20
The calculator’s formula gives the same result: monthly payment $405.52 and total interest $4,331.20.
Assumptions
- The interest rate is fixed for the entire loan term.
- Payments are made at the end of each month (ordinary annuity).
- Interest compounds monthly at the rate APR / 12.
- The payment is rounded to the nearest cent, and the final payment may differ by a few cents to clear the balance.
- This calculation does not include fees, taxes, insurance, PMI, or escrow amounts. Those would add to your actual monthly obligation.
How to Read the Amortization Schedule
An amortization schedule is a table with one row per payment. Each row shows the payment number, the payment amount, the interest portion, the principal portion, and the remaining balance. Early in the schedule, the interest portion is high and the principal portion is low. As the balance decreases, the interest portion shrinks and the principal portion grows. By the end of the term, almost the entire payment goes toward principal.
For example, in the $20,000 loan above, the first payment of $405.52 includes about $133.33 in interest and $272.19 in principal, leaving a balance of $19,727.81. By the 60th payment, the interest is only about $2.68 and the principal is $402.84.
You can use the schedule to see how much interest you pay in any given year, or to plan extra payments that reduce the principal faster.
Common Mistakes and Pitfalls
- Using the annual rate as the monthly rate. Always divide the APR by 12. Using 8% instead of 0.6667% per month will massively overstate the payment.
- Mixing up the number of payments. A 5-year loan has 60 monthly payments, not 5. Always multiply years by 12.
- Rounding too early. Round the payment to cents, but keep the interest rate unrounded in calculations to avoid a final balance that doesn’t zero out.
- Ignoring payment timing. This formula assumes payments at the end of each month. If payments are made at the beginning, the schedule changes slightly.
- Forgetting that the payment is fixed. In a fixed-rate amortized loan, the payment amount doesn’t change; only the split changes.
When to Use a Quick Amortization Schedule
Use this tool when you need a fast estimate of monthly payments and total interest for a fixed-rate loan. It’s useful for comparing loan offers (by entering different rates or terms), for budgeting, or for understanding how much of your early payments goes to interest. The schedule also helps you see the effect of extra payments: if you pay an extra $50 per month, you can see how much earlier the loan is paid off and how much interest you save.
However, this calculator is for simple, fixed-rate loans. It does not model adjustable-rate mortgages (ARMs), interest-only loans, balloon payments, or loans with fees rolled into the principal. For those, you need a more specialized tool.
Alternatives and Variations
Different situations call for different amortization methods:
- Extra payments: If you plan to make extra principal payments, you can adjust the schedule by recalculating the balance after each extra payment. Many calculators have a dedicated extra payment field.
- Biweekly payments: Paying half the monthly payment every two weeks results in 26 half-payments per year (equivalent to 13 full payments), which shortens the term and reduces interest.
- Interest-only loans: For a period, you pay only interest, then the payment jumps to amortize the principal over the remaining term.
- Adjustable-rate loans: The rate changes at specified intervals, so the payment recalculates each time. You’d need a schedule that uses different rates for different periods.
Frequently Asked Questions
How do I create an amortization schedule in Excel?
In Excel, list payment numbers 1 to n in column A. In column B, enter the payment amount (use the PMT function: =PMT(rate, nper, -principal)). For interest, use =balance * rate; for principal, =payment – interest; for new balance, =previous balance – principal. Drag the formulas down. The final balance should be near zero.
What is the difference between amortization and simple interest?
Simple interest is calculated only on the original principal, so the interest amount is constant each period. Amortization calculates interest on the remaining balance, so the interest amount decreases over time. Most consumer loans (mortgages, auto loans) use amortization, not simple interest.
Why is my calculated payment different from the lender’s quote?
Lenders often include fees, points, or mortgage insurance in the payment, or they may round differently. Also, the exact day your loan funds can affect the first payment. This calculator gives the pure principal and interest payment; the lender’s disclosure will show the full amount.
Can I pay off a loan early without penalty?
That depends on your loan agreement. Some loans have prepayment penalties, while others allow extra payments without penalty. Check your contract or ask your lender. The amortization schedule can show you how much interest you’d save by paying extra.
What happens if I make an extra payment?
If you make an extra payment and specify it goes to principal, the balance drops immediately. This reduces the interest charged in subsequent months, and the loan may be paid off earlier than the original term. The payment amount stays the same, but the number of payments decreases.
How do I calculate the total interest if I make extra payments?
You need to recalculate the schedule with the extra payments. Each time you add an extra principal payment, the balance decreases, so the interest for that month and all future months is lower. The total interest is the sum of all interest portions in the adjusted schedule.
This result is an estimate based on the inputs you provide; your lender’s official disclosure 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
- Secured Loan with Savings Account: How It Works$405.53
- Secured Loan Servicing: How It Works & What to Know$405.53
- Secured Loan With a Car Title? How It Works$405.53
- Secured Loan Interest Rates: How They Work$405.53
- Secured Loan Requirements: What Lenders Check$405.53
- Secured Loan Home Improvement: How It Works$405.53