Calculate Net Present Value
How NPV Works
Net Present Value (NPV) is a financial metric used to evaluate the profitability of an investment or project. It calculates the present value of all expected cash flows — both inflows and outflows — discounted at a specified rate.
The NPV formula is:
Where:
- CF_t = cash flow in period t (negative for outflows, positive for inflows)
- r = discount rate (as a decimal)
- t = time period (typically in years, starting at 0)
- n = total number of periods
The discount factor for each period is 1 / (1 + r)^t. This reflects the time value of money: a dollar received today is worth more than a dollar received in the future because it can be invested and earn returns.
Decision Rule
- NPV > 0: Accept the project. The present value of inflows exceeds outflows, creating value.
- NPV < 0: Reject the project. The present value of outflows exceeds inflows, destroying value.
- NPV = 0: The project breaks even in present value terms.
NPV is widely used in capital budgeting because it provides a direct measure of how much value a project is expected to add or subtract.
Profitability Index
The profitability index (PI) is calculated as:
A PI greater than 0 indicates a profitable project. The profitability index is useful for ranking and comparing projects when capital is limited, as it shows the value created per dollar invested.
NPV Examples
Example 1: Simple Project Evaluation
A company is considering a project that requires an initial investment of $50,000. The project is expected to generate the following cash flows:
- Year 1: $15,000
- Year 2: $20,000
- Year 3: $25,000
The company's required rate of return is 10%. Let's calculate the NPV:
- Year 0: -$50,000 / (1.10)^0 = -$50,000
- Year 1: $15,000 / (1.10)^1 = $13,636
- Year 2: $20,000 / (1.10)^2 = $16,529
- Year 3: $25,000 / (1.10)^3 = $18,783
NPV = -$50,000 + $13,636 + $16,529 + $18,783 = -$1,052
The NPV is negative, so the project should be rejected. The present value of expected returns does not exceed the initial investment at the 10% discount rate.
Example 2: Comparing Projects
Two projects require the same $100,000 initial investment but have different cash flow profiles:
Project A:
- Year 1: $40,000
- Year 2: $40,000
- Year 3: $40,000
Project B:
- Year 1: $20,000
- Year 2: $40,000
- Year 3: $60,000
At a 10% discount rate:
- Project A NPV: approximately $5,474
- Project B NPV: approximately $3,136
Both projects have positive NPV and should be accepted if capital is available. However, Project A creates more value because its cash flows arrive earlier, allowing them to be discounted less.
Example 3: Impact of Discount Rate
Consider a project with an initial investment of $80,000 and expected cash flows of $30,000 per year for four years. The NPV varies with the discount rate:
- At 5%: NPV = approximately $26,415 (Accept)
- At 10%: NPV = approximately $12,075 (Accept)
- At 15%: NPV = approximately -$363 (Reject)
- At 20%: NPV = approximately -$10,245 (Reject)
This demonstrates that the choice of discount rate is critical. Higher discount rates reduce NPV because they place less value on future cash flows. The discount rate should reflect the risk and opportunity cost of capital.
Understanding the Discount Rate
The discount rate is the rate used to convert future cash flows into present value. It represents the required rate of return, cost of capital, or opportunity cost for the investment. Common approaches to determining the discount rate include:
- Weighted Average Cost of Capital (WACC): Reflects the average cost of financing the company through debt and equity
- Required Rate of Return: The minimum return investors or the company expect for accepting the investment's risk
- Hurdle Rate: A minimum rate set by management to ensure only sufficiently profitable projects are pursued
- Risk-Adjusted Rate: A rate that incorporates the specific risk profile of the project
Impact of Discount Rate on NPV
The table below shows how different discount rates affect NPV for a project with $100,000 initial investment and $30,000 annual cash flows for 5 years:
| Discount Rate | NPV | Decision |
|---|---|---|
| 5% | $29,889 | Accept |
| 8% | $19,774 | Accept |
| 10% | $13,724 | Accept |
| 12% | $8,139 | Accept |
| 15% | $595 | Accept |
| 18% | -$6,344 | Reject |
As the discount rate increases, NPV decreases. At approximately 15.2%, the NPV crosses zero — this is the Internal Rate of Return (IRR) for the project.
Frequently Asked Questions
What is Net Present Value (NPV)?
Net Present Value is the difference between the present value of cash inflows and the present value of cash outflows over time. It discounts all future cash flows to today's value using a chosen discount rate. A positive NPV indicates the project is expected to generate value; a negative NPV suggests the project destroys value. NPV is the most widely used method in capital budgeting for evaluating long-term investments.
How do I calculate NPV?
Calculate NPV using the formula: NPV = sum of [CF_t / (1 + r)^t] for all time periods from t=0 to n. The initial investment (t=0) is typically negative. Future cash flows are divided by (1 + discount rate) raised to the power of the period number. This calculator handles the math automatically — just enter your discount rate, initial investment, and yearly cash flows.
What discount rate should I use?
The discount rate typically reflects the cost of capital or required rate of return. Common approaches include using the Weighted Average Cost of Capital (WACC), a hurdle rate set by your organization, or the required return for similar-risk projects. Higher discount rates reduce NPV; lower rates increase it. The choice significantly affects the accept/reject decision and should reflect the risk and opportunity cost of capital.
What does a positive NPV mean?
A positive NPV means the present value of expected cash inflows exceeds the present value of cash outflows. This indicates the project is expected to create value and should be accepted under traditional capital budgeting rules. Projects with NPV > 0 are value-creating; projects with NPV < 0 are value-destroying. An NPV of zero means the project breaks even in present value terms.
What is the profitability index?
The profitability index (PI) is the ratio of NPV to the absolute value of the initial investment: PI = NPV / |Initial Investment|. A PI greater than 0 indicates a profitable project. The profitability index is useful for ranking projects when capital is limited because it shows the value created per dollar invested, allowing for better capital allocation decisions.
How does NPV differ from IRR?
NPV calculates the dollar value a project adds or subtracts at a given discount rate. IRR (Internal Rate of Return) calculates the discount rate at which NPV equals zero. NPV provides an absolute value measure in dollars; IRR gives a percentage return. NPV is generally preferred when the two methods conflict because it directly measures value creation and handles varying discount rates more reliably. Use the IRR calculator to find the internal rate of return.
Can I use NPV for uneven cash flows?
Yes. NPV is specifically designed to handle uneven cash flows across different periods. Each cash flow is discounted individually based on when it occurs. This calculator allows you to add as many years as needed and enter different amounts for each period, making it ideal for projects with irregular cash inflows and outflows over time.
Is my data sent to a server?
No. All calculations happen locally in your browser using JavaScript. No financial data is transmitted, stored, or logged. You can verify this in your browser's developer tools (Network tab). The calculator works offline after the page loads.
Limitations and Considerations
NPV is a powerful tool, but it has limitations:
- Assumes reinvestment at the discount rate: NPV implicitly assumes cash flows can be reinvested at the discount rate, which may not always be realistic
- Requires accurate estimates: NPV is only as good as the cash flow projections and discount rate used. Small changes in assumptions can significantly affect the result
- Does not account for project flexibility: NPV does not capture the value of options to expand, delay, or abandon projects (real options)
- Ignores non-financial factors: Strategic benefits, brand value, or social impact are not reflected in NPV
- Difficulty comparing projects of different sizes or durations: A large project may have a higher NPV but lower profitability index than a smaller project
This calculator is educational. It demonstrates how NPV works mathematically. For actual investment decisions, consult a qualified financial professional and consider all relevant factors beyond NPV alone.
Related Financial Tools
- IRR Calculator — calculate the internal rate of return for a series of cash flows
- ROI Calculator — calculate return on investment as a percentage
- Compound Interest Calculator — model compound growth with adjustable frequency
- Investment Return Calculator — project investment growth with regular contributions
- Break Even Calculator — calculate when revenue covers costs
Privacy & Limitations
- All calculations run entirely in your browser -- nothing is sent to any server.
- Results are estimates for planning purposes and should not replace professional financial advice.
Related Tools
- Overhead Cost Calculator -- Calculate overhead rate, allocate indirect costs, and analyze overhead as a
- Raise Calculator -- Calculate new salary after a percentage raise
- Retirement Savings Calculator -- Project retirement savings growth with visual chart, savings gap analysis, and
- Debt Snowball Calculator -- Compare snowball vs avalanche debt payoff strategies with payment schedules and
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
NPV Calculator FAQ
What is Net Present Value (NPV)?
Net Present Value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time. It discounts all future cash flows to today's value using a chosen discount rate. A positive NPV indicates the project is expected to generate value; a negative NPV suggests the project destroys value. NPV is widely used in capital budgeting to evaluate long-term investments.
How do I calculate NPV?
NPV is calculated using the formula: NPV = sum of [CF_t / (1 + r)^t] for t = 0 to n, where CF_t is the cash flow in period t, r is the discount rate, and t is the time period. Typically, the initial investment (t=0) is negative and future cash inflows are positive. This calculator handles the math automatically — enter your discount rate and cash flows to see the NPV.
What discount rate should I use?
The discount rate typically reflects the cost of capital or required rate of return for the investment. Common approaches include using the Weighted Average Cost of Capital (WACC), the required return for similar-risk projects, or a hurdle rate set by the organization. A higher discount rate reduces NPV; a lower rate increases it. The choice of discount rate significantly affects the decision, so it should reflect the risk and opportunity cost of the investment.
What does a positive NPV mean?
A positive NPV means the present value of expected cash inflows exceeds the present value of cash outflows. This indicates the project is expected to create value and is generally considered acceptable. In traditional capital budgeting, projects with NPV > 0 are accepted, and projects with NPV < 0 are rejected. An NPV of exactly zero means the project breaks even in present value terms.
What is the profitability index?
The profitability index (PI) is the ratio of the present value of future cash flows to the initial investment. It is calculated as PI = NPV / |Initial Investment|, or equivalently, PI = (PV of inflows) / (PV of outflows). A PI greater than 0 (or greater than 1 using the alternative definition) indicates a profitable project. The profitability index is useful for ranking projects when capital is limited.
How does NPV differ from IRR?
NPV calculates the dollar value a project adds or subtracts at a given discount rate. IRR (Internal Rate of Return) calculates the discount rate at which NPV equals zero. NPV gives an absolute value measure; IRR gives a percentage return. NPV is generally preferred when the two methods conflict because it directly measures value creation and handles varying discount rates more reliably. Both are complementary tools in investment analysis.
Can I use NPV for uneven cash flows?
Yes. NPV is designed to handle uneven cash flows across different periods. Each cash flow is discounted individually based on when it occurs. This calculator allows you to add as many years as needed and enter different cash flow amounts for each period, making it suitable for projects with irregular or varying cash inflows and outflows over time.
Is my data sent to a server?
No. All calculations happen locally in your browser using JavaScript. No financial data is transmitted, stored, or logged. You can verify this in your browser's developer tools (Network tab). The calculator works offline after the page loads.