Loan Balance Sheet Calculator and Explanation

A loan balance sheet shows how much of a loan remains unpaid at a given point, alongside related payment and interest figures. Enter the original loan amount, annual percentage rate (APR), and term to estimate the monthly payment and total interest; this calculator does not calculate a balance at a selected date.

Formula

This calculator uses the standard fixed-payment loan formula. It calculates the monthly payment as M = P × r / (1 − (1 + r)−n), where r = APR / 1200 is the monthly rate and n = years × 12 is the number of monthly payments. Total interest over the scheduled term is I = M × n − P.

• P is the starting loan principal, in dollars.
• APR is the annual percentage rate entered as a percentage, such as 8 for 8%.
• r is the monthly interest rate as a decimal.
• n is the number of monthly payments.
• M is the calculated monthly payment, in dollars.
• I is the estimated total interest paid, in dollars.

Calculations use the unrounded payment internally to determine total interest. Displayed money amounts are rounded to cents, so multiplying the displayed payment by the number of months can differ slightly from the displayed total interest.

Worked Example

Using the calculator’s default values: a $20,000 principal, 8% APR, and a 5-year term:

1. Convert the APR to a monthly rate: r = 8 / 1200 = 0.0066667.
2. Find the number of payments: n = 5 × 12 = 60.
3. Apply the payment formula: M = 20,000 × 0.0066667 / (1 − (1.0066667)−60).
4. The monthly payment is about $405.53.
5. Calculate interest using the unrounded payment: I = M × 60 − 20,000, which is about $4,331.80.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal monthly payments, made at the end of each monthly period.
• Interest accrues monthly using the APR divided by 12.
• The estimate excludes fees, taxes, insurance, PMI, escrow, and any other charges or add-ons.

What a Loan Balance Sheet Shows

“Loan balance sheet” can mean a summary of a borrower’s remaining debt, or a schedule showing how each payment changes the loan balance. It is not necessarily a formal accounting balance sheet. A borrower-facing loan summary commonly includes the original principal, current outstanding principal, interest rate, payment amount, payment dates, and payoff information.

A payment schedule, often called an amortization schedule, breaks the loan into periods. Each row records the opening balance, payment, interest charged, principal repaid, and closing balance. The closing balance for one period becomes the opening balance for the next. This makes it easier to see why an early payment may reduce principal by less than a later payment of the same size: when the balance is higher, more interest accrues.

How the Balance Changes

For a fixed-rate loan with regular monthly payments, the basic period-by-period calculation is:

• Interest for the month = opening balance × monthly interest rate.
• Principal repaid = payment − interest for the month.
• Closing balance = opening balance − principal repaid.

For example, at the calculator’s 8% APR assumption, the first month’s interest on $20,000 is approximately $133.33. From a $405.53 payment, about $272.20 goes toward principal, leaving a balance of roughly $19,727.80. Actual lender statements can differ because of payment dates, daily interest calculations, rounding, fees, or other contract terms.

The calculator above estimates the scheduled payment and total interest, not a date-specific balance. To build a balance sheet, repeat the monthly steps using the actual payment dates and terms. A remaining balance also is not always the same as a payoff quote: accrued interest or other contract charges may affect the amount due on a particular date.

When to Use It and What to Check

A loan balance summary can help organize debts, review a statement, track repayment, or compare a lender’s schedule with a basic estimate. It is useful to distinguish three amounts: the starting principal, the current principal balance, and the payoff amount. They refer to different points or calculations and should not be treated as interchangeable.

• Check the rate format. Enter APR as a percentage: 8 means 8%, not 0.08. The calculator converts it to a monthly decimal rate.
• Check the term unit. Enter years; the calculation converts years to months. A 5-year term means 60 scheduled monthly payments.
• Check what the payment includes. A loan payment may not include a separately billed insurance premium, tax, fee, or escrow contribution.
• Use the lender’s figures for account records. A calculator’s rounded estimate is not a substitute for the current statement or a dated payoff figure.

A common misconception is that every dollar paid reduces the balance by a dollar. On an interest-bearing loan, part of a scheduled payment first covers interest accrued for the period; only the remainder reduces principal. If a payment is less than the interest due, the balance may not fall as expected, depending on the loan terms.

Limits and Related Calculations

This estimate assumes one fixed rate, equal monthly payments, and a fully amortizing loan. It does not model variable rates, skipped or late payments, extra principal payments, payment holidays, refinancing, balloon payments, or fees. For a changing rate or irregular payment history, a period-by-period calculation needs the actual dates, rates, and amounts. Even with a fixed-rate loan, daily accrual and lender rounding can cause small differences from this monthly model.

To estimate a balance after a particular number of payments, use the loan’s payment amount and actual payment count in a remaining-balance calculation, or consult the lender’s amortization schedule. To estimate payoff timing after extra payments, those additional amounts and their dates must also be included. The calculator here does not infer them from the original loan terms.

Frequently Asked Questions

What does loan balance mean?
The loan balance is the principal still owed at a specified time. It can differ from a payoff amount, which may reflect interest accrued since the last payment and other contract-specific items.

Is a loan balance sheet the same as an amortization schedule?
Not always. A balance sheet may be a brief summary of debts and balances. An amortization schedule is a detailed, period-by-period record of payments, interest, principal, and remaining balance.

Why does the balance go down slowly at first?
Interest is calculated on the outstanding balance. Early in repayment the balance is relatively large, so a larger share of each level payment can go to interest; as principal falls, the interest portion generally falls too.

Does this calculator show my current loan balance?
No. It estimates the scheduled monthly payment and total interest from the original amount, APR, and term. A current balance requires the payment history and the lender’s interest and payment-date rules.

Why might my lender’s figures differ?
Differences can result from daily rather than monthly interest accrual, payment timing, rounding, fees, rate changes, or payments that differ from the assumed schedule. Use the lender’s statement or disclosure for account-specific amounts.

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

Related

• Loan Balance Calculator: Estimate What You Still Owe
• Loan Balance After Payment: Calculate What Remains
• Loan Balance Amortization Calculator: See What You Owe

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 | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2