An introduction to net present value
Key takeaways
NPV calculates the value of future cash flows in today’s dollars, helping investors assess whether an investment is expected to add value after accounting for time and risk.
If an investment’s NPV is greater than zero, it suggests projected returns exceed costs — while a negative NPV may indicate the investment isn’t financially attractive.
While NPV is widely used for evaluating and comparing investment opportunities, it works best when paired with other metrics and real-world considerations like risk tolerance, assumptions, and cash flow timing.
There are different methods to determine the present value of profits or revenues that will be earned in the future. One of those ways is to calculate the net present value (NPV). NPV is a fundamental metric used to assess the value of future cash flows in today's terms, factoring in the time value of money. In this article, we'll explore topics like the net present value formula, how to calculate net present value in Excel, and a practical example of NPV to solidify your understanding.
What is net present value in simple terms?
Net present value (NPV) is a financial metric used to evaluate an investment or project. It compares the present value of expected future cash inflows (such as revenue or savings) with the present value of anticipated cash outflows (such as investments or costs). In simpler terms, NPV helps determine whether an investment will yield returns that exceed the initial investment, accounting for the time value of money.
How to calculate net present value (NPV)?
The NPV formula is a fundamental equation used in finance to assess the profitability of an investment or project by comparing the present value of expected cash inflows with the present value of cash outflows. The NPV equation is:
Where:
- NPV = Net Present Value
- Ct = Cash flow at time 𝑡
- r = Discount rate (the rate of return that could be earned on an alternative investment of similar risk)
- "Initial Investment" represents the upfront cost to initiate the investment or project.
The net present value equation calculates the present value of each individual cash flow at time 𝑡 by dividing it by (1+r) to the t power, which represents the discount factor for each period. Then, it sums up the present values of all cash flows from time t=0 to 𝑡=𝑛. Finally, the initial investment is subtracted from the sum to obtain the net present value.
Example of net present value
What is an example of NPV? Let's look at the following scenario:
A company is considering a project requiring an initial investment of $50,000, with anticipated annual cash inflows of $20,000 for five years.
Calculation steps:
1. Identify cash flows
- Initial Investment: -$50,000
- Cash Inflows (Years 1-5): $20,000 per year
2. Apply Discount Rate (10%) to Calculate Present Value (PV) of Cash Inflows
- Year 1 PV: $18,181
- Year 2 PV: $16,529
- Year 3 PV: $15,038
- Year 4 PV: $13,736
- Year 5 PV: $12,422
3. Calculate NPV
- NPV = PV of Cash Inflows - Initial Investment
- NPV = $75,906 (total PV of cash inflows) - $50,000 (initial investment)
- NPV = $25,906
The positive NPV of $25,906 indicates that the project is financially attractive. It suggests that the present value of anticipated cash inflows, discounted at 10% per year, exceeds the upfront investment cost of $50,000. Therefore, based on NPV analysis, the project is expected to generate returns that surpass the initial investment, making it a potentially profitable investment opportunity.
Why is net present value important?
NPV is crucial for several reasons:
- Decision-making tool: NPV helps businesses and investors assess whether an investment is financially viable and worth pursuing.
- Time value of money: NPV accounts for the opportunity cost of tying up capital today versus the potential returns over time by discounting future cash flows.
- Comparative analysis: NPV allows for comparing different investment opportunities by standardizing their profitability in present value terms.
- Risk assessment: By incorporating a discount rate, NPV considers the risk associated with future cash flows, providing a more comprehensive analysis
What is net present worth?
Net present worth (NPW) is essentially another term for NPV. It represents the difference between the present value of benefits (inflows) and costs (outflows) associated with an investment over a specific time period.
What is net profit value and what is the net profit value formula?
- Net profit value is less commonly used in finance and may refer to a concept similar to NPV, but it specifically focuses on the net profitability (revenues minus costs) of an investment or project in present value terms.
- Net profit value formula:
- Net profit value could be calculated as the present value of expected net cash flows (revenues minus costs) compared to the initial investment.
- Formula: Net profit = Value of investment - Cost of investment
- Interpretation:
- Net profit value, if used interchangeably with net present value, implies the same concept of evaluating investment profitability by considering the time value of money and comparing the present value of cash inflows versus outflows.
What constitutes a good NPV?
A positive NPV indicates that the projected earnings (in present value terms) surpass the initial investment, suggesting a potentially profitable venture. Generally, a higher NPV signifies a more lucrative opportunity. Below is a concise answer to the question, What is a good NPV?
- Positive value: A positive NPV indicates that the investment is expected to generate returns that exceed the initial investment, which is generally favorable.
- Magnitude of NPV: A higher positive NPV is more attractive as it signifies potentially higher returns relative to the initial investment.
- Comparison with discount rate: NPV should be significantly higher than the discount rate used, indicating a higher return compared to the required rate of return.
- Risk considerations: A positive NPV with a lower associated risk is preferable to a similar NPV with a higher risk.
- Industry norms and benchmarking: Industry-specific benchmarks can provide context to evaluate whether a specific NPV is considered good within that industry.
- Strategic objectives and investment criteria: The interpretation of a good NPV can vary depending on the company or investor's strategic objectives and investment criteria.
Annuity NPV formula
An annuity involves a series of equal cash flows recurring at regular intervals. Calculating the NPV of an annuity entails a modified formula:
Where:
- NPV = Net Present Value
- Cash Flow = Amount of cash flow received or paid at each period (the same for each period in an annuity)
- r = Discount rate per period (expressed as a decimal)
- n = Number of periods
- Initial Investment = Upfront cost or initial investment required for the annuity
This formula calculates the present value of an annuity by discounting each cash flow back to its present value using the discount rate r. The present values of all cash flows are then summed, and the initial investment is subtracted to obtain the net present value.
You can also calculate the NPV formula in Excel since the NPV function readily handles annuities. Simply input the cash flows as a uniform series and specify the discount rate.
NPV in Excel
In Excel, you can use the NPV function to compute the net present value of a series of cash flows. The NPV function takes the discount rate and the series of cash flows as arguments and returns the NPV.
The NPV in Excel formula is as follows:
NPV(rate, value1, [value2],...)
- rate: The discount rate per period. This should be entered as a decimal (e.g., 0.10 for 10%).
- value1, value2, etc.: The series of cash flows. These can be positive or negative and represent cash inflows and outflows. They must occur at regular intervals.
- For example, let's say we have the following cash flows:
- Initial investment: -$50,000 (negative because it's an outflow)
- Cash inflows for years 1 to 5: $20,000 each year
We want to calculate the NPV using a discount rate of 8%.
Here's how you would use the NPV function in Excel:
=NPV(0.08, -50000, 20000, 20000, 20000, 20000)
This formula calculates the NPV using a discount rate of 8% and the series of cash flows. The result will be the net present value of the investment.
You can also input the cash flows as a range of cells instead of individual values if they are listed in consecutive cells in your Excel worksheet. For example:
=NPV(0.08, A1:A5)
In this case, the cash flows are listed in cells A1 to A5.
The NPV calculator in Excel offers unmatched convenience and accuracy. With just a few clicks, you can easily utilize the formula NPV in Excel to make informed decisions and compute net present value. By leveraging the calculate NPV formula feature, you can confidently analyze cash flows and make data-driven decisions that drive success.
The bottom line
Net present value (NPV) is a fundamental concept in finance. It provides a quantitative basis for evaluating investments based on their projected cash flows and the time value of money. Understanding how to compute net present value and what it means empowers individuals and organizations to make sound financial decisions, ensuring optimal resource allocation and sustainable growth.
Related Content
© 2026 Raisin SE. All rights reserved.
The Raisin name and logo are trademarks of Raisin SE. All other trademarks, logos, marks, and brand names are the property of their respective owners.
*APY means Annual Percentage Yield. APY is accurate as of April 10, 2026. Interest rate and APY may change after initial deposit depending on the terms of the specific product selected. Minimum opening deposit is $1.00.
Raisin is not an FDIC-insured bank, and FDIC deposit insurance only covers the failure of an insured bank.
Raisin is not an NCUA-insured credit union. NCUA deposit insurance only covers the failure of an insured credit union.
Raisin does not hold any customer funds. Customer funds are held in various custodial deposit accounts. Each customer authorizes the Custodial Bank to hold the customer’s funds in such accounts, in a custodial capacity, in order to effectuate the customer’s deposits to and withdrawals from the various bank and credit union products that the customer requests through Raisin.com. The Custodial Bank does not establish the terms of the bank or credit union products and provides no advice to customers about bank or credit union products offered by the applicable bank or credit union through Raisin.com. Each customer also authorizes the Service Bank to move funds among the various banks and credit unions at the customer’s request. First International Bank & Trust (FIBT), Member FDIC, is the Service Bank. Bell Bank and Starion Bank, each Member FDIC, are the Custodial Banks.
†Based on $250,000 in FDIC or NCUA insurance coverage per insurable category of ownership at each partner bank or credit union on the Raisin platform (each a "Product Bank"), when aggregated with all other deposits held by you at such Product Bank and in the same insurable category. Deposits made through Raisin will be eligible to receive deposit insurance from the FDIC or the NCUA (each a "Deposit Insurer") in accordance with and up to the maximum amount permitted by law at each Product Bank. Raisin is not a bank or credit union and does not hold any customer funds. Funds are held at FDIC-insured banks and NCUA-insured credit unions. Deposit insurance covers the failure of an insured bank or credit union. Certain conditions must be satisfied for pass through deposit insurance coverage to apply. Customers may choose to deposit funds with identically registered accounts at different Product Banks on the Raisin platform to be eligible for Deposit Insurer coverage up to $10 million for individual accounts and $20 million for joint accounts when at least 40 Product Banks are utilized. Please be aware, however, that any deposits you have at a Product Bank, whether through the Raisin platform or outside the Raisin platform, that you may hold in the same capacity (such as in an individual capacity or joint capacity) count toward the applicable Deposit Insurer's deposit insurance maximum amount, and any such amounts that you hold in the same capacity at a Product Bank that exceed the maximum insurance coverage by the applicable Deposit Insurer will not be insured. For more information on FDIC deposit insurance, please see here. For more information on the NCUA share insurance fund, please see here. You are solely responsible for monitoring the amount of funds you have on deposit at each a Product Bank, whether through the Raisin platform or outside the Raisin platform, to confirm that the deposits you hold in the same capacity at each Product Bank do not exceed the maximum deposit insurance coverage provided by the applicable Deposit Insurer.