calculate-loan

01 Loan payments

Loan and Debt Calculator: How to Use One

Calculator No. 01-25881 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A loan and debt calculator works out your monthly payment and total interest for a fixed-rate loan when you enter the amount borrowed, the annual interest rate, and the term in years. It uses the standard amortization formula to give you a clear picture of what a loan really costs before you sign. This page explains the math, shows a worked example, and covers common pitfalls so you can read the results with confidence.

Formula

The calculator uses the standard fixed-rate loan payment formula:

Monthly Payment = P × (r × (1 + r)^n) / ((1 + r)^n − 1)

Where:

  • P = principal (loan amount) in dollars
  • r = monthly interest rate, equal to the annual percentage rate (APR) divided by 12 and then by 100 (so an 8% APR gives r = 0.08/12 = 0.006666…)
  • n = total number of monthly payments, equal to the term in years multiplied by 12

The total interest is simply the monthly payment multiplied by the number of payments, minus the principal.

Worked Example

Using the default values: loan amount $20,000, APR 8%, term 5 years.

  1. Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
  2. Number of payments: n = 5 × 12 = 60
  3. Compute (1 + r)^n = (1.0066667)^60 ≈ 1.4898457
  4. Payment = 20000 × (0.0066667 × 1.4898457) / (1.4898457 − 1) = 20000 × (0.0099323) / 0.4898457 ≈ 20000 × 0.020276 = 405.52
  5. Total paid = 405.52 × 60 = 24,331.20
  6. Total interest = 24,331.20 − 20,000 = 4,331.20

The calculator shows a monthly payment of $405.52 and total interest of $4,331.20, matching the example exactly.

Assumptions

  • Fixed interest rate for the entire term (not adjustable).
  • Payments are made at the end of each month.
  • Interest compounds monthly at APR / 12.
  • The payment is rounded to the cent, and totals use that rounded payment.
  • No fees, taxes, insurance, or other charges are included.

How to Read the Results

The monthly payment is the amount you would pay each month to fully repay the loan by the end of the term. The total interest figure shows the extra cost of borrowing beyond the principal. Comparing these numbers across different loan amounts, rates, or terms helps you see how each factor affects your budget. For example, a longer term lowers the monthly payment but increases total interest, while a shorter term does the opposite. The calculator does not tell you whether a loan is affordable or a good choice—it only gives the arithmetic for the inputs you provide.

Common Mistakes and Misconceptions

  • Using the APR as a monthly rate: Always divide the APR by 12 (and by 100) before using it in the formula. A common error is plugging in 8 instead of 0.0066667.
  • Ignoring fees and other costs: The calculator shows only principal and interest. Origination fees, closing costs, and insurance can add hundreds or thousands to the true cost.
  • Rounding too early: If you round the monthly rate to 0.007 instead of 0.0066667, the payment will be slightly off. Keep full precision until the final step.
  • Assuming the payment stays the same for an adjustable-rate loan: This formula only works for fixed-rate loans. If the rate can change, the payment will change too.
  • Thinking the total interest is simply APR × principal × years: That ignores amortization, where you pay interest on a declining balance. The actual interest is less than that simple multiplication.

When to Use This Calculator

Use this calculator when you are comparing fixed-rate loan offers, planning a budget for a major purchase, or deciding between different loan terms. It is useful for auto loans, personal loans, student loans, and many mortgages. However, it is not designed for:

  • Credit cards with revolving balances and variable rates
  • Interest-only loans or balloon payments
  • Loans with prepayment penalties or complex fee structures
  • Adjustable-rate mortgages with rate caps

For those situations, you need a more specialized tool or a detailed amortization schedule from the lender.

How to Choose a Loan Term

Your choice of term (e.g., 3 years vs. 5 years) affects both the monthly payment and total interest. As a general rule:

  • Shorter terms mean higher monthly payments but less total interest.
  • Longer terms mean lower monthly payments but more total interest.
  • A longer term can also mean you owe more than the item is worth for a longer period (negative equity).

The calculator lets you experiment with different terms to see the trade-off. For example, a $20,000 loan at 8% for 3 years (36 months) gives a payment of about $626.73 and total interest of about $2,562.28, compared to the 5-year example above. The 3-year loan saves about $1,768.92 in interest but costs about $221 more per month.

Safety and Accuracy Notes

Always verify the interest rate and term with your lender before relying on the result. Lenders may use slightly different rounding or compounding methods (e.g., daily compounding), which can change the payment by a few cents. The calculator assumes monthly compounding at APR/12, which is standard for most installment loans but not universal. Also, the APR you receive depends on your credit score, income, and market conditions—the 8% default is just an example. You should enter the actual rate from your loan offer to get a meaningful estimate.

This calculator is for educational purposes and provides an estimate only. The exact figures will be stated in your loan disclosure documents.

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 yearly percentage. APR (annual percentage rate) includes the interest rate plus certain fees and costs, so it is usually higher. For this calculator, use the APR if you want to include those fees in the payment estimate; otherwise, use the nominal interest rate. Lenders are required to disclose the APR.

Can I use this calculator for a mortgage?

Yes, but only for a fixed-rate mortgage with no escrow, PMI, or other fees. The calculator will give you the principal and interest portion of your monthly payment. Your actual mortgage payment may also include property taxes, homeowners insurance, and private mortgage insurance, which are not included here. For a complete picture, add those costs separately.

Why does the total interest seem so high?

Interest accrues on the remaining balance each month. Early in the loan, most of your payment goes to interest; later, more goes to principal. Over a long term, the cumulative interest can be substantial. For example, a $30,000 loan at 6% for 6 years (72 months) results in about $5,800 in interest. That is why comparing total interest across terms is useful.

What if I make extra payments?

Extra payments reduce the principal faster, which lowers the total interest and shortens the loan term. This calculator does not model extra payments. You would need a separate extra-payment calculator to see the effect. In general, making extra payments early saves more interest than doing so later.

Is the monthly payment the same every month?

For a fixed-rate loan, yes, the payment is the same every month. The portion going to interest and principal changes over time, but the total payment stays constant. If the loan has a variable rate, the payment can change when the rate changes.

What does “Cannot compute” mean?

If the payment formula produces a negative or undefined result, it usually means the interest rate or term is outside the valid range, or the payment is less than the monthly interest. For example, a very high rate with a very long term can cause the formula to fail. Check your inputs and make sure they are realistic.

The result from this calculator is an estimate; your lender’s disclosure will provide 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

The whole Loan payments section →