Monthly Loan Balance Calculator: See What You Owe

A monthly loan balance calculator estimates how much principal remains after a chosen number of monthly payments on a fixed-rate loan. Enter the original loan amount, annual interest rate, loan term, and number of payments made to see the estimated remaining balance and the scheduled monthly payment.

Formula

The calculator uses the standard amortization formula for a fixed-rate loan with equal monthly payments. It first calculates the monthly payment, then applies that payment and monthly interest to find the remaining balance after the specified number of payments.

Monthly rate: r = APR / 1200, where APR is entered as a percentage per year.
Number of scheduled payments: n = 12 × loan term in years.
Monthly payment: M = P × r / [1 − (1 + r)⁻ⁿ]. The calculator rounds M to cents for the payment and total-interest outputs.
Balance after k payments: B_k = P(1 + r)^k − M × [(1 + r)^k − 1] / r.
Total scheduled interest: I = M × n − P.

P is the original principal in dollars, r is the monthly interest rate as a decimal, M is the monthly payment in dollars, n is the scheduled payment count, and k is the number of payments already made. For example, an APR of 8% becomes a monthly rate of 0.08 / 12, or about 0.006667. The balance formula assumes payments are made at the end of each month.

Worked Example

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

Monthly payment before rounding: $20,000 × 0.0066667 / [1 − (1.0066667)⁻⁶⁰] ≈ $405.53. Rounded to cents, the payment is $405.53.
Balance after 12 payments: $20,000(1.0066667)¹² − $405.53 × [(1.0066667)¹² − 1] / 0.0066667 ≈ $16,539.91.
Total scheduled interest: $405.53 × 60 − $20,000 = $4,331.80.

These are estimates based on the displayed formula and payment rounded to the cent. A lender’s actual payment schedule can differ if its rounding, payment dates, or interest calculation method differs.

Assumptions

The interest rate is fixed for the full term.
Payments are equal, made monthly at the end of each period, and the entered payment count does not exceed the scheduled term.
Interest is compounded monthly using APR / 12.
Fees, taxes, insurance, PMI, escrow, skipped or late payments, and extra principal payments are not included.

When to Use a Monthly Balance Calculator

This calculation is useful when you want an estimate of principal still owed at a point in a standard repayment schedule. You can use it to understand how amortization changes the balance over time, check a planned payoff date against an estimate, or compare the balance at different payment counts. It does not access an account or retrieve a lender’s current payoff figure.

To inspect a particular month, enter the number of payments already completed. For example, 12 means one year of monthly payments on a schedule with no skipped months. The first output is the balance after that many payments. The monthly payment and total interest outputs describe the original scheduled loan, not just the period elapsed.

How to Read the Balance and Common Errors

Early in a fully amortizing loan, a larger share of each payment generally goes toward interest because interest is calculated on a larger outstanding principal. As the balance falls, the interest portion decreases and more of each fixed payment reduces principal. The payment itself remains level under the model’s fixed-rate assumptions.

APR entry: Enter 8 for 8%, not 0.08. The formula divides the entered percentage by 1,200 to obtain a monthly decimal rate.
Payment count: Count payments actually made, not calendar months since the loan began. A payment made late or skipped can change the real balance.
Rounding: The example uses a monthly payment rounded to cents. A lender may keep additional precision internally or apply rounding differently, so small differences are possible.
Loan term: A term of five years represents 60 scheduled monthly payments. The balance formula is intended for payment counts from zero through the scheduled term.

A balance is not necessarily the amount required to close a loan on a particular day. A payoff quote may account for interest accrued since the last payment and other contract-specific amounts. Request a current payoff figure from the lender when an exact amount is needed.

What This Estimate Does Not Model

The calculator treats the entered APR as a fixed annual rate and models equal monthly payments. It does not include variable-rate changes, payment holidays, additional principal, fees added to the balance, or a different payment frequency. Those changes can make a real loan’s balance differ from the calculated schedule. If extra payments are made, the number of payments and interest charged may change; this calculator has no extra-payment input.

For a loan with an adjustable rate, the fixed-rate result is only a simplified illustration for the rate entered. To estimate a changing-rate loan, the rate changes and their effective dates would need to be modeled period by period. Use the rate, balance, and schedule shown in the lender’s own documents for account-specific figures.

Frequently Asked Questions

How do I calculate my loan balance after 12 monthly payments?
Convert the APR to a monthly rate by dividing it by 1,200, calculate the level monthly payment for the loan term, then apply the balance formula with k = 12. The calculator performs these steps using the values entered.

Why does my balance fall slowly at first?
Interest for each period is based on the remaining principal. When the balance is high, more of a fixed payment covers that period’s interest, leaving less to reduce principal. As principal falls, the interest portion generally declines.

Does the balance include interest?
The displayed balance is the estimated remaining principal under the modeled schedule. It is not necessarily a same-day payoff amount, which may include interest accrued after the last payment and other amounts determined by the loan terms.

Can I use this for a loan with extra payments?
Not precisely. The formula assumes only the regular level payment. Extra principal payments generally change the subsequent balance and payoff schedule, and this calculator has no field for them.

Why does the calculator differ from my lender’s balance?
Possible reasons include payment dates, daily rather than monthly interest calculations, rounding conventions, fees, rate changes, late or additional payments, or a difference between principal balance and payoff amount. The lender’s account statement or payoff quote reflects its records and terms.

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

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 | - | 12 | 0 | 600
out bal | Balance after payments | $ | p * (1 + apr / 1200) ^ k - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest over term | $ | pmt * yrs * 12 - p | 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.