Net Present Value Calculator
Evaluate investment opportunities with NPV analysis, IRR, payback period, and profitability index
Investment Details
Upfront cost (will be treated as negative)
Minimum acceptable rate of return
Comma-separated values (Year 1, Year 2, etc.)
Project Duration: 5 years
Net Present Value (NPV)
NPV at 10.0% discount rate
$48,033
✓ Accept this investment
This project creates value and exceeds the required return.
Key Investment Metrics
Initial Investment
$100,000
PV of Cash Inflows
$148,033
Profitability Index
1.48
$1.48 return per $1 invested
Internal Rate of Return
25.75%
Exceeds required 10.0%
Payback Analysis
Simple Payback Period
2.9 years
Time to recover initial investment
Discounted Payback Period
4.4 years
Payback considering time value of money
Investment Decision Summary
NPV Test
Positive NPV - Accept
IRR Test
IRR (25.8%) exceeds required return - Accept
Profitability Index Test
PI = 1.48 > 1.0 - Accept
Related Calculators
Frequently Asked Questions
What is a good NPV?
Any positive NPV is technically "good" because it means the investment creates value above the required return. However, higher NPV is better. In practice, NPV should be evaluated relative to: (1) The size of the initial investment (use Profitability Index for efficiency), (2) Alternative investment opportunities, (3) Project risk and strategic importance, (4) Capital constraints. A $10,000 NPV on a $50,000 investment (20% return) may be better than $50,000 NPV on a $1,000,000 investment (5% return).
What discount rate should I use?
The discount rate should reflect the opportunity cost and risk of the investment. Common approaches: (1) WACC(Weighted Average Cost of Capital) for corporate projects, (2) Required return based on comparable investments with similar risk, (3) Safe rate + risk premium (e.g., Treasury yield + 5-10% for business projects), (4) Personal hurdle rate for individual investments (often 8-15%). Higher risk = higher discount rate. Conservative: use higher rates. Aggressive: use lower rates.
What's the difference between NPV and IRR?
NPV measures the dollar value created at a given discount rate. IRR measures the rate of return the project generates (the discount rate where NPV = 0). NPV assumes reinvestment at the discount rate; IRR assumes reinvestment at the IRR itself (often unrealistic). When they conflict (e.g., mutually exclusive projects), NPV is generally the better decision criterion because it directly measures value creation. Accept projects where IRR > required return, which is equivalent to NPV > 0 at that required return.
How do I estimate future cash flows?
Use conservative, realistic projections based on: (1) Historical data: Past performance of similar projects, (2) Market research: Industry trends, competitor analysis, customer surveys, (3) Financial modeling: Revenue forecasts minus all operating costs, taxes, capex, (4) Sensitivity analysis: Test best-case, base-case, and worst-case scenarios. Include: operating cash flows, tax effects, working capital changes, salvage value, and terminal value. Exclude: sunk costs, interest payments (captured in discount rate), and accounting depreciation.
Should I use NPV or payback period?
Use both, but prioritize NPV. NPV measures profitability and accounts for the time value of money. Payback period measures liquidity and risk (how quickly you recover capital). NPV is superior for investment decisions because it considers all cash flows and directly measures value creation. Payback period is supplementary—useful for risk-averse investors or when liquidity is critical. Example: A 2-year payback with negative NPV is still a bad investment; a 7-year payback with high positive NPV may be excellent.
How do taxes affect NPV?
Always use after-tax cash flows in NPV calculations. Taxes reduce cash inflows (you keep only after-tax profit) and can create tax shields (depreciation, interest deductions reduce taxable income). Example: If a project generates $100,000 pre-tax profit and you're in a 30% tax bracket, use $70,000 in the NPV calculation. Depreciation doesn't reduce cash flow directly, but it reduces taxes: if you have $50,000 depreciation, you save $50,000 × 30% = $15,000 in taxes, which increases after-tax cash flow.
What if cash flows change from year to year?
NPV handles irregular cash flows perfectly—that's one of its strengths. Enter each year's expected cash flow individually. Growing businesses often have increasing cash flows; mature businesses may have declining flows. Example: Year 1: $20,000, Year 2: $30,000, Year 3: $40,000, Year 4: $35,000, Year 5: $30,000. Each is discounted to present value using the appropriate time period. This flexibility makes NPV ideal for real-world projects with variable cash flows.
Can NPV be negative?
Yes, and negative NPV means the project destroys value—the return is below the required rate. Reject negative NPV projects unless there are compelling non-financial reasons (strategic positioning, regulatory compliance, brand building, market entry). Example: A project with -$50,000 NPV at 10% discount rate means you'd be better off investing the money elsewhere at 10%. Some projects may have negative NPV but positive strategic value (e.g., a loss leader product that drives other profitable sales).
How do I compare projects of different sizes?
Use Profitability Index (PI) instead of NPV to compare efficiency. PI = PV of Inflows / Initial Investment. A $20,000 NPV on $50,000 investment (PI = 1.4) may be better than $50,000 NPV on $500,000 investment (PI = 1.1) if capital is limited. If capital is unlimited and projects aren't mutually exclusive, choose all projects with positive NPV. If capital is constrained, rank by PI and select projects until budget is exhausted.
How accurate is NPV analysis?
NPV is only as accurate as your inputs (cash flow forecasts, discount rate). It's a decision-making framework, not a crystal ball. Improve accuracy with: (1) Sensitivity analysis: Test how NPV changes with different assumptions, (2) Scenario analysis: Best-case, base-case, worst-case projections, (3) Monte Carlo simulation: Probability-weighted outcomes, (4) Conservative estimates: When uncertain, err on the side of caution. Even imperfect NPV analysis is better than intuition alone.