Net Present Value Calculator:
NPV Formula, NPV Profile, Profitability Index, and NPV vs IRR Analysis
Net present value is the only capital budgeting metric that measures value creation in dollars rather than percentages. Where IRR tells you the rate at which your investment breaks even, NPV tells you exactly how many dollars of value you create above and beyond recovering your cost of capital. A positive NPV means money created; a negative NPV means money destroyed. That direct link to dollar value is why NPV is the theoretically preferred metric in corporate finance and the foundation of every serious discounted cash flow analysis.
Net present value is the master metric of capital budgeting. Every major corporate investment decision — whether to build a new factory, acquire a competitor, launch a product line, or invest in equipment — ultimately reduces to an NPV calculation: is the present value of the cash flows this investment generates worth more than what it costs? If yes, value is created; if no, capital is being misallocated. The decision rule is binary and absolute: accept positive-NPV investments, reject negative-NPV investments, and when capital is limited, rank competing investments by NPV to maximize the total value created per dollar of scarce capital.
NPV’s theoretical superiority over all other capital budgeting metrics rests on three properties that no other single metric shares: it measures value creation in dollars (not percentages), it correctly accounts for the timing of every cash flow (not just total magnitude), and it avoids the reinvestment rate assumption flaw that makes IRR overstate true returns for high-yield projects. The profitability index extends NPV into a capital rationing tool. The NPV profile visualizes how NPV changes across all possible discount rates. And incremental NPV resolves the conflicts that arise when NPV and IRR rankings disagree for mutually exclusive projects. This guide develops the complete NPV analytical framework.
The NPV Formula: Discounting Every Cash Flow to Today
NPV is the algebraic sum of all cash flows from an investment, each discounted to its present value using the appropriate discount rate. The initial investment (a cash outflow) is typically expressed as a negative number at time zero. Subsequent cash flows (inflows from operations, cost savings, or terminal value) are each divided by (1+r)^t to convert them to their present value, then summed. The net result — positive or negative — is the NPV.
EQUIVALENT SUMMATION NOTATION
Three input disciplines determine NPV accuracy. First, cash flows must be after-tax: accounting net income includes non-cash charges like depreciation that do not represent actual cash flows. The correct input is free cash flow — operating cash flow after working capital changes and capital expenditures, minus taxes paid. Second, opportunity costs must be included: if a project uses an asset already owned by the firm (a building, equipment, existing staff), the economic cost of that resource must be charged to the project even if there is no accounting entry. Third, all cash flows in the explicit projection period must be included, plus a terminal value if the investment generates value beyond the last explicitly modeled year.
Step-by-Step NPV Calculation: Business Expansion Project
The following worked example traces the complete NPV calculation for a manufacturing company considering a $200,000 production line expansion. The project generates increasing cash flows over five years, with a $30,000 salvage value on equipment included in the Year 5 cash flow. The discount rate is the company’s WACC of 10 percent.
The positive NPV of $84,677 means the production line expansion creates $84,677 of value above and beyond recovering the $200,000 investment plus the 10% annual return required by the company’s capital providers. In economic terms: if the company borrows $200,000 at a blended cost of 10% per year, the cash flows generated by the expansion are sufficient to repay the debt, cover the 10% annual interest, and still have $84,677 in surplus present value. That surplus is the NPV — the net economic gain from the investment at the stated cost of capital.
The Excel implementation of this calculation is: =NPV(10%, 50000, 65000, 75000, 80000, 120000) + (-200000). The NPV() function in Excel discounts all values from period 1 onward. The initial investment at period 0 is not discounted (it is already in present-value terms since it occurs today) and must be added separately outside the NPV() function. For irregular cash flow dates, XNPV(rate, values, dates) allows actual calendar dates to be specified rather than assuming equal intervals.
Calculate NPV for Any Investment Cash Flow Series
Enter your initial investment and up to 20 years of projected cash flows to calculate NPV at your discount rate, see each year’s discounted cash flow, and view the complete NPV profile across all discount rates.
Open the NPV CalculatorThe NPV Profile: How NPV Changes Across Discount Rates
The NPV profile plots the investment’s NPV at every possible discount rate, revealing three critical pieces of information in a single visualization: the NPV at the cost of capital (the decision-relevant figure), the IRR (the x-axis intercept where NPV equals zero), and the sensitivity of NPV to discount rate changes (the slope of the curve). Steep profiles indicate high duration risk — small errors in estimating the discount rate produce large NPV errors. Flat profiles indicate the decision is robust to rate uncertainty.
| Discount Rate | Sum of Discounted CFs | NPV | Decision | Notes |
|---|---|---|---|---|
| 0% | $390,000 | +$190,000 | Accept | Undiscounted sum of all cash flows |
| 5% | $331,186 | +$131,186 | Accept | Very attractive at risk-free-rate |
| 8% | $302,036 | +$102,036 | Accept | Strong NPV at conservative WACC |
| 10% (WACC) | $284,677 | +$84,677 | Accept | Base case at company’s cost of capital |
| 15% | $247,341 | +$47,341 | Accept | Still positive at stressed WACC |
| 20% | $217,011 | +$17,011 | Accept (marginal) | Thin margin of safety at 20% |
| 23.3% (IRR) | $200,000 | $0 | Breakeven | IRR — discount rate where NPV = 0 |
| 25% | $192,088 | -$7,912 | Reject | NPV turns negative above IRR |
| NPV profile for the $200,000 production line expansion. The IRR of 23.3% provides a 13.3 percentage point cushion above the 10% WACC — a strong margin of safety. Project remains accept-viable up to a WACC of approximately 23%. | ||||
The NPV profile table reveals the margin of safety concept in capital budgeting: the spread between the IRR and the actual WACC represents how much the cost of capital could increase before the project becomes unviable. For this expansion project, the 13.3 percentage point spread (23.3% IRR minus 10% WACC) provides substantial cushion against both WACC estimation errors and interest rate increases during the project’s life. A project with an IRR of only 10.5% and a WACC of 10% has a margin of safety of only 0.5 percentage points — any small error in the WACC estimate or any rate increase converts a marginally positive NPV into a negative one.
NPV vs IRR: When the Rankings Conflict and Which Wins
For a single investment evaluated in isolation, NPV and IRR always agree on the accept/reject decision: if NPV is positive, IRR exceeds the hurdle rate; if NPV is negative, IRR falls below it. The conflict arises when comparing mutually exclusive projects of different scale or duration, where the project with the higher IRR does not necessarily have the higher NPV. In these cases, finance theory is unambiguous: follow NPV, not IRR, because NPV measures value creation in the currency investors actually care about — dollars.
The three-project comparison above illustrates the classic NPV versus IRR conflict. Project Beta has the highest IRR (18.63%) but the lowest NPV in dollar terms ($13,888). Project Gamma has the lowest IRR (13.19%) but the highest NPV ($27,601) — $13,713 more value than Beta. If these are mutually exclusive projects and the firm can only fund one, the NPV ranking selects Gamma (creates $27,601 in value) while the IRR ranking would incorrectly select Beta (creates only $13,888 in value).
Why NPV Beats IRR for Mutually Exclusive Projects
The IRR preference for Beta over Gamma is a scale illusion: Beta generates a higher return rate on a smaller investment, but Gamma generates more total dollars of value on a larger investment. If the firm has $200,000 of capital available, investing $50,000 in Beta and $150,000 elsewhere at the 8% WACC produces less value than investing $200,000 in Gamma. The IRR-to-NPV conflict always resolves in favor of NPV when the question is “which project creates the most value?” — because NPV directly measures dollar value created. IRR measures a rate that says nothing about absolute scale.
NPV at 8% WACC: Four Capital Projects Compared
The following growth bars compare the NPV of four distinct capital investment scenarios at a common 8% WACC. All four projects have positive NPVs and would be individually accepted under the NPV decision rule, but when ranked by NPV magnitude they reveal very different absolute values created per investment, which determines priority when capital is constrained.
If the company has $500,000 in capital to allocate and can fund multiple projects, the optimal capital allocation using NPV maximization would fund Market Expansion ($300,000 cost, $69,840 NPV) and Equipment Upgrade ($80,000 cost, $19,825 NPV) for a combined $380,000 invested and $89,665 total NPV — more total value than any single project including the Factory Upgrade alone. This multi-project NPV optimization is the foundation of corporate capital budgeting and requires comparing all feasible combinations of projects against the capital constraint, not simply funding projects in descending NPV order.
The Profitability Index: NPV per Dollar for Capital Rationing
The profitability index (PI) translates absolute NPV into a per-dollar-invested metric that enables optimal capital rationing when the budget cannot fund all positive-NPV projects. PI = (NPV + Initial Investment) / Initial Investment = 1 + (NPV / Initial Investment). A PI greater than 1.0 confirms a positive NPV. The PI ranking determines which combination of projects maximizes total NPV created within a fixed capital budget.
| Project | Investment Cost | NPV @ 8% | Profitability Index | PI Rank | Fund? (Budget: $200K) |
|---|---|---|---|---|---|
| Beta | $50,000 | $13,888 | 1.278 | #1 | Yes ($50K used, $13,888 NPV) |
| Alpha | $100,000 | $19,790 | 1.198 | #2 | Yes ($150K used, $33,678 total NPV) |
| Gamma | $200,000 | $27,601 | 1.138 | #3 | No (would require full budget alone) |
| PI ranking outcome: Fund Beta + Alpha = $150K invested, total NPV $33,678. vs Fund Gamma alone = $200K invested, NPV $27,601. PI-based selection creates $6,077 more value than the single highest-NPV project. Remaining $50K after Beta+Alpha earns at 8% WACC (PI=1.00), adding $0 net NPV vs the alternative. | |||||
The profitability index analysis above demonstrates why neither NPV magnitude alone nor IRR alone provides the correct capital rationing solution. Funding Gamma ($200,000, NPV $27,601) appears optimal when ranked by NPV, but funding Beta plus Alpha ($150,000 combined, NPV $33,678) creates more total value. The PI framework finds this solution by identifying the most efficient deployments of capital: Beta at PI 1.278 generates 27.8 cents of NPV per dollar invested; Alpha at PI 1.198 generates 19.8 cents; Gamma at PI 1.138 generates only 13.8 cents. Combining the two highest-PI projects that fit within the budget creates more aggregate NPV than the single highest-NPV project.
Terminal Value in NPV Models: DCF Valuation Applications
For investments with value-generating activities beyond the explicit cash flow projection period, a terminal value must be estimated and included in the final year’s discounted cash flow. Terminal value represents the present value (as of the last explicit year) of all future cash flows beyond that point. In capital project analysis, terminal value typically represents salvage value or equipment disposal proceeds. In business valuation DCF models, terminal value estimated using the perpetuity growth formula often represents 60 to 80 percent of the total enterprise value.
The two most common terminal value methods are the perpetuity growth model and the exit multiple approach. The perpetuity growth model assumes the business generates free cash flow forever at a constant growth rate: Terminal Value = Final Year FCF x (1 + g) / (r – g), where g is the long-term sustainable growth rate and r is the discount rate. At a 3% growth rate and 10% discount rate, a business generating $10 million in FCF in the final explicit year has a terminal value of $10M x 1.03 / (0.10 – 0.03) = $147.1 million. The exit multiple method applies an industry EBITDA or revenue multiple to the projected terminal year financial metric, then discounts that value back to the present.
Terminal Value Sensitivity: The Most Important NPV Input
In a 10-year DCF model for a growth company, the terminal value (discounted to present) can represent 70 to 85% of total enterprise value. A 1 percentage point change in the perpetuity growth rate assumption (g) on a $10M FCF business at a 10% discount rate changes the terminal value by approximately $21 million — from $147M (at 3% growth) to $126M (at 2% growth). Because terminal value is discounted over 10 years, a $21M terminal value difference creates a $8.1M difference in NPV at 10% (since $21M / 1.10^10 = $8.1M). Always report the growth rate assumption explicitly and run sensitivity analysis on the terminal value independently from the near-term cash flow projections.
NPV Sensitivity Analysis: Testing the Decision Under Uncertainty
A single NPV calculation at a point estimate for cash flows and discount rate is inadequate for major capital decisions. Sensitivity analysis identifies which input assumptions most strongly affect the NPV and quantifies the conditions under which the project transitions from positive-NPV to negative-NPV. The goal is not to predict the future with certainty but to understand which variables the investment thesis depends on most heavily.
Three standard sensitivity approaches are: one-way sensitivity analysis (vary one input while holding all others constant, plot NPV vs that input), scenario analysis (define three or more internally consistent scenarios with correlated input changes — base, downside, upside — and calculate NPV under each), and Monte Carlo simulation (randomly sample all uncertain inputs from probability distributions thousands of times to generate a full probability distribution of NPV outcomes, including the probability that NPV is negative). For most capital budgeting applications, scenario analysis provides the most practical insight at manageable analytical cost.
One-Way Sensitivity: The Production Line Expansion
For the $200,000 expansion project at 10% WACC: (1) If annual revenue is 10% lower than base case in all years, NPV falls from $84,677 to approximately $57,100 — still positive. (2) If the discount rate rises from 10% to 15% (due to increased risk perception), NPV falls from $84,677 to $47,341 — still positive. (3) If the project costs $250,000 instead of $200,000 (50K cost overrun), NPV falls from $84,677 to $34,677 — still positive. (4) If cash flows are 25% below base case AND cost overruns 15%, NPV falls below zero. The intersection of multiple adverse scenarios represents the actual risk to the investment decision.
Applying NPV Correctly: The Capital Budgeting Checklist
Frequently Asked Questions: Net Present Value
What is net present value (NPV)?+
Net present value (NPV) is the sum of the present values of all cash flows from an investment, including the initial cost. NPV = C0 + C1/(1+r) + C2/(1+r)^2 + … + Cn/(1+r)^n, where C0 is the initial investment (negative), C1 through Cn are future cash inflows, and r is the discount rate per period. NPV measures the dollar value created or destroyed by the investment above and beyond recovering the cost of capital. A positive NPV means the investment earns more than the required rate of return, creating value. A negative NPV means it earns less, destroying value. NPV is measured in dollars, not percentages.
What is the NPV decision rule?+
The NPV decision rule: accept an investment if NPV is greater than zero; reject if less than zero; be indifferent if equal to zero. When NPV is positive, the investment generates returns exceeding the cost of capital, creating value. When NPV is negative, it generates insufficient returns to cover the cost of capital, destroying value. For mutually exclusive projects (where only one can be chosen), select the project with the highest positive NPV — it creates the most absolute dollar value. For independent projects under capital constraints, rank by profitability index (NPV/Investment) to maximize value per dollar of capital deployed.
What is the NPV formula and how do I use it in Excel?+
The NPV formula is NPV = sum of [Ct / (1+r)^t] for t = 0 to n, where Ct is the cash flow at time t and r is the periodic discount rate. In Excel: enter the initial investment as a negative number in cell A1 and future cash flows in A2 through An. Formula: =NPV(rate, A2:An) + A1. Important: Excel’s NPV() function starts discounting from period 1, not period 0. The period-0 initial investment must be added separately and is already in present value terms (no discounting needed). For irregular dates: =XNPV(rate, cash_flows, dates) where dates is a parallel column of actual calendar dates.
What is an NPV profile?+
An NPV profile is a graph plotting NPV against discount rate, showing how the investment’s value changes at all possible cost of capital levels. The profile always slopes downward: NPV is highest at low discount rates and decreases as rates rise. The x-axis intercept (where NPV = 0) is the IRR. The slope reveals duration risk: steep profiles indicate cash flows concentrated far in the future (high sensitivity to rate changes); flat profiles indicate near-term cash flows (low rate sensitivity). The spread between the IRR and the actual WACC on the NPV profile represents the project’s margin of safety — how much rates could rise before the project becomes unviable.
What is the difference between NPV and IRR?+
NPV measures dollar value created at a specific discount rate. IRR finds the specific rate where NPV equals zero. NPV requires knowing the discount rate first; IRR finds it implicitly. NPV outputs dollars (e.g., +$84,677); IRR outputs a percentage (e.g., 23.3%). For independent projects, both metrics agree: positive NPV corresponds to IRR exceeding the hurdle rate. They conflict for mutually exclusive projects of different scale: a smaller project may have higher IRR but lower NPV than a larger project. Finance theory recommends NPV as the primary metric because it measures what shareholders actually care about — dollar value created — not a percentage that ignores investment scale.
What is the profitability index and when do I use it?+
The profitability index (PI) is NPV per dollar invested: PI = (NPV + Initial Investment) / Initial Investment = 1 + (NPV / Initial Investment). A PI above 1.0 indicates a positive NPV. PI is used for capital rationing — when a budget constraint prevents funding all positive-NPV projects. Rank projects by PI (highest first) and fund in descending PI order until the budget is exhausted. This maximizes total NPV created per dollar of scarce capital. Example: with $150,000 budget, fund a $50,000 project at PI 1.278 and a $100,000 project at PI 1.198 rather than a single $200,000 project at PI 1.138 — the former combination creates more total NPV despite the lower individual NPVs.
How does terminal value affect NPV?+
Terminal value represents the value of all cash flows beyond the explicit projection period and is added to the final year’s cash flow before discounting. In business valuations, terminal value calculated using the perpetuity growth formula (TV = Final CF x (1+g) / (r-g)) is then discounted back over the full projection horizon. For a 10-year DCF at 10% WACC with 3% terminal growth, a $10M final-year FCF has a terminal value of $147M, which discounts to $56.7M today ($147M / 1.10^10). This often represents 60 to 80% of total enterprise value. Terminal value is extremely sensitive to the growth rate and discount rate assumptions and requires independent sensitivity analysis.
How is NPV used in real estate investment analysis?+
Real estate NPV discounts all projected cash flows to their present value and subtracts the acquisition cost. For a rental property: C0 = negative purchase price plus closing costs; annual cash flows = net operating income (NOI) minus debt service; terminal cash flow = net sale proceeds (sale price minus outstanding mortgage minus selling costs). A positive NPV at the investor’s required return means the property generates returns exceeding the cost of capital, creating investment value. Sensitivity analysis should stress NOI (occupancy and rent), exit cap rate (affects sale price), and holding period. Most sophisticated real estate investors use IRR alongside NPV to evaluate leveraged equity returns.
What is incremental NPV and when should I use it?+
Incremental NPV is the NPV of the difference in cash flows between two mutually exclusive projects (larger project minus smaller project). When NPV and IRR rankings conflict for mutually exclusive projects, calculate the incremental cash flows, find the incremental IRR, and compare it to the hurdle rate. If the incremental IRR exceeds the hurdle rate, the larger project is preferred despite the lower overall IRR. For the Alpha vs Gamma comparison: incremental investment = $100,000 (Gamma’s $200K minus Alpha’s $100K); incremental annual CF = $27,000/yr. The incremental IRR is approximately 11.3%, which exceeds the 8% WACC, confirming Gamma is the correct choice despite lower IRR. This is the theoretically rigorous resolution to the NPV vs IRR conflict.
Key Takeaways
Net present value is the theoretically superior capital budgeting metric because it directly measures dollar value created, correctly accounts for the timing of all cash flows, and avoids the reinvestment rate assumption flaw that causes IRR to overstate returns for high-yield projects. The NPV formula NPV = C0 + C1/(1+r) + C2/(1+r)^2 + … + Cn/(1+r)^n is the mathematical expression of a simple economic question: does this investment generate returns above the cost of capital, and if so, by how many dollars?
The three most important NPV implementation disciplines are: using after-tax free cash flows (not accounting profits), applying the correct risk-adjusted discount rate (WACC for corporate projects, opportunity cost for personal investments), and including all relevant cash flows including opportunity costs, working capital changes, and terminal value. The NPV profile visualization, the profitability index for capital rationing, and the incremental NPV analysis for mutually exclusive projects extend the basic NPV framework into a complete capital allocation toolset. Together with IRR and MIRR, NPV provides the complete quantitative foundation for any serious investment decision where future cash flows must be compared against today’s cost of capital.
Calculate NPV for Any Investment with Full Analytical Precision
Our NPV Calculator discounts any cash flow series at your WACC, generates the complete NPV profile across all discount rates, calculates the profitability index for capital rationing, and computes IRR alongside NPV for complete capital budgeting analysis.
Launch the NPV Calculator