Formula for calculating modified internal rate of return
Formula. In general terms, the equation of MIRR can be written as follows: MIRR equation. where N is the number of years (periods) The Internal Rate of Return calculation has very real problems. Excel offers a practical solution. And so, a new modified metric known as the modified internal rate of return or in short MIRR is designed. Video. Recommended Article.