Week 2

Perpetuities, NPV & IRR

Perpetuities, NPV & IRR

Part of: Financial Management Lesson 2 — Financial Management & Finance Key concepts: Perpetuity, Growing Perpetuity, Net Present Value, Internal Rate of Return, Discount Rate


Perpetuities — annuities that never end

A perpetuity pays a level CC every period forever. Taking the annuity formula and letting n→∞n\to\infty, the term (1+r)−n→0(1+r)^{-n}\to 0, leaving a strikingly simple result:

PVperpetuity=Cr\boxed{PV_{\text{perpetuity}} = \frac{C}{r}}
Check

C=100C = 100, r=10%r = 10\% → PV=100/0.10=$1,000PV = 100/0.10 = \$1{,}000. Summing 50 years of discounted $100 already gives ≈$991\approx \$991; the remaining infinite tail adds only ≈$9\approx\$9 — almost all the value of a perpetuity sits in the early payments.

Growing perpetuity (the Gordon formula)

If payments grow forever at rate g<rg < r:

PVgrowing perp=Cr−g(r>g)\boxed{PV_{\text{growing perp}} = \frac{C}{r-g}}\qquad (r > g)
The convergence condition r>gr > g

If g≥rg \ge r the sum diverges — an infinite stream growing at least as fast as it is discounted is worth infinity. The formula is only valid when the discount rate strictly exceeds the growth rate. CC here is the first payment (at t=1t = 1), not the time-0 amount.

Check

C=100C = 100, r=10%r = 10\%, g=3%g = 3\% → PV=100/(0.10−0.03)=$1,428.57PV = 100/(0.10-0.03) = \$1{,}428.57.


Net Present Value — the master decision rule

NPV is the value created by a project: the PV of all future cash flows minus the initial investment.

NPV=∑t=0TCFt(1+r)t=−CF0+∑t=1TCFt(1+r)t\boxed{NPV = \sum_{t=0}^{T} \frac{CF_t}{(1+r)^t} = -CF_0 + \sum_{t=1}^{T}\frac{CF_t}{(1+r)^t}}
The rule

Accept if NPV>0NPV > 0. A positive NPV means the project returns more than the cost of capital rr — it adds wealth today, measured in dollars.

Lecture project

CF=(−1000,100,200,300,300,300)CF = (-1000, 100, 200, 300, 300, 300) at r=6%r = 6\% gives NPV≈−$13.97NPV \approx -\$13.97 → reject at 6%. But the NPV profile below shows it would be accepted at any rate below the IRR (≈5.55%).

Excel's NPV quirk — off-by-one

NPV(rate, values) assumes the first value is at t=1t = 1, not t=0t = 0. So for a project with a time-0 outlay you must write =NPV(r, CF1:CFn) + CF0, adding the un-discounted initial flow separately. Writing =NPV(r, CF0:CFn) discounts the outlay by one period too many.

L2_npv_profile


Internal Rate of Return

The IRR is the discount rate that makes NPV=0NPV = 0 — the project's own break-even return.

0=∑t=0TCFt(1+IRR)t0 = \sum_{t=0}^{T}\frac{CF_t}{(1+\text{IRR})^t}
The rule

Accept if IRR>r\text{IRR} > r (the hurdle/cost of capital). Graphically, the IRR is where the NPV profile crosses zero. Excel: IRR(values, [guess]).


Why IRR can mislead — three traps

1. IRR measures profitability, NPV measures profit

A project returning 300% on $1 (IRR = 3.0) creates $3 of value; a project returning 30% on $100{,}000 creates $30{,}000. IRR ranks the first higher, but NPV — and your bank balance — prefer the second. For mutually exclusive projects, rank by NPV, not IRR.

2. Multiple IRRs

When cash flows change sign more than once (e.g. outflow → inflow → outflow), the polynomial NPV(r)=0NPV(r) = 0 can have several roots. The cash flow (−9450,19500,−10000)(-9450, 19500, -10000) has two IRRs (≈ −4.8% and ≈ 11.1%). Excel returns whichever is nearest your guess, so the answer is ambiguous — fall back to NPV.

L2_multiple_irr

3. The reinvestment assumption

IRR implicitly assumes every interim cash flow is reinvested at the IRR itself. For a high-IRR project that is unrealistic — you rarely have other projects yielding the same high rate. NPV assumes reinvestment at the cost of capital rr, which is the economically correct benchmark.


NPV vs IRR — when do they agree?

Situation NPV IRR Use
Single project, conventional CFs accept if >0>0 accept if >r> r agree
Mutually exclusive projects rank by $\$ created can mis-rank (scale/timing) NPV
Non-conventional CFs (sign changes) one clear answer multiple/none NPV
Comparing very different scales correct biased to small projects NPV
One-line verdict

When NPV and IRR disagree, trust NPV. IRR is a useful communication tool (a percentage return) but NPV is the decision rule because it measures dollars of value added and uses the right reinvestment rate.


Summary

Key takeaways
  • Perpetuity =C/r= C/r; growing perpetuity =C/(r−g)= C/(r-g), valid only when r>gr > g.
  • NPV discounts every cash flow to today; accept if NPV > 0. Mind Excel's NPV off-by-one — add CF0CF_0 separately.
  • IRR is the rate where NPV = 0; accept if IRR > r.
  • IRR's three traps: profitability ≠ profit, multiple IRRs with sign changes, and an unrealistic reinvestment assumption.
  • When the two rules conflict, NPV wins.