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

<?php

return [
    [
        -52990.70632392715,
        [0.05 / 12, 60, 1000],
    ],
    [
        -68327.092460502600,
        [-0.05 / 12, 60, 1000],
    ],
    [
        -26762.755452881098,
        [0.10 / 4, 16, 2000, 0, 1],
    ],
    [
        -38955.527352284700,
        [-0.10 / 4, 16, 2000, 0, 1],
    ],
    [
        26762.755452881100,
        [0.10 / 4, 16, -2000, 0, 1],
    ],
    [
        -34846.254654898500,
        [0.10 / 4, 16, 2000, 12000, 1],
    ],
    [
        18679.256250863700,
        [0.10 / 4, 16, -2000, 12000, 1],
    ],
    [
        -18679.256250863700,
        [0.10 / 4, 16, 2000, -12000, 1],
    ],
    [
        34846.254654898500,
        [0.10 / 4, 16, -2000, -12000, 1],
    ],
    [
        56948.685406482400,
        [-0.10 / 4, 16, -2000, -12000, 1],
    ],
    [
        -5555.6058459337655,
        [0.075 / 12, 2 * 12, 250, null, 0],
    ],
    [
        -9252.072719337915,
        [0.06 / 52, 4 * 52, 50, null, 1],
    ],
    [
        -762.8840472202697,
        [0.0525 / 1, 10 * 1, 100, null, 0],
    ],
    [
        -1000.0,
        [0.0, 10 * 1, 100, null, 0],
    ],
    [
        '#VALUE!',
        ['NaN', 10 * 1, 100, null, 0],
    ],
    [
        '#VALUE!',
        [0.0525 / 1, 'NaN', 100, null, 0],
    ],
    [
        '#VALUE!',
        [0.0525 / 1, 10 * 1, 'NaN', null, 0],
    ],
    [
        '#VALUE!',
        [0.0525 / 1, 10 * 1, 100, 'NaN', 0],
    ],
    [
        '#VALUE!',
        [0.0525 / 1, 10 * 1, 100, null, 'NaN'],
    ],
    [
        '#NUM!',
        [0.0525 / 1, 10 * 1, 100, null, -1],
    ],
    [
        '#NUM!',
        [0.0525 / 1, 10 * 1, 100, null, 2.5],
    ],
    [
        '#NUM!',
        [0.0525 / 1, 10 * -1, 100, null, 1],
    ],
];