Net Present Value Calculator
Discount future cash flows to today's value and subtract your initial investment to see whether a project or investment creates value. Also see IRR, profitability index, and payback period.
Investment details
Default values are examples. Use negative cash flows for periods with net outflows.
Results
Net present value (NPV)
₹0
Present value by period
Discounted cash flow schedule
Filter the schedule to view all periods, cash inflows, or cash outflows.
| Period | Cash flow | Discount factor | Present value | Cumulative PV |
|---|
Quotelyo Calculators
Explore more free calculators
Loans, savings, investing, retirement, real estate and business calculators. Free to use, no signup required.
No calculators match that search. Try a different word or category.
Investment analysis guide
How a Net Present Value Calculator Works
Evaluating an investment involves more than adding up the money you expect to receive in the future. You also need to consider when those cash flows will arrive and what they are worth today. A Net Present Value (NPV) Calculator helps you estimate the present value of future cash flows after subtracting the initial investment.
Net present value is widely used to evaluate capital investments, business projects, equipment purchases, expansion plans, and other opportunities that involve an upfront cost followed by expected future cash inflows or outflows.
Use the calculator above to enter the initial investment, expected future cash flows, and discount rate. The result helps you assess whether the discounted value of the projected cash flows exceeds the investment cost under your chosen assumptions.
What Can You Calculate With an NPV Calculator?
An NPV calculator converts future cash flows into present values using a selected discount rate. It then combines those values with the initial investment to estimate the net value created or lost under the model's assumptions.
Net Present Value
Estimate the value remaining after the present value of expected future cash flows is adjusted for the initial investment.
Discounted Cash Flows
Understand how cash received in different periods contributes to an investment's present value.
Investment Comparison
Compare potential projects using consistent cash-flow estimates and discount-rate assumptions to support investment decisions.
The calculator provides a financial estimate, not a guarantee of investment performance. The reliability of the result depends on your cash-flow forecasts, discount rate, project duration, and other assumptions.
What Is Net Present Value?
Net present value is the difference between the present value of an investment's expected future cash flows and its initial cost. It accounts for the time value of money: receiving money today is generally more valuable than receiving the same amount later, because today's money can potentially earn a return or be used for another purpose.
NPV discounts each expected future cash flow to its equivalent value today. It then subtracts the initial investment, which typically occurs at time zero and therefore is not discounted.
Why the time value of money matters
An investment that returns ₹1 lakh next year is not necessarily equivalent to one that returns ₹1 lakh five years from now. The later payment must be discounted to account for the time you wait and the return you could require from an alternative investment.
Where NPV is used
- Business investments: Assessing whether a new facility, product, or expansion may create financial value.
- Equipment purchases: Comparing the upfront cost of equipment with expected future savings or operating benefits.
- Project evaluation: Estimating the present value of expected project cash inflows and outflows.
- Capital budgeting: Prioritizing projects when organizations have limited investment resources.
- Personal financial decisions: Comparing certain purchases or income-generating opportunities when future cash flows can be reasonably estimated.
Net Present Value Formula
The NPV formula discounts each future cash flow by the appropriate number of periods and subtracts the initial investment. This allows cash flows occurring at different times to be expressed in today's monetary value.
NPV Calculation
NPV: Net present value of the investment.
C₀: Initial investment expressed as a positive cost in this notation. The formula subtracts it at time zero.
Cₜ: Net cash flow received or paid at period t.
r: Discount rate per period, expressed as a decimal.
t: The period in which the cash flow occurs.
How the discounting formula works
A future cash flow is divided by (1 + r) raised to the number of periods before it is received. Cash flows further in the future generally have lower present values when the discount rate is positive.
Present Value of a Future Cash Flow
Calculate the present value of each future cash flow separately, add those present values together, and subtract the initial investment to obtain NPV.
Use a consistent time period
The discount rate and the cash-flow schedule must use consistent periods. For annual cash flows, use an annual discount rate. For monthly cash flows, use an appropriate monthly rate. If the rate is converted from an annual rate, make sure the conversion matches the intended compounding convention.
Net Present Value Calculator Example
Suppose a business is considering a project that costs ₹1,00,000 today and is expected to generate ₹50,000 in net cash inflows at the end of each of the next three years. The business uses a 10% annual discount rate to evaluate the project.
Illustrative investment scenario
Step-by-step NPV calculation
| Year | Cash flow | Present value |
|---|---|---|
| Year 0 | −₹1,00,000 | −₹1,00,000.00 |
| Year 1 | ₹50,000 | ₹45,454.55 |
| Year 2 | ₹50,000 | ₹41,322.31 |
| Year 3 | ₹50,000 | ₹37,565.74 |
| Total NPV | — | ₹24,342.60 |
Estimated net present value
NPV ≈ ₹24,342.60
The present value of the three projected cash inflows is approximately ₹1,24,342.60. Subtracting the initial investment of ₹1,00,000 results in a positive NPV of approximately ₹24,342.60.
Under these assumptions, the project's discounted inflows exceed its initial cost. This result depends on the forecast cash flows and the selected 10% discount rate; it does not guarantee that the project will deliver the projected returns.
How to Interpret Your NPV Result
NPV helps evaluate an investment by expressing its expected cash flows in present-value terms. The sign of the result provides a useful starting point for deciding whether the estimated returns meet your chosen discount-rate requirement.
NPV Greater Than Zero
The present value of the projected future cash flows exceeds the initial investment. The project is expected to create value relative to the selected discount rate under the model's assumptions.
NPV Equal to Zero
The present value of the expected cash flows equals the initial investment. The project meets the selected discount-rate threshold in the financial model.
NPV Less Than Zero
The present value of the expected cash flows is lower than the initial investment. The project falls short of the selected return requirement under the given assumptions.
Does a positive NPV always mean you should invest?
Not automatically. A positive NPV is a favorable financial signal when the cash-flow estimates and discount rate are appropriate, but you should also consider project risk, available capital, strategic priorities, operational constraints, and alternative opportunities.
If two projects have different investment sizes, durations, or risk profiles, compare their NPVs alongside other measures rather than assuming the larger number always identifies the better choice.
How to Use a Net Present Value Calculator
Follow these steps to estimate NPV and evaluate an investment using your expected cash flows and discount-rate assumptions.
Enter the initial investment
Record the upfront amount required to begin the project. Include relevant initial costs in the analysis and ensure the investment is represented only once in the cash-flow model.
Estimate future cash flows
Enter the expected net cash inflow or outflow for each future period. Consider revenue, operating expenses, maintenance, working capital, taxes, and other project-related items relevant to your chosen cash-flow definition.
Choose an appropriate discount rate
Select a rate that reflects the time value of money and the risk of the cash flows being evaluated. For a business project, this may be linked to its required rate of return or an appropriate project discount rate.
Confirm the period and timing
Check whether your cash flows are annual, quarterly, or monthly. Ensure the discount rate matches the schedule and determine whether each cash flow occurs at the beginning or end of its period.
Calculate the present values
Discount each future cash flow to today's value and add the results together. Subtract the initial investment to obtain the net present value.
Review the result and test scenarios
Interpret whether NPV is positive, negative, or approximately zero. Adjust the cash-flow forecasts or discount rate to understand how sensitive the result is to changes in assumptions.
How to Choose the Right Discount Rate
The discount rate represents the return threshold used to convert future cash flows into present values. Selecting the rate is one of the most important parts of an NPV analysis because it can significantly affect the final result.
Required rate of return
An investor may use the return they require for an investment with a comparable level of risk. This rate helps determine whether the expected cash flows justify committing capital to the project.
Cost of capital
Businesses often evaluate projects using a cost-of-capital measure, sometimes a weighted average cost of capital (WACC), when appropriate for the project's financing and risk characteristics. The rate should be suitable for the cash flows being discounted.
Investment risk
Cash flows with greater uncertainty may require a different risk assessment from relatively predictable cash flows. However, simply adding an arbitrary premium to the discount rate can distort the analysis. Use a coherent method for matching risk assumptions to the cash-flow forecasts.
Inflation and nominal versus real rates
Your cash flows and discount rate need to use a consistent basis. Nominal cash flows, which include expected inflation, are generally discounted using a nominal rate. Real cash flows, expressed in purchasing-power terms, should be discounted using a real rate.
A higher discount rate generally lowers NPV
When future cash flows are positive and other inputs remain unchanged, increasing the discount rate reduces their present value. The effect is usually greater for cash flows that occur further in the future. If the cash-flow pattern contains multiple outflows and inflows, interpret the overall result using the full cash-flow schedule.
Net Present Value vs. Other Investment Metrics
NPV is a useful investment evaluation measure, but it is not the only metric used in project analysis. Other methods answer different questions and can provide additional insight when used together.
| Metric | What it measures | Primary use | Important limitation |
|---|---|---|---|
| Net Present Value (NPV) | Present value of cash flows minus initial investment | Estimate value created at a selected discount rate | Depends on cash-flow estimates and discount-rate assumptions |
| Internal Rate of Return (IRR) | The discount rate that makes NPV equal to zero | Express the implied return as a percentage | May have multiple or misleading results with unusual cash-flow patterns |
| Payback Period | Time needed to recover the initial investment | Assess how quickly the investment cost is recovered | Simple payback ignores cash flows after payback and often ignores the time value of money |
| Profitability Index | Present value of future inflows relative to initial investment | Compare value per unit of invested capital | May not rank mutually exclusive projects the same way as NPV |
| Return on Investment (ROI) | A return measure relative to the cost or investment base | Summarize investment performance | Definitions vary and may not account for cash-flow timing |
Why NPV is often useful for project selection
NPV measures expected value in monetary terms after accounting for the chosen discount rate. When comparing mutually exclusive projects under consistent assumptions, the project with the higher positive NPV generally contributes more estimated value. The decision should still account for risk, capital constraints, and strategic considerations.
How to Calculate NPV in Excel
You can calculate net present value in Excel using the built-in NPV function. One important detail is that Excel's NPV function discounts the cash flows supplied to it as end-of-period cash flows, starting with period one.
Excel NPV Formula
If cell B1 contains the discount rate and cells B3:B5 contain the projected cash flows for years one through three, with the initial investment stored separately in B2 as a negative amount, you could use:
Keep the initial cash flow outside the range discounted by Excel's NPV function when it occurs at time zero.
Common Excel NPV mistake
Including the initial investment as the first value inside Excel's NPV function discounts it by one period, which is usually incorrect for an initial investment made today. Add the time-zero cash flow separately instead.
Spreadsheet applications may offer similar functions with different conventions. Review the relevant function documentation if you use a tool other than Excel.
Common NPV Calculation Mistakes to Avoid
An NPV calculation is only as reliable as the assumptions that support it. Avoid the following mistakes when evaluating investments.
- Using unrealistic cash-flow forecasts: Overestimating revenue or underestimating project expenses can make an investment appear more attractive than it really is.
- Choosing an inappropriate discount rate: A rate that does not reflect the investment's characteristics can overstate or understate present value.
- Mixing annual and monthly periods: Ensure that the cash-flow frequency and discount-rate frequency are consistent.
- Discounting the initial investment incorrectly: A cost incurred today is generally included at its time-zero value rather than discounted as a future cash flow.
- Ignoring inflation: Keep nominal or real cash flows consistent with the discount rate used in the calculation.
- Ignoring ongoing project costs: Include relevant operating expenses, maintenance, working capital, taxes, and other cash-flow effects where applicable.
- Assuming a positive NPV removes risk: Projected cash flows can differ from actual results because of market, operational, competitive, and other uncertainties.
- Comparing projects with inconsistent assumptions: Use a comparable framework for timing, inflation, tax treatment, and risk when evaluating alternatives.
Why Sensitivity Analysis Matters for NPV
NPV can change substantially when the assumptions behind a project change. Sensitivity analysis helps you understand which inputs have the greatest effect on a projected investment result.
Test different discount rates
Calculate NPV at several reasonable discount rates to see how your valuation responds to changes in the return threshold. This helps show how sensitive the decision is to your required return.
Review optimistic and conservative cash flows
Prepare alternative cash-flow forecasts to evaluate how the project performs under different operating conditions. A conservative scenario might include lower sales, higher costs, or delayed receipts where those possibilities are relevant.
Consider changes in project timing
Delayed cash inflows generally have lower present values when the discount rate is positive. Review whether expected start dates, construction schedules, or payment delays could affect the investment's projected NPV.
Focus on the assumptions that drive the result
A project with a small positive NPV may be sensitive to modest changes in cash flows or discount rates. If the investment's value changes sharply under reasonable alternative assumptions, consider that uncertainty when making the decision.
Frequently asked questions
Net Present Value Calculator FAQs
Find answers to common questions about NPV formulas, discounted cash flows, discount rates, Excel calculations, and investment decision-making.
What is a Net Present Value Calculator?
A Net Present Value Calculator estimates an investment's net value by discounting expected future cash flows to their present value and subtracting the initial investment. It helps evaluate whether projected returns exceed a selected discount-rate threshold under the assumptions entered.
How do you calculate net present value?
Discount every future cash flow by dividing it by (1 + r) raised to its period, where r is the discount rate per period. Add the present values together and subtract the initial investment made at time zero. The result is the net present value.
What does a positive NPV mean?
A positive NPV means the present value of the expected future cash flows exceeds the initial investment at the selected discount rate. The project is expected to create value relative to that return threshold, assuming the cash-flow estimates and other inputs are reasonable.
What does a negative NPV mean?
A negative NPV means the present value of the projected future cash flows is lower than the initial investment. Under the chosen discount rate and assumptions, the project falls short of the required return threshold.
What does an NPV of zero mean?
An NPV of zero means the present value of the expected future cash flows equals the initial investment. Under the model's assumptions, the project exactly meets the selected discount-rate requirement. It does not mean that the investment produces no cash flow or has no economic value.
What is the discount rate in an NPV calculation?
The discount rate is the rate used to convert future cash flows into present values. It may reflect a required rate of return, an appropriate cost of capital, and considerations related to the investment's risk. A suitable rate depends on the project and its assumptions.
How does the discount rate affect NPV?
For a project with positive future cash flows, a higher discount rate generally reduces their present value and lowers NPV. A lower rate generally raises the present value of those inflows. The precise effect depends on the timing and pattern of all cash flows.
What is the difference between NPV and present value?
Present value measures the current worth of a future cash flow or series of cash flows. Net present value goes one step further by subtracting the initial investment from the present value of the project's future cash flows.
What is the difference between NPV and IRR?
NPV expresses the estimated net value of an investment in monetary terms using a specified discount rate. Internal Rate of Return (IRR) is the discount rate that makes NPV equal to zero. NPV helps estimate value created, while IRR expresses an implied return rate. IRR can have multiple or misleading solutions for some unusual cash-flow patterns, so the two metrics are often considered together.
Can NPV be negative even when a project makes a profit?
Yes. Accounting profit and NPV measure different things. An investment may generate positive accounting profits or undiscounted cash inflows yet have a negative NPV because those cash flows are too small, arrive too late, or fail to meet the selected required return.
How do you calculate NPV in Excel?
Excel's NPV function discounts the future cash flows supplied to it as period-one and subsequent cash flows. For a typical initial investment at time zero, add the initial negative cash flow separately. For example: =NPV(rate, future_cash_flows) + initial_cash_flow.
Should the initial investment be included in the NPV function?
For Excel's standard NPV function, an initial investment made at time zero is normally excluded from the discounted future cash-flow range and added separately as a negative cash flow. Discounting that time-zero amount as if it occurred in period one would misstate the calculation. Other financial tools may handle inputs differently.
Can NPV be used to compare two investments?
Yes. NPV can help compare investments using consistent assumptions about cash flows, timing, risk, and discount rates. When comparing mutually exclusive projects, the larger positive NPV generally indicates more estimated value created, although capital limits and strategic considerations may also affect the decision.
What are the limitations of NPV?
NPV relies on estimates of future cash flows and a chosen discount rate. Actual results may differ because of uncertainty, unexpected costs, delays, market changes, and other risks. It can also be sensitive to the assumptions used, making scenario and sensitivity analysis valuable.
Does NPV account for inflation?
NPV accounts for the time value of money through discounting, but inflation is not necessarily handled correctly unless the cash flows and discount rate are consistent. Nominal cash flows should generally be discounted using a nominal rate, while real cash flows should use a real rate.
Is a higher NPV always better?
A higher NPV generally indicates more estimated value created when projects are evaluated on a comparable basis with appropriate assumptions. However, project risk, required capital, timing, strategic fit, and resource constraints should also be considered before making an investment decision.
Make Better Investment Decisions With an NPV Calculator
A Net Present Value Calculator helps you evaluate an investment by comparing its initial cost with the present value of expected future cash flows. Enter realistic forecasts, use a discount rate suited to the investment, and make sure your cash-flow periods match the rate convention.
Review whether the result is positive, negative, or close to zero, and test different cash-flow and discount-rate assumptions before relying on the estimate. For important financial decisions, combine NPV with other metrics and a careful assessment of risks, capital requirements, and available alternatives.
This calculator and the accompanying information are for educational purposes only. Results are estimates based on the assumptions entered and do not guarantee investment performance or constitute personalized financial advice.