MIRR formula The MIRR formula is substantially different from the IRR formula - you will notice that, while the future value of positive cash flows is still taken into consideration, the MIRR metric is not that similar to the NPV equation (net present value calculator). MIRR=(FV(Ci+,RR)PV...
The formula for MIRR can be expressed as the following: The internal rate of return is a discount rate. It is used to make the net present value (NPV). This is for all cash flows from a project equal to zero. Both the calculations of MIRR and IRR rely on the formula for NPV, wh...
Values –the OFFSET formula described above Finance_rate –cell D1 Reinvest_rate –cell D2 So, our MIRR formula takes this shape: =MIRR(Values, Finance_rate, Reinvest_rate) And now, you can type any number of values in column A, beginning in cell A2, and your MIRR calculator with ...
The Formula MIRR = (FV of the cash inflows discounted at the WACC / PV of cash outflows discounted at the firm's financing cost for the project)(1/n)-1 Video of the Day Step 1 Calculate the future value of the cash inflows by discounting them at the firm's WACC. For example, con...