XNPV Result is not 0 when I use the XIRR result as the rate

[neukarmel]

I have a stream of cash flows for a financial model that I am building (pasted below). I am trying to calculate the IRR of the Gross and Net lines. For the Gross line, I entered the following formula =XIRR(G19:AD19,G17:AD17,0.5) and I get the result of 47.16%. I then try to verify that XIRR result by doing entering the following formula =XNPV(AK19,G19:AD19,G17:AD17. AK19 is the cell where the XIRR result was calculated. The result of that XNPV formula is -0.09795349. I was expecting the result of the XNPV to be much closer to 0 than that. Does this mean that my IRR calculation is not correct. Can someone please verify this for me? I would be grateful. Thank you in advance for your help.


[TABLE="width: 2516"]
<colgroup><col><col><col span="3"><col><col><col span="2"><col><col><col span="3"><col><col><col span="3"><col><col><col span="3"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: right"]Mar-18[/TD]
[TD="align: right"]Jun-18[/TD]
[TD="align: right"]Sep-18[/TD]
[TD="align: right"]Dec-18[/TD]
[TD="align: right"]Mar-19[/TD]
[TD="align: right"]Jun-19[/TD]
[TD="align: right"]Sep-19[/TD]
[TD="align: right"]Dec-19[/TD]
[TD="align: right"]Mar-20[/TD]
[TD="align: right"]Jun-20[/TD]
[TD="align: right"]Sep-20[/TD]
[TD="align: right"]Dec-20[/TD]
[TD="align: right"]Mar-21[/TD]
[TD="align: right"]Jun-21[/TD]
[TD="align: right"]Sep-21[/TD]
[TD="align: right"]Dec-21[/TD]
[TD="align: right"]Mar-22[/TD]
[TD="align: right"]Jun-22[/TD]
[TD="align: right"]Sep-22[/TD]
[TD="align: right"]Dec-22[/TD]
[TD="align: right"]Mar-23[/TD]
[TD="align: right"]Jun-23[/TD]
[TD="align: right"]Sep-23[/TD]
[TD="align: right"]Dec-23[/TD]
[/TR]
[TR]
[TD]Capital Calls[/TD]
[TD][/TD]
[TD] (2,000,000)[/TD]
[TD] (2,000,000)[/TD]
[TD] (2,000,000)[/TD]
[TD] (2,000,000)[/TD]
[TD] (2,000,000)[/TD]
[TD] (2,000,000)[/TD]
[TD] (2,000,000)[/TD]
[TD] (2,000,000)[/TD]
[TD] (2,000,000)[/TD]
[TD] (2,000,000)[/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]Gross[/TD]
[TD="align: right"] (0)[/TD]
[TD="align: right"] (2,000,000)[/TD]
[TD="align: right"] (1,599,770)[/TD]
[TD="align: right"] (2,000,000)[/TD]
[TD="align: right"] (2,000,000)[/TD]
[TD="align: right"] (2,000,000)[/TD]
[TD="align: right"] (2,000,000)[/TD]
[TD="align: right"] 707,500[/TD]
[TD="align: right"] (2,000,000)[/TD]
[TD="align: right"] (2,000,000)[/TD]
[TD="align: right"] (2,000,000)[/TD]
[TD="align: right"] 11,412,955[/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 16,077,841[/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 14,135,376[/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 5,102,124[/TD]
[/TR]
[TR]
[TD]Net[/TD]
[TD="align: right"] (0)[/TD]
[TD="align: right"] (2,110,000)[/TD]
[TD="align: right"] (1,709,770)[/TD]
[TD="align: right"] (2,110,000)[/TD]
[TD="align: right"] (2,110,000)[/TD]
[TD="align: right"] (2,110,000)[/TD]
[TD="align: right"] (2,110,000)[/TD]
[TD="align: right"] 597,500[/TD]
[TD="align: right"] (2,110,000)[/TD]
[TD="align: right"] (2,060,000)[/TD]
[TD="align: right"] (2,060,000)[/TD]
[TD="align: right"] 11,352,955[/TD]
[TD="align: right"] (60,000)[/TD]
[TD="align: right"] (60,000)[/TD]
[TD="align: right"] (60,000)[/TD]
[TD="align: right"] 14,840,227[/TD]
[TD="align: right"] (60,000)[/TD]
[TD="align: right"] (60,000)[/TD]
[TD="align: right"] (60,000)[/TD]
[TD="align: right"] 13,248,252[/TD]
[TD="align: right"] (60,000)[/TD]
[TD="align: right"] (60,000)[/TD]
[TD="align: right"] (60,000)[/TD]
[TD="align: right"] 3,731,748[/TD]
[/TR]
</tbody>[/TABLE]