IRR Calculator

Formula

0 = Σ [CFₜ / (1 + IRR)ᵗ] for t = 0 to N

CFₜ represents the cash flow at time period t (where t=0 is the initial capital investment, typically negative); t is the time index; N is the final period count; and IRR is the internal rate of return per period that satisfies the equation by setting the sum of all discounted cash flows equal to zero.

Worked example

Cash flows (year 0 first, investment negative)

-10000, 3000, 4000, 4000, 3000

• IRR: 14.895%
• Net cash flow: 4,000.00
• Periods: 5

What Internal Rate of Return (IRR) Calculates and Who It Is For

The Internal Rate of Return (IRR) measures the annualized profitability of a potential capital investment. Rather than looking solely at total dollar profit, IRR calculates the compound discount rate that equates the present value of future cash inflows to the original cash outlay. When a project's cash flows are discounted at its IRR, the resulting Net Present Value (NPV) is exactly zero.

Capital budgeting teams, real estate sponsors, venture capitalists, and individual investors rely on IRR to evaluate capital expenditures, compare competing projects, and determine whether an asset meets a predetermined hurdle rate. Because IRR expresses performance as a percentage rate, it allows decision-makers to evaluate assets across different industries and holding periods using a common metric.

---

Step-by-Step Worked Example

To see how the numerical approximation works, consider an investment modeled with the following cash flows:

• Period 0 (Initial Investment): -$10,000
• Period 1: $3,000
• Period 2: $4,000
• Period 3: $4,000
• Period 4: $3,000

1. Calculate Net Nominal Cash Flow

First, sum all cash flows directly to observe total nominal dollar gain: $$\text{Net Cash Flow} = -10,000 + 3,000 + 4,000 + 4,000 + 3,000 = $4,000.00$$ The project spans 5 periods (Period 0 through Period 4) and yields $4,000.00 of total profit above the initial outlay.

2. Set Up the Discounted Equation

To solve for IRR ($r$), establish the present value sum: $$0 = -10,000 + \frac{3,000}{(1+r)^1} + \frac{4,000}{(1+r)^2} + \frac{4,000}{(1+r)^3} + \frac{3,000}{(1+r)^4}$$

3. Iterative Testing

Because $r$ cannot be isolated directly, the calculator tests values using numerical bisection:

• At a discount rate of 10.000%, NPV is +$1,003.48 (the rate is too low).
• At a discount rate of 18.000%, NPV is -$582.44 (the rate is too high).
• By narrowing the range through iterative passes, the calculator identifies the zero-point at r = 14.895%.

4. Verification

Discounting each flow at 14.895% ($r = 0.14895$):

• Period 1: $3,000 / (1.14895)^1 = $2,611.08
• Period 2: $4,000 / (1.14895)^2 = $3,030.13
• Period 3: $4,000 / (1.14895)^3 = $2,637.29
• Period 4: $3,000 / (1.14895)^4 = $1,721.50
• Sum of Inflows: $2,611.08 + $3,030.13 + $2,637.29 + $1,721.50 = $10,000.00

Subtracting the initial $10,000 investment yields an NPV of $0.00, confirming that 14.895% is the exact internal rate of return.

---

How to Interpret the Results and Industry Benchmarks

Interpreting an IRR result requires comparing it to an appropriate baseline, typically an organization's Weighted Average Cost of Capital (WACC) or an investor's minimum target return:

• IRR Exceeds Hurdle Rate: If a company's borrowing and equity cost is 9% and the project generates an IRR of 14.895%, the project creates economic value above its financing costs and is generally acceptable.
• IRR Equals Hurdle Rate: The project yields just enough cash flow to cover the cost of capital, resulting in zero economic value added.
• IRR Below Hurdle Rate: The investment fails to compensate for the cost of funding, signaling capital would be better allocated elsewhere.

In real estate and corporate private equity, stabilized core assets typically target IRRs between 7% and 11%, whereas value-add or opportunistic projects demand IRRs of 15% to 20% or higher to account for higher operational risk.

---

Practical Tips for Cash Flow Modeling

1. Standardize Interval Lengths: Standard IRR formulas assume that all periods represent identical units of time (e.g., exactly 12 months apart). If cash events occur on arbitrary calendar dates, use the XIRR approach rather than standard periodic IRR.
2. Include Unproductive Periods: If a project requires two years of construction before earning revenue, enter Period 1 as $0 rather than omitting it. Omitting periods accelerates the timing of cash flows and artificially inflates the resulting IRR.
3. Assess Terminal Values: In multi-year investments, the final period cash flow frequently includes an asset sale or liquidation value in addition to operational earnings.

---

When Not to Rely on IRR

While IRR is a widely used financial metric, it has notable limitations that make it unsuitable in certain situations:

• Mutually Exclusive Projects of Differing Scale: A small project requiring $10,000 that yields an IRR of 30% generates $3,000 in return, whereas a larger project requiring $1,000,000 that yields an IRR of 18% generates $180,000. Relying solely on IRR favors the smaller, less profitable initiative in total dollar terms. In these cases, Net Present Value (NPV) is the preferred decision tool.
• Unrealistic Reinvestment Assumptions: IRR inherently assumes that all interim cash distributions can be reinvested into other opportunities earning that exact same IRR. For high-return projects (e.g., 40%), this assumption is rarely realistic in practice.
• Non-Conventional Cash Flows: If cash flows switch from positive to negative at later stages—such as environmental cleanup costs or plant decommissioning—the polynomial equation may produce multiple mathematical IRRs or fail to converge on a valid rate.

Comparison

Scenario	Input	Result
Base example	Cash flows (year 0 first, investment negative): -10000, 3000, 4000, 4000, 3000	IRR: 14.895%

Common mistakes

• Entering the initial capital investment as a positive number, which prevents the equation from balancing
• Assuming cash flows can occur at irregular dates without adjusting for periodic compounding
• Overlooking the reinvestment rate assumption (IRR mathematically assumes future inflows are reinvested at the IRR itself, rather than the cost of capital)
• Relying solely on IRR to pick between mutually exclusive projects of drastically different dollar scales
• Failing to recognize multiple internal rates of return when non-normal cash flows flip between positive and negative more than once

Checklist

• Enter the initial outlay as a negative figure at period 0
• List all subsequent periodic cash flows in strict chronological sequence
• Ensure all time intervals between cash flows are identical (e.g., strictly annual)
• Include a zero for any intermediate period that yields no net cash flow
• Check whether cash flows change sign more than once, which can create multiple rates of return
• Compare the calculated IRR against your company's hurdle rate or weighted average cost of capital (WACC)

Calculators Percentage Editorial Team

Calculator guides from the Calculators Percentage team. These introductory examples are educational, not professional advice.

Last reviewed: November 12, 2026

This tool provides mathematical calculations based on standardized discounting formulas for informational purposes only. It does not constitute investment, tax, or financial advice.