mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-23 22:18:30 +00:00
Mark Baker
5ad5f787ab
* First steps splitting out the Amortization and Deprecation Excel functions from Financials * Verify which methods allow negative values for arguments * Additional unit tests for SLN() and SYD() * Additional unit tests for DDB() * Additional unit tests for DB() * Verify Amortization cases where salvage is greater than cost * More unit tests for Amortization * Resolve broken test in AMORLINC() and extract amortizationCoefficient calculation * verify amortizationCoefficient calculation * Extract YIELDDISC() and YIELDMAT() to Financial\Securities * Additional validation for Securities Yield functions
97 lines
1.4 KiB
PHP
97 lines
1.4 KiB
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
3000,
|
|
[10000, 1000, 5, 1],
|
|
],
|
|
[
|
|
2400,
|
|
[10000, 1000, 5, 2],
|
|
],
|
|
[
|
|
1800,
|
|
[10000, 1000, 5, 3],
|
|
],
|
|
[
|
|
1200,
|
|
[10000, 1000, 5, 4],
|
|
],
|
|
[
|
|
600,
|
|
[10000, 1000, 5, 5],
|
|
],
|
|
[
|
|
1428.5714285714287,
|
|
[8000, 0, 7, 3],
|
|
],
|
|
[
|
|
4090.909090909091,
|
|
[30000, 7500, 10, 1],
|
|
],
|
|
[
|
|
409.09090909090907,
|
|
[30000, 7500, 10, 10],
|
|
],
|
|
[
|
|
-800,
|
|
[-2000, 1000, 5, 2],
|
|
],
|
|
[
|
|
3771.4285714285716,
|
|
[12000, 1000, 2.5, 2],
|
|
],
|
|
[
|
|
5028.571428571428,
|
|
[12000, 1000, 2.5, 1.5],
|
|
],
|
|
[
|
|
-600,
|
|
[-2000, 1000, 5, 3],
|
|
],
|
|
[
|
|
-800,
|
|
[12000, 15000, 5, 2],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[12000, -1000, 5, 3],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[10000, 1000, 5, 10],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
['INVALID', 1000, 5, 1],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[12000, 'INVALID', 5, 1],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[12000, 1000, 'INVALID', 1],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[12000, 1000, 5, 'INVALID'],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[12000, -1, 5, 2],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[12000, 1000, -5, 1],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[12000, 1000, 5, 0],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
[12000, 1000, 5, -1],
|
|
],
|
|
];
|