Debt

Verifying the interest and principal split inside your EMI

Verify the interest and principal split inside your EMI by recomputing one month by hand or in a sheet, and learn why small differences appear.

Editorial illustration for Verifying the interest and principal split inside your EMI

To verify the interest and principal split in your EMI, take the balance at the start of the month, apply the monthly rate and compare the result with the interest on your statement. The remainder of the EMI is the principal. If your number is close but not identical, the usual cause is how the lender counts days, not an error.

The method in four steps

  1. Find the principal outstanding at the start of the month from the statement.
  2. Find the annual interest rate in your sanction letter or the lender's latest notice. Rates can change on some loans, so use the one that applied in that month.
  3. Interest for the month is roughly balance times annual rate divided by 12.
  4. Principal part is the EMI minus that interest. New balance is the old balance minus the principal part.

A hand calculation on an invented loan

Assume a loan with a balance of ₹4,00,000, an annual rate of 12% (an assumption for this example, not a typical rate) and an EMI of ₹8,898 over 60 months.

  • Monthly interest: ₹4,00,000 times 12% divided by 12 equals ₹4,000
  • Principal part: ₹8,898 minus ₹4,000 equals ₹4,898
  • New balance: ₹4,00,000 minus ₹4,898 equals ₹3,95,102

If your statement shows interest of ₹4,000 and principal of ₹4,898, the split matches the simple monthly method.

Why might the statement show something different?

Say the statement shows interest of ₹4,077 for a 31-day month. The lender may be charging interest by the day. On ₹4,00,000 at 12% a year, one day is ₹4,00,000 times 12% divided by 365, which is about ₹131.51. For 31 days that is about ₹4,076.71, and for 30 days about ₹3,945.21. A statement figure near ₹4,077 would match daily counting.

CauseEffect on interestHow to check
Interest counted by actual daysHigher in 31-day months, lower in FebruaryMultiply the daily amount by the days in the month
EMI paid late or earlyInterest for extra or fewer daysCompare the payment date with the due date
First EMI after disbursalA longer or shorter first periodCount days from disbursal to the first due date
Rate changedInterest differs from the old rateLook for a rate-change notice
RoundingA rupee or twoRecompute with the lender's rounding if stated

Can you do this in a spreadsheet?

Yes. In Excel or Google Sheets, put the opening balance in B2, the annual rate as a decimal in C2 (for example 0.12) and the EMI in D2. Then:

  • Interest: =ROUND(B2*C2/12,2)
  • Principal: =D2-ROUND(B2*C2/12,2)
  • Closing balance: =B2-(D2-ROUND(B2*C2/12,2))

To check the EMI itself, the PMT function takes rate per period, number of periods and loan amount: =PMT(0.12/12,60,-400000) gives about 8,897.78, which a lender would round. For the interest part of a given month, IPMT works with the same arguments plus the period number: =IPMT(0.12/12,1,60,-400000) gives about 4,000 for month 1. Both exist in Excel and Google Sheets.

What do you do with the result?

Record the month, the balance, the interest and the principal in your loan page. If you upload bank statements to SpendixAI, the EMI debit appears in the account it left from, and your sheet carries the split.

If you want to go further, build a full table for the whole tenure: one row per month with the opening balance, interest, principal and closing balance, copying the formulas down. Compare any month with the lender's repayment schedule. If the first few rows agree to within a rupee or two, you can trust the rest more.

A final habit

Check one month a year, not every month. Pick a month, run the four steps and keep the result in the loan folder.

SPENDIXAI JOURNAL

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

Explore your reports