MIRR Formula:
From: | To: |
The MIRR (Modified Internal Rate of Return) with WACC (Weighted Average Cost of Capital) formula provides a more accurate measure of an investment's profitability by assuming reinvestment at the firm's cost of capital rather than the IRR's internal rate.
The calculator uses the MIRR formula:
Where:
Explanation: This formula adjusts for the cost of capital and provides a more realistic measure of investment returns compared to traditional IRR.
Details: MIRR provides a better indication of an investment's true profitability by using more realistic reinvestment assumptions and avoiding the multiple IRR problem that can occur with unconventional cash flows.
Tips: Enter future value and present value in dollars, number of periods in years, and WACC as a percentage. All values must be positive numbers.
Q1: Why use MIRR instead of IRR?
A: MIRR provides a more realistic measure by assuming reinvestment at the firm's cost of capital rather than the project's IRR, and avoids the multiple IRR problem.
Q2: What is a good MIRR value?
A: A MIRR higher than the company's required rate of return or WACC indicates a potentially good investment. The higher the MIRR, the better the investment.
Q3: How is WACC different from discount rate?
A: WACC represents the average rate a company expects to pay to finance its assets, while discount rate is the rate used to discount future cash flows to their present value.
Q4: Can MIRR be negative?
A: Yes, MIRR can be negative if the present value of costs exceeds the future value of benefits, indicating a loss-making investment.
Q5: What are the limitations of MIRR?
A: MIRR still relies on estimated future cash flows and assumes a constant reinvestment rate, which may not reflect real-world conditions.