Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

CUMPRINC

Description: Returns the cumulative principal paid on a loan between two periods.

Syntax: CUMPRINC(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:

CUMPRINC(.09/12, 30*12, 125000, 13, 24, 0) = -934.1071

 

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