Loan Balance Calculator
Test cases replayed : 3 of 3 match · Methodology · No outside source listed
Find how much you still owe on a fixed-rate loan after a given number of monthly payments.
Result
Remaining balance
Monthly payment
- Principal paid so far
- Interest paid so far
- Payments left
Estimate for planning only, not tax, legal, financial or medical advice. This calculator uses the method explained on this page.
This browser did not allow copying. The sentence is in the box below, already selected: copy it with your keyboard or the menu.
How to use this calculator
Fill in the fields in this order; each step takes you to its field.
- Original loan amount, in dollars: enter 0 or more.
- Interest rate, in % / year: enter a number from 0 to 100.
- Original term, in months: enter a number from 1 to 600.
- Payments already made: enter a number from 0 to 600.
- Read the result: Remaining balance; the panel also shows Monthly payment, Principal paid so far, Interest paid so far and Payments left.
Remaining balance over time
Amortization schedule
| Year | Principal | Interest | Balance |
|---|
The CSV file is made in your browser: UTF-8, comma-separated, one row per table row, amounts in USD to the cent with a decimal point.
How this calculator works
Remaining balance after k payments: B = P(1 + r)^k − payment × ((1 + r)^k − 1) ÷ r, where P is the original amount and r the annual interest rate ÷ 12. The payment is P × r ÷ (1 − (1 + r)^−n).
This assumes every payment was made on time and in the scheduled amount. Your lender's payoff quote also adds interest accrued since the last payment.
The formula
| Symbol | Meaning | Unit |
|---|---|---|
| Original loan amount | $ | |
| Interest rate | % / year | |
| Original term | months | |
| Payments already made | ||
| Monthly payment | $ | |
| Remaining balance | $ | |
pmt(P, r, n) | the payment per period that repays P over n periods at rate r per period, or P ÷ n when r is zero. |
Worked example
| Original loan amount | $30,000 |
|---|---|
| Interest rate | 7 % / year |
| Original term | 60 months |
| Payments already made | 24 |
| Monthly payment | $594.04 |
|---|---|
| Principal paid so far | $10,761.28 |
| Interest paid so far | $3,495.59 |
| Payments left | 36 |
Remaining balance $19,238.72
Each step uses the unrounded value of the step before it; figures on this page are rounded for display.
Frequently asked questions
How much is left on a $30,000, 60-month loan at 7% after 24 payments?
About $19,238.72. The monthly payment is $594.04.
Why does the balance fall slowly at first?
Early payments go mostly to interest because interest is charged on the full balance; the principal share grows as the balance falls.