The XIRR function in Excel Kyvos calculates the Internal Rate of Return (IRR) for a series of cash flows occurring at irregular intervals (non-periodic).
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note For the net asset value in the Kyvos semantic model, the column must be a semi-additive measure with the last non-empty child. The use of semi-additive measures is supported only in index-based semantic models. |
Syntax of XIRR Function
| Code Block |
|---|
XIRR[Numeric_Expression1, Set_Expression, Numeric_Expression2, Guess] |
...