Modified Internal Rate of Return (MIRR), a More Meaningful Metric than IRR

Following my last post on the flaws of IRR—resulting from the unrealistic assumption that cash inflows get reinvested in projects with identical IRRs, I decided to investigate a formula with which I had not been very familiar, the modified internal rate of return (MIRR). The MIRR overcomes the reinvestment assumption of IRR and serves as a much better metric for ranking projects.

While more complex as a formula, MIRR is not difficult to work with once the concepts are understood. Besides, Excel can do the hard work of crunching the numbers: see http://office.microsoft.com/en-us/excel-help/mirr-HP005209180.aspx and http://www.techonthenet.com/excel/formulas/mirr.php.

The MIRR formula starts by calculating the future value (value in the final period) of all cash inflows generated by the project using the organization’s reinvestment rate, a weighted average of return rates on projects. (This reinvestment rate could be calculated based on historical rates or the rates of recently approved projects.)

The future value of cash inflows is divided by the present value (value at project start) of all project cash outflows discounted by the finance rate, a rate that represents the cost of capital for the organization.

The n in the formula represents the number of periods.

MIRR Formula

The cons of MIRR are that it requires two inputs not required by IRR: the reinvestment rate and the finance rate. But the result is far more meaningful. It allows comparisons among projects with widely different patterns of cash flows.

This is not to say that organizations should use MIRR as a sole metric for project selection. It still might make more sense to pursue a smaller number of projects with larger Net Present Values (NPV) that many smaller projects with larger MIRRs.

For some reason, IRR is used far more often in project selection than MIRR. Does your organization use IRR or MIRR and why?

Other posts in series: MIRR, IRR, Break-Even Analysis, NPV, ROI

Advertisements

I’m a solution engineer for Shape Security, an awesome web security startup in Mountain View that defends some of the worlds largest web sites from bot attacks. I see this blog as a learning tool. It gives me a chance to collect my thoughts on topics of interest and to share with others. If you see a mistake or think I’m on the wrong track, please let me know. I appreciate comments. See my LinkedIn profile at http://www.linkedin.com/in/jamesdowney and follow me on Twitter at http://twitter.com/james_downey.

Posted in IRR, Project Selection

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: