IRR Calculator
Calculate the Internal Rate of Return (IRR), Net Present Value (NPV), Modified IRR (MIRR), and payback schedules for investment portfolios, real estate syndications, and corporate capital budgeting.
Cash Flow Schedule
Configure initial investment & periodic cash returns.
Initial capital expenditure required at inception (t = 0).
Benchmark minimum required rate of return for NPV and MIRR.
The NPV Profile charts how project valuation drops as the cost of capital increases. The point where the curve intersects the horizontal axis ($NPV = 0$) represents the exact Internal Rate of Return.
Internal Rate of Return (IRR) Definition & Formula
The Internal Rate of Return (IRR) is the annual discount rate that sets the Net Present Value (NPV) of all future cash flows equal to zero ($NPV = 0$). An investment is financially acceptable when its IRR exceeds the corporate hurdle rate or Weighted Average Cost of Capital ($IRR > WACC$).
Internal Rate of Return Definition & The NPV = 0 Equation
The Internal Rate of Return (IRR) is the foundational metric of corporate finance, commercial real estate underwriting, and private equity. It quantifies the intrinsic annualized rate of growth an investment project generates on its unrecovered invested capital balance.
Mathematically, the IRR is defined as the unique interest rate r = IRR at which the sum of all future discounted cash inflows exactly balances the initial capital expenditure, producing a Net Present Value of exactly zero:
Where C0 is initial cash outlay at inception (t = 0), CFt is net cash flow generated at period t, and n is total project lifespan.
| Variable | Financial Definition | Accounting Significance |
|---|---|---|
| C0 | Initial Capital Outlay (Period 0) | Cash invested upfront before operations commence. |
| CFt | Net Cash Flow at Time Period t | Operating revenue minus operating expenses, taxes, and working capital shifts. |
| IRR | Internal Rate of Return (r) | Discount rate setting present value of inflows equal to upfront cost. |
| WACC | Weighted Average Cost of Capital | Corporate hurdle rate; minimum required return demanded by debt and equity investors. |
How Financial Solvers Compute IRR (Newton-Raphson Iteration)
When a project extends beyond four years (n > 4), the polynomial expression for IRR cannot be solved using elementary algebra. By the Abel-Ruffini Theorem, general polynomial equations of degree 5 or higher possess no general algebraic solution in radicals.
Professional financial software (including Excel, Python NumPy, and our interactive engine) calculates IRR using numerical root-finding, predominantly the Newton-Raphson algorithm:
f(r) = -C0 + ∑t=1n [ CFt / (1 + r)t ] f'(r) = -∑t=1n [ t × CFt / (1 + r)t+1 ] The algorithm begins with an estimated rate r0 (typically 10%), iteratively tangent-projecting toward the horizontal root until the error tolerance |rk+1 − rk| drops below 10−7.
Capital Budgeting Decision Matrix (IRR vs. NPV vs. MIRR vs. Payback)
When evaluating corporate projects and acquisitions, relying on a single capital budgeting metric can lead to disastrous resource allocation. The table below summarizes the key trade-offs between standard evaluation criteria:
| Metric | Primary Question Answered | Reinvestment Assumption | Scale Sensitivity | Mutually Exclusive Reliability |
|---|---|---|---|---|
| IRR | What is the percentage rate of return per dollar invested? | At project's own IRR (Unrealistic) | Ignores total dollar scale | Poor (Can conflict with NPV) |
| NPV (Gold Standard) | How many total dollars of shareholder value are created? | At corporate WACC (Realistic) | Fully accounts for project scale | Excellent (Always choose highest NPV) |
| MIRR | What is the true rate of return under realistic reinvestment? | At corporate WACC (Realistic) | Partial | High |
| Payback Period | How quickly will the initial capital outlay be recouped? | None (Ignores cash flows beyond payback) | Ignores profitability | Poor (Liquidity measure only) |
| Profitability Index | What is the ratio of value created per dollar spent? | At corporate WACC | Standardizes per dollar | Best for Capital Rationing |
Modified IRR (MIRR) & The Reinvestment Rate Assumption
Standard IRR contains an inherent mathematical flaw called the reinvestment rate fallacy. When calculating IRR, the mathematics assume that all positive cash inflows generated throughout the life of the project can be immediately redeployed at the exact same IRR percentage.
If a tech startup or mineral lease generates a 70% IRR, standard IRR assumes that every dollar of dividend or operational cash flow received in Year 2 can also be reinvested elsewhere in the company at 70% annual return. In reality, mature companies typically reinvest excess capital at their standard cost of capital (e.g., 8% to 12%).
By compounding cash inflows forward to the terminal year at realistic WACC and discounting negative cash flows back to Year 0 at financing borrowing rates, MIRR eliminates rate distortions and prevents multiple real roots.
Non-Conventional Cash Flows & Descartes' Rule of Signs
Standard capital investments exhibit a conventional cash flow pattern: an initial negative outflow followed solely by positive inflows (− + + + ...). In this pattern, the sequence of cash flow signs changes exactly once, ensuring a single unique real IRR root.
However, when projects require substantial mid-life maintenance or major terminal reclamation costs—such as open-pit mining, nuclear decommissioning, or offshore oil platform removal—the cash flows reverse signs multiple times (− + + −):
The number of positive real roots of a polynomial cannot exceed the number of sign reversals between consecutive non-zero coefficients. If cash flows exhibit 2 sign changes (e.g. −$1,000 → +$2,300 → −$1,320), the equation can possess two distinct real internal rates of return (e.g. both 10% and 20% yield NPV = 0).
Diagnostic Rule: Whenever cash flows reverse signs more than once, never rely on standard IRR. Evaluate the NPV Profile curve or use MIRR.
Applications in Real Estate Deals, Private Equity & Corporate CapEx
Commercial Real Estate Syndication
Real estate sponsors model 5-to-7 year hold periods. Cash flows combine net operating income (NOI) distributions with a lump-sum terminal sale determined by dividing final year NOI by the exit capitalization rate (Cap Rate).
Private Equity Buyouts (LBOs)
PE general partners target 20% to 25% net levered IRRs. Fund performance benchmarks compare fund IRR against public market equivalents (PME) to justify carried interest compensation structures.
Corporate Capital Rationing
When CFOs face a constrained annual capital expenditure budget, projects are ranked by Profitability Index and IRR to build an optimal value-maximizing CapEx portfolio.
4-Tier Graded Worked Numerical Problems
Calculate IRR for an initial $10,000 machine generating $12,000 at the end of Year 1.
1. Formulate NPV equation: 0 = -10,000 + 12,000 / (1 + r)
2. Rearrange algebraically: 10,000 = 12,000 / (1 + r) → (1 + r) = 12,000 / 10,000 = 1.20
3. Solve for r: r = 1.20 - 1 = 0.20 = 20.00%
Conclusion: IRR is exactly 20.00% per year.
Initial investment is $50,000 with returns of $20,000 (Yr 1), $25,000 (Yr 2), and $22,000 (Yr 3). Hurdle rate WACC = 10%.
1. Set NPV = 0: 0 = -50,000 + 20,000/(1+r) + 25,000/(1+r)² + 22,000/(1+r)³
2. Test at r = 14%: NPV = -50,000 + 17,544 + 19,237 + 14,849 = +$1,630
3. Test at r = 18%: NPV = -50,000 + 16,949 + 17,955 + 13,390 = -$1,706
4. Linear interpolation / Newton convergence: r ≈ 14% + [ 1,630 / (1,630 + 1,706) ] × 4% = 15.68%
Conclusion: IRR = 15.68%. Because IRR > 10% WACC (NPV at 10% is +$5,372), accept the project.
A PE firm invests $2,000,000 equity. Annual dividends are $150k, $200k, $250k, $300k. In Year 5, company is sold for $4,500,000 net equity.
1. Cash flows: C₀ = -$2,000,000; CF₁ = $150k; CF₂ = $200k; CF₃ = $250k; CF₄ = $300k; CF₅ = $4,850,000 ($350k dividend + $4.5M sale)
2. Total nominal cash returned: $150k + $200k + $250k + $300k + $4,850k = $5,750,000 (2.88x MOIC)
3. Newton-Raphson polynomial convergence solves to: IRR = 24.35%
Conclusion: Net fund IRR = 24.35% annualized. Exceeds the standard 20% institutional hurdle rate.
A strip mine requires $1,000 upfront cost, produces $2,300 in Year 1, and requires $1,320 in Year 2 for environmental site restoration.
1. Cash flows: C₀ = -$1,000; CF₁ = +$2,300; CF₂ = -$1,320 (2 sign changes: − to + to −)
2. Polynomial equation: 0 = -1,000 + 2,300/(1+r) - 1,320/(1+r)²
3. Multiplying through by (1+r)²: -1000(1+r)² + 2300(1+r) - 1320 = 0 → Quadratic roots: r = 10% and r = 20%
Diagnostic Warning: Both 10% and 20% yield NPV = $0! Standard IRR fails. At WACC = 12%, true NPV is +$4.08, and MIRR is 14.89%.
Common Pitfalls & Diagnostic Decision Traps
1. The Scale Neglect Trap
A small $1,000 investment yielding $2,000 after 1 year has a 100% IRR ($1,000 net profit). A $10,000,000 project returning $15,000,000 after 1 year has a 50% IRR ($5,000,000 net profit). Blindly sorting by IRR favors the tiny $1,000 project. Always review total dollar NPV.
2. The Borrowing vs. Lending Direction Trap
When borrowing money, you receive cash upfront and pay back later (+$100k → -$120k). The mathematical root is still 20%, but a higher IRR means you are paying a more expensive interest rate to borrow. The standard decision rule (higher is better) only applies to investments, not financing.
3. Unequal Project Lives Trap
Comparing a 3-year project against a 10-year project using IRR ignores reinvestment risk at the end of Year 3. Use the Equivalent Annual Annuity (EAA) method or MIRR to align unequal operational time horizons.
Connected Financial Mathematics Solvers
Explore complementary corporate valuation, compounding, and interest analytics across the Basic Math Tools finance ecosystem:
Lead Developer & Founder of Basic Math Tools. Specializes in browser-native computational algorithms and applied mathematics.
Mathematics & curriculum specialists. Audited against standard algebraic and arithmetic principles.