Uneven cash flows, NPV and IRR
When amounts differ, discount each one and add. Net present value (NPV) is the sum of all discounted flows, with the cost today entered as a negative amount:
NPV = CF0 + CF1 / (1 + r) + CF2 / (1 + r)^2 + ... + CFn / (1 + r)^n
A positive NPV means the investment earns more than the required rate r; a negative NPV means less.
Worked example. Pay $20,000 today and receive $4,000, $6,000, $8,000 and $7,000 at the ends of Years 1 to 4. At 8%, NPV = -20,000 + 3,703.70 + 5,144.03 + 6,350.66 + 5,145.21 = $343.60, so the investment just beats 8%.
The internal rate of return (IRR) is the rate that makes NPV zero. Calculators find it by trial (the CF and IRR keys). Accept the investment if its IRR exceeds the required rate.
| Measure | Answers | Caution |
|---|---|---|
| NPV | How many dollars of value it adds at the required rate | Depends on the rate chosen |
| IRR | What rate the flows earn | Can mislead when flows change sign more than once, or when comparing projects of different size |
When NPV and IRR disagree between two choices, NPV at the client's required rate is the better guide.