Overview
NPV (Net Present Value) tells you whether an investment creates value once you account for the time value of money โ the simple fact that a dollar today is worth more than a dollar in the future. This article walks through exactly how to calculate NPV from an initial investment, a discount rate, and a series of projected future cash flows.
This guide is for anyone evaluating a business investment, capital project, or major personal financial decision who needs to determine 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
Select 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
In this example, the NPV is negative, meaning the project does not clear the 12% hurdle rate โ at this discount rate, the investment would destroy value relative to an alternative use of that capital 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% is highly sensitive to your cost-of-capital assumption, and worth examining more carefully before deciding. Use the NPV calculator to run these scenarios quickly without redoing the arithmetic by hand.
Step 7: Compare against alternative projects, if applicable
If 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 โ this is the single biggest source of misleading NPV results.
- Ignoring sensitivity to the discount rate โ a single point-estimate NPV can hide how fragile the conclusion is to a reasonable change in assumptions; always check at least two or three discount rate scenarios.
- Comparing NPV across projects with very different initial investment sizes without considering capital constraints โ a smaller project with a lower NPV but much smaller required investment may be more practical than a larger project with a marginally higher NPV.
- Confusing NPV with simple payback period โ a project can have a long payback period but still a strongly positive NPV if the cash flows in later years are large enough, and vice versa.
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 โ both are estimates, which is why sensitivity analysis across a range of assumptions is standard practice rather than relying on 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