MIRR Formula:
From: | To: |
Definition: This calculator computes the Modified Internal Rate of Return (MIRR) using the combination approach, which considers both the cost of investment and the interest received on reinvestment of cash.
Purpose: It provides a more accurate measure of an investment's attractiveness than IRR by assuming reinvestment at the firm's cost of capital.
The calculator uses the formula:
Where:
Explanation: The formula calculates the interest rate that equates the present value of cash outflows with the future value of cash inflows.
Details: MIRR provides a better indication of a project's profitability and efficiency than IRR by eliminating the multiple IRR problem and providing a more realistic reinvestment rate assumption.
Tips: Enter the future value of positive cash flows, present value of negative cash flows, and number of periods. All values must be > 0.
Q1: How is MIRR different from IRR?
A: MIRR assumes reinvestment at the firm's reinvestment rate rather than the project's IRR, providing a more realistic measure.
Q2: What's considered a good MIRR value?
A: Generally, an MIRR higher than the company's cost of capital indicates a good investment.
Q3: When should I use the combination approach?
A: Use this approach when you have separate financing and reinvestment rates for your cash flows.
Q4: How do I calculate FVp and PVn?
A: FVp is the sum of all positive cash flows compounded at the reinvestment rate. PVn is the sum of all negative cash flows discounted at the finance rate.
Q5: Can MIRR be negative?
A: Yes, a negative MIRR indicates the project's cost exceeds its returns when considering the reinvestment rate.