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

<?php

// rate, per, nper, pv, fv, type, Result

return [
    [
        -22.858787457480013,
        [0.0085, 3, 3, 8000],
    ],
    [
        22.473454124370,
        [-0.0085, 3, 3, 8000],
    ],
    [
        -292.44712990937001,
        [0.10, 3, 3, 8000],
    ],
    [
        239.114391143911,
        [-0.10, 3, 3, 8000],
    ],
    [
        -212.50,
        [0.00425, 1, 60, 50000],
    ],
    [
        212.50,
        [-0.00425, 1, 60, 50000],
    ],
    [
        -209.38324500656188,
        [0.00425, 2, 60, 50000],
    ],
    [
        208.495090812845,
        [-0.00425, 2, 60, 50000],
    ],
    [
        0.0,
        [0.00875, 1, 8, 10000, 5000, 1],
    ],
    [
        0.0,
        [-0.00875, 1, 8, 10000, 5000, 1],
    ],
    [
        -70.968650395558996,
        [0.00875, 2, 8, 10000, 5000, 1],
    ],
    [
        71.207753426393,
        [-0.00875, 2, 8, 10000, 5000, 1],
    ],
    [
        '#VALUE!',
        ['NaN', 2, 8, 10000, 5000, 1],
    ],
    [
        '#VALUE!',
        [0.00875, 'NaN', 8, 10000, 5000, 1],
    ],
    [
        '#VALUE!',
        [0.00875, 2, 'NaN', 10000, 5000, 1],
    ],
    [
        '#VALUE!',
        [0.00875, 2, 8, 'NaN', 5000, 1],
    ],
    [
        '#VALUE!',
        [0.00875, 2, 8, 10000, 'NaN', 1],
    ],
    [
        '#VALUE!',
        [0.00875, 2, 8, 10000, 5000, 'NaN'],
    ],
    [
        '#NUM!',
        [0.00875, 2, 8, 10000, 5000, 2],
    ],
    [
        '#NUM!',
        [0.005, -1, 8, 2500, 200, 1],
    ],
    [
        '#NUM!',
        [0.005, 8, 2, 2500, 200, 1],
    ],
];