Home Loan Reducing Balance Calculator and Formula

A home loan reducing balance calculator estimates the monthly principal-and-interest payment and total interest when interest is charged on the amount still owed. Enter the loan amount, annual interest rate and term to see the scheduled payment and the total interest over the full term.

Formula

This calculator uses the standard fixed-payment, reducing-balance amortization formula. It first calculates a monthly payment, rounds that payment to the nearest cent, then multiplies it by the number of monthly payments to estimate total interest.

• Monthly payment: M = round[P × r ÷ (1 − (1 + r)⁻ⁿ), 2]
• Total interest: I = M × n − P

P is the loan principal in dollars; APR is the annual percentage rate entered as a percentage; r is the monthly rate, APR ÷ 1,200; n is the number of monthly payments, loan term in years × 12; M is the monthly principal-and-interest payment in dollars; and I is the estimated total interest in dollars. The rate must be above zero for this formula.

Worked Example

Using the calculator’s defaults: principal P = $20,000, APR = 8%, and term = 5 years.

1. Convert the annual rate to a monthly rate: r = 8 ÷ 1,200 = 0.0066667.
2. Convert the term to monthly payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: M = round[20,000 × 0.0066667 ÷ (1 − (1.0066667)⁻⁶⁰), 2] = $405.53 per month.
4. Calculate interest using the rounded payment: I = $405.53 × 60 − $20,000 = $4,331.80.

The displayed total is the scheduled payments minus the original principal. Because the payment is rounded to cents, a real lender’s final payment can differ slightly if it adjusts the last installment or uses a different day-count method.

Assumptions

• The interest rate remains fixed for the entire term.
• Payments are equal monthly installments, made at the end of each monthly period.
• Interest accrues monthly using APR divided by 12; this is a simplified monthly compounding model.
• The calculation excludes lender fees, taxes, homeowners insurance, mortgage insurance, escrow, and any other charges because there are no inputs for them.
• No extra payments, missed payments, rate changes, or changes to the loan balance are modelled.

What a Reducing Balance Means

With a reducing-balance loan, each interest charge is calculated against the outstanding principal rather than the original amount borrowed for every month of the loan. A scheduled payment covers the interest accrued for that period and pays down some principal. As principal falls, the interest portion of later payments generally falls too, while the principal portion rises, assuming the rate and payment stay fixed.

This differs from a simple flat-rate illustration that applies interest to the original principal throughout the term. A flat-rate figure and a reducing-balance APR are not directly interchangeable: they describe interest using different calculation methods. Check the lender’s payment schedule and disclosures to understand the actual rate basis and charges.

How to Use and Read the Result

Enter the amount borrowed, the annual rate quoted for the loan, and the repayment term in years. Use the rate and term that apply to the loan being estimated, rather than a rate or fee guessed from a general example. The default values are only a demonstration; obtain the applicable figures from the lender.

• Monthly payment is the estimated amount allocated to principal and interest under the model. It is not necessarily the full monthly housing cost.
• Total interest estimates interest paid if all scheduled payments are made and the terms remain unchanged.
• Total scheduled outlay can be inferred as principal plus displayed interest. It does not include excluded costs such as taxes or insurance.

The payment formula is designed for regular, level installments. A home loan may have an introductory or adjustable rate, a different payment frequency, fees added to the balance, or other contractual details. Those can change the payment or total cost and are not represented unless separately included in the inputs.

Common Mistakes and Limits

• Entering a decimal instead of a percentage: Enter 8 for 8% APR, not 0.08. The formula divides the percentage by 1,200 to obtain a monthly decimal rate.
• Mixing years and months: This calculator expects years. A 30-year term is entered as 30, not 360.
• Treating the payment as the full housing bill: Principal and interest do not automatically include taxes, insurance, mortgage insurance, utilities, or maintenance.
• Assuming every loan has a fixed rate: If the interest rate changes, this fixed-rate estimate cannot forecast later payments. Recalculate using the applicable rate for a simple scenario, while recognizing that future terms may differ.
• Ignoring payment rounding: The monthly installment is rounded to cents before total interest is calculated. A lender may use a different schedule or adjust the final payment.

This is an estimate, not a lender’s amortization schedule. It does not determine eligibility, affordability, taxes, or legal obligations. Use the lender’s stated APR, payment schedule, and itemized charges for the specific loan.

Frequently Asked Questions

What is a reducing balance home loan?
A reducing balance loan calculates interest on the principal still outstanding. Regular payments reduce principal over time, so later interest charges are generally based on a smaller balance when the rate is unchanged.

How do I calculate a home loan payment on a reducing balance?
Convert APR to a monthly decimal by dividing by 1,200, convert years to months by multiplying by 12, and apply the level-payment formula shown above. This calculator performs those steps and rounds the payment to cents.

Does a reducing balance calculator include taxes and insurance?
No. This calculator estimates principal and interest only. Taxes, insurance, mortgage insurance, escrow and fees are excluded unless entered into a calculator designed to model them.

Why does the interest part of a payment change?
For a fixed-rate, level-payment loan, interest is calculated on the remaining balance. As scheduled payments reduce principal, less interest is due in later periods, leaving more of the same payment to reduce principal.

Can I use this calculator for a variable-rate home loan?
It can show a simplified scenario at one entered rate, but it cannot predict future rate changes. A changing rate can alter payments and total interest; use the lender’s loan terms for applicable payment details.

The result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Home Equity Loan Calculator: Amount Up to a CLTV Limit and Payment
• Mortgage Calculator With Escrow: Payment With Tax and Insurance
• Mortgage Loan Amount Calculator: The Loan a Monthly Payment Repays

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