How to Calculate NPV: Complete Step-by-Step Guide
Master Net Present Value calculation for better investment decisions
Try Our Free NPV Calculator
Skip the math - calculate NPV instantly with our professional tool
What is Net Present Value (NPV)?
Net Present Value (NPV) is one of the most important financial metrics for evaluating investments. It tells you the present value of an investment by discounting all future cash flows back to today's dollars.
In simple terms: NPV shows you how much value an investment creates or destroys in today's money.
The Golden Rule:
- ✅ NPV > 0: Accept the investment (it creates value)
- ❌ NPV < 0: Reject the investment (it destroys value)
- ⚠️ NPV = 0: Indifferent (investment exactly returns the cost of capital)
The NPV Formula
Don't worry if this looks complex - we'll break it down into simple steps below!
How to Calculate NPV: 5 Simple Steps
1Identify All Cash Flows
List all expected cash flows from the investment, including:
- Initial investment (negative cash flow)
- Annual revenues or cost savings
- Operating costs
- Terminal value (if selling the asset)
Example:
Year 0: -$100,000 (initial investment)
Year 1: $30,000
Year 2: $40,000
Year 3: $50,000
2Determine the Discount Rate
Choose the appropriate discount rate based on:
- Company's WACC (Weighted Average Cost of Capital)
- Required rate of return
- Opportunity cost of capital
- Risk-adjusted hurdle rate
Example: 10% discount rate
Use r = 0.10 in calculations
3Discount Each Cash Flow
Apply the discount formula to each future cash flow:
Example with r = 10%:
Year 1: $30,000 / (1.10)¹ = $27,273
Year 2: $40,000 / (1.10)² = $33,058
Year 3: $50,000 / (1.10)³ = $37,566
4Sum All Present Values
Add up all the discounted cash flows from step 3:
Example:
Total PV = $27,273 + $33,058 + $37,566 = $97,897
5Subtract Initial Investment
Calculate NPV by subtracting the initial investment:
Final NPV:
NPV = $97,897 - $100,000 = -$2,103
❌ Since NPV is negative, this investment should be rejected.
Real-World NPV Example
Scenario: Should You Buy New Equipment?
Your company is considering purchasing new manufacturing equipment for $500,000. The equipment will generate cost savings over 5 years. Your company's WACC is 12%.
Cash Flows:
Year 0 (Initial):
-$500,000
Year 1 savings:
$150,000
Year 2 savings:
$175,000
Year 3 savings:
$200,000
Year 4 savings:
$180,000
Year 5 savings + resale:
$160,000
Discounted Cash Flows (12% rate):
Year 1 PV:
$133,929
Year 2 PV:
$139,551
Year 3 PV:
$142,360
Year 4 PV:
$114,397
Year 5 PV:
$90,799
Total PV:
$621,036
Final Decision:
NPV = $621,036 - $500,000 = $121,036
✅ Accept the investment! The positive NPV of $121,036 means this equipment purchase will create value for the company.
NPV Best Practices & Tips
✅ Do's
- • Use realistic cash flow projections
- • Include all relevant costs and benefits
- • Adjust discount rate for project risk
- • Consider terminal value for long projects
- • Perform sensitivity analysis
- • Account for taxes and working capital
❌ Don'ts
- • Don't ignore the time value of money
- • Don't use inconsistent time periods
- • Don't forget sunk costs (exclude them)
- • Don't rely solely on NPV - use multiple metrics
- • Don't use outdated discount rates
- • Don't ignore strategic intangibles
Frequently Asked Questions
What is the NPV formula?
The NPV formula is: NPV = Σ(Cash Flow_t / (1 + r)^t) - Initial Investment, where t is the time period, r is the discount rate, and Cash Flow_t is the cash flow at time t. This formula discounts all future cash flows to present value.
Can NPV be negative?
Yes, a negative NPV indicates the investment will destroy value and should typically be rejected. It means the project's cash flows, when discounted to present value, are less than the initial investment cost.
What discount rate should I use for NPV?
Use your company's WACC (Weighted Average Cost of Capital), required rate of return, or opportunity cost of capital. Typical ranges: 8-12% for established businesses, 15-25% for startups, higher for riskier projects.
Is higher NPV always better?
Generally yes, but consider: 1) Project size (larger projects naturally have higher NPV), 2) Capital constraints, 3) Risk profile, 4) Strategic fit. Sometimes a smaller NPV project with better risk-return profile is preferable.
Ready to Calculate Your NPV?
Now that you understand how NPV works, use our free calculator to analyze your investment opportunities instantly. No Excel required!
Related Resources
IRR Calculator →
Calculate Internal Rate of Return
ROI Calculator →
Measure Return on Investment
WACC Calculator →
Calculate Cost of Capital