Loan Balance Calculator by Month: Track Your Payoff

A loan balance calculator by month estimates how much principal remains after each monthly payment, using your starting loan amount, APR, and term. Enter those figures to see the balance after a selected number of payments, plus the monthly payment and total interest under a fixed-rate, monthly-payment model.

Formula

The balance after k monthly payments is calculated as:

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

• B_k is the estimated remaining balance in dollars after k payments.
• P is the original loan principal in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. For example, 8% APR gives r = 0.08 ÷ 12.
• k is the number of monthly payments made. This calculator displays the balance after month 12.
• M is the level monthly payment in dollars, rounded to cents. It is calculated from the principal, APR, and term.

The payment formula is M = round[P × r ÷ (1 − (1 + r)⁻ⁿ), 2], where n is the number of monthly payments in the term: years × 12. The estimate of total interest is the rounded monthly payment multiplied by n, minus the original principal. It assumes those payments are made as scheduled.

Worked Example

Using the calculator’s defaults—$20,000 principal, 8% APR, and a five-year term—first convert the annual rate to a monthly rate: r = 8 ÷ 1,200 = 0.0066667. The term is n = 5 × 12 = 60 monthly payments.

1. Calculate the unrounded payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] ≈ $405.527.
2. Round the payment to cents: M = $405.53.
3. For month 12, substitute k = 12: $20,000 × (1.0066667)¹² − $405.53 × [(1.0066667)¹² − 1] ÷ 0.0066667.
4. The estimated balance after 12 payments is $16,436.67.

Over 60 payments, the calculator’s total paid is $405.53 × 60 = $24,331.80, so estimated total interest is $4,331.80. Actual lender statements can differ by a few cents or more because of payment dates, rounding practices, or other account activity.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest compounds monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, late payments, and extra principal payments are not included.

How to Read a Monthly Balance

The result is the modeled principal still owed after 12 scheduled payments; it is not the sum of the payments remaining. Each regular payment has an interest portion and a principal portion. Early in a level-payment loan, interest is calculated on a larger outstanding balance, so a smaller share of the payment reduces principal. As the balance falls, the interest portion generally falls and more of each payment goes toward principal.

To understand another month, use the same formula with that month’s payment count as k. A month-by-month schedule repeats the process: calculate interest on the opening balance, subtract that interest from the payment to find principal repaid, then subtract principal repaid from the opening balance. Small discrepancies can appear if a schedule rounds interest on every row rather than carrying full precision.

When This Estimate Is Useful

A monthly balance estimate can help you understand amortization, check how the principal changes over time, or compare a calculator result with a statement. It can also clarify why the loan balance does not drop by the entire payment amount: part of each payment covers interest under the model.

For an accurate account-specific figure, use the balance and payoff information supplied by the lender. A payoff amount on a particular date may include interest accumulated since the latest payment and other items that this calculator does not model. If the interest rate changes, payments are irregular, or extra payments are applied, a fixed-payment estimate will no longer describe the account precisely.

Common Mistakes and Limits

• Mixing annual and monthly rates: APR is entered as a percent per year, so the monthly rate in this formula is APR ÷ 1,200—not APR ÷ 12 when APR is written as a whole number like 8.
• Using the wrong month count: A five-year term means 60 monthly payments. The displayed balance is specifically after 12 payments; it does not change the term to one year.
• Expecting the initial amount minus payments: That subtraction ignores interest charged along the way. The balance formula accounts for monthly interest before measuring principal reduction.
• Confusing APR with every possible borrowing cost: The calculation uses the APR as a nominal annual rate divided into monthly periods. It does not separately model fees or a different effective compounding convention.
• Expecting exact payoff figures: Payment posting dates, daily interest, rate changes, skipped or late payments, and lender rounding can alter a real balance. This is an estimate, not an account statement.

Frequently Asked Questions

How do I calculate my loan balance after 12 months?
Use the balance formula with k = 12, the monthly rate equal to APR ÷ 1,200, and the scheduled monthly payment. The calculator applies that method to its entered principal, rate, and term.

Why is my balance higher than the loan amount minus payments made?
Because some of each payment covers interest. Only the remainder reduces principal, and the interest portion is calculated from the outstanding balance under the loan’s terms.

Does this calculator include extra payments?
No. It assumes the same scheduled payment every month. Extra payments that are applied to principal generally change the balance path and may affect the payoff timeline.

Can I use this for a variable-rate loan?
Only as a simplified estimate for a period when the rate remains unchanged. A changing rate requires recalculating with the applicable rate and payment for each period.

Why does my lender show a different payoff balance?
A dated payoff quote may include accrued interest, payment timing, fees, or other account-specific adjustments. The calculator omits those details, so check the lender’s disclosure or account information for exact figures.

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

Related

• Energy Balance: Calculate Intake Minus Expenditure
• How to Balance a T Account: Steps and Examples
• Beginning Balance: How to Calculate It

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
out bal | Balance after month 12 | $ | p * (1 + apr / 1200) ^ 12 - round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * ((1 + apr / 1200) ^ 12 - 1) / (apr / 1200) | 2
out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2