How to Calculate Modified Internal Rate of Return (MIRR): Step-by-Step Guide

Hey there, future financial wizard! Ready to dive into a powerful tool for evaluating investments? We're going to learn all about the Modified Internal Rate of Return, or MIRR. Don't let the fancy name intimidate you – we'll break it down into easy-to-follow steps, showing you how to calculate it by hand. This will not only empower you to understand your investments better but also to truly grasp the underlying math.

What is MIRR and Why Do We Use It?

You might have heard of the Internal Rate of Return (IRR), a popular metric for project evaluation. While IRR is great, it has a couple of assumptions that aren't always realistic. Specifically, it assumes that any positive cash flows generated by a project are reinvested at the IRR itself. In the real world, you might reinvest those funds at a different rate, perhaps your company's cost of capital or a lower, more conservative rate.

This is where MIRR shines! MIRR adjusts for this by allowing you to specify two different rates:

1. Finance Rate (or Cost of Capital): This is the rate at which you borrow funds or the cost of your capital. It's used to discount negative cash flows.
2. Reinvestment Rate: This is the rate at which you expect to reinvest positive cash flows generated by the project. It's used to compound positive cash flows.

By using these separate rates, MIRR provides a more realistic and often more accurate picture of a project's profitability, making it a valuable alternative to traditional IRR.

Prerequisites

Before we jump into the calculation, it's helpful to have a basic understanding of:

• Cash Flows: The money coming into (inflows) and going out of (outflows) a project over time.
• Present Value (PV): The current value of a future sum of money or stream of cash flows, given a specified rate of return.
• Future Value (FV): The value of an asset or cash at a specified date in the future, equivalent in value to a specified sum today.
• Exponents: How to calculate numbers raised to a power (e.g., (1.08)^3).

Don't worry if these concepts are a bit rusty; we'll walk through them as we go!

The MIRR Formula

Here's the formula we'll be using. It might look a bit complex at first, but we'll tackle each part individually:

MIRR = [ (Terminal Value of Inflows) / (Present Value of Outflows) ] ^ (1/n) - 1

Where:

• Terminal Value of Inflows (TVI): The future value of all positive cash flows, compounded to the end of the project at your chosen reinvestment rate.
• Present Value of Outflows (PVO): The present value of all negative cash flows (including the initial investment), discounted back to time zero at your chosen finance rate.
• n: The total number of periods (e.g., years) the project lasts.

Let's get started with an example!

Worked Example

Imagine you're evaluating a 3-year project with the following cash flows:

• Initial Investment (Year 0): -$100,000 (an outflow)
• Year 1 Cash Flow: +$30,000 (an inflow)
• Year 2 Cash Flow: +$40,000 (an inflow)
• Year 3 Cash Flow: +$50,000 (an inflow)

Let's also assume:

• Finance Rate (Cost of Capital): 10% (0.10)
• Reinvestment Rate: 8% (0.08)
• Number of Periods (n): 3 years

Step 1: Gather Your Inputs

First things first, let's clearly list out all the numbers we'll be working with. This helps prevent confusion later on.

• Cash Flows (CF):
  • CF0 (Year 0): -$100,000
  • CF1 (Year 1): +$30,000
  • CF2 (Year 2): +$40,000
  • CF3 (Year 3): +$50,000
• Finance Rate (r_finance): 10% or 0.10
• Reinvestment Rate (r_reinvest): 8% or 0.08
• Number of Periods (n): 3

Step 2: Calculate the Present Value of Outflows (PVO)

Now, let's focus on all the negative cash flows (money going out). In our example, we only have one negative cash flow: the initial investment of -$100,000 at Year 0.

Since this cash flow is already at 'time zero' (the start of the project), its present value is simply itself. We use the finance rate to discount any future outflows, but here, it's not needed for CF0.

• PVO = $100,000

Note: If you had another negative cash flow in, say, Year 2 of -�KINL0�20,000 / (1 + 0.10)^2. Then you'd add this to your initial investment to get the total PVO.

Step 3: Calculate the Terminal Value of Inflows (TVI)

Next, we'll take all the positive cash flows (money coming in) and compound them forward to the very end of the project (Year 3 in our case) using the reinvestment rate.

• Year 1 inflow ($30,000): This cash flow occurs at the end of Year 1. To find its value at the end of Year 3, we compound it for 2 years (Year 3 - Year 1 = 2 years) at the reinvestment rate of 8%.

  • �KINL1�30,000 * (1.08)^2 = �KINL2�34,992

• Year 2 inflow ($40,000): This cash flow occurs at the end of Year 2. To find its value at the end of Year 3, we compound it for 1 year (Year 3 - Year 2 = 1 year) at the reinvestment rate of 8%.

  • �KINL3�40,000 * 1.08 = $43,200

• Year 3 inflow ($50,000): This cash flow already occurs at the end of Year 3, so it doesn't need to be compounded.

  • $50,000

Now, sum up these future values to get your Terminal Value of Inflows (TVI):

• TVI = �KINL4�43,200 + �KINL5�128,192

Step 4: Apply the MIRR Formula

We've got all the pieces! Now, let's plug our PVO, TVI, and 'n' into the MIRR formula:

MIRR = [ (Terminal Value of Inflows) / (Present Value of Outflows) ] ^ (1/n) - 1

• MIRR = [ (�KINL6�100,000) ] ^ (1/3) - 1
• MIRR = [ 1.28192 ] ^ (1/3) - 1

To calculate (1.28192)^(1/3), you'll need a calculator. This is the same as taking the cube root of 1.28192.

• 1.28192 ^ (1/3) ≈ 1.08630

• MIRR = 1.08630 - 1

• MIRR = 0.08630

To express this as a percentage, multiply by 100:

• MIRR = 8.63%

Step 5: Interpret Your Result

Congratulations! You've calculated the MIRR for your project. An MIRR of 8.63% means that, considering your specific finance and reinvestment rates, this project is expected to generate a return equivalent to an annual compound rate of 8.63% over its lifetime.

To make an investment decision, you would typically compare this MIRR to your required rate of return or hurdle rate. If MIRR > Hurdle Rate, the project is generally considered acceptable.

Common Pitfalls to Avoid

• Mixing Up the Rates: This is the most common mistake! Remember, the finance rate is for discounting outflows, and the reinvestment rate is for compounding inflows. Don't swap them!
• Incorrect Compounding/Discounting Periods: Make sure you're compounding/discounting for the correct number of years. For TVI, each inflow is compounded from its occurrence date to the project end date. For PVO, each outflow is discounted from its occurrence date to time zero.
• Sign Errors: Always keep track of positive (inflow) and negative (outflow) cash flows. The PVO only includes negative cash flows, and the TVI only includes positive ones.
• Mathematical Errors: Taking roots or powers can be tricky. Double-check your calculator entries, especially for (1/n).

When to Use a Calculator for Convenience

While knowing how to calculate MIRR by hand is invaluable for understanding, it can be quite tedious for projects with many cash flows or long durations. Financial calculators, spreadsheet software (like Excel or Google Sheets), and online MIRR calculators are fantastic tools for speed and accuracy.

They automate the compounding and discounting steps, reducing the chance of manual errors. For complex projects, these tools are highly recommended, but always remember the principles you've learned here so you can interpret the results confidently. Many online calculators will ask for your cash flows, finance rate, and reinvestment rate, then instantly provide the MIRR, saving you time for analysis rather than calculation.

Keep practicing, and you'll master MIRR in no time! Happy investing!