Rate
The interest rate per period.
NumberOfPeriods
The total number of payment periods in the term.
PresentValue
The initial sum borrowed.
Start
The first period to include (periods are numbered beginning with 1).
End
The last period to include.
Type
0 To specify that payments are made at the end of each period and 1 to specify that payments are made at the start of each period (including a payment at the start of the term).
Returns
The cumulative interest paid on a loan.
Returns the cumulative interest paid on a loan between two specified payment periods.
Example
Returns roughly $-187.11. Consider a three-year loan of $8,000 at 6% annual interest with monthly end-of-month payments. The total interest paid during months 7 through 12 is roughly $187.11. The result is negative because interest is an outgoing payment.