MIRR Calculator - Modified Internal Rate of Return Created by Bogna Szyk and Wei Bin Loo Reviewed by Steven Wooding Based on 1 source54 people find this calculator helpful 54 Add to BoardNew Table of contentsWhat is the modified internal rate of return?MIRR formulaHow to calculate MIRR: an ...
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...