Ms Excel Xirr Function. Because you provide the dates for each cash flow, the values do not have to occur at regular intervals. The Excel Xirr Function - Calculates the Internal Rate of Return for a Series of Cash Flows - Function Description with Examples & Common Errors.
Excel XIRR function returns the internal rate of return (IRR) from the cash flow data at irregular interval. Some points to keep in mind. The good thing about XIRR Function is, it considers only irregular series of cash flow or installments intervals, whereas most of the function in excel gives fine.
A review of the XIRR function in EXCEL and some unusual results that the function may produce.
The Excel XIRR function is a financial function that returns the internal rate of return (IRR) for a series of cash flows that occur at irregular intervals.
We use the XIRR function below to solve this calculation. The Excel XIRR function returns the internal rate of return for a series of cash flows that may or may not be periodic. The good thing about XIRR Function is, it considers only irregular series of cash flow or installments intervals, whereas most of the function in excel gives fine.