Bank PDF had 60 rows.
I zoomed till the commas looked like ants.
Cousin said, just show me where the interest total is.
He had been adding the interest column in his head and losing count at month 8.
I told him to stop adding 60 lines on a phone.
Total interest is EMI times months minus principal.
That one line is the whole PDF, if the EMI is regular.
Early EMIs are mostly interest.
That is the other shock.
I will walk both.
This is a estimate walk, not a promise the bank sheet matches to the paisa.
The one line I wish they printed in bold
Say loan 5,00,000.
Say the EMI comes about ₹10,379 at 9 percent for 60 months.
I am using the same flavour of example as the EMI calculator on this site.
60 times 10,379 is 6,22,740.
Minus 5,00,000 principal.
Total interest about 1,22,740.
I dont need row 1 to row 60.
I need EMI, months, principal.
If your EMI is 12,500 and months 36 and principal 3,50,000, then 12,500 times 36 is 4,50,000.
Minus 3,50,000 is 1,00,000 interest.
Same shape.
If the PDF EMI is not the same every month, this shortcut slips.
Some lenders do a odd first month.
Broken period interest, I talk about that in why bank EMI and this calculator dont match.
If 59 months are 10,379 and month 1 is 10,820, add that extra in the head.
Still easier than summing 60 interest cells.
I open the tool.
Loan amount 500000.
Rate 9.
Tenure 60 months, not 5, not 60 years.
Calculate.
I read EMI, total interest, total payout.
I point cousin at total interest.
I say, that is the number you want, if your three boxes match the sanction.
If they dont match the sanction, the PDF wins for the official, the tool is the preview.
I never say 100 percent bank match.
Why month 1 looks like you paid almost no principal
Reducing balance.
Interest that month is on the remaining principal.
Month 1, remaining is almost the full 5,00,000.
9 percent a year is 0.75 percent a month, simple way.
0.75 percent of 5,00,000 is 3,750.
If EMI is 10,379, principal in month 1 is 10,379 minus 3,750, about 6,629.
So, out of 10,379, only about 6,629 cut the loan.
Rest was rent on the money.
Cousin hates this.
I did too.
Month 2, principal is a bit less, interest a bit less, principal slice a bit more.
By month 60, interest slice is small, principal slice is almost the whole EMI.
The schedule is that slide.
It is not a trick.
It is how reducing balance works.
If you want less total interest, you need lower rate, or fewer months, or you prepay principal.
This box does not take prepayment.
If you already prepaid, run a smaller principal.
I wrote 20 year vs 15 year for the tenure trade.
Longer tenure, EMI falls, total interest climbs.
Same idea you see in the early rows.
More months of that fat interest slice.
Picture is the 5 lakh, 9 percent, 60 month flavour.
EMI near 10,379.
Total interest near 1,22,741.
I look at those two, not at row 37.
If your PDF total interest is 1,24,000 and the tool says 1,22,741, I look for insurance add-on, processing stuffed into disbursal, or a rate that is 9.15 not 9.
Small gap, I shrug.
Big gap, a box is wrong, or the product is flat interest, which this tool is not.
This tool is reducing balance, the usual home and personal loan style.
Flat vs reducing, the other why I dont get it
Some old shop loans quote flat 10 percent.
They mean interest on original principal for the whole time, then add, then divide.
That total interest is fatter.
The schedule, if they even give one, will not match this tool.
I ask, did the officer say reducing.
If he said flat, I dont use this EMI as gospel.
I still can compute their EMI if they already printed it, then total interest is still EMI times months minus principal, if they collect equal EMIs.
The formula of how they got the EMI changes.
The add-up of what you pay does not.
You pay what you pay.
Total interest is still extra rupees above the loan.
That definition is the cousin definition.
Not a RBI circular I invented.
If floating rate, the PDF you opened in year 1 is a snapshot.
Rate changes, EMI or tenure changes, total interest changes.
I dont freeze 1,22,740 for a 20 year float.
I freeze it for a fixed example.
For a float, I rerun when the SMS comes.
Insurance premium added to loan, principal is higher than the car price.
Type the actual loan, not the on-road without insurance.
Otherwise total interest looks smaller than the PDF because you typed a smaller principal.
I check that every time now.
How I read a schedule without adding 60 rows
I look at first interest cell.
I look at last interest cell.
I look at the printed grand total interest if they printed it.
Many PDFs have a summary on page 1.
Cousin skipped page 1 and jumped to the table.
I send him back.
If no summary, EMI times n minus P.
I also look at outstanding after 12 months.
If he wants to prepay after a year, that outstanding is the number, not 5,00,000 minus 12 times 10,379.
Because 12 times 10,379 includes interest he already paid.
12 times 10,379 is 1,24,548.
That is not 1,24,548 off the principal.
Principal would have dropped by the sum of 12 principal slices, maybe around 80,000-ish in this example, I am not quoting a official year-1 table.
The tool here does not dump a full 60 row HTML.
So I dont pretend I listed every month.
I teach the shape.
If he needs every row, the bank PDF is that.
This site is the three box check.
First time boxes, which box first.
Principal, yearly rate, months.
That order.
Years in the months box makes EMI huge and total interest nonsense.
20 instead of 240.
I have seen it.
Total interest then looks like a horror, or EMI looks like a rent for a mall.
Fix the tenure.
Then look at total interest again.
I say estimate, not official.
Lender sheet for the file.
This page so you stop adding interest cells with a thumb.
Early EMIs are mostly interest.
Total interest is EMI times months minus principal.
If those two sentences sit in your head, the 60 row PDF is just a long proof.
If he still wants a feel for year 1, I say look at the outstanding column after 12 rows, not at the EMI sum.
EMI sum includes interest.
Outstanding is what you still owe.
That is the number a prepay talk should use.
I put that outstanding as a new principal in EMI calculator only if the rate and leftover months are still the plan.
Then total interest from that day is a new story.
The old 1,22,740 is not a tattoo.
It was the start.