mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-22 07:53:42 +00:00
Mark Baker
a34695e0f9
* Additional unit tests and rationalisation for Financial Functions * Providing a series of sample files for Financial functions * Refactor the last of the existing Financial functions * Some more unit tests with default assignments from null arguments Co-authored-by: Adrien Crivelli <adrien.crivelli@gmail.com>
160 lines
2.0 KiB
PHP
160 lines
2.0 KiB
PHP
<?php
|
|
|
|
// rate, nper, pv, start_period, end_period, type, result
|
|
|
|
return [
|
|
[
|
|
-934.10712342088004,
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
13,
|
|
24,
|
|
0,
|
|
],
|
|
[
|
|
-68.278271180977001,
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
1,
|
|
1,
|
|
0,
|
|
],
|
|
[
|
|
-68.278271180977001,
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
1,
|
|
1,
|
|
null,
|
|
],
|
|
[
|
|
-9025.875084814226,
|
|
0.004175,
|
|
60,
|
|
50000,
|
|
1,
|
|
12,
|
|
0,
|
|
],
|
|
[
|
|
-9488.600856134633,
|
|
0.004175,
|
|
60,
|
|
50000,
|
|
13,
|
|
24,
|
|
0,
|
|
],
|
|
[
|
|
-9975.04899646991,
|
|
0.004175,
|
|
60,
|
|
50000,
|
|
25,
|
|
36,
|
|
0,
|
|
],
|
|
[
|
|
-10486.435670612591,
|
|
0.004175,
|
|
60,
|
|
50000,
|
|
37,
|
|
48,
|
|
0,
|
|
],
|
|
[
|
|
-11024.039391968092,
|
|
0.004175,
|
|
60,
|
|
50000,
|
|
49,
|
|
60,
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'NaN',
|
|
360,
|
|
125000,
|
|
13,
|
|
24,
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
'NaN',
|
|
125000,
|
|
13,
|
|
24,
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
360,
|
|
'NaN',
|
|
13,
|
|
24,
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
'NaN',
|
|
24,
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
13,
|
|
'NaN',
|
|
0,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
13,
|
|
24,
|
|
'NaN',
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
24,
|
|
13,
|
|
0,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
0.0075,
|
|
360,
|
|
125000,
|
|
24,
|
|
13,
|
|
2,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
0.0075,
|
|
10,
|
|
125000,
|
|
13,
|
|
24,
|
|
0,
|
|
],
|
|
];
|