Skip to main content

Loan · FINANCIAL TOOLS

Loan Balance Calculator

Find out how much of a loan is still outstanding part-way through its term, and how much of it you have actually repaid.

Understand the calculation

Calculation logic, formula, example and guardrails behind the estimate.

How it works

The calculator first derives the instalment from the original terms, then computes what the balance must be after the instalments you have paid. It uses a closed form — the principal grown forward at the monthly rate, less the instalments grown forward — which gives the same answer as walking the schedule month by month, and the two are checked against each other.

It then splits everything you have paid into two parts. Whatever reduced the principal is the principal cleared; the rest was interest. That split is the useful part, because the two are wildly unequal early in a loan.

More detail

The percentages are the point worth studying. On a 20-year loan, paying a quarter of the instalments clears nowhere near a quarter of the principal — interest is charged on the outstanding amount, so it takes the largest share of the earliest payments.

Any prepayment you have already made is not modelled, so a real balance will be lower than the figure here if you have paid extra at any stage.

Because so much interest is still ahead of you early in a loan, the prepayment calculator.

For the full month-by-month schedule behind these figures, use the EMI calculator.

Formula

B = P(1 + r)ᵏ − E × ((1 + r)ᵏ − 1) ÷ r

The original principal compounded forward for k months, less the future value of the k instalments already paid. Equivalent to the month-by-month schedule, and exact rather than iterative.

B
Balance still outstanding.
P
Amount originally borrowed.
E
The monthly instalment.
r
Monthly interest rate — annual rate ÷ 12.
k
Instalments paid so far.
Worked example

A ₹50,00,000 loan at 8.5% over 20 years, five years in — that is 60 of 240 instalments paid.

  1. 01Instalment₹43,391.16
  2. 02Paid to the lender so far60 × ₹43,391 = ₹26,03,470
  3. 03Tenure elapsed60 ÷ 240 = 25%
  4. 04Principal actually cleared₹5,93,641, or 11.87%
  5. 05Interest paid so far₹20,09,829

A quarter of the instalments have gone but only about an eighth of the principal. Just over ₹20 lakh of the ₹26 lakh paid was interest, which is what a reducing-balance loan looks like early on — and why a prepayment made now removes far more interest than the same amount paid later.

Frequently asked questions

Common questions about the loan balance calculator and the assumptions behind it.

Disclaimer

This calculator is provided for general information and planning only. It is not investment, tax or legal advice, and it does not take your personal circumstances into account. Outputs are estimates based on the assumptions stated on this page, exclude taxes and charges unless said otherwise, and market-linked returns are not guaranteed — the value of investments can fall as well as rise. Lending terms, rates and eligibility are decided by the lender. For advice on your own situation, speak to a qualified professional, several of whom you can consult on Finvestalk.