Net Present Value (NPV) Calculator
Is a Project Worth More Than It Costs, in Today's Dollars?
Net present value is the standard by which capital budgeting decisions get made: it discounts every future cash flow a project is expected to generate back to today's dollars, sums them, and subtracts the upfront cost. A positive NPV means the project is expected to create value beyond the required rate of return; a negative NPV means it destroys value even before accounting for anything going wrong.
The Formula
Each year's cash flow is discounted individually by the discount rate r raised to the power of that year's position, then all discounted values are summed and the initial investment is subtracted.
Where This Matters
- Capital budgeting — businesses use NPV as the primary screen for whether to fund a new project, purchase equipment, or expand a facility.
- Comparing mutually exclusive projects — when only one of several proposals can be funded, ranking by NPV (not just by size of return) identifies which creates the most absolute value.
- Choosing the right discount rate matters as much as the cash flows — a project's NPV can flip from positive to negative depending on the discount rate used, which is usually tied to the company's cost of capital.
Worked Example
| Year | Cash flow | Present value |
|---|---|---|
| 1 | $3,000 | $2,777.78 |
| 2 | $4,000 | $3,429.36 |
| 3 | $4,000 | $3,175.33 |
| 4 | $3,000 | $2,205.09 |
| Net Present Value | $1,587.55 | |
Since NPV is positive, the project is expected to generate more value than its cost at an 8% required return — a signal to accept it under standard capital budgeting criteria.
How to Use This Calculator
- Enter the initial investment (upfront cost).
- Enter the discount rate (your required rate of return or cost of capital).
- Enter the expected yearly cash flows, comma-separated, in order (e.g.
3000,4000,4000,3000). - Select Calculate to see each year's discounted value, the net present value, and an accept/reject verdict.
Related Calculations
Find the exact break-even discount rate with the Internal Rate of Return (IRR) Calculator, or see how quickly the investment is recovered with the Payback Period Calculator.
Principles of Capital Budgeting and Net Present Value (NPV)
A Net Present Value (NPV) calculator evaluates corporate capital investment projects, acquisitions, and equipment purchases by computing the net surplus economic value generated after discounting all future projected cash inflows and subtracting the initial upfront capital expenditure. In corporate financial strategy, NPV represents the gold standard metric for shareholder wealth maximization.
The Fundamental Net Present Value Formula and Decision Rules
Where CFt = Net cash inflow in period t | r = Discount rate (WACC / Hurdle Rate) | C0 = Initial Upfront Outlay
Profitability Index: PI = ( Present Value of Future Cash Inflows ) / Initial Capital Outlay (C0)
The NPV Investment Decision Framework
| NPV Output Result | Corporate Decision Recommendation | Impact on Shareholder Value |
|---|---|---|
| NPV > $0.00 (Positive NPV) | ACCEPT PROJECT | Directly expands shareholder net worth; earns return > hurdle rate |
| NPV = $0.00 (Zero NPV) | Indifferent / Marginal | Project earns precisely the cost of capital (WACC); zero excess surplus |
| NPV < $0.00 (Negative NPV) | REJECT PROJECT | Destroys corporate shareholder value; earns return < cost of capital |
Step-by-Step Worked Calculation Example
Example: Evaluating a $150,000 Factory Automation Equipment Purchase
Problem: A manufacturing plant considers buying a robotic packaging system for C0 = $150,000. It generates projected net cash savings: Year 1 = $45,000; Year 2 = $55,000; Year 3 = $60,000; Year 4 = $50,000. Corporate discount rate (WACC) = 9.0%. Calculate: (1) Discounted PV of each annual cash flow; (2) Total project NPV; and (3) Final corporate investment decision.
Step 1: Discount Individual Annual Cash Flows at 9.0%:
PV Year 1 = $45,000 / ( 1.09 )1 = $41,284.40
PV Year 2 = $55,000 / ( 1.09 )2 = $46,292.40
PV Year 3 = $60,000 / ( 1.09 )3 = $46,331.00
PV Year 4 = $50,000 / ( 1.09 )4 = $35,421.60
Step 2: Sum Present Values:
Total PV Inflows = $41,284.40 + $46,292.40 + $46,331.00 + $35,421.60 = $169,329.40
Step 3: Compute Net Present Value (NPV = PV Inflows - Outlay):
NPV = $169,329.40 - $150,000.00 = +$19,329.40 Positive Net Surplus
Conclusion: Because NPV is positive (+$19,329), management accepts the project, adding $19,329 in net enterprise value.
NPV vs. IRR Ranking Conflicts in Mutually Exclusive Projects
When choosing between two mutually exclusive corporate investment proposals, NPV and IRR can yield conflicting project rankings due to The Scale Problem:
- Project A: Invest $10,000 to earn $15,000 (IRR = 50.0% | NPV at 10% = +$3,636).
- Project B: Invest $1,000,000 to earn $1,250,000 (IRR = 25.0% | NPV at 10% = +$136,364!).
While Project A delivers a higher percentage IRR, Project B generates $136,364 in pure net wealth for shareholders compared to only $3,636 for Project A. Financial finance theory mandates that NPV always takes absolute precedence over IRR.
Equivalent Annual Annuity (EAA) for Unequal Project Lives
When comparing two capital investment proposals with different economic useful lifespans (e.g., Machine A lasts 4 years while Machine B lasts 8 years):
Standard NPV is biased toward longer-lived projects. Corporate analysts compute the Equivalent Annual Annuity (EAA):
The proposal delivering the higher annualized EAA cash contribution provides superior long-term capital efficiency across ongoing replacement cycles.
Sensitivity and Scenario Modeling in NPV Analysis
Corporate CFOs never rely on a single deterministic NPV calculation; financial analysts perform rigorous Monte Carlo Simulations and 2D Sensitivity Tables:
Varying the corporate discount rate (WACC ± 2.0%) and base revenue growth projections (± 15%) generates an expected probability distribution of positive vs. negative NPV outcomes, ensuring capital is allocated only to resilient, downside-protected projects.
Real Options Valuation in High-Risk NPV Projects
In pharmaceutical drug discovery and natural resource exploration, traditional static NPV often undervalues projects with multi-stage flexibility:
Incorporating Real Options Analysis (the managerial flexibility to expand, delay, or abandon a project at future decision gates) captures the asymmetric upside value of strategic corporate investments.
Capital Rationing and Profitability Index Ranking
When a corporation faces a strict capital expenditure budget ceiling (e.g., maximum $5M CapEx allowance):
Management ranks projects by Profitability Index (PI = PV Inflows / Cost), selecting the combination of positive NPV projects that maximizes total enterprise value within the fixed capital budget.
Post-Audit Investment Reviews
Leading corporations perform mandatory Post-Completion Audits (12 to 24 months post-launch) comparing actual operational cash flows against original NPV financial projections, refining future capital budgeting accuracy.
Strategic Value Maximization
Adhering strictly to positive Net Present Value decision criteria ensures corporate capital expenditures consistently expand enterprise market capitalization.
Corporate Capital Discipline
Enforcing strict positive NPV hurdles ensures executive management allocates corporate capital only to high-return initiatives that generate sustainable economic value for long-term shareholders.
Disciplined Capital Allocation
Net Present Value analysis remains the bedrock standard for maximizing enterprise value and protecting corporate balance sheets.