Overview
NPV (Net Present Value) tells you whether an investment creates value once the time value of money is factored in, the simple fact that a dollar today is worth more than a dollar in the future. This article walks through calculating NPV from an initial investment, a discount rate, and a series of projected future cash flows.
It's written for anyone evaluating a business investment, capital project, or major personal financial decision who needs to know whether the expected returns justify the upfront cost.
What You Need
Before calculating NPV, gather:
- Initial investment (outflow): the upfront cost of the project or investment
- Projected cash flows for each future period: typically annual, for the life of the project
- Discount rate: your required rate of return or cost of capital, reflecting the risk of the investment
Steps
Step 1: Lay out the initial investment and projected cash flows by period
| Year | Cash Flow |
|---|---|
| 0 (today) | โ$30,000 (initial investment) |
| 1 | $10,000 |
| 2 | $12,000 |
| 3 | $14,000 |
Step 2: Choose your discount rate
Pick a discount rate that reflects your required rate of return given the investment's risk level. For this example, assume a 12% hurdle rate.
Step 3: Discount each future cash flow back to its present value
Present Value of Cash Flow = Cash Flow / (1 + Discount Rate)^Period Number
| Year | Cash Flow | Discount Factor (1.12^n) | Present Value |
|---|---|---|---|
| 1 | $10,000 | 1.12 | $8,929 |
| 2 | $12,000 | 1.2544 | $9,567 |
| 3 | $14,000 | 1.4049 | $9,972 |
Step 4: Sum the discounted cash flows
Total Present Value of Future Cash Flows = $8,929 + $9,567 + $9,972 = $28,468
Step 5: Subtract the initial investment to get NPV
NPV = Total Present Value of Future Cash Flows โ Initial Investment = $28,468 โ $30,000 = โ$1,532
The NPV comes out negative here, meaning the project doesn't clear the 12% hurdle rate. At this discount rate, the investment would destroy value relative to putting that same capital to work elsewhere at the same required return.
Step 6: Test the result against alternative discount rates
Recalculate NPV at a lower discount rate, say 8%, to see how sensitive the result is. A project that's negative at 12% but solidly positive at 8% depends heavily on your cost-of-capital assumption and deserves a closer look before you decide. The NPV calculator runs these scenarios quickly without redoing the arithmetic by hand.
Step 7: Compare against alternative projects, if applicable
Choosing between multiple investment options of similar scale? The option with the higher NPV at the same discount rate is generally preferable, since it creates more value in today's dollars for the same capital risk.
Common Mistakes to Avoid
Using an arbitrary discount rate instead of one grounded in your actual cost of capital or required return is the single biggest source of misleading NPV results.
Ignoring sensitivity to the discount rate is another common trap. A single point-estimate NPV can hide how fragile the conclusion is to a reasonable change in assumptions, so check at least two or three discount rate scenarios before trusting the number.
Comparing NPV across projects with very different initial investment sizes, without considering capital constraints, can steer you wrong too. A smaller project with a lower NPV but a much smaller required investment may be more practical than a larger project with a marginally higher NPV.
Confusing NPV with simple payback period causes its own confusion. A project can carry a long payback period and still post a strongly positive NPV if the cash flows in later years run large enough, and the reverse holds too.
Formula & Methodology
Present Value of Cash Flow in Period n = Cash Flow / (1 + Discount Rate)^n
NPV = ฮฃ [Cash Flow in Period n / (1 + Discount Rate)^n] โ Initial Investment, summed across all periods
This is the standard discounted cash flow (DCF) approach. The accuracy of NPV depends entirely on the quality of the cash flow projections and the appropriateness of the chosen discount rate, and since both are estimates, running a sensitivity analysis across a range of assumptions is standard practice rather than trusting a single calculation.
Key Terms
- NPV: Net Present Value; the present value of future cash inflows minus the present value of cash outflows
- Present Value: the current worth of a future sum of money, discounted at a specific rate
- Future Value: the projected value of a current sum of money at a specific point in the future
- IRR: Internal Rate of Return; the discount rate at which NPV equals zero
- Payback Period: the time required for an investment's cash flows to recover the initial cost, without discounting