Ex-PwC Chartered Accountants
|
CA & ACCA Certified
|
Top Rated Plus on Upwork (4.9★, 115 reviews)
|
100+ US Businesses Served

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.

$
%
$
$13,724
Net Present Value
Creates Value
Verdict
1.14
Profitability Index
$150,000
Total Cash Flows
Free Download · No spam

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 Investment

where 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 →
Ex-PwC · CA & ACCA Certified · 4.9★ on Upwork (115 reviews) · 100+ US Businesses Served

Frequently Asked Questions

What is a good NPV?
Any positive NPV means the investment is expected to earn more than your required return, creating value. Between options of similar risk and size, the higher NPV is generally the better choice.
What discount rate should I use for NPV?
Use a rate that reflects your cost of capital or required return — often your WACC. A higher discount rate lowers NPV. The right rate depends on the risk of the cash flows.
What is the difference between NPV and IRR?
NPV gives a dollar value of how much an investment creates above your discount rate. IRR gives the percentage return at which NPV equals zero. NPV is generally preferred for choosing between projects of different sizes.
What is the profitability index?
The profitability index is the present value of future cash flows divided by the initial investment. Above 1.0 means positive NPV; it helps compare projects when capital is limited.
Why discount future cash flows?
Because money has a time value — a dollar today can be invested to earn a return, so a future dollar is worth less. Discounting converts future cash flows into today's equivalent so they can be fairly compared to the upfront cost.

Related Free Tools

Book a Free Call →