calculate-loan

01 Loan payments

Total Balance and Interest: How It Works

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

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

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.

This calculator works out your total loan balance and the total interest you will pay over the life of a fixed-rate loan. You enter the loan amount, the annual interest rate (APR), and the loan term in years, and you get back the monthly payment and the total interest paid. The total balance is simply the original loan amount plus the total interest, which equals the sum of all monthly payments.

Formula

The monthly payment for a fixed-rate loan is calculated using the standard amortization formula:

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

Where:

  • P = loan principal (the amount you borrow, in dollars)
  • r = monthly interest rate = annual rate (APR) divided by 12, then divided by 100 (so 8% APR becomes 0.0066667)
  • n = total number of monthly payments = loan term in years × 12

Total interest is then: Total Interest = (Monthly Payment × n) − P

Total balance (the amount you actually repay) is: Total Balance = P + Total Interest

Worked Example

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

  1. Convert APR to monthly rate: 8 / 12 / 100 = 0.0066667
  2. Number of payments: 5 × 12 = 60
  3. Plug into the formula: 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1)
  4. (1.0066667)^60 ≈ 1.4898457
  5. Numerator: 20000 × (0.0066667 × 1.4898457) = 20000 × 0.0099323 = 198.646
  6. Denominator: 1.4898457 − 1 = 0.4898457
  7. Monthly payment = 198.646 / 0.4898457 ≈ 405.53
  8. Total paid = 405.53 × 60 = 24,331.80
  9. Total interest = 24,331.80 − 20,000 = 4,331.80

So for a $20,000 loan at 8% APR over 5 years, the monthly payment is $405.53, the total interest is $4,331.80, and the total balance repaid is $24,331.80. These match the calculator’s outputs exactly.

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 APR / 12.
  • The loan has no prepayment penalty, and you make exactly the required payment every month.
  • Fees, taxes, insurance, and other charges are not included.

How to Read the Results

The monthly payment is the amount you pay each month. The total interest is the extra cost of borrowing on top of the principal. The total balance is the full amount you will have paid by the end of the term. Notice that the total interest is not simply the APR times the principal times the years—that would ignore the fact that you are paying down the principal each month. For example, 8% of $20,000 is $1,600 per year, which over 5 years would be $8,000, but the actual total interest is only $4,331.80 because the average balance is much lower than $20,000.

Common Mistakes and Misconceptions

  • Using the annual rate directly in the formula: Always divide by 12 to get the monthly rate. Using 8 instead of 0.0066667 gives a wildly wrong payment.
  • Forgetting to convert years to months: The exponent must be the number of monthly payments, not the number of years.
  • Rounding the monthly payment too early: If you round the payment to $405.53 before computing total interest, the result is slightly different from the exact formula. The calculator rounds the payment to cents first, then multiplies by the number of payments, which is the standard practice.
  • Thinking total interest is simple interest: Amortized loans charge interest on the remaining balance, so early payments are mostly interest, and later payments are mostly principal.

When to Use This Calculator

Use this calculator for any fixed-rate installment loan where you know the amount, rate, and term. Common examples include auto loans, personal loans, student loans, and fixed-rate mortgages. It is especially useful for comparing different loan offers: a longer term lowers the monthly payment but increases total interest, while a shorter term does the opposite. For instance, a $20,000 loan at 8% for 3 years gives a monthly payment of $626.73 and total interest of $2,562.28, while the same loan for 7 years gives a payment of $311.24 and total interest of $6,144.16. This calculator shows that trade-off clearly.

Limits of the Formula

The formula assumes a fixed rate and level payments. It does not handle adjustable-rate loans, interest-only periods, balloon payments, or loans with fees rolled into the principal. It also assumes you never miss a payment and never pay extra. If you make extra payments, the total interest will be lower and the loan will be paid off early, but this formula will not reflect that. For those scenarios, you would need a more detailed amortization schedule that tracks each payment.

Frequently Asked Questions

What is the difference between total balance and total interest?

Total interest is the extra money you pay for the privilege of borrowing—the sum of all interest charges over the loan’s life. Total balance is the entire amount you repay, which is the original loan amount plus the total interest. For the default example, the total interest is $4,331.80, and the total balance is $24,331.80.

Why is my total interest not equal to APR × principal × years?

Because the loan is amortized—you pay down the principal each month, so the balance on which interest is charged shrinks over time. The average balance is roughly half the original amount for a fully amortizing loan, so the actual interest is closer to half of what simple multiplication would suggest. For a 5-year, 8% loan on $20,000, simple interest would be $8,000, but the actual is $4,331.80.

Does the monthly payment include taxes and insurance?

No. The payment calculated here covers only principal and interest. For a mortgage, you might also pay property taxes, homeowners insurance, and possibly PMI, often held in an escrow account. Those are separate costs and are not part of this formula. Ask your lender for a full breakdown of the monthly payment including escrow.

What happens if I make extra payments?

Extra payments reduce the principal balance faster, which means less interest accrues over time. The loan will be paid off earlier than the original term, and the total interest will be lower than what this calculator shows. To see the exact effect, you would need an amortization schedule that recalculates interest on the reduced balance.

Can I use this for a mortgage?

Yes, for the principal and interest portion of a fixed-rate mortgage. However, mortgages often have additional costs like property taxes, insurance, and possibly PMI, which are not included. Also, if the mortgage has an adjustable rate, this formula only works for the period when the rate is fixed. For a standard 30-year fixed mortgage, this calculator gives the correct monthly payment and total interest for the loan amount and rate you enter.

Why does the calculator show “Cannot compute” for some inputs?

That happens when the interest rate or term is set to an impossible value, such as a zero or negative rate, or a term that is too short for the payment to cover the interest. The formula requires a positive rate and a positive number of payments. If you see that message, check that your inputs are within the allowed ranges.

This result is an estimate for educational purposes; your lender’s disclosure statement provides the exact figures 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

The whole Loan payments section →