I've been running XIRR commands over various ranges of data and it works fine on some ranges and just flat out wrong in others. Below I've attached the spreadsheet with the data I'm using. If I do a rough math on the return (sum of what I put versus what it is worth at the end of the time frame) I should be negative a few percentage points.

Does anyone know what I can do to fix this or why it produces these results?

xirr.xlsx