Net Present Value: How to Calculate NPV

Net present value or NPV represents the difference between the present value of cash inflows and outflows over a set period of time. Knowing how to calculate NPV can be useful when trying to determine whether an investment — either business or personal — will eventually pay off.

In capital budgeting, calculating the net present value can help with estimating the profitability of an investment or expansion project. Meanwhile, investors use the net present value calculation to gauge an investment’s potential rate of return based on the present value of its future cash flows and a discount rate, based on the cost of borrowing or financing.

What Is Net Present Value (NPV)?

Net present value is a measure of the value of all future cash flows over the life of an investment, discounted to the present after factoring in inflows, outflows, and inflation, which can erode the value of money over time.

When applying the net present value formula, you’re looking at whether revenues are greater than costs or vice versa to determine whether an investment or project is likely to yield a gain or a loss.

As mentioned, net present value is often used in capital budgeting. Businesses and governments can use capital budgeting methods to determine how much of a return they’re likely to see on a project before funding it. The NPV formula takes into account the time value of money, a concept which suggests that a sum of money received now is worth more than that same sum received at a future date.

How to Calculate NPV

Calculating net present value is a fairly simple operation.

If you want to calculate net present value using the NPV formula, you’d first need to know the expected positive and negative cash flows for an investment or project. You’d also need to know the discount rate. From there, you could complete your calculations in this order:

•   List future cash flows for each year you expect to receive them.

•   Calculate the present value for each cash flow.

•   Add all present values for future cash flows together.

•   Subtract cash outflows from the present value sum of future cash flows.

You’ll need to know the present value calculation to complete the second step.

NPV Formula

Here’s what the NPV formula looks like:

PV = FV/(1 + k)^N

In this formula, k is the discount rate and n is the number of time periods.

Again, net present value calculations follow a distinct formula. A positive NPV means earnings from the investment should outpace the cost. Negative NPV, on the other hand, means you’re more likely to lose money on the investment.

The application of the formula depends on the number of expected cash flows for an investment or project.

Example of NPV with a Single Cash Flow Investment

If you’re evaluating potential investments with a single cash flow, then you could use this formula to calculate NPV:

NPV = Cash flow / (1 + i)t – initial investment

In this formula, i represents the required return or discount rate for the investment while t equals the number of time periods involved. The discount rate is an interest rate used to discount future cash flows for a financial instrument.

Weighted average cost of capital (WACC) usually serves as the discount rate for calculating NPV. The WACC measures a company’s cost of borrowing or financing.

Example of NPV with Multiple Cash Flows

If you’re evaluating projects or potential investments with multiple cash flows, you’ll use a different net present value formula. Here’s what the NPV formula looks like in that scenario:

NPV = Today’s value of expected cash flows – Today’s value of invested cash

💡 Quick Tip: The best stock trading app? That’s a personal preference, of course. Generally speaking, though, a great app is one with an intuitive interface and powerful features to help make trades quickly and easily.

Tools to Help Calculate NPV

If you want to simplify your calculations you could look for an online net present value calculator. Or you could use the NPV function in spreadsheet software, such as Microsoft Excel or something similar. The NPV function helps calculate net present value for an investment based on the discount rate and a series of future cash flows, both positive and negative.

To use this function, you’d simply create a new Excel spreadsheet, then navigate to the “Formulas” tab. Here, you’d choose “Financial”, then from the dropdown menu select “NPV”. This will bring up the function where you can enter the rate and each value you want to calculate.

What Does NPV Show You?

The NPV formula should tell you at a glance whether you’re likely to make money from an investment, lose money or break-even. This can help when comparing multiple investments to decide where to put your money when you have a limited amount of capital to work with.

It works the same way in capital budgeting. Say a fast-food chain is trying to decide whether to expand into a new market which entails opening up 10 more locations. They could calculate the net present value for each location, based on expected cash flows, to determine whether moving ahead with the project is a financially sound business decision.

What Is a Good NPV?

Generally speaking, a net present value greater than zero is good. This means that the investment or expansion project is likely to yield a gain. When the net present value is below zero, you have negative NPV which means the project or investment is likely to result in a loss.

The higher the number produced by a net present value calculation, the better. But it’s important to remember that the results produced by applying the NPV formula are only as reliable as the data points used in the calculation.

Inaccurate cash flow projections could result in skewed numbers which may produce a net present value estimate that’s above or below the actual returns you’re likely to realize.

Comparing NPV

Here are some ways that NPV stacks up to other types of calculations.

NPV vs Present Value

NPV and present value may sound similar but they measure different things. Present value or PV is the present value of all future cash inflows over a set period of time. Companies use this calculation to estimate values for future revenues or liabilities. When you calculate present value, you’re trying to measure the value of future cash flows today.

Net present value, on the other hand, is the sum of the present values for both cash inflows and cash outflows. With the NPV formula, you’re trying to determine how profitable an investment might be, based on the initial investment required and expected rate of return.

NPV vs IRR

Analysts use IRR or internal rate of return to evaluate proposed capital expenditures. The IRR calculation determines the percentage rate of return at which a project’s cash flows result in a net present value of zero. Like NPV, internal rate of return is also a part of capital budgeting.

Both NPV and IRR measure potential profitability but in different ways. When calculating the net present value of an investment, you’re estimating returns in dollars. With an internal rate of return, you’re estimating the percentage return an investment or project should generate.

Depending on whether you’re trying to target a specific dollar amount or percentage amount for returns, you may apply one or both formulas when evaluating an investment.

NPV vs ROI

Net present value measures expected cash flows for potential investments. You’re looking at future discounted cash flows to determine whether an investment makes sense financially.

