Returns the cumulative interest paid for an investment period with a constant interest rate.
CUMPRINC(Rate; NPer; PV; S; E; Type)
Rate is the periodic interest rate.
NPer is the payment period with the total number of periods. Nper can also be a non-integer value.
PV is the current value in the sequence of payments.
S is the first period.
E is the last period.
Type is the due date of the payment at the beginning or end of each period.
What are the payoff amounts if the yearly interest rate is 5.5% for 36 months? The cash value is 15,000 currency units. The payoff amount is calculated between the 10th and 18th period. The due date is at the end of the period.
=CUMPRINC(5.5%/12;36;15000;10;18;0) = -3669.74 currency units. The payoff amount between the 10th and 18th period is 3669.74 currency units.