What Is Net Present Value (NPV)? Formula, Calculation, and How to Use It
NPV answers the one question every investment decision comes down to: is this project worth more than it costs? Here's the formula, a full worked example, and how to actually use it.
Table of Contents
What Is Net Present Value?
Every business decision that involves spending money today to earn money tomorrow is essentially a bet on the future. Net Present Value — NPV — is the mathematical framework that tells you whether that bet is a good one.
NPV is the difference between the present value of all future cash inflows a project generates and the cost of the initial investment. In plain terms: it converts every future cash flow into what it would be worth in today's money, adds them all up, and subtracts what you paid to get those cash flows. If the result is positive, you've created value. If it's negative, you've destroyed it.
NPV is used everywhere that capital allocation decisions are made: a manufacturer evaluating whether to buy new equipment, a CFO deciding which of three expansion projects to fund, a private equity firm modelling an acquisition, an infrastructure investor pricing a 20-year toll road. The core logic is always the same — translate future money into present money, then subtract what it costs.
What makes NPV particularly powerful is that it accounts for both the magnitude of cash flows and their timing. A project that pays ₹50 lakh five years from now is worth less than one that pays ₹50 lakh next year — not because the numbers differ, but because money available sooner can be reinvested, spent, or saved. That's the foundation NPV is built on.
Why Money Today Is Worth More Than Money Tomorrow
Before you can calculate NPV, you need to genuinely understand the principle that drives it: the time value of money. It sounds like finance jargon, but the intuition is entirely everyday.
Imagine someone offers you two options: receive ₹1,00,000 today, or receive ₹1,00,000 exactly one year from now. Most people would take the money today — and for good reason. Money in hand right now can be invested. Even a conservative fixed deposit yielding 6.5% turns ₹1,00,000 into ₹1,06,500 in 12 months. So waiting a year to receive the same amount means you've quietly given up ₹6,500 in potential earnings.
A rupee today is worth more than a rupee tomorrow — not because of inflation, but because of what it can become.
This is the core mechanism. When a project promises to return ₹1,00,000 in Year 3, you don't value that at ₹1,00,000 in today's terms. You ask: what lump sum, invested today at my required rate of return, would grow into ₹1,00,000 by Year 3? That lump sum is the present value of that cash flow.
The formula for present value of a single cash flow is:
Where CF = the future cash flow, r = the discount rate (your required rate of return), and n = the number of years until the cash flow is received.
Using a 10% discount rate: ₹1,00,000 received in Year 3 is worth only ₹75,131 today. That's the present value. NPV chains this logic across every year of a project's life, then nets out the initial cost.
Compounding moves money forward in time (how much will ₹100 be worth in 5 years?). Discounting moves money backward (what is ₹100 in 5 years worth today?). NPV is built entirely on discounting — turning future cash into present-day equivalents.
The NPV Formula
The full NPV formula extends the present value logic across multiple time periods and subtracts the initial investment:
C₀ = initial investment (written as negative because it's a cash outflow). CF₁, CF₂ ... CFₙ = net cash flows in each period. r = discount rate. n = total number of periods.
In compact sigma notation this is often written as:
Where t runs from 1 to n. The summation discounts each period's cash flow back to today, and C₀ is subtracted at the end.
Every term in the formula has a direct, intuitive meaning:
| Term | What It Represents | Practical Example |
|---|---|---|
| C₀ | Initial investment outflow | ₹80 lakh paid today for new equipment |
| CFₜ | Net cash flow in period t | Revenue minus operating costs each year |
| r | Discount rate (required return) | Company's WACC of 11% |
| t | Time period | Year 1, Year 2, Year 3 … |
| (1+r)ᵗ | Discount factor for period t | 1.11¹ = 1.110 for Year 1 at 11% |
| NPV | Value created (or destroyed) in today's money | +₹12.4 lakh → project creates value |
The discount rate r is doing most of the heavy lifting. It embeds your minimum required return — which for a company is typically its Weighted Average Cost of Capital (WACC). If a project can't clear that hurdle after discounting, it doesn't create shareholder value even if it's nominally profitable.
How to Calculate NPV: Step by Step
Calculating NPV is a four-step process. Each step is straightforward — the complexity lies in the quality of your inputs, not the arithmetic.
Identify the initial investment (C₀)
This is every cash outflow required at the start: purchase price, installation costs, working capital tied up, licensing fees, training. Do not include sunk costs — only future outlays. Write this as a negative number; it's money leaving the business today.
Forecast the periodic cash flows (CF₁ to CFₙ)
Project the net cash inflow each period: revenue generated minus operating costs attributable to the project. Use after-tax, incremental cash flows — only what changes because of this project. Exclude financing costs (they're captured in the discount rate) and non-cash items like depreciation (unless it affects tax).
Choose the discount rate (r)
For a corporate project, the standard choice is the company's WACC. For a riskier project, add a risk premium on top. For personal investment decisions, use your opportunity cost — what you'd earn on the next-best alternative. The discount rate is the single most consequential input in the model; a 2-percentage-point difference can flip a project from positive to negative NPV.
Discount each cash flow and sum
Divide each period's cash flow by (1 + r)ᵗ, where t is the year number. Add all the discounted cash flows together. Subtract the initial investment. The result is NPV. If positive, the project clears the hurdle. If negative, it doesn't — at this discount rate.
In Excel or Google Sheets, the =NPV(rate, CF1:CFn) function discounts a range of cash flows automatically. Importantly, it does NOT include C₀ — so the full formula is =NPV(rate, CF1:CFn) + C₀ where C₀ is a negative number in your cell. This is the most common NPV spreadsheet error to avoid.
Worked Example: A Manufacturing Upgrade
Prism Plastics is evaluating an upgrade to its injection moulding line. The new machines cost ₹95 lakhs to purchase and install. Management forecasts the upgrade will generate ₹28 lakhs in Year 1, ₹33 lakhs in Year 2, ₹36 lakhs in Year 3, ₹34 lakhs in Year 4, and ₹29 lakhs in Year 5 — after which the equipment is fully depreciated and sold for scrap. The company's WACC is 10%.
Should Prism Plastics make this investment?
| Step 1 — Calculate Discount Factors: 1 ÷ (1.10)ⁿ | |||
| Year | Cash Flow (₹ Lakhs) | Discount Factor | Present Value (₹ Lakhs) |
| 1 | 28.00 | 1 ÷ 1.10¹ = 0.9091 | 25.45 |
| 2 | 33.00 | 1 ÷ 1.10² = 0.8264 | 27.27 |
| 3 | 36.00 | 1 ÷ 1.10³ = 0.7513 | 27.05 |
| 4 | 34.00 | 1 ÷ 1.10⁴ = 0.6830 | 23.22 |
| 5 | 29.00 | 1 ÷ 1.10⁵ = 0.6209 | 18.01 |
| Sum of Discounted Cash Flows | ₹121.00 Lakhs | ||
| Step 2 — Subtract Initial Investment | |||
| Initial Investment (C₀) | −₹95.00 Lakhs | ||
| Net Present Value | +₹26.00 Lakhs ✓ | ||
The NPV of +₹26 lakhs means this investment creates ₹26 lakhs of value in today's money, above and beyond Prism Plastics' 10% required return. Over five years, the total undiscounted cash inflows sum to ₹160 lakhs — but once the time cost of money is applied, they're worth ₹121 lakhs in present-day terms. That still exceeds the ₹95 lakh cost by a comfortable margin, so the project clears the hurdle. Management should proceed.
Interpreting a Positive or Negative NPV
The decision rule for NPV is one of the cleanest in all of finance. There are exactly three outcomes:
A common confusion: a negative NPV does not mean the project loses money in nominal terms. Prism Plastics collects ₹160 lakhs over five years against a ₹95 lakh investment — that's a healthy ₹65 lakh profit on paper. But once you account for the time value of money at 10% per year, those future payments are worth only ₹121 lakhs in today's terms. The project is still profitable by NPV standards, but if the discount rate were raised to — say — 22%, the present value of cash flows would fall below ₹95 lakhs and the NPV would turn negative.
That's a crucial nuance: NPV is not an absolute measure of profit. It is a measure of excess return above your hurdle rate. A project with NPV = 0 still returns all your capital with the required rate of return — it just creates no surplus. Whether that's acceptable depends on strategic context, not just the number.
If you must choose between two projects and both have positive NPVs, always pick the one with the higher NPV — not the higher percentage return. NPV measures absolute value creation in currency terms. A project returning ₹40 lakhs NPV on a ₹200 lakh investment beats one returning ₹25 lakhs on a ₹50 lakh investment if capital isn't constrained, because the larger project creates more total value for shareholders.
NPV vs. IRR vs. Payback Period
NPV doesn't operate in isolation. In practice, capital budgeting teams use multiple metrics. Understanding where each one succeeds and fails helps you use them together intelligently.
| Metric | What It Measures | Decision Rule | Key Weakness |
|---|---|---|---|
| NPV | Absolute value created in today's money | Accept if NPV > 0; maximise NPV among alternatives | Doesn't show return as a %; harder to compare projects of different scales |
| IRR | The discount rate at which NPV = 0 (the project's internal return) | Accept if IRR > required return (hurdle rate) | Can produce multiple IRRs with non-conventional cash flows; can mislead when comparing unequal-scale projects |
| Payback Period | How many years to recover the initial investment | Accept if payback < company's maximum threshold | Ignores time value of money entirely; ignores all cash flows after payback date |
| Discounted Payback | Years to recover initial investment using discounted cash flows | Accept if discounted payback < threshold | Still ignores cash flows after the payback date; less intuitive than IRR |
IRR is the discount rate that makes NPV exactly zero — it's the project's own rate of return. In Prism Plastics' example, the IRR is approximately 24.8%, well above the 10% hurdle rate. That's consistent with the positive NPV: if the project earns 24.8% internally and you only require 10%, there's a significant value surplus.
The practical hierarchy: NPV is the gold standard for corporate capital allocation because it directly answers "how much value does this create?" IRR is useful as a communication shorthand (executives relate to percentages) and as a sensitivity check. Payback period is a rough liquidity proxy — useful in early-stage screening or in businesses with very uncertain long-term forecasts — but it should never be the primary decision metric because it ignores the time value of money and cuts off analysis at an arbitrary date.
WACC is the most commonly used discount rate in corporate NPV analysis. Understanding how it's calculated — and how the mix of debt and equity changes it — helps you make more accurate NPV models. See the What Is WACC? article for a full explanation with worked examples.
The Discount Rate: The Key Assumption
Of all the inputs in an NPV model, the discount rate has the largest effect on the outcome. Get it wrong — even slightly — and the model may approve bad projects or reject good ones.
The discount rate serves as the hurdle. It answers: "What return does this capital deserve?" Three frameworks are used depending on context:
WACC (Weighted Average Cost of Capital)
The most common corporate choice. WACC blends the cost of equity and the after-tax cost of debt in proportion to the capital structure. Use WACC when the project has the same risk profile as the company's existing operations. Riskier projects need a higher discount rate — adding a project-specific risk premium on top of WACC is standard practice.
Opportunity Cost Rate
For personal investment decisions or scenarios without a formal WACC, use the return you could earn on the next-best alternative of comparable risk. If you can reliably earn 8.5% in a diversified equity fund, that's your opportunity cost — any project must beat 8.5% NPV-positive to be worth pursuing over simply investing in the fund.
Hurdle Rate
Some companies set a fixed internal hurdle rate above WACC — say 15% — for all new projects, building in a buffer for forecasting uncertainty. This is pragmatic in businesses with lumpy or uncertain cash flows. The trade-off: it rejects some genuinely positive-NPV projects that fall between WACC and the hurdle.
How the Discount Rate Changes the Outcome
Back to Prism Plastics. Let's see what happens to NPV as the discount rate changes:
| Discount Rate | Sum of Discounted CFs (₹L) | Less: Initial Investment (₹L) | NPV (₹L) | Decision |
|---|---|---|---|---|
| 6% | 135.85 | 95.00 | +40.85 | Accept |
| 10% | 121.00 | 95.00 | +26.00 | Accept |
| 15% | 105.22 | 95.00 | +10.22 | Accept |
| 20% | 91.70 | 95.00 | −3.30 | Reject |
| 24.8% (≈ IRR) | 95.00 | 95.00 | 0.00 | Indifferent |
Notice that at a 15% discount rate, the NPV is still positive — the project survives even if Prism Plastics raises its hurdle. But at 20%, the NPV flips negative. The IRR of ~24.8% is the tipping point: any rate above that destroys the NPV. This is exactly why IRR is described as "the discount rate at which NPV = 0."
This sensitivity analysis also reveals a useful stress-test: if you're unsure whether your 10% WACC is right, calculate NPV at 12%, 15%, and 18%. If the NPV stays comfortably positive across all three scenarios, you have a robust project. If it goes negative at 14%, you're betting heavily on the accuracy of your discount rate estimate — and that warrants more scrutiny.
Common Misconceptions About NPV
NPV is widely used but also widely misunderstood. Here are the most persistent misconceptions, and why they matter:
Key Takeaways
- NPV = present value of future cash flows − initial investment — a single number measuring how much value a project creates in today's money.
- A positive NPV means proceed — the project earns more than the required return. A negative NPV means reject — not because it loses money, but because it doesn't earn enough relative to the time cost of capital.
- The discount rate is the most influential input — even a 2–3 percentage point change can flip NPV from positive to negative. Always run a sensitivity analysis.
- Use after-tax, incremental cash flows — exclude sunk costs, non-cash items (except where they affect tax), and financing costs (these are embedded in the discount rate).
- NPV beats IRR for comparing unequal-scale projects — when you must choose between projects with different investment sizes, maximise NPV in currency terms, not IRR as a percentage.
- NPV is not a forecast — it's a model — the output is only as reliable as the cash flow projections and discount rate you feed in. Treat it as a structured decision tool, not an oracle.
Quick Quiz
Four questions to check your understanding. Click an answer to reveal the explanation.
1. A project has an initial investment of ₹50 lakhs and generates discounted cash flows totalling ₹62 lakhs over its life. What is its NPV?
2. The discount rate used in NPV analysis is most often set equal to:
3. Prism Plastics raises its discount rate from 10% to 22%. Based on the sensitivity table in this article, what happens to the project's NPV?
4. A project earns ₹40 lakhs in nominal cash profit over three years on a ₹30 lakh investment, but has a negative NPV of −₹5 lakhs. The correct interpretation is: