Net Present Value

What NPV answers

Net present value compares a project’s expected cash flows with its cost after translating them to the same point in time. It asks whether the present value of future net cash flows exceeds the investment required at time zero, using a chosen discount rate. NPV is a valuation tool, not a forecast engine. It produces a result from assumptions about amounts, timing, risk, and the required return.

The formula is NPV = Σ[CFt ÷ (1 + r)^t], including the time-zero cash flow, where CFt is the cash flow at period t, r is the discount rate per period, and t is the period number. The initial cost is usually a negative cash flow at t = 0, so it is not discounted. If a spreadsheet NPV function assumes the first listed flow occurs at the end of period one, add the initial outlay separately.

A positive NPV indicates that projected cash flows exceed the required return embedded in the discount rate. A negative NPV indicates they fall short under the same assumptions. If two mutually exclusive projects have similar risk and constraints, higher NPV generally adds more value under the model. If projects differ in size, duration, liquidity, or risk, the ranking needs further analysis.

The discount rate reflects the return required for the project’s risk and financing context. Using a rate that is too low can inflate NPV; using one that is too high can make viable projects appear unattractive. A company-wide cost of capital may not fit a project with materially different risk. The rate should be consistent with whether cash flows are nominal or real, before or after tax, and in which currency.

Calculate NPV step by step

Suppose a project costs $10,000 now and is expected to produce $4,000 at the end of each of the next three years. At a 8% annual discount rate, NPV = -$10,000 + $4,000/1.08 + $4,000/(1.08)^2 + $4,000/(1.08)^3. The present values are about $3,703.70, $3,429.36, and $3,175.33. Their sum is $10,308.39, so NPV is about $308.39.

A positive value of $308.39 does not mean the project will definitely earn that amount. It means the projected inflows, discounted at 8%, exceed the $10,000 cost by that amount. If cash flows are lower, delayed, or riskier than assumed, actual value can be negative. The number is also sensitive to rounding, so retain full precision until the final step.

If the project requires an additional $1,000 maintenance cost at the end of year two, include it as a negative cash flow at that date. Its present value is -$1,000/(1.08)^2, or about -$857.34. Revised NPV is about -$548.95. Omitting that cost would overstate value. Include incremental cash flows that arise because the project is accepted, not every company expense regardless of the decision.

If working capital is required at the start and recovered at the end, include both flows. A $2,000 working-capital investment at time zero reduces NPV by $2,000; recovery of $2,000 at year three adds $2,000/(1.08)^3, about $1,587.67. The net present-value effect is approximately -$412.33. The recovery should not be assumed unless the project can release the funds at the stated time.

The discount rate and cash-flow consistency

Nominal cash flows include expected price increases; real cash flows are stated in today’s purchasing power. Discount nominal flows with a nominal rate and real flows with a real rate. If a project’s costs rise with inflation but revenue is fixed, model that asymmetry. Using a nominal discount rate on real flows can produce a distorted result.

After-tax cash flows should generally be discounted using a rate consistent with after-tax risk and financing assumptions. Tax depreciation, credits, and loss carryforwards can change project cash flows by year. A simple exam problem may ignore tax, but a real valuation should state whether cash flows and the discount rate are before or after tax. Avoid mixing pretax cash flows with an after-tax rate.

Cash flows in different currencies require consistent conversion. A euro project can be valued in euros using a euro discount rate or translated into dollars using exchange-rate assumptions and a dollar-consistent rate. Do not discount euro cash flows with a dollar rate without translating or adjusting the framework. Currency risk and capital controls can affect expected cash flows and investor access.

Risk can be reflected through expected cash flows, the discount rate, or both, but avoid double-counting. If a risk-adjusted cash-flow scenario already reduces expected revenue for a disruption, adding an arbitrary premium for the same risk can depress NPV twice. State how the risk enters the model. Sensitivity analysis can show how NPV changes across plausible rates and outcomes.

Incremental and sunk costs

NPV should include incremental cash flows: changes that occur because the project is accepted. A sunk cost has already been incurred and cannot be recovered, so it generally should not affect the forward-looking decision. If a company spent $100,000 on a feasibility study last year, that cost does not change the cash flows of accepting or rejecting the project today. It may matter for accounting or reporting, but not for the incremental NPV choice.

Opportunity cost is a cash flow the company gives up by using a resource for the project. If a warehouse could be leased for $50,000 annually, using it for a new project has an economic cost even if no rent payment is recorded. Include the forgone alternative value in the project analysis. This avoids treating an owned resource as free merely because it is already on the balance sheet.

Cannibalization occurs when a new product takes sales from an existing product. The project should include the reduction in existing cash flows caused by that shift. A project with strong gross sales may have lower incremental value after lost sales elsewhere in the company. The analyst should also consider complementary revenue or cost savings if they truly result from the project.

Worked case: choose between projects

A company can choose Project A, which costs $20,000 and pays $8,000 at each year-end for three years, or Project B, which costs $20,000 and pays $3,000 in year one, $7,000 in year two, and $12,000 in year three. At 10%, Project A’s present inflows are about $7,272.73 + $6,611.57 + $6,010.52 = $19,894.82, so NPV is -$105.18. Project B’s present inflows are about $2,727.27 + $5,785.12 + $9,016.53 = $17,528.92, so NPV is -$2,471.08.

At 10%, neither project meets the required return under these cash-flow assumptions, though A is closer. If the projects are mutually exclusive and the company must choose one, A has the higher NPV and destroys less modeled value. If the company can reject both, a negative NPV suggests neither should be accepted absent strategic or other benefits omitted from the model. A manager should not call Project A “profitable” simply because it returns cash; compare cash flows with the opportunity cost of capital.

Now lower the discount rate to 8%. Recalculate rather than assume the ranking stays the same. Projects with different timing can respond differently to discount-rate changes. Project B’s later large payment is more sensitive to the rate than Project A’s earlier cash. This is why rate sensitivity matters, especially for long-duration cash flows.

Sensitivity and scenario analysis

A single NPV hides uncertainty in sales volume, price, costs, timing, and discount rate. A sensitivity table can recalculate NPV across two variables, such as lower sales and higher costs. A scenario analysis can combine assumptions into coherent cases: base, downside, and upside. These are not probabilities unless the analyst assigns and supports probabilities. They show how dependent the conclusion is on assumptions.

Break-even analysis can solve for the sales volume or margin required for NPV to reach zero. If the project’s NPV becomes negative after a small cost increase, it is more fragile than a project with a wider margin of safety. A break-even threshold is useful for monitoring. The company can compare actual results with the assumptions and reconsider when conditions change.

Terminal value represents cash flows beyond the explicit forecast period in some valuation models. A growing perpetuity formula can produce a large value, making assumptions about long-term growth and discount rates decisive. The terminal growth rate must be below the discount rate in the standard constant-growth formulation. The value is model-dependent, not a resale price guaranteed by the market.

NPV and investment suitability

NPV is commonly used for business projects, but its logic also appears in bond prices and discounted cash-flow valuation. A bond price is the present value of contractual coupons and principal discounted at a yield. Equity valuation may discount expected cash flows or dividends. The cash flows and discount rate differ by security, and market price may deviate from model value because expectations and risk premiums change.

An adviser should not recommend a security to a client solely because a simplified NPV is positive. The model may omit liquidity, taxes, risk, diversification, client horizon, and alternative investments. A client who needs cash next year may be unable to tolerate a project whose cash flows arrive in five years. Suitability depends on the client’s facts and the full investment terms.

A client may ask why a company with positive accounting earnings has a negative project NPV. Accounting profit and project valuation answer different questions. Accounting income allocates revenues and expenses under reporting standards. NPV compares incremental cash flows to a required return. A company can record earnings yet invest in a project that fails to compensate for risk and time.

Common NPV mistakes

Do not discount the initial outlay if it occurs at time zero. Include it as a negative cash flow without a period delay.

Do not omit maintenance, working capital, opportunity cost, or cannibalization when they are incremental to the project. A project’s stated revenue is not its net cash flow.

Do not mix annual cash flows with a monthly rate or nominal flows with a real discount rate. Match timing, currency, taxes, and inflation assumptions.

Do not treat positive NPV as a guaranteed profit. It is a conditional result based on projected cash flows and the chosen discount rate.

Do not rank different-sized projects by percentage return alone when the decision seeks total value. NPV measures value added in currency units, while IRR measures a rate; both can be informative.

A disciplined NPV workflow

Define the decision and forecast incremental cash flows. Draw a timeline and place the initial outlay at time zero. Include operating inflows, costs, taxes, capital spending, working capital, opportunity costs, and terminal proceeds when supported. Exclude sunk costs. State whether flows are nominal or real, pretax or after-tax, and in which currency.

Choose a discount rate consistent with the cash flows’ risk and the decision. Convert it to the period length and discount each flow. Add the results and check the sign. A higher rate should generally lower NPV for future positive flows. If the sign or direction is surprising, revisit the timeline and cash-flow conventions.

Test the conclusion under reasonable alternatives. Identify which assumptions drive most of the value and what evidence would change them. Compare projects on the same basis. For a client investment, use NPV as one analytical input and also assess liquidity, risk, diversification, taxes, and suitability.

Sources

CFA Institute Research Foundation, Net Present Value and Internal Rate of Return; NASAA Series 65 Test Specifications, Section I; OpenStax Principles of Finance, discounted cash-flow concepts.