Net Present Value: Finance Study Notes

💰 Net Present Value (NPV)

Main Topics Covered

• What NPV is, and why money today is worth more than money later
• How NPV is determined: discounting and summing cash flows
• The NPV formulas: single cash flow, benefits minus costs, net cash flow, and constant cash flow
• Capital efficiency (NPVI) with a worked example
• Alternative discounting frequencies: end, mid and beginning of period
• Choosing the discount rate, and risk-adjusted NPV (rNPV)
• Using NPV in decision making
• Advantages and disadvantages of NPV
• NPV as an integral transform (continuous form, Laplace and Z-transform)
• A full worked example (the new product line) and the lottery example
• Common pitfalls, including the Excel =NPV(...) issue
• Alternative capital budgeting methods

---

📌 Overview: What Is NPV?

Net present value (NPV), also known as net present worth (NPW), is a method for assessing whether future amounts of money are worth more or less than the cost of an investment made today.

• Widely used in finance, economics, and project evaluation to judge whether a planned activity is expected to create value.
• Works by converting future cash flows into their "present value", recognising that money available now is more valuable than the same amount received later.
• This adjustment reflects factors such as interest rates, inflation, and the opportunity to use money for other purposes.

NPV measures the value of an asset that has cash flow by adding up the present value of all future cash flows that asset will generate.

Interpreting the sign

NPV result	Meaning
Positive NPV	The present value of expected future benefits exceeds the initial cost; likely to be financially worthwhile
Negative NPV	The opposite; the investment is likely not worthwhile

• Because it summarises expected gains and losses in a single figure, NPV is a central tool for comparing alternative projects and making informed financial and economic decisions.
• It provides a method for evaluating and comparing capital projects or financial products with cash flows spread over time, such as:
  • loans
  • investments
  • payouts from insurance contracts
  • many other applications

---

⏳ Time Value of Money

The present value of a cash flow depends on the time interval between now and the cash flow, because of the time value of money (which includes the annual effective discount rate).

• Example: a lender may offer 99 cents for the promise of receiving $1.00 a month from now, but the promise to receive that same dollar 20 years in the future would be worth much less today to that same lender, even if the payback in both cases was equally certain.
• This decrease in the current value of future cash flows is based on a chosen rate of return (discount rate).
• In a time series of identical cash flows, the cash flow in the present is the most valuable, and each future cash flow is less valuable than the previous one.
• Why? A present cash flow can be invested immediately and begin earning returns, while a future flow cannot.

---

🧮 How NPV Is Determined

1. Calculate the costs (negative cash flows) and benefits (positive cash flows) for each period of the investment.
2. Discount each period's cash flow back to its present value (PV) at a periodic rate of return (the rate of return dictated by the market).
3. NPV is the sum of all the discounted cash flows.

Key points

• Because of its simplicity, NPV is a useful tool to determine whether a project or investment will result in a net profit or a loss: a positive NPV results in profit, a negative NPV in a loss.
• NPV measures the excess or shortfall of cash flows, in present value terms, above the cost of funds.
• Unlimited capital budgeting (theory): a company should pursue every investment with a positive NPV.
• Capital constraints (practice): a company is limited to the projects with the highest NPV whose cost cash flows (initial cash investment) do not exceed the company's capital.
• NPV is a central tool in discounted cash flow (DCF) analysis and a standard method for using the time value of money to appraise long-term projects. It is widely used throughout economics, financial analysis, and financial accounting.

Special case: only inflows after purchase

When all future cash flows are positive (such as the principal and coupon payment of a bond) and the only outflow is the purchase price:

• NPV is simply the PV of future cash flows minus the purchase price (which is its own PV).
• NPV can be described as the "difference amount" between the sums of discounted cash inflows and cash outflows. It compares the present value of money today to the present value of money in the future, taking inflation and returns into account.

NPV versus IRR (converse processes)

Process	Input	Output
NPV	A sequence of cash flows and a discount rate (or discount curve)	A present value, which is the current fair price
Converse DCF process	A sequence of cash flows and a price	The discount rate, or internal rate of return (IRR), which would yield the given price as NPV

• This rate, called the yield, is widely used in bond trading.

---

📐 The NPV Formulas

