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

<?php

// values, guess, Result

return [
    [
        -0.02124484827341,
        [
            -70000,
            12000,
            15000,
            18000,
            21000,
        ],
    ],
    [
        0.086630948036519995,
        [
            -70000,
            12000,
            15000,
            18000,
            21000,
            26000,
        ],
    ],
    [
        -0.1821374641455,
        [
            -70000,
            12000,
            15000,
            18000,
        ],
        0.10,
    ],
    [
        -0.13618951095869,
        [
            -100,
            [
                20,
                24,
                28.8,
            ],
        ],
    ],
    [
        0.13057575637152699,
        [
            -100,
            [
                20,
                24,
                28.8,
                34.56,
                41.47,
            ],
        ],
    ],
    [
        '#VALUE!',
        999,
        1.23,
    ],
    [
        '#VALUE!',
        [
            70000,
            12000,
            15000,
            18000,
            21000,
        ],
    ],
    [
        '#VALUE!',
        [
            -70000,
            -12000,
            -15000,
            -18000,
            -21000,
        ],
    ],
    'no arguments' => ['exception'],
];