This equity finance loan calculator estimates the monthly payment and total interest for a loan based on the amount you borrow, the annual percentage rate (APR), and the loan term in years. You enter the loan amount, interest rate, and term, and the calculator returns your fixed monthly payment and the total interest paid over the life of the loan. It uses the standard amortization formula for level-payment loans, which is the same math used for most mortgages, auto loans, and personal loans.
Formula
The monthly payment for a fixed-rate, fully amortizing loan is calculated with the standard 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 (APR is the annual percentage rate in percent, divided by 100 to get a decimal, then divided by 12 for monthly)
- n = total number of monthly payments = loan term in years × 12
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.0066666667
- Calculate number of payments: n = 5 × 12 = 60
- Compute (1 + r)^n = (1.0066666667)^60 ≈ 1.489845708
- Numerator: P × r × (1 + r)^n = 20000 × 0.0066666667 × 1.489845708 ≈ 198.6460944
- Denominator: (1 + r)^n − 1 = 1.489845708 − 1 = 0.489845708
- Monthly payment: M = 198.6460944 / 0.489845708 ≈ 405.53 (rounded to the cent)
- Total interest: M × n − P = 405.53 × 60 − 20000 = 24331.80 − 20000 = $4,331.80
So for a $20,000 loan at 8% APR over 5 years, the monthly payment is $405.53 and the total interest is $4,331.80, matching the calculator output.
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 a rate of APR / 12.
- The loan is fully amortizing—each payment covers interest and reduces principal, so the balance reaches zero at the end of the term.
- Fees, taxes, insurance, PMI, and other charges are not included unless you add them to the loan amount manually.
When to Use This Calculator
This calculator is useful for any fixed-rate loan where you want to know the monthly payment and total interest before you commit. Common scenarios include:
- Comparing loan offers from different lenders by entering the same amount and term but different APRs.
- Estimating how a longer term reduces your monthly payment but increases total interest.
- Planning a budget by seeing what payment fits your cash flow.
- Understanding the impact of a larger down payment (which reduces the loan amount).
It works for mortgages, auto loans, personal loans, student loans, and business loans—as long as the loan has a fixed rate and equal monthly payments.
How to Read the Results
The monthly payment is the amount you pay each month. The total interest is the extra cost of borrowing over the entire term. For example, a $20,000 loan at 8% for 5 years costs $4,331.80 in interest, meaning you repay $24,331.80 in total. If you extend the term to 10 years, the monthly payment drops (to about $242.66) but the total interest rises significantly (to about $9,119.20). This trade-off is the core of loan planning.
Common Mistakes and Misconceptions
- Using the annual rate directly in the formula: Always divide APR by 1200 to get the monthly rate. Forgetting this leads to wildly wrong payments.
- Confusing APR with the nominal rate: APR includes certain fees and reflects the true cost, but the formula uses APR as the annual interest rate. If your loan has origination fees, the APR may be higher than the stated rate, so use the APR for a more accurate estimate.
- Rounding too early: Keep full precision in intermediate steps. Round only the final payment to cents.
- Assuming interest is simple: Most loans compound monthly, not annually. The formula accounts for monthly compounding.
- Ignoring the effect of extra payments: Making extra payments reduces the balance faster and cuts total interest, but this calculator assumes you pay exactly the scheduled amount each month.
Limits of the Formula
This formula assumes a fixed interest rate and equal payments. It does not handle:
- Adjustable-rate loans where the rate changes over time.
- Interest-only periods or balloon payments.
- Loans with fees rolled into the principal (though you can add them to the loan amount).
- Prepayment penalties or tax implications.
For those cases, you need a more specialized calculator or a lender’s amortization schedule.
Frequently Asked Questions
What is the difference between APR and interest rate?
The interest rate is the cost of borrowing the principal, expressed as a percentage. APR (Annual Percentage Rate) includes the interest rate plus certain fees (like origination fees) and is expressed as a yearly rate. APR gives a more complete picture of the loan’s cost. For the payment formula, use APR because it reflects the true cost you pay.
Can I use this calculator for a home equity loan?
Yes, if the home equity loan has a fixed rate and is fully amortizing (which most are). Enter the loan amount (the amount you borrow), the APR, and the term. The calculator gives the monthly payment and total interest. Home equity lines of credit (HELOCs) often have variable rates, so this calculator is not accurate for those.
How does the loan term affect my payment and total interest?
A longer term reduces your monthly payment because the principal is spread over more months, but you pay more total interest because interest accrues over a longer period. For example, a $20,000 loan at 8% for 3 years has a monthly payment of about $626.73 and total interest of $2,562.28, while a 10-year term has a payment of $242.66 and total interest of $9,119.20.
What if I make extra payments?
Extra payments reduce the principal faster, which shortens the loan term and reduces total interest. This calculator assumes no extra payments. To estimate the effect, you would need a calculator that allows extra payments or a full amortization schedule.
Does this calculator include taxes and insurance?
No. The calculator only covers principal and interest. For a mortgage, you would add property taxes, homeowners insurance, and possibly PMI to get the full monthly housing cost. Those amounts vary by location and lender, so they are not included.
Why does the calculator show “Cannot compute” for some inputs?
If the payment amount cannot cover the interest (for example, if the term is extremely long or the rate is very high), the formula produces a negative or undefined result. The calculator prevents this by showing “Cannot compute.” In practice, a loan with a payment less than the interest would never amortize—the balance would grow, not shrink.
Remember, this calculator provides an estimate based on the inputs you provide. The exact figures will appear on your loan disclosure from the lender.
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
- QNB Car Loan Payment Calculator and Guide$405.53
- Car Loan Payment Calculator and Formula$405.53
- VA Down Payment Assistance Calculator and Guide$15,000.00
- Low Down Payment Home Loans: Costs and Trade-Offs$405.53
- Down Payment vs Advance Payment: Key Differences
- DIB Bank Car Loan Calculator and Payment Guide$405.53