Calculate Net Present Value (NPV), Internal Rate of Return (IRR), and Profitability Index. Compare multiple investment projects side-by-side with sensitivity analysis.
Try an example:
Enter your investment details to see NPV analysis.
Net Present Value (NPV) is the difference between the present value of expected future cash flows and the initial investment cost, discounted at the investor's required rate of return. A positive NPV means the investment creates value above the cost of capital; a negative NPV means it destroys value. NPV is the gold standard for capital budgeting decisions.
Net Present Value is the cornerstone of modern capital budgeting and investment analysis. According to a landmark survey of 392 CFOs by Graham and Harvey, 74.9% of chief financial officers always or almost always use NPV when evaluating capital investments, making it one of the two most popular techniques alongside IRR (75.7%). Unlike simple metrics like payback period or accounting rate of return, NPV captures the fundamental economic reality that money has time value.
The CFA Institute curriculum emphasizes NPV as the primary tool for capital budgeting decisions. The 2026 AFP Cost of Capital Survey confirms that 83% of organizations use discounted cash flow techniques to evaluate projects. The NPV rule is straightforward: accept projects with positive NPV, reject those with negative NPV. A positive NPV means the project generates returns exceeding the cost of capital, creating intrinsic value for shareholders.
In practice, NPV analysis involves three critical inputs: the initial investment, projected cash flows, and the discount rate. While the first two are relatively straightforward to estimate, choosing the appropriate discount rate requires careful consideration of the project's risk profile. Higher-risk ventures warrant higher discount rates, reflecting the greater uncertainty in future cash flows. This risk adjustment is what makes NPV superior to metrics that ignore time value of money.
For comprehensive investment analysis, combine NPV with Internal Rate of Return (IRR) and Payback Period calculations. While NPV tells you the absolute dollar value created, IRR provides the percentage return, and payback period indicates liquidity risk. For income-focused investments, compare NPV against dividend yield to assess whether cash returns justify the risk premium. Use earnings per share (EPS) as a starting point for estimating the cash flows that drive your NPV model. Together, these metrics offer a complete picture of investment merit.
The NPV formula with summation notation:
NPV = -C0 + SUM(t=1 to n) [ Ct / (1 + r)^t ]
Where:
The discount rate is arguably the most important input in NPV calculations. It represents the opportunity cost of capital - the return you could earn on an alternative investment of similar risk.
According to the 2026 AFP survey, 83% of organizations use CAPM to estimate the cost of equity, and 62% use their calculated cost of capital as the standard hurdle rate. The remaining 38% set a hurdle rate above the cost of capital to account for execution risk.
| Industry | Typical WACC | Key Driver |
|---|---|---|
| Utilities | 5-7% | Regulated cash flows, high debt capacity |
| Food Processing | ~6% | Non-cyclical demand, stable margins |
| Real Estate (REITs) | 6-9% | Asset-backed, high leverage |
| Healthcare | 8-10% | Regulatory risk, long R&D cycles |
| Software | 10-14% | High equity beta, low capital intensity; SaaS/Internet at upper end |
| Retail | 8.5-12.5% | Consumer cyclicality, thin margins |
| Semiconductors | ~10.8% | High cyclicality, capex-heavy |
Source: Damodaran, NYU Stern (Jan 2026). Ranges reflect company size and leverage differences within each sector.
Use WACC (Weighted Average Cost of Capital), typically 8-12% for established companies. This reflects the blended cost of debt and equity financing.
Cap rates typically range 5-10% depending on property type and location. Add premium for development projects or value-add opportunities.
High discount rates of 20-50% reflect extreme uncertainty. Calculate your burn rate and runway to stress-test assumptions.
Use your expected return from alternative investments. Historical stock market ROI (7-10%) provides a reasonable benchmark for most investors.
Use NPV to measure the absolute dollar value an investment creates. Use IRR to express the annualized percentage return. Use payback period to assess liquidity risk. When NPV and IRR disagree on project ranking, always prioritize NPV because it maximizes shareholder value in absolute terms.
In the Graham and Harvey survey, 75.7% of CFOs use IRR, 74.9% use NPV, and approximately 57% use payback period. Each metric answers a different question, and experienced analysts use all three together.
Answers: How much value does this investment create in today's dollars?
Answers: What is the project's annualized rate of return?
Answers: How long until I recover my initial investment?
NPV and IRR usually agree on accept/reject decisions but can rank projects differently. When comparing mutually exclusive projects, always prioritize NPV. A $1 million project with 20% IRR creates more value than a $10,000 project with 100% IRR. NPV tells you the actual dollar value created; IRR only tells you the percentage return.
A manufacturing company evaluates a $100,000 CNC machine expected to generate $30,000 in annual cost savings for 5 years. Using a 10% discount rate (company WACC):
Positive NPV of $13,722 indicates the machine creates value. The company should proceed with the purchase as it exceeds the 10% required return.
An investor considers a $500,000 rental property with $48,000 annual net operating income and expected sale at $600,000 in 7 years. Using an 8% discount rate:
The $100,794 NPV suggests strong value creation. Combined with the 9.6% cap rate ($48,000 / $500,000), this investment meets institutional quality standards.
A venture capitalist evaluates a $250,000 seed investment in a SaaS startup. Expected cash flows show losses initially, then growth. Using 25% discount rate for early-stage risk:
Despite the high discount rate reflecting startup risk, NPV remains positive. The investment earns above the 25% hurdle rate, though sensitivity analysis at 30% and 35% would test robustness.
A buyer evaluates acquiring a profitable services firm for $1.2M. The business generates $180,000 annual free cash flow with 3% annual growth, financed at 9% WACC. Planned exit in year 7 at 5x EBITDA:
The $369,083 NPV and 1.31x Profitability Index indicate strong value creation. Cross-check the purchase price against valuation multiples for the industry to confirm the entry price is reasonable.
The most frequent NPV errors are using accounting profit instead of cash flows, including sunk costs in the initial investment, discounting the Year 0 outlay, mixing nominal cash flows with a real discount rate, and applying a single company-wide WACC to projects with different risk profiles. Avoiding these five mistakes eliminates the majority of NPV miscalculations in practice.
NPV requires actual cash inflows and outflows, not accounting profit. Net income includes non-cash items like depreciation, amortization, and accruals that distort the timing of real cash movements. Always start from free cash flow, not the income statement bottom line.
Money already spent (R&D completed, feasibility studies paid for) is irrelevant to NPV. Only incremental future cash flows matter. If you spent $50,000 on market research before deciding whether to launch, that $50,000 should not appear in your NPV model regardless of the launch decision.
The Year 0 cash outflow occurs today and should not be discounted. A common spreadsheet error is applying the discount factor to the initial investment, which understates its true cost and inflates NPV. The initial outlay enters the formula at face value: NPV = -C0 + PV(future cash flows).
If cash flows include inflation (nominal), the discount rate must also be nominal. If cash flows are in constant dollars (real), use a real discount rate. Mixing the two produces systematically biased results. The Fisher equation relates the two: (1 + nominal) = (1 + real) x (1 + inflation).
A company's overall WACC reflects the risk of its existing asset mix. A high-risk expansion into a new market deserves a higher discount rate than a cost-reduction project in the core business. The 2026 AFP survey found that 38% of organizations set hurdle rates above WACC to account for project-specific execution risk.
If a project uses an existing asset (warehouse, equipment, land), the opportunity cost of that asset must be included as a cash outflow. A factory building you already own is not "free" for NPV purposes. Its market value or best alternative use represents a real cost of the project.
While NPV is the gold standard for capital budgeting, it has important limitations that practitioners must understand to avoid misapplication.
Small changes in the discount rate can dramatically change NPV, especially for long-duration projects. A project positive at 10% might be negative at 12%. Always perform sensitivity analysis across a range of discount rates.
NPV is only as accurate as its cash flow projections. For new products or technologies, forecasting errors can be substantial. Use scenario analysis (pessimistic, base, optimistic) to understand the range of possible outcomes.
NPV captures only quantifiable cash flows. Strategic benefits like market positioning, learning opportunities, or option value from future expansion may not be reflected. Real options analysis can help capture this additional value.
NPV implicitly assumes intermediate cash flows can be reinvested at the discount rate. For projects with very high returns, this may be unrealistic. Modified IRR (MIRR) addresses this limitation for some applications.
When capital is unlimited, maximize NPV regardless of size. But when capital is constrained, a smaller project with higher NPV per dollar invested (Profitability Index) may be preferable to a larger project with higher absolute NPV.
Pair this tool with the IRR Calculator for percentage returns, the Payback Period Calculator for liquidity risk, and the ROI Calculator for quick comparisons. Use our CAPM Calculator to estimate the cost of equity input and the WACC Calculator for a blended discount rate.
NPV is the most theoretically sound capital budgeting metric because it accounts for the time value of money and provides absolute dollar value of investment returns.
The NPV rule is simple: accept projects with positive NPV (they create value), reject projects with negative NPV (they destroy value). When comparing projects, choose the one with highest NPV.
The discount rate is the most critical input. It should reflect both the opportunity cost of capital and the specific risk of the project being evaluated.
Always perform sensitivity analysis to understand how NPV changes with different discount rate and cash flow assumptions. A robust project remains positive across scenarios.
Combine NPV with IRR for percentage returns, Profitability Index for capital efficiency, and Payback Period for liquidity assessment to get a complete investment picture.
Calculate OER and NOI for real estate properties
Calculate capitalization rate and property value
Calculate gross and net rental yield
Estimate property taxes and effective rates
Rental Property Guide
In-depth guide with examples, benchmarks, and interactive calculators