Present value of a single cash flow

Each cash inflow/outflow is discounted back to its present value (PV). Then all are summed, so NPV is the sum of all terms:

$\mathrm{PV} = \frac{R_t}{(1+i)^t}$

where:

• $t$ is the time of the cash flow
• $i$ is the discount rate, i.e. the return that could be earned per unit of time on an investment with similar risk
• $R_t$ is the net cash flow (cash inflow − cash outflow) at time $t$. For educational purposes, $R_0$ is commonly placed to the left of the sum to emphasize its role as (minus) the investment.

The term $1/(1+i)^t$ is the discount factor, also known as the present value factor.

Notes on use

• The result of this formula is multiplied with the annual net cash inflows and reduced by the initial cash outlay.
• Where cash flows are not equal in amount, the formula is used to determine the present value of each cash flow separately.
• Any cash flow within 12 months will not be discounted for NPV purposes; nevertheless, the usual initial investments during the first year ($R_0$) are summed up as a negative cash flow.

NPV as discounted benefits minus costs

The NPV can also be thought of as the difference between the discounted benefits and costs over time:

$\mathrm{NPV} = \mathrm{PV}(B) - \mathrm{PV}(C)$

where:

• $B$ are the benefits or cash inflows
• $C$ are the costs or cash outflows

Given the (period, cash inflows, cash outflows) shown by $(t, B_t, C_t)$, where $N$ is the total number of periods:

$\mathrm{NPV}(i,N) = \sum_{t=0}^{N} \frac{B_t}{(1+i)^t} - \sum_{t=0}^{N} \frac{C_t}{(1+i)^t}$

• $B_t$ are the benefits or cash inflows at time $t$.
• $C_t$ are the costs or cash outflows at time $t$.

NPV using net cash flow

The NPV can be rewritten using the net cash flow $(R_t)$ in each time period:

$\mathrm{NPV}(i,N) = \sum_{t=0}^{N} \frac{R_t}{(1+i)^t}$

Conventions:

• The initial period occurs at time $t=0$, and cash flows in successive periods are discounted from $t=1,2,3,\dots$ and so on.
• All future cash flows during a period are assumed to occur at the end of each period.

Constant cash flow (finite geometric series)

For a constant cash flow $R$, the NPV is a finite geometric series given by:

$\mathrm{NPV}(i,N,R) = R\left(\frac{1-\left(\frac{1}{1+i}\right)^{N+1}}{1-\left(\frac{1}{1+i}\right)}\right), \quad i \neq 0$

Why $R_0$ matters

• Including the $R_0$ term is important in the above formulae.
• A typical capital project involves a large negative $R_0$ cash flow (the initial investment) with positive future cash flows (the return on the investment).
• A key assessment is whether, for a given discount rate, the NPV is positive (profitable) or negative (loss-making).
• The IRR is the discount rate for which the NPV is exactly 0.

---

⚙️ Capital Efficiency (NPVI)

The NPV method can be slightly adjusted to calculate how much money is contributed to a project's investment per dollar invested. This is known as the capital efficiency ratio. The formula for net present value per dollar investment (NPVI) is:

$\mathrm{NPVI}(i,N) = \frac{\sum_{t=1}^{N} \frac{R_t}{(1+i)^t}}{\sum_{t=1}^{N} \frac{C_t}{(1+i)^t}}$

where:

• $R_t$ is the net cash flow (cash inflow − cash outflow) at time $t$
• $C_t$ are the net cash outflows at time $t$

Example

If the discounted benefits across the life of a project are $100 million and the discounted net costs are $60 million, then:

$\mathrm{NPVI} = \frac{\$100\mathrm{M} - \$60\mathrm{M}}{\$60\mathrm{M}} \approx 0.6667$

That is, for every dollar invested in the project, a contribution of $0.6667 is made to the project's NPV.

---

🕒 Alternative Discounting Frequencies

The standard NPV formula assumes that benefits and costs occur at the end of each period, resulting in a more conservative NPV. However, cash inflows and outflows may occur at the beginning or in the middle of the period.

Mid-period discounting

$\mathrm{NPV}(i,N) = \sum_{t=0}^{N} \frac{R_t}{(1+i)^{t-0.5}}$

