Documentation/Calc Functions/CUMPRINC ADD

    From The Document Foundation Wiki
    Other languages:

    Function name:

    CUMPRINC_ADD

    Category:

    Financial Analysis

    Summary:

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

    CUMPRINC_ADD performs a similar calculation to the CUMPRINC function. However, by default the value returned by CUMPRINC is formatted in a locale-dependent currency format whereas formatting is not applied to the value returned by CUMPRINC_ADD. In addition, CUMPRINC 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.

    CUMPRINC_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 CUMPRINC function, those calls are converted to calls to the CUMPRINC_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 CUMPRINC_ADD function are converted to refer to the CUMPRINC 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 CUMPRINC function, which is compliant with ODF 1.2.

    Syntax:

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

    Returns:

    -

    Arguments:

    -

    Additional details:

    -

    Examples:

    -

    Related LibreOffice functions:

    -

    ODF standard:

    -

    Related (or similar) Excel functions:

    -