Required. The total number of periods in an annuity.
A monthly payment - 12
Quarterly payment - 4
Required. Present value.
Required. The first period.
Required. The last period.
Required. When payments are due.
0 - End of period.
1 - At the beginning of the period.
The CUMPRINC function returns
#NUM error value if:
start_period < 1
end_period < 1
start_period > end_period
type is not 0 (zero) or 1
Use the same unit for rate and nper, the above example uses monthly payments. That is why the interest rate is divided by 12 and nper is multiplied by 12. There are 120 monthly payments in a 10 year period.
This image shows the principal for month 25 to 36 and the cumulative principal. The amount in cell G22 is the same as in the top image cell E3.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Financial'
The CUMPRINC function function is one of many functions in the 'Financial' category.