The short answer: net present value discounts every expected future cash flow back to today at a required return, then subtracts the initial investment. NPV = −C0 + CF1/(1+r) + CF2/(1+r)2 + … A positive NPV means the project is expected to create value above the hurdle rate; zero means it earns exactly the hurdle; negative means it falls short.

Key takeaways

  • NPV is in today’s dollars. It converts a stream of future cash flows into one comparable number.
  • The discount rate is a hurdle, not a forecast. It reflects the return available elsewhere at similar risk.
  • Cash flows, not accounting profit. Add back non-cash charges only through their tax effect, and include working capital and capital spending.
  • Do not subtract interest and then discount at the cost of capital. That double-counts financing.
  • Positive NPV is a necessary test, not a guarantee. Forecast error, execution risk, and capital constraints still matter.

The NPV formula and decision rule

NPV compares the present value of future cash flows with the cost of the investment today. The general formula is:

NPV = −C0 + Σ [CFt ÷ (1 + r)t] for t = 1 to n

C0 is the initial cash outlay, CFt is the net cash flow in period t, r is the discount rate per period, and n is the number of periods. If the cash flows are annual, use an annual rate; if they are monthly, use a monthly rate and count months.

For an independent project, accept if NPV is greater than zero, reject if it is less than zero, and treat zero as the break-even point where the project earns exactly the required return. For mutually exclusive projects, choose the one with the highest positive NPV, not the highest internal rate of return or the shortest payback.

Choosing the discount rate

The discount rate is the opportunity cost of capital: the return the business could expect from another investment with similar risk. It is not the interest rate on a loan, the inflation rate, or a rate chosen to make the answer look good. A common starting point for a whole company is the weighted average cost of capital; a riskier project should carry a higher hurdle, and a safer one may carry a lower hurdle.

Match nominal to nominal or real to real. If cash flows include expected inflation, discount them at a nominal rate. If they are stated in today’s purchasing power, use a real rate. Mixing the two produces a number that looks precise but is not. OMB Circular A-94 provides federal guidance on discounting for benefit-cost analysis, including the distinction between real and nominal rates.

A worked example

A $500,000 equipment investment is expected to produce $140,000 of net cash flow at the end of each year for five years. The required return is 9%. The present value of the five payments is $544,551, so NPV is $544,551 − $500,000 = $44,551. The project clears the hurdle.

Year Cash flow Discount factor at 9% Present value
1 $140,000 0.917431 $128,440
2 $140,000 0.841680 $117,835
3 $140,000 0.772183 $108,106
4 $140,000 0.708425 $99,180
5 $140,000 0.649931 $90,990
Total $700,000 $544,551

The undiscounted cash inflow is $700,000, but $200,000 of that is compensation for waiting and risk. The project’s IRR is about 12.4%, and its profitability index is 1.089. All three measures tell the same story here because the cash flows are conventional and the project is independent.

The annuity shortcut

When the cash flow is the same every period, the present value can be calculated with the annuity factor:

PV = CF × [1 − (1 + r)−n] ÷ r

For $140,000 for five years at 9%, the factor is [1 − 1.09−5] ÷ 0.09 = 3.88965, and the present value is $544,551. In a spreadsheet, use =NPV(rate, range) + initial when the initial outlay is entered as a negative number in a separate cell. Excel’s NPV function discounts the first value in the range by one period, so do not include the year-zero cash flow inside the range.

What cash flows belong in NPV

  • Initial outlay: equipment, installation, shipping, training, and any immediate working capital.
  • Incremental operating cash flow: revenue minus cash operating costs and taxes. Depreciation is not a cash flow, but its tax deduction is.
  • Working capital: increases in receivables and inventory are outflows; their release at the end is an inflow.
  • Salvage and disposal: after-tax proceeds at the end of the project.
  • Opportunity costs: space, equipment, or management time that could be used elsewhere.
  • Exclude: sunk costs, financing flows, and allocated overhead that does not change with the project.

Tax cash flow can be built as (revenue − cash operating costs − depreciation) × (1 − tax rate) + depreciation, or equivalently (revenue − cash operating costs) × (1 − tax rate) + depreciation × tax rate. The second form makes the depreciation tax shield visible. If EBITDA is $200,000, depreciation is $50,000, and the tax rate is 25%, tax is $37,500 and cash flow is $162,500.

