|
CUMIPMT(R, N, P, S, E, T) |
|
Description
This function returns the cumulative interest paid between S (the start) and E (the end) on a loan. Make sure that you are consistent about the units used for specifying R and N. (For example, for a 4-year loan with 10% annual interest rate, use 10%/12 for R and 412 for N.)
Parameters
R
Rate, a numeric expression.
N
Number of payments, an integer greater than 0.
P
Present value.
S
Starting period in calculation.
E
Ending period in calculation.
T
(Optional) Timing of the payment:
0 |
Payment is made at the end of the period. |
1 |
Payment is made at the beginning of the period. |
Examples
CUMIPMT(9.5%/12, 3012, 100000, 1, 12, 0) = 9473.61
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support