Calculate MIRR Using WACC: A Step-by-Step Guide
The modified internal rate of return (MIRR) calculates the return earned on an investment while taking into consideration that you may not be able to re-invest the money you earn at the same rate the investment provides. The weighted average cost of capital (WACC) is the weighted average of a firm's cost of debt and equity financing. Therefore, a firm's WACC is the minimum return it must earn on investments and represents the firm's minimum re-investment rate in the MIRR calculation.
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
Step 1
Calculate the future value of the cash inflows by discounting them at the firm's WACC. For example, consider a project that will earn $50,000 in the first year, $100,000 in the second year, and $200,000 in the third year. If the firm's WACC is 10 percent, the value of these cash flows at the end of the third year would be calculated as follows:
FV = (50,000 x 1.132) + (100,000 x 1.13) + 200,000
FV = 376,845
Step 2
Calculate the present value of the cash outflows discounted at the firms's cost of financing for the project. Consider that the project in the previous example would require cash outflows of $75,000 at the beginning of the project and another $75,000 in year 1. If the cost of financing the project is 11 percent, the present value of the cash outflows would be calculated as follows:
PV = 75,000 + 75,000/1.11
PV = 142,568
Step 3
Solve for the MIRR using the FV from step 1 and the PV from step 2. Since the project in this example provided cash flows for three years, n is equal to three in the MIRR equation.
MIRR = (FV/PV)^(1/n) - 1
MIRR = (376,845/142,568) ^ (1/3) -1
MIRR = .3827
In this example the firm would accept this project because the MIRR exceeds the WACC.
investing
- Weighted Average Life of Bonds: Calculation & Significance
- Calculating Profit Percentage Change: A Guide for Investors & Accountants
- Calculating Combined Firm Beta: A Comprehensive Guide
- Understanding Paid-Up Capital: Definition & Calculation
- Calculate Average Cost Basis: A Simple Guide
- Portfolio Beta Calculation: A Comprehensive Guide
- EBIT Calculation: A Simple Guide for Investors
- Powerball Odds: A Comprehensive Guide to Calculating Your Chances
- Calculate Investment Portfolio Returns with Excel: A Step-by-Step Guide
-
Condominium Depreciation: A Guide for Real Estate InvestorsInvestors may choose homes, land, apartments, commercial buildings and more as real estate investments. Investors must depreciate rental properties, according to Internal Revenue Service. Depreciation...
-
Understanding & Calculating Forex Spreads: A Beginner's GuideThe Forex spread is something that you will need to be familiar with if you plan on getting involved in the Forex market. Here are the basic steps involved in how to calculate the Forex spread. ...
