CUMPRINC(R, N, P, S, E, T)

 

Description

This function returns the cumulative principal 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:

 

 

Examples

 

CUMPRINC(9.5%/12, 3012, 100000, 1, 12, 0) = 616.64