Capital Balance Calculator: How to Calculate It

Calculate a loan’s remaining capital balance—the unpaid principal after a chosen number of payments—using the original loan amount, APR, term, and payments made. Enter those figures to get the estimated balance, along with the monthly payment and total interest for context.

Formula

For a fixed-rate loan with level monthly payments, the capital balance after k payments is:

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

• B is the remaining capital balance in dollars.
• P is the original principal, or amount borrowed, in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 1,200.
• k is the number of monthly payments already made.
• M is the monthly payment in dollars, rounded to cents.

The payment is calculated from the original principal, monthly rate, and total number of scheduled payments: M = P × r / (1 − (1 + r)⁻ⁿ), where n is the term in months. The balance formula accounts for interest that accumulates and payments that reduce the debt. It assumes payments are made monthly and on schedule.

Worked Example

Using the calculator’s default values: principal P = $20,000, APR = 8%, term = 5 years, and 12 payments made.

1. Convert the annual percentage rate to a monthly decimal: r = 8 ÷ 1,200 = 0.0066667.
2. Convert the term to months: n = 5 × 12 = 60.
3. Calculate the monthly payment: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53 when rounded to cents.
4. Apply the balance formula after 12 payments: B = 20,000(1.0066667)¹² − 405.53 × [(1.0066667)¹² − 1] ÷ 0.0066667.
5. The estimated capital balance is $16,401.11. The scheduled payment is $405.53 per month, and total interest across 60 payments using that rounded payment is $4,331.80.

Assumptions

• The interest rate stays fixed throughout the loan.
• Payments are equal, monthly, and made at the end of each monthly period.
• Interest compounds monthly at APR ÷ 12.
• Extra payments, missed or late payments, fees, taxes, insurance, PMI, and escrow are not included.

Step-by-Step

1. Find the original principal. Use the amount actually borrowed, not the total of all scheduled payments. If the loan has been amended or refinanced, use the principal and terms for the current loan.
2. Get the applicable APR and term. Enter the annual percentage rate as a percent, not as a decimal. Enter the original repayment term in years. If the rate is variable, the result is only a snapshot based on the rate entered.
3. Count completed payments. Enter the number of regular monthly payments that have posted to the account. Do not count a payment that is merely scheduled or still processing. The number must not exceed the term in months.
4. Calculate the monthly payment and monthly rate. The calculator converts APR to a monthly rate and calculates the level payment from the principal and term. The payment is rounded to the nearest cent before it is used in the balance calculation.
5. Read the capital balance result. This is the formula’s estimate of unpaid principal immediately after the stated number of payments. At zero payments it is the original principal; after the final scheduled payment it should be close to zero, subject to rounding.
6. Compare with the account’s payoff information if needed. A capital balance is not necessarily the amount required to pay off a loan on a particular date. A payoff figure may include interest accrued since the last payment and other account-specific amounts. Ask the lender or servicer for an exact current figure.

When to Use the Calculation

Use this method to understand how regular payments gradually reduce principal, estimate the remaining principal at a particular point in a fixed-rate repayment schedule, or check the general arithmetic of a statement. It is useful for learning how term, payment count, and interest affect the balance. It does not replace the lender’s account records, which reflect actual posting dates, payment allocation, and contract terms.

The calculator’s total-interest figure is the scheduled interest over the full term, based on the rounded monthly payment. It is not the interest paid so far. The balance result is more directly useful when you want the estimated unpaid principal after the payment count you enter.

Common Mistakes

• Using the wrong principal: The formula starts with the amount borrowed. Do not substitute the sum of payments or include unrelated fees unless they were financed into the principal.
• Entering APR in the wrong format: Enter 8 for 8%, not 0.08. The calculator divides the entered percent by 1,200 to get a monthly decimal.
• Counting payments inaccurately: Use payments actually made and posted. A difference of even one payment changes the balance.
• Confusing balance with payoff: The estimated capital balance excludes possible accrued interest and account-specific charges. Request a dated payoff quote for an exact payoff amount.
• Ignoring extra payments or rate changes: The standard formula assumes equal payments and a constant rate. Extra principal payments, skipped payments, or a variable rate can make the real balance differ.
• Rounding too early: Keep full precision for intermediate calculations and round the monthly payment to cents as the calculator does. Small rounding differences can accumulate across many payments.

Tips

• Check your loan statement or original agreement for the principal, APR, term, and payment schedule; use the actual figures rather than illustrative defaults.
• Make sure the number of payments entered is no greater than the full term expressed in months. The calculator flags a payment count beyond the term rather than returning a misleading negative balance.
• For a balance on a date between payment dates, this monthly formula may not match the account’s daily interest calculation. Ask the lender how it calculates interest and request a current balance.
• Keep the result as an estimate for education and comparison. The lender’s transaction history is the source for posted payments and the exact account balance.

Troubleshooting

The calculator says it cannot compute: Check that the number of payments is not greater than the term in months. For example, a five-year term has 60 scheduled monthly payments.

The result is higher than expected: Confirm the APR, original principal, and payment count. Check whether the real loan has a different payment amount, variable rate, or payment history than the assumptions.

The result does not match a statement: Statements may show a balance as of a particular date, include interest accrued since the last payment, or reflect extra payments and fees. Compare figures for the same date and ask the lender to explain its balance calculation.

The balance is not exactly zero at the end: The monthly payment is rounded to cents, and a final payment may be adjusted to clear the remaining amount. Use the lender’s final payment figure rather than treating a small calculated difference as an error.

Frequently Asked Questions

What does capital balance mean?
It generally means the unpaid principal remaining on a loan, excluding interest that may have accrued since the most recent payment.

Is capital balance the same as payoff balance?
No. A payoff amount may include interest through a specified date and other account-specific amounts. Request a dated payoff figure from the lender or servicer.

Can I calculate a balance after extra payments?
Not accurately with this standard formula, which assumes equal scheduled payments. Use a payment-by-payment schedule that includes each extra payment, or request an updated balance from the lender.

Can I use this for a variable-rate loan?
Only as an estimate for a period when the rate is known and remains unchanged. Rate changes can alter both the payment and the balance path.

Why does the calculator use APR divided by 1,200?
APR is entered as a percentage per year. Dividing by 100 converts percent to a decimal, and dividing by 12 converts the annual rate to a monthly rate.

Does the balance include future interest?
No. It estimates principal remaining after the payments entered. Interest for future periods is not part of that capital balance.

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

Related

• VA Interest Loan Rates: How to Estimate Payments
• US Home Loan Interest Rates: Estimate Your Payment
• Used Car Loan Interest Rates: Calculate Your Payment

in p | Original 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 | Capital balance after payments | $ | p * (1 + apr / 1200) ^ k - round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) + 0 * sqrt(yrs * 12 - k) | 2
out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest over full term | $ | pmt * yrs * 12 - p | 2