Net Present Value Calculator
Cash Flows by Year
Step-by-Step Calculation
Enter your investment details and cash flows above to see a complete NPV analysis.
| Year | Cash Flow | Discount Factor | Present Value | Cumulative PV |
|---|
Your guide to net present value
Net Present Value (NPV) is a financial metric used to evaluate the profitability of an investment or project. It calculates the difference between the present value of cash inflows and the present value of cash outflows over a period of time. NPV helps investors and business owners make better decisions by showing whether an investment will create or destroy value.
What is net present value?
Net Present Value is the sum of all future cash flows (both incoming and outgoing) discounted to today's value, minus the initial investment. A positive NPV means the investment is expected to create value. A negative NPV means the investment is expected to lose value. NPV is widely used in capital budgeting and investment analysis.
The NPV formula
The formula for NPV is:
Where:
- CFt = Cash flow at time t
- r = Discount rate (required rate of return)
- t = Time period (year)
NPV decision rules
- NPV > 0: ✅ Accept the investment. It creates value.
- NPV = 0: ⚞ Neutral. The investment breaks even.
- NPV < 0: ❌ Reject the investment. It destroys value.
NPV comparison at different discount rates
Here's how an investment with $50,000 initial investment and cash flows of $15,000, $18,000, $20,000, $22,000, $25,000 over 5 years changes at different discount rates:
| Discount Rate | NPV | Profitability Index | Decision |
|---|---|---|---|
| 5% | $23,041 | 1.46 | ✅ Accept |
| 8% | $13,722 | 1.27 | ✅ Accept |
| 10% | $8,125 | 1.16 | ✅ Accept |
| 12% | $3,258 | 1.07 | ✅ Accept |
| 15% | ($3,245) | 0.94 | ❌ Reject |
| 20% | ($12,873) | 0.74 | ❌ Reject |
Higher discount rates reduce the present value of future cash flows, making the NPV lower. The break-even discount rate (where NPV = 0) is called the Internal Rate of Return (IRR).
Comparing two investment options
Here's a comparison of two investment options with the same initial investment ($100,000) but different cash flow patterns (at 8% discount rate):
| Year | Option A Cash Flow | Option A PV | Option B Cash Flow | Option B PV |
|---|---|---|---|---|
| 1 | $30,000 | $27,778 | $10,000 | $9,259 |
| 2 | $30,000 | $25,720 | $20,000 | $17,147 |
| 3 | $30,000 | $23,815 | $30,000 | $23,815 |
| 4 | $30,000 | $22,051 | $40,000 | $29,402 |
| 5 | $30,000 | $20,417 | $50,000 | $34,029 |
| Total PV | $119,781 | $113,652 | ||
| NPV | $19,781 | $13,652 | ||
Option A has higher NPV ($19,781 vs $13,652) and is the better investment, even though both have positive NPVs. This shows how NPV helps compare different investment opportunities.
How to use this calculator
- Set your currency: Type your preferred symbol (e.g., $, €, £, ₹).
- Enter initial investment: The amount you're investing today.
- Enter discount rate: Your required rate of return.
- Add cash flows: Enter the expected cash flows for each year.
- Click calculate: See your NPV, PI, payback period, and decision.
Understanding your results
- NPV: The net present value of the investment.
- Profitability Index (PI): Total PV divided by initial investment. PI > 1 means good investment.
- Payback Period: How long it takes to recover the initial investment.
- Decision: Whether to accept or reject the investment.
- Yearly breakdown: Shows cash flows, discount factors, and present values.
Example: Evaluating a business investment
You are considering investing $50,000 in a small business. The projected annual cash flows are $15,000, $18,000, $20,000, $22,000, and $25,000 over 5 years. Your required rate of return is 8%.
- Initial Investment: $50,000
- Discount Rate: 8%
- Cash Flows: $15k, $18k, $20k, $22k, $25k
NPV = $13,722 (positive)
PI = 1.27 (>1)
Payback Period: ~3.1 years
Decision: ✅ Accept. This investment creates over $13,700 in value and pays back in just over 3 years.
When to use NPV
- Capital budgeting: Evaluating large business investments.
- Project evaluation: Comparing different project options.
- Business acquisition: Determining the value of buying a business.
- Real estate: Evaluating rental property investments.
- Startup analysis: Assessing new business opportunities.
Common mistakes to avoid
- Ignoring the discount rate: The discount rate is critical to NPV.
- Using the wrong discount rate: Use the cost of capital or required return.
- Forgetting initial investment: Always include the full initial cost.
- Including sunk costs: Only consider future cash flows, not past costs.
- Ignoring risk: Higher risk should use a higher discount rate.
Final thoughts
Net Present Value is one of the most important tools in financial decision-making. It helps you evaluate whether an investment is worth pursuing by accounting for the time value of money. By using this calculator, you can make better investment decisions, compare different options, and build wealth more effectively. Remember, a positive NPV means you're creating value, and that's what smart investing is all about.