🇺🇸 Internal Rate of Return (IRR) Calculator & Capital Budgeting Tool
The definitive 🇺🇸 U.S. corporate finance and capital budgeting IRR calculator. Engineered for private equity, real estate, and CFOs, featuring 7 CPA-grade modes: compute MIRR, plot NPV discount rate profiles, execute WACC-based hurdle rate decisions, stress-test 3-scenario discounted cash flows (DCF), rank multi-project capital allocations, generate PE MOIC × IRR sensitivity matrices, and calculate discounted payback periods with instant PDF export.
| Period | Cash Flow (USD) | Label (optional) |
|---|
| Period | Cash Flow (USD) |
|---|
| Period | Cash Flow (USD) |
|---|
| Period | Revenue / CF Inflow | Costs / CF Outflow |
|---|
📐 How to Calculate & Interpret Internal Rate of Return
Everything you need to understand Internal Rate of Return — the math behind it, all 7 calculation modes, real worked examples, when to use IRR vs. NPV, and 10 pro tips used by US investment professionals and CFOs.
📊 What Is IRR? (The Break-Even Discount Rate)
The Internal Rate of Return (IRR) is the discount rate at which the Net Present Value (NPV) of all cash flows from an investment equals exactly zero. In plain English: it is the annualized percentage return an investment is expected to generate. If the IRR of a project exceeds your required rate of return (WACC or hurdle rate), the investment creates value — it’s worth doing. If it falls below, the investment destroys value.
🧮 The IRR vs. NPV Mathematical Formula
IRR is defined as the rate r that satisfies the NPV equation set to zero. Unlike NPV — where you plug in a known discount rate — IRR requires solving for the unknown rate. There is no closed-form algebraic solution for most cash flow patterns, so the answer must be found iteratively.
A manufacturing company is evaluating a $100,000 equipment purchase. The equipment is expected to generate the following net cash flows over 5 years. The company’s WACC is 10%. Should they invest?
| Period | Cash Flow | Discount Factor | PV of CF | Cumulative PV |
|---|---|---|---|---|
| Year 0 (Now) | −$100,000 | 1.0000 | −$100,000 | −$100,000 |
| Year 1 | +$25,000 | 0.9091 | +$22,727 | −$77,273 |
| Year 2 | +$30,000 | 0.8264 | +$24,793 | −$52,480 |
| Year 3 | +$35,000 | 0.7513 | +$26,296 | −$26,184 |
| Year 4 | +$40,000 | 0.6830 | +$27,321 | +$1,137 |
| Year 5 | +$50,000 | 0.6209 | +$31,046 | +$32,183 |
| NPV | +$32,183 |
This calculator has 7 specialized tabs, each solving a different investment analysis problem. Here’s exactly what to use and when:
Select the tab that matches your goal. For most users, start with Core IRR / NPV. Use MIRR if you want a more conservative, realistic return figure. Use Hurdle Rate if you already have an IRR and need a GO/NO-GO decision.
Period 0 is your initial investment — always enter it as a negative number (e.g., −$100,000). This represents cash leaving your hands. Future inflows are positive. Additional outflows in later periods are also negative.
Enter your WACC (Weighted Average Cost of Capital) or required return rate in the Discount Rate field. This is used to calculate NPV. Common US benchmarks: 8–12% for mature companies, 15–25% for startups, 10% as a general baseline.
Click the green Calculate button. Results appear instantly — IRR, NPV, payback, MOIC, and the full DCF table. Use PDF Report to export a branded document, or WhatsApp to share results with your team.
Don’t stop at base case. Run the Scenario Analysis tab to see what happens if revenue drops 20% or costs increase 15%. A project that only works under optimistic assumptions carries hidden risk.
Run the NPV Profile tab to see the full rate-sensitivity picture. If your NPV turns negative at 12% but your WACC is 10%, there’s only a 2% margin of safety — that’s thin. A healthy project should stay positive well above the WACC.
Download the PDF Report for your CFO or investment committee. The PDF includes all inputs, KPI metrics, the full cash flow table, and a branded header with the date. All processing is browser-side — your data never leaves your device.
If you’re choosing between options, use Multi-Project Compare. Enter cash flows for up to 3 projects. The tool ranks them by IRR, NPV, and payback. Remember: for mutually exclusive projects, always follow the NPV rank, not the IRR rank.
Every metric in this calculator tells you something different. The most common mistake investors make is using IRR alone to make decisions. Here’s a clear guide to when each metric matters:
| Metric | What It Measures | Best Used For | Key Limitation | This Calculator’s Tab |
|---|---|---|---|---|
| IRR | % return at which NPV = 0 | Ranking investment efficiency; single project GO/NO-GO vs WACC | Assumes reinvestment at IRR (often too optimistic); multiple solutions possible with non-conventional CFs | Core IRR / NPV |
| NPV | Total dollar value added in today’s dollars | Mutually exclusive projects (always pick highest NPV); absolute value measurement | Requires knowing the correct discount rate; doesn’t show return % | Core IRR / NPV |
| MIRR | Modified % return with realistic reinvestment assumption | When standard IRR seems suspiciously high; businesses with known WACC | Less intuitive; two rates required (finance + reinvest) | MIRR Tab |
| Payback Period | How many years to recover initial investment | Liquidity-focused decisions; early-stage projects; risk screening | Ignores time value of money and cash flows after payback | Core IRR / NPV |
| Discounted Payback | Payback using PV of cash flows | Conservative version of payback; includes TVM | Still ignores post-payback value; always longer than simple payback | Core IRR / NPV |
| MOIC (Equity Multiple) | Total return as a multiple (e.g., 2.5x) | PE, VC, and real estate professionals; gross return before time weighting | Ignores time — a 2x in 2 years vs. 2x in 10 years are very different | MOIC Matrix |
| Profitability Index | NPV ÷ Initial Investment + 1 | Capital rationing — rank projects when budget is limited | Can conflict with NPV for mutually exclusive projects | Core IRR / NPV |
Knowing what a “good” IRR looks like depends entirely on your sector, risk profile, and cost of capital. These are real-world US benchmarks used by investment committees and CFOs in 2025:
| Asset Class / Sector | Typical IRR Target | Typical WACC / Hurdle | Margin of Safety | Decision Signal |
|---|---|---|---|---|
| 🏭 Manufacturing / Equipment | 15–25% | 8–12% | 7–13 pp | Strong GO |
| 🏢 Commercial Real Estate | 12–18% | 7–9% | 5–9 pp | GO |
| 🏗️ Value-Add Real Estate | 18–25% | 8–10% | 10–15 pp | Strong GO |
| 🏦 Private Equity (Buyout) | 20–25% | 12–15% | 7–10 pp | GO |
| 🚀 Venture Capital (Seed/Series A) | 30–50%+ | 20–30% | 10–20 pp | High Risk |
| ⚡ Renewable Energy / Infrastructure | 8–14% | 6–9% | 2–5 pp | GO |
| 💊 Pharma / Biotech R&D | 20–40% | 12–18% | Variable | Risk-Dependent |
| 🖥️ Software / SaaS (B2B) | 25–40% | 12–20% | 10–20 pp | Strong GO |
| 🛢️ Oil & Gas Exploration | 15–30% | 10–15% | 5–15 pp | Risk-Dependent |
| 🏬 Retail Expansion / Store Openings | 20–30% | 10–14% | 10–16 pp | GO |
If Project A has IRR 25% (NPV $50K) and Project B has IRR 20% (NPV $120K), choosing A because of higher IRR is wrong. Always choose the higher NPV for mutually exclusive projects — it creates more actual value.
Standard IRR assumes you can reinvest all cash flows at the IRR itself — often 20%, 25%, or higher. This is unrealistic for most businesses. Use MIRR with your actual WACC as the reinvest rate for a more accurate picture.
Any project with non-conventional cash flows (negative after initially positive — e.g., a mine with reclamation costs) can have multiple IRRs. If the calculator returns “No Solution,” switch to NPV analysis.
A 30% IRR on $10,000 creates $3,000 of value. A 20% IRR on $1,000,000 creates $200,000. IRR measures efficiency — NPV measures wealth creation. For capital allocation decisions, prioritize total NPV, not % return.
For real estate, PE deals, or long-term equipment, the sale price or salvage value at the end is often the largest cash flow. Always include the exit value as a positive cash flow in the final period.
If cash flows are in real (inflation-adjusted) dollars, use a real discount rate. If cash flows are nominal, use a nominal rate. Mixing the two produces systematically wrong NPV results.
Every projection is wrong. The question is how wrong. Use the Scenario Analysis tab to test what happens with 20% lower revenue or 15% higher costs. A project that fails the worst-case scenario needs more contingency planning before approval.
📌 Quick Reference — IRR Decision Framework
- Enter Period 0 as negative
- Add all future cash flows
- Set your WACC as discount rate
- Choose Annual / Quarterly / Monthly
- Click Calculate
- IRR > WACC → Positive NPV → GO
- IRR < WACC → Negative NPV → NO-GO
- Check NPV Profile margin of safety
- Compare MOIC for holding period context
- Run Scenario Analysis
- Run MIRR with realistic reinvest rate
- Test worst-case scenario
- Apply risk-adjusted hurdle rate
- Use MOIC Matrix for PE/RE deals
- Export PDF for decision record
Use all 7 calculation modes above — Core IRR, MIRR, NPV Profile, Hurdle Rate Decision, Scenario Analysis, Multi-Project Compare, and MOIC Matrix. 100% free, browser-based, no login.
🇺🇸 5 Real-World U.S. Investment & IRR Scenarios
These are five real-world US investment scenarios with actual industry-benchmark cash flows, WACC rates, and decision outcomes. Each example mirrors exactly how this calculator operates — enter the same numbers above to reproduce every result yourself.
Scenario: A Tier 2 auto parts manufacturer in Ohio is evaluating a $180,000 investment in two CNC machining centers. The equipment reduces labor costs by $38,000/year and increases production capacity, generating an estimated $22,000–$35,000 in additional annual net revenue. The machines have a 5-year usable life with a $15,000 salvage value at Year 5. Company WACC is 10%. Hurdle rate: 12% (accounts for execution risk).
How to enter this in the calculator: Open the Core IRR / NPV tab. Set Period 0 = −$180,000. Enter annual net cash flows for Years 1–5. Set Discount Rate = 10%. Click Calculate.
| Period | Cash Flow | Disc. Factor | PV of CF | Cumulative PV |
|---|---|---|---|---|
| Year 0 (Now) | −$180,000 | 1.0000 | −$180,000 | −$180,000 |
| Year 1 | +$48,000 | 0.9091 | +$43,636 | −$136,364 |
| Year 2 | +$55,000 | 0.8264 | +$45,455 | −$90,909 |
| Year 3 | +$60,000 | 0.7513 | +$45,079 | −$45,830 |
| Year 4 | +$63,000 | 0.6830 | +$43,030 | −$2,800 |
| Year 5 + Salvage | +$80,000 | 0.6209 | +$49,674 | +$46,874 |
| NPV @ 10% | +$46,874 |
📋 Try it yourself: Open Core IRR / NPV tab → Period 0: −180000 → Years 1–5: 48000, 55000, 60000, 63000, 80000 → Discount Rate: 10 → Calculate
↑ Open CalculatorScenario: A Houston logistics warehouse operator installs a 200kW rooftop solar array at a total system cost of $320,000. The 30% federal Investment Tax Credit (ITC) under the Inflation Reduction Act reduces the net outlay to $224,000 in Year 0. Annual electricity savings average $38,000/year (growing 2% annually as grid rates rise). Annual O&M is $3,500. A battery storage upgrade costing $28,000 is required at Year 7. WACC: 8%.
How to enter this: Core IRR / NPV tab. Period 0 = −$224,000 (net of ITC). Add 10 annual periods. Year 7 includes both the savings AND the −$28,000 battery cost as net CF. Discount Rate = 8.
| Year | Energy Savings | O&M Cost | Battery CapEx | Net Cash Flow |
|---|---|---|---|---|
| 0 (Install) | — | — | −$224,000 (net ITC) | −$224,000 |
| Year 1 | +$34,500 | −$3,500 | — | +$31,000 |
| Year 2 | +$35,190 | −$3,500 | — | +$31,690 |
| Year 3 | +$35,894 | −$3,500 | — | +$32,394 |
| Year 4 | +$36,612 | −$3,500 | — | +$33,112 |
| Year 5 | +$37,344 | −$3,500 | — | +$33,844 |
| Year 6 | +$38,091 | −$3,500 | — | +$34,591 |
| Year 7 | +$38,853 | −$3,500 | −$28,000 | +$7,353 |
| Year 8 | +$39,630 | −$3,500 | — | +$36,130 |
| Year 9 | +$40,423 | −$3,500 | — | +$36,923 |
| Year 10 | +$41,231 | −$3,500 | — | +$37,731 |
| NPV @ 8% | +$58,340 | |||
📋 Try it: Core IRR tab → Period 0: −224000 → Years 1–10: 31000, 31690, 32394, 33112, 33844, 34591, 7353, 36130, 36923, 37731 → Rate: 8 → Calculate
↑ Open CalculatorScenario: A real estate investor acquires a 30,000 sq ft industrial warehouse in DFW at $2.1M with $500,000 equity (70% LTV financing). The property is 65% leased at acquisition. After a $120,000 renovation in Year 1 (included in the initial cash flow), the investor stabilizes occupancy to 95% by Year 2, generating growing net operating income. After a 5-year hold, the property is sold at a 5.5% cap rate on Year 5 NOI, producing net equity proceeds of $920,000 after debt payoff and closing costs.
Hurdle Rate: 15% (value-add RE typically requires 15–20% IRR to compensate for execution risk per industry benchmarks).
| Period | NOI (Levered) | Debt Service | Net Eq. CF |
|---|---|---|---|
| Year 0 | — | −$620,000 (equity + reno) | −$620,000 |
| Year 1 | +$112,000 | −$94,000 | +$18,000 |
| Year 2 | +$148,000 | −$96,000 | +$52,000 |
| Year 3 | +$156,000 | −$98,000 | +$58,000 |
| Year 4 | +$164,000 | −$100,000 | +$64,000 |
| Year 5 (inc. Sale) | +$1,057,000 | −$105,000 | +$988,000 |
| NPV @ 9% | +$243,800 | ||
📋 Try it: Core IRR tab → Period 0: −620000 → Years 1–5: 18000, 52000, 58000, 64000, 988000 → Discount Rate: 9 → Also run MOIC Matrix tab with $620K investment, $1,388K exit, 5 years
↑ Open CalculatorScenario: A first-time franchisee is evaluating opening a single fast-casual restaurant unit in Phoenix, AZ. Total build-out and franchise fee investment: $425,000. Year 1 is a ramp-up year (lower foot traffic, staff training). Years 2–7 assume stabilized unit economics based on the franchisor’s disclosed FDD Item 19 average-unit-volume data. The unit is sold or transferred at a 2.5x EBITDA multiple after Year 7. The franchisee uses a 14% WACC to reflect the high operational risk of a first-time food service operator.
Note: Franchise IRRs are highly sensitive to AUV (Average Unit Volume), food/labor cost ratios, and local competition. The Scenario Analysis tab is critical for this investment type.
| Year | Revenue | Operating Costs (75%) | Net CF |
|---|---|---|---|
| Year 0 | — | −$425,000 (invest) | −$425,000 |
| Year 1 (Ramp) | $560,000 | −$532,000 | +$28,000 |
| Year 2 | $720,000 | −$658,000 | +$62,000 |
| Year 3 | $800,000 | −$730,000 | +$70,000 |
| Year 4 | $820,000 | −$745,000 | +$75,000 |
| Year 5 | $835,000 | −$760,000 | +$75,000 |
| Year 6 | $850,000 | −$775,000 | +$75,000 |
| Year 7 (inc. 2.5x EBITDA Sale) | $862,000 + $190,000 sale | −$777,000 | +$265,000 |
| NPV @ 14% | +$18,400 | ||
📋 Try it: Core IRR tab → Period 0: −425000 → Years 1–7: 28000, 62000, 70000, 75000, 75000, 75000, 265000 → Rate: 14 → Also run MIRR tab with finance rate 8%, reinvest rate 10%
↑ Open CalculatorScenario: A lower-middle-market PE firm acquires a B2B SaaS company in Austin, TX at an 8.0x EBITDA multiple ($64M enterprise value). Financing: 50% debt ($32M at 7% interest), 50% equity ($32M, with the sponsor’s check being $4M as part of a management rollover deal). The portfolio company grows EBITDA from $8M to $14.5M over 5 years through organic growth and one bolt-on acquisition. The firm exits at a 10x EBITDA multiple in Year 5. This example uses the MOIC / IRR Matrix and Multi-Project Compare tabs.
Equity cash flows shown below are for the $4M sponsor check only (representing a co-invest opportunity shown to LPs).
| Metric | Entry (Yr 0) | Exit (Yr 5) |
|---|---|---|
| EBITDA | $8.0M | $14.5M |
| EV Multiple | 8.0x | 10.0x |
| Enterprise Value | $64M | $145M |
| Net Debt | $32M | $19M (paid down) |
| Equity Value | $32M | $126M |
| Sponsor Equity % | 12.5% | 12.5% |
| Sponsor Equity Value | $4.0M invested | $15.75M returned |
| Gross MOIC | 3.94x |
📋 Try it: Core IRR tab → Period 0: −4000000 → Years 1–5: 120000, 200000, 280000, 360000, 10640000 → Rate: 20 → Also try MOIC Matrix: Investment $4M, Exit $15.75M, 5 years, Hurdle 20%
↑ Open Calculator| Example | Investment | IRR | WACC / Hurdle | NPV | MOIC | Payback | Decision |
|---|---|---|---|---|---|---|---|
| 🏭 CNC Machines (OH) | $180,000 | 22.1% | 10% / 12% | +$46,874 | 1.84x | 3.3 yrs | GO ✅ |
| ☀️ Solar 200kW (TX) | $224,000 (net ITC) | 18.3% | 8% / 8% | +$58,340 | 1.52x | 5.6 yrs | GO ✅ |
| 🏢 Warehouse RE (DFW) | $620,000 equity | 21.4% | 9% / 15% | +$243,800 | 2.24x | 5.0 yrs | GO ✅ |
| 🍔 QSR Franchise (AZ) | $425,000 | 16.2% | 14% / 15% | +$18,400 | 1.55x | 5.1 yrs | BORDERLINE ⚠️ |
| 🏦 PE LBO SaaS (TX) | $4,000,000 | 28.7% | 20% / 20% | +$1,820,000 | 3.94x | 4.8 yrs | Strong GO ✅ |
Every example in this section uses the exact same inputs the calculator accepts. Enter the Period 0 and annual cash flows, set your discount rate, and click Calculate to reproduce every result. Use the Scenario Analysis and MIRR tabs to stress-test your own investment.
💡 5 CPA-Grade Tips for Capital Allocation & IRR Analysis
These are five professional-grade techniques used by US CFOs, PE analysts, and real estate investors to extract maximum insight from every IRR analysis. Each tip maps directly to a specific tab or feature in this calculator — with worked examples, Do/Don’t guidance, and exact steps to follow.
Standard IRR contains a hidden flaw that most investors never check: it assumes every dollar of interim cash flow gets reinvested at the IRR itself. If your project shows an IRR of 25%, the math assumes your Year 1, 2, and 3 cash flows all go into another 25%-returning investment — which is almost never true for a real business. MIRR fixes this by using your actual WACC as the reinvestment rate, producing a more honest return figure.
| Standard IRR | MIRR (@ 10% reinvest) | Gap | Signal |
|---|---|---|---|
| 12% | 11.4% | −0.6 pp | ✅ Reliable |
| 18% | 15.8% | −2.2 pp | ✅ Acceptable |
| 24% | 19.1% | −4.9 pp | ⚠️ Investigate |
| 30% | 21.6% | −8.4 pp | ❌ Inflated |
| 40% | 25.8% | −14.2 pp | ❌ Misleading |
- 1Run Core IRR / NPV first to get the standard IRR result.
- 2Click the MIRR tab. Enter the same cash flows (or copy them).
- 3Set Finance Rate = your borrowing cost (e.g., 7–9% for most US businesses in 2025).
- 4Set Reinvestment Rate = your WACC or the rate you can realistically earn on reinvested cash (typically 8–12%).
- 5Click Calculate MIRR. Compare MIRR vs Standard IRR in the results panel.
- 6If the gap is >4 pp, report MIRR as your primary return metric — not standard IRR.
- Always run MIRR alongside standard IRR
- Set reinvestment rate = WACC (not IRR)
- Use MIRR when standard IRR exceeds 20%
- Report both figures to decision-makers
- Use MIRR for food/retail businesses where cash is spent, not reinvested
- Relying solely on standard IRR for high-return projections
- Setting reinvestment rate = IRR (that defeats the purpose)
- Ignoring the gap between MIRR and IRR
- Using standard IRR when cash flows are consumed (restaurants, retail)
- Presenting IRR without mentioning the reinvestment assumption
Most investors only look at one number: “Is IRR above WACC?” But this is a binary pass/fail — it tells you nothing about how far above the threshold you sit. The NPV Profile chart plots NPV at every discount rate from 0% to 50%, and the point where the line crosses zero is the IRR. The gap between your current WACC and that crossing point is your margin of safety — how much interest rates, cost of capital, or project assumptions can deteriorate before the investment turns negative.
- 1Go to the NPV Profile tab. Enter your cash flows.
- 2Set Min Rate = 0%, Max Rate = 40% (or higher for high-return projects).
- 3Click Generate Profile. The chart shows the NPV curve across all rates.
- 4Find the zero-crossing point — that’s your IRR. Note your WACC on the chart.
- 5Margin of Safety = IRR − WACC. Look for at least 5 percentage points as a minimum.
- 6Check if the curve is steep or flat near your WACC. A steep curve = high rate sensitivity = more risk.
The single most common professional mistake in investment analysis is presenting only the base-case projection to a board or investment committee. In reality, every financial model is built on assumptions — revenue growth rates, cost inflation, occupancy rates, sales volumes — and each one has a range of outcomes. The Scenario Analysis tab forces you to model Best, Base, and Worst outcomes in seconds. The shape of the scenario range tells you more about a project’s risk than the base-case IRR ever could.
| Scenario | Revenue Adj. | Cost Adj. | IRR Result | Decision |
|---|---|---|---|---|
| 🟢 Best Case | +15% uplift | −10% reduction | 26.8% | GO |
| 🔵 Base Case | — | — | 22.1% | GO |
| 🔴 Worst Case | −20% drop | +15% increase | 14.2% | BORDERLINE |
| Scenario Range | Worst Case vs Hurdle | Signal |
|---|---|---|
| All 3 scenarios pass hurdle | Worst > Hurdle | ✅ Robust — Invest |
| Base + Best pass, Worst fails | Worst near hurdle | ⚠️ Conditional — add contingency |
| Only Best case passes hurdle | Base & Worst fail | ❌ Reject — too speculative |
| All 3 scenarios fail hurdle | All below hurdle | ❌ Clear No-Go |
| Industry | Best Rev | Best Cost | Worst Rev | Worst Cost |
|---|---|---|---|---|
| Manufacturing / CapEx | +10% | −8% | −15% | +12% |
| Commercial Real Estate | +15% | −5% | −20% | +10% |
| Solar / Renewable Energy | +8% | −5% | −12% | +15% |
| Restaurant / Franchise | +15% | −8% | −25% | +20% |
| SaaS / Tech | +25% | −10% | −30% | +15% |
| PE / LBO | +20% | −10% | −20% | +15% |
- 1Go to Scenario Analysis tab. Enter Revenue (inflow) and Cost (outflow) for each year separately.
- 2Set Best Case Revenue Uplift and Cost Reduction percentages using the table above as a guide.
- 3Set Worst Case Revenue Drop and Cost Increase using industry benchmarks.
- 4Click Run Scenarios. Review the IRR and NPV for all three cases plus the bar chart comparison.
- 5If the worst-case IRR is below your hurdle rate, require a contingency plan or additional sensitivity analysis before approval.
- Always present all 3 scenarios to boards & investors
- Label the key assumption driving worst case (e.g., occupancy)
- Build contingency into budget if worst case is borderline
- Use industry-specific percentage ranges (table above)
- Export PDF after running scenarios — it includes the chart
- Only base case presented — scenarios never tested
- Best and worst case are symmetric (±5%) — understates real risk
- Worst case still assumes revenue growth (not a real stress)
- Decision made on IRR alone without scenario context
- No contingency budget when worst case fails the hurdle
Private equity and real estate investors think in two currencies simultaneously: IRR (the annualized rate) and MOIC / Equity Multiple (the total return multiple). IRR is the LP preference metric — it determines carried interest and fund benchmarks. MOIC is the gut-check — it tells you how many dollars you got back per dollar invested. The MOIC / IRR Matrix tab generates a full color-coded matrix showing the implied IRR for every combination of equity multiple (1.0x to 5.0x) and holding period (1 to 10 years), with your specific deal highlighted in the matrix.
MOIC ↓
Green = above 15% hurdle. Red = below hurdle. ★ = Example deal (2.5x MOIC, 5-year hold, 20.1% IRR).
- 1Deal Screening: Before building a full model, enter your expected exit multiple and holding period into the matrix. If the implied IRR is already below your hurdle rate, don’t spend time on the full model.
- 2Exit Timing Optimization: Use the matrix to determine the optimal hold period. Example: a 3.0x MOIC needs to close in Year 5 (24.6% IRR) vs Year 7 (17.1% IRR) to stay firmly above a 20% hurdle.
- 3LP Communication: When presenting to limited partners, the matrix instantly shows which exit multiples at which time horizons meet the fund’s target return — making the investment thesis visually intuitive.
- 1Go to MOIC / IRR Matrix tab.
- 2Enter Your Investment (total equity check, e.g., $1,000,000).
- 3Enter Hurdle Rate (your target IRR — the matrix colors cells green/red relative to this).
- 4Enter Exit Value and Holding Period for your specific deal — it gets highlighted in the matrix.
- 5Click Generate Matrix. The full MOIC × holding period matrix renders instantly with your deal bolded.
- 6Export as PDF to include in your investment memo or LP presentation.
Capital allocation is the highest-stakes decision a CFO makes. When multiple projects compete for the same budget, the instinct is to fund whichever shows the highest IRR — but this leads to systematic underperformance. IRR measures efficiency (return per dollar invested) while NPV measures absolute value creation (total dollars added to shareholder wealth). For mutually exclusive or budget-constrained decisions, NPV always wins. The Multi-Project Compare tab ranks all three projects by both metrics side-by-side so the conflict is immediately visible.
| Project | Investment | IRR | IRR Rank | NPV @ 10% | NPV Rank | MOIC | Correct Choice |
|---|---|---|---|---|---|---|---|
| 🏭 Project A (Small CapEx) | $50,000 | 31.4% | 1st | +$28,000 | 3rd | 1.96x | — |
| ☀️ Project B (Solar Install) | $220,000 | 18.3% | 2nd | +$58,300 | 2nd | 1.52x | — |
| 🏢 Project C (Warehouse RE) | $620,000 | 21.4% | 2nd | +$243,800 | 1st | 2.24x | — |
| ❌ If you chose by IRR: Project A — gains only $28,000 in value. ✅ If you chose by NPV: Project C — gains $243,800 in value. NPV wins by $215,800. | |||||||
| Situation | Use IRR Rank | Use NPV Rank |
|---|---|---|
| Mutually exclusive projects (pick one) | ❌ No | ✅ Yes |
| Capital rationing (limited budget) | ⚠️ Partial | ✅ Yes |
| Independent projects (fund all that pass) | ✅ Yes | ✅ Yes |
| Comparing project efficiency / return % | ✅ Yes | ❌ No |
| Different investment sizes | ❌ No | ✅ Yes |
| LP/PE fund performance reporting | ✅ Yes | ⚠️ Secondary |
- 1Go to Multi-Project Compare tab. Three project blocks appear side-by-side.
- 2Enter Period 0 (negative) and all future cash flows for each project separately. Add periods as needed.
- 3Set the Discount Rate (your WACC) at the top — it applies to all three projects for a fair NPV comparison.
- 4Click Compare Projects. The results table ranks by IRR and NPV separately with 1st Best / Last badges.
- 5If IRR rank ≠ NPV rank, always follow the NPV rank for mutually exclusive projects.
- 6Export as PDF Report for the capital allocation committee — includes the full comparison table and bar chart.
- Always compute NPV before making the final project selection
- Use Multi-Project Compare for any budget involving 2+ options
- Document when IRR and NPV rankings disagree — explain why
- Use Profitability Index (NPV/Investment) for capital rationing
- Export the full PDF for the capital committee record
- Choosing highest IRR when projects have different investment sizes
- Comparing IRRs across projects with different durations (5-yr vs 10-yr)
- Approving a project without seeing the NPV alongside the IRR
- Using IRR as the sole metric in board presentations
- Neglecting to run Scenario Analysis on the “winner” before approval
Every tip in this section uses a specific tab in the calculator above. Run MIRR alongside IRR, generate the NPV Profile for margin of safety, stress-test with scenarios, map your exit with the MOIC Matrix, and rank projects by NPV — all in one free tool.
📊 Internal Rate of Return (IRR) FAQs
Every question you have about Internal Rate of Return, MIRR, NPV, MOIC, hurdle rates, and how to use this calculator — answered in plain US English with real examples.
IRR is the discount rate that makes the NPV (Net Present Value) of all project cash flows equal exactly zero. In everyday terms, it’s the annualized percentage return you earn on every dollar you invest, accounting for the time value of money.
Think of it like a compound interest rate working in reverse. Instead of asking “what will my investment grow to?”, IRR asks: “what annual growth rate would have to be true for this investment to be worth exactly what I paid for it — no more, no less?”
The decision rule is straightforward: if IRR > your cost of capital (WACC or hurdle rate), approve the investment. It generates more return than it costs to finance. If IRR < WACC, the investment destroys value and should be rejected.
There is no single universal benchmark — a “good” IRR depends entirely on the asset class, risk level, and your cost of capital. The right question is: does the IRR exceed my WACC by a sufficient margin to compensate for risk?
| Asset Class / Strategy | Typical Target IRR (US, 2026) | Risk Level |
|---|---|---|
| S&P 500 Equities (historical) | ~10% | Medium |
| Corporate Bonds / Fixed Income | 4–7% | Low–Medium |
| Core Real Estate | 8–10% | Low–Medium |
| Value-Add Real Estate | 12–18% | Medium |
| Opportunistic Real Estate | 18–25% | Medium–High |
| Private Equity Buyout | 15–20% | High |
| Growth Equity | 20–30% | High |
| Venture Capital | 30%+ | Very High |
| Small Business CapEx | 15–25% | Medium–High |
IRR and NPV measure the same investment from two different angles:
| Metric | What it Measures | Output | Best Used When… |
|---|---|---|---|
| IRR | Efficiency — return rate per dollar | Percentage (%) | Comparing projects of similar size |
| NPV | Magnitude — total dollar value added | Dollar amount ($) | Mutually exclusive project selection |
For a single project, both give the same accept/reject answer — if IRR > WACC, then NPV > $0, and vice versa. For mutually exclusive projects (you can only choose one), always use NPV.
A negative IRR means your total undiscounted cash inflows are less than your initial investment — you lose money in absolute terms, before even accounting for the time value of money.
This is fundamentally different from a low positive IRR (e.g., 3%), which still returns your principal plus a small gain. A negative IRR means you never fully recover what you invested.
Note: Some projects have negative IRR not because they are poor investments, but because of incorrectly entered cash flows — double-check that Period 0 is negative (initial outlay) and that future inflows are entered as positive numbers.
ROI (Return on Investment) = Net Profit ÷ Cost of Investment × 100. It is a simple, time-agnostic ratio. It doesn’t care whether you made $50,000 in Year 1 or Year 10 — both contribute equally to ROI.
IRR accounts for when cash flows occur. A dollar received today is worth more than a dollar received in 5 years. IRR captures this by discounting every future cash flow back to present value before calculating the return rate.
| Scenario | ROI | IRR | Which is Better? |
|---|---|---|---|
| Double money in 2 years | 100% | 41.4%/yr | Use IRR — same ROI, very different annual returns |
| Double money in 10 years | 100% | 7.2%/yr |
A hurdle rate — also called WACC (Weighted Average Cost of Capital) or minimum required return — is the minimum IRR a project must achieve to justify the investment. It represents the opportunity cost of your capital.
The standard IRR decision rule: IRR > Hurdle Rate = GO ✅ | IRR < Hurdle Rate = NO-GO ❌
The Federal Reserve Bank of St. Louis (FRED at fred.stlouisfed.org) publishes current benchmark rates — the Federal Funds Rate and Prime Rate — which serve as the foundation for US hurdle rate calculations.
IRR is defined as the rate r that satisfies:
There is no closed-form algebraic solution for r when there are more than two cash flow periods. The calculator solves it numerically using the Newton-Raphson iteration method — the same algorithm used by Microsoft Excel’s IRR() function:
- Start with an initial guess (r = 10%)
- Compute NPV and its derivative (dNPV/dr)
- Update: r_new = r_old − NPV / dNPV
- Repeat until |NPV| < 10⁻¹⁰ (converges) or 1,000 iterations reached
MIRR (Modified Internal Rate of Return) fixes the biggest flaw in standard IRR: the reinvestment assumption. Standard IRR assumes all positive cash flows are reinvested at the IRR itself — often an optimistically high rate that isn’t realistic.
MIRR uses two separate rates:
- Finance Rate — your cost of borrowing (used to PV all negative cash flows back to Period 0)
- Reinvestment Rate — your actual WACC (used to FV all positive cash flows to the final period)
The Multiple IRR Problem occurs when cash flows are “non-conventional” — meaning they change sign more than once beyond Period 0 (e.g., positive in Year 2, negative in Year 3, positive again in Year 5). Mathematically, the IRR equation can have as many solutions as sign changes (Descartes’ Rule of Signs).
When this happens, the calculator’s Newton-Raphson solver tries 5 different starting guesses. If it cannot converge to a reliable single solution, it reports “No Solution.”
Non-conventional cash flows are common in mining projects (large reclamation costs), real estate with major renovations, and manufacturing with scheduled equipment replacements.
Profitability Index (PI) = (NPV + Initial Investment) ÷ Initial Investment, or equivalently: PI = 1 + (NPV ÷ |Initial Investment|)
| PI Value | Decision | Meaning |
|---|---|---|
| PI < 1.0 | Reject | Returns less than $1.00 per dollar invested (NPV negative) |
| PI = 1.0 | Break-even | Returns exactly $1.00 per dollar (NPV = $0) |
| PI > 1.0 | Accept | Returns more than $1.00 per dollar (NPV positive) |
This calculator has 7 specialized tabs. Here’s the recommended workflow:
- Core IRR / NPV tab: Enter Period 0 as a negative number (your upfront investment). Add future cash flows (Periods 1–15). Set your WACC as the discount rate. Click Calculate.
- MIRR tab: Enter finance rate (borrowing cost) and reinvestment rate (WACC). Get a more realistic return estimate than standard IRR.
- NPV Profile tab: Generate a chart showing NPV at every discount rate from 0% to 50%. Where NPV = $0 is your IRR visually.
- Hurdle Rate Decision tab: Input your project IRR, WACC, NPV, and risk level. Get an instant GO / BORDERLINE / NO-GO investment decision.
- Scenario Analysis tab: Model Best, Base, and Worst Case outcomes by adjusting revenue and cost percentages.
- Multi-Project Compare tab: Enter up to 3 projects side-by-side and rank them by IRR, NPV, MOIC, and payback.
- MOIC IRR Matrix tab: See implied IRR for any combination of equity multiple and holding period — a private equity standard tool.
Yes. In the Core IRR tab, use the Cash Flow Frequency selector to choose Annual, Quarterly, or Monthly. The calculator automatically:
- Converts your annualized discount rate to the correct sub-period rate (÷4 for quarterly, ÷12 for monthly)
- Annualizes the resulting period IRR back to an annual figure using compounding: Annual IRR = (1 + Period IRR)^frequency − 1
100% private. Every calculation runs entirely in your browser using JavaScript. No cash flow inputs, results, scenarios, or personal data are ever transmitted to any server, stored in any database, or shared with any third party — including USFinanceCalculators.com itself.
Revenue on this page is generated solely through Google AdSense display advertising, which is served by Google’s servers independently of the calculator’s computation engine.
The calculator uses the same Newton-Raphson algorithm as Microsoft Excel’s IRR() and MIRR() functions. For standard investment cash flows (up to 15 periods, single sign change), results are accurate to at least 6 decimal places.
| Feature | Excel IRR() | This Calculator |
|---|---|---|
| Algorithm | Newton-Raphson | Newton-Raphson (same) |
| Max Iterations | 20 (default) | 1,000 (more robust) |
| Precision | IEEE 754 float (~15 digits) | Big.js (~20 digits) |
| Multiple IRR Handling | Returns first solution found | Flags issue, tries 5 guesses |
Enter your Base Case revenue and cost cash flows for each period. Then set percentage adjustments:
- Best Case: Revenue uplift (e.g., +15%) and cost reduction (e.g., -10%)
- Worst Case: Revenue drop (e.g., -20%) and cost increase (e.g., +15%)
The calculator applies these multipliers to generate three complete cash flow sets, computes a separate IRR and NPV for each, and displays them in a side-by-side comparison table with a bar chart.
MOIC (also called equity multiple or cash-on-cash return) = Total Cash Returned ÷ Total Cash Invested. A 2.5x MOIC means you received $2.50 for every $1.00 invested.
MOIC and IRR together tell the complete return story:
| MOIC | Holding Period | Implied IRR | Assessment |
|---|---|---|---|
| 2.0x | 3 years | 26.0% | Excellent |
| 2.0x | 7 years | 10.4% | Adequate |
| 3.0x | 5 years | 24.6% | Strong |
| 3.0x | 10 years | 11.6% | Moderate |
The NPV Profile plots NPV (Y-axis) vs. discount rate (X-axis) across a range you define (e.g., 0% to 50%). The resulting curve visually answers three critical questions:
- Where does the line cross zero? That’s your IRR — the break-even discount rate.
- How steeply does it slope? A steep slope = high duration sensitivity (long-payback projects). A gentle slope = resilient to WACC changes.
- What is NPV at your specific WACC? This is the real acceptance criterion — the NPV at your cost of capital, not just the IRR.
WACC = (Cost of Equity × Equity Weight) + (Cost of Debt × (1 − Tax Rate) × Debt Weight)
Typical US WACC ranges for 2025–2026:
- Large-cap S&P 500 companies: 7–10%
- Mid-market businesses ($10M–$500M revenue): 10–15%
- Small businesses: 14–20%
- Early-stage startups: 20–35%
Enter cash flows for up to 3 projects in the Multi-Project Compare tab. Set a shared discount rate (WACC) and click Compare Projects. The calculator ranks all three by:
- IRR — highest annualized return rate
- NPV — total dollar value created at your WACC
- MOIC — equity multiple (total cash returned ÷ invested)
- Simple & Discounted Payback — time to recover investment
For a rental property or real estate deal, structure your cash flows this way:
- Period 0: −(Purchase Price + Closing Costs + Initial Rehab) — negative
- Periods 1–N: Annual Net Operating Income (Gross Rent − Vacancy − Operating Expenses − Property Management − Insurance − Taxes)
- Final Period: Add Net Sale Proceeds (Sale Price − Selling Costs − Remaining Mortgage Balance) to that year’s NOI
| Strategy | Target IRR Benchmark |
|---|---|
| Core (stabilized, Class A) | 8–10% |
| Value-Add (renovation, lease-up) | 12–18% |
| Opportunistic (ground-up development) | 18–25%+ |
| Single-Family Rental (SFR) | 10–15% |
The calculator does not apply taxes automatically. It computes pre-tax IRR based on whatever cash flows you enter. To calculate an after-tax IRR, you must manually adjust each period’s cash flow before entering it:
- Subtract income tax on operating profits (federal rate + applicable state rate)
- Add depreciation tax shields — depreciation reduces taxable income but is non-cash. Use IRS MACRS schedules (IRS Publication 946) to calculate the annual depreciation deduction × your marginal tax rate
- Adjust the exit cash flow for capital gains tax (long-term federal rate is 20% for high earners in 2026, plus 3.8% NIIT where applicable) and depreciation recapture (25%)
Simple Payback counts the raw number of years to recover your investment, treating all future dollars as equal regardless of when they are received. It is quick and intuitive but ignores the time value of money.
Discounted Payback first converts each future cash flow to its present value (using your WACC), then counts how long it takes to recover the investment in today’s dollars. It is always longer than simple payback because discounted future dollars are worth less.
| Metric | Time Value of Money? | Typical Use |
|---|---|---|
| Simple Payback | No | Quick screening, low-risk small CapEx |
| Discounted Payback | Yes | Capital allocation, risk-adjusted comparison |
Use all 7 tabs above — Core IRR, MIRR, NPV Profile, Hurdle Rate Decision, Scenario Analysis, Multi-Project Compare, and MOIC Matrix — completely free.
🔗 Related U.S. Corporate Finance & Valuation Calculators
The IRR Calculator is one piece of a full investment toolkit. Use these companion tools to model NPV, WACC, real estate cash flows, business valuations, tax impacts, and capital allocation — all in one place on USFinanceCalculators.com.
Calculators
Calculates the present value of all future cash flows discounted at your WACC. NPV is the companion metric to IRR — use both together for every investment decision.
Projects how much a lump sum or series of contributions will grow over time at a given interest rate. Use to model the compounded exit value on the other side of an IRR analysis.
Discounts a future cash flow back to today’s dollars at a specified rate. The foundation of all DCF and IRR calculations — use to check individual period present values.
Calculates simple Return on Investment as a percentage — the quick, non-time-weighted cousin of IRR. Best for short-term investments or when timing doesn’t materially affect the return.
Models how interest compounds over time across different frequencies (monthly, quarterly, annual). Useful for understanding reinvestment growth assumptions built into MIRR calculations.
Calculates the blended average cost and total return from making regular investments over time at varying prices. Use to compute IRR on a DCA-based equity portfolio.
Estimates a company’s value using EBITDA multiples, revenue multiples, and asset-based approaches. Use to define the acquisition cost (Period 0) and exit value for an LBO or PE deal IRR analysis.
Calculates EBITDA, EBITDA margin, and year-over-year growth. EBITDA is the foundation of most PE deal valuation and exit multiple calculations used in the MOIC / IRR Matrix tab.
Computes monthly payments, total interest, and true cost for equipment loans and leases. Use to accurately determine the after-financing cash flow schedule for a CapEx IRR analysis.
Calculates the revenue needed to cover fixed and variable costs. The break-even point defines the minimum revenue assumption in your Worst Case scenario analysis alongside the IRR tool.
Measures whether operating income covers debt obligations. Lenders require DSCR ≥ 1.25x for commercial loans. Use alongside IRR to confirm the project is both profitable and financeable.
Generates year-by-year net operating income, cash-on-cash return, and free cash flow for rental properties. Pipe the annual cash flows directly into the IRR calculator to compute total property IRR.
Calculates the cap rate (NOI / Property Value) for commercial and residential real estate. Use to set your exit value assumption in the IRR model — exit value = Year N NOI ÷ exit cap rate.
Calculates total return, cash-on-cash yield, and equity multiple for real estate investments. Use to cross-check IRR results with simple equity multiple (MOIC) for a full picture of RE performance.
Estimates federal and state capital gains tax on investment disposals — both short-term (ordinary rates) and long-term (0/15/20% brackets). Use to compute after-tax IRR by netting tax from your exit cash flow.
Designs optimal asset allocation across stocks, bonds, real estate, and alternatives based on risk tolerance and time horizon. Use the Multi-Project Compare tab to rank IRR across asset classes once allocated.
From IRR and NPV to mortgage amortization, capital gains tax, PE valuations, and business break-even — everything is free, instant, and built for US financial standards.
-
A free educational math tool that applies the standard IRR formula (Newton-Raphson iteration) and MIRR formula as defined in financial mathematics textbooks and the CFA Institute curriculum.
-
A scenario modeling tool that lets you test Best, Base, and Worst Case assumptions against your cash flows — for learning and preliminary analysis only.
-
A decision-support tool that generates a GO / NO-GO signal based on IRR vs. hurdle rate — intended to support, not replace, professional due diligence.
-
A reference tool for understanding IRR, NPV, MIRR, MOIC, and payback period concepts as used in US corporate finance and investment analysis.
-
Not a substitute for professional financial advice. No output from this calculator constitutes a personalized investment recommendation.
-
Not a tax tool. IRR results do not account for federal or state income taxes, capital gains taxes, depreciation recapture, FIRPTA, or any other tax obligations unless you manually adjust your cash flows to reflect after-tax amounts.
-
Not a guarantee of future performance. Projected IRRs are entirely dependent on cash flow assumptions — which may differ materially from actual results.
-
Not connected to any live data or market feeds. All calculations are performed locally in your browser using only your manual inputs.
These are mathematically established limitations of the IRR model itself — not limitations of this calculator specifically. They are documented in the CFA Institute curriculum and US corporate finance textbooks.
-
Reinvestment rate assumption: Standard IRR assumes all interim cash flows are reinvested at the IRR itself — which is rarely achievable in practice. Use the MIRR tab for a more realistic estimate using your actual WACC.
-
Multiple IRR problem: When a project has non-conventional cash flows (alternating positive and negative values beyond Period 0), there may be multiple valid mathematical solutions or no solution at all. The calculator flags this and recommends using NPV in such cases.
-
Scale blindness: IRR does not measure the absolute size of value creation. A $50,000 investment returning 35% IRR creates less wealth than a $500,000 investment at 22% IRR. Always compare NPV alongside IRR for mutually exclusive project decisions.
-
Duration sensitivity: IRR comparisons between projects with different holding periods (e.g., 3 years vs. 10 years) can be misleading. A high short-term IRR may not be replicable at reinvestment, reducing the effective long-term return.
-
No risk adjustment: IRR treats all cash flows as equally certain. Higher-risk cash flows require a higher hurdle rate adjustment — the calculator provides this via the Risk Level field in the Hurdle Rate Decision tab, but the adjustments (+2% for medium, +5% for high risk) are illustrative, not actuarially derived.
-
Inflation not modeled: Unless you input real (inflation-adjusted) cash flows, the IRR output is a nominal rate. To obtain a real IRR, adjust each cash flow for expected inflation before entering it into the calculator.
The formulas, definitions, and methodologies used in this calculator are grounded in US government publications, federal financial standards, and peer-reviewed academic frameworks. The following authoritative sources are provided for independent verification and further reading.
| Authority Source | Domain | Relevance to This Calculator | Direct Link |
|---|---|---|---|
|
U.S. Securities & Exchange Commission (SEC) Office of Investor Education & Advocacy |
.gov | The SEC’s Investor.gov resource defines how IRR and NPV are used in investment return measurement, and why the reinvestment rate assumption matters for retail and institutional investors. Their guidance underpins the MIRR explanation in this tool. | investor.gov — IRR Definition ↗ |
|
U.S. Small Business Administration (SBA) Capital Planning & Business Investment Guidance |
.gov | The SBA’s business financial planning guides reference IRR and payback period as key metrics for evaluating CapEx, equipment financing, and SBA 7(a) / 504 loan-funded investments — directly relevant to the business use cases modeled in this tool. | sba.gov — Business Finance Guide ↗ |
|
IRS — Publication 946 How to Depreciate Property (MACRS) |
.gov | Depreciation under MACRS affects the after-tax cash flows that go into an IRR model for capital equipment and real estate. IRS Publication 946 defines allowable depreciation schedules used by US businesses to compute tax-adjusted cash flows. | irs.gov — Publication 946 ↗ |
|
U.S. Department of Energy (DOE) Federal Energy Management Program (FEMP) |
.gov | The DOE FEMP uses IRR and Life-Cycle Cost Analysis (LCCA) to evaluate energy efficiency and renewable energy investments — the same framework used in the Solar IRR example in the Examples section of this page. Their methodology guidance validates this tool’s approach. | energy.gov — LCCA Methodology ↗ |
|
Federal Reserve Bank of St. Louis (FRED) Economic Research — Discount Rate & WACC Data |
.gov | FRED provides the benchmark interest rate data (Federal Funds Rate, 10-Year Treasury yield, commercial prime rates) that US businesses use to set their WACC and hurdle rates — the key inputs in the Hurdle Rate Decision tab of this calculator. | fred.stlouisfed.org — Economic Data ↗ |
|
MIT OpenCourseWare — Finance Theory I 15.401 — Sloan School of Management |
.edu | MIT’s finance curriculum (15.401) covers the mathematical derivation of IRR, NPV, MIRR, and the reinvestment rate problem — the same academic framework this calculator’s formulas are based on. Free lecture notes are publicly available for independent verification. | ocw.mit.edu — Finance Theory I ↗ |
-
Written for humans, not search engines. All explanatory content, examples, and pro tips on this page are written in plain US English, using real investment scenarios that reflect how the calculator is actually used in the field.
-
Grounded in primary sources. Every numerical claim, formula, and benchmark rate referenced on this page is tied to a verifiable source — either the US government links in the table above or standard financial textbooks.
-
Updated when regulations or rates change. We review this page when the Federal Reserve adjusts rates, IRS updates depreciation rules, or major changes occur to US capital gains tax rates that affect after-tax IRR calculations.
-
Calculation methodology is transparent. The Newton-Raphson IRR solver used in this calculator is the same iterative algorithm used in Microsoft Excel’s
IRR()andMIRR()functions. Our implementation uses Big.js for high-precision arithmetic to avoid floating-point rounding errors.
