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

<?php

// rate, per, nper, pv, result

return [
    [
        -66111.111111111,
        0.0085,
        1,
        36,
        8000000,
    ],
    [
        -533333.33333333,
        0.10,
        1,
        3,
        8000000,
    ],
    [
        -205.270833333,
        0.004175,
        1,
        60,
        50000,
    ],
    [
        -201.791666667,
        0.004175,
        2,
        60,
        50000,
    ],
    [
        0.0,
        0.00,
        1,
        3,
        8000000,
    ],
    [
        0.0,
        0.125,
        3,
        3,
        8000000,
    ],
    [
        '#VALUE!',
        'NaN',
        3,
        3,
        8000000,
    ],
    [
        '#VALUE!',
        0.125,
        'NaN',
        3,
        8000000,
    ],
    [
        '#VALUE!',
        0.125,
        3,
        'NaN',
        8000000,
    ],
    [
        '#VALUE!',
        0.125,
        3,
        3,
        'NaN',
    ],
    [
        '#NUM!',
        0.125,
        -1,
        3,
        800000,
    ],
    [
        '#NUM!',
        0.125,
        4,
        3,
        800000,
    ],
];