Home Loan Remaining Amount Calculator and Formula

A home loan remaining amount calculator estimates the principal balance left after a given number of monthly payments. Enter the original loan amount, annual interest rate, loan term, and payments already made; the calculator returns the estimated remaining balance and total scheduled interest for the full term.

Formula

The calculator first finds the fixed monthly payment, then applies the standard amortization balance formula after the number of payments entered:

Monthly payment: M = round[P × r / (1 − (1 + r)⁻ⁿ), 2]

Remaining balance: B = P × (1 + r)^k − M × [(1 + r)^k − 1] / r

• P is the original loan principal, in dollars.
• APR is the annual interest rate entered as a percentage.
• r is the monthly rate, calculated as APR ÷ 1,200.
• n is the full repayment term in months: years × 12.
• M is the monthly principal-and-interest payment, rounded to cents.
• k is the number of monthly payments made.
• B is the estimated principal balance after payment k, in dollars.

The total scheduled interest shown is M × n − P. It assumes every scheduled payment is made and uses the rounded monthly payment. It is interest across the entire modeled term, not interest remaining from today.

Worked Example

Using the calculator’s default values: a $20,000 loan, 8% APR, a five-year term, and 24 monthly payments made.

1. Convert the APR to a monthly rate: r = 8 ÷ 1,200 = 0.0066667.
2. Convert the term to months: n = 5 × 12 = 60.
3. Calculate the monthly payment: M = round[20,000 × 0.0066667 ÷ (1 − (1.0066667)⁻⁶⁰), 2] = $405.53.
4. Calculate the balance after 24 payments: B = 20,000 × (1.0066667)²⁴ − 405.53 × [(1.0066667)²⁴ − 1] ÷ 0.0066667 = $12,867.42.
5. Calculate total scheduled interest over the full term: $405.53 × 60 − $20,000 = $4,331.80.

The balance is not calculated by simply subtracting 24 payments from the original principal. Each payment includes interest, particularly earlier in the schedule, so the amount reducing principal varies over time.

Assumptions

• The interest rate stays fixed for the entire term.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest compounds monthly at APR ÷ 12.
• The model excludes fees, taxes, insurance, PMI, escrow, and any other charges or loan features not entered.

When to Use a Remaining-Balance Estimate

This estimate can help you understand how amortization changes the principal over time, check a rough balance for a particular payment count, or compare a mathematical schedule with loan paperwork. It is useful only when the loan follows the fixed-rate, level-payment assumptions above. A lender’s account statement or payoff quote reflects the actual loan account and is needed for an exact figure.

For a real mortgage, use the original principal and the rate and term that apply to the modeled loan period. Enter the number of payments actually posted, not simply the number of months since the loan began. If a payment was delayed, skipped, changed, or applied differently, the calculator’s result may diverge from the account balance.

How to Read the Result and Its Limits

The first result is the estimated principal remaining immediately after the entered number of regular payments. The monthly payment and total scheduled interest are supporting figures based on the same fixed-rate schedule. A balance is not the same as a payoff amount: a payoff calculation can include interest accrued since the last payment and other account-specific amounts.

APR is entered as a percentage per year, so 8% is entered as 8, not 0.08. The formula turns that into a monthly rate by dividing by 1,200. The term is entered in years, while payment count is entered as a number of monthly payments. Check these units before interpreting the output.

The calculator accepts up to 600 payments, matching the maximum 50-year term. For a meaningful schedule, the payment count should not exceed the loan’s full term in months. If it does, the formula is being applied beyond the point the loan is scheduled to be repaid and may produce an invalid or misleading balance.

Why a Lender’s Balance May Differ

Actual mortgage balances can differ because the real payment history or loan terms do not match the simplified schedule. Common causes include:

• Extra principal payments, missed or late payments, or a payment amount that changed.
• A variable rate, a rate change, or a loan structure with non-level payments.
• Daily interest calculations, payment dates, or rounding methods that differ from the monthly model.
• Fees, escrow amounts, insurance, taxes, or other charges included in a statement’s amount due.
• A remaining term or payment count that was entered incorrectly.

Do not add taxes, homeowners insurance, or escrow to the principal-and-interest payment in this formula. Those items may appear alongside a mortgage payment, but they do not reduce principal under this calculation. Extra payments also are not modeled; including them requires a payment-by-payment schedule that accounts for when the extra amount is applied.

Frequently Asked Questions

How do I calculate the remaining balance on a home loan?
Find the monthly payment from the principal, monthly interest rate, and total number of payments. Then apply the amortization balance formula using the number of payments already made, as shown above.

Is the remaining balance the same as the payoff amount?
No. The remaining balance estimates principal under the modeled schedule. A payoff amount may also include accrued interest or account-specific charges; request the current figure from the loan servicer.

Does the calculator include extra payments?
No. It assumes equal scheduled monthly payments only. Extra principal payments change the balance and may affect the timing or amount of later payments.

Why does my mortgage statement show a different balance?
The actual payment history, rate, interest method, timing, rounding, or loan features may differ from the calculator’s assumptions. Use the servicer’s account records for the actual balance.

Does the monthly payment include taxes and insurance?
No. The payment formula covers principal and interest only. Taxes, insurance, PMI, escrow, and fees are not included in the results.

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

Related

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

in p | Original loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
in k | Monthly payments made | - | 24 | 0 | 600
out bal | Remaining loan balance | $ | p * (1 + apr / 1200) ^ k - round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2
out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total scheduled interest | $ | pmt * yrs * 12 - p | 2