calculate-loan

01 Loan payments

Loan Calculator Reducing Balance Formula

Calculator No. 01-24940 · 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 monthly payment and total interest for a loan using the reducing balance method, where interest is charged on the remaining principal each month. You enter the loan amount, annual interest rate (APR), and loan term in years, and you get the exact level monthly payment and total interest paid over the life of the loan.

Formula

The reducing balance formula for a fixed-rate, fully amortizing loan is:

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

Where:

  • P = principal (loan amount) in dollars
  • r = monthly interest rate = annual rate (APR) ÷ 12 ÷ 100 (as a decimal)
  • n = total number of monthly payments = years × 12

This is the standard formula used by most lenders for personal loans, auto loans, and fixed-rate mortgages. It is called “reducing balance” because each month the interest is calculated on the remaining principal, which decreases as you make payments.

Worked Example

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

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. Number of payments n = 5 × 12 = 60
  3. (1 + r)^n = (1.0066667)^60 ≈ 1.489846
  4. Numerator: 20000 × 0.0066667 × 1.489846 ≈ 198.646
  5. Denominator: 1.489846 − 1 = 0.489846
  6. Monthly payment = 198.646 / 0.489846 ≈ 405.53 (rounded to cents)

Total paid = 405.53 × 60 = $24,331.80. Total interest = $24,331.80 − $20,000 = $4,331.80. These match the calculator outputs exactly.

Assumptions

  • The interest rate is fixed for the entire term.
  • Payments are made at the end of each month (ordinary annuity).
  • Interest compounds monthly at APR ÷ 12.
  • The formula does not include fees, taxes, insurance, PMI, or escrow amounts.
  • All payments are made on time; missed payments would change the actual balance.

How the Reducing Balance Method Works

In a reducing balance loan, each monthly payment is split into two parts: interest and principal. The interest portion is calculated as the current balance times the monthly rate. The remainder of the payment reduces the principal. Because the principal decreases each month, the interest portion also decreases, so more of your payment goes toward principal over time.

For example, in the first month of the $20,000 loan at 8% APR, interest is $20,000 × 0.0066667 = $133.33. The remaining $405.53 − $133.33 = $272.20 reduces the principal to $19,727.80. In the second month, interest is $19,727.80 × 0.0066667 ≈ $131.52, and principal reduction is $274.01. This continues until the last payment, where the interest is just a few cents and nearly the entire payment is principal.

Why the Formula Matters

The reducing balance formula is the industry standard for installment loans. It ensures that the lender earns interest only on the outstanding balance, which is fairer to borrowers than a flat-rate method where interest is charged on the original amount for the whole term. Understanding this formula lets you calculate your own payment, compare loan offers, and see how much interest you’ll pay over time.

It also helps you see the impact of the interest rate and term. A higher rate or longer term increases total interest, while a shorter term raises the monthly payment but lowers total interest. For instance, the same $20,000 at 8% for 3 years gives a payment of about $626.73 and total interest of $2,562.28, versus $4,331.80 over 5 years.

Common Mistakes and Misconceptions

  • Using the annual rate directly: Always divide the APR by 12 to get the monthly rate. Using 8% instead of 0.6667% will give a wildly wrong payment.
  • Forgetting to convert years to months: n must be in months. A 5-year loan has 60 payments, not 5.
  • Rounding too early: Keep several decimal places in intermediate steps; rounding the monthly rate to 0.007 instead of 0.0066667 can change the payment by a few dollars.
  • Confusing reducing balance with simple interest: Simple interest loans charge interest on the original principal for the whole term, which is different and usually more expensive.
  • Thinking the payment is interest + principal divided by months: That would ignore the compounding effect and understate the true payment.

Limits of the Formula

This formula assumes a fixed rate and equal monthly payments. It does not work for variable-rate loans, interest-only periods, balloon payments, or loans with fees rolled into the principal. If you have a loan with a teaser rate or payment holidays, the actual payment schedule will differ. Also, the formula gives the payment before any taxes or insurance; those are usually added to your monthly bill but are not part of the loan arithmetic.

For loans with daily interest (common in some countries), the calculation is slightly different, but the monthly compounding model is standard for most consumer loans in the US and many other places.

How to Use the Result

The monthly payment from the calculator is what you would pay each month if the loan terms are exactly as entered. Total interest tells you the cost of borrowing over the full term. You can use these numbers to compare different loan offers by entering the same loan amount and term but different APRs. You can also see how extra payments would shorten the loan or reduce interest, though that requires a separate calculation.

Remember that the lender’s official disclosure (the Loan Estimate or Truth-in-Lending statement) will show the exact payment, APR, and total interest, including any fees. The calculator is an educational tool for estimation.

Frequently Asked Questions

What is the difference between reducing balance and flat rate interest?

Reducing balance interest is calculated on the remaining principal each month, so the interest you pay decreases over time. Flat rate interest is calculated on the original loan amount for the entire term, so you pay interest on money you’ve already repaid. For the same nominal rate, a flat rate loan has a higher effective cost.

How do I calculate the reducing balance formula in Excel?

In Excel, you can use the PMT function: =PMT(rate, nper, pv) where rate is the monthly rate (APR/12), nper is the total number of payments, and pv is the loan amount (as a negative number). For the example, =PMT(0.08/12, 60, 20000) gives $405.53.

Does the reducing balance formula include compound interest?

Yes, the formula assumes monthly compounding. Each month, interest is added to the balance, and the next month’s interest is calculated on that new balance. The formula accounts for this compounding effect.

Why is my calculated payment different from the lender’s quote?

Lenders may include fees, insurance, or a slightly different rounding method. Also, the APR on a loan disclosure includes certain fees, so the actual payment may be based on a slightly different rate. Always check the lender’s itemized statement.

Can I use this formula for a mortgage with escrow?

The formula gives the principal and interest portion only. Escrow for property taxes and insurance is added on top and is not part of the loan arithmetic. Your total monthly payment will be higher than the calculator result.

The result from this calculator is an estimate; the lender’s official disclosure provides 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 | $ | 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 →