mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-24 19:38:20 +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
69 lines
926 B
PHP
69 lines
926 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
1800,
|
|
[10000, 1000, 5],
|
|
],
|
|
[
|
|
1000,
|
|
[10000, 5000, 5],
|
|
],
|
|
[
|
|
1142.857142857143,
|
|
[8000, 0, 7],
|
|
],
|
|
[
|
|
50,
|
|
[500, 100, 8],
|
|
],
|
|
[
|
|
2250,
|
|
[30000, 7500, 10],
|
|
],
|
|
[
|
|
166.66666666666666,
|
|
[1200, 200, 6],
|
|
],
|
|
[
|
|
3750,
|
|
[45000, 7500, 10],
|
|
],
|
|
[
|
|
-10500,
|
|
[12000, 1500, -1],
|
|
],
|
|
[
|
|
21000,
|
|
[12000, 1500, 0.5],
|
|
],
|
|
[
|
|
3250,
|
|
[12000, -1000, 4],
|
|
],
|
|
[
|
|
-250,
|
|
[0, 1000, 4],
|
|
],
|
|
[
|
|
-600,
|
|
[12000, 15000, 5],
|
|
],
|
|
[
|
|
'#DIV/0!',
|
|
[12000, 1500, 0],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
['INVALID', 1000, 1],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[12000, 'INVALID', 1],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
[12000, 1000, 'INVALID'],
|
|
],
|
|
];
|