Loan Repayment Calculator: Reducing Balance Explained

A reducing-balance loan repayment calculator estimates a fixed monthly payment and the total interest for a loan whose interest is charged on its outstanding balance. Enter the loan amount, annual percentage rate (APR), and term to see the estimated payment and interest; as you repay principal, the balance—and usually the interest charged each month—falls.

Formula

The calculator uses the standard level-payment amortization formula for a fixed-rate loan with monthly payments:

Payment = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the amount borrowed, in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 1,200. For an 8% APR, r = 8 ÷ 1,200.
• n is the number of monthly payments: loan term in years × 12.
• Payment is the estimated monthly amount, in dollars.

Total interest is calculated as monthly payment × number of payments − principal. The payment is displayed to the nearest cent, and the interest estimate uses that displayed, rounded payment. Actual lender calculations may account for payment dates, daily interest, fees, or rounding differently.

Worked Example

Using the calculator defaults—$20,000 principal, 8% APR, and a five-year term:

1. Convert APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667.
2. Find the number of payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
4. The estimated monthly payment is $405.53.
5. Total of the rounded payments: $405.53 × 60 = $24,331.80. Estimated total interest: $24,331.80 − $20,000 = $4,331.80.

Assumptions

• The APR remains fixed throughout the loan term.
• Payments are equal, made monthly, and are assumed to be on schedule.
• Interest is modelled monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, late charges, and other costs are not included.

How Reducing-Balance Repayment Works

With reducing-balance repayment, interest for a period is calculated from the principal still owed, rather than repeatedly from the original loan amount. A regular payment first covers interest accrued for that period; whatever remains reduces principal. The following period’s interest is then calculated on the lower balance.

For example, at a monthly rate of 0.0066667, a $20,000 balance accrues about $133.33 in interest for one month under a simple monthly model. From a $405.53 payment, about $272.20 goes toward principal. As the balance declines, the interest portion generally shrinks and the principal portion grows, while the scheduled payment stays level.

This is also called amortizing repayment. It differs from a structure where interest is calculated on the original principal for every period. However, the label alone does not establish every detail of a particular loan: check the contract or lender’s disclosure for its interest method, payment schedule, and any fees.

How to Use and Read the Estimate

Enter the principal amount, the quoted annual APR as a percentage, and the term in years. The calculator assumes monthly payments and a fixed rate. Use the APR and term that apply to the specific offer, rather than substituting a rate from an advertisement or an estimate. If the lender provides a payment schedule, compare its assumptions with this calculator’s.

• Monthly payment is the modelled amount due each month toward principal and interest.
• Total interest is the estimated interest over all scheduled payments, not the total amount repaid.
• Total repaid in this model can be found by adding principal and estimated interest.

These figures describe loan arithmetic, not a complete household budget or an approval decision. A payment figure here does not include costs that are outside the inputs, and it does not establish what a person can afford or whether a lender will approve an application.

Common Mistakes and Calculator Limits

• Entering a percentage incorrectly: Type 8 for 8% APR, not 0.08. The formula converts the annual percentage to a monthly decimal.
• Mixing years and months: The term input is in years; the formula multiplies it by 12. A five-year term means 60 monthly payments.
• Treating APR as the exact periodic rate: APR is an annual figure. This calculator applies APR ÷ 12 as the monthly rate; a lender may use different timing or conventions.
• Assuming the result includes every borrowing cost: This model has no inputs for fees or other charges. The disclosed payment may therefore differ.
• Ignoring extra or missed payments: The formula assumes the stated payment is made on schedule. Additional principal payments, payment holidays, late payments, or a changing rate alter the balance and total interest.

The formula is a useful estimate for a fixed-rate, fully amortizing loan with regular monthly payments. It is not a complete schedule for a variable-rate loan, an interest-only period, a balloon payment, or a loan with irregular dates unless those features are separately modelled.

Frequently Asked Questions

What does reducing balance mean on a loan?
It means interest is calculated on the remaining principal balance. As principal is repaid, the balance falls, so the interest charged in later periods generally falls too.

Does a reducing-balance loan payment decrease every month?
Not necessarily. With a fixed rate and level-payment amortization, the scheduled payment remains the same, but its interest portion usually decreases while the principal portion increases. Variable rates or changing payment terms can change the amount due.

Is reducing balance the same as amortization?
They are closely related terms in this context. An amortizing loan repays principal over time through scheduled payments, and interest is commonly assessed on the outstanding balance. The exact contract terms determine the calculation method.

Why does my lender’s payment differ from this calculator?
Possible reasons include fees, payment timing, daily rather than monthly interest calculations, a different APR or term, rounding, or insurance and other amounts included in the bill. Check the lender’s itemized disclosure and payment schedule.

Can I use this calculator for extra repayments?
Not directly. It estimates the original scheduled payment and interest under regular level payments. Extra payments reduce principal sooner and can change payoff timing and interest, so they require a balance-by-period calculation that includes their amounts and dates.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

• Loan Payment Calculator Excel: Formula and Example
• Loan Payment Calculator Comparison: What the Numbers Mean
• Loan Payment Calculator: How Compounding Interest Works

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