An interest rate calculator for loan comparisons estimates the monthly payment and total interest for a fixed-rate, fully amortizing loan from its amount, annual percentage rate (APR), and term. Enter those figures to compare the payment and interest estimates on the same basis; the calculator does not include fees or other borrowing costs.
Formula
The calculator treats the APR as a nominal annual rate divided into monthly periods. It calculates the level payment that pays off the principal and interest over the full term, then subtracts the original principal from the sum of the rounded monthly payments.
- p = amount borrowed, in dollars.
- apr = annual percentage rate, entered as a percentage number; for example, enter 8 for 8%.
- r = monthly interest rate as a decimal, equal to apr ÷ 1,200.
- n = number of monthly payments, equal to years × 12.
- pmt = monthly payment in dollars, rounded to the nearest cent.
- int = estimated total interest in dollars, using the rounded payment.
The payment formula is pmt = round[p × r ÷ (1 − (1 + r)−n), 2]. Total interest is int = pmt × n − p. The payment is rounded before total interest is calculated, so the estimate reflects a payment amount expressed in cents.
Worked Example
Using the calculator’s default values—$20,000 borrowed at 8% APR for 5 years:
- Convert the APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
- Find the number of monthly payments: 5 × 12 = 60.
- Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60] = $405.53 after rounding to cents.
- Calculate total interest using that rounded payment: $405.53 × 60 − $20,000 = $4,331.80.
The displayed estimates are a monthly payment of $405.53 and total interest of $4,331.80. Actual schedules can differ if the lender uses different payment dates, rounding, or rate conventions.
Assumptions
- The interest rate remains fixed for the entire term.
- There are equal monthly payments, with the first payment one month after the loan begins.
- Interest compounds monthly, using APR ÷ 12 as the monthly rate.
- The calculation excludes fees, taxes, insurance, PMI, and escrow. It assumes the stated amount is the principal being repaid.
How to Compare Loan Estimates
For a meaningful comparison, use the same principal and term for each option, then enter each quoted APR separately. If the offers have different terms, compare both their monthly payments and total interest, while keeping in mind that a longer term can lower the payment but increase the number of months interest accrues. A payment figure alone does not show the full cost or every difference between loan contracts.
For example, a hypothetical $20,000 loan at 8% APR over five years gives the result above. If the term changes, the monthly payment and total interest both change even if the principal and APR stay the same. This calculator can show the effect of those inputs, but the numbers are examples rather than a forecast of an available offer. Enter the actual APR and term from each lender’s written estimate; do not substitute a general advertised rate.
Check whether quoted rates are comparable. An interest rate is the price charged for borrowing, while APR may express a broader annualized borrowing cost under the lender’s calculation. The calculator labels its input APR but applies it as a nominal annual rate divided by 12. It does not separately model fees or independently verify how a lender calculated an APR. If offers include different fees, discount points, or other charges, review those disclosed amounts separately rather than treating the calculator’s interest result as the entire cost.
What the Results Show—and Leave Out
The monthly payment is the modeled amount due for principal and interest under the assumptions above. Total interest is the sum of those rounded payments minus the original loan principal. It is not the total amount paid: the modeled total of principal and interest is the original principal plus the displayed interest.
Some real loans have variable rates, irregular payment dates, balloon payments, interest-only periods, deferred payments, or fees added to the balance. Those features do not fit this fixed-rate level-payment formula. Extra payments can also change the payoff date and interest paid, but they are not included here. For those situations, use the lender’s payment schedule or a calculator that explicitly models the relevant terms.
Common Comparison Mistakes
- Mixing up APR and a monthly rate: enter an annual percentage such as 8, not 0.08 or a monthly percentage. The calculator converts APR to a monthly decimal internally.
- Comparing different loan amounts: a smaller payment may simply reflect borrowing less. Hold principal constant when isolating the effect of rate or term.
- Looking only at the payment: a longer term spreads repayment over more months, so the payment can fall even as total interest rises.
- Ignoring fees or add-ons: they may affect the amount financed or overall cost, but this calculator has no inputs for them.
- Assuming the estimate is a payoff quote: actual payoff figures can depend on accrued interest, payment history, and contract terms.
Frequently Asked Questions
How do I compare two loans with an interest rate calculator?
Enter each loan’s principal, APR, and term, then compare the estimated monthly payment and total interest. Use consistent assumptions and check fees and other terms separately.
Does a lower APR always mean a lower monthly payment?
Not by itself. The payment also depends on the amount borrowed and the repayment term. Different fees or contract features are not captured by this calculation.
Why can a longer loan term cost more interest?
A longer term generally means more monthly periods during which interest is charged. The lower payment, if any, does not by itself indicate lower total interest.
Is APR the same as the interest rate?
No. APR is an annualized measure that can incorporate certain borrowing costs according to the lender’s method, while the interest rate is the rate used to calculate interest. This calculator uses the entered APR as its periodic rate basis and does not model separate fees.
Does the calculator include fees or extra payments?
No. It models equal monthly principal-and-interest payments and excludes fees, taxes, insurance, escrow, and extra payments.
Can I use it for a variable-rate loan?
Only as a simplified illustration of one assumed fixed rate and term. A variable rate can change, so this result cannot represent the full future payment schedule.
This result is an estimate; the lender’s disclosure gives the exact figures.
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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 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
- Debt-to-Income Calculator and Spreadsheet Formula40.00 %
- Debt-to-Income Ratio Calculator and How It Works30.00 %
- Debt-to-Income Ratio Calculator: Meaning and Formula24.00 %
- Debt-to-Income Ratio: Is Yours Too High?36.00 %
- Debt-to-Income Ratio Calculator and Scale24.00 %
- Debt-to-Income Ratio Calculator and Sheet38.33 %