NPV Calculator
Calculate the net present value of an investment.
For educational purposes only. This calculator does not provide investment advice.
📊 Visual Analysis
What This Calculator Does
The NPV Calculator computes the Net Present Value of an investment by discounting a series of future cash flows back to today's dollars and subtracting the initial investment. Enter the discount rate, initial investment, and projected annual cash flows to determine whether the investment creates value at the given discount rate.
Formula
Where:
- I = Initial investment (entered as a positive number)
- CFt = Cash flow in year t
- r = Discount rate (expressed as a percentage)
- t = Year number (1, 2, 3, ...)
The formula discounts each future cash flow by the discount rate raised to the power of the number of years in the future. Cash flows further in the future are discounted more heavily. The sum of all discounted cash flows minus the initial investment gives the NPV.
Input Fields Explained
Discount Rate (%)
The rate used to convert future cash flows into present value. This should reflect the risk of the investment and your opportunity cost. Higher discount rates reduce the present value of future cash flows, making it harder for a project to achieve a positive NPV.
Initial Investment ($)
The upfront cost of the investment. This is the cash outflow at time zero (today). Enter the total amount you need to spend to start the project or make the investment.
Annual Cash Flows (comma-separated)
The projected cash inflows for each year, separated by commas. For example, entering "30000,35000,40000,45000,50000" means $30K in year 1, $35K in year 2, and so on for 5 years. Enter net cash flows (inflows minus outflows) for each period.
Example Calculation
You invest $100,000 in a project with a 10% discount rate. Projected cash flows: $30,000, $35,000, $40,000, $45,000, $50,000 over 5 years.
PV of Year 1 = 30,000 ÷ 1.10 = $27,273
PV of Year 2 = 35,000 ÷ 1.21 = $28,926
PV of Year 3 = 40,000 ÷ 1.331 = $30,053
PV of Year 4 = 45,000 ÷ 1.4641 = $30,736
PV of Year 5 = 50,000 ÷ 1.6105 = $31,046
Total PV of cash flows = $148,034
NPV = 148,034 − 100,000 = $48,034
Interpretation: A positive NPV of $48,034 means the project is projected to generate $48,034 in value above the 10% required return. The investment appears worthwhile at this discount rate — but the result depends entirely on the accuracy of the cash flow projections and the appropriateness of the discount rate.
How to Read the Result
The investment is projected to earn more than the required return. The project creates value at the given discount rate.
The investment exactly meets the required return. It creates no additional value beyond what the discount rate demands.
The investment falls short of the required return. The project does not create value at the given discount rate.
Common Mistakes
- Choosing the wrong discount rate. The NPV result is highly sensitive to the discount rate. Using a rate that is too low overstates the NPV, while a rate that is too high understates it. Test multiple rates to understand how sensitive the result is to this assumption.
- Overestimating future cash flows. NPV calculations rely on projections that may not materialize. Optimistic cash flow assumptions can make a poor investment look attractive. Use conservative estimates and consider worst-case scenarios.
- Ignoring the timing of cash flows. NPV properly accounts for the time value of money, but only if cash flows are entered in the correct years. Delaying a large cash flow by even one year significantly reduces its present value.
- Comparing projects by NPV alone when sizes differ. A project with a $1M investment and $200K NPV is not necessarily better than one with a $100K investment and $50K NPV. The second project has a higher return on investment. Use profitability index or IRR alongside NPV.
- Assuming deterministic cash flows. Real-world cash flows are uncertain. A single NPV calculation with fixed inputs does not capture this uncertainty. Consider running sensitivity or scenario analysis.
When This Calculator Is Useful
- Evaluating whether a capital investment project creates value
- Comparing the financial attractiveness of different investment opportunities
- Estimating the value of a series of future income streams
- Performing discounted cash flow analysis for business valuation
Limitations
- Requires a discount rate assumption that is inherently subjective
- Assumes cash flows are certain and occur exactly as projected
- Does not reflect project scale — use profitability index for size comparisons
- Does not account for flexibility or the option to abandon/expand the project
- Sensitive to small changes in discount rate, especially for long-duration projects
- This calculator is for educational purposes only and does not constitute investment advice
Frequently Asked Questions
What is Net Present Value (NPV)?
NPV is the sum of all future cash flows discounted to their present value, minus the initial investment. A positive NPV means the investment is projected to generate value above the required return. A negative NPV means it falls short. NPV is one of the most widely used methods for evaluating investment opportunities.
What discount rate should I use?
The discount rate should reflect the risk of the cash flows and your opportunity cost. For corporate projects, the weighted average cost of capital (WACC) is commonly used. For personal investments, consider the return you could earn on a comparable-risk alternative. There is no single correct rate — different assumptions produce different NPV results, so sensitivity analysis is recommended.
NPV vs IRR — which is better?
NPV gives an absolute dollar value of value creation, while IRR gives a percentage return. NPV is generally preferred for comparing mutually exclusive projects because it accounts for scale. IRR can produce multiple values for non-conventional cash flows and may be misleading when comparing projects of different sizes. Using both together provides a more complete picture.
What happens if NPV is zero?
An NPV of zero means the investment's cash flows, when discounted at the chosen rate, exactly equal the initial investment. In other words, the investment earns exactly the required rate of return — no more, no less. This is the break-even point in present value terms.
Can NPV be used to compare projects of different sizes?
NPV alone does not account for project scale. A $1M project with an NPV of $100K creates more total value than a $100K project with the same NPV, but the smaller project has a much higher return relative to investment. For comparing projects of different sizes, use NPV alongside the profitability index (NPV divided by initial investment) or IRR.
🔧 Related Calculators
Educational Disclaimer
This calculator is for educational and informational purposes only. It does not provide investment, financial, tax, or legal advice. The results are based on the inputs and assumptions you provide and may not reflect real market conditions, fees, taxes, or risks. Always do your own research or consult a qualified professional before making financial decisions.