**Net present value** takes into account the time value of money. All projected after-tax cash flow from a proposed investment is discounted to the present values using a minimum acceptable rate of return.

**Discount Rate**

An important issue in forecasting the time value of money in budgeting decisions is establishing the appropriate discount rate to use for calculating the present value of cash flows.

We’ll need to determine some minimum acceptable rate of return on the money invested. This target rate to use as the basis for present value calculations may be at or above the cost of capital.

This is entered in cell

B1of the example below. We need to see a12% minimum rate of return to consider this investment acceptable.

**Initial Investment**

Since our initial investment occurs immediately, it does not need to be discounted.

Our net present value in this case will be calculated as the sum of the discounted net cash flows minus the initial investment.

In our example, assume we are considering an investment having a $

20,000initial cost, entered in cellB10.

- ·
**Cash Flow**

For the purpose of simplicity, the analysis in this example will be based on annual after-tax cash flow.

In practice, our cash flow will often be measured in shorter increments, such as months and quarters.

In Row

4of our example below, we’ll project net cash flows after taxes over the next four years to be $4,800, $7,200, $9,600, and $10,800respectively.

In general, our investment is acceptable if it has a positive net present value. We’ll see this in cell

B10, the net present value returned when we calculate it all out is $3,722.Since the sum of the discounted net cash flows, $

23,722(in cellB8), is greater than the initial cost of $20,000(in cellB9), the investment is acceptable in this analysis.If subtracting the initial cost from the sum of the discounted net cash flows turned out to be a negative value, then the return on investment would not have been adequate to satisfy our minimum acceptable rate of return.

Let’s have a look at the formulas:

Looking back at the first illustration, notice that the values in Row

5range from.89at the end of the first year, to

.64at the end of the fourth year.This represents the value of a dollar we have today at the end of each projected year.

The syntax for the calculations in Row

5are:

1 / (1 + Discount Rate ) ^ Year Number

The

^(caret) is the exponentiation operator.The Discounted Cash Flow is the result of multiplying Row

4(net cash flow) by Row5.

Excel provides a

NPV(net present value) function to perform the discounting process with a single formula.The following formula has been entered in cell

E10and demonstrates that theNPVfunction can be applied to return the same value as the result in cellB10from the long calculation method.

=NPV(B1,B4:E4)-B9

The Excel

NPVfunction has an assumption that the first cash flow must occur at the end of one period.Therefore, we subtract the initial investment to get a net present value.

Here’s the syntax for the formula:

=NPV( DiscountRate , CashFlow ) – InitialInvestment

]]>Net present value can also be used to help select from competing investment alternatives.

When this method is used for screening alternative investments, a higher net present value is sometimes considered a positive indicator.