Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

CUMIPMT

Description: Returns the cumulative interest paid between two periods.

Syntax: CUMIPMT(Rate, Nper, PV, Start_Period, End_Period, Type)

Type Timing
0 (zero) Payment at the end of the period
1  Payment at the beginning of the period

 

Remarks:

Example:

CUMIPMT(0.09/12, 30*12, 125000, 13, 24, 0) = -11135.23

 

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