This calculator works out the full repayment plan for a fixed-rate loan: your monthly payment, how much total interest you will pay, and a breakdown of each payment into principal and interest over the life of the loan. You enter the loan amount, the annual interest rate (APR), and the loan term in years, and the calculator returns your monthly payment and total interest cost.
Formula
The calculator uses the standard fixed-rate loan payment formula:
Monthly Payment = P × (r × (1 + r)^n) / ((1 + r)^n – 1)
where:
- P = loan amount (principal) in dollars
- r = monthly interest rate = annual APR / 12 / 100 (e.g., 8% APR → 0.08/12 = 0.006666…)
- n = total number of monthly payments = 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 multiplied by the number of payments, minus the original loan amount.
Worked Example
Using the default values: loan amount $20,000, APR 8%, term 5 years.
- Monthly rate r = 8 / 1200 = 0.0066667
- Number of payments n = 5 × 12 = 60
- Payment = 20000 × (0.0066667 × (1.0066667^60)) / (1.0066667^60 – 1)
- Compute (1.0066667^60) ≈ 1.4898457
- Numerator: 20000 × (0.0066667 × 1.4898457) = 20000 × 0.0099323 = 198.646
- Denominator: 1.4898457 – 1 = 0.4898457
- Payment = 198.646 / 0.4898457 ≈ 405.53 (rounded to $405.53)
Total paid = 405.53 × 60 = $24,331.80. Total interest = 24,331.80 – 20,000 = $4,331.80.
These match the calculator output exactly.
Assumptions
- Fixed interest rate for the entire loan term (no rate changes).
- Payments are made monthly at the end of each period.
- Interest compounds monthly at APR/12.
- No fees, taxes, insurance, PMI, or escrow are included.
- The payment is rounded to the cent, and totals are calculated from that rounded payment.
How to Read the Results
The monthly payment is the amount you would pay each month if the loan starts today and you never miss a payment. The total interest tells you the cost of borrowing over the whole term. For example, a $20,000 loan at 8% for 5 years costs $405.53 per month and $4,331.80 in interest. If you lengthen the term to 10 years, the monthly payment drops (to about $242.66) but the total interest rises (to about $9,119.20) because you are paying interest for longer. This trade-off is central to any amortization schedule.
Common Mistakes and Misconceptions
- Using the APR directly in the formula without dividing by 12. The annual rate must be converted to a monthly rate. For 8% APR, use 0.08/12, not 0.08.
- Confusing APR with the nominal rate. APR includes certain fees and costs in some contexts, but here it is simply the annual interest rate. If your loan has origination fees, the actual cost will be higher.
- Rounding too early. If you round the monthly rate to 0.0067 instead of 0.0066667, the payment will be slightly off. Keep full precision until the final step.
- Thinking the interest is simple interest. Amortized loans charge interest on the remaining balance, so early payments are mostly interest, and later payments are mostly principal. The formula accounts for this automatically.
How to Use an Amortization Schedule
An amortization schedule is a table showing each payment’s split into interest and principal, plus the remaining balance. To build one manually, for each month k (starting at 1):
- Interest for month k = previous balance × monthly rate
- Principal paid = monthly payment – interest
- New balance = previous balance – principal paid
For the example above, month 1: balance $20,000, interest = 20,000 × 0.0066667 = $133.33, principal = 405.53 – 133.33 = $272.20, new balance = $19,727.80. Month 2: interest = 19,727.80 × 0.0066667 = $131.52, principal = $274.01, balance = $19,453.79. The schedule continues until the balance reaches zero after 60 payments.
When to Use This Calculator
Use this tool for any fixed-rate loan where you know the amount, rate, and term: personal loans, auto loans, student loans, or mortgages. It is especially useful to compare different terms: a shorter term means a higher monthly payment but less total interest; a longer term means a lower payment but more interest. The calculator does not account for extra payments, which would shorten the term and reduce total interest. If you plan to make extra payments, you would need a more detailed calculator that includes prepayment.
Limitations of the Formula
The formula assumes the interest rate never changes and that you make exactly the same payment every month. Real loans may have fees, variable rates, or payment holidays. For adjustable-rate mortgages, the payment changes when the rate resets, so this formula only works for the initial fixed period. Also, the formula does not include property taxes, insurance, or PMI, which are often escrowed into a mortgage payment. For an accurate picture of your actual monthly obligation, add those costs separately.
Frequently Asked Questions
How do I calculate the monthly payment on a note?
Use the formula: Payment = P × (r(1+r)^n) / ((1+r)^n – 1), where P is the loan amount, r is the monthly rate (APR/12/100), and n is the number of months. This calculator does it for you.
What is the difference between a note and a loan?
A note is a legal document that promises repayment, while a loan is the actual money given. The amortization schedule applies to the loan itself, regardless of the document.
Can I use this for a mortgage with escrow?
No, the calculator only covers principal and interest. Escrow for taxes and insurance is not included, so your actual monthly payment will be higher.
How does making extra payments affect the schedule?
Extra payments reduce the principal faster, which lowers the total interest and shortens the term. The monthly payment stays the same unless you recast the loan. This calculator does not model extra payments.
Why is my calculated payment different from the lender’s quote?
Lenders may include fees, rounding differences, or different payment dates. Also, if the loan has a variable rate or a balloon payment, the standard formula won’t match. Always check the lender’s disclosure for the exact figures.
What is a balloon payment?
A balloon payment is a large lump sum due at the end of the loan term, often after a series of smaller payments. This calculator assumes the loan is fully amortized (paid off) over the term, so it does not apply to balloon loans.
This result is an estimate based on the inputs you provide; the lender’s official disclosure will give the exact payment and total cost 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