calculate-loan

01 Loan payments

Refinance Principal Balance Formula

Calculator No. 01-23596 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

To find your refinance principal balance, use the formula: B = P × (1 + r)^n − PMT × [((1 + r)^n − 1) / r], where B is the remaining balance, P is the original loan amount, r is the monthly interest rate (APR ÷ 12), n is the number of payments already made, and PMT is your monthly payment. This formula calculates exactly how much of your original loan principal is still unpaid after a certain number of payments, which is the amount you would need to refinance.

Formula

The refinance principal balance formula is the standard amortization balance formula, written as:

B = P × (1 + r)^k − PMT × [((1 + r)^k − 1) / r]

Where:

  • B = remaining principal balance (in dollars)
  • P = original loan amount (in dollars)
  • r = monthly interest rate = annual APR ÷ 12 (as a decimal, e.g., 8% APR → r = 0.08/12 = 0.006666…)
  • k = number of monthly payments already made
  • PMT = fixed monthly payment (in dollars), calculated as PMT = P × r × (1 + r)^N / ((1 + r)^N − 1), where N is the total number of payments in the original term (years × 12)

This formula assumes a fixed interest rate, level monthly payments, and that payments are made at the end of each month (ordinary annuity). The result is the outstanding principal after exactly k payments.

Worked Example

Using the default values from the calculator: original loan amount P = $20,000, APR = 8%, term = 5 years (N = 60 months), and k = 12 payments made.

  1. Monthly interest rate: r = 8 / 1200 = 0.0066666667
  2. Monthly payment: PMT = 20000 × 0.0066666667 × (1.0066666667)^60 / ((1.0066666667)^60 − 1) = $405.53 (rounded to the cent)
  3. Balance after 12 payments: B = 20000 × (1.0066666667)^12 − 405.53 × [((1.0066666667)^12 − 1) / 0.0066666667]
  4. Calculate (1.0066666667)^12 ≈ 1.0829995
  5. 20000 × 1.0829995 ≈ 21659.99
  6. ((1.0829995 − 1) / 0.0066666667) ≈ 12.4499
  7. 405.53 × 12.4499 ≈ 5048.96
  8. B ≈ 21659.99 − 5048.96 = 16611.03

The calculator shows a remaining balance of $16,611.03, matching this step-by-step calculation.

Assumptions

  • Fixed interest rate for the entire original term; the formula does not apply to adjustable-rate loans where r changes.
  • Payments are made monthly at the end of each month; if payments are biweekly or at the beginning of the month, the balance will differ.
  • Compounding is monthly at APR/12, which is the standard for most amortizing loans.
  • The formula does not include fees, taxes, insurance, PMI, escrow, or any prepayment penalties; those are separate costs that do not affect the principal balance calculation.

Why You Need the Principal Balance for Refinancing

When you refinance, the new loan pays off your existing loan. The amount the new lender sends to your old lender is your current principal balance, not the original loan amount. Knowing this number helps you estimate your new monthly payment and total interest, because the new loan’s principal is that balance (plus any refinance fees you roll in). The formula gives you a precise figure at any point in your loan’s life, without waiting for a statement from your lender.

How to Use the Formula in Practice

To use the formula, you need four pieces of information from your current loan documents:

  • Original loan amount (P)
  • Annual interest rate (APR) that was fixed at origination
  • Total term in months (N), which is years × 12
  • Number of payments made so far (k), which you can count from your payment history

Once you have these, plug them into the formula or use the calculator above. If you have made extra payments or have missed payments, the formula will not be accurate because it assumes exactly k regular payments. In that case, contact your lender for the exact payoff amount, which also includes any accrued interest up to the payoff date.

Common Mistakes and Misconceptions

A frequent error is using the annual rate directly in the exponent. Always divide the APR by 12 to get the monthly rate, and use the number of months, not years, for k and N. Another mistake is confusing the remaining balance with the payoff amount: the payoff amount includes interest accrued since your last payment and any fees, so it is slightly higher than the principal balance. Also, some people think the balance declines linearly (e.g., after half the term, half the principal is left), but amortization means early payments are mostly interest, so the principal balance drops slowly at first and faster later.

When the Formula Doesn’t Apply

This formula assumes a fixed-rate, fully amortizing loan with level payments. It does not work for:

  • Adjustable-rate mortgages (APR changes over time)
  • Interest-only loans (where payments do not reduce principal)
  • Balloon loans (where the final payment is large)
  • Loans with irregular payments or skipped payments
  • Loans with prepayment penalties that affect the payoff amount

For those, you need the lender’s amortization schedule or a more complex calculation that accounts for changing rates and payment amounts.

Frequently Asked Questions

Is the principal balance the same as the payoff amount?

No. The principal balance is the outstanding loan amount before any interest accrues. The payoff amount is what you actually need to pay on a specific date, including interest accrued since your last payment, any late fees, and sometimes a prepayment penalty. The payoff amount is usually a few days’ worth of interest higher than the principal balance.

Can I use this formula if I’ve made extra payments?

No, not directly. Extra payments reduce your principal faster, so the standard formula overestimates the remaining balance. To get an accurate figure, you would need to recalculate the balance after each extra payment, or simply ask your lender for a payoff quote.

What if my interest rate is variable?

This formula only works with a fixed rate. For an adjustable-rate loan, the balance depends on the specific rate changes over time. You can use the formula for each period with a constant rate, but you must know the rate history and payment schedule. In practice, your lender’s statement shows the current balance.

How often should I calculate my principal balance?

It is useful to calculate it whenever you are considering refinancing, making a large extra payment, or selling the property. For ongoing tracking, your monthly statement shows the balance, but the formula helps you verify that number and understand how much principal you’ve paid off.

Does the formula include refinance closing costs?

No. The formula only computes the remaining principal of your existing loan. Refinance closing costs are separate and are either paid out of pocket or added to the new loan amount. If you roll costs into the new loan, the new principal will be higher than the balance you calculated.

Why does my lender’s balance differ slightly from my calculation?

Lenders often round the monthly payment to the cent, and the formula uses the exact payment. Also, your lender may use a slightly different rounding method or include a day or two of interest in the displayed balance. Small differences of a few dollars are normal; if you need an exact number, request a payoff statement.

This calculation is an estimate; your lender’s payoff statement provides the exact figures for refinancing.

Related

Formula used
in p | Original loan amount | $ | 20000 | 1 | 100000000
in apr | Original interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Original loan term | years | 5 | 0.0833 | 50
in k | Payments already made | months | 12 | 0 | 600
out bal | Remaining principal balance | $ | p * (1 + apr / 1200) ^ k - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2
out paid | Total paid so far | $ | (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * k | 2
out int | Interest paid so far | $ | paid - (p - bal) | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →