About Brian DeChesare
Brian DeChesare is the Founder of Mergers & Inquisitions and Breaking Into Wall Street. In his spare time, he enjoys lifting weights, running, traveling, obsessively watching TV shows, and defeating Sauron.
Net Present Value (NPV) equals the sum of an asset’s discounted future cash flows minus the upfront cost or “asking price” for this asset today; a positive NPV means that you can achieve more than your targeted returns by investing, while a negative NPV means the opposite.
Net Present Value (NPV): Definition and Example Calculations
Net Present Value (NPV) Definition: Net Present Value (NPV) equals the sum of an asset’s discounted future cash flows minus the upfront cost or “asking price” for this asset today; a positive NPV means that you can achieve more than your targeted returns by investing, while a negative NPV means the opposite.
To understand Net Present Value, you must first understand Present Value, or what an investment’s future cash flows are worth TODAY based on the annualized rate of return you could potentially earn on other, similar investments (called the “Discount Rate”).
Net Present Value goes a step further and subtracts the investment’s upfront cost or “asking price” to determine if its Present Value exceeds its current cost.
If it does, it suggests that you should invest; if it does not, an investment may not achieve your desired goals.
Net Present Value is critical because it helps investors determine if an investment is worthwhile by comparing the actual annualized return to the targeted annualized return (the Discount Rate).
The NPV, PV, Discount Rate, and IRR are all linked by simple rules. We defined the NPV and PV above, but for the latter two:
Based on this, we can say:
Here are a few simple examples of these relationships in Excel, based on a simple example of buying an apartment for $200,000, earning $12,000 of income from it per year, and selling it again for $200,000 after 5 years.
Notice that all that changes in each example is the Discount Rate, or our expectations for the annualized returns.
Like dating, you can always get a positive result if you lower your expectations enough.
Other ways to change the Net Present Value include modifying the upfront cost, the apartment’s selling price, or the annual income earned by renting out this property.
But, as with dating once again, these are the equivalent of “doing work on yourself” to improve, so they all require more time and effort and may or may not be feasible.
Confusingly, the NPV function in Excel calculates both the Present Value (PV) and the Net Present Value (NPV) of an investment, depending on what you input into the function.
There is another option for calculating the Net Present Value as well: We could take the PV of the future cash flows and subtract the upfront cost, but the results will differ slightly because of how the NPV function works:
In general, it’s best to use Excel’s built-in NPV function to calculate the Net Present Value consistently.
Also, it’s essential if there are multiple upfront investments required to buy an asset or company, as in the example below:
To calculate the Net Present Value in real life, you need to estimate the future cash flows of an investment, the WACC (discount rate), and the cost of the initial investment.
For real companies, you calculate the Discount Rate using the Weighted Average Cost of Capital (WACC) formula, which we describe in separate articles (how to calculate the Discount Rate and the WACC formula).
You can make an investment decision based on either the IRR and WACC or the NPV:
In the following example, the Virgin Company is determining whether they should invest in Virgin Galactic (for trips to Jupiter) or Virgin Asia (for low-cost flights to Southeast Asia).
Each subsidiary has its own Discount Rate because sending passengers to Jupiter is much riskier than operating low-cost flights to Southeast Asia.
The Virgin Galactic plan has a higher IRR, but the upfront cost is also much higher, which means its Net Present Value is lower.
Therefore, it makes more sense to launch Virgin Asia since it has a higher Net Present Value despite having a lower IRR:
Net Present Value is widely used in analyses such as the Discounted Cash Flow (DCF) model to value companies and in planning and budgeting in roles such as FP&A at normal companies.
It’s also common in real estate investing, fixed income research, credit analysis, and even venture capital and startup modeling to determine a growth company’s potential value.
It’s not quite as common in M&A analysis and merger models because they often focus on short-term EPS accretion/dilution, but even there, it can come up in valuations.
Brian DeChesare is the Founder of Mergers & Inquisitions and Breaking Into Wall Street. In his spare time, he enjoys lifting weights, running, traveling, obsessively watching TV shows, and defeating Sauron.