Navigation:  Formula Reference > Spreadsheet Formula Functions >

CUMIPMT

Previous pageReturn to chapter overviewNext page

 

This function returns the cumulative interest paid on a loan between the starting and ending periods.

Syntax

CUMIPMT(rate,nper,pval,startperiod,endperiod,paytype)

Arguments

This function has these arguments:

Argument

Description

rate

Interest rate

nper

Total number of payment periods

pval

Present value

startperiod

Starting period

endperiod

Ending period

paytype

Type of payment timing; can be any of:

 

0 - Payment at end of the period

 

1 - Payment at beginning of the period

Remarks

This functions returns a #NUM! error when rate, nper, or pval is negative or zero. Nper, startperiod, endperiod, and paytype are truncated to integers. If startperiod or endperiod is less than 1 or startperiod is greater than endperiod, a #NUM! error is returned. If paytype is a number other than 0 or 1, a #NUM! error is returned.

Data Types

Accepts numeric and DateTime object data. Returns numeric data.

Examples

CUMIPMT(B2/12,B4*12,C4,14,20,0)

CUMIPMT(B2/12,B4*12,C4,14,20,0)

 

See Also

CUMPRINC

INTRATE