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 ... Formula and Calculation of MIRR .

Calculating MIRR in Google Sheets and Excel involves a few extra steps than IRR since you need to put in the finance rate (cost of borrowing) and the reinvestment rate.

When calculating the IRR or MIRR of monthly cash flows, the results must be multiplied by 12 to produce an annual yield; however, the XIRR function automatically produces an annual result that does ...

Cons of MIRR. A limitation of MIRR is that a trader will need to work from an estimate of the cost of capital in order to make a decision. MIRR is also a difficult concept for those without a ...

MIRR is also a difficult concept for those without a financial background to grasp, and there is dispute over the theoretical background for the MIRR calculation within academic circles. However, MIRR ...