xny/vendor/phpoffice/phpspreadsheet/tests/data/Calculation/Financial/CUMPRINC.php

<?php

// rate, nper, pv, start_period, end_period, type, result

return [
    [
        -934.10712342088004,
        0.0075,
        360,
        125000,
        13,
        24,
        0,
    ],
    [
        -68.278271180977001,
        0.0075,
        360,
        125000,
        1,
        1,
        0,
    ],
    [
        -68.278271180977001,
        0.0075,
        360,
        125000,
        1,
        1,
        null,
    ],
    [
        -9025.875084814226,
        0.004175,
        60,
        50000,
        1,
        12,
        0,
    ],
    [
        -9488.600856134633,
        0.004175,
        60,
        50000,
        13,
        24,
        0,
    ],
    [
        -9975.04899646991,
        0.004175,
        60,
        50000,
        25,
        36,
        0,
    ],
    [
        -10486.435670612591,
        0.004175,
        60,
        50000,
        37,
        48,
        0,
    ],
    [
        -11024.039391968092,
        0.004175,
        60,
        50000,
        49,
        60,
        0,
    ],
    [
        '#VALUE!',
        'NaN',
        360,
        125000,
        13,
        24,
        0,
    ],
    [
        '#VALUE!',
        0.0075,
        'NaN',
        125000,
        13,
        24,
        0,
    ],
    [
        '#VALUE!',
        0.0075,
        360,
        'NaN',
        13,
        24,
        0,
    ],
    [
        '#VALUE!',
        0.0075,
        360,
        125000,
        'NaN',
        24,
        0,
    ],
    [
        '#VALUE!',
        0.0075,
        360,
        125000,
        13,
        'NaN',
        0,
    ],
    [
        '#VALUE!',
        0.0075,
        360,
        125000,
        13,
        24,
        'NaN',
    ],
    [
        '#VALUE!',
        0.0075,
        360,
        125000,
        24,
        13,
        0,
    ],
    [
        '#NUM!',
        0.0075,
        360,
        125000,
        24,
        13,
        2,
    ],
    [
        '#NUM!',
        0.0075,
        10,
        125000,
        13,
        24,
        0,
    ],
];