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

93 lines
1.7 KiB
PHP

<?php
return [
[
-52990.70632392715,
[0.05 / 12, 60, 1000],
],
[
-68327.092460502600,
[-0.05 / 12, 60, 1000],
],
[
-26762.755452881098,
[0.10 / 4, 16, 2000, 0, 1],
],
[
-38955.527352284700,
[-0.10 / 4, 16, 2000, 0, 1],
],
[
26762.755452881100,
[0.10 / 4, 16, -2000, 0, 1],
],
[
-34846.254654898500,
[0.10 / 4, 16, 2000, 12000, 1],
],
[
18679.256250863700,
[0.10 / 4, 16, -2000, 12000, 1],
],
[
-18679.256250863700,
[0.10 / 4, 16, 2000, -12000, 1],
],
[
34846.254654898500,
[0.10 / 4, 16, -2000, -12000, 1],
],
[
56948.685406482400,
[-0.10 / 4, 16, -2000, -12000, 1],
],
[
-5555.6058459337655,
[0.075 / 12, 2 * 12, 250, null, 0],
],
[
-9252.072719337915,
[0.06 / 52, 4 * 52, 50, null, 1],
],
[
-762.8840472202697,
[0.0525 / 1, 10 * 1, 100, null, 0],
],
[
-1000.0,
[0.0, 10 * 1, 100, null, 0],
],
[
'#VALUE!',
['NaN', 10 * 1, 100, null, 0],
],
[
'#VALUE!',
[0.0525 / 1, 'NaN', 100, null, 0],
],
[
'#VALUE!',
[0.0525 / 1, 10 * 1, 'NaN', null, 0],
],
[
'#VALUE!',
[0.0525 / 1, 10 * 1, 100, 'NaN', 0],
],
[
'#VALUE!',
[0.0525 / 1, 10 * 1, 100, null, 'NaN'],
],
[
'#NUM!',
[0.0525 / 1, 10 * 1, 100, null, -1],
],
[
'#NUM!',
[0.0525 / 1, 10 * 1, 100, null, 2.5],
],
[
'#NUM!',
[0.0525 / 1, 10 * -1, 100, null, 1],
],
];