NPV Calculator
Enter an initial investment and future cash flows to calculate Net Present Value, Internal Rate of Return (IRR), and Profitability Index. Choose even cash flows (same amount each year) or custom cash flows (different amounts per year).
Year-by-Year Present Value Breakdown
| Year | Cash Flow | Discount Factor | Present Value | Cumulative PV |
|---|
How NPV Is Calculated
Net Present Value converts future cash flows into today's dollars using a discount rate. The formula sums all discounted cash flows and subtracts the initial investment:
Where:
- C₀ = Initial investment (cash outflow at Year 0)
- CFₜ = Cash flow in year t
- r = Discount rate (decimal)
- n = Total number of periods (years)
Each future cash flow is divided by (1 + r) raised to the power of its year number. This "discounting" accounts for the time value of money: a dollar received today is worth more than a dollar received in the future.
How the Discount Rate Works
The discount rate represents your required rate of return or cost of capital. It answers the question: "What return could I earn on an equally risky alternative investment?"
| Scenario | Typical Discount Rate | Rationale |
|---|---|---|
| Government bonds (low risk) | 3--5% | Risk-free baseline |
| Corporate WACC | 8--12% | Blended cost of debt and equity |
| Private equity / VC | 15--25% | Higher risk, higher required return |
| Startup ventures | 25--50% | Very high uncertainty |
A higher discount rate makes future cash flows worth less in present terms, producing a lower NPV. This reflects the principle that riskier investments require higher expected returns to be attractive.
NPV vs. IRR: When to Use Each
Both NPV and IRR are widely used in capital budgeting, but they answer different questions:
| Metric | What It Tells You | Decision Rule | Best For |
|---|---|---|---|
| NPV | Dollar amount of value created | Accept if NPV > 0 | Comparing projects of different sizes |
| IRR | Effective annual return rate | Accept if IRR > cost of capital | Quick assessment of return percentage |
| PI | Value per dollar invested | Accept if PI > 1.0 | Ranking projects when capital is limited |
When NPV and IRR Disagree
For mutually exclusive projects with different scales, NPV and IRR can give conflicting signals. A small project might have a higher IRR (say 40%) but create less total value than a larger project with a lower IRR (say 20%) but much higher NPV. In these cases, NPV is the more reliable guide because it measures absolute value creation.
NPV Decision Rules
| Condition | Meaning | Action |
|---|---|---|
| NPV > 0 | Investment earns more than the discount rate | Accept -- creates value |
| NPV = 0 | Investment earns exactly the discount rate | Indifferent -- no value added |
| NPV < 0 | Investment earns less than the discount rate | Reject -- destroys value |
| IRR > discount rate | Return exceeds required minimum | Favorable |
| PI > 1.0 | PV of inflows exceeds the investment | Favorable |
Important: NPV is a financial model, not a crystal ball. It depends on your estimates of future cash flows and your choice of discount rate. Sensitivity analysis -- recalculating NPV with different assumptions -- is critical for making robust decisions.
Examples
Example 1 -- Equipment Purchase
Scenario: A company is considering buying equipment for $50,000 that will generate $15,000/year for 5 years. Discount rate: 10%.
- Year 1 PV: $15,000 / 1.10 = $13,636
- Year 2 PV: $15,000 / 1.21 = $12,397
- Year 3 PV: $15,000 / 1.331 = $11,270
- Year 4 PV: $15,000 / 1.4641 = $10,245
- Year 5 PV: $15,000 / 1.6105 = $9,314
- Total PV: $56,862
- NPV = $56,862 - $50,000 = $6,862
- PI = $56,862 / $50,000 = 1.14
- Decision: Accept (NPV positive, PI > 1)
Example 2 -- Growing Cash Flows
Scenario: $200,000 investment with uneven returns: Year 1: $40,000, Year 2: $60,000, Year 3: $80,000, Year 4: $70,000, Year 5: $50,000. Discount rate: 12%.
- Year 1 PV: $35,714
- Year 2 PV: $47,832
- Year 3 PV: $56,943
- Year 4 PV: $44,487
- Year 5 PV: $28,371
- Total PV: $213,347
- NPV = $213,347 - $200,000 = $13,347
- Decision: Accept
Frequently Asked Questions
What is Net Present Value (NPV)?
NPV is the difference between the present value of all future cash inflows and the initial investment. It tells you, in today's dollars, how much value an investment will create (positive NPV) or destroy (negative NPV) after accounting for the time value of money.
How do you calculate NPV?
Subtract the initial investment from the sum of all future cash flows, each divided by (1 + discount rate) raised to the power of the year number. For example, a $10,000 cash flow in Year 3 at a 10% discount rate has a present value of $10,000 / (1.10)^3 = $7,513.
What is a good discount rate to use?
The discount rate should reflect the risk level and opportunity cost of the investment. Companies often use their Weighted Average Cost of Capital (WACC). Individual investors might use the expected return from alternative investments such as the stock market (historically around 8-10% nominal). Higher-risk projects warrant higher discount rates.
What is IRR and how does it relate to NPV?
The Internal Rate of Return (IRR) is the discount rate that makes NPV exactly zero. If the IRR exceeds your required rate of return, the investment is attractive. IRR gives a percentage return, while NPV gives a dollar value -- both are useful, but NPV is generally preferred for decision-making.
What is the Profitability Index?
The Profitability Index (PI) equals the present value of future cash flows divided by the initial investment. A PI of 1.25 means every $1 invested generates $1.25 in present-value terms. PI is especially useful when comparing multiple projects and you have limited capital.
Can NPV be negative?
Yes. A negative NPV means the investment's present value of cash inflows is less than the initial cost. The project would destroy value at the given discount rate. Unless there are strong strategic reasons, negative-NPV projects should typically be rejected.
What are the limitations of NPV?
NPV relies on estimates of future cash flows and the chosen discount rate, both of which involve uncertainty. It does not account for project flexibility (real options), strategic value, or non-financial considerations. It also assumes cash flows can be reinvested at the discount rate.
Does this calculator store my data?
No. All calculations run entirely in your browser. No financial data is sent to any server, and nothing is stored.
Related Tools
- ROI Calculator -- calculate return on investment as a percentage
- IRR Calculator -- calculate internal rate of return for cash flow series
- Payback Period Calculator -- find how long it takes to recover an investment
- Compound Interest Calculator -- calculate compound growth over time
- Present Value Calculator -- find today's value of a future sum
- WACC Calculator -- calculate weighted average cost of capital
- Break-Even Calculator -- determine when revenue covers costs
Privacy & Limitations
Privacy: This calculator runs entirely in your browser. No financial data is transmitted or stored anywhere.
Limitations: NPV is a financial projection tool, not a guarantee of returns. Actual results depend on the accuracy of your cash flow estimates and the appropriateness of your discount rate. This tool is for educational and planning purposes and should not replace professional financial advice.
Related Tools
View all toolsSimple Interest Calculator
Calculate simple interest and total amount
Loan Calculator
Calculate monthly payments and total interest
Loan Amortization Schedule
Generate a full payment-by-payment breakdown with principal, interest, and balance
Mortgage Calculator
Estimate mortgage payments and totals
Refinance Calculator
Calculate break-even point on mortgage refinancing and compare monthly savings
Compound Interest Calculator
Calculate compound growth over time
Net Present Value Calculator FAQ
What is Net Present Value (NPV)?
Net Present Value (NPV) is the difference between the present value of future cash inflows and the initial investment. It discounts each future cash flow back to today's value using a discount rate. A positive NPV means the investment is expected to generate more value than it costs.
How do you calculate NPV?
NPV = -Initial Investment + CF1/(1+r)^1 + CF2/(1+r)^2 + ... + CFn/(1+r)^n, where CF is the cash flow for each period, r is the discount rate, and n is the number of periods. Each future cash flow is divided by (1 + discount rate) raised to the power of its period number.
What is a good discount rate to use?
The discount rate should reflect the opportunity cost of capital and the risk of the investment. Common choices include the company's weighted average cost of capital (WACC), the expected return of alternative investments, or the required rate of return. Typical ranges are 8-15% for corporate projects and 10-25% for riskier ventures.
What is the difference between NPV and IRR?
NPV gives you a dollar amount showing how much value an investment creates or destroys. IRR (Internal Rate of Return) is the discount rate that makes NPV equal to zero -- it tells you the effective annual return rate. NPV is generally preferred for decision-making because it shows absolute value creation, while IRR shows relative return percentage.
What is the profitability index?
The Profitability Index (PI) is the ratio of the present value of future cash flows to the initial investment. PI = PV of cash flows / Initial Investment. A PI greater than 1.0 means the investment creates value. PI is useful for ranking projects when capital is limited.
Should I accept or reject a project based on NPV?
The general rule is: Accept if NPV > 0 (the project creates value), Reject if NPV < 0 (the project destroys value). If NPV = 0, the project earns exactly the discount rate. Also consider IRR relative to your required return and the profitability index for capital rationing decisions.
Does this calculator store my data?
No. All calculations run entirely in your browser. No data is sent to any server, and nothing is stored.