Loan Balance Calculator

The loan balance calculator answers a focused question: after a certain number of scheduled payments, how much principal is still outstanding? It reconstructs the regular payment from the original loan amount, annual rate, term, and payment frequency. Then it applies the selected number of payments and solves for the remaining balance. This is different from a new-loan payment calculator. It is for an existing installment loan where you want to estimate today’s principal, equity, or payoff starting point.

Use it for fixed-rate mortgages, auto loans, personal loans, equipment loans, or other amortizing debt with regular payments. For a new borrowing decision, use the loan calculator. For home purchase payment estimates, use the mortgage calculator. To see the entire payment schedule, use the amortization calculator.

How to use this calculator

Enter the original loan amount, annual interest rate, original term in years, and number of payments already made. Then choose the payment frequency that matches the contract. If the loan is monthly and you have paid for five years, enter 60 payments. If it is biweekly and you have paid for five years, enter 130 payments. Mixing years and payment counts is one of the most common ways to get a wrong balance.

The calculator rounds the total scheduled payments to the nearest whole number and caps completed payments at that total. It accepts a zero interest rate. When the rate is zero, the regular payment is simply principal divided by total payments, and the balance declines evenly. With a positive rate, it uses the standard amortization formula.

Formula used by the calculator

The total number of scheduled payments is:

$\text{total payments} = \text{term years} \times \text{payments per year}$

The periodic interest rate is:

$\text{periodic rate} = \frac{\text{annual rate}}{100 \times \text{payments per year}}$

For a positive rate, the regular payment is:

$\text{regular payment} = \frac{\text{loan amount} \times \text{periodic rate}}{1 - (1 + \text{periodic rate})^{-\text{total payments}}}$

After the completed payments, the balance is:

$\text{balance} = \text{loan amount} \times (1 + \text{periodic rate})^{\text{completed payments}} - \text{regular payment} \times \frac{(1 + \text{periodic rate})^{\text{completed payments}} - 1}{\text{periodic rate}}$

For a zero-rate loan, the balance is:

$\text{balance} = \text{loan amount} - \text{regular payment} \times \text{completed payments}$

The displayed balance is floored at zero so rounding does not create a tiny negative balance at the end of the term.

Worked example matching the default inputs

Use an original loan amount of $250,000, an annual interest rate of 6.5%, an original term of 30 years, 60 payments already made, and monthly frequency. Monthly frequency means 12 payments per year, so the total payment count is 360. The periodic rate is 6.5% divided by 12, or about 0.5417% per month.

The regular payment from the amortization formula is $1,580.17. After 60 monthly payments, the remaining balance formula gives $234,027.44. The principal repaid is therefore $15,972.56, even though the borrower has made 60 payments totaling about $94,810. The difference is interest: early payments on a long fixed-rate loan devote a large share to interest before principal reduction accelerates.

The calculator also reports 300 payments remaining and 25.00 years of remaining term. The periodic rate shown in the result is 0.54%, matching the monthly rate rounded for display. If the payments-made entry were 360 or higher, the completed-payment count would be capped at 360 and the balance would display as $0.00.

How it helps borrowers

Remaining balance is the starting point for many decisions. A homeowner can compare the balance with a sale price to estimate equity before transaction costs. A car owner can compare the balance with trade-in value to see whether the loan is underwater. A borrower considering extra payments can estimate the current principal, then test accelerated payoff with the mortgage-acceleration calculator or bi-weekly mortgage payment calculator.

The result can also help check a lender statement. If your estimate is close to the statement balance, the loan is probably following the expected schedule. If it is far off, there may be extra principal payments, late fees, deferment, interest-rate changes, payment holidays, or escrow items that this calculator does not model. For a temporary payment pause, use the deferred-payment-loan calculator instead of forcing skipped months into this scheduled-payment model.

Caveats and payoff quotes

This calculator estimates principal balance, not the exact payoff amount. A payoff quote can include interest accrued since the last payment, recording fees, late charges, escrow shortages, or other contract items. Mortgages often accrue daily interest between payments. Auto and personal loans may have payoff procedures that differ from statement balances. Always request an official payoff quote before selling collateral, refinancing, or mailing a final payment.

The calculator also assumes a fixed rate and regular payments. Adjustable-rate loans need the actual rate history. Loans with extra payments need an amortization record that applies each extra amount on the correct date. Revolving credit cards do not fit this formula because balances, purchases, rates, and minimum payments change continuously.

Sources

• Consumer Financial Protection Bureau, Mortgage resources — consumer guidance on mortgage payments, balances, and loan terms.
• Consumer Financial Protection Bureau, What is a Loan Estimate? — explanation of loan cost disclosures and borrower review.
• Freddie Mac, Refinancing — homeowner education on using balance, rate, and term information when comparing refinance options.