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

<?php

// Issue date, 1st Interest, Settlement, Rate, Par, Freq, Basis, Result

return [
    [
        16.6666666666666,
        '2008-03-01', '2008-08-31', '2008-05-01', 0.10, 1000, 2, 0,
    ],
    [
        15.5555555555559,
        '2008-03-05', '2008-08-31', '2008-05-01', 0.10, 1000, 2, 0,
    ],
    [
        15.5555555555559,
        '2008-03-05', '2008-08-31', '2008-05-01', 0.10, 1000, 2, null,
    ],
    [
        15.5555555555559,
        '2008-03-05', '2008-08-31', '2008-05-01', 0.10, 1000, 2, 0,
    ],
    [
        7.22222222222222,
        '2008-04-05', '2008-08-31', '2008-05-01', 0.10, 1000, 2, 0,
    ],
    [
        200,
        '2010-01-01', '2010-06-30', '2010-04-01', 0.08, 10000, 4,
    ],
    [
        1600,
        '2012-01-01', '2012-04-01', '2013-12-31', 0.08, 10000, 4,
    ],
    [
        32.363013698630134,
        '2012-01-01', '2012-03-31', '2012-02-15', 0.0525, 5000, 4, 3,
    ],
    [
        6.472602739726027,
        '2012-01-01', '2012-03-31', '2012-02-15', 0.0525, 1000, 4, 3,
    ],
    [
        18.05555555555555,
        '2017-08-05', '2017-11-10', '2017-10-10', 0.05, 2000, 4, 0,
    ],
    [
        '#NUM!',
        '2008-03-05', '2008-08-31', '2008-05-01', -0.10, 1000, 2, 0,
    ],
    [
        '#VALUE!',
        'Invalid Date', '2008-08-31', '2008-05-01', 0.10, 1000, 2, 0,
    ],
    [
        '#VALUE!',
        '2008-03-01', '2008-08-31', '2008-05-01', 'ABC', 1000, 2, 0,
    ],
    'Non-numeric Rate' => [
        '#VALUE!',
        '2008-03-01', '2008-08-31', '2008-05-01', 'NaN', 1000, 2, 0,
    ],
    'Invalid Rate' => [
        '#NUM!',
        '2008-03-01', '2008-08-31', '2008-05-01', -0.10, 1000, 2, 0,
    ],
    'Non-numeric Par Value' => [
        '#VALUE!',
        '2008-03-01', '2008-08-31', '2008-05-01', 0.10, 'NaN', 2, 0,
    ],
    'Invalid Par Value' => [
        '#NUM!',
        '2008-03-01', '2008-08-31', '2008-05-01', 0.10, -1000, 2, 0,
    ],
    'Non-numeric Frequency' => [
        '#VALUE!',
        '2008-03-01', '2008-08-31', '2008-05-01', 0.10, 1000, 'NaN', 0,
    ],
    'Invalid Frequency' => [
        '#NUM!',
        '2008-03-01', '2008-08-31', '2008-05-01', 0.10, -1000, 3, 0,
    ],
    'Non-numeric Basis' => [
        '#VALUE!',
        '2008-03-01', '2008-08-31', '2008-05-01', 0.10, 1000, 2, 'ABC',
    ],
    'Invalid Basis' => [
        '#NUM!',
        '2008-03-01', '2008-08-31', '2008-05-01', 0.10, 1000, 2, -2,
    ],
];