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

<?php

return [
    [
        -75.623186008367,
        [0.10 / 12, 1, 2 * 12, 2000],
    ],
    [
        -91.597714484189,
        [-0.10 / 12, 1, 2 * 12, 2000],
    ],
    [
        -27598.053462421,
        [0.08, 10, 10, 200000],
    ],
    [
        -13356.484444134500,
        [-0.08, 10, 10, 200000],
    ],
    [
        -735.22834886722,
        [0.05 / 12, 1, 60, 50000],
    ],
    [
        -940.107483227145,
        [-0.05 / 12, 1, 60, 50000],
    ],
    [
        -738.29180032083,
        [0.05 / 12, 2, 60, 50000],
    ],
    [
        -936.190368713698,
        [-0.05 / 12, 2, 60, 50000],
    ],
    [
        -600.85202718047,
        [0.035 / 4, 1, 8, 0, 5000, 1],
    ],
    [
        -606.109482418299,
        [0.035 / 4, 2, 8, 0, 5000, 1],
    ],
    [
        '#VALUE!',
        ['NaN', 2, 8, 0, 5000, 1],
    ],
    [
        '#VALUE!',
        [0.035 / 4, 'NaN', 8, 0, 5000, 1],
    ],
    [
        '#VALUE!',
        [0.035 / 4, 2, 'NaN', 0, 5000, 1],
    ],
    [
        '#VALUE!',
        [0.035 / 4, 2, 8, 'NaN', 5000, 1],
    ],
    [
        '#VALUE!',
        [0.035 / 4, 2, 8, 0, 'NaN', 1],
    ],
    [
        '#VALUE!',
        [0.035 / 4, 2, 8, 0, 5000, 'NaN'],
    ],
    [
        '#NUM!',
        [0.035 / 4, 0, 8, 0, 5000, 1],
    ],
    [
        '#NUM!',
        [0.035 / 4, 4, 2, 0, 5000, 1],
    ],
    [
        '#NUM!',
        [0.035 / 4, 2, 8, 0, 5000, 2],
    ],
];