NPV Calculator
Calculate net present value by discounting future cash flows to today’s value.
What Is Net Present Value (NPV)?
Net Present Value (NPV) is a financial metric used to evaluate the profitability of an investment or project. It calculates the difference between the present value of cash inflows and the present value of cash outflows over a period of time. A positive NPV indicates that the projected earnings (in today's dollars) exceed the anticipated costs, suggesting the investment is likely profitable. A negative NPV suggests the opposite.
This tool discounts each future cash flow back to its present value using a specified discount rate, then sums them together. The discount rate typically reflects the cost of capital or the required rate of return.
How the NPV Calculation Works
The NPV formula discounts each individual cash flow to account for the time value of money—the principle that a dollar today is worth more than a dollar tomorrow.
The formula used is:
NPV = Σ [CFt / (1 + r)^t] - Initial Investment
Where:
- CFt = Cash flow at time period t (inflows are positive, outflows are negative)
- r = Discount rate (expressed as a decimal)
- t = Time period (e.g., year 1, year 2)
- Initial Investment = The upfront cost of the project (typically a negative cash flow at time 0)
The calculator sums the present values of all future cash flows and subtracts the initial investment to arrive at the net present value.
How to Use the NPV Calculator
- Enter the Initial Investment: Input the upfront cost of the project or investment. This is typically a negative number representing cash outflow.
- Input the Discount Rate: Enter the discount rate as a percentage (e.g., 10 for 10%). This rate should reflect your required rate of return or cost of capital.
- Add Cash Flows: Enter the expected net cash flows for each future period. You can add or remove periods as needed.
- Review the Result: The calculator will display the NPV. A positive value suggests the investment adds value; a negative value suggests it does not.
Example Calculation
Consider a project with an initial investment of $10,000 and a discount rate of 10%. The expected cash flows are:
- Year 1: $3,000
- Year 2: $4,000
- Year 3: $5,000
The present values are calculated as follows:
- Year 1: $3,000 / (1.10)^1 = $2,727.27
- Year 2: $4,000 / (1.10)^2 = $3,305.79
- Year 3: $5,000 / (1.10)^3 = $3,756.57
Total present value of inflows: $2,727.27 + $3,305.79 + $3,756.57 = $9,789.63
NPV = $9,789.63 - $10,000 = -$210.37
In this case, the NPV is negative, indicating the project would not meet a 10% return threshold and may not be a worthwhile investment.
Interpreting Your Results
The NPV result provides a clear decision rule:
- NPV > 0: The investment is expected to generate more value than its cost. It adds value to the business or portfolio.
- NPV = 0: The investment is expected to break even. It generates exactly the required rate of return.
- NPV < 0: The investment is expected to destroy value. It does not meet the required rate of return.
NPV is a dollar amount, not a percentage. A higher positive NPV generally indicates a more attractive investment, but it does not account for the scale of the investment. For comparing projects of different sizes, consider using the profitability index alongside NPV.
Common Mistakes When Using NPV
- Incorrect Discount Rate: Using a rate that is too low or too high can significantly skew results. The discount rate should reflect the risk of the investment and the opportunity cost of capital.
- Ignoring All Cash Flows: Ensure all relevant cash flows—including maintenance costs, taxes, and salvage value—are included. Omitting significant outflows or inflows leads to an inaccurate NPV.
- Misaligned Time Periods: All cash flows must be aligned to the same time period. If you use annual discounting, all cash flows must be annual figures.
- Confusing NPV with IRR: NPV gives a dollar value, while Internal Rate of Return (IRR) gives a percentage return. They are complementary metrics, not substitutes.
Limitations of NPV Analysis
- Forecast Uncertainty: NPV relies on estimated future cash flows, which are inherently uncertain. Small changes in assumptions can lead to large changes in the result.
- Single Discount Rate: The standard NPV model uses a single discount rate for all periods, which may not accurately reflect changing risk profiles over time.
- Ignores Non-Financial Factors: NPV does not account for strategic value, brand impact, or qualitative benefits that may be important to a decision.
- No Flexibility: The model assumes a fixed set of cash flows and does not account for managerial flexibility to alter the project in response to changing conditions.
Practical Use Cases for NPV
- Capital Budgeting: Companies use NPV to evaluate whether to invest in new equipment, facilities, or technology.
- Real Estate Investment: Investors calculate NPV to assess the profitability of rental properties or development projects.
- Project Selection: When choosing between multiple projects with limited capital, NPV helps prioritize those that add the most value.
- Business Valuation: NPV is used in discounted cash flow (DCF) analysis to estimate the value of a business or asset.
Frequently Asked Questions
What is a good NPV?
A positive NPV is generally considered good, as it indicates the investment is expected to generate more value than its cost. However, the "goodness" of an NPV depends on the scale of the investment and the alternatives available. A higher positive NPV is typically better, but it should be compared against other investment opportunities and the required rate of return.
What is the difference between NPV and IRR?
NPV calculates the dollar value added by an investment, while IRR calculates the percentage rate of return. NPV is an absolute measure, and IRR is a relative measure. They are often used together: a project with a positive NPV will have an IRR greater than the discount rate. However, they can give conflicting rankings when comparing projects of different sizes or durations.
Can NPV be negative and still be a good investment?
In strict financial terms, a negative NPV suggests the investment does not meet the required rate of return and may destroy value. However, there are exceptions. A project with a negative NPV might still be pursued for strategic reasons, such as entering a new market, building brand awareness, or complying with regulations. These non-financial benefits are not captured by the NPV calculation.
What discount rate should I use?
The discount rate should reflect the opportunity cost of capital and the risk of the investment. Common choices include the weighted average cost of capital (WACC) for a company, the expected return of a comparable investment, or a rate that reflects the specific risk profile of the project. There is no single correct rate; it depends on the context and the investor's required return.
Does NPV account for inflation?
NPV can account for inflation, but it must be done consistently. If you use nominal cash flows (which include the effects of inflation), you must use a nominal discount rate. If you use real cash flows (adjusted for inflation), you must use a real discount rate. Mixing nominal and real figures will produce inaccurate results.