To understand how to calculate net present value (NPV), you must compare the initial investment to the present value of all future cash flows it will generate.
A positive NPV means the investment creates value, while a negative NPV means it destroys value relative to your required return. It essentially tells you—in today’s dollars—whether a project is worth the cost.
The formula:
> NPV = −Initial Investment + Σ [CFₜ / (1 + r)ᵗ]
Where CFₜ is the cash flow in period t, r is the discount rate, and t is the time period.
Step 1: Identify All Cash Flows
List every cash inflow and outflow associated with the project, including the initial investment (negative) and all future returns (positive or negative).
Example project:
- Initial investment: $80,000
- Year 1 return: $25,000
- Year 2 return: $30,000
- Year 3 return: $35,000
- Year 4 return: $20,000
Step 2: Choose Your Discount Rate
The discount rate reflects the minimum return you require – your cost of capital, hurdle rate, or opportunity cost. Common choices:
| Context | Typical Discount Rate |
|---|---|
| Corporate investment (WACC) | 8%-12% |
| Real estate investment | 8%-15% |
| Personal investment | Personal rate of return expectation |
| Government projects | 3%-7% |
| High-risk startups | 20%-35% |
For this example, use 10%.
Step 3: Calculate Present Value of Each Cash Flow
Divide each future cash flow by (1 + discount rate)^year:
| Year | Cash Flow | Calculation | Present Value |
|---|---|---|---|
| 0 | −$80,000 | Initial investment | −$80,000 |
| 1 | $25,000 | $25,000 / (1.10)¹ | $22,727 |
| 2 | $30,000 | $30,000 / (1.10)² | $24,793 |
| 3 | $35,000 | $35,000 / (1.10)³ | $26,296 |
| 4 | $20,000 | $20,000 / (1.10)⁴ | $13,660 |
Step 4: Sum All Present Values
> NPV = −$80,000 + $22,727 + $24,793 + $26,296 + $13,660
> NPV = +$7,476
The NPV is positive – the project returns more than the 10% required rate. Accept the project.
Step 5: Apply the Decision Rule
| NPV Result | Decision |
|---|---|
| Positive (+) | Accept – project creates value above required return |
| Zero (0) | Neutral – exactly meets required return |
| Negative (−) | Reject – project destroys value |
When comparing multiple projects, choose the one with the highest positive NPV.
Calculating NPV in Excel
Method 1: NPV Function
=NPV(discount_rate, cash_flow_year1:cash_flow_year4) + initial_investment
Note: Excel’s NPV function discounts from Period 1. Add the Period 0 investment separately (as a negative):
=NPV(0.10, 25000, 30000, 35000, 20000) + (−80000) = $7,476
Method 2: Manual calculation
Create a column for each year’s discount factor and multiply each cash flow – this makes assumptions visible and easier to audit.
Sensitivity Analysis: Test Your Assumptions
NPV is only as good as its inputs. Run sensitivity scenarios:
| Scenario | Discount Rate | NPV |
|---|---|---|
| Optimistic | 8% | $11,842 |
| Base case | 10% | $7,476 |
| Pessimistic | 12% | $3,375 |
| Break-even | ~14.5% | $0 |
If your NPV turns negative at a discount rate that seems realistic (say, 12%), the project’s margin of safety is thin – factor that into the decision.
The Bottom Line
Calculating NPV is a five-step process: list cash flows, choose a discount rate, calculate present value of each cash flow, sum them, subtract the initial investment. A positive result means the investment creates value above your required return. Do it in Excel for speed, but understand the mechanics so you can explain – and challenge – the assumptions behind any NPV model.
