NPV Calculator (Net Present Value)
Use this free NPV calculator to find the net present value of an investment. Enter your initial investment, discount rate, and yearly cash flows to see whether the project creates value — plus its NPV, total cash flows, and profitability index.
Get the Free Small Business Finance Toolkit
The same templates our Ex-PwC CFOs use with 100+ clients: a 13-Week Cash Flow Forecast and a 12-Month Budget (Excel). Enter your email and download instantly.
How to Use This NPV Calculator
- Initial Investment — the upfront cash outlay.
- Discount Rate — your required return or cost of capital (often your WACC).
- Number of Years — how many years of cash flows to model.
- Cash Flows — enter each year individually, or use the auto-fill for equal yearly amounts.
What Is Net Present Value (NPV)?
Net present value is the value an investment creates after accounting for the time value of money. It discounts every future cash flow back to today\'s dollars at your chosen rate, sums them, and subtracts the initial investment. The logic is simple but powerful: a dollar received in three years is worth less than a dollar today, so future returns must be discounted before you can fairly compare them to what you spend now.
The decision rule is clean. A positive NPV means the investment is expected to earn more than your required return — it creates value, and you should consider it. A negative NPV means it falls short and destroys value. Between competing projects, the higher NPV is generally better. Because it accounts for both timing and your cost of capital, NPV is the gold-standard metric in corporate finance for capital budgeting and is the foundation of discounted cash flow (DCF) valuation.
NPV Formula
NPV = Σ [ Cash Flow_t ÷ (1 + r)^t ] − Initial Investmentwhere
r = discount rate, t = year
Example Calculation
Invest $100,000, discount rate 10%, receiving $30,000 per year for 5 years:
- Present value of the five $30,000 cash flows ≈ $113,724
- NPV = $113,724 − $100,000 ≈ $13,724
- Positive NPV → the project creates value at a 10% required return
Common Mistakes to Avoid
- Using the wrong discount rate. Too low overstates NPV; your rate should reflect real opportunity cost (often WACC).
- Forgetting the initial investment\'s timing. The upfront cost is at year 0 and is not discounted.
- Being over-optimistic on cash flows. NPV is only as good as the projections behind it — stress-test them.
- Ignoring risk differences. Riskier projects deserve a higher discount rate, not the company average.
NPV for Startups & Business Decisions
NPV is the right tool whenever you are deciding whether a significant investment is worth it — new equipment, a product line, an acquisition, or a major project. It forces discipline: instead of "this feels worth it," you ask whether the discounted returns beat the cost of capital. Investors and lenders expect this rigor, and it is the engine of any DCF valuation.
Choosing the right discount rate and building credible cash flow projections is exactly what our financial modeling team does. If you are evaluating a major investment or preparing a valuation, a free call is a fast way to pressure-test your numbers.
Need help interpreting these numbers?
Our Ex-PwC Chartered Accountants help US startups and small businesses turn calculations like this into real financial strategy — pricing, cash flow, fundraising, and growth decisions.
Book a Free 30-Min Call →