MIRR Calculator

Refining Investment Accuracy with Reinvestment Logic

The cost of the project at Year 0.
The total value of all inflows compounded to the end of the project.
Cost of capital to fund the project.
\[ \text{MIRR} = \left( \frac{\text{Terminal Value}}{\text{Initial Outlay}} \right)^{\frac{1}{n}} - 1 \]
Modified Internal Rate of Return
0.00%

Introduction to MIRR: Correcting the Flaws of Standard IRR

In the field of corporate finance and capital budgeting, the Internal Rate of Return (IRR) has long been a favorite metric. It provides a simple percentage that represents the efficiency of an investment. However, seasoned financial analysts know that standard IRR has a significant structural flaw: it assumes that all positive cash flows generated during a project’s lifecycle are reinvested at the same high IRR rate. In reality, most businesses can only reinvest cash at their weighted average cost of capital (WACC). This discrepancy often leads to "IRR inflation," making projects look more attractive than they truly are. The Modified Internal Rate of Return (MIRR) was developed as the professional antidote to this problem. The Krazy MIRR Calculator helps you find the true economic yield by integrating both financing costs and realistic reinvestment assumptions.

How MIRR Works: The Three-Step Process

MIRR approaches a project’s lifecycle in three distinct phases, making it far more robust than its predecessor:

  1. Financing Component: Future negative cash flows are discounted back to the present (Year 0) using a "Financing Rate" (the cost of borrowing).
  2. Reinvestment Component: Positive cash flows are compounded forward to the end of the project using a "Reinvestment Rate" (usually the business's WACC or the rate on a standard savings/money market account).
  3. Geometric Mean: The MIRR is finally calculated as the geometric growth rate that connects the present value of costs to the future (terminal) value of benefits.
\[ \text{MIRR} = \sqrt[n]{\frac{FV(\text{Positive Cash Flows, Reinvestment Rate})}{PV(\text{Negative Cash Flows, Financing Rate})}} - 1 \]

Why MIRR is Superior for Capital Budgeting

The primary advantage of MIRR is realism. If a project has an IRR of 50%, standard IRR assumes you can find another 50% return project for every dollar you earn tomorrow. This is rarely possible. MIRR allows you to assume a more modest 10% reinvestment rate, which typically results in a lower but more "honest" percentage. Furthermore, MIRR solves the "multiple IRR problem"—a mathematical anomaly where projects with alternating positive and negative cash flows can produce multiple valid IRR results. MIRR always yields a single, definitive number.

Key Variables: Financing vs. Reinvestment Rates

To get the most out of our calculator, you must understand the two interest rates involved:

  • Financing Rate: This represents the cost of the capital used to start the project. If you are taking out a 6% business loan to buy equipment, your financing rate is 6%.
  • Reinvestment Rate: This is the yield you expect to get on the profits the project generates. Most conservative analysts use the company's cost of capital (WACC) or the yield of a risk-free asset like a Treasury bond.

Practical Applications: Real Estate and Private Equity

MIRR is widely used in high-stakes investment environments:

  • Real Estate Development: Developers use MIRR to account for the gap between receiving rental income and the eventual sale of the property, knowing they can't always reinvest monthly rent into new buildings immediately.
  • Private Equity: Fund managers use MIRR to show limited partners a more realistic return expectation, especially when a fund is "dry" and not making new acquisitions.
  • Small Business Equipment: If a bakery buys a new oven, the extra $1,000 in monthly profit might just sit in a 4% savings account. MIRR correctly identifies that the "project" is the furnace PLUS the savings account growth.

How to Use the Krazy MIRR Solver

We've streamlined the complex math into a four-field utility:

  1. Initial Outlay: Enter the negative cash flow required to start (e.g., the purchase price).
  2. Terminal Value: Enter the total sum of all future inflows, after they've been compounded to the end of the project. (If you have equal annual payments, use a Future Value of Annuity formula first).
  3. Duration: How many years will the project last?
  4. Rates: Input your cost of capital. Our tool defaults to 10%, a common hurdle rate for many businesses.

Comparison: NPV, IRR, and MIRR

While Net Present Value (NPV) remains the "gold standard" for determining if a project adds value (if NPV > 0, do the project), MIRR provides the best "comparative" percentage. If you have two projects and one has a higher MIRR, it is almost always the more efficient use of capital, assuming equivalent risk profiles. By using the Krazy suite, you can verify your NPV results against a realistic MIRR percentage to ensure your investment committee has all the facts.

Avoiding the "Profit Illusion"

Many entrepreneurs fall into the trap of looking only at raw profit dollars. A project that turns $10,000 into $15,000 over one year is vastly different from one that takes 10 years to achieve the same result. MIRR forces you to consider the Time Value of Money. By seeing your return as a modified annual percentage, you can compare a local business opportunity to the broader stock market, ensuring your time and capital are being deployed in their "highest and best use."

Why Choose Krazy Calculator?

Krazy, under the technical leadership of Michael Samuel, is dedicated to financial transparency. We believe that professional financial modeling should be accessible to every aspiring business owner, not just those with institutional Bloomberg terminals. Our tools are mobile-responsive, ad-free, and use the latest standardized finance algorithms to ensure accuracy. When your capital is on the line, don't guess—calculate with Krazy.

Refine your returns. Eliminate the illusion. Master your capital with Krazy.