calculate-loan

01 Loan payments

Principal Balance Calculation: How It Works

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

Remaining principal $16,611.20
Principal paid so far
$3,388.80
= Loan amount − remaining principal
Monthly payment
$405.53
Level-payment formula, rounded to the cent
Loan amount
$20,000
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years), Payments made (months)
You get
Remaining principal ($), Principal paid so far ($), Monthly payment ($)
Rounding
2 dp

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.

This calculator works out the remaining principal balance on a loan after a certain number of payments, which is the amount you still owe before interest. You enter the original loan amount, annual interest rate (APR), loan term, and the number of payments already made, and it returns the outstanding principal. This is the figure your lender uses when you ask for a payoff quote, and it is also what you need to track if you are considering extra payments.

Formula

The remaining principal balance after k payments is calculated using the standard amortization formula:

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

Where:

  • Bk = remaining principal balance after k payments (in $)
  • P = original loan amount (in $)
  • r = monthly interest rate = APR / 1200 (as a decimal, e.g., 8% APR → 0.0066667)
  • k = number of payments already made (in months)
  • PMT = the level monthly payment, calculated as P × r / [1 − (1 + r)−n], where n = total number of payments (years × 12)

The first part, P × (1 + r)k, grows the original loan by interest for k months. The second part subtracts the accumulated value of all the payments you have made, each also growing at the monthly rate. The difference is exactly what you still owe.

Worked Example

Using the default values: loan amount $20,000, APR 8%, term 5 years, and 12 payments made.

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. Total payments n = 5 × 12 = 60
  3. Monthly payment PMT = 20000 × 0.0066667 / (1 − (1.0066667)−60) = 20000 × 0.0066667 / (1 − 0.67121) = 20000 × 0.0066667 / 0.32879 = 20000 × 0.020276 = $405.53 (rounded to cents)
  4. Balance after 12 payments: B = 20000 × (1.0066667)12 − 405.53 × [((1.0066667)12 − 1) / 0.0066667]
  5. (1.0066667)12 = 1.082999
  6. B = 20000 × 1.082999 − 405.53 × (0.082999 / 0.0066667) = 21659.98 − 405.53 × 12.4499 = 21659.98 − 5048.84 = $16,611.14

So after one year, you still owe about $16,611.14. The calculator shows the same result: $16,611.14.

Assumptions

  • Fixed interest rate for the entire loan term (no adjustable-rate changes).
  • Payments are made exactly on time each month, at the end of each month.
  • Interest compounds monthly at APR / 12, which is standard for most amortizing loans.
  • The monthly payment is rounded to the cent, and the balance calculation uses that rounded payment.
  • This calculation does not include fees, taxes, insurance, PMI, or escrow amounts. Those are separate and would change the actual payoff figure.

Why the Balance Matters

Knowing your principal balance is useful for several practical reasons. When you request a payoff quote from a lender, the amount includes accrued interest up to the payoff date plus any fees, but the core number is the principal balance. If you are planning to sell a home or a car, the outstanding balance tells you how much you need to pay off to transfer the title. For those considering extra payments, the current balance is the starting point for calculating how much interest you might save.

The balance also appears on your monthly statement, but it is often the total balance (principal plus interest accrued since the last payment). The formula here gives the principal-only amount, which is what you would owe if you paid immediately after a payment date.

How to Read the Result

The main output, Remaining principal, is the amount you owe before any interest that has accrued since your last payment. The second output, Principal paid so far, is simply the original loan amount minus the remaining balance. This is the portion of your payments that has actually reduced the debt, as opposed to interest.

Early in the loan, the principal paid is small because most of each payment goes to interest. For the example above, after 12 payments you have paid $405.53 × 12 = $4,866.36 in total, but only $3,388.86 of that reduced the principal ($20,000 − $16,611.14). The rest, $1,477.50, went to interest. This is normal amortization.

Common Mistakes

  • Using the annual rate instead of the monthly rate. Always divide the APR by 1200 (or 12, if you use a decimal rate). Forgetting this makes the balance far too high.
  • Entering the term in months instead of years. The calculator expects years, so a 5-year loan is 5, not 60. If you enter 60, the payment becomes tiny and the balance after 12 payments will be wrong.
  • Counting the payment number incorrectly. If you have made 12 payments, k = 12. If you have made 0 payments, the balance equals the original loan amount.
  • Rounding intermediate values. The formula uses the exact monthly rate, not a rounded version. Rounding the rate to 0.0067 instead of 0.0066667 can change the balance by a few dollars over a long term.

Limits of the Formula

This amortization formula assumes a fixed rate and a fixed payment for the entire term. It does not handle:

  • Adjustable-rate loans where the rate changes after a certain period.
  • Interest-only periods, where the payment does not cover principal for a while.
  • Balloon payments, where the final payment is much larger than the regular payment.
  • Biweekly payment schedules, which reduce the balance faster because you make 26 half-payments per year.
  • Late fees or missed payments, which add interest and penalties.

For those situations, you need a more detailed amortization schedule that accounts for the specific payment pattern. The formula here is the standard for level-payment, fixed-rate loans, which covers most mortgages, auto loans, and personal loans.

Using the Balance for Extra Payments

If you make an extra payment directly toward the principal, the balance drops immediately, and the interest that would have accrued on that amount is avoided. To see the effect, you can run this calculator with a lower loan amount or a shorter term. For example, if you pay an extra $1,000 after 12 months on the default loan, the new balance is $16,611.14 − $1,000 = $15,611.14. The remaining interest over the next 48 months will be less than originally planned.

Note that some lenders apply extra payments to future interest unless you specify that it goes to principal. Always tell the lender to apply the extra amount to the principal balance. This calculator shows the principal-only effect, which is the best-case scenario for reducing interest.

Frequently Asked Questions

What is the difference between principal balance and payoff amount? The principal balance is the amount you owe before any interest has accrued since your last payment. The payoff amount includes the principal plus interest accrued up to the day you pay, plus any fees (like a payoff statement fee or prepayment penalty). The payoff amount is usually slightly higher than the principal balance.

Why is my principal balance not going down by the full payment amount? Because each payment is split into interest and principal. Early in the loan, interest is high because the outstanding balance is large, so only a small portion of your payment reduces the principal. As the balance decreases, more of each payment goes to principal.

Can I use this formula for a mortgage with escrow? No. This formula only covers the loan principal and interest. Escrow for property taxes and insurance is a separate amount added to your monthly payment, but it does not affect the principal balance calculation. Your actual monthly payment will be higher than the payment shown here if escrow is included.

How do I find my current principal balance? Your lender’s monthly statement shows the total balance, which includes interest accrued since the last payment. To get the principal-only balance, you can use this calculator with the number of payments you have made, or call your lender for an official payoff quote. The statement may also list the principal balance separately.

What happens if I make an extra payment? If you make an extra payment and specify it goes to principal, your balance drops immediately, and you will pay less interest over the life of the loan. You can either keep the same monthly payment and pay off the loan early, or recast the loan to lower your payment (if allowed). This calculator can show the new balance after the extra payment.

Does the balance calculation work for a loan with a variable rate? No, because the formula assumes a constant interest rate. For a variable-rate loan, you would need to recalculate the balance each time the rate changes, using the new rate for the remaining term. This calculator gives an estimate only for fixed-rate loans.

This result is an estimate based on the inputs you provide; the lender’s official payoff statement gives the exact amount due.

Related

Formula used
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 | months | 12 | 0 | 600
out bal | Remaining principal | $ | p * (1 + apr / 1200) ^ k - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2
out paid | Principal paid so far | $ | p - bal | 2
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 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 →