mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-20 10:40:42 +00:00
Mark Baker
42761f90b7
* Start extracting CashFlow functions from Financial, beginning with the simple Single Rate flows * Extracting Variable Periodic and NonPeriodic CashFlow functions from Financial * Some more unit tests for exception cases
102 lines
1.5 KiB
PHP
102 lines
1.5 KiB
PHP
<?php
|
|
|
|
// values, finance_rate, reinvestment_rate, Result
|
|
|
|
return [
|
|
[
|
|
0.12609413036591,
|
|
[
|
|
-120000,
|
|
[
|
|
39000,
|
|
30000,
|
|
21000,
|
|
37000,
|
|
46000,
|
|
],
|
|
],
|
|
0.10,
|
|
0.12,
|
|
],
|
|
[
|
|
-0.048044655249981,
|
|
[
|
|
-120000,
|
|
[
|
|
39000,
|
|
30000,
|
|
21000,
|
|
],
|
|
],
|
|
0.10,
|
|
0.12,
|
|
],
|
|
[
|
|
0.13475911082830999,
|
|
[
|
|
-120000,
|
|
[
|
|
39000,
|
|
30000,
|
|
21000,
|
|
37000,
|
|
46000,
|
|
],
|
|
],
|
|
0.10,
|
|
0.14,
|
|
],
|
|
[
|
|
0.74021752686287001,
|
|
[
|
|
-100,
|
|
[
|
|
12,
|
|
14,
|
|
11,
|
|
],
|
|
],
|
|
5.5,
|
|
5,
|
|
],
|
|
[
|
|
1.8579321744785,
|
|
[
|
|
-100,
|
|
[
|
|
12,
|
|
14,
|
|
11,
|
|
13,
|
|
16,
|
|
],
|
|
],
|
|
5.5,
|
|
5,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
999,
|
|
1.23,
|
|
2.34,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[0.12, 0.13, 0.125],
|
|
1.23,
|
|
2.34,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[-0.12, -0.13, -0.125],
|
|
1.23,
|
|
2.34,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[-0.12, 0.13, 0.125],
|
|
1.23,
|
|
-2.34,
|
|
],
|
|
];
|