The modified internal rate of return assumes that positive cash flows are reinvested at the cost of capital and initial outlays are financed at the firm's financing cost.

Excel and Google Sheets have three functions to calculate the internal rate of return: IRR, XIRR, and MIRR. Learn how these functions can calculate investment returns.

In the example at left, the MIRR formula would be =MIRR (D2:D14,D16,D17)*12, which yields an internal rate of return of 17.68%. Note: Some CPAs maintain that the MIRR function’s results are less valid ...

IRR is not equal to annual rate of return. Assumptions of IRR are not always reasonable and rational. IRR itself may produce misleading results. What should investors use instead of IRR? Internal ...

The MIRR formula is complex and few traders calculate it without the use of computer software. To calculate MIRR manually, you will need to know the future value of a company’s positive cash flows ...