[]

Document Solutions for Excel, .NET Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
  - ACCRINT
  - ACCRINTM
  - AMORDEGRC
  - AMORLINC
  - COUPDAYBS
  - COUPDAYS
  - COUPDAYSNC
  - COUPNCD
  - COUPNUM
  - COUPPCD
  - CUMIPMT
  - CUMPRINC
  - DB
  - DDB
  - DISC
  - DOLLARDE
  - DOLLARFR
  - DURATION
  - EFFECT
  - FV
  - FVSCHEDULE
  - INTRATE
  - IPMT
  - IRR
  - ISPMT
  - MDURATION
  - MIRR
  - NOMINAL
  - NPER
  - NPV
  - ODDFPRICE
  - ODDFYIELD
  - ODDLPRICE
  - ODDLYIELD
  - PDURATION
  - PMT
  - PPMT
  - PRICE
  - PRICEDISC
  - PRICEMAT
  - PV
  - RATE
  - RECEIVED
  - RRI
  - SLN
  - SYD
  - TBILLEQ
  - TBILLPRICE
  - TBILLYIELD
  - VDB
  - XIRR
  - XNPV
  - YIELD
  - YIELDDISC
  - YIELDMAT
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Document Solutions Data Viewer
API Reference
Release Notes

IPMT

This function calculates the payment of interest on a loan.

Syntax

IPMT(rate, per, nper, pval, [fval], [type])

Arguments

This function has these arguments:

Argument	Description
rate	[Required] Value of interest rate per period.
per	[Required] Number of the period for which to find the interest, between 1 and nper
nper	[Required] Total number of payment periods in an annuity.
pval	[Required] Present value, worth now
fval	[Optional] Future value, cash value after the last payment; if omitted, the calculation uses zero
type	[Optional] Indicates when payments are due; at the end (0) or beginning (1) of the period; if omitted, the calculation uses the end (0)

Remarks

The result is represented by a negative number because it is money paid out by you.

Examples

IPMT(0.65,A1,B3,C42)

IPMT(R1C1,R12C12,R13C13,R32C1)

IPMT(0.45, 2, 30, 6000) gives the result -2,699.98