Return on investment, or ROI, measures the efficiency of an investment, in terms of the rate of return that the investment is likely to produce. With ROI, you’re looking at the cash flows you’re likely to gain from an investment. To find ROI, you’d add up the total revenues less the total costs involved, then divide that figure by the total costs.

NPV vs Payback Period

The payback period is the period of time required for a return on investment to equal the initial investment. Payback period calculations don’t account for the time value of money. Instead, they look at how long it will take for you to realize a return from an investment that’s equal to the dollar amount that you invested.

Calculating the payback period helps determine how long to hold onto an investment. You might use this method if you’re trying to compare multiple investments to see which one is a better fit for your personal investing timeline. But if you want to get a sense of the total return you’re likely to realize, then you’d still want to apply the net present value formula.

Benefits and Drawbacks of NPV

Net present value can help analyze and evaluate business projects or personal investments. You can easily see at a glance what you could stand to gain — or lose — from making a particular investment. But the NPV formula does have some limitations that are important to be aware of.

Benefits of NPV

Net present value’s main advantage is that it takes the time value of money into consideration. By looking at discounted cash flows you can get a better understanding of the viability of an investment, based on what you’ll get out of it versus what you’ll put in.

This can help with decision-making when choosing investments for your portfolio or making strategic capital investments in a business. Net present value calculations can also help companies with projecting future value based on the investments they make today.

Drawbacks of NPV

The biggest disadvantage or flow associated with net present value is that results depend on the quality of the information that’s being used. If your projections for future cash flows are off, that can produce inaccurate results when using the net present value formula.

NPV can also overlook some hidden costs involved in an investment or project which may detract from total returns. It also doesn’t take into account the margin of safety, or the difference between an investment’s price and its value.

Finally, it’s difficult to use net present value to evaluate projects or investments that are different in size or nature, as the input values are likely to be very different.

💡 Quick Tip: Are self-directed brokerage accounts cost efficient? They can be, because they offer the convenience of being able to buy stocks online without using a traditional full-service broker (and the typical broker fees).

How Investors Can Use NPV

You can use NPV to evaluate stocks and other securities, including alternative investments, based on your time frame and projected profits. With stocks, for example, net present value can give you an idea of whether a company is a good buy or not by calculating NPV per share.

To do that, you’d divide the company’s net present value by the number of outstanding shares in the company to get this number. If the net value per share is higher than the stock’s current market price, then the stock could be considered a good buy. On the other hand, if the net value per share is below the stock’s current market price that suggests you might lose money if you decide to buy in.

The Takeaway

As discussed, Net present value, or NPV, represents the difference between the present value of cash inflows and outflows over a set period of time. Understanding the net present value formula can help with making smarter investment decisions.

As with any tool, most investors use NPV along with other financial ratios and forms of analysis before deciding whether to purchase any asset. If you have questions about how NPV can be used as a part of an investment strategy, it may be worthwhile to consult with a financial professional.

Ready to invest in your goals? It’s easy to get started when you open an investment account with SoFi Invest. You can invest in stocks, exchange-traded funds (ETFs), mutual funds, alternative funds, and more. SoFi doesn’t charge commissions, but other fees apply (full fee disclosure here).

For a limited time, opening and funding an Active Invest account gives you the opportunity to get up to $1,000 in the stock of your choice.

FAQ

Is a higher NPV better?

A higher NPV isn’t necessarily a good thing or means that an investment is better than another investment. But in general, a good NPV is a number that’s higher than zero.

What is the basic NPV investment rule?

The basic NPV investment rule is that projects or investments should only be pursued if they’ll lead to gains or productive gains.

Is NPV the same as profit?

NPV is not the same thing as profit, although a positive NPV is indicative of profit, while negative NPV is related to a loss.

Is a NPV of 0 acceptable?

An NPV of zero means that a project or investment isn’t expected to produce significant gains or losses. Whether that’s acceptable or not is up to the individual making the investment decision.

When should NPV not be used?

NPV might not be helpful or useful for comparing investments of drastically different sizes, or projects of different sizes.

Is Excel NPV accurate?

Excel’s NPV calculations should be accurate, but they’re only as accurate as the data that’s entered to make the calculation. So, it could be inaccurate, and it’s a good idea to double-check the calculation.

---

Photo credit: iStock/Sanja Radin

SoFi Invest®

SoFi Invest encompasses two distinct companies, with various products and services offered to investors as described below: Individual customer accounts may be subject to the terms applicable to one or more of these platforms.
1) Automated Investing and advisory services are provided by SoFi Wealth LLC, an SEC-registered investment adviser (“SoFi Wealth“). Brokerage services are provided to SoFi Wealth LLC by SoFi Securities LLC.
2) Active Investing and brokerage services are provided by SoFi Securities LLC, Member FINRA (www.finra.org)/SIPC(www.sipc.org). Clearing and custody of all securities are provided by APEX Clearing Corporation.
For additional disclosures related to the SoFi Invest platforms described above please visit SoFi.com/legal.
Neither the Investment Advisor Representatives of SoFi Wealth, nor the Registered Representatives of SoFi Securities are compensated for the sale of any product or service sold through any SoFi Invest platform.

Financial Tips & Strategies: The tips provided on this website are of a general nature and do not take into account your specific objectives, financial situation, and needs. You should always consider their appropriateness given your own circumstances.

Disclaimer: The projections or other information regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect actual investment results, and are not guarantees of future results.
Claw Promotion: Customer must fund their Active Invest account with at least $25 within 30 days of opening the account. Probability of customer receiving $1,000 is 0.028%. See full terms and conditions.

SOIN0124031