Why is so much of my early payment interest?

Because interest each month is the rate times the balance, and the balance starts at its highest. On a 20-year loan at 8.5% the first year is about 81% interest. The schedule below shows the crossover month where principal first exceeds interest.

What does the last row of a schedule look like?

Lopsided, and correctly so. Lenders round the instalment, so the final payment is trued up against whatever balance remains, which is why it differs from every other row by a few units.

Finance & Loansloans

Loan Amortization Schedule

The full amortisation schedule for a loan. Every instalment split into interest and principal, with the running balance and a downloadable table.

Also called: amortisation table, loan schedule, repayment schedule.

Total interest over the term

₹54,13,879

You repay ₹1,04,13,878 on a loan of ₹50,00,000, ₹54,13,879 of it interest. In the first year alone, ₹4,21,182 goes to interest and only ₹99,511 to the debt.

Monthly instalment

₹43,391

Total repayment

₹1,04,13,878

Interest in year 1

₹4,21,182

Principal in year 1

₹99,511

How this is calculated

An estimate, not an offer or a guarantee. Projected returns assume the rate you entered holds for the whole term, which no market does.

principal_vs_interest_split

Principal ₹50,00,000 (48%)Interest ₹54,13,879 (52%)

Outstanding balance

Hover or drag for values

Outstanding balance

240 rows

Month	Payment	Interest	Principal	Balance
1	₹43,391	₹35,417	₹7,975	₹49,92,026
2	₹43,391	₹35,360	₹8,031	₹49,83,995
3	₹43,391	₹35,303	₹8,088	₹49,75,907
4	₹43,391	₹35,246	₹8,145	₹49,67,762
5	₹43,391	₹35,188	₹8,203	₹49,59,559
6	₹43,391	₹35,130	₹8,261	₹49,51,298
7	₹43,391	₹35,072	₹8,319	₹49,42,978
8	₹43,391	₹35,013	₹8,378	₹49,34,600
9	₹43,391	₹34,953	₹8,438	₹49,26,162
10	₹43,391	₹34,894	₹8,498	₹49,17,665
11	₹43,391	₹34,833	₹8,558	₹49,09,107
12	₹43,391	₹34,773	₹8,618	₹49,00,489

Method and background

This is what the calculation gives for the numbers you entered. It is an estimate, not advice, and it knows nothing about your situation beyond those numbers. Rules for India change on a published schedule; the effective date is shown on every rule-based tool.

How this is calculated

The outstanding-balance formula falls out of the same derivation as the EMI itself, one step earlier. Interest in any month is the rate times the previous balance; principal is whatever the fixed payment has left over. Because the balance starts at its maximum, the split is heavily weighted to interest early and reverses late.

B_k = P*(1+i)^k - E*((1+i)^k - 1)/i

E: The equal periodic instalment (currency)
P: Principal: the amount borrowed (currency)
i: Monthly interest rate = annual rate ÷ 12 ÷ 100 (decimal)
n: Total number of monthly instalments (months)
B_k: Outstanding balance after k payments (currency)

Full derivation: The annuity payment, derived from scratch

Worked examples

Each of these is asserted on every build. If a change to the engine ever moved one of these answers, the build would fail before the page could print it.

year one of the DRV-001 example is 81% interest

Loan amount: ₹50,00,000
Interest rate (per year): 8.5%
Tenure: 20 years

Total interest over the term₹54,13,879

summed from the engine schedule; matches the reference post table

Open this example

zero interest gives a flat principal schedule

Loan amount: ₹12,00,000
Interest rate (per year): 0%
Tenure: 10 years

Total interest over the term₹0

i=0 branch: every instalment is pure principal

Open this example

single instalment schedule has one row

Loan amount: ₹1,00,000
Interest rate (per year): 12%
Tenure: 0.08 years

Total interest over the term₹1,000

n=1 reduction

Open this example

Written about this

The EMI formula, in plain English · 2 min · Where the EMI formula comes from, what each part of it does, and how to reproduce it in a spreadsheet in one line.

Method and limits

What it assumes

Interest compounds monthly on the reducing balance.
The rate stays fixed for the whole term. Floating-rate loans reset periodically.
Processing fees, insurance and statutory charges are excluded.

What it deliberately does not model

Does not model rate resets on floating-rate loans. Most lenders hold the instalment steady and extend the term instead, so a rate rise can add years without changing what leaves your account each month.
Does not include property insurance, maintenance or association dues, or any lender fee.
Assumes every instalment is paid in full and on time.

Formula version 1.0.0 · definition 1.0.0 · India · Report a problem with this calculator

Frequently asked questions

Why is so much of my early payment interest?: Because interest each month is the rate times the balance, and the balance starts at its highest. On a 20-year loan at 8.5% the first year is about 81% interest. The schedule below shows the crossover month where principal first exceeds interest.
What does the last row of a schedule look like?: Lopsided, and correctly so. Lenders round the instalment, so the final payment is trued up against whatever balance remains, which is why it differs from every other row by a few units.