NPV profile, IRR, and project ranking

As the discount rate rises, the present value of future cash flows falls and NPV declines. The internal rate of return is the rate at which NPV equals zero. For a conventional project with one sign change, IRR above the hurdle is consistent with positive NPV. The consistency breaks down when projects differ in scale or timing, or when cash flows change sign more than once.

Consider a small project with a 40% IRR and a $20,000 NPV, and a larger project with a 22% IRR and a $200,000 NPV. If the company can fund only one, the larger project creates more value. IRR is a rate; NPV is the amount of value. For mutually exclusive choices, use NPV, and use IRR as context rather than as the deciding vote.

Common mistakes

  • Double-counting financing. Subtracting interest expense and then discounting at the weighted average cost of capital counts the cost of debt twice.
  • Discounting nominal cash flows at a real rate, or the reverse. Match the inflation assumption in the cash flows to the rate.
  • Including sunk costs. Money already spent is not affected by the decision and should not be in the incremental cash flows.
  • Forgetting working capital. Growth often consumes cash before it produces cash.
  • Using accounting profit as cash flow. Depreciation, accruals, and capitalized costs create a gap.
  • Mismatching the period. An annual cash flow discounted at a monthly rate, or a five-year project with a ten-year rate, produces a meaningless number.
  • Treating NPV as a sure thing. It is a forecast, not a fact; the discount rate does not remove uncertainty.

Practical caveats

Forecast quality dominates the arithmetic. A small change in the terminal-year cash flow, the discount rate, or the assumed project life can move NPV more than a decade of operating detail. Build a base case, a downside case, and an upside case; report the assumptions behind each. If the decision flips inside a plausible range, the project needs more analysis or a staged commitment, not a more precise spreadsheet.

Long-lived projects also need a terminal value or an explicit horizon. Terminal value assumptions are easy to manipulate, so disclose the growth rate and the capital spending required to sustain it. Inflation, taxes, foreign exchange, and capital rationing can change the ranking. A positive NPV project that consumes all of a small company’s cash can still be a bad decision if the business cannot fund the timing gap.

How to present an NPV decision

  1. Lay out the cash-flow table. Show the initial outlay, each period’s cash flow, and the terminal items.
  2. State the discount rate and its source. Explain why it matches the project’s risk and the cash-flow period.
  3. Show NPV, IRR, profitability index, and payback together. Each answers a different question.
  4. Run a sensitivity. Flex the discount rate, revenue, cost, and project life one at a time.
  5. Write down the qualitative conditions. Permits, execution, key customers, and financing can override a marginal NPV.

A positive NPV is the financial case for investing. It is not a substitute for a funding plan, an execution plan, or a check that the assumptions are internally consistent.

Frequently asked questions

What does an NPV of zero mean?

It means the project is expected to earn exactly the discount rate. The business is no better or worse off in present-value terms, before considering strategic or qualitative effects.

Is a higher discount rate better?

No. A higher rate lowers present value. The right rate is the opportunity cost of capital for the project’s risk, not a rate chosen to produce a desired answer.

Should depreciation be included in NPV?

Only through its tax effect. Depreciation is not a cash outflow, but it reduces taxable income and creates a tax shield.

What is the difference between NPV and IRR?

NPV is a dollar amount of value at the required return; IRR is the percentage rate that makes NPV zero. NPV is more reliable for ranking mutually exclusive projects.

Can NPV be used for a personal decision?

Yes, if the cash flows are incremental and after tax, and the discount rate reflects the opportunity cost. It is a framework, not a substitute for advice on risk or liquidity.

What if the cash flows are monthly?

Use a monthly discount rate and count months, not years. Do not divide the annual rate by twelve unless the rate is a nominal annual rate; for an effective annual rate, convert it to the equivalent monthly rate.

Further reading

Keep exploring

Read next Break-Even with Multiple Products: Weighted Contribution Margin Two products with different margins break even on a blended contribution margin. See how the unit mix sets… Read next Rule of 40: Growth Plus Margin for SaaS The Rule of 40 adds revenue growth and profit margin into one score. See which margin to use,… Read next CAC Payback: Months to Recover Acquisition Cost CAC payback divides acquisition cost by monthly gross profit. See what belongs in each input, how churn stretches…