Finance & Economics · Valuation · Valuation Models
Internal Rate of Return (IRR) Calculator
Calculates the Internal Rate of Return (IRR) for a series of cash flows using numerical iteration, helping investors evaluate project profitability.
Calculator
Formula
CF_t is the net cash flow at time period t (negative for outflows, positive for inflows). IRR is the Internal Rate of Return — the discount rate that sets the Net Present Value (NPV) of all cash flows to zero. N is the total number of periods. Because this equation has no closed-form solution, IRR is found numerically using iterative methods such as Newton-Raphson or bisection.
Source: Brealey, Myers & Allen — Principles of Corporate Finance, 13th Edition; CFA Institute — Corporate Finance curriculum.
How it works
IRR is fundamentally tied to the concept of the time value of money. A dollar received today is worth more than a dollar received in the future because today's dollar can be reinvested to earn returns. NPV quantifies this by discounting future cash flows back to present value. IRR is the specific discount rate that makes the sum of all present values — including the initial outflow — equal to zero. If a project's IRR exceeds the firm's required rate of return (often called the hurdle rate or weighted average cost of capital), the project is considered value-creating and should be accepted.
The governing formula is: NPV = Σ [CF_t / (1 + IRR)^t] = 0, where CF_t represents the cash flow in period t (negative for investments/outflows, positive for receipts/inflows) and t runs from 0 (today) to N (the final period). Because this polynomial equation has no general closed-form solution, IRR must be solved numerically. This calculator uses the Newton-Raphson method, an iterative algorithm that converges rapidly on the root by repeatedly refining an estimate using the ratio of the function value to its derivative. The process halts when the estimate changes by less than 0.000001% between iterations.
Practical applications of IRR span capital budgeting decisions (comparing machinery purchases, plant expansions, or new product lines), private equity and venture capital deal screening, real estate investment analysis (where it competes with metrics like equity multiple and cash-on-cash return), infrastructure project evaluation by governments, and personal investment benchmarking. Decision rules: accept a project if IRR ≥ hurdle rate; reject if IRR < hurdle rate. When comparing mutually exclusive projects, choose the one with higher IRR — but always cross-check with NPV to avoid scale distortions.
Worked example
Consider a capital project with the following cash flows: an initial investment of $100,000 at Year 0, followed by inflows of $25,000 (Year 1), $30,000 (Year 2), $35,000 (Year 3), $40,000 (Year 4), and $45,000 (Year 5).
Step 1 — Set up the NPV equation: 0 = -100,000 + 25,000/(1+r) + 30,000/(1+r)² + 35,000/(1+r)³ + 40,000/(1+r)⁴ + 45,000/(1+r)⁵
Step 2 — Iterate numerically: Starting with an initial guess of r = 10%, compute NPV ≈ +$28,664 (positive, so IRR > 10%). Try r = 25%: NPV ≈ -$8,212 (negative, so IRR < 25%). Newton-Raphson quickly converges to approximately r = 20.27%.
Step 3 — Verify: Plugging IRR = 20.27% back into the NPV formula yields a value extremely close to $0.00, confirming the solution.
Step 4 — Interpret: Total undiscounted inflows are $175,000 against a $100,000 investment, yielding a net undiscounted profit of $75,000. But the IRR of 20.27% is what captures the time-adjusted profitability. If this company's hurdle rate is 12%, the project clears the threshold by over 8 percentage points — a strong accept signal.
Limitations & notes
Multiple IRRs: If a cash flow stream changes sign more than once (e.g., a large outflow at the end of the project for decommissioning), there can be multiple mathematically valid IRRs, making interpretation ambiguous. Always plot the NPV profile across discount rates when sign changes occur mid-stream.
Reinvestment rate assumption: IRR implicitly assumes that all intermediate cash inflows are reinvested at the IRR itself, which may be unrealistically high for exceptional projects. The Modified Internal Rate of Return (MIRR) addresses this by specifying separate finance and reinvestment rates.
Scale insensitivity: A project with a 50% IRR on a $10,000 investment adds less absolute value than a project with a 20% IRR on $1,000,000. Always complement IRR analysis with NPV to ensure you are maximising total value rather than percentage return.
Non-conventional projects: Projects with delayed investment phases, milestone payments, or terminal cleanup costs may produce IRR figures that are mathematically correct but economically misleading. Sensitivity analysis and scenario modelling are advisable in these cases.
Calculator scope: This tool supports up to five future periods. For longer investment horizons or irregular cash flow timing (e.g., quarterly), a full spreadsheet model using XIRR (which accounts for actual dates) is recommended.
Frequently asked questions
What is a good IRR for a project?
A 'good' IRR depends entirely on the investor's hurdle rate and the asset class. Corporate projects typically need to clear the company's Weighted Average Cost of Capital (WACC), often 8–15% for mature companies. Private equity funds typically target IRRs of 20–30%, while real estate investments may target 12–18%. Any IRR above your minimum required return generally indicates value creation.
What is the difference between IRR and NPV?
NPV measures the absolute dollar value added by an investment at a specified discount rate — it directly answers 'how much richer does this make me?' IRR is a percentage rate that tells you the project's intrinsic return independent of a predefined discount rate. Both metrics are complementary: use NPV to maximise total value and IRR to gauge efficiency and compare against hurdle rates.
Why can there be multiple IRRs?
The IRR equation is a polynomial, and by Descartes' Rule of Signs, the number of possible positive real roots equals the number of sign changes in the cash flow sequence. A project that has an initial outflow, positive inflows, then a large terminal outflow (e.g., environmental cleanup) changes sign twice and can theoretically produce two valid IRR values. In such cases, NPV analysis or MIRR is more reliable.
What is the difference between IRR and MIRR?
Modified Internal Rate of Return (MIRR) corrects the reinvestment rate assumption embedded in standard IRR. While IRR assumes intermediate cash flows are reinvested at the IRR itself, MIRR lets you specify a realistic reinvestment rate (typically the firm's cost of capital) and a separate financing rate for outflows. MIRR always produces a single value and is generally considered more conservative and realistic than IRR.
Can IRR be negative, and what does that mean?
Yes. A negative IRR means the investment is expected to destroy value — you will receive back less than you invested, even before adjusting for the time value of money. For example, if you invest $100,000 and receive only $80,000 back over five years with no inflows exceeding the losses, IRR will be negative. This is a clear rejection signal regardless of hurdle rate.
Last updated: 2025-01-15 · Formula verified against primary sources.