Net present value (NPV) is a core component ofÂ corporate budgeting. It is a comprehensive way to calculate whether a proposed project will be value added or not. The calculation of NPV encompasses many financial topics in one formula: Â cash flows, theÂ time value of money, the discount rate over the duration of the project (usually WACC), terminal value and salvage value.Â
This is not a beginner's topic, and it is recommended you read the above topics first. (For related reading, see What are the disadvantages of using net present value as an investment criterion?)Â
Net Present Value Defined
Let's examine each step of NPV in order. The formula is:Â
NPV= âˆ‘Â {AfterTax Cash Flow / (1+r)^t}Â  Initial Investment
Broken down, each period's aftertax cash flow at timeÂ tÂ is is discounted by some rate,Â r. Â The sum of all these discounted cash flows is then offset by the initial investment, which equals the current NPV.
Any NPV greater than $0 is a valueadded project, but in the decisionmaking process among competing projects, the one with the highest NPV is the one that should be chosen. One pitfall in this approach is that while financially sound from theory point of view, an NPVÂ calculation is only as good as the data driving it. Coming up with the correct assumptions (acquisition and disposition costs, all tax implications, the actual scope and timing of cash flows) is extremely difficult. This is where the majority of the work actually takes place. If you have the data, plugging it in is easy. Â
Calculating NPV in Excel
There are two ways to calculate NPV in Excel, one is by just using one of the built in NPV formulas, the second is by breaking out the component cash flows and calculating each step individually, then using those calculations to produce NPV. Â
The second method is preferable because financial modeling best practices require calculations to be transparent and easilyÂ auditable. The trouble with piling all of theÂ calculationsÂ into a formula is that you can't easily see what numbers go where, or what numbers are user inputs or hard coded. The other big problem is that the built in Excel formula will notÂ net out the initial cash outlay. Believe it or not, you actually have to manually add it back in if you used the builtin formula. This is why we recommend and demonstrate the first approach. Â Â
Here is a simple example. What makes this example simple among other things is that the timing ofÂ cashflowsÂ is both known and consistent (discussed further below). Â
Assume a company is assessing the profitability of Project X. Â Project X requires $250,000 in funding and is expected to generate $100,000 in aftertax cash flows the first year, and then grow by $50,000 for each of the next four years.
You can break out a schedule as follows:
[RightClick and open image in new window if hard to read]
Â
NPV Complications
The above example covers all the steps, but there are a few simplifications. First, the assumption above is that all cash flows are received in one lump sum at year end. This is obviously unrealistic. In the real world, not only is it unlikely that you would only perform this analysis at yearend, but it's also improbable you'd receive 100% of aftertax cash flows on that date. (Learn more formulas by taking Investopedia'sÂ excel course online.)Â
The correct method to fix the first problem is by creating a stub discount factor (adjust the t, in years) by the amount of time elapsed since the last completed year, and the second problem is corrected by assuming cash flows are discounted at the middle of the period, rather than the end. This better approximates the more realistic accumulation of aftertax cash flows over the course of the year. Â And example of creating a stub year can be found in the CAGR Article. Â

What is the formula for calculating net present value (NPV)?
Net present value (NPV) is a method of determining the current value of all future cash flows generated by a project after ... Read Answer >> 
How do I use Excel to get discount rate over time?
Learn how to calculate discount rate in Microsoft Excel and how to find the discount factor over a specified number of years. Read Answer >> 
What are the disadvantages of using net present value as an investment criterion?
While net present value (NPV) calculations are useful when you are valuing investment opportunities, the process is by no ... Read Answer >> 
When and why should the terminal value be discounted?
Find out why investors use the terminal value, why the terminal value is discounted to the present day, and how it's related ... Read Answer >> 
How do you calculate IRR in Excel?
Understand how to calculate the internal rate of return (IRR) in Excel and how it's used to determine anticipated yield per ... Read Answer >>

Investing
Time Value Of Money: Determining Your Future Worth
Determining monthly contributions to college funds, retirement plans or savings is easy with this calculation. 
Investing
Free Cash Flow Yield: The Best Fundamental Indicator
Cash in the bank is what every company strives to achieve. Find out how to determine how much a company is generating and keeping. 
Small Business
Capital Budgeting: Which is Better, IRR or NPV?
Using internal rate of return and net present value for capital budgeting evaluations often end in the same result. But there are times when using NPV to discount cash flows makes more sense. 
Investing
Valuing Firms Using Present Value of Free Cash Flows
When trying to evaluate a company, it always comes down to determining the value of the free cash flows and discounting them to today. 
Investing
Fundamental Case Study: Is Amazon's Cash Flow Actually Solid? (AMZN)
Review Amazon's cash flow situation, including its free cash flow yield, operating cash flow from organic growth and cash flow from debt financing.

Net Present Value  NPV
Net Present Value (NPV) is the difference between the present ... 
Initial Cash Flow
Initial cash flow is the amount of money paid out or received ... 
Net Present Value Rule
A rule stating that an investment should be accepted if its net ... 
Adjusted Present Value  APV
The Net Present Value (NPV) of a project if financed solely by ... 
Profitability Index
An index that attempts to identify the relationship between the ... 
Cash Flow Per Share
A measure of a firm's financial strength, calculated as: Cash ...