finance calculator

Net Present Value (NPV) Calculator

Discount projected cash flows back to today’s dollars, subtract the upfront investment, and see in one number whether a project creates or destroys value at your chosen hurdle rate.

Results

Net present value
$308

Overview

Net present value (NPV) is the workhorse metric for deciding whether a project, deal, or investment is worth doing. Instead of just looking at payback or a simple ROI, NPV takes your expected future cash flows, discounts them back to today’s dollars using a required rate of return, and then subtracts the upfront investment. A positive NPV means the project is expected to create value above your hurdle rate; a negative NPV means it falls short.

How to use this calculator

  1. Choose a discount rate that reflects your required return or opportunity cost of capital—this might be your WACC for a company or an expected portfolio return in a personal context.
  2. Enter the initial investment as a positive number in the input field; the calculator treats it as an outflow at time 0 when computing NPV.
  3. Enter your projected net cash flows for each year from year 1 through year 4. These can be positive (net inflows) or negative (net additional investments or losses).
  4. Review the resulting NPV. A positive NPV suggests the project clears your hurdle rate; a negative NPV suggests it does not create enough value given the risk and discount rate you chose.
  5. Experiment with different discount rates, cash flow patterns, and project horizons (using the available years) to see how sensitive NPV is to changes in assumptions.

Inputs explained

Discount rate %
Your required annual rate of return or hurdle rate. In corporate finance this is often the weighted average cost of capital (WACC); for personal projects it might be the return you expect from alternative investments.
Initial investment
The upfront cost of the project at time 0. Enter it as a positive number; the calculator internally treats it as an outflow when computing NPV.
Year 1–4 cash flows
Projected net cash flows at the end of each year. These should be after operating expenses and any additional capital expenditures you expect in that year. You can enter negative values if you anticipate future reinvestment or losses.

How it works

You provide three key inputs: a discount rate (your required return or hurdle), an initial investment amount (usually a negative cash flow at time 0), and up to four annual net cash flows for the project.

For each future year t, we discount that year’s cash flow back to the present by dividing it by (1 + rate)^t. This reflects the idea that a dollar received later is worth less than a dollar received today.

We sum all of the discounted future cash flows and then subtract (or equivalently add the negative of) the initial investment to arrive at net present value: NPV = −Initial investment + Σ CF_t ÷ (1 + r)^t.

If the resulting NPV is greater than zero, the project is expected to earn more than the discount rate and is considered value‑creating under the assumptions. If NPV is exactly zero, it is right on the margin; a negative NPV means it is expected to underperform your required return.

Because the discount rate and the timing/size of cash flows matter, two projects with the same total undiscounted cash flows can have very different NPVs if one pays out sooner or has more risk baked into the rate.

Formula

NPV = −I₀ + Σ (CFₜ ÷ (1 + r)^t)

Where:
I₀ = Initial investment at time 0
CFₜ = Cash flow at the end of year t
r = Discount rate (annual)
t = Year index (1, 2, 3, …)

When to use it

  • Screening capital projects, new product launches, or real estate deals against a hurdle rate to decide which ones to pursue.
  • Comparing mutually exclusive projects that have the same total cash flow but different timing profiles, where ROI or payback alone might be misleading.
  • Running quick sensitivity analysis by tweaking the discount rate, individual cash flows, or project length to see how robust the NPV is to changes.
  • Evaluating small business investments, side projects, or equipment purchases when you want to know if they beat your alternative investment options.

Tips & cautions

  • Include future negative cash flows for major capital expenditures, working capital build, or known repair/upgrade cycles so NPV reflects the full cost of the project.
  • Use a discount rate that matches project risk: higher‑risk projects should be discounted at higher rates than low‑risk ones.
  • If your project horizon is longer than four years, approximate a terminal value or move to a spreadsheet with more explicit year‑by‑year modeling.
  • Remember that NPV is additive: the NPV of a combined set of independent projects is the sum of their individual NPVs, which can help with portfolio‑level decisions.
  • Look at both the absolute NPV and NPV relative to the initial investment to get a sense of both total value created and efficiency.
  • The calculator supports four annual cash flows; projects with longer horizons or irregular timing may need a spreadsheet or a terminal value approximation.
  • Assumes all cash flows occur at the end of each year and uses a constant annual discount rate; mid‑year timing or changing rates are not modeled.
  • Taxes, financing structure, depreciation, and working capital changes are not modeled explicitly unless you bake them into the cash flows you enter.
  • Risk is collapsed into a single discount rate. In reality, different cash flows may have different risk profiles, which this simplified calculation does not capture.

Worked examples

10% discount, $10k spend, 3 years of $4k

  • Discount rate r = 10% (0.10); Initial investment I₀ = $10,000.
  • Year 1 PV = 4,000 ÷ (1.10)^1 ≈ $3,636.
  • Year 2 PV = 4,000 ÷ (1.10)^2 ≈ $3,305.
  • Year 3 PV = 4,000 ÷ (1.10)^3 ≈ $3,004.
  • Sum of PVs ≈ 3,636 + 3,305 + 3,004 ≈ $9,945.
  • NPV ≈ −10,000 + 9,945 ≈ −$55 (slightly negative, roughly breakeven after rounding).

8% discount with same cash flows

  • Now use r = 8%. Year 1 PV ≈ 4,000 ÷ 1.08 ≈ $3,704.
  • Year 2 PV ≈ 4,000 ÷ (1.08)^2 ≈ $3,431.
  • Year 3 PV ≈ 4,000 ÷ (1.08)^3 ≈ $3,177.
  • Sum of PVs ≈ 3,704 + 3,431 + 3,177 ≈ $10,312.
  • NPV ≈ −10,000 + 10,312 ≈ $312 (positive, passes the 8% hurdle).

Including a negative cash flow in year 2

  • Initial investment I₀ = $50,000; r = 9%.
  • Year 1 CF = +$20,000; Year 2 CF = −$5,000 (additional CapEx); Year 3 CF = +$30,000; Year 4 CF = +$25,000.
  • Enter these values and review NPV to see whether the project still clears a 9% hurdle once the extra CapEx is accounted for.

Deep dive

This NPV calculator discounts your future cash flows at a chosen hurdle rate and subtracts the upfront investment to show whether a project is expected to create or destroy value.

Enter discount rate, initial spend, and up to four yearly cash flows to compute net present value and quickly screen capital projects, real estate deals, or business ideas.

Use negative cash flows for future capital expenditures and consider adding a terminal value to the final year if your project extends beyond the calculator’s horizon.

FAQs

What discount rate should I use?
Use your weighted average cost of capital (WACC) or opportunity cost of capital. For personal projects, use expected investment returns.
Can I add more years?
Duplicate the cash-flow inputs or move the calculation to a spreadsheet for longer timelines.
How is NPV different from ROI or payback?
NPV discounts timing and risk via the rate, while ROI/payback ignore time value and uneven timing.
Does sign convention matter?
Yes. The tool treats the initial investment as an outflow and cash flows as inflows unless you enter them negative.
Can I include a terminal value?
Yes—add it to the final year’s cash flow to approximate value beyond the modeled period.

Related calculators

This NPV calculator uses a simplified annual cash-flow model with a constant discount rate and end-of-year timing. It does not incorporate detailed tax, financing, or accounting treatment and should be used for educational planning and quick screening only. For high-stakes decisions, build a full model in a spreadsheet and consult financial professionals.