Spread Formula Reference
In This Topic
    CUMIPMT
    In This Topic

    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)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    CUMPRINC | INTRATE | Financial Functions