An amortization schedule by monthly payment shows every payment over the life of a loan, broken into the portion that goes toward interest and the portion that reduces the principal balance. You enter the loan amount, annual interest rate (APR), and the loan term in years, and the calculator below produces the full schedule, including the monthly payment, total interest, and the remaining balance after each payment.
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]
Where:
- M = monthly payment (in dollars)
- P = principal loan amount (in dollars)
- r = monthly interest rate = annual 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
For each payment, the interest portion is calculated as the current balance multiplied by the monthly rate. The principal portion is the payment minus the interest. The balance is then reduced by the principal portion, and the process repeats for each month.
Worked Example
Using the default values from the calculator: P = $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: 0.0099323 / 0.48985 ≈ 0.020276
- Multiply by principal: 20000 × 0.020276 ≈ 405.52
The monthly payment is $405.52 (rounded to the cent). The total paid over 60 months is 60 × 405.52 = $24,331.20. The total interest is $24,331.20 – $20,000 = $4,331.20, which matches the calculator output.
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 the rate APR/12.
- The payment amount is rounded to the nearest cent; the final payment may differ slightly to account for rounding.
- This calculation does not include fees, taxes, insurance, PMI, or escrow amounts, unless you add them to the loan amount or payment manually.
How to Read an Amortization Schedule
An amortization schedule is a table with columns for payment number, payment amount, interest paid, principal paid, and remaining balance. Early in the schedule, a large share of each payment goes to interest because the balance is highest. As the balance decreases, the interest portion shrinks and the principal portion grows. For example, with the default $20,000 loan at 8% for 5 years, 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 a few dollars and the principal portion is nearly the full payment.
To build the schedule yourself, start with the initial balance. For each month, multiply the balance by the monthly rate to get the interest. Subtract that from the fixed payment to get the principal paid. Subtract the principal from the balance to get the new balance. Repeat until the balance reaches zero.
Using the Calculator for Different Scenarios
This calculator is useful for any fixed-rate loan: auto loans, personal loans, student loans, or mortgages. Simply enter the loan amount, the annual interest rate (APR) you expect or have been quoted, and the term in years. The calculator instantly gives you the monthly payment and total interest. You can adjust the inputs to compare different terms or down payments. For example, a longer term reduces the monthly payment but increases total interest. A shorter term does the opposite. The calculator helps you see that trade-off clearly.
To see the full amortization schedule, you can use the formula above to create a spreadsheet or use an online schedule generator. The calculator here gives you the key numbers, but the schedule itself shows the balance at any point, which is helpful if you plan to sell the asset or refinance before the term ends.
Common Mistakes and Misconceptions
- Using the annual rate instead of the monthly rate. Always divide the APR by 12 before applying the formula. Using 8% instead of 0.6667% will massively overstate the payment.
- Confusing APR with the nominal rate. APR includes certain fees and costs, so it may be slightly higher than the simple interest rate. Use the APR you are actually quoted for the most accurate payment estimate.
- Forgetting to round the payment. The formula gives a precise value, but lenders round to the nearest cent. This can cause a small difference in the final payment or total interest.
- Thinking the interest is simple interest. Amortized loans use compound interest in the sense that interest is calculated on the remaining balance, which includes unpaid interest from prior periods. However, because you pay off the interest each month, you never pay interest on interest if you make payments on time.
- Assuming the payment covers taxes and insurance. For mortgages, the payment often includes escrow, but the formula here only covers principal and interest.
Limitations of the Formula
The formula assumes a fixed interest rate for the entire term and level payments. It does not work for adjustable-rate mortgages, interest-only loans, or loans with balloon payments. For those, the payment changes over time or the principal is not fully amortized. Also, the formula does not account for extra payments. If you make additional principal payments, the loan will be paid off early and the total interest will be lower than shown. To model extra payments, you would need to recalculate the schedule each time you make an extra payment.
The calculator also assumes payments are made exactly on time every month. Late payments can incur fees and change the interest calculation. Finally, the result is an estimate; the exact figures, including any fees or prepayment penalties, are provided in the lender’s loan disclosure.
Frequently Asked Questions
How do I calculate the amortization schedule myself?
Start with the loan balance. For each month, multiply the balance by the monthly interest rate (APR/12) to get the interest for that month. Subtract that interest from your fixed monthly payment to get the principal portion. Subtract the principal portion from the balance to get the new balance. Repeat for each month until the balance reaches zero. You can do this in a spreadsheet with a formula like =PPMT(rate, period, nper, pv) or =IPMT().
What happens if I make an extra payment?
An extra payment goes directly toward the principal, reducing the balance faster. This shortens the loan term and reduces the total interest. For example, on a $20,000 loan at 8% for 5 years, adding $100 to the first payment would reduce the balance by an extra $100, saving interest on that amount for the remaining months. The exact savings depend on when you make the extra payment.
Why does the interest portion change every month?
Interest is calculated on the current outstanding balance. As you pay down the principal, the balance decreases, so the interest for the next month is lower. That means more of your fixed payment goes toward principal each month. This is why the interest portion declines over time.
Can I use this calculator for a mortgage?
Yes, but remember that the payment shown is only principal and interest. Your actual mortgage payment may also include property taxes, homeowners insurance, and possibly PMI if your down payment is less than 20%. Those amounts are not included in this calculation. Enter the loan amount (not the home price) and the annual interest rate to get the principal and interest portion.
What is the difference between APR and the interest rate?
The interest rate is the cost of borrowing the principal, expressed as a percentage. The APR (annual percentage rate) includes the interest rate plus certain fees and costs, such as origination fees or closing costs, spread over the loan term. For the most accurate payment estimate, use the APR because it reflects the true cost of the loan.
Does the formula work for loans with a term in months?
Yes. If your loan term is given in months, you can use that number directly for n. For example, a 60-month auto loan has n = 60. The calculator above uses years, but you can enter a fractional year (e.g., 5 for 60 months). The formula is the same.
The result from this calculator is an estimate; the lender’s disclosure provides 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
- Federal Schedule B: What It Is & How to Use It$405.53
- Federal Form Schedule C Part V: What It Is$45,000.00
- Form 5471 Schedule O: What It Is & How to Fill It$405.53
- Federal 1120 Schedule O: What It Is & How to File$50,000.00
- Form 1065 Schedule L: Balance Sheet Instructions$0.00
- Federal 1065 Schedule L: Balance Sheet Guide$0.00