Spreadsheet: 799402d1665067841-xirr-weird-results-xirr-calculation-error-
Sheet: Sheet1

 | Date | Cashflow | Balance | Microsoft Excel | Google Docs | LibreOffice |  | LIVE |  |  | #yrs | PV of CF | NPV |  | actual XIRR |  | NPV curve
 | 2012-12-31 00:00:00 | -8041.43 |  | Err:502 |  | Err:502 |  |  |  |  |  |  |  |  |  |  | %discnt | (X)NPV
 | 2013-02-28 00:00:00 | -7899.18 |  | Err:502 |  | Err:502 |  |  |  |  |  |  |  |  |  |  | -0.9999
 | 2013-06-30 00:00:00 | -64911.42 |  | Err:502 |  | Err:502 |  |  |  |  |  |  |  |  |  |  | -0.99
 | 2013-08-31 00:00:00 | -84409.38 |  | Err:502 |  | Err:502 |  |  |  |  |  |  |  |  |  |  | -0.9
 | 2013-09-30 00:00:00 | -403750 |  | Err:502 |  | Err:502 |  |  |  |  |  |  |  |  |  |  | -0.85
 | 2014-01-07 00:00:00 | 60715.36 |  | 4.9e-09 |  | Err:502 |  |  |  |  |  |  |  |  |  |  | -0.8
 | 2014-01-20 00:00:00 | -7500 |  | 4.9e-09 |  | Err:502 |  |  |  |  |  |  |  |  |  |  | -0.75
 | 2014-02-10 00:00:00 | 7650752.21 |  | 148.22609375 | 148.226094536155 | 148.226094536155 |  |  |  |  |  |  |  |  |  |  | -0.7
 | 2014-10-17 00:00:00 | -6000 |  | 148.22058875 | 148.220589165573 | 148.220589165573 |  |  |  |  |  |  |  |  |  |  | -0.65
 | 2014-11-20 00:00:00 | -7.45 |  | 148.22058375 | 148.220584877052 | 148.220584877052 |  |  |  |  |  |  |  |  |  |  | -0.6
 | 2014-11-21 00:00:00 | -4560.03 |  | 148.21799625 | 148.217995659497 | 148.217995659497 |  |  |  |  |  |  |  |  |  |  | -0.55
 | 2015-02-23 00:00:00 | -129600 |  | 148.19771625 | 148.197717247708 | 148.197717247708 |  |  |  |  |  |  |  |  |  |  | -0.5
 | 2015-02-24 00:00:00 | -4592.41 |  | 148.19700875 | 148.197008368376 | 148.197008368376 |  |  |  |  |  |  |  |  |  |  | -0.45
 | 2015-03-26 00:00:00 | -20811.34 |  | 148.19487875 | 148.194879372124 | 148.194879372124 |  |  |  |  |  |  |  |  |  |  | -0.4
 | 2015-04-01 00:00:00 | -275000 |  | 148.16896375 | 148.168963811626 | 148.168963811626 |  |  |  |  |  |  |  |  |  |  | -0.35
 | 2015-05-05 00:00:00 | -258882.09 |  | 148.15365375 | 148.153653605626 | 148.153653605626 |  |  |  |  |  |  |  |  |  |  | -0.2999999999999999
 | 2015-05-11 00:00:00 | -25611.85 |  | 148.15225875 | 148.152258378473 | 148.152258378473 |  |  |  |  |  |  |  |  |  |  | -0.25
 | 2015-05-22 00:00:00 | -52425.36 |  | 148.14980125 | 148.149802244717 | 148.149802244717 |  |  |  |  |  |  |  |  |  |  | -0.2
 | 2015-06-01 00:00:00 | -17597.9 |  | 148.14908375 | 148.149083406375 | 148.149083406375 |  |  |  |  |  |  |  |  |  |  | -0.15
 | 2015-06-02 00:00:00 | -34401.21 |  | 148.14769625 | 148.147697300247 | 148.147697300247 |  |  |  |  |  |  |  |  |  |  | -0.09999999999999998
 | 2015-06-22 00:00:00 | -3254.56 |  | 148.14759875 | 148.147597617939 | 148.147597617939 |  |  |  |  |  |  |  |  |  |  | -0.04999999999999993
 | 2015-07-23 00:00:00 | -39803.63 |  | 148.14680125 | 148.146800645106 | 148.146800645106 |  |  |  |  |  |  |  |  |  |  | 0
 | 2015-08-20 00:00:00 | -2866.38 |  | 148.14676125 | 148.14676155067 | 148.14676155067 |  |  |  |  |  |  |  |  |  |  | 0.05000000000000004
 | 2015-09-24 00:00:00 | -37783.02 |  | 148.14644375 | 148.146442653462 | 148.146442653462 |  |  |  |  |  |  |  |  |  |  | 0.09999999999999998
 | 2015-10-22 00:00:00 | -13295.03 |  | 148.14636625 | 148.146366216706 | 148.146366216706 |  |  |  |  |  |  |  |  |  |  | 0.15
 | 2015-11-25 00:00:00 | -95.96 |  | 148.14636625 | 148.146365870583 | 148.146365870583 |  |  |  |  |  |  |  |  |  |  | 0.2000000000000001
 | 2015-11-26 00:00:00 | -22569.69 |  | 148.14628625 | 148.146285571484 | 148.146285571484 |  |  |  |  |  |  |  |  |  |  | 0.2500000000000001
 | 2015-12-14 00:00:00 | -196004.66 |  | 148.14574125 | 148.145740739219 | 148.145740739219 |  |  |  |  |  |  |  |  |  |  | 0.3000000000000002
 | 2016-01-26 00:00:00 | -40852.69 |  | 148.14567875 | 148.145677766711 | 148.145677766711 |  |  |  |  |  |  |  |  |  |  | 0.35
 | 2016-02-01 00:00:00 | -16511.44 |  | 148.14565375 | 148.145654325223 | 148.145654325223 |  |  |  |  |  |  |  |  |  |  | 0.4
 | 2016-02-02 00:00:00 | -17817.06 |  | 148.14562875 | 148.145629374598 | 148.145629374598 |  |  |  |  |  |  |  |  |  |  | 0.4500000000000001
 | 2016-02-26 00:00:00 | -14949.7 |  | 148.14561375 | 148.145614310062 | 148.145614310062 |  |  |  |  |  |  |  |  |  |  | 0.5000000000000001
 | 2016-03-23 00:00:00 | -25118.86 |  | 148.14559625 | 148.145596588954 | 148.145596588954 |  |  |  |  |  |  |  |  |  |  | 0.5500000000000002
 | 2016-04-29 00:00:00 | -34981.04 |  | 148.14558125 | 148.145581730102 | 148.145581730102 |  |  |  |  |  |  |  |  |  |  | 0.6
 | 2016-05-24 00:00:00 | -24293.7 |  | 148.14557375 | 148.145574405755 | 148.145574405755 |  |  |  |  |  |  |  |  |  |  | 0.65
 | 2016-06-22 00:00:00 | -26642.76 |  | 148.14556875 | 148.145569008701 | 148.145569008701 |  |  |  |  |  |  |  |  |  |  | 0.7000000000000001
 | 2016-06-29 00:00:00 | 1999470.97 |  | 148.14593625 | 148.14593697202 | 148.14593697202 |  |  |  |  |  |  |  |  |  |  | 0.7500000000000001
 | 2016-07-27 00:00:00 | -26125.15 |  | 148.14593375 | 148.145933697083 | 148.145933697083 |  |  |  |  |  |  |  |  |  |  | 0.8000000000000002
 | 2016-08-24 00:00:00 | -189265.3 |  | 148.14591875 | 148.145917535923 | 148.145917535923 |  |  |  |  |  |  |  |  |  |  | 0.85
 | 2016-10-25 00:00:00 | -107290.31 |  | 148.14591375 | 148.145913620795 | 148.145913620795 |  |  |  |  |  |  |  |  |  |  | 0.9
 | 2016-11-23 00:00:00 | -42427.41 |  | 148.14591375 | 148.145912580553 | 148.145912580553 |  |  |  |  |  |  |  |  |  |  | 0.9500000000000001
 | 2016-12-22 00:00:00 | -44039.51 |  | 148.14591125 | 148.145911855062 | 148.145911855062 |  |  |  |  |  |  |  |  |  |  | 1
 | 2017-02-24 00:00:00 | -5667.28 |  | 148.14591125 | 148.145911816243 | 148.145911816243 |  |  |  |  |  |  |  |  |  |  | 1.05
 | 2017-03-23 00:00:00 | -98089.08 |  | 148.14591125 | 148.145911352267 | 148.145911352267 |  |  |  |  |  |  |  |  |  |  | 1.1
 | 2017-05-30 00:00:00 | -216267.99 |  | 148.14591125 | 148.145910949623 | 148.145910949623 |  |  |  |  |  |  |  |  |  |  | 1.15
 | 2017-06-23 00:00:00 | -8665.71 |  | 148.14591125 | 148.145910938013 | 148.145910938013 |  |  |  |  |  |  |  |  |  |  | 1.2
 | 2017-07-12 00:00:00 | -10816.45 |  | 148.14591125 | 148.145910926846 | 148.145910926846 |  |  |  |  |  |  |  |  |  |  | 1.25
 | 2017-10-23 00:00:00 | -38717.48 |  | 148.14591125 | 148.14591091711 | 148.14591091711 |  |  |  |  |  |  |  |  |  |  | 1.3
 | 2017-11-21 00:00:00 | -112158.83 |  | 148.14591125 | 148.145910898159 | 148.145910898159 |  |  |  |  |  |  |  |  |  |  | 1.35
 | 2017-12-25 00:00:00 | -30871.82 |  | 148.14591125 | 148.145910894887 | 148.145910894887 |  |  |  |  |  |  |  |  |  |  | 1.4
 | 2018-01-26 00:00:00 | -96843.72 |  | 148.14591125 | 148.145910888267 | 148.145910888267 |  |  |  |  |  |  |  |  |  |  | 1.45
 | 2018-02-05 00:00:00 | -909099.17 |  | 148.14591125 | 148.145910834091 | 148.145910834091 |  |  |  |  |  |  |  |  |  |  | 1.5
 | 2018-02-20 00:00:00 | -24241.86 |  | 148.14591125 | 148.145910832915 | 148.145910832915 |  |  |  |  |  |  |  |  |  |  | 1.55
 | 2018-03-27 00:00:00 | -56440.25 |  | 148.14591125 | 148.14591083122 | 148.14591083122 |  |  |  |  |  |  |  |  |  |  | 1.6
 | 2018-04-30 00:00:00 | -57122.63 |  | 148.14591125 | 148.145910830144 | 148.145910830144 |  |  |  |  |  |  |  |  |  |  | 1.65
 | 2018-05-31 00:00:00 | -30883.34 |  | 148.14591125 | 148.145910829764 | 148.145910829764 |  |  |  |  |  |  |  |  |  |  | 1.7
 | 2018-06-30 00:00:00 | -66200.79 |  | 148.14591125 | 148.145910829224 | 148.145910829224 |  |  |  |  |  |  |  |  |  |  | 1.75
 | 2018-07-25 00:00:00 | -96777.16 |  | 148.14591125 | 148.145910828663 | 148.145910828663 |  |  |  |  |  |  |  |  |  |  | 1.8
 | 2018-08-24 00:00:00 | -47153.74 |  | 148.14591125 | 148.145910828482 | 148.145910828482 |  |  |  |  |  |  |  |  |  |  | 1.85
 | 2018-09-25 00:00:00 | -678164.49 |  | 148.14591125 | 148.145910826804 | -0.244670958555486 |  |  |  |  |  |  |  |  |  |  | 1.9
 | 2018-09-30 00:00:00 | -183600 |  | 148.14591125 | -0.228278795083909 | -0.228278795083909 |  |  |  |  |  |  |  |  |  |  | 1.95
 | 2019-08-31 00:00:00 | -71150.48 |  | 148.14591125 | -0.220754991383868 | -0.220754991383868 |  |  |  |  |  |  |  |  |  |  | 2
 | 2020-02-29 00:00:00 | -99873.16 |  | 148.14591125 | -0.209650553164951 | -0.209650553164941
 | 2020-05-31 00:00:00 | -87156.86 |  | 148.14591125 | -0.200227927359933 | -0.200227927359933
 | 2020-06-30 00:00:00 | -189001.26 |  | 148.14591125 | -0.18179419705141 | -0.181794197049026
 | 2020-07-31 00:00:00 | -436297.04 |  | 148.14591125 | -0.147194598656216 | -0.147194598656216
 | 2020-08-31 00:00:00 | -1090386.11 |  | 148.14591125 | -0.0869485668080825 | -0.086948566808083
 | 2020-09-30 00:00:00 | -168699.79 |  | 148.14591125 | -0.079554111655501 | -0.079554111655501
 | 2021-06-30 00:00:00 | -39395.75 |  | 148.14591125 | -0.0777783713398541 | -0.077778371339854
 | 2021-08-31 00:00:00 | -9033.01 |  | 148.14591125 | -0.0773695087200316 | -0.077369508720032
 | 2021-11-30 00:00:00 | -29804.12 |  | 148.14591125 | -0.0760046312017747 | -0.076004631201774
 | 2021-12-15 00:00:00 | 600000 |  | 148.14591125 | -0.107985762218015 | -0.107985762217105
 | 2021-12-31 00:00:00 | -648259.52 |  | 148.14591125 | -0.0737274423254442 | -0.073727442325444
 | 2022-01-21 00:00:00 | 600000 |  | 148.14591125 | -0.105209282003118 | -0.105209282003088
 | 2022-01-31 00:00:00 | -159403.47 |  | 148.14591125 | -0.0957710606592077 | -0.095771060659202
 | 2022-02-28 00:00:00 | -2066.46 |  | 148.14591125 | -0.0956538378050128 | -0.095653837805006 |  |  |  | (X)NPV |  |  |  |  |  |  | (X)NPV
 |  |  |  |  |  |  | guess
 |  |  |  |  |  |  |  |  |  | (X)NPV
 |  |  |  |  |  |  |  |  |  | (X)NPV
 |  |  |  |  |  |  | -0.1 |  |  | (X)NPV