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 principal repaid on a loan.
Returns the cumulative principal repaid on a loan between two specified payment periods.
Example
Returns roughly $-1,273.14. Consider a three-year loan of $8,000 at 6% annual interest with monthly end-of-month payments. The total principal repaid during months 7 through 12 is roughly $1,273.14. The result is negative because principal repayment is an outgoing payment.