Loan Running Balance Calculator and Formula

A loan running balance is the amount of principal still unpaid after a specified number of payments. This calculator estimates the balance after a chosen number of monthly payments on a fixed-rate loan; enter the original loan amount, APR, term, and payments made to see the remaining balance and related payment figures.

Formula

The running balance after k regular payments is the original principal grown by interest for k periods, minus the accumulated value of the payments already made:

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

• B_k is the balance after k monthly payments, in dollars.
• P is the amount borrowed, in dollars.
• r is the monthly interest rate as a decimal, calculated here as APR ÷ 1,200.
• k is the number of payments made, in months. This calculator fixes it at 12.
• M is the monthly payment in dollars, rounded to the nearest cent.

The payment is calculated from the standard level-payment formula: M = round(P × r ÷ (1 − (1 + r)⁻ⁿ), 2), where n is the total number of monthly payments, or years × 12. Total interest in the calculator is the sum of all scheduled payments minus the original principal: I = M × n − P. Because the payment is rounded to cents, the total is based on that rounded amount.

Worked Example

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

1. Monthly payment: $20,000 × 0.0066667 ÷ (1 − (1.0066667)⁻⁶⁰) = $405.53, rounded to cents.
2. Total scheduled payments: $405.53 × 60 = $24,331.80.
3. Total interest estimate: $24,331.80 − $20,000 = $4,331.80.
4. After 12 payments, the balance formula gives approximately $16,434.59. This is principal still owed under the stated assumptions, not the total of remaining payments.

Assumptions

• The interest rate stays fixed throughout the loan term.
• Payments are equal and made monthly, at the end of each monthly period.
• Interest compounds monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, late charges, and other loan costs are not included.
• The balance output assumes exactly 12 on-time payments and no extra payments.

What a Running Balance Shows

A running balance is a sequence of snapshots: the amount owed after each payment or other account event. In an amortizing loan, every scheduled payment generally covers interest accrued for the period first, with the remainder reducing principal. Early in a level-payment schedule, the balance can fall slowly because the outstanding principal is large and the interest portion of each payment is correspondingly larger. As principal declines, less interest accrues and more of a fixed payment goes toward principal.

The term is also used in account statements and loan-servicing records. A real account’s balance may reflect payment dates, accrued interest, fees, payment allocation, and adjustments. A payoff quote can therefore differ from a calculator’s balance: payoff may include interest accumulated since the last payment and any applicable charges. The lender’s account records are needed for an exact amount on a particular date.

How to Use and Read the Estimate

Enter the amount originally borrowed, the annual percentage rate expressed as a percent, and the loan term in years. The calculator reports the scheduled monthly payment, total interest across the full modeled term, and the balance after one year of payments. For example, an APR entry of 8 means eight percent, not 0.08 or 8 as a decimal rate. The formula itself converts the percentage into a monthly decimal rate.

The output is not a payoff amount for an arbitrary date. It is a modeled balance immediately after payment 12. To estimate another point in the schedule, use the formula with that payment count as k. If no payment has yet been made, the balance is the original principal. If all scheduled payments have been made, the balance should be approximately zero, subject to cent rounding and any final-payment adjustment.

What Changes the Balance

The result depends on the amount borrowed, rate, payment size, elapsed payment periods, and how payments are applied. Extra principal payments typically reduce the balance faster and can reduce later interest, but the effect depends on the loan’s terms and servicing. A missed or late payment, a variable rate, payment holidays, capitalization of unpaid interest, or fees can make the actual account balance differ from this level-payment model.

Loan statements may show a current principal balance, a total account balance, or a payoff figure. These are not necessarily interchangeable. Principal balance excludes future interest that has not accrued; an account balance may include amounts already due; payoff generally concerns the amount required to close the account on a stated date. Check the label and date on a statement before comparing it with an estimate.

Common Calculation Mistakes and Limits

• Mixing annual and monthly rates: The formula requires APR divided by 12 and then by 100. Using 8 directly as the monthly rate produces a meaningless result.
• Using the term in years as months: A five-year term means 60 monthly periods, not five.
• Ignoring payment rounding: The displayed payment is rounded to cents, so totals can differ slightly from calculations that retain extra decimal places. A servicer may adjust the final payment.
• Assuming every loan is level-payment: Interest-only, variable-rate, irregular-payment, and balloon loans need different calculations or additional inputs.
• Comparing unlike balances: A balance immediately after a payment is not the same as a payoff quote between payment dates.

This calculator uses a standard fixed-rate amortization formula and does not reproduce every lender’s day-count convention, payment posting rule, fee, or account adjustment. Use the lender’s statement or disclosure for the exact contractual figures.

Frequently Asked Questions

What does loan running balance mean?
A loan running balance is the amount still owed at a particular point in the repayment schedule, usually after a payment has been credited.

How do I calculate a loan balance after payments?
Use the balance formula with the original principal, monthly rate, number of payments made, and scheduled monthly payment. The calculator applies it after 12 payments.

Why does my balance barely go down at first?
With an amortizing loan, interest is calculated on the outstanding principal. When the balance is high, a larger share of each fixed payment goes to interest, leaving less to reduce principal.

Is the running balance the same as the payoff amount?
No. A payoff amount may include interest accrued since the last payment and other amounts due. Request a dated payoff figure from the loan servicer for an exact amount.

Does an extra payment change the calculated balance?
Yes, if the additional amount is applied to principal, it can lower the balance and future interest. This calculator does not include extra payments, so its result will not reflect them.

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

Related

• KCC Loan Interest Rate: How It Works
• Journal Entry to Increase a Loan Balance
• Jumbo vs High-Balance Loan: Key Differences

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