XIRR Calculation error

There might be features in Excel 2013 that make this easier.

But in my version, I think the easiest implementation requires a number of "helper" cells.

See the image below. See the "descend" worksheet in the attached Excel file for details.

xirr multicol descend.jpg

Formulas:
F22: =INDEX($L$22:$L$30, ROWS($L$22:$L$30)-ROWS($A$22:A22)+1)
H22: =INDEX(A$22:A$30, ROWS(A$22:A$30)-ROWS(A$22:A22)+1)
L23: =XIRR(IF(ROW($K$22:K23)=ROW(K23), -K23+I23+J23, $I$22:I23 + $J$22:J23), $H$22:H23)
Copy F22 into F23:F29
Insert column before column K, copy H22 into H22:L30, then delete column K and format I22:K30 as Number
Copy L23 into L24:L30

Again, the formula in L23 must be array-entered (press ctrl+shift+Enter instead of just Enter) in my version of Excel. Perhaps not in your version.