Internal Rate of Return Calculator:
IRR Formula, MIRR, NPV Relationship, and Capital Project Analysis
IRR is the discount rate that makes an investment’s net present value exactly zero — the precise break-even cost of capital below which the project creates value and above which it destroys it. Unlike ROI, IRR accounts for the timing of every cash flow in the series. Unlike CAGR, IRR handles multiple inflows and outflows at different points. And unlike NPV, IRR produces a percentage that can be compared directly against a hurdle rate without knowing the exact cost of capital in advance.
The internal rate of return is the most widely used capital budgeting metric in corporate finance and the standard performance benchmark in private equity, venture capital, and real estate investment. A CFO presenting a capital expenditure proposal to the board, a private equity fund reporting to limited partners, and a real estate developer evaluating a seven-year hold all use IRR as their primary return metric. Yet IRR is also the most frequently misunderstood financial metric, with three specific failure modes — the reinvestment rate assumption, the multiple IRR problem, and the scale insensitivity limitation — that can lead to incorrect capital allocation decisions when IRR is used without awareness of its constraints.
This guide builds a complete analytical framework for IRR: the exact mathematical definition as the solution to the NPV=0 equation, the Newton-Raphson iterative algorithm that calculators and spreadsheets use to solve for it, the MIRR correction that addresses the reinvestment rate flaw, the multiple IRR problem and when it applies, real-world applications in business capital projects and real estate, the IRR versus WACC decision rule, and the precise circumstances where IRR should be replaced by NPV or MIRR as the primary decision metric.
IRR Defined: The Rate That Makes NPV Equal Zero
The internal rate of return is defined as the discount rate r that satisfies the NPV equation when set equal to zero. The NPV equation discounts each cash flow Ct at period t back to the present by dividing by (1+r)^t, then sums all discounted cash flows. When this sum equals zero, the discount rate used is the IRR. This is not a formula that can be solved algebraically for most multi-period cash flow series — it requires iterative numerical methods to compute.
IRR: SOLVE FOR r WHERE NPV = 0
MIRR: CORRECTS REINVESTMENT RATE ASSUMPTION
The IRR’s mathematical definition contains a subtle but important economic interpretation: it is the single interest rate at which the present value of all future cash inflows exactly equals the present value of all cash outflows. If you borrowed money at exactly the IRR rate to fund the initial investment and reinvested all inflows at that same rate, you would end the project with exactly zero net gain or loss. This break-even interpretation is what makes IRR directly comparable to a cost of capital or hurdle rate: if your borrowing cost or required return is below the IRR, the project earns more than it costs and creates value.
How IRR Is Actually Computed: Newton-Raphson Iteration
Since the NPV=0 equation has no closed-form algebraic solution for most cash flow series, IRR is computed numerically using an iterative algorithm. The Newton-Raphson method is the standard approach used by Excel’s IRR() function, financial calculators, and most computational finance implementations. It converges rapidly for well-behaved (single sign-change) cash flows, typically reaching sufficient precision within 10 to 20 iterations.
The iteration example above reveals the bracketing logic of IRR computation: starting with a guess, computing the NPV at that rate, observing whether it is positive (IRR is higher) or negative (IRR is lower), and refining the estimate. Newton-Raphson improves on simple bisection by using the slope of the NPV curve (its derivative) to make a smarter update step, converging much faster. For the five-cash-flow example above, Excel’s IRR() function reaches the 15.10% solution in eight iterations starting from its default 10% guess.
The practical implication for spreadsheet users: Excel’s IRR() function works on a range of equally spaced periodic cash flows (annual, monthly, quarterly), with the first value being the negative initial investment. The XIRR() function accepts the same cash flows but with a parallel column of actual dates, allowing for irregular payment intervals — essential for real estate transactions that close mid-month or business investments with non-calendar-year cash flows. For monthly cash flows, IRR() returns the monthly IRR; multiply by 12 to annualize (though (1 + monthly IRR)^12 – 1 is the more precise annualized figure).
IRR vs NPV vs MIRR vs CAGR: The Complete Metric Decision Matrix
Each of the four primary investment return metrics answers a different analytical question. Selecting the wrong metric for the situation produces a correct calculation of the wrong thing. The decision matrix below maps each metric to its specific use case, limitation, and the type of cash flow structure it is designed to handle.
The NPV versus IRR comparison is the most important distinction in capital budgeting theory. NPV is theoretically superior because it measures value creation in dollars (which is what shareholders care about) and does not embed a potentially unrealistic reinvestment rate assumption. IRR is practically superior for many situations because it does not require specifying a discount rate in advance, produces a percentage that can be communicated and compared across projects and industries intuitively, and allows a clear comparison against a known hurdle rate. Finance textbooks since Brealey, Myers, and Allen have recommended NPV as the primary metric; practitioners have overwhelmingly continued to use IRR alongside NPV, treating them as complementary tools.
Calculate IRR for Any Cash Flow Series Instantly
Enter your initial investment and up to 20 years of cash flows to calculate IRR, MIRR at your reinvestment rate, NPV at your hurdle rate, and payback period — with the full Newton-Raphson iteration shown.
Open the IRR CalculatorMIRR: Correcting IRR’s Reinvestment Rate Flaw
The standard IRR formula’s most significant mathematical flaw is its implicit assumption that all positive cash flows generated by the investment are reinvested at the IRR rate for the remainder of the project’s life. For a project with an IRR of 15%, the formula assumes that the $25,000 received in Year 1 is reinvested at 15% through Year 5. If the company’s actual reinvestment opportunities earn only 8% (the typical WACC for a mature company), the standard IRR overstates the true economic return of the project.
The visualization above demonstrates the IRR overstatement quantitatively: the same five-cash-flow project has a standard IRR of 15.10%, but its MIRR ranges from 11.28% to 13.30% depending on the realistic reinvestment rate assumption. The gap between IRR and MIRR is largest for high-IRR projects (where the reinvestment rate assumption matters most) and smallest for projects whose IRR is close to the actual reinvestment rate. Financial analysts in private equity and corporate finance who use MIRR alongside IRR produce more conservative and reliable return estimates that better reflect the actual value created by the investment.
The MIRR formula: MIRR = (FV of positive cash flows compounded at the reinvestment rate / PV of negative cash flows discounted at the finance rate)^(1/n) – 1. In the business project example with an 8% reinvestment rate: FV of positive cash flows at 8% = $25,000 x 1.08^4 + $30,000 x 1.08^3 + $35,000 x 1.08^2 + $40,000 x 1.08 + $20,000 = $34,012 + $37,791 + $40,824 + $43,200 + $20,000 = $175,827. MIRR = ($175,827 / $100,000)^(1/5) – 1 = 11.94%. Excel’s MIRR() function computes this directly.
The Multiple IRR Problem: When IRR Fails Completely
The multiple IRR problem is the most serious analytical failure mode of the IRR metric. By Descartes’ Rule of Signs, the NPV = 0 polynomial equation can have as many positive real solutions as there are sign changes in the cash flow series. A conventional investment (one negative cash outflow followed by positive inflows) has exactly one sign change and therefore exactly one IRR. A non-conventional cash flow series with two or more sign changes can have two or more mathematically valid IRRs, none of which individually represents the true economic return.
Multiple IRR Example: Two Valid Solutions, Neither Correct
Cash flows: Year 0: -$100,000 | Year 1: +$230,000 | Year 2: -$132,000. This series has two sign changes (negative to positive, then positive to negative). The NPV equation has two solutions: IRR = 10% and IRR = 20%. At both rates, NPV = 0. Plugging either into Excel’s IRR() returns one of the two values depending on the starting guess. Neither 10% nor 20% alone describes the project’s return. This pattern appears in: oil well investments (large cleanup costs at end), leveraged buyouts with refinancing costs, projects with major renovation expenses mid-life, and any investment where significant cash outflows occur after the initial period.
The correct approach when non-conventional cash flows produce multiple IRR solutions is to abandon IRR entirely for that analysis and use NPV at the known cost of capital or MIRR with a specified reinvestment rate. MIRR by construction always produces a unique solution because it separates positive and negative cash flows, compounding positives forward and discounting negatives back, eliminating the polynomial sign-change problem. For any investment where additional capital expenditures are required after the initial outlay (renovation costs, environmental remediation, equipment replacement), analysts should verify whether the cash flow series has more than one sign change before relying on IRR as the primary metric.
Real Estate IRR: A Complete Worked Example
Real estate is one of the most natural applications of IRR analysis because rental properties generate cash flows over multiple years before a terminal sale event — exactly the structure that makes IRR superior to ROI or CAGR. The real estate IRR captures both the ongoing rental yield and the terminal appreciation in a single annualized return metric that can be compared directly against alternative investments, financing costs, or fund benchmarks.
| Year | Cash Flow | Description | PV @ 10% | PV @ 10.2% (IRR) |
|---|---|---|---|---|
| 0 | -$300,000 | Purchase price (all cash, no leverage) | -$300,000 | -$300,000 |
| 1 | +$18,000 | Net rental income (gross $26K minus vacancy, mgmt, expenses) | $16,364 | $16,334 |
| 2 | +$18,000 | Year 2 net rental income | $14,876 | $14,822 |
| 3 | +$18,000 | Year 3 net rental income | $13,524 | $13,450 |
| 4 | +$18,000 | Year 4 net rental income | $12,294 | $12,205 |
| 5 | +$18,000 | Year 5 net rental income | $11,176 | $11,074 |
| 6 | +$18,000 | Year 6 net rental income | $10,160 | $10,049 |
| 7 | +$438,000 | Year 7: $18K rent + $420K sale proceeds (40% appreciation) | $224,895 | $221,998 |
| NPV of all cash flows | +$3,289 (NPV positive @ 10%) | -$68 (NPV ~ 0 @ 10.2% = IRR) | ||
The real estate IRR of 10.2% above reflects the blended return of two distinct value streams: a 6% annual rental yield on the purchase price ($18,000 / $300,000) combined with 40% price appreciation realized at year 7. Neither yield alone captures the full investment return. The cap rate (6%) understates the total return because it ignores appreciation. A simple ROI calculation ($438,000 + $126,000 rent – $300,000 cost = 88% simple ROI) ignores the timing of cash flows and the time value of money. IRR at 10.2% is the single most informative summary of this investment’s economics.
Leverage Dramatically Changes Real Estate IRR
The example above assumes an all-cash purchase. With 25% down ($75,000) and a 75% mortgage ($225,000) at 7% interest, the equity IRR changes substantially. The mortgage payments come out of rental income (partially), and when the property sells for $420,000 the mortgage is repaid from proceeds. The levered equity IRR on the $75,000 down payment can exceed 15 to 20% even with the same 10.2% unlevered IRR, because leverage amplifies equity returns. Always specify whether real estate IRR is levered (on equity) or unlevered (on total property value) when communicating performance.
The IRR vs WACC Decision Rule: Accept, Reject, or Investigate Further
The practical application of IRR in corporate capital budgeting follows a straightforward decision rule: accept projects where IRR exceeds the weighted average cost of capital (WACC); reject projects where IRR falls below WACC; and conduct additional analysis for projects where IRR is close to WACC, where non-conventional cash flows create multiple IRR solutions, or where comparing mutually exclusive projects of different scale. This rule is correct for evaluating independent projects with conventional cash flows. It can produce wrong decisions in three specific cases that require awareness.
| Project IRR | WACC / Hurdle Rate | Decision | NPV Implication | Strategic Note |
|---|---|---|---|---|
| 25% | 8% | Strong Accept | Strongly positive | Rare — verify assumptions for overstatement |
| 15.10% | 8% | Accept | Positive | Business project example: proceed |
| 10.20% | 8% | Accept (marginal) | Modestly positive | Real estate example: verify all assumptions |
| 9% | 8% | Borderline — further analysis | Marginally positive | Small errors in cash flow estimates could flip decision |
| 7% | 8% | Reject | Negative | Destroys value at current WACC |
| 4% | 8% | Strong Reject | Significantly negative | Capital should be returned to shareholders or invested elsewhere |
| IRR rule holds for conventional cash flows (single sign change). For non-conventional flows or mutually exclusive projects, use NPV as the primary decision metric. Accept/reject assumes all projects can be funded — scarce capital requires ranking by NPV, not IRR. | ||||
The three cases where the IRR vs WACC rule produces incorrect conclusions: first, comparing mutually exclusive projects of different scale (a $1M project with 20% IRR vs a $10M project with 15% IRR — the larger project may create more total dollar value despite the lower IRR); second, non-conventional cash flows producing multiple IRR solutions (use MIRR or NPV instead); and third, projects with highly unconventional cash flow timing, such as those where most cash flows arrive in the distant future (the NPV profile has extreme sensitivity to the discount rate, making small WACC estimation errors very consequential). In all three cases, NPV analysis should supplement or replace IRR as the primary decision metric.
IRR Analysis Best Practices Checklist
Frequently Asked Questions: IRR
What is the internal rate of return (IRR)?+
The internal rate of return is the discount rate that makes the net present value (NPV) of all cash flows from an investment equal to zero. Mathematically, it solves: 0 = C0 + C1/(1+IRR) + C2/(1+IRR)^2 + … + Cn/(1+IRR)^n, where C0 is the initial investment (negative) and C1 through Cn are the periodic cash inflows. IRR is the break-even cost of capital: if the actual cost of capital or hurdle rate is below the IRR, the investment creates positive NPV; if above, it destroys value. IRR cannot be solved algebraically for most multi-period cash flows and requires numerical iteration to compute.
How is IRR calculated step by step?+
IRR is calculated using numerical iteration (Newton-Raphson method). Step 1: Start with an initial rate guess (typically 10%). Step 2: Calculate NPV at that rate. Step 3: If NPV is positive, the IRR is higher; if negative, the IRR is lower. Step 4: Update the guess using the Newton-Raphson formula: new rate = old rate – NPV(rate) / NPV'(rate), where NPV’ is the derivative. Step 5: Repeat until NPV is within tolerance of zero. In Excel: use IRR(cash_flow_range) for equal-interval cash flows, or XIRR(cash_flows, dates) for irregular intervals. The calculator enters -100,000 in Year 0 and the positive cash flows in subsequent years; IRR() returns the annualized rate.
What is the difference between IRR and NPV?+
NPV calculates the dollar value created by an investment at a specific discount rate: NPV = sum of [Ct / (1+r)^t] – Initial Investment. IRR finds the specific rate at which NPV equals zero. NPV requires knowing the discount rate (WACC) in advance; IRR does not. NPV measures value in dollars; IRR produces a percentage. For independent projects with conventional cash flows, both metrics agree: positive NPV projects have IRR exceeding the cost of capital. They can disagree when comparing mutually exclusive projects of different size (NPV is correct) or when non-conventional cash flows produce multiple IRR solutions (use NPV or MIRR). Finance theory favors NPV; practitioners use both.
What is MIRR and why is it preferred over IRR?+
MIRR (Modified Internal Rate of Return) corrects two flaws in standard IRR: the unrealistic reinvestment rate assumption and the potential for multiple solutions with non-conventional cash flows. IRR assumes all positive cash flows are reinvested at the IRR rate itself. MIRR uses a separate, user-specified reinvestment rate (typically WACC or expected market return). For a project with IRR of 15.1% and a realistic 8% reinvestment rate, MIRR = (FV of positives at 8% / PV of negatives)^(1/n) – 1 = 11.94%. MIRR always produces a unique solution. Excel’s MIRR() function computes it directly with three arguments: cash flows, finance rate, reinvestment rate.
What is the multiple IRR problem?+
The multiple IRR problem occurs when a cash flow series has more than one sign change (positive to negative or negative to positive). By Descartes’ Rule of Signs, the NPV=0 polynomial equation can have as many solutions as sign changes. A project with cash flows of -$100,000, +$230,000, -$132,000 has two sign changes and can produce two valid IRRs (approximately 10% and 20%). Neither alone is the correct return measure. This problem appears in projects with significant end-of-life costs (environmental cleanup, decommissioning), leveraged buyouts with refinancing outflows, or real estate with major renovation costs mid-hold. Solution: use MIRR or NPV for non-conventional cash flows.
What is a good IRR for a real estate investment?+
Real estate IRR benchmarks vary by strategy and risk: Core real estate (stabilized, low-risk assets) typically targets levered equity IRRs of 8 to 12%. Core-plus adds modest value-add risk and targets 10 to 14%. Value-add strategies (significant renovation or lease-up risk) target 14 to 18%. Opportunistic strategies (ground-up development, distressed assets) target 18 to 25% or higher. These are levered (equity) IRR targets. Unlevered IRRs are typically 3 to 7 percentage points lower. A real estate deal should be evaluated against the investor’s specific cost of capital, not generic benchmarks, as local market conditions, asset type, and financing availability all affect the appropriate hurdle rate.
How does IRR differ from ROI and CAGR?+
ROI measures total percentage return without time adjustment: ROI = Net Profit / Cost x 100. CAGR converts total return to an annualized rate for a single entry and exit: CAGR = (EV/BV)^(1/n) – 1. IRR accounts for the specific timing of every individual cash flow in the series. For investments with a single purchase and sale and no intermediate cash flows, CAGR and IRR produce identical results. For investments with multiple cash flows at different times (monthly rent, quarterly dividends, capital calls, distributions), IRR is the correct metric. ROI and CAGR cannot handle multiple intermediate cash flows and should not be used for real estate, private equity, or multi-period business project analysis.
How is IRR used in private equity?+
Private equity uses IRR as the primary performance metric for fund and investment-level returns. IRR is calculated on the equity cash flows: capital called from limited partners (negative), management fees (negative), portfolio company distributions (positive), and final exit proceeds (positive). PE funds typically target gross IRRs of 20 to 30% and report net IRRs (after management fees and carried interest) of 15 to 25% to limited partners. The DPI (Distributions to Paid-In Capital) multiple and TVPI (Total Value to Paid-In Capital) multiple are reported alongside IRR because high IRRs achieved quickly on small investments can look compelling while creating less absolute value than a lower IRR on a larger, longer investment.
What is the IRR vs WACC decision rule?+
The IRR vs WACC decision rule: accept a project if IRR exceeds the WACC (Weighted Average Cost of Capital); reject if IRR falls below WACC. The WACC is the blended cost of debt and equity capital, weighted by their proportions in the company’s capital structure. When IRR exceeds WACC, the project earns more than the cost of the capital funding it, generating positive NPV. When IRR falls below WACC, the project destroys value. This rule works correctly for independent projects with conventional cash flows. It can fail for mutually exclusive project comparisons of different scale, for non-conventional cash flows with multiple IRR solutions, and for projects with extreme duration where small WACC estimation errors are highly consequential.
Key Takeaways
IRR is the most analytically powerful and most widely misused metric in capital budgeting. It correctly accounts for the timing of all cash flows, produces a percentage directly comparable to a hurdle rate, and eliminates the need to specify a discount rate in advance — capabilities that no simpler metric provides. Its limitations are equally specific: the reinvestment rate assumption that overstates returns for high-IRR projects, the multiple IRR problem that renders it unreliable for non-conventional cash flows, and the scale insensitivity that makes it inappropriate as the sole ranking metric when choosing among mutually exclusive projects of different size.
The complete IRR analysis protocol addresses all three limitations: run MIRR alongside IRR using the company’s WACC as the reinvestment rate, verify that the cash flow series has only one sign change before relying on IRR, and supplement IRR rankings with NPV dollar comparisons when choosing between competing projects. Applied within these boundaries, IRR remains the indispensable analytical tool for evaluating business capital expenditures, real estate investments, private equity performance, and any other investment structure where multiple cash flows occur at different points in time.
Solve IRR for Any Cash Flow Series Instantly
Our IRR Calculator runs the Newton-Raphson iteration on up to 20 cash flows, computes MIRR at your specified reinvestment rate, calculates NPV at your hurdle rate, and flags the multiple IRR warning for non-conventional cash flows.
Launch the IRR Calculator