IPMT Function in Excel: Interest Part of an EMI

⏱ 1 min readUpdated 28 September 2026

FinancialLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Related functions

IPMT returns how much of a given EMI is interest; PPMT returns the principal part. Together they always equal PMT.

Syntax

=IPMT(rate, per, nper, pv, [fv], [type])
Argument What it means
per Which payment (1 = first).

Examples

Example 1

=IPMT(8.5%/12, 1, 240, -3000000)

Interest in the first EMI of a ₹30 lakh, 20-year loan: ₹21,250.

Example 2

=-SUM(IPMT(8.5%/12, SEQUENCE(12), 240, 3000000))

Interest paid in year 1 (Excel 365).

PPMT · PMT · CUMIPMT

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZINDIRECT Function in Excel: Build a Reference From TextExcel Functions A–ZMROUND Function in Excel: Round to the Nearest MultipleExcel Functions A–ZFIXED Function in Excel: Round and Format as Text
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong