XIRR is an Excel built-in function that is used to calculate Internal Rate of Return (IRR) of irregular cash flows. Learn and understand the logic of XIRR Calculation in Excel
MIRR is an an improved version of IRR in Excel. You can use MIRR function to factor in financing cost of cash outflows and reinvestment rate of cash inflows to compute a more realstic IRR of cash flows. Get an insight into MIRR Calculation in Excel