NPV and IRR: the capital budgeting duo

Deciding whether to invest $100,000 in new equipment, launch an IT project, open a branch, or buy rental property requires quantitative tools. The two pillars of capital budgeting are Net Present Value (NPV) and Internal Rate of Return (IRR): together they determine if an investment creates or destroys value.

NPV — Net Present Value

NPV is the algebraic sum of all cash flows discounted at the cost of capital, minus initial investment.

NPV = −I₀ + Σ_t=1ⁿ CF_t / (1+r)^t

NPV decision rule

• NPV > 0: accept (creates value)
• NPV = 0: indifference threshold
• NPV < 0: reject (destroys value)

Example

$100,000 investment, cash flows: $25k, $30k, $35k, $40k, $45k. Discount rate 8%.

PV sum = $136,680. NPV = $36,680 (accept).

IRR — Internal Rate of Return

IRR is the discount rate that makes NPV = 0. Project's effective return rate.

IRR decision rule

• IRR > WACC: accept
• IRR < WACC: reject

Our example: IRR ≈ 20.1% vs WACC 8% — strong margin.

Why NPV and IRR together

When they conflict, follow NPV for value-maximizing decisions.

Payback Period and Discounted Payback

Simple payback

Time to recover initial investment from undiscounted cash flows.

Discounted payback

Same but with discounted flows. More accurate, always longer.

US benchmarks:

• < 2 years: excellent
• 2-4 years: good
• 4-7 years: acceptable
• > 7 years: high-risk, requires scenario analysis

Profitability Index (PI)

PI = PV of future cash flows / Initial investment

• PI > 1: creates value
• PI = 1.5: $1.50 PV per $1 invested
• PI < 1: destroys value

Useful for capital rationing: with limited budget, choose highest-PI projects.

WACC — Weighted Average Cost of Capital

WACC = (E/V)×re + (D/V)×rd×(1−t)

US WACC benchmarks 2026

Practical applications

1. Industrial equipment

$250k investment, 8-yr life, $40k annual savings. WACC 9%. NPV ≈ $15k. IRR ≈ 10.5%. Accept with caution.

2. New branch

$500k fit-out, growing CF over 5 years. WACC 10%. NPV ≈ $35k, IRR ≈ 13%. Accept.

3. Rental property

$400k price, $18k net rent/year, $500k terminal value. WACC 6%. NPV ≈ $60k, IRR ≈ 7.5%. Good investment with leverage.

4. R&D biotech project

$5M investment, highly uncertain flows, WACC 18% (high-risk). Requires Monte Carlo + real options analysis.

NPV and IRR limitations

• Reinvestment assumption: NPV assumes reinvestment at WACC, IRR at its own rate. MIRR solves this
• Non-conventional flows: multiple IRRs when cash flows change sign multiple times
• Different project sizes: IRR favors small projects
• Single risk rate: year-specific risks not captured
• Pure financial view: ignores strategic effects, real options
• Sensitivity: ±20% flow variations can flip decisions

Advanced extensions

MIRR — Modified IRR

Solves reinvestment assumption. Uses financing rate for negative flows, reinvestment rate for positive.

NPV Profile

Plot NPV vs discount rate. X-axis intersection = IRR. Useful for project comparisons.

Equivalent Annual Annuity (EAA)

Converts NPV to constant annual flow. Useful for comparing different-duration projects.

Real Options

Extends NPV to include strategic flexibility (expansion, abandonment, deferral). Black-Scholes or binomial models. Common in M&A and R&D.

Sensitivity and scenario analysis

Vary 3-5 key parameters ±10-20%:

• Annual cash flow (±20%)
• Discount rate (±2 pts)
• Useful life (±1 year)
• Terminal value (±30%)
• Initial investment (±15%)

Build 3 scenarios:

• Base case: most likely
• Best case: reasonable upside
• Worst case: stress downside

Monte Carlo simulation

For large investments (>$1M), simulate 10,000-100,000 scenarios with probability distributions. Tools: Oracle Crystal Ball, Palisade @Risk, Python scipy, R mc2d.

Output: NPV probability distribution. Informs decisions under high variance.

US tax considerations

• MACRS depreciation: Modified Accelerated Cost Recovery System for CapEx
• Section 179 deduction: up to $1.22M immediately expensed on qualifying equipment (2026)
• Bonus depreciation: 60% in 2026, phasing down
• R&D credit §41: up to 20% of qualified research expenses
• Opportunity Zones: capital gains deferral for qualified investments
• Investment Tax Credit (ITC): 30% for solar/clean energy projects

FAQ

Which discount rate?

Company WACC for corporate investment. Risk-adjusted WACC for high-risk projects. Opportunity cost for personal investments.

Positive NPV but low IRR: accept?

Yes. NPV is the preferred metric. Low IRR but above WACC with positive NPV = value creation.

Different-duration projects?

Use Equivalent Annual Annuity (EAA) or chain-replicate the shorter.

Nominal vs real discounting?

Consistency: nominal flows with nominal rate, real flows with real rate. Don't mix.

Handle uncertainty?

Scenario analysis, sensitivity, Monte Carlo for big projects, real options for flexibility.

NPV vs Payback?

NPV for value decisions. Payback useful as additional constraint (liquidity, time risk).

Common mistakes in capital budgeting

• Using wrong discount rate: applying corporate WACC to a project with different risk profile (e.g., green energy project at IT company WACC)
• Ignoring incremental cash flows: NPV must use cash flows caused by the investment, not total operational flows
• Double-counting working capital: either model WC as separate cash outflow at start + recovery at end, OR deduct from operating CF — never both
• Forgetting taxes: use after-tax cash flows consistently
• Ignoring terminal value: for projects with indefinite life, terminal value can be 50-80% of total NPV
• Sunk costs: prior CapEx or R&D already spent should be excluded from decision analysis
• Circular reasoning: using target IRR as discount rate for NPV is nonsensical

Capital rationing and Profitability Index

When budget is constrained, use PI ranking to allocate capital:

Example: $500,000 budget, 5 projects available:

Ranked by PI: C, A/E (tie), B, D. Optimal selection within $500k: C ($250k) + A ($200k) + D ($50k partial)? Actually can't partial. Best: C + A + $50k idle = $350k spent, NPV $230k. Or C + B + D = $500k, NPV $220k. Or C + E partial impossible. Use optimization (integer programming) for complex cases.

Building a proper DCF model

Professional DCF models include:

1. Revenue forecast: year-by-year, explicit assumptions on volume and price
2. Operating expenses: split between variable (scale with revenue) and fixed
3. EBITDA calculation: revenue − COGS − OPEX
4. Depreciation schedule: based on CapEx and useful life
5. EBIT and tax: EBIT × (1 − tax rate) = NOPAT
6. Free Cash Flow: NOPAT + D&A − CapEx − Δ Working Capital
7. Terminal value: Gordon Growth: FCF × (1+g) / (WACC − g), with g = 1-3%
8. Discounting: PV each FCF at WACC, sum, subtract initial investment

Common tools: Excel (most flexible), Google Sheets, specialized software (Oracle Crystal Ball, Macabacus for investment banking, Capital IQ).

Pre-money vs post-money valuations

For startup investments, NPV connects to valuation:

• Pre-money: company value before new investment
• Post-money: pre-money + investment amount
• Example: $2M investment at $8M pre-money = $10M post-money. Investor owns 20%

DCF valuation of equity gives NPV of shareholder cash flows, which at transaction time = pre-money value.

Updated July 2026