IRR Formula
The internal rate of return (IRR) is the discount rate that sets the net present value (NPV) of all future cash flows to exactly zero. In other words, it is the break‑even expected annual growth rate of an investment. Unlike the dollar‑based NPV, IRR expresses profitability as a percentage – ideal for comparing projects of different sizes.
What Is the IRR Formula?
Mathematically, IRR is the value of r that solves the equation:
\[ NPV = \sum\_{t=0}^{n} \frac{C_t}{(1 + r)^t} = 0 \]Where:
- Cₜ = net cash flow at time t (negative for outflows, positive for inflows)
- r = internal rate of return (the unknown)
- t = time period (year, month, etc.)
- n = total number of periods
There is no closed‑form algebraic solution for arbitrary cash flows. The equation must be solved iteratively – by trial and error, interpolation, or specialized software.
How to Calculate IRR
1. Iterative Approach (Manual)
Choose a starting rate r₁, calculate NPV. If NPV is positive, increase the rate; if negative, lower it. Repeat until NPV is close to zero. Linear interpolation between two rates that bracket zero speeds up the process.
For example:
- Initial investment: –$10,000
- Year 1 cash flow: $3,000
- Year 2: $4,000
- Year 3: $4,500
At 10%: NPV ≈ +$189
At 15%: NPV ≈ –$362
Interpolated IRR ≈ 10% + \([189 / (189 + 362)] × 5%\) ≈ 11.7%
2. Online IRR Calculator
For quick, mistake‑free results, use the calculator above. Enter your series of cash flows, and it instantly computes the exact IRR using an efficient numerical algorithm – no manual trial and error required.
3. Excel Functions
Microsoft Excel provides two primary functions:
- IRR(values, [guess]) – for equally spaced periods (e.g., annual). Example:
=IRR(B1:B4, 0.1) - XIRR(values, dates, [guess]) – for cash flows with specific dates, handles irregular intervals. Example:
=XIRR(B1:B4, A1:A4)
The guess parameter is optional but speeds up convergence. Default is 0.1 (10%). For most investment profiles, the result is insensitive to the guess.
IRR vs. NPV – Which Metric Matters?
| Metric | Meaning | Output | Use case |
|---|---|---|---|
| IRR | Break‑even discount rate | Percentage | Comparing returns across projects, setting hurdle rates |
| NPV | Present value of all cash flows at a given discount rate | Dollar amount | Deciding whether a project adds value (NPV > 0) |
IRR is intuitive for expressing a project’s efficiency, but it doesn’t tell you the total value created. A small short‑term project can have a very high IRR but generate less total wealth than a larger project with a moderate IRR. Use both metrics together.
IRR Calculation Example with Dates
Consider an investment with the following cash flows:
| Date | Cash Flow |
|---|---|
| 01‑Jan‑2026 | –50,000 |
| 01‑Apr‑2026 | 15,000 |
| 01‑Jul‑2026 | 18,000 |
| 01‑Oct‑2026 | 22,000 |
Using the XIRR function (or our calculator with date inputs), the annualized IRR is 38.7%. The high return reflects the short investment horizon – all returns are received within one year.
When IRR Works Well
- Conventional cash flows (one outflow followed by inflows)
- Comparing mutually exclusive projects with similar scale and duration
- Setting a minimum acceptable rate of return (hurdle rate) – if IRR exceeds the cost of capital, the project is acceptable
Limitations to Keep in Mind
- Reinvestment assumption – IRR implicitly assumes all interim cash flows can be reinvested at the IRR itself. If actual reinvestment rates are lower, the true return will be overstated.
- Multiple IRR values – when cash flow signs change more than once (e.g., negative, positive, negative), the equation may have more than one solution. The Modified IRR (MIRR) or NPV is then preferable.
- Scale insensitivity – a very small investment with a massive percentage return may be favored over a large, high‑value project.
- Mutually exclusive projects – IRR can rank projects incorrectly when cash flow timing differs significantly.
This article is for informational purposes only and does not constitute financial advice. Always verify calculations against your actual data.