Spread.NET 17 Formula Reference
In This Topic
    In This Topic

    This function returns the cumulative principal paid on a loan between the start and end periods.




    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


    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.




    Version Available

    This function is available in product version 2.0 or later.

    See Also

    CUMIPMT | IPMT | Financial Functions