How to Calculate Net Present Value: Step-by-Step Guide with Examples
Calculating NPV involves forecasting periodic cash flows, choosing an appropriate discount rate, calculating individual present values, and summing them against the initial outlay.
Key Takeaways
- Calculate the discount factor for each period using 1 / (1 + r)^t.
- Multiply each year’s nominal cash flow by its discount factor to obtain Present Value.
- Sum all discounted cash inflows across the project lifecycle.
- Subtract Year 0 initial investment to arrive at the final Net Present Value.
Step 1: Estimate All Projected Cash Flows
Begin by projecting the net cash flow for each year of the project life. Net cash flow should represent actual cash received minus cash spent—not accounting net income. Non-cash expenses like depreciation should be added back, while capital expenditures and working capital changes must be deducted.
Step 2: Determine the Appropriate Discount Rate
The discount rate should represent your opportunity cost of capital or Weighted Average Cost of Capital (WACC). For riskier ventures, analysts calibrate the hurdle rate to project-specific risk using divisional CAPM betas or empirical equity risk premiums rather than ad-hoc add-ons.
Step 3: Calculate the Discount Factor for Each Year
For year $t$ and discount rate $r$, the discount factor is:
$$\text{Discount Factor}_t = \frac{1}{(1 + r)^t}$$
For example, at a 10% discount rate: - Year 1: $1 / (1.10)^1 = 0.9091$ - Year 2: $1 / (1.10)^2 = 0.8264$ - Year 3: $1 / (1.10)^3 = 0.7513$ - Year 4: $1 / (1.10)^4 = 0.6830$ - Year 5: $1 / (1.10)^5 = 0.6209$
Step 4: Master Worked Timetable (5-Year Project Schedule)
Below is the comprehensive cash flow timetable for an initial investment of ₹10,00,000 discounted at a 10% annual hurdle rate. Notice how the Running Total column crosses from negative to positive in Year 2, establishing the exact discounted payback timeline.
| Period (t) | Timing / Milestone | Nominal Cash Flow | Discount Factor (10%) | Present Value (PV) | Cumulative Net Present Value |
|---|---|---|---|---|---|
| Period 0 | Initial CapEx Outlay (Day 0) | -₹10,00,000 | 1.0000 | -₹10,00,000 | -₹10,00,000 |
| Period 1 | Year 1 Operations (End of Yr 1) | ₹3,00,000 | 0.9091 | ₹2,72,727 | -₹7,27,273 |
| Period 2 | Year 2 Expansion Inflow | ₹35,00,000 | 0.8264 | ₹28,92,562 | +₹21,65,289 (Breakeven) |
| Period 3 | Year 3 Net Inflow | ₹78,567 | 0.7513 | ₹59,029 | +₹22,24,318 |
| Period 4 | Year 4 Scale Revenue | ₹54,64,755 | 0.6830 | ₹37,32,504 | +₹59,56,822 |
| Period 5 | Year 5 Final Inflow & Scrap | ₹3,00,000 | 0.6209 | ₹1,86,273 | +₹61,43,095 |
Step 5: Sum Present Values & Deduct Outlay
Sum of Present Values of all future inflows: $$\text{PV of Inflows} = ₹2,72,727 + ₹28,92,562 + ₹59,029 + ₹37,32,504 + ₹1,86,273 = ₹71,43,095$$
Subtract Initial Outlay (₹10,00,000): $$\text{NPV} = ₹71,43,095 - ₹10,00,000 = +₹61,43,095$$
Because the NPV is positive (+₹61,43,095) and the Profitability Index is 7.14x, this capital project creates exceptional shareholder wealth.
Calculate Net Present Value Live
Run your cash flows through our free, real-time Net Present Value calculator.