Debt

Home loan principal vs interest, year by year: a worked example

Home loan interest vs principal year by year: a hypothetical ₹30 lakh loan shows interest dominating early, plus how to build the view from your statement.

Editorial illustration for Home loan principal vs interest, year by year: a worked example

In the early years of a home loan, most of each EMI goes to interest, and only a small slice reduces the principal. On the hypothetical loan below, over 80% of the first year's payments is interest. Principal only overtakes interest in the thirteenth year. Here is the year-by-year view and how to build the same one from your own statement.

The hypothetical loan

  • ₹30,00,000 for 20 years (240 months) at an assumed 9% a year, reducing balance.
  • EMI about ₹26,992, so ₹3,23,901 is paid each year.
  • Total interest over the full term: about ₹34,78,027.
  • All figures are invented to show a pattern; your loan will differ.

How does the split change over the years?

YearOpening balanceInterestPrincipalClosing balanceInterest share
1₹30,00,000₹2,67,720₹56,181₹29,43,81982.7%
5₹27,41,630₹2,43,483₹80,418₹26,61,21175.2%
10₹22,56,686₹1,97,992₹1,25,909₹21,30,77761.1%
13₹18,42,417₹1,59,131₹1,64,771₹16,77,64649.1%
15₹14,97,419₹1,26,768₹1,97,134₹13,00,28539.1%
20₹3,08,649₹15,253₹3,08,649₹04.7%

In year 1, interest of ₹2,67,720 is nearly five times principal of ₹56,181. By year 13, the two have crossed. Halfway through the term, after 10 years, the balance is still ₹21,30,777, about 71% of the original loan.

Why does this happen?

Each month's interest is the opening balance times the monthly rate. When the balance is high, interest is high, and since the EMI is fixed, what remains after interest is small. As principal falls, interest falls and the leftover grows. That is why a prepayment in the early years saves a lot: it reduces a balance that is still charging a lot of interest.

Draw it as a stacked bar chart

A stacked column chart shows the pattern well. Put years along the bottom, rupees up the side, and stack interest and principal for each year. In both Excel and Google Sheets, select the year, interest and principal columns, choose a stacked column chart, and you will see the interest block shrink while the principal block grows.

How do you build the same view from a schedule?

If you have a month-by-month schedule with a month number in column A, interest in column D and principal in column E, add a helper column H with the year number: =ROUNDUP(A2/12,0). Then, for each year in column J:

  • Interest for the year: =SUMIFS($D$2:$D$241,$H$2:$H$241,J2)
  • Principal for the year: =SUMIFS($E$2:$E$241,$H$2:$H$241,J2)
  • Interest share: =K2/(K2+L2), formatted as a percentage, if K holds interest and L holds principal.

For a fixed-rate loan you can skip the schedule. =-CUMIPMT($B$2/12,$B$3,$B$1,1,12,0) gives year-1 interest, and =-CUMPRINC($B$2/12,$B$3,$B$1,1,12,0) gives year-1 principal, where B1 is the loan amount, B2 the yearly rate and B3 the number of months. Change 1 and 12 to 13 and 24 for year 2, and so on.

What about your own statement?

Your lender's statement lists interest and principal for each EMI, or gives a yearly summary. Copy the yearly totals into the table, and compare them with the pattern above. If your loan has a floating rate, the shape stays the same but the numbers move whenever the rate changes.

What does this mean for prepayment and tenure?

Two practical readings follow from the table. First, a part-payment made in year 2 removes a balance that would have gone on paying interest at an interest share above 80% for years, whereas the same amount in year 18 removes a balance that has little interest left to save. Second, if you choose a shorter tenure instead of a lower EMI, the principal column grows faster and the whole table compresses. Compare your lender's offered options by rebuilding the table with each choice.

Closing checklist

  • Copy yearly interest and principal from your statement.
  • Calculate the interest share each year.
  • Note where principal first exceeds interest.
  • Mark any prepayments, since they change every later year.
  • Confirm tax questions with your CA; rules change.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports