Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php declare(strict_types=1); // result, message, values, dates, guess return [ 'I..
Decoded Output download
<?php
declare(strict_types=1);
// result, message, values, dates, guess
return [
'If values and dates contain a different number of values, returns the #NUM! error value' => [
'#NUM!',
[4000, -46000],
['2015-01-04'],
0.1,
],
'Cash flows are all negative' => [
'#NUM!',
[-4000, -46000],
['2015-01-04', '2019-06-27'],
0.1,
],
'Cash flows are all positive' => [
'#NUM!',
[4000, 46000],
['2015-01-04', '2019-06-27'],
0.1,
],
'If any number in dates is not a valid date, returns the #VALUE! error value' => [
'#VALUE!',
[4000, -46000],
['2015-01-04', '2019X06-27'],
0.1,
],
'If any entry in values is not numeric, returns the #VALUE! error value' => [
'#VALUE!',
['y', -46000],
['2015-01-04', '2019-06-27'],
0.1,
],
'If values is not an array, returns the #NUM! error value' => [
'#NUM!',
-46000,
['2015-01-04', '2019-06-27'],
0.1,
],
'If dates is not an array but values is, returns the #NUM! error value' => [
'#NUM!',
[4000, -46000],
'2015-01-04',
0.1,
],
'If neither dates nor values is an array, returns the #N/A error value' => [
'#N/A',
4000,
'2015-01-04',
0.1,
],
'Return VALUE error if guess is non-numeric' => [
'#VALUE!',
[1893.67, 139947.43, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-27', '2019-06-20', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
'XYZ',
],
'Dates can be in any order after all' => [
0.137963527441025,
[1893.67, 139947.43, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-27', '2019-06-20', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
0.1,
],
'XIRR calculation #0 is incorrect' => [
0.77868869226873,
[4000, -46000],
['2015-04-01', '2019-06-27'],
0.1,
],
'issue 689' => [
-0.6118824173,
[-1000000.706, 947003.58],
['2018-09-05', '2018-09-26'],
],
'issue 689 updated 2022-12-25' => [
-0.935842486,
[-20972.36, 20350.545],
['2022-12-12', '2022-12-16'],
],
'XIRR calculation #1 is incorrect' => [
0.137963527441025,
[139947.43, 1893.67, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-20', '2019-06-27', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
0.1,
],
'XIRR calculation #2 is incorrect' => [
0.09999999,
[100.0, -110.0],
['2019-06-12', '2020-06-11'],
0.1,
],
'XIRR calculation #3 is incorrect' => [
3235.159644,
[1.0, 1893.67, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-27', '2019-06-27', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
],
'XIRR calculation #4 is incorrect' => [
0.15467888,
[1893.67, 139947.43, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-20', '2019-06-27', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
],
'XIRR calculation #5 is incorrect' => [
-0.197387315,
[-100, 20, 40, 25],
['2010-01-01', '2010-04-01', '2010-10-01', '2011-02-01'],
],
'XIRR calculation #6 is incorrect' => [
3.434984565,
[-10000, 2750, 4250, 3250, 2750, 46000],
['2008-01-01', '2008-03-01', '2008-10-30', '2009-02-15', '2009-04-01', '2009-06-01'],
],
'Substitute for guess=0' => [
0.13796353,
[139947.43, 1893.67, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-20', '2019-06-27', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
0.00000,
],
'Substitute when guess is empty cell' => [
0.13796353,
[139947.43, 1893.67, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-20', '2019-06-27', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
'C1',
],
'Can\'t find a result2 that works after FINANCIAL_MAX_ITERATIONS tries, the #NUM! error value is returned' => [
'#NUM!',
[-10000, 10000, -10000, 5],
['2010-01-15', '2010-04-16', '2010-07-16', '2010-10-15'],
],
'See issue #2469 - non-convergence with initial guess' => [
-0.642307613,
[55600, -51094.83],
['2021-11-24', '2021-12-24'],
],
'See issue #2469 - non-convergence with initial guess equal to correct answer' => [
-0.642307613,
[55600, -51094.83],
['2021-11-24', '2021-12-24'],
-0.642307613,
],
'Only one argument should cause exception' => [
'exception',
['2021-11-24', '2021-12-24'],
],
'No argument should cause exception' => [
'exception',
],
'DeCampo One year no growth' => [
0,
[-1000, 1000],
['2010-01-01', '2011-01-01'],
],
'DeCampo One year growth' => [
0.1,
[-1000, 1100],
['2010-01-01', '2011-01-01'],
],
'DeCampo One year decline' => [
-0.1,
[-1000, 900],
['2010-01-01', '2011-01-01'],
],
'DeCampo vs spreadsheet' => [
0.1212676,
[-1000, -1000, -1000, -1000, 4300],
['2010-01-01', '2010-04-01', '2010-07-01', '2010-10-01', '2011-01-01'],
],
'DeCampo vs spreadsheet reordered' => [
0.1212676,
[-1000, 4300, -1000, -1000, -1000],
['2010-10-01', '2011-01-01', '2010-07-01', '2010-01-01', '2010-04-01'],
],
'DeCampo Over 100% growth' => [
2.0,
[-1000, 3000],
['2010-01-01', '2011-01-01'],
],
'DeCampo Total loss one year, agree with Excel not DeCampo' => [
'#NUM!', // -1.0, DeCampo accounts for this case, Excel doesn't
[-1000, 0],
['2010-01-01', '2011-01-01'],
],
'DeCampo Total loss two years, agree with Excel not DeCampo' => [
'#NUM!', // -1.0, DeCampo accounts for this case, Excel doesn't
[-1000, 0],
['2010-01-01', '2012-01-01'],
],
'DeCampo Readme example' => [
0.2504234710540838,
[-1000, -2500, -1000, 5050],
['2016-01-15', '2016-02-08', '2016-04-17', '2016-08-24'],
],
'DeCampo from nodejs' => [
0.2126861,
[-10000, 3027.25, 630.68, 2018.2, 1513.62, 1765.89, 4036.33, 4036.33, 1513.62, 1513.62, 2018.16, 1513.62, 1009.08, 1513.62, 1513.62, 1765.89, 1765.89, 22421.55],
['2000-05-24', '2000-06-05', '2001-04-09', '2004-02-24', '2005-03-18', '2006-02-15', '2007-01-10', '2007-11-14', '2008-12-17', '2010-01-15', '2011-01-14', '2012-02-03', '2013-01-18', '2014-01-24', '2015-01-30', '2016-01-22', '2017-01-20', '2017-06-05'],
],
'DeCampo issue5a, agree with DeCampo not Excel' => [
-0.7640294, // '#NUM!'
[-2610, -2589, -5110, -2550, -5086, -2561, -5040, -2552, -2530, 29520],
['2001-06-22', '2001-07-03', '2001-07-05', '2001-07-06', '2001-07-09', '2001-07-10', '2001-07-12', '2001-07-13', '2001-07-16', '2001-07-17'],
],
'DeCampo issue5b, agree with DeCampo not Excel' => [
-0.8353404, // '#NUM!'
[-2610, -2589, -5110, -2550, -5086, -2561, -5040, -2552, -2530, -9840, 38900],
['2001-06-22', '2001-07-03', '2001-07-05', '2001-07-06', '2001-07-09', '2001-07-10', '2001-07-12', '2001-07-13', '2001-07-16', '2001-07-17', '2001-07-18'],
],
'Python XIRR test line 20' => [
412461.6383,
[-100, 1000],
['2019-12-31', '2020-03-05'],
],
'Python XIRR test line 21' => [
1.223853529e16,
[-2236.3994659663, -47.3417585212, -46.52619316339632, 10424.74612565936, -13.077972551952],
['2017-12-16', '2017-12-26', '2017-12-29', '2017-12-31', '2017-12-20'],
],
'Python XIRR test line 39, agree with Python not Excel' => [
-1, // '#NUM!',
[18902, 83600, -5780, -4080, -56780, -2210, -2380, 33975, 23067.98, -1619.57],
['2016-04-06', '2016-05-04', '2016-05-12', '2017-05-08', '2017-07-03', '2018-05-07', '2019-05-06', '2019-10-01', '2020-03-13', '2020-05-07'],
],
'Issue 3297, Excel gives wrong answer' => [
-.379332733303311, // 2.98023223876953E-09,
[-19646.10172, -22288.58964, -1483.5, -12597.54406, -46629.45777, -2472.769, 0, -25616.37076, -30055.68344, 1038.5, -13621.9742, 13629.539, -36736.0694, -944.605609, -49020.77156, 27308.87082, -63912.64722, 8764.136, 3162, -23946.7257, -5428.8, -83899.24172, 58242.82346, -11147.78101, 287092.5749],
['2022-05-02', '2022-05-31', '2022-06-01', '2022-06-26', '2022-06-30', '2022-07-01', '2022-07-15', '2022-07-31', '2022-09-02', '2022-09-05', '2022-09-27', '2022-09-28', '2022-09-29', '2022-10-03', '2022-10-06', '2022-10-10', '2022-11-01', '2022-11-03', '2022-11-04', '2022-12-01', '2022-12-02', '2022-12-28', '2022-12-30', '2023-01-02', '2023-01-13'],
],
];
?>Did this file decode correctly?
Original Code
<?php
declare(strict_types=1);
// result, message, values, dates, guess
return [
'If values and dates contain a different number of values, returns the #NUM! error value' => [
'#NUM!',
[4000, -46000],
['2015-01-04'],
0.1,
],
'Cash flows are all negative' => [
'#NUM!',
[-4000, -46000],
['2015-01-04', '2019-06-27'],
0.1,
],
'Cash flows are all positive' => [
'#NUM!',
[4000, 46000],
['2015-01-04', '2019-06-27'],
0.1,
],
'If any number in dates is not a valid date, returns the #VALUE! error value' => [
'#VALUE!',
[4000, -46000],
['2015-01-04', '2019X06-27'],
0.1,
],
'If any entry in values is not numeric, returns the #VALUE! error value' => [
'#VALUE!',
['y', -46000],
['2015-01-04', '2019-06-27'],
0.1,
],
'If values is not an array, returns the #NUM! error value' => [
'#NUM!',
-46000,
['2015-01-04', '2019-06-27'],
0.1,
],
'If dates is not an array but values is, returns the #NUM! error value' => [
'#NUM!',
[4000, -46000],
'2015-01-04',
0.1,
],
'If neither dates nor values is an array, returns the #N/A error value' => [
'#N/A',
4000,
'2015-01-04',
0.1,
],
'Return VALUE error if guess is non-numeric' => [
'#VALUE!',
[1893.67, 139947.43, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-27', '2019-06-20', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
'XYZ',
],
'Dates can be in any order after all' => [
0.137963527441025,
[1893.67, 139947.43, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-27', '2019-06-20', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
0.1,
],
'XIRR calculation #0 is incorrect' => [
0.77868869226873,
[4000, -46000],
['2015-04-01', '2019-06-27'],
0.1,
],
'issue 689' => [
-0.6118824173,
[-1000000.706, 947003.58],
['2018-09-05', '2018-09-26'],
],
'issue 689 updated 2022-12-25' => [
-0.935842486,
[-20972.36, 20350.545],
['2022-12-12', '2022-12-16'],
],
'XIRR calculation #1 is incorrect' => [
0.137963527441025,
[139947.43, 1893.67, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-20', '2019-06-27', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
0.1,
],
'XIRR calculation #2 is incorrect' => [
0.09999999,
[100.0, -110.0],
['2019-06-12', '2020-06-11'],
0.1,
],
'XIRR calculation #3 is incorrect' => [
3235.159644,
[1.0, 1893.67, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-27', '2019-06-27', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
],
'XIRR calculation #4 is incorrect' => [
0.15467888,
[1893.67, 139947.43, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-20', '2019-06-27', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
],
'XIRR calculation #5 is incorrect' => [
-0.197387315,
[-100, 20, 40, 25],
['2010-01-01', '2010-04-01', '2010-10-01', '2011-02-01'],
],
'XIRR calculation #6 is incorrect' => [
3.434984565,
[-10000, 2750, 4250, 3250, 2750, 46000],
['2008-01-01', '2008-03-01', '2008-10-30', '2009-02-15', '2009-04-01', '2009-06-01'],
],
'Substitute for guess=0' => [
0.13796353,
[139947.43, 1893.67, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-20', '2019-06-27', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
0.00000,
],
'Substitute when guess is empty cell' => [
0.13796353,
[139947.43, 1893.67, 52573.25, 48849.74, 26369.16, -273029.18],
['2019-06-20', '2019-06-27', '2019-06-21', '2019-06-24', '2019-06-27', '2019-07-27'],
'C1',
],
'Can\'t find a result2 that works after FINANCIAL_MAX_ITERATIONS tries, the #NUM! error value is returned' => [
'#NUM!',
[-10000, 10000, -10000, 5],
['2010-01-15', '2010-04-16', '2010-07-16', '2010-10-15'],
],
'See issue #2469 - non-convergence with initial guess' => [
-0.642307613,
[55600, -51094.83],
['2021-11-24', '2021-12-24'],
],
'See issue #2469 - non-convergence with initial guess equal to correct answer' => [
-0.642307613,
[55600, -51094.83],
['2021-11-24', '2021-12-24'],
-0.642307613,
],
'Only one argument should cause exception' => [
'exception',
['2021-11-24', '2021-12-24'],
],
'No argument should cause exception' => [
'exception',
],
'DeCampo One year no growth' => [
0,
[-1000, 1000],
['2010-01-01', '2011-01-01'],
],
'DeCampo One year growth' => [
0.1,
[-1000, 1100],
['2010-01-01', '2011-01-01'],
],
'DeCampo One year decline' => [
-0.1,
[-1000, 900],
['2010-01-01', '2011-01-01'],
],
'DeCampo vs spreadsheet' => [
0.1212676,
[-1000, -1000, -1000, -1000, 4300],
['2010-01-01', '2010-04-01', '2010-07-01', '2010-10-01', '2011-01-01'],
],
'DeCampo vs spreadsheet reordered' => [
0.1212676,
[-1000, 4300, -1000, -1000, -1000],
['2010-10-01', '2011-01-01', '2010-07-01', '2010-01-01', '2010-04-01'],
],
'DeCampo Over 100% growth' => [
2.0,
[-1000, 3000],
['2010-01-01', '2011-01-01'],
],
'DeCampo Total loss one year, agree with Excel not DeCampo' => [
'#NUM!', // -1.0, DeCampo accounts for this case, Excel doesn't
[-1000, 0],
['2010-01-01', '2011-01-01'],
],
'DeCampo Total loss two years, agree with Excel not DeCampo' => [
'#NUM!', // -1.0, DeCampo accounts for this case, Excel doesn't
[-1000, 0],
['2010-01-01', '2012-01-01'],
],
'DeCampo Readme example' => [
0.2504234710540838,
[-1000, -2500, -1000, 5050],
['2016-01-15', '2016-02-08', '2016-04-17', '2016-08-24'],
],
'DeCampo from nodejs' => [
0.2126861,
[-10000, 3027.25, 630.68, 2018.2, 1513.62, 1765.89, 4036.33, 4036.33, 1513.62, 1513.62, 2018.16, 1513.62, 1009.08, 1513.62, 1513.62, 1765.89, 1765.89, 22421.55],
['2000-05-24', '2000-06-05', '2001-04-09', '2004-02-24', '2005-03-18', '2006-02-15', '2007-01-10', '2007-11-14', '2008-12-17', '2010-01-15', '2011-01-14', '2012-02-03', '2013-01-18', '2014-01-24', '2015-01-30', '2016-01-22', '2017-01-20', '2017-06-05'],
],
'DeCampo issue5a, agree with DeCampo not Excel' => [
-0.7640294, // '#NUM!'
[-2610, -2589, -5110, -2550, -5086, -2561, -5040, -2552, -2530, 29520],
['2001-06-22', '2001-07-03', '2001-07-05', '2001-07-06', '2001-07-09', '2001-07-10', '2001-07-12', '2001-07-13', '2001-07-16', '2001-07-17'],
],
'DeCampo issue5b, agree with DeCampo not Excel' => [
-0.8353404, // '#NUM!'
[-2610, -2589, -5110, -2550, -5086, -2561, -5040, -2552, -2530, -9840, 38900],
['2001-06-22', '2001-07-03', '2001-07-05', '2001-07-06', '2001-07-09', '2001-07-10', '2001-07-12', '2001-07-13', '2001-07-16', '2001-07-17', '2001-07-18'],
],
'Python XIRR test line 20' => [
412461.6383,
[-100, 1000],
['2019-12-31', '2020-03-05'],
],
'Python XIRR test line 21' => [
1.223853529e16,
[-2236.3994659663, -47.3417585212, -46.52619316339632, 10424.74612565936, -13.077972551952],
['2017-12-16', '2017-12-26', '2017-12-29', '2017-12-31', '2017-12-20'],
],
'Python XIRR test line 39, agree with Python not Excel' => [
-1, // '#NUM!',
[18902, 83600, -5780, -4080, -56780, -2210, -2380, 33975, 23067.98, -1619.57],
['2016-04-06', '2016-05-04', '2016-05-12', '2017-05-08', '2017-07-03', '2018-05-07', '2019-05-06', '2019-10-01', '2020-03-13', '2020-05-07'],
],
'Issue 3297, Excel gives wrong answer' => [
-.379332733303311, // 2.98023223876953E-09,
[-19646.10172, -22288.58964, -1483.5, -12597.54406, -46629.45777, -2472.769, 0, -25616.37076, -30055.68344, 1038.5, -13621.9742, 13629.539, -36736.0694, -944.605609, -49020.77156, 27308.87082, -63912.64722, 8764.136, 3162, -23946.7257, -5428.8, -83899.24172, 58242.82346, -11147.78101, 287092.5749],
['2022-05-02', '2022-05-31', '2022-06-01', '2022-06-26', '2022-06-30', '2022-07-01', '2022-07-15', '2022-07-31', '2022-09-02', '2022-09-05', '2022-09-27', '2022-09-28', '2022-09-29', '2022-10-03', '2022-10-06', '2022-10-10', '2022-11-01', '2022-11-03', '2022-11-04', '2022-12-01', '2022-12-02', '2022-12-28', '2022-12-30', '2023-01-02', '2023-01-13'],
],
];
Function Calls
| None |
Stats
| MD5 | 4ce24b02c141896c0b46795978f7a87a |
| Eval Count | 0 |
| Decode Time | 90 ms |