Net Present Value
Net present value (NPV) is the value today of an investment's future cash flows minus its upfront cost. Learn the formula, a worked example and how to read it.
Contents
Net present value (NPV) is the difference between what an investment costs today and what its future cash flows are worth today. Each expected cash flow is discounted back to the present at a rate that reflects the return investors require, those present values are added up, and the initial outlay is subtracted. A positive NPV means the investment is expected to earn more than that required return; a negative NPV means it falls short.
Because it accounts for the time value of money, NPV is the standard yardstick for capital budgeting decisions such as buying equipment, launching a product or acquiring a business. It is the central calculation behind discounted cash flow (DCF) analysis.
NPV formula
NPV = Σ [CFt ÷ (1 + r)t] − C0
- CFt is the net cash flow expected in period t (inflows minus outflows).
- r is the discount rate per period, typically the company's weighted average cost of capital (WACC) or a project-specific required rate of return.
- t is the number of periods until the cash flow arrives.
- C0 is the initial investment, paid today and therefore not discounted.
Each term in the sum is the present value of one cash flow. NPV is simply the total present value of the cash flows less what you pay to get them.
How to calculate NPV
- Forecast the net cash flow for each period of the investment's life, including any salvage value at the end.
- Select a discount rate that matches the risk of the investment.
- Discount each cash flow by dividing it by (1 + r) raised to the number of periods until it is received.
- Add the discounted cash flows together.
- Subtract the initial investment. The result is the NPV.
NPV example
A manufacturer is considering a $100,000 machine that is expected to produce net cash flows of $30,000, $35,000, $40,000 and $25,000 over the next four years. The company's discount rate is 8%.
- Year 1: $30,000 ÷ 1.08 = $27,778
- Year 2: $35,000 ÷ 1.082 (1.1664) = $30,007
- Year 3: $40,000 ÷ 1.083 (1.2597) = $31,753
- Year 4: $25,000 ÷ 1.084 (1.3605) = $18,376
The discounted cash flows total $107,914. Subtracting the $100,000 cost gives an NPV of $7,914, so the machine is expected to return more than 8% and add about $7,900 of value. Notice that the undiscounted cash flows add up to $130,000; discounting removes about $22,000 of that, which is the cost of waiting for the money and bearing the risk of not receiving it.
The answer depends heavily on the rate selected. At 6% the same project has an NPV of about $12,800, at 10% about $3,300, and at 12% it turns negative at roughly −$950. The rate at which NPV is exactly zero, about 11.5% here, is the project's internal rate of return (IRR).
How to interpret NPV
- NPV greater than zero: the investment is expected to earn more than the discount rate and create value. Accept it, if nothing else competes for the capital.
- NPV equal to zero: the investment earns exactly the discount rate. It covers its cost of capital but adds no additional value.
- NPV less than zero: the investment earns less than the required return. It can still show an accounting profit, but the capital would be better used elsewhere.
When projects are mutually exclusive, select the one with the highest NPV. When the budget cannot fund every positive-NPV project, a situation called capital rationing, rank projects by the profitability index (present value of future cash flows ÷ initial investment). The machine above has a profitability index of 1.08.
NPV vs. IRR
NPV and IRR use the same cash flows and typically agree on whether to accept a project. NPV gives an answer in dollars, while IRR gives a percentage that is compared with the required return. They can disagree when comparing projects of very different sizes or timing, because a small project can have a higher IRR but a lower NPV. IRR can also give several answers, or none, when cash flows switch between positive and negative more than once. When the two conflict, NPV is the more reliable guide because it measures the value actually added.
How to calculate NPV in Excel or Google Sheets
The NPV function in Excel and Google Sheets assumes the first value arrives one period from now, so leave the upfront cost out of the range and subtract it separately. For the example above: =NPV(8%, B2:B5) - 100000, which returns 7,914. Including the year-zero outlay inside the function discounts the entire result by one extra period and understates the NPV (here it would return about 7,327). For cash flows on irregular dates, use XNPV, which discounts each amount by its actual date.
Limitations of NPV
- It is only as good as the forecast. Optimistic cash flow estimates produce optimistic NPVs, so test the result with sensitivity analysis or several scenarios.
- The discount rate is a judgment call. Small changes in the rate can reverse the decision, as the example shows.
- It ignores scale. A $10,000 NPV on a $50,000 investment is very different from the same NPV on a $5 million one.
- It treats the decision as now or never. Standard NPV does not value the flexibility to postpone, expand or abandon a project later.
Frequently asked questions
What is a good NPV?
Any NPV above zero means the investment is expected to beat its required return. Whether it is good enough depends on the alternatives, the size of the investment and how confident you are in the cash flow forecast.
What discount rate should I use for NPV?
Most companies begin with their WACC for projects that carry the same risk as the business overall, then add a premium for riskier projects such as new markets or unproven products. Use a rate per period that matches the cash flows, for example a monthly rate for monthly cash flows.
What is the difference between NPV and present value?
Present value is what a future amount, or a series of amounts, is worth today. NPV takes that present value and subtracts the cost of the investment, so it indicates the value an investment adds rather than the value of its cash flows alone.
Can NPV be negative?
Yes. A negative NPV means the present value of the cash flows is less than the initial investment, so the project is expected to earn less than the discount rate.