Documentation/Calc Functions/CUMIPMT ADD

    From The Document Foundation Wiki
    Other languages:

    Function name:

    CUMIPMT_ADD

    Category:

    Financial Analysis

    Summary:

    Calculates the total or cumulative interest paid during a time interval, for a fixed-rate loan that is based on a specified number of regular payments over a defined term.

    CUMIPMT_ADD performs a similar calculation to the CUMIPMT function. However, by default the value returned by CUMIPMT is formatted in a locale-dependent currency format whereas formatting is not applied to the value returned by CUMIPMT_ADD. In addition, CUMIPMT benefits from its use of a Kahan summation algorithm which attempts to reduce the numerical error that can arise when adding a sequence of finite-precision floating-point numbers.

    CUMIPMT_ADD exists only for interoperability with legacy documents created with older versions of Microsoft Excel. In Calc, if you open an Excel 2003 (.xls) file that contains calls to the CUMIPMT function, those calls are converted to calls to the CUMIPMT_ADD function. If you save a document from Calc in ODS (Open Document Format for Office Applications) or OOXML (Office Open XML) format, any calls to the CUMIPMT_ADD function are converted to refer to the CUMIPMT function.

    Because of the limited applicability of this function, fuller details are intentionally omitted from this wiki.

    Note pin.svg

    Note:
    For all new documents and most cases that do not require interoperability with legacy Excel spreadsheets, it is recommended that you use Calc's CUMIPMT function, which is compliant with ODF 1.2.

    Syntax:

    CUMIPMT_ADD(Rate; Nper; Pv; Start period; End period; Type)

    Returns:

    -

    Arguments:

    -

    Additional details:

    -

    Examples:

    -

    Related LibreOffice functions:

    -

    ODF standard:

    -

    Related (or similar) Excel functions:

    -