• Over a project's lifecycle, cash flows are typically spread across each period (for example across each year), so the middle of the year represents the average point in time at which these cash flows occur.
• Hence mid-period discounting typically provides a more accurate, although less conservative, NPV.

Beginning-of-period discounting

$\mathrm{NPV}(i,N) = -\text{Initial Investment} + \sum_{t=1}^{N} \frac{R_t}{(1+i)^{t-1}}$

• This results in the least conservative NPV.

Comparison

Method	Exponent on $(1+i)$	Conservativeness
End of period (standard)	$t$	More conservative
Mid-period	$t - 0.5$	Typically more accurate, less conservative
Beginning of period	$t - 1$	Least conservative

---

🎯 The Discount Rate

The rate used to discount future cash flows to present value is a key variable of the process.

Common approaches

• Weighted average cost of capital (after tax): often used, but many people believe that higher discount rates are appropriate to adjust for risk, opportunity cost, or other factors.
• Variable discount rate: higher rates applied to cash flows further along the time span might be used to reflect the yield curve premium for long-term debt. An NPV using variable discount rates (if they are known for the duration of the investment) may better reflect the situation than one calculated from a constant rate.
• Alternative-venture rate: decide the rate which the capital needed for the project could return if invested elsewhere. Example: if the capital required for Project A can earn 5% elsewhere, use 5% in the NPV calculation to allow a direct comparison between Project A and the alternative.
• Reinvestment rate: the rate of return for the firm's investments on average.
  • When analyzing projects in a capital constrained environment, it may be appropriate to use the reinvestment rate rather than the weighted average cost of capital.
  • It reflects the opportunity cost of investment, rather than the possibly lower cost of capital.
• Target rate of return: for some professional investors, funds are committed to target a specified rate of return. That rate should be selected as the discount rate, allowing a direct comparison between the project's profitability and the desired rate of return.

Which rate for which purpose?

Purpose	Likely better choice
Simply determine whether a project will add value to the company	Firm's weighted average cost of capital
Decide between alternative investments to maximize the value of the firm	Corporate reinvestment rate

Risk-adjusted net present value (rNPV)

• Using variable rates over time, or discounting "guaranteed" cash flows differently from "at risk" cash flows, may be a superior methodology but is seldom used in practice.
• Using the discount rate to adjust for risk is often difficult to do in practice (especially internationally) and difficult to do well.
• An alternative is to explicitly correct the cash flows for the risk elements using rNPV or a similar method, then discount at the firm's rate.

---

✅ Use in Decision Making

NPV is an indicator of how much value an investment or project adds to the firm.

• If $R_t$ is positive, the project has a positive cash inflow at time $t$. If $R_t$ is negative, the project is in the status of discounted cash outflow at time $t$.
• Appropriately risked projects with a positive NPV could be accepted. This does not necessarily mean they should be undertaken, since NPV at the cost of capital may not account for opportunity cost, i.e. comparison with other available investments.
• Mutually exclusive alternatives: in financial theory, the one yielding the higher NPV should be selected.
• A positive NPV indicates that the projected earnings of a project or investment (in present dollars) exceed the anticipated costs (also in present dollars).

Net Present Value Rule: the only investments that should be made are those with positive NPVs.

• An investment with a positive NPV is profitable, but one with a negative NPV will not necessarily result in a net loss: it is just that the internal rate of return of the project falls below the required rate of return.

---

⚖️ Advantages and Disadvantages

Advantages

• Includes all relevant time periods and cash flows by considering the time value of money, consistent with the goal of wealth maximization for shareholders.
• Accounts for cash flow timing patterns and size differences for each project, and provides an easy, unambiguous dollar-value comparison of different investment options.
• Can be easily calculated using modern spreadsheets, assuming the discount rate and future cash flows are known.
• Additive: for a firm considering multiple projects, the NPVs of different projects may be aggregated to calculate the highest wealth creation, based on the available capital the firm can invest.

Disadvantages

The NPV approach does not consider hidden costs and project size. Thus, investment decisions on projects with substantial hidden costs may not be accurate.

Relies on input parameters such as knowledge of future cash flows

