Financial Laboratory · Investment

Net present value (NPV)

Are a project’s future returns worth more today than its cost?

Back to 3.8 Investment appraisal

  • IB 3.8 Investment appraisal
  • HL only
  • Formula as on the guide’s formula sheet
  • Simulated data Example: Emberly Roasters, fictional

As printed on the guide’s formula sheet (p. 65), with the discount factors of the guide’s table (p. 66). NPV is HL only. The internal rate of return shown with it is enrichment, beyond the syllabus.

The calculator

Example figures: Emberly Roasters, a fictional business. Simulated data.

Your project
The rates in the guide’s discount table (p. 66).

A negative figure is a year in which more cash goes out than comes in.

Currency

The labels, workings and results use these words. Emberly Roasters’s figures are in dollars.

The figures

Project
Nitrogen-flush packaging line
Capital cost (year 0)
$120,000
Net cash flow, year 1
$22,000
Net cash flow, year 2
$30,000
Net cash flow, year 3
$36,000
Net cash flow, year 4
$38,000
Net cash flow, year 5
$34,000
Discount rate
8%

Changing these figures needs JavaScript. With it switched off, the page shows the full worked example for the figures above.

Result

These results are for the last complete figures. Correct the figure marked in the inputs to update them.

Net present value at 8%

$5,736

the returns are worth more today than the cost

Sum of present values
$125,736.00
Original cost
$120,000
NPV changes sign
between 8% and 10%
Internal rate of return Enrichment
about 9.7%the rate at which NPV is zero
Payback, for comparison
3 years and 10.1 months

Section 01: The formula and the working

Each formula in the guide’s words, then the working with the figures above, step by step.

Net present value (NPV) = ∑ present values of return − original cost

As printed on the guide’s formula sheet (p. 65).

Present value = return in a year × discount factor for that year and rate

Standard form; the factors come from the guide’s table (p. 66).

Discount factor = (1) ÷ ((1 + r)^n)

Enrichment Enrichment: where the table comes from. r is the rate as a decimal, n the year. In an examination, use the table.

Net present value at 8%

Given
  • Capital cost (year 0): $120,000
  • Net cash flow, year 1: $22,000
  • Net cash flow, year 2: $30,000
  • Net cash flow, year 3: $36,000
  • Net cash flow, year 4: $38,000
  • Net cash flow, year 5: $34,000
  • Discount rate: 8%
Formula
NPV = sum of the present values of the returns − original cost
Substitution
= (22,000 × 0.9259 + 30,000 × 0.8573 + 36,000 × 0.7938 + 38,000 × 0.7350 + 34,000 × 0.6806) − 120,000
Working
Year 1: 22,000 × 0.9259 = 20,369.80
Year 2: 30,000 × 0.8573 = 25,719
Year 3: 36,000 × 0.7938 = 28,576.80
Year 4: 38,000 × 0.7350 = 27,930
Year 5: 34,000 × 0.6806 = 23,140.40
Sum of present values = 125,736
125,736 − 120,000 = 5,736
Answer
$5,736

Discount factors at 8% from the guide's table (p. 66). A positive NPV means the returns are worth more, in today’s money, than the cost.

Unit
$, in today’s money
Interpretation
At 8%, the returns are worth $125,736.00 in today’s money, $5,736.00 more than the cost.
Business implication
On NPV alone the project adds value at this rate; the decision still weighs risk and what the figures leave out.

Section 02: The chart

Drawn from the figures above, with every value also in a table.

Each year’s return and its present value at 8%Net cash flow and present value at 8% by year: year 1 $22,000 worth $20,370 today; year 2 $30,000 worth $25,719 today; year 3 $36,000 worth $28,577 today; year 4 $38,000 worth $27,930 today; year 5 $34,000 worth $23,140 today. The later the year, the more its return is discounted.$0$10k$20k$30k$40kYear 1: net cash flow $22,000Year 1: present value $20,3701Year 2: net cash flow $30,000Year 2: present value $25,7192Year 3: net cash flow $36,000Year 3: present value $28,5773Year 4: net cash flow $38,000Year 4: present value $27,9304Year 5: net cash flow $34,000Year 5: present value $23,1405YearNet cash flowPresent value at 8%
Chart Each year’s net cash flow (grey) and its present value at 8% (blue). The gap grows with time: money received later is worth less today.
The chart’s figures as a table
Present values at 8%
YearNet cash flowDiscount factorPresent value
Year 1$22,0000.9259$20,369.80
Year 2$30,0000.8573$25,719.00
Year 3$36,0000.7938$28,576.80
Year 4$38,0000.7350$27,930.00
Year 5$34,0000.6806$23,140.40
Sum of present values$125,736.00
Less the original cost−$120,000
Net present value$5,736.00

Section 03: The discount rate

NPV at each rate in the guide’s discount table. The rate stands for what the money could earn elsewhere, plus an allowance for risk, so it is itself a judgement.

NPV at each of the guide’s rates
Discount rateNet present valueOn NPV alone
4%$21,322Worth more than it costs
6%$13,188Worth more than it costs
8% (the figures as entered)$5,736Worth more than it costs
10%−$1,096Worth less than it costs
20%−$28,010Worth less than it costs
Net present value at each discount rateNPV at the guide's rates: 4% $21,322, 6% $13,188, 8% $5,736, 10% −$1,096, 20% −$28,010. The higher the rate, the lower the NPV. NPV is zero at about 9.7%, the internal rate of return (enrichment).−$40k−$20k$0$20k$40k0%5%10%15%20%25%NPV at 4%: $21,322NPV at 6%: $13,188NPV at 8%: $5,736NPV at 10%: −$1,096NPV at 20%: −$28,0108%: $5,736Internal rate of return about 9.7% (enrichment)IRR about 9.7% (enrichment)Discount rateNPV at the guide’s rates (dots)

Reading. NPV is positive at 8% and negative at 10%, so the project’s return lies between the two: the decision depends on which rate the business requires. The internal rate of return, the rate at which NPV is exactly zero, is about 9.7% (enrichment: worked from the discount formula, not the table).

Section 04: What it means

For the figures above: the reading, the comparisons that give it meaning, and what a manager might do.

What the number means

At a discount rate of 8%, the project’s returns are worth $125,736.00 in today’s money. Taking away the $120,000 cost leaves an NPV of $5,736.00: on these estimates the project earns more than the rate the money could earn elsewhere.

What to compare it with

Compare the NPV with other projects’ NPVs at the same rate, and look at the rate itself: the NPV turns negative between 8% and 10%, so a business that requires 10% would reject a project that one requiring 8% would accept. Compare the size of the NPV with the size of the investment: a small positive NPV on a large cost leaves little room for error.

Why benchmarks vary

The right rate reflects what the money could earn elsewhere and the risk of the project, so it differs between businesses and over time: when interest rates rise, or when a project is riskier, a higher rate is used and NPV falls. The guide’s table gives five rates, and an examination uses the table; in practice a business chooses its own rate. Every method rests on estimates of future cash flows, which grow less reliable the further ahead they look.

What a manager might do

Options for a manager, not IB requirements; each has a cost or a risk to weigh.

  • Agree the discount rate before appraising, so that it is not chosen to fit the answer.
  • Test the estimates as well as the rate: 10% lower returns would change the NPV by about $12,574.
  • Compare projects of different sizes with care: a larger NPV may simply come from a larger investment.
  • Weigh what the figures leave out before deciding: the fit with the business’s objectives, how risky the estimates are, and the effect on staff, customers and the environment.

Section 05: Learn more