Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

IPMT

Description: Returns the interest payment for a period of time based on an investment with periodic constant payments and a constant interest rate. For a more complete description of the arguments in IPMT and for more information about annuity functions, see the PV function.

Syntax: IPMT(Rate, Per, Nper, PV, [FV], [Type])

Set type equal to If payments are due
0 or omitted At the end of the period
1 At the beginning of the period

Remarks:

Example:

IPMT(.10/12, 1*3, 3, 8000,0,0) = -22.41

IPMT(.10, 3, 3, 8000,0,0) = -292.45

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.