• NPV depends heavily on knowledge of future cash flows, their timing, the length of the project, the initial investment required, and the discount rate.
• It can only be accurate if these inputs are correct.
• Sensitivity analysis can examine how the NPV changes as input variables change, reducing the uncertainty of the NPV.

Relies on choice of discount rate and discount factor

• Accuracy relies heavily on the choice of a discount rate (and hence discount factor) representing an investment's true risk premium.
• The discount rate is assumed to be constant over the life of an investment, but discount rates can change over time, for example as the cost of capital changes.
• Other drawbacks include a lack of consideration for a project's size and the cost of capital.

Lack of consideration of non-financial metrics

• The NPV calculation is purely financial and does not consider non-financial metrics that may be relevant to an investment decision.

Difficulty in comparing mutually exclusive projects

• Comparing mutually exclusive projects with different investment horizons can be difficult.
• Since unequal projects are all assumed to have duplicate investment horizons, the NPV approach can be used to compare the optimal duration NPV.

---

🔬 Interpretation as an Integral Transform

The time-discrete formula

$\mathrm{NPV}(i,N) = \sum_{t=0}^{N} \frac{R_t}{(1+i)^t}$

can also be written in a continuous variation:

$\mathrm{NPV}(i) = \int_{t=0}^{\infty} (1+i)^{-t} \cdot r(t)\,dt$

where $r(t)$ is the rate of flowing cash, given in money per time, and equals 0 when the investment is over.

• NPV can be regarded as a Laplace-transformed (continuous) or Z-transformed (discrete) cash flow, with an integral operator including the complex number $s$, which resembles the interest rate $i$ from the real number space, or more precisely $s = \ln(1+i)$.

$F(s) = \{\mathcal{L}f\}(s) = \int_{0}^{\infty} e^{-st} f(t)\,dt$

• From this follow simplifications known from cybernetics, control theory and system dynamics.
• Imaginary parts of the complex number $s$ describe the oscillating behaviour (compare with the pork cycle, cobweb theorem, and phase shift between commodity price and supply offer).
• Real parts are responsible for representing the effect of compound interest (compare with damping).

---

🧪 Worked Examples

Example 1: Introducing a new product line

Setup

• A corporation must decide whether to introduce a new product line.
• Immediate cost of 100,000 at $t=0$, represented as a negative outgoing cash flow: −100,000.
• The product provides equal benefits of 10,000 for each of 12 years, beginning at $t=1$.
• No outgoing cash flows after the initial 100,000 cost.
• Simplifying assumption: the net cash received or paid is lumped into a single transaction on the last day of each year.
• After 12 years the product provides no cash flow and is discontinued without additional costs.
• The effective annual discount rate is 10%.

Calculation

• Total present value of the incoming cash flows: 68,136.91.
• Total present value of the outgoing cash flows: simply 100,000 at $t=0$.

$\mathrm{NPV} = PV(\text{benefits}) - PV(\text{costs})$

$\begin{aligned}\mathrm{NPV} &= 68{,}136.91 - 100{,}000 \\ &= -31{,}863.09\end{aligned}$

Observations

• As $t$ increases, the present value of each cash flow decreases. The final incoming cash flow has a future value of 10,000 at $t=12$ but a present value (at $t=0$) of 3,186.31.
• The opposite of discounting is compounding: investing 3,186.31 at $t=0$ at 10% compounded for 12 years results in a cash flow of 10,000 at $t=12$ (the future value).
• Although the incoming cash flows ($10{,}000 \times 12 = 120{,}000$) appear to exceed the outgoing cash flow (100,000), the undiscounted flows make the project appear misleadingly profitable.
• When discounted, the project results in a net loss of 31,863.09, so the NPV calculation indicates the project should be disregarded.
• Cash flows in different periods cannot be accurately compared unless adjusted to reflect their value at the same period of time (here $t=0$).

Inherent assumptions

1. The investment horizons of all possible projects are equally acceptable to the investor (e.g. a 3-year project is not necessarily preferable to a 20-year project).
2. The 10% discount rate is the appropriate (and stable) rate for each project considered, and each project is assumed equally speculative.
3. Shareholders cannot get above a 10% return on their money if they directly assumed an equivalent level of risk. (If the investor could do better elsewhere, no projects should be undertaken by the firm, and the excess capital should be turned over to shareholders through dividends and stock repurchases.)

