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

<?php

// Periods, Payment, Present Value, Future Value, Type, Guess, Result

return [
    [
        0.0077014724882014003,
        48,
        -200,
        8000,
    ],
    [
        0.046781916422493401,
        60,
        -6000,
        120000,
    ],
    [
        -0.020442952219356499,
        60,
        -1000,
        120000,
    ],
    [
        0.015130843902343399,
        24,
        -250,
        5000,
    ],
    [
        0.016550119066711999,
        24,
        -250,
        5000,
        null,
        1,
    ],
    [
        0.087499997684093694,
        208,
        -700,
        8000,
    ],
    [
        0.087113755605863596,
        10,
        -1000,
        6500,
    ],
    [
        0.048472127283572801,
        6,
        -1000,
        100000,
        -126068,
    ],
    [
        0.030272873827543501,
        6,
        1000,
        100000,
        -126068,
    ],
    [
        0.030272873827543699,
        6,
        -1000,
        -100000,
        126068,
        0,
    ],
    [
        '#NUM!',
        0,
        1,
        8000,
    ],
    [
        '#NUM!',
        208,
        -700,
        8000,
        0,
        0,
        0,
    ],
    [
        -1.000125, // Excel says #NUM!, but I believe this is correct
        1,
        1,
        8000,
    ],
    [
        6.9258100553578E-10,
        208,
        -700,
        137600,
        8000,
    ],
    [
        0.00054607632544395,
        208,
        -700,
        137600,
    ],
    [
        '#VALUE!',
        'NaN',
        -700,
        8000,
        0,
        0,
        0,
    ],
    [
        '#VALUE!',
        208,
        'NaN',
        8000,
        0,
        0,
        0,
    ],
    [
        '#VALUE!',
        208,
        -700,
        'NaN',
        0,
        0,
        0,
    ],
    [
        '#VALUE!',
        208,
        -700,
        8000,
        'NaN',
        0,
        0,
    ],
    [
        '#VALUE!',
        208,
        -700,
        8000,
        0,
        'NaN',
        0,
    ],
    [
        '#VALUE!',
        208,
        -700,
        8000,
        0,
        0,
        'NaN',
    ],
];