NPV Examples
Example 1 - Equipment Purchase: Machine costs $50,000, generates $15,000/year savings for 4 years, 10% discount rate. Year 1 PV: $13,636; Year 2: $12,397; Year 3: $11,270; Year 4: $10,245. Total PV: $47,548. NPV: -$2,452. Decision: Reject—doesn't meet required return threshold.
Example 2 - Software Implementation: Cost: $100,000. Year 1 benefit: $40,000; Year 2: $50,000; Year 3: $60,000. Discount rate: 12%. PV Year 1: $35,714; Year 2: $39,859; Year 3: $42,710. Total PV: $118,283. NPV: $18,283. Decision: Accept—creates $18,283 in value above cost of capital.
Example 3 - Marketing Campaign: Cost: $25,000. Returns: Year 1: $15,000; Year 2: $20,000. Discount rate: 15%. PV Year 1: $13,043; Year 2: $15,123. Total PV: $28,166. NPV: $3,166. Decision: Marginal—positive but small NPV suggests modest value creation.
Who Should Use This Calculator?
Financial managers and CFOs use NPV for capital budgeting decisions, evaluating equipment purchases, facility expansions, and major projects. It provides the most accurate measure of value creation.
Business owners assessing new ventures or product launches need NPV analysis to determine if projected returns justify the investment and risk. It helps prioritize limited capital across competing opportunities.
Investors evaluating real estate, private equity, or business acquisitions use NPV to model scenarios and determine fair purchase prices based on expected future cash flows discounted appropriately.
Frequently Asked Questions
What is Net Present Value (NPV)?
NPV is the difference between the present value of cash inflows and the present value of cash outflows over a period of time. It represents the absolute dollar value created (if positive) or destroyed (if negative) by an investment. Formula: NPV = Σ [Cash Flow_t / (1 + r)^t] - Initial Investment where r = discount rate, t = time period. Interpretation: NPV > 0: Investment creates value—accept. NPV = 0: Investment meets required return exactly—indifferent. NPV < 0: Investment destroys value—reject.
How do I choose the discount rate for NPV?
The discount rate should reflect your opportunity cost of capital: Corporate Projects: Use WACC (Weighted Average Cost of Capital)—typically 8-12%. Personal Investments: Use your required rate of return—often 7-10% for conservative investors, higher for aggressive. Real Estate: Often 10-15% reflecting illiquidity and risk. Venture/Startups: 15-30%+ reflecting high failure risk. Risk Adjustment: Higher risk projects need higher discount rates. Inflation: Use nominal rate with nominal cash flows; real rate with inflation-adjusted cash flows.
What is the difference between NPV and PV?
PV (Present Value): The current worth of a future sum of money or stream of cash flows given a specified rate of return. NPV (Net Present Value): PV of inflows minus PV of outflows (including initial investment). Example: Investment costs $10,000. Future cash flows have PV of $12,000. PV of inflows: $12,000. NPV: $12,000 - $10,000 = $2,000. Key Difference: PV doesn't consider investment cost; NPV is net of all costs. NPV is the decision metric—PV alone doesn't tell you if an investment is worthwhile.
Can NPV be negative?
Yes, negative NPV means the investment's returns don't justify the cost of capital. Interpretation: Project earns less than the discount rate. Value would be destroyed if undertaken. Decision: Reject the project. However, consider: Strategic Value: Some projects have non-financial benefits (market position, learning). Required Projects: Regulatory compliance may force negative NPV investments. Real Options: Future opportunities may justify modest negative NPV today. Sunk Costs: Don't continue projects just because you've already spent money—evaluate marginal NPV.
What is the NPV rule?
The NPV decision rule: Accept projects with NPV > 0. Reject projects with NPV < 0. Indifferent to projects with NPV = 0. Mutually Exclusive Projects: Choose the one with highest positive NPV. Independent Projects: Accept all with NPV > 0 (if capital available). Capital Rationing: Rank by NPV or profitability index and select best combination within budget. Why it works: NPV directly measures wealth creation in today's dollars. Positive NPV means you're earning more than your cost of capital, creating shareholder or personal value.
How does inflation affect NPV calculations?
Two approaches: Nominal Approach: Use nominal cash flows (including inflation) with nominal discount rate. Real Approach: Use inflation-adjusted cash flows with real discount rate (nominal rate minus inflation). Consistency is critical—never mix nominal cash flows with real discount rates or vice versa. Example: 3% inflation, 10% nominal discount rate, $100 cash flow in year 1. Nominal: $103 cash flow, 10% discount rate. Real: $100 cash flow, ~6.8% real discount rate (1.10/1.03 - 1). Both give same NPV result. Most practitioners use nominal approach as it's more intuitive.
What is the profitability index and how does it relate to NPV?
Profitability Index (PI) = Present Value of Future Cash Flows / Initial Investment. Relationship to NPV: PI > 1 means NPV > 0 (accept). PI < 1 means NPV < 0 (reject). PI = 1 means NPV = 0 (indifferent). When to use PI: Capital Rationing: When you can't fund all positive NPV projects, PI helps rank by efficiency (return per dollar invested). Resource Allocation: Choose highest PI projects first until capital exhausted. Limitation: PI can favor smaller projects over larger value creators—use NPV when comparing mutually exclusive projects.
How do I calculate NPV with unequal time periods?
For irregular cash flow timing, use XNPV (Excel function) or adjust manually: XNPV Formula: Accounts for exact dates of each cash flow. More precise than assuming year-end cash flows. Manual Calculation: NPV = ÎŁ [Cash Flow_i / (1 + r)^((Date_i - Date_0)/365)] where dates are actual calendar dates. Example: Investment Jan 1, return June 30. Time = 0.5 years. Discount factor = (1.10)^0.5 = 1.0488. Most business projects assume year-end for simplicity, but XNPV is more accurate for precise analysis.
What is the discount factor in NPV?
The discount factor converts future cash flows to present value. Formula: Discount Factor = 1 / (1 + r)^t where r = discount rate, t = time period. Example: 10% discount rate. Year 1: 1 / (1.10)^1 = 0.909. Year 2: 1 / (1.10)^2 = 0.826. Year 3: 1 / (1.10)^3 = 0.751. Application: Future Value × Discount Factor = Present Value. $100 in year 3 at 10% = $100 × 0.751 = $75.10 today. Discount factors decrease over time—money further in the future is worth less today.
Should I use NPV or IRR for investment decisions?
NPV is generally preferred for these reasons: Absolute Value: NPV shows dollar value created; IRR shows percentage. Wealth Maximization: NPV directly measures shareholder/personal wealth increase. Reinvestment Assumption: NPV assumes reinvestment at discount rate (more realistic); IRR assumes reinvestment at IRR (often unrealistic). Multiple Solutions: IRR can have multiple values; NPV is unique. Scale: NPV properly accounts for project size—larger projects can have lower IRR but higher NPV. Use IRR when: Comparing efficiency of similar-sized projects. Communicating with non-financial stakeholders (percentages are intuitive). Quick screening before detailed NPV analysis. Best Practice: Calculate both. If they conflict, trust NPV.