September 2011
Beginner
140 pages
3h 40m
English
Complementary to the CUMIPMT function, CUMPRINC returns the amount of the compound principal capital that needs to be paid back within a given period of time defined as the total number of payment periods (months, quarters, years, and so on). It is assumed that the rate of interest remains constant for the whole accounting period.
Figure 8-2. Sample result of the CUMPRINC function
This function is useful if you want to know how much of the principal capital borrowed needs to be paid back within the specified amount of time or any shorter interval ...
Read now
Unlock full access