Finance

NPV Calculator

Calculate net present value from a discount rate, initial investment, and yearly cash flows. Determine whether an investment creates or destroys value.

Quick Answer

NPV = -Initial Investment + Sum of (Cash Flow / (1 + r)^t). A positive NPV means the investment earns more than the discount rate and should be accepted. A negative NPV means it destroys value.

Calculate NPV

Enter the discount rate, initial investment, and expected cash flows for each year.

%
$
$
$
$
$
$
Disclaimer: This calculator provides simplified NPV estimates for educational purposes. Actual investment returns depend on many factors not captured in this model, including cash flow uncertainty, inflation, tax implications, and changing market conditions. This tool does not constitute financial or investment advice. Consult with a qualified financial advisor before making investment decisions.

About This Tool

The NPV Calculator helps investors, financial analysts, and business owners evaluate investment opportunities by computing the net present value of expected cash flows. NPV is widely regarded as the gold standard of investment analysis because it accounts for both the magnitude and timing of cash flows, providing a single dollar figure that represents the value created or destroyed by an investment decision. Whether you are evaluating a capital expenditure, a real estate acquisition, or a new business venture, NPV provides the analytical foundation for sound financial decision-making.

How NPV Works

The NPV calculation starts with the initial investment (a cash outflow at time zero) and then adds the present value of each future cash inflow. Future cash flows are discounted using the formula: PV = CF / (1 + r)^t, where CF is the cash flow, r is the discount rate, and t is the year. The discount rate represents the minimum acceptable rate of return, typically based on the cost of capital or the return available on alternative investments of similar risk. By converting all cash flows to present-day dollars, NPV allows direct comparison: if the sum of discounted inflows exceeds the initial investment, the project creates value and should be considered.

Choosing the Right Discount Rate

The discount rate is the most influential input in an NPV calculation, and selecting it correctly is critical. For corporate projects, the Weighted Average Cost of Capital (WACC) is the standard starting point. WACC blends the cost of equity and the cost of debt, weighted by the company's capital structure. Typical WACC values range from 8% to 15% for established companies. For riskier projects, a risk premium is added to the base rate. Startups and ventures in emerging markets might use discount rates of 20-40% to reflect higher uncertainty. For personal investment decisions, the appropriate discount rate is your opportunity cost: the return you could reasonably expect from the next-best use of your money. Using too low a discount rate makes marginal projects look attractive, while too high a rate rejects value-creating investments.

NPV Decision Rules

The NPV decision rule is straightforward: accept investments with positive NPV and reject those with negative NPV. A positive NPV means the investment earns more than the discount rate, creating value above the minimum acceptable return. A zero NPV means the investment earns exactly the discount rate -- it meets the minimum threshold but creates no excess value. When comparing mutually exclusive projects (where you can only choose one), select the project with the highest positive NPV, as it creates the most value. When evaluating independent projects (where you could accept multiple), accept all projects with positive NPV as long as capital is available. If capital is limited, rank projects by profitability index (NPV / Investment) to maximize total value per dollar invested.

Sensitivity Analysis and Scenarios

Because NPV depends heavily on assumptions about future cash flows and the discount rate, sensitivity analysis is essential. Calculate NPV under multiple scenarios: optimistic (higher cash flows, lower discount rate), base case (most likely assumptions), and pessimistic (lower cash flows, higher discount rate). This range shows how robust the investment decision is. If NPV is positive even in the pessimistic scenario, the investment is relatively safe. If it turns negative in realistic downside scenarios, the investment carries significant risk. Many analysts also perform breakeven analysis to find the discount rate at which NPV equals zero (this is the IRR) and the minimum cash flow needed for a positive NPV. These analyses transform NPV from a single number into a comprehensive risk assessment framework.

Common Pitfalls in NPV Analysis

