IRR Calculator — Internal Rate of Return, MIRR, NPV & Capital Budgeting
Measure the Internal Rate of Return of an Investment or Project
The Internal Rate of Return (IRR) is one of the most widely used measures in capital budgeting because it converts a project's expected cash flows into a single annualized percentage that can be compared with a required return, hurdle rate, or cost of capital. Unlike simple ROI, IRR does not merely compare the beginning and ending value of an investment. It considers the timing of the complete cash-flow stream and asks a more precise question: what discount rate makes the project's net present value equal to zero? In mathematical terms, IRR is the rate r that solves the equation:
where the initial investment is normally represented as a negative cash flow and subsequent project inflows or outflows are represented in their actual periods. OpenStax defines IRR as the discount rate that sets a project's NPV equal to zero, while Damodaran presents the same relationship as the fundamental definition used in discounted cash-flow capital budgeting.
The calculator is designed to make that relationship visible rather than treating IRR as a mysterious percentage generated by a black box. In the primary reference example, the initial investment is $40,000, the hurdle rate or WACC is 12%, the reinvestment rate for MIRR is 10%, and the financing cost is 8%. The project then receives annual net cash flows of $10,000 in Year 1, $20,000 in Year 2, and $30,000 in Year 3. The verified engine solves an IRR of approximately 19.438%, a modified IRR of approximately 17.022% (or 17.072% under alternate reinvestment assumptions), NPV of roughly $6,225.86, a profitability index around 1.156, and a discounted payback of about 2.71 years.
That example illustrates why IRR should never be interpreted without context. The project's IRR is above its 12% hurdle rate, so under a conventional capital-budgeting rule the project satisfies that return hurdle. But the comparison is not simply "19.438% is a good number." The percentage is meaningful only relative to the project's risk, cost of capital, cash-flow assumptions, and alternative investment opportunities.
This distinction is particularly important when comparing projects of different sizes. A small project can produce a very high IRR while creating relatively little dollar value, while a much larger project can have a lower IRR but create substantially more NPV. Damodaran's capital-budgeting materials explicitly discuss conflicts between NPV and IRR caused by project scale and timing, and note that NPV is a dollar surplus-value measure whereas IRR is a percentage return measure.
For a simpler beginning-to-ending investment return, the ROI Calculator is more appropriate. For the time value of money underlying the NPV calculation, the Present Value Calculator and Future Value Calculator provide useful companion analyses. For annualized growth expressed without the full capital-budgeting framework, the CAGR Calculator can provide another perspective.
How IRR Is Calculated: The NPV Equation, Cash-Flow Timing and Numerical Root Finding
The defining equation behind IRR is simple to write but difficult to solve algebraically for most real-world cash-flow schedules:
Consider the reference scenario: Initial outlay = $40,000; Year 1 = $10,000; Year 2 = $20,000; Year 3 = $30,000.
The calculator's implementation uses high-precision Newton-Raphson iteration with automatic bisection fallback when required. The fundamental validation of any calculated IRR is to plug it back into the original NPV equation to confirm NPV(IRR) ≈ 0.
IRR vs NPV vs MIRR: Three Different Ways to Evaluate the Same Project
IRR, NPV, and MIRR answer three distinct financial questions:
| Metric | Output Unit | Time Value of Money? | Primary Strength | Key Limitation |
|---|---|---|---|---|
| Internal Rate of Return (IRR) | Percentage (%/yr) | Yes (Compounded) | Intuitive benchmarking across scales | Unrealistic reinvestment rate assumption |
| Net Present Value (NPV) | Dollar Amount ($) | Yes (Discounted) | Direct measure of enterprise wealth added | Requires estimating a precise hurdle rate |
| Modified IRR (MIRR) | Percentage (%/yr) | Yes (Explicit WACC) | Realistic reinvestment rate & unique root | Requires user financing & reinvestment inputs |
| Simple ROI | Percentage (%) | No (Ignored) | Extremely simple to calculate | Completely blind to project duration |
MIRR: A More Explicit Reinvestment and Financing Model
Standard IRR mathematically assumes that all interim positive cash flows generated during Year 1, Year 2, etc., are continuously reinvested at the project's own internal rate of return. If a project has a 45% IRR, it assumes all cash is reinvested at 45% per year—an assumption that is virtually impossible in practical corporate management.
Modified IRR (MIRR) corrects this by compounding positive inflows forward at the company's actual cost of capital or reinvestment rate (e.g., 10%) and discounting financing outlays at the borrowing rate (e.g., 8%):
Multiple IRRs and Non-Conventional Cash Flows: Why Some Projects Do Not Have One Unique IRR
When a project features non-conventional cash flows that switch signs more than once (such as −$10k initial outlay, +$30k operating cash flow, and −$25k environmental decommissioning cleanup), Descartes' Rule of Signs proves that the polynomial has multiple real roots.
In the reference baseline (−$10,000, +$30,000, −$25,000), standard IRR produces roots at both 22.98% and 77.02%. The calculator provides a Descartes' Rule diagnostic that warns users when sign changes occur and provides MIRR as an unambiguous single rate.
Monthly and Fixed-Annuity IRR: Translating Periodic Cash Flows Correctly
IRR is inherently a periodic calculation. For monthly recurring cash flows, the root-solving process occurs in monthly periods before converting into annual terms:
In the reference example ($10,000 initial outlay, $15,000 ending terminal balance, $100 monthly withdrawal over 2.5 years), the periodic monthly rate yields approximately 26.343% nominal annual IRR and 29.768% annual compounded IRR.
For recurring accumulation, the Annuity Calculator or Future Value Calculator can provide helpful companion analysis.
Project Comparison and the Fisher Crossover Rate: When IRR and NPV Tell Different Stories
The Fisher crossover rate is the discount rate at which two competing projects have the exact same Net Present Value:
Below the crossover rate, one project dominates in dollar value; above it, the other project becomes optimal. Changing the cost of capital updates NPV and ranking decisions without altering each project's intrinsic IRR.
For borrowing decisions, the Loan Calculator and APR Calculator can compare borrowing costs against project IRR.
IRR Sensitivity, Capital-Budgeting Applications and How to Interpret the Result Responsibly
Compare expected factory or robotics expansion returns against the firm's WACC.
Model gross and net fund returns across 3- to 7-year holding periods with leveraged buyouts (LBOs).
Project equity returns by modeling acquisition equity, annual NOI after debt service, and disposition proceeds.
Solve for implicit lease interest rates across scheduled customer payments and residual scrap values.
Common IRR Mistakes and How to Use the Calculator for Better Capital-Budgeting Decisions
Simple ROI ignores timing; IRR discounts every cash flow according to the year or month it occurs.
Non-conventional cash flows can produce multiple valid mathematical roots.
A $1,000 project with 80% IRR creates $800; a $10,000,000 project with 22% IRR creates $2,200,000 in wealth.
Standard IRR implies reinvestment at the IRR; MIRR corrects this with a realistic hurdle rate.
For broader investment return metrics, explore the Average Return Calculator.
Frequently Asked Questions
Q1.What is the difference between IRR and NPV?
IRR is the discount rate that makes a project's NPV equal to zero. NPV is the dollar value of the project's future cash flows after discounting them at a selected required return, less the initial investment. IRR is therefore a percentage measure, while NPV is a value-creation measure.
Q2.Why is IRR important in corporate capital budgeting?
IRR provides a percentage return that can be compared with a company's hurdle rate or cost of capital. A conventional project with an IRR above the relevant required return may satisfy the normal IRR acceptance rule. It also gives managers an intuitive way to compare the project's implied return with alternative uses of capital.
Q3.What is an acceptable IRR for an investment project?
There is no universal acceptable IRR. The relevant benchmark depends on the project's risk, financing cost, inflation, industry, useful life, and available alternatives. A project generally needs to be compared with an economically appropriate hurdle rate rather than an arbitrary universal percentage.
Q4.What is the reinvestment-rate assumption in IRR, and how does MIRR address it?
Standard IRR can imply that interim project cash flows are reinvested at the IRR. MIRR makes the assumption explicit by allowing the analyst to specify a reinvestment rate and a financing rate. The resulting modified return is therefore based on those stated assumptions rather than the project's own IRR.
Q5.Why can some cash-flow streams have multiple IRRs?
When cash flows change sign more than once, the IRR equation can have multiple real roots. For example, a sequence such as negative investment, positive operating cash flow, and later negative cleanup expenditure can produce more than one IRR. This is a mathematical property of non-conventional cash flows, not necessarily a calculator error.
Q6.How does IRR account for the time value of money?
IRR incorporates time value by discounting each future cash flow according to its period and finding the rate that makes the combined present value equal the initial investment. The timing of each cash flow therefore affects the result.
Q7.What is a hurdle rate?
A hurdle rate is the minimum return an organization requires before accepting a project under its chosen decision framework. If a conventional project's IRR exceeds the hurdle rate, the project may satisfy the IRR acceptance rule. The hurdle rate itself does not change the project's mathematical IRR.
Q8.How does the timing of cash flows affect IRR?
Two projects with identical total future cash inflows can produce different IRRs if one receives more cash earlier and the other receives more cash later. Earlier cash flows generally have greater present value, so timing can materially affect both IRR and NPV.
Q9.Can IRR be negative?
Yes. A project can have a negative IRR when the modeled cash-flow stream implies that recovering the initial investment requires a negative periodic return. A negative IRR should not automatically be interpreted as a software error; the underlying cash-flow structure must be examined.
Q10.What is the Profitability Index and how is it used alongside IRR?
Profitability Index generally relates the present value of future cash inflows to the initial investment. A PI above 1 is associated with positive NPV under the same assumptions, while a PI below 1 corresponds to negative NPV. It can be particularly useful when comparing projects under capital constraints.
Q11.What is the Fisher crossover rate?
The Fisher crossover rate is the discount rate at which two competing projects have equal NPV. It can help explain why the relative ranking of two projects changes as the required return changes. The concept is particularly relevant when projects differ in cash-flow timing or scale.
Q12.How should non-conventional cash flows be handled in capital budgeting?
Non-conventional cash flows should be modeled with their actual signs and timing. Multiple sign changes can create multiple IRRs, so analysts should examine NPV, MIRR, and the project economics rather than assuming a single standard IRR is sufficient. The calculator's multiple-IRR diagnostic is designed specifically for this situation.
Formula Identities: 0 = Σ [CFₜ ÷ (1 + IRR)ᵗ] − CF₀ | NPV = Σ [CFₜ ÷ (1 + r)ᵗ] − CF₀ | MIRR = [FV(Pos @ r_reinvest) ÷ −PV(Neg @ r_finance)]^(1/n) − 1 | PI = PV(Inflows) ÷ Initial Outlay.
Interpretation: IRR is a model-derived root, not a guaranteed future yield. For mutually exclusive capital projects, evaluate NPV alongside IRR to guard against scale blindness and the reinvestment rate flaw.