How to calculate NPV
/What is Net Present Value?
Net present value is an analysis tool used to decide whether to invest in a capital asset. It is employed as part of the capital budgeting process. A desirable investment is one that yields a positive net present value, which implies that a business will receive excess cash over time as a result of the investment. A negative net present value indicates that a company will lose money on a proposed investment. A negative net present value is usually grounds to terminate an investment that is under consideration.
How to Calculate Net Present Value
To calculate net present value in Excel, we use the following formula:
NPV = X * [(1+r)^n - 1]/[r * (1+r)^n]
Where:
X = The amount received per period
n = The number of periods
r = The rate of return
Advantages of Net Present Value
There are several advantages to the net present value concept, which are as follows:
Use of the time value of money concept. The main advantage of using NPV is that it incorporates the time value of money, so that future cash inflows and outflows are translated into today’s dollars. Since inflation reduces purchasing power over time, NPV provides the most accurate measure of a project’s actual profitability - especially during periods of high inflation.
Yields a numeric outcome. A further advantage of NPV is that it boils down the effects of all cash inflows and outflows into a single numeric outcome, which can then be used to compare the results of a variety of proposed projects.
Related AccountingTools Courses
Example of Net Present Value
The CFO of Smith Company is interested in the NPV associated with a production facility that the CEO wants to acquire. In exchange for an initial $10 million payment, Smith should receive payments of $1.2 million at the end of each of the next 15 years. Smith has a corporate cost of capital of 9%. To calculate the NPV, we insert the cash flow information into the NPV formula:
1,200,000*((1+0.09)^15-1)/(0.09*(1+0.09)^15) = $9,672,826
The present value of the cash flows associated with the investment is $327,174 lower than the initial investment in the facility, so Smith should not proceed with the investment.
It is not that difficult to estimate the amount of cash received per period, as well as the number of periods over which cash will be received. The difficult inclusion in the formula is the rate of return. This is generally considered to be a company's cost of capital, but can also be considered its incremental cost of capital, or a risk-adjusted cost of capital. In the latter case, this means that several extra percentage points are added to the corporate cost of capital for those cash flow situations considered to be unusually risky.
Enhancements to the NPV Calculation
The NPV calculation can be massively more complicated than the simplified example just shown. In reality, you may need to include the cash flows related to the following additional items:
Ongoing expenditures related to the investment
Variable amounts of cash flow being received over time, rather than the same amount every time
Variable timing for the receipt of cash, rather than the consistent receipt of a payment on the same date
The amount of working capital required for the project, as well as the release of working capital at the end of the project
The amount at which the investment can be resold at the end of its useful life
The tax value of depreciation on the fixed asset that was purchased
All of the preceding factors should be considered when evaluating NPV for an investment proposal. In addition, consider generating several models to account for the worst case, most likely, and best case scenarios for cash flows.
NPV can also be used to compare several cash flows to decide which has the largest current value. NPV is commonly used in the analysis of capital purchasing requests, to see if an initial payment for fixed assets and other expenditures will generate positive cash flows in the future. If so, NPV becomes the basis for a decision to buy a fixed asset.
Alternative Evaluation Methods
Net present value should not be the only method used to evaluate the need for a fixed asset. Here are some of the alternative methods that can be used:
Internal rate of return (IRR). The internal rate of return is the discount rate at which the present value of future cash flows equals the initial investment, resulting in an NPV of zero. It represents the expected rate of return on a project. If the IRR exceeds the company’s required rate of return (or hurdle rate), the investment is generally considered acceptable. However, IRR can be misleading when comparing mutually exclusive projects or when cash flows alternate between positive and negative.
Payback period. The payback period calculates the amount of time required to recover the initial investment from the project’s cash inflows. It’s a simple and quick way to assess risk, as shorter payback periods are often preferred. However, it does not consider cash flows beyond the payback period or the time value of money. This makes it less reliable for assessing long-term profitability.
Accounting rate of return. The accounting rate of return measures the expected annual accounting profit from an investment as a percentage of the initial or average investment. It uses financial statement data rather than cash flows, making it easy to calculate. However, it ignores the time value of money and may not accurately reflect the true profitability of a project. It is more commonly used for internal reporting and comparison of similar asset purchases.
Modified internal rate of return (MIRR). The modified internal rate of return addresses some flaws in the traditional IRR by assuming reinvestment of cash flows at the firm’s cost of capital or another specified rate. It provides a more realistic view of the project’s profitability. MIRR is particularly useful when a project has non-standard cash flows or when comparing multiple investment options. However, it still involves assumptions about reinvestment rates and can be complex to calculate manually.