Outstanding Loan Balance Calculator and Formula

This calculator estimates an outstanding loan balance after a chosen number of monthly payments on a fixed-rate loan. Enter the original loan amount, APR, loan term, and payments already made to see the estimated remaining principal and the interest paid so far.

Formula

The balance after k scheduled payments is the original principal grown by monthly interest, minus the accumulated value of the payments made:

B_k = P(1 + r)^k − M × ((1 + r)^k − 1) / r

• B_k is the estimated outstanding balance in dollars.
• P is the starting loan principal in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 1,200.
• k is the number of monthly payments made.
• M is the fixed monthly payment in dollars, rounded to cents.

The calculator finds the scheduled payment from the standard fixed-payment formula: M = round(P × r / [1 − (1 + r)⁻ⁿ], 2), where n is the full term in months, calculated as years × 12. The result is an estimate for a regular amortizing loan. It does not model irregular payment dates or changes in the loan terms.

Worked Example

Using the defaults—$20,000 principal, 8% APR, a five-year term, and 12 payments made—the monthly rate is 0.08 ÷ 12 = 0.0066667, and the full term is 5 × 12 = 60 months.

1. Calculate the scheduled payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53 after rounding to cents.
2. Calculate the balance after 12 payments: $20,000 × (1.0066667)¹² − $405.53 × [(1.0066667)¹² − 1] ÷ 0.0066667 = $16,466.56, rounded to cents.
3. Estimate principal repaid: $20,000 − $16,466.56 = $3,533.44.

The balance is not the same as the total of the payments remaining. Future payments include interest as it accrues, while the displayed balance estimates the principal still owed at the calculation point.

Assumptions

• The interest rate is fixed for the full modeled term.
• Payments are equal, monthly, and made at the end of each monthly period; the selected payment count represents payments already made.
• Interest compounds monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, late charges, extra payments, and payment-date variations are not included.

What an Outstanding Loan Balance Means

An outstanding loan balance is the amount of principal that remains unpaid at a particular point in time. With an amortizing loan, each regular payment covers interest accrued for the period and reduces principal by whatever is left over. Early in the schedule, interest can account for a larger share of a payment; later, more of the same payment generally goes toward principal.

The term can mean different figures in different contexts. A lender’s account may show principal balance, accrued interest, unpaid fees, or a payoff amount. A payoff quote can include interest accruing through a specified date and other contract-related amounts, so it may differ from a calculator’s principal estimate. For an exact amount to settle a loan, request the dated figure and its breakdown from the loan servicer.

How to Use and Interpret the Estimate

Use the original amount borrowed—not the total of all scheduled payments—as the loan amount. Enter the APR as a percentage, such as 8 for 8%, the term in years, and the number of completed monthly payments. The payment count should ordinarily be between zero and the number of scheduled months. If your loan is still active, a count greater than its term would not describe a normal unpaid balance.

The calculator’s headline result is the estimated principal remaining. “Principal paid” is the original amount minus that balance; it is not total cash paid, because scheduled payments also cover interest. The payment result is the modeled regular installment. For example, 12 payments of $405.53 total $4,866.36, but the principal reduction in the worked example is only $3,533.44; the difference largely represents interest under the model.

For a statement comparison, use the same effective date and check how the lender applies payments. A balance shortly before a due date can differ from one immediately after a payment posts. Rounding each payment to cents can also produce a small difference from calculations that retain fractions of a cent throughout.

Why a Real Balance Can Differ

This calculation assumes a stable rate, one payment each month, and no changes to the scheduled installment. Real account balances may diverge because of a variable rate, skipped or late payments, extra principal payments, fees, payment allocation rules, or a different first payment date. A loan may also use a day-count method or compounding convention that is not represented by monthly APR/12 arithmetic.

• Extra payments: Additional amounts applied to principal can reduce the balance faster than the scheduled-payment model. Confirm how an extra payment is credited.
• Interest-only or balloon terms: The standard amortization formula may not fit a loan whose payments do not repay principal evenly over the stated term.
• Variable rates: A single APR cannot reproduce a history of changing rates. Use the applicable rate for each period or rely on the account’s current figures.
• Payoff versus balance: A payoff figure is date-specific and may include items that this principal-only estimate omits.

For planning or reconciliation, compare the estimate with a statement showing principal, accrued interest, and any other charges separately. The lender’s records reflect the actual account activity and contract terms; this formula is not a substitute for them.

Frequently Asked Questions

Is outstanding balance the same as the payoff amount?
No. The outstanding principal is the unpaid loan amount in this calculator. A payoff amount may include interest through a particular date and other amounts required to settle the account.

Does the balance include future interest?
No. It estimates principal remaining after the payments entered. Interest on future periods is generally part of future scheduled payments, not the current principal balance.

Why is my lender’s balance different?
Possible reasons include a different payment date, accrued interest, fees, a changing rate, extra or late payments, or rounding and payment-allocation methods. Compare the statement date and balance components.

Can I enter extra payments?
This calculator does not have an extra-payment input. Extra amounts may change the balance depending on when they are paid and how the servicer applies them, so the standard schedule will not capture that effect.

How do I find the exact amount to pay off a loan?
Ask the loan servicer for a payoff quote valid through your intended payment date. The calculator provides an estimate, and the lender’s disclosure gives the exact figures.

Related

• HBL Personal Loan Interest Rate: What to Check
• HBL Loan Interest Rate Calculator and Payment Estimate
• Gold Loan Balance Transfer Calculator and Cost Guide

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
in k | Payments made | - | 12 | 0 | 600
out bal | Outstanding 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 paid | Principal paid | $ | p - bal | 2