Net present value and IRR explained

Time value of money in one paragraph

A dollar received today is worth more than a dollar received in five years because you can invest today's dollar and earn a return — the essence of compound interest. The present value (PV) of a future cash flow CF_t received in year t at discount rate r is:

PV = CFt / (1 + r)t

The discount rate r reflects opportunity cost: what you could earn on the next-best investment of similar risk. For a diversified corporation, that rate is often the weighted average cost of capital (WACC) — the blended return equity and debt investors demand. For a startup founder, it might be the return venture capitalists require on comparable deals. The rate is not arbitrary; it encodes risk.

Net present value (NPV)

NPV is the sum of all discounted cash flows — initial investment (usually negative) plus operating inflows and outflows over the project's life:

NPV = ∑t=0n CFt / (1 + r)t

Interpretation is direct and in dollars:

• NPV > 0 — the project creates value above your hurdle rate; accept it (all else equal).
• NPV = 0 — the project earns exactly your required return; indifferent.
• NPV < 0 — the project destroys value relative to alternatives; reject it.

NPV's strength is additivity: if Project A has NPV of $2M and Project B has NPV of $3M, doing both (if independent) creates $5M of value. That property makes NPV the theoretically preferred rule for capital budgeting. It also scales naturally — a $50M NPV matters more than a $5M NPV when capital is scarce.

What cash flows belong in NPV?

Use incremental cash flows — the difference between the world with the project and without it. Include:

• Upfront capex and working-capital changes
• Operating cash inflows (revenue minus cash costs, not accounting profit)
• Tax effects on incremental income
• Salvage or disposal value at project end

Exclude sunk costs already spent, financing cash flows (interest and principal — the discount rate already accounts for capital cost), and non-cash accounting charges like depreciation (except through their tax shield). For stock valuation, the same logic appears in free cash flow projections inside a DCF model.

Internal rate of return (IRR)

The IRR is the discount rate r* that makes NPV equal to zero. In other words, it is the project's implied compound annual return if you reinvest intermediate cash flows at that same rate. Decision rule:

• IRR > hurdle rate — accept (project beats your required return).
• IRR < hurdle rate — reject.

IRR is intuitive for managers who think in percentage returns ("this expansion returns 18% annually") and is widely reported in pitch decks and board memos. There is no closed-form solution for most cash-flow patterns; Excel's IRR() function and financial calculators solve it iteratively.

IRR pitfalls that textbooks emphasize

IRR assumes reinvestment at the IRR itself — if a project throws off large early cash flows, IRR assumes you can reinvest them at that high rate, which may be unrealistic. IRR can also produce multiple solutions when cash flows change sign more than once (capex, then revenue, then teardown costs) or no solution when all flows are same-sign. For mutually exclusive projects of different scale, IRR can rank a smaller high-percentage project above a larger lower-percentage project that creates more absolute dollars — NPV resolves that correctly.

Modified IRR (MIRR) fixes the reinvestment assumption by discounting negative flows to present and compounding positive flows to terminal value at the hurdle rate, then computing a single return. Many CFOs prefer MIRR for comparisons but still report IRR because stakeholders expect it.

NPV vs IRR: when they agree and when they fight

For a standalone project with conventional cash flows (one outflow, then inflows), NPV and IRR usually agree. Conflicts appear with:

• Scale differences — Project X: IRR 25%, NPV $1M; Project Y: IRR 20%, NPV $4M. IRR picks X; NPV correctly picks Y if capital is not constrained to one.
• Different lives — a five-year lease vs a ten-year purchase need equivalent annual annuity or common-horizon adjustments before comparing IRRs.
• Non-conventional cash flows — mining projects with reclamation outlays at the end can yield two IRRs; NPV remains unambiguous.

Academic and practitioner consensus: use NPV as the primary decision rule; use IRR as a communication supplement. If they disagree on mutually exclusive projects, trust NPV.

Worked example: Harbor Manufacturing warehouse automation

Harbor Manufacturing debates replacing manual pallet picking with an automated storage-and-retrieval system (ASRS). Numbers are simplified but realistic.

Cash flow forecast (thousands USD)

Harbor's WACC is 9% — the hurdle rate for this operating-risk project. Discounting each net cash flow:

• Year 0: −$2,400
• Year 1: $560 / 1.09 = $513
• Year 2: $575 / 1.09² = $484
• Year 3: $590 / 1.09³ = $456
• Year 4: $605 / 1.09⁴ = $429
• Year 5: $800 / 1.09⁵ = $520

NPV ≈ +$2 thousand — essentially breakeven at 9%. The spreadsheet IRR function returns approximately 9.1%, just above the hurdle. Harbor's board approves narrowly: the automation clears the cost of capital but leaves little margin of safety. A 10% WACC would flip NPV negative — sensitivity to the discount rate matters as much as the cash-flow forecast.

Suppose a vendor offers a cheaper semi-automated line for $1.2M upfront with lower annual savings. Its IRR might be 14% while NPV is only $180K. IRR ranks the smaller project higher; NPV ranks the full ASRS higher if Harbor can fund only one project but wants maximum dollar value. The CFO presents both metrics and lets the board choose whether percentage return or absolute value creation is the binding constraint.

Method decision table

Common pitfalls

• Using the wrong discount rate — applying a 5% treasury yield to a risky startup project understates required return and inflates NPV.
• Forecasting operating profit instead of cash flow — depreciation is not a cash outflow; working-capital build is.
• Ignoring opportunity cost — using warehouse space for Project A means forgoing rent from Project B; include it.
• Trusting IRR alone on exclusive projects — always check NPV when only one option can be chosen.
• Comparing projects with different durations without terminal-value or annuity-equivalent adjustments.
• Optimistic salvage values — used equipment often resells for far less than book value.
• Double-counting strategic optionality — "this opens future markets" needs quantified follow-on cash flows, not narrative alone.
• Excel IRR on non-annual periods — monthly cash flows require XIRR with actual dates, not raw IRR.

Practical checklist

• Define incremental cash flows with and without the project — exclude sunk costs.
• Choose a hurdle rate matched to project risk (WACC for operating assets, higher for venture bets).
• Compute NPV first; treat it as the authoritative accept/reject signal.
• Calculate IRR or MIRR for communication; note if multiple IRRs exist.
• Run sensitivity tables on discount rate and key revenue/cost assumptions.
• For mutually exclusive options, rank by NPV, not IRR alone.
• Align project life assumptions before comparing returns across options.
• Document tax effects and working-capital changes explicitly.
• Compare results to a simple payback screen if liquidity is tight.
• Revisit the model when actual cash flows arrive — capital budgeting is a living forecast.

Key takeaways

• NPV measures dollar value created at your required return; positive NPV means accept.
• IRR is the breakeven discount rate; compare it to your hurdle for intuitive go/no-go calls.
• When NPV and IRR conflict on exclusive projects, follow NPV.
• Both metrics depend on cash-flow quality and discount-rate discipline more than spreadsheet elegance.
• Stock-level DCF valuation is NPV applied to an entire business — the same logic, longer horizon.

Related reading

• Discounted cash flow (DCF) valuation explained — NPV applied to whole businesses and stocks
• WACC explained — choosing the discount rate for corporate projects
• Free cash flow explained — the cash metric inside DCF and capex models
• Fundamental analysis explained — connecting valuation tools to stock picking