Several common mistakes can lead to flawed NPV calculations. First, using overly optimistic cash flow projections -- anchoring to best-case scenarios rather than realistic expectations inflates NPV and leads to poor investment decisions. Second, ignoring terminal value: for projects that continue beyond the explicit forecast period, a terminal value captures the remaining expected cash flows and can represent 50% or more of total NPV. Third, failing to account for all costs, including opportunity costs, working capital requirements, and implementation expenses. Fourth, using a discount rate that does not match the project's risk profile. Fifth, ignoring inflation: if cash flows are in nominal terms, use a nominal discount rate; if in real terms, use a real rate. Mixing nominal cash flows with real discount rates (or vice versa) produces incorrect results.

Frequently Asked Questions

What is Net Present Value (NPV)?
Net Present Value is the difference between the present value of future cash inflows and the initial investment cost. It accounts for the time value of money by discounting future cash flows back to today's value using a specified discount rate. A positive NPV means the investment is expected to generate more value than it costs, making it financially attractive. A negative NPV means the investment is expected to destroy value. NPV is considered one of the most reliable methods for evaluating investment decisions because it accounts for both the magnitude and timing of cash flows.
How do I choose the right discount rate?
The discount rate should reflect the opportunity cost of capital -- the return you could earn on an alternative investment of similar risk. For corporate investments, the Weighted Average Cost of Capital (WACC) is commonly used, typically ranging from 8% to 15% for most companies. For personal investments, use the rate of return you expect from your next-best alternative. Higher discount rates are appropriate for riskier investments. A common approach is to calculate NPV at multiple discount rates (sensitivity analysis) to see how robust the investment decision is across different scenarios.
What does a negative NPV mean?
A negative NPV means the present value of expected future cash flows is less than the initial investment, indicating the project is expected to generate a return below the discount rate. In financial terms, the investment destroys value compared to the alternative use of that capital. Generally, projects with negative NPVs should be rejected in favor of investing the capital elsewhere. However, some projects with negative NPVs may still be pursued for strategic reasons, such as entering a new market, building capabilities, or meeting regulatory requirements. The negative NPV quantifies the cost of pursuing those strategic objectives.
What is the difference between NPV and IRR?
NPV tells you the dollar value created or destroyed by an investment, while IRR (Internal Rate of Return) tells you the percentage rate of return. IRR is the discount rate that makes NPV exactly zero. Both are useful but NPV is generally considered more reliable for decision-making. IRR can give misleading results when cash flows change sign multiple times (producing multiple IRRs) or when comparing projects of different sizes. A project with a 50% IRR but $1,000 NPV creates less value than one with 20% IRR but $100,000 NPV. Use NPV for go/no-go decisions and IRR for comparing projects of similar scale.
What is the profitability index?
The profitability index (PI) is the ratio of the present value of future cash flows to the initial investment. It equals (NPV + Initial Investment) / Initial Investment, or equivalently, 1 + (NPV / Initial Investment). A PI greater than 1.0 indicates a profitable investment. The PI is useful when you have limited capital and need to rank competing projects. A project with a PI of 1.5 generates $1.50 in present value for every $1 invested, while a PI of 0.8 means only $0.80 in present value per dollar invested. When capital is constrained, ranking projects by PI helps maximize the total value created from available funds.
How does NPV handle the time value of money?
NPV handles the time value of money through discounting, which converts future cash flows into their present-day equivalent. The core principle is that a dollar received today is worth more than a dollar received in the future because today's dollar can be invested to earn a return. The discount factor for each period is 1 / (1 + r)^t, where r is the discount rate and t is the number of periods. A $100 cash flow received in year 3 with a 10% discount rate has a present value of $100 / (1.10)^3 = $75.13. The further in the future a cash flow occurs, the less it is worth today, which is why NPV penalizes investments with back-loaded returns.

You might also like

Tax & Finance

Self-Employment Tax Estimator

Calculate your quarterly SE tax payments and deductions.

⏱ 2 minFinance

Compound Interest Calculator

See how your money grows with compound interest over time.

⏱ 1 minCareer

Freelance Rate Calculator

Find your ideal hourly, daily, and project rates.

⏱ 3 min