September 2011
Beginner
140 pages
3h 40m
English
The CUMIPMT (cumulative compounded interest) function returns the amount of interest that needs to be paid on the principal or capital, borrowed for a period of time. It is defined as the total number of payment periods (months, quarters, years, and so on).
Figure 8-1. Sample result of the CUMIPMT function
It is assumed that the rate of interest remains constant for the whole accounting period. You can calculate the amount of interest to be paid back for the whole period or a part of it using the start and end arguments. For example, if you ...
Read now
Unlock full access