More realistic problems would also consider factors such as:

• smaller time buckets
• taxes (including cash flow timing)
• inflation
• currency exchange fluctuations
• hedged or unhedged commodity costs
• risks of technical obsolescence
• potential future competitive factors
• uneven or unpredictable cash flows
• a more realistic salvage value assumption

Example 2: Powerball lottery

• Winning a Powerball lottery of $500 million.
• If one does not select the "CASH" option, one is paid $25,000,000 per year for 20 years, a total of $500,000,000.
• If one selects the "CASH" option, one receives a one-time lump sum of approximately $285 million, the NPV of $500,000,000 paid over time.
• Both scenarios are before taxes, and the "other factors" above could affect the payment amount.

---

⚠️ Common Pitfalls

Pitfall	Explanation	Remedy
Negative late cash flows	If $R_t$ is generally negative late in the project (e.g. clean-up and restoration costs in an industrial or mining project), the company owes money at that stage, so a high discount rate is not cautious but too optimistic.	Include explicit provision for financing any losses after the initial investment, i.e. explicitly calculate the cost of financing such losses.
Adding a risk premium to the discount rate	A bank might charge a higher rate for a risky project, but that is not a valid way to adjust NPV for risk (though a reasonable approximation in some cases). If risk causes losses, a discount rate reduces the effect of such losses below their true financial cost.	Identify and value risks explicitly, e.g. by actuarial or Monte Carlo techniques, and explicitly calculate the cost of financing any losses.
Compounding of the risk premium	The rate is a composite of the risk-free rate and the risk premium, so future cash flows are discounted by both, and this effect compounds with each subsequent cash flow, giving a much lower NPV than might otherwise be calculated.	The certainty equivalent model can account for the risk premium without compounding its effect on present value.
No overall picture of gain or loss	NPV does not give a percentage gain relative to the investment.	Use IRR or other efficiency measures as a complement to NPV.
Computing NPV on cash flows after interest	A common error among non-specialist users; it double counts the time value of money.	Use free cash flow as the basis for NPV computations.

Excel's =NPV(...) function

Microsoft Excel's =NPV(...) formula makes two assumptions that result in an incorrect solution:

1. The time between each item in the input array is constant and equidistant (e.g. 30 days between item 1 and item 2), which may not be correct for the cash flow being discounted.
2. The item in the first position of the array is assumed to be period 1, not period zero, so all array items are discounted by one extra period.

Fix: use the =XNPV(...) formula.

Software support

• Many computer-based spreadsheet programs have built-in formulae for PV and NPV.

---

🔀 Alternative Capital Budgeting Methods

Method	Description
Adjusted present value (APV)	The net present value of a project if financed solely by ownership equity, plus the present value of all the benefits of financing
Accounting rate of return (ARR)	A ratio similar to IRR and MIRR
Cost-benefit analysis	Includes issues other than cash, such as time savings
Internal rate of return (IRR)	Calculates the rate of return of a project while disregarding the absolute amount of money to be gained
Modified internal rate of return (MIRR)	Similar to IRR, but makes explicit assumptions about the reinvestment of the cash flows; sometimes called Growth Rate of Return
Payback period	Measures the time required for the cash inflows to equal the original outlay; it measures risk, not return
Real option	Attempts to value managerial flexibility that is assumed away in NPV
Equivalent annual cost (EAC)	A capital budgeting technique useful in comparing two or more projects with different lifespans

Risk-adjusted net present value (rNPV) in detail

Risk-adjusted net present value (rNPV), or expected net existing value (eNPV), is a method to value risky future cash flows.

• rNPV is the standard valuation method in the drug development industry, where sufficient data exists to estimate success rates for all R&D phases.
• A similar technique is used in the probability model of credit default swap (CDS) valuation.
• rNPV modifies the standard NPV calculation of DCF analysis by multiplying each cash flow by the estimated probability that it occurs (the estimated success rate).
• In the language of probability theory, the rNPV is the expected value.
• This contrasts with the more general valuation approach, where risk is instead incorporated by adding a risk premium percentage to the discount rate, as opposed to weighting the cash flows.