NPV Calculator
Calculate Net Present Value (NPV) of an investment from cash flows + discount rate. Accept/Reject verdict + year-by-year breakdown.
NPV Calculator
Future cash flows
How to use the NPV Calculator
Enter the initial investment
This is the upfront cost — what you pay in Year 0 to start the project. Entered as a positive number (the tool treats it as an outflow internally).
Pick a discount rate
The discount rate is your required return — the opportunity cost of capital. Use your WACC (Weighted Average Cost of Capital) if you have it. For personal investments, 8-10% is a common reference rate (long-term stock market real return). Higher rates are more demanding; the same cash flows produce a lower NPV.
List the expected cash flows
Year 1 to N — the cash flowing IN from the project each year. Five years are pre-loaded; use + Add another year to extend (no limit) or × to remove. Negative inflows? Enter them as negative numbers — the tool handles mid-life capex or losses.
Read the verdict
NPV > 0 → Accept the project (it creates value at your required return). NPV < 0 → Reject. The year-by-year breakdown shows each cash flow's present value — the more distant the year, the less the future dollar is worth today.
NPV — the corporate finance foundation
Net Present Value is the bedrock of corporate finance. It answers a deceptively simple question: given the time value of money, is this investment worth making? The math captures one elegant insight — a dollar received in five years is worth less than a dollar in your hand today, because the dollar you have now can be invested. NPV translates every future cash flow into "today's dollars" using a discount rate, then sums them all up against the initial cost. Positive total → the project creates value. Negative total → it destroys value. There is no more important decision rule in finance.
Where the discount rate comes from
The choice of discount rate is the single biggest lever in any NPV calculation. For a corporate investment, the standard reference is the company's Weighted Average Cost of Capital (WACC) — the blended cost of debt and equity, weighted by their proportions in the capital structure. For a US large-cap firm in 2026, WACC typically lands in the 7-10% range. For a small business or startup, WACC is higher (12-25%) reflecting equity holders' demand for higher returns on riskier ventures. For personal investments, common benchmarks are 8-10% (the long-term real return of a diversified equity portfolio) or your mortgage rate (the guaranteed return on prepaying debt instead).
Change the discount rate by 2 percentage points and the NPV of a 10-year project can shift by 30-40%. The discount rate is doing more work than most spreadsheet builders realise.
The APAC corporate finance use case
NPV is the foundational evaluation tool in every Singapore, Malaysia, and Indonesia CFO's toolkit when ranking capital projects against limited budgets. Vietnam's growth-stage corporates use it to evaluate infrastructure expansion; the Philippines' BPO industry uses it for facility decisions; Thailand's manufacturing sector uses it for equipment upgrades; Hong Kong's financial services use it across loan portfolios and investment products. Across the region, ASEAN discount rates tend to be higher than US/EU because of higher equity risk premiums — a Singapore WACC of 9-11% is common, Indonesian or Vietnamese WACC closer to 13-16%. The tool is generic — you choose the rate — so it works regardless of jurisdiction.
NPV vs IRR — when each one wins
NPV and IRR (Internal Rate of Return) are complementary tools that usually agree on accept/reject but can disagree on ranking when comparing mutually exclusive projects of different scales or different cash-flow timing. Use NPV when: choosing between projects of different sizes (NPV measures dollar value created); when cash flows change sign multiple times (IRR can produce multiple solutions); when you have an external benchmark rate. Use IRR when: communicating to non-finance stakeholders (a percentage is more intuitive); ranking projects of similar scale; when the absolute scale of value created is less important than the rate of return. The honest professional answer is: compute both, and prefer NPV when they disagree on ranking.
10 Things to Know About NPV
NPV was popularised by Irving Fisher in his 1907 book "The Rate of Interest" — though the underlying time-value-of-money math dates back to medieval merchant guilds.
The 2-percentage-point sensitivity rule: changing the discount rate by 2pp typically shifts NPV by 30-40% for 10-year projects. Always run a sensitivity analysis.
NPV rule: positive = accept, negative = reject. It's the only universally-correct decision rule in corporate finance — every other rule (payback, accounting return) has edge cases where it gives wrong answers.
WACC ranges by industry: utilities 4-6%, mature consumer 7-9%, tech 9-13%, early-stage biotech 18-25%. Higher risk → higher required return → harder to clear the NPV bar.
Terminal value in real-world DCF: after the explicit forecast period (usually 5-10 years), analysts add a "terminal value" computed via Gordon growth or exit multiple — often 60-80% of total NPV in long-life assets.
Public sector NPV: governments often use lower "social discount rates" (3-5%) to value long-horizon infrastructure projects more favourably. UK Treasury uses 3.5%, US OMB uses 3-7%.
Inflation: NPV in real dollars uses real discount rate; NPV in nominal dollars uses nominal rate. Mixing them is the single most common DCF mistake in finance interviews.
Risk-free rate as floor: NPV at the risk-free rate (US Treasury yield) is the minimum bar for ANY positive-NPV claim. Below that, you're better off in T-bills.
Real options valuation extends NPV: the right but not obligation to expand, delay, or abandon adds option value that static NPV misses. Mining and biotech use it routinely.
NPV is in every CFA, MBA, ACCA, and CPA curriculum globally. Master it once — the math hasn't changed since Irving Fisher.
Frequently Asked Questions
-
For corporate projects: your company's WACC (typically 7-12% for established firms). For personal investments: 8-10% (long-term real stock market return) or your mortgage rate (debt-paydown alternative). For risk-free comparison: the 10-year Treasury / SGS yield. Sensitivity-test 2pp above and below your base case.
-
Enter it as positive — the tool treats it as a Year 0 outflow internally. The breakdown table shows it as a negative present value to make the math transparent. If you have additional capex in years 1-N, enter those as negative cash flows in the relevant year.
-
NPV measures dollar value created accounting for time value of money. ROI (Return on Investment) is total return ÷ investment, ignoring timing. Payback period is "how many years until I get my money back" — ignores cash flows after payback and ignores time value. NPV is the only metric that handles both timing AND total value correctly.
-
Yes — when the initial investment is large enough and the discount rate is high enough, even all-positive future cash flows can produce a negative NPV. That's the tool telling you: at your required return, this project doesn't pay back. Try lowering the discount rate or increasing the cash flows to see what would make it positive.
-
Two approaches. Real method: enter cash flows in today's dollars, use real discount rate (nominal − inflation). Nominal method: enter inflated cash flows, use nominal discount rate. Both give the same answer if done consistently. Mixing them (real cash flows with nominal rate, or vice versa) is the single most common DCF mistake.
-
Use Add Year to extend out to the project horizon. For very long-lived assets (infrastructure, real estate, perpetuities), practitioners often forecast 5-10 years explicitly then add a "terminal value" — usually computed via Gordon growth model: TV = CF_final × (1 + g) ÷ (r − g). Add the terminal value to the final year's cash flow.
-
Use after-tax cash flows for project NPV. The tax shield from interest (if debt-financed) is reflected in the WACC's after-tax cost of debt, so the cash flows you discount should be operating cash flows after tax (often "free cash flow to firm"). Mixing pre-tax cash flows with after-tax WACC double-counts the tax effect.
-
Prefer NPV when: (1) comparing mutually exclusive projects of different scales — NPV measures absolute value created; (2) cash flows change sign multiple times — IRR can produce multiple solutions; (3) the discount rate changes over time. IRR is more intuitive for communication (percentages travel better than dollar values) but NPV is the more reliable decision rule when they disagree.
-
Yes. Initial investment is Year 0. Additional outflows in later years can be entered as negative cash flows in those years. So if you have $50K upfront then a $20K expansion investment in Year 3, enter $50K initial + Year 3 cash flow as (operating_cf − 20000).
-
No. All calculation happens entirely in your browser via JavaScript. Open DevTools → Network and watch — there's zero outbound traffic. This makes the tool safe for confidential investment evaluations and competitive financial modelling.
Related News
You may be interested in these recent stories from our newsroom.
-
Snowflake jumps 36 per cent in a day on an earnings beat and a US$6 billion AWS chip deal
Snowflake had its best day as a public company on 28 May, closing up 36 per cent after a clean first-quarter beat and a five-year, US$6 bill...
-
MAS Scraps Mandatory Financial Advice for Most Complex Product Buyers in Retail Shake-Up
Singapore retail investors buying structured notes, derivatives and investment-linked policies will no longer need mandatory financial advic...
-
SEC Rewrites Float Rules, PSE Moves to Implement Them — Clearing the Path for GCash's USD 1B Philippine IPO
The SEC lowered the public float floor for large Philippine issuers in February 2026. The PSE followed with a consultation paper in April. T...
75 more free tools
Calculators, converters, security tools — no signup.