Using the Functions in Excel: MIRR The modified internal rate of return (MIRR) is used when the company expects to borrow and invest. You can also use it to help you calculate when there is a ...

Excel has three functions to calculate the IRR: IRR, the modified IRR (MIRR), and IRR for different payment periods (XIRR). Juststock / Getty Images IRR computes the rate of return that results in ...

You have added a table in Excel with date, cash flow, and description columns. You can now use the =XIRR(B2:B7, A2:A7) function to calculate an annualized internal rate of return for this real ...

Hence, the Extended Internal Rate of Return (XIRR ... calculated using Microsoft Excel or Google Sheets. Excel has a built-in ...