Loan Balance Calculator
Loan Balance Calculator
Estimate how much principal remains after a chosen number of monthly payments, then review payment progress, interest, and the complete amortization path.
Loan details
Values update instantly. The model assumes a fixed rate, equal monthly payments, and no extra fees or prepayments.
After 24 of 60 scheduled monthly payments.
Lifetime payment breakdown
See where every scheduled dollar falls: principal and interest already paid, plus principal and interest still ahead.
Total scheduled payments
$11,322.74 across 60 payments| Category | Amount | Share |
|---|
Balance and principal progress
The balance curve typically falls slowly at first and faster later because each payment gradually shifts from interest toward principal.
Amortization schedule
Each row uses the same calculation model as the balance, charts, and Excel workbook.
| Period | Starting balance | Payment | Principal | Interest | Ending balance |
|---|
What does this loan balance calculator estimate?
This calculator estimates the unpaid principal on a standard amortizing loan after a selected number of monthly payments. It is suitable for fixed-rate personal loans, auto loans, and many conventional mortgages when the contract uses equal monthly installments. The result is an estimate of principal still owed, not a lender’s formal payoff quote. A payoff quote can include daily accrued interest, late charges, escrow adjustments, prepayment fees, or other account-specific items that are not part of this model.
The default example uses a $10,000 loan, a 5% annual interest rate, a five-year term, and two years of completed payments. Under those assumptions, the scheduled monthly payment is about $188.71 and the remaining principal is about $6,296.52 after 24 payments.
How should each input be used?
Original loan amount
Enter the principal borrowed before interest. This field is required and should be a positive dollar amount. A larger loan raises the payment, interest cost, and remaining balance in direct proportion when the rate and term stay unchanged. Do not enter the total of all future payments or the current balance; the model needs the starting principal.
Annual interest rate
Enter the nominal annual percentage rate used to calculate monthly interest. The calculator divides this rate by 12. A higher rate increases the monthly payment and causes principal to decline more slowly in the early months. A zero rate is valid and produces a simple straight-line repayment schedule. Keep lender fees separate unless they were financed into the original principal. For background on how consumer loan rates and disclosures work, review the Consumer Financial Protection Bureau’s loan guidance.
Original loan term
Enter the full contractual term in years or months. Changing the unit converts the current value rather than simply relabeling it. The calculator rounds the converted duration to the nearest whole month because the schedule is monthly. A longer term usually lowers the monthly payment but raises total interest and keeps the balance outstanding longer. A shorter term does the opposite.
Time already paid
Enter how long payments have been made, again in years or months. This amount may range from zero to the full term. Values beyond the original term are rejected because a standard amortizing loan should already be paid off. The model assumes all scheduled payments were made on time and in full. Missed payments, deferments, extra payments, and rate changes require a lender statement or a more specialized model.
How is the remaining balance calculated?
First, the calculator determines the level monthly payment. For a positive monthly rate, the payment is based on the standard annuity formula. It then calculates the balance after the selected number of payments. With principal P, monthly rate r, total months n, and completed payments k:
Balance after k payments = P × (1 + r)^k − Payment × ((1 + r)^k − 1) ÷ r
When the interest rate is zero, the calculator uses payment = principal ÷ months and balance = principal − payment × completed payments. Full precision is maintained inside the model; rounding is applied only for display and export. This prevents small repeated rounding differences from accumulating in the balance.
How should the results be interpreted?
Remaining loan balance
This is the estimated principal still unpaid immediately after the selected payment count. A value of zero means the chosen period reaches the end of the modeled schedule. A high balance relative to the original principal is normal early in a long-term loan, especially at higher rates.
Monthly payment
This is the scheduled principal-and-interest installment. It excludes taxes, insurance, escrow, optional protection products, and servicing fees. For mortgages, the amount debited from your account may therefore be materially higher. The CFPB home-buying resources explain common mortgage payment components.
Principal repaid and interest paid to date
Principal repaid is the original amount minus the remaining balance. Interest paid to date is the sum of the interest portions of completed scheduled payments. Early payments usually contain more interest because interest is calculated on a larger outstanding balance. These figures help distinguish cash paid from actual debt reduction.
Future interest and payoff progress
Future interest is the scheduled interest from the next payment through maturity, assuming no changes. Payoff progress is principal repaid divided by original principal. It is not the percentage of time elapsed; the two can differ because amortization is nonlinear.
What do the charts and schedule show?
The lifetime breakdown divides all scheduled payments into four current-state categories: principal already paid, interest already paid, principal remaining, and interest still scheduled. The line chart plots remaining balance and cumulative principal across the entire term, with the current month highlighted. The schedule then exposes the same model row by row. In monthly view, each row shows starting balance, payment, principal, interest, and ending balance. Annual view aggregates those rows into compact yearly totals.
Use the charts to understand direction and timing, but use the exact result cards and schedule for amounts. The exported Excel workbook captures the current inputs, results, breakdown, and every monthly schedule row. For a broader explanation of amortization and payment structure, see the Investopedia overview of amortization.
What assumptions can cause differences from a lender statement?
Common causes include daily rather than monthly interest accrual, payment dates that differ from the contractual due date, financed fees, skipped or partial payments, extra principal payments, adjustable rates, balloon payments, and rounding conventions. Mortgage balances may also be shown beside escrow balances that are not principal. The Federal Reserve’s consumer financial resources provide additional context on borrowing and credit.
Before refinancing, selling collateral, or paying off a loan, request an official payoff statement from the servicer. This calculator is an educational planning tool and does not provide individualized financial, legal, tax, or investment advice.