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

<?php

// rate, nper, pmt, pv, type, Result

return [
    [
        2581.4033740600998,
        [0.005, 10, -200, -500, 1],
    ],
    [
        2421.371872695160,
        [-0.005, 10, -200, -500, 1],
    ],
    [
        12682.503013197,
        [0.01, 12, -1000],
    ],
    [
        11361.512828387000,
        [-0.01, 12, -1000],
    ],
    [
        82859.19732763403,
        [0.009175, 35, -2000, null, 1],
    ],
    [
        2301.4018303408998,
        [0.005, 12, -100, -1000, 1],
    ],
    [
        2103.328949318290,
        [-0.005, 12, -100, -1000, 1],
    ],
    [
        -178.046206611904,
        [0.005, 12, 100, -1000, 1],
    ],
    [
        178.046206611904,
        [0.005, 12, -100, 1000, 1],
    ],
    [
        -2301.401830340900,
        [0.005, 12, 100, 1000, 1],
    ],
    [
        -220.083335489543,
        [-0.005, 12, 100, -1000, 1],
    ],
    [
        220.083335489543,
        [-0.005, 12, -100, 1000, 1],
    ],
    [
        -2103.328949318290,
        [-0.005, 12, 100, 1000, 1],
    ],
    [
        68023.43754198513,
        [0.004175, 60, -1000],
    ],
    [
        39729.460894165997,
        [0.025, 16, -2000, 0, 1],
    ],
    [
        1300,
        [0.0, 12, -100, -100],
    ],
    [
        -1100,
        [0.0, 12, 100, -100],
    ],
    [
        1100,
        [0.0, 12, -100, 100],
    ],
    [
        -1300,
        [0.0, 12, 100, 100],
    ],
    [
        '#VALUE!',
        ['NaN', 12, -100, -100],
    ],
    [
        '#VALUE!',
        [0.0, 'NaN', -100, -100],
    ],
    [
        '#VALUE!',
        [0.0, 12, 'NaN', -100],
    ],
    [
        '#VALUE!',
        [0.0, 12, -100, 'NaN'],
    ],
    [
        '#VALUE!',
        [0.0, 12, -100, -100, 'NaN'],
    ],
    [
        -33882857.54639115,
        [-0.10, -100, -100, 0, 1],
    ],
    [
        -10000.00,
        [0.0, -100, -100, 0, 1],
    ],
    [
        -100.0,
        [0.10, -1, -100, 0, 1],
    ],
    [
        '#NUM!',
        [0.10, 12, -100, 0, 2],
    ],
    [
        '#NUM!',
        [0.10, 12, -100, 0, -1],
    ],
];