PhpSpreadsheet/tests/data/Calculation/Financial/FV.php

123 lines
2.0 KiB
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],
],
];