This calculator works out your monthly mortgage payment and generates a full amortization schedule, showing how much of each payment goes to interest versus principal over the life of the loan. Enter your loan amount, interest rate (APR), and loan term in years, and you’ll get the monthly payment, total interest paid, and a year-by-year breakdown of balances.
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 = APR / 1200 (as a decimal, e.g., 8% APR → r = 0.08/12 = 0.0066667)
- n = total number of monthly payments = loan term in years × 12
This formula assumes a fixed interest rate for the entire term and that payments are made at the end of each month (ordinary annuity). The total interest is simply the monthly payment times the number of payments minus the principal: Total Interest = M × n – P.
Worked Example
Using the default values from the calculator: loan amount = $20,000, APR = 8%, term = 5 years.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
- Calculate number of payments: n = 5 × 12 = 60
- Compute (1 + r)^n = (1.0066667)^60 ≈ 1.4898457
- Plug into formula: M = 20000 × (0.0066667 × 1.4898457) / (1.4898457 – 1)
- Numerator: 20000 × 0.0099323 = 198.646
- Denominator: 0.4898457
- M = 198.646 / 0.4898457 ≈ 405.53
So the monthly payment is $405.53 (rounded to cents). Total paid over 60 months = 405.53 × 60 = $24,331.80. Total interest = $24,331.80 – $20,000 = $4,331.80, which matches the calculator’s output.
Assumptions
- Fixed interest rate for the entire loan term (no rate adjustments).
- Payments are made at the end of each month.
- Interest compounds monthly at APR / 12.
- No fees, taxes, insurance, PMI, or escrow are included.
- The payment is rounded to the nearest cent; the calculator uses the rounded payment for totals.
How to Read an Amortization Schedule
An amortization schedule is a table that breaks down every payment into two parts: interest and principal. In the early months, a large share of your payment goes toward interest, with only a small amount reducing the principal. As the balance decreases, the interest portion shrinks and the principal portion grows. By the end of the term, the final payment clears the remaining balance.
For example, with a $200,000 loan at 6% APR for 30 years, the first payment might be $1,199.10, with $1,000 going to interest and $199.10 to principal. After 15 years, the interest portion drops to about $600, and the principal portion rises to about $600. This front-loading of interest is why paying extra early can save significant interest over time.
Common Mistakes and Misconceptions
- Using the nominal APR instead of the monthly rate: Always divide APR by 12 to get the monthly rate. Forgetting this can overstate the payment.
- Ignoring rounding: Lenders round payments to the nearest cent; the last payment may differ slightly. Most calculators, including this one, round the monthly payment and then compute totals from that rounded value.
- Assuming the schedule is linear: Many people think principal is paid down evenly each month. In reality, interest is charged on the remaining balance, so the schedule is curved.
- Confusing APR with the note rate: APR includes certain fees and costs, so it can be slightly higher than the interest rate quoted. This calculator uses the APR as the effective annual rate, which is a good approximation for most loans.
- Not accounting for extra payments: If you make extra principal payments, the schedule changes. The calculator here does not model extra payments; you would need a more advanced tool for that.
When to Use This Calculator
Use this calculator when you want a quick estimate of the monthly payment for a fixed-rate mortgage. It’s useful for comparing different loan amounts, interest rates, or terms. For example, you can see how a 15-year term compares to a 30-year term in terms of monthly payment and total interest. You can also use it to estimate the payment for a refinance or a home equity loan.
However, this calculator does not include property taxes, homeowners insurance, PMI (if your down payment is less than 20%), or HOA fees. Those are typically added to your monthly payment through an escrow account. To get your true monthly housing cost, add those amounts to the calculator’s result.
How to Choose a Loan Term
Loan term is one of the most important choices you’ll make. A shorter term (e.g., 15 years) usually has a higher monthly payment but much lower total interest. A longer term (e.g., 30 years) has a lower monthly payment but more interest over time. For instance, a $250,000 loan at 6% APR:
- 15-year term: monthly payment ≈ $2,109.64, total interest ≈ $129,735
- 30-year term: monthly payment ≈ $1,498.88, total interest ≈ $289,596
The 30-year payment is about $611 less per month, but you pay an extra $159,861 in interest. Use this calculator to run your own numbers and see the trade-off. There is no universally “best” term; it depends on your budget and financial goals.
Limitations of the Formula
The amortization formula assumes a fixed rate and level payments. It does not apply to adjustable-rate mortgages (ARMs), interest-only loans, or balloon loans. For those, the payment can change over time or have a large final payment. Additionally, the formula does not account for prepayment penalties or other fees that might affect the true cost. Always check your loan documents for the exact terms.
Frequently Asked Questions
How do I calculate the amortization schedule for a home loan?
To create a schedule, start with your 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 from the balance to get the new balance. Repeat for each month until the balance reaches zero.
What is the difference between APR and interest rate?
The interest rate is the cost of borrowing the principal, expressed as a yearly percentage. APR (Annual Percentage Rate) includes the interest rate plus certain lender fees and closing costs, spread over the loan term. APR is generally higher than the interest rate and gives a more complete picture of the loan’s cost.
Can I use this calculator for an adjustable-rate mortgage?
No. This calculator assumes a fixed rate for the entire term. For an ARM, the rate changes after an initial period, and the payment can go up or down. You would need a more complex calculator that models rate adjustments.
How does making extra payments affect my amortization schedule?
Extra principal payments reduce your balance faster, which means less interest accrues in future months. This can shorten your loan term and reduce total interest. To see the effect, you would need a calculator that allows extra payments, as this one does not.
Why is my first payment mostly interest?
Because interest is calculated on the full loan balance at the start. Since the balance is highest at the beginning, the interest portion is largest. As you pay down principal, the interest portion decreases over time.
What is PMI and why isn’t it included?
PMI (Private Mortgage Insurance) is required by lenders when your down payment is less than 20%. It protects the lender if you default. This calculator does not include PMI because it varies by lender and loan type. You would need to add it separately to your monthly cost estimate.
This calculator provides an estimate for educational purposes; your lender’s official disclosure will show the exact payment and amortization schedule.
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