The XIRR function is an inbuilt function in Excel and falls under the category of Financial Function. The function was. Using a changing rate starting with guess XIRR cycles through the calculation until the result is accurate within 0000001 percent.
Using a changing rate starting with guess XIRR cycles through the calculation until the result is accurate within 0000001 percent.
The XIRR function calculates in the internal rate of return for series of cash flows that occur at irregular intervals. If you use the XIRR formula in Excel then you have complete flexibility over the time periods of the cash flows. XIRR function calculates the Internal Rate of Return for a supplied series of cash flows. You can enter this as part of a formula in a cell of a worksheet.