Finance

NPV Calculator

Calculate net present value (NPV) for investments with multiple cash flows. Determine if a project or investment is worth pursuing based on discounted future cash flows.

$
%
Cash flows by year
$
$
$
$
$
$
Net present value (NPV)
$29,079
Initial investment
$100,000
Total cash flows
$175,000
Discount rate
10%
Nominal return
$75,000
NPV
$29,079
Profitability index
1.29

Positive NPV indicates this investment should create value.

Cash flows by year

Cumulative value over time

What is net present value (NPV)?

Net present value (NPV) is one of the most important concepts in finance and capital budgeting. It represents the difference between the present value of all expected future cash flows and the initial investment required. In simpler terms, NPV tells you how much value an investment will add (or subtract) in today's dollars.

The concept is built on the time value of money principle: a dollar today is worth more than a dollar in the future because you can invest today's dollar and earn a return. NPV accounts for this by discounting all future cash flows back to their present value using a discount rate, which typically represents your required rate of return or the cost of capital.

The NPV formula

The NPV formula calculates the sum of all discounted cash flows minus the initial investment:

NPV=C0+C1(1+r)1+C2(1+r)2++Cn(1+r)n=C0+t=1nCt(1+r)t\begin{aligned} NPV &= -C_0 + \frac{C_1}{(1+r)^1} + \frac{C_2}{(1+r)^2} + \ldots + \frac{C_n}{(1+r)^n} \\[0.5em] &= -C_0 + \sum_{t=1}^{n} \frac{C_t}{(1+r)^t} \end{aligned}

Where:

  • C0C_0 = Initial investment (outflow)
  • CtC_t = Cash flow at time t
  • rr = Discount rate (as a decimal)
  • nn = Number of periods
  • tt = Time period

Example calculation

Consider a $100,000 investment that generates the following cash flows over 5 years with a 10% discount rate:

YearCash flowDiscount factorPresent value
0-$100,0001.000-$100,000
1$25,0000.909$22,727
2$30,0000.826$24,793
3$35,0000.751$26,296
4$40,0000.683$27,321
5$45,0000.621$27,941
Total$29,078

The NPV of $29,078 indicates this investment creates value.

Interpreting NPV results

NPV resultInterpretationDecision
NPV > 0Creates valueAccept project
NPV = 0Breaks evenIndifferent
NPV < 0Destroys valueReject project

A positive NPV means the investment will earn more than the required rate of return. The investment generates enough cash to:

  1. Pay back the initial investment
  2. Provide the required return to investors
  3. Generate additional surplus value

Choosing the right discount rate

The discount rate is critical to NPV calculations. Common approaches include:

Weighted average cost of capital (WACC)

For corporate investments, WACC represents the blended cost of debt and equity financing. It's the most common discount rate for capital budgeting decisions.

Required rate of return

Individual investors might use their personal required return based on risk tolerance and alternative investment opportunities.

Risk-adjusted rates

Higher-risk projects should use higher discount rates to account for uncertainty. Many analysts add a risk premium to the base discount rate.

Project risk levelTypical discount rate
Low risk6-10%
Medium risk10-15%
High risk15-25%

NPV vs other investment metrics

NPV vs internal rate of return (IRR)

NPV and IRR often lead to the same accept/reject decision, but NPV is generally preferred because:

  • It assumes cash flows are reinvested at the discount rate (more realistic)
  • It provides a dollar value of wealth creation
  • It works correctly with non-conventional cash flows

NPV vs payback period

Payback period tells you when you'll recover your investment but ignores the time value of money and cash flows after payback. NPV is more comprehensive.

Profitability index

The profitability index (PI) is calculated as:

PI=NPV+Initial InvestmentInitial InvestmentPI = \frac{NPV + Initial\ Investment}{Initial\ Investment}

A PI greater than 1.0 indicates a worthwhile investment. It's useful for comparing projects of different sizes when capital is limited.

Limitations of NPV

Estimation challenges

NPV requires accurate forecasts of future cash flows, which can be difficult, especially for long-term projects or new ventures.

Discount rate sensitivity

Small changes in the discount rate can significantly impact NPV, particularly for projects with cash flows far in the future.

Ignores flexibility

Traditional NPV doesn't account for managerial flexibility to expand, delay, or abandon projects. Real options analysis addresses this limitation.

Scale differences

NPV doesn't account for project size. A $1 million NPV from a $100 million investment may be less attractive than a $500,000 NPV from a $5 million investment.

Practical applications

Capital budgeting

Companies use NPV to evaluate equipment purchases, facility expansions, new product lines, and other major investments.

Investment analysis

Investors use NPV to value stocks, bonds, and real estate by discounting expected future cash flows.

Business valuation

NPV forms the foundation of discounted cash flow (DCF) analysis, the most common method for valuing companies.

Personal finance

Individuals can use NPV for major purchases like solar panels, rental properties, or education investments.

Tips for better NPV analysis

  1. Use realistic cash flow estimates - Base projections on market research and historical data
  2. Consider multiple scenarios - Calculate NPV under optimistic, expected, and pessimistic assumptions
  3. Adjust for inflation - Use real (inflation-adjusted) cash flows with real discount rates, or nominal values with nominal rates
  4. Include all relevant cash flows - Don't forget taxes, working capital, salvage values, and opportunity costs
  5. Compare with alternatives - Evaluate NPV against other investment options, including doing nothing