Finance Desk

Investment appraisal

Two projects, three methods, and not always the same answer. Appraise Halden Distribution's two projects by payback, average rate of return and, at HL, net present value; change the estimates and the rate, and see when the methods agree, when they disagree and what none of them can tell you.

Show content for

Showing everything. HL-only material is marked HL.

Section 01: The appraisal desk

The case: the same warehouse as the ratio desk, a year later, choosing what to invest in.

The projects belong to the Halden Distribution case. Its accounts are on the ratio desk.

Interaction

Two projects for 2027

Source: Simulated data

Change any estimate or, at HL, the discount rate. The results, the chart, the tables and the workings all follow.

Halden's owners want to win back Lumen Home's confidence and cut the cost of errors before next year's peak. The finance manager has estimated the net cash flows of two projects, each starting in 2027. Every figure is a simulated estimate, and the further ahead an estimate looks, the less reliable it is.

Project A Automated pack-and-label line

A machine line that bags, weighs and labels orders. It replaces six packing roles and most labelling errors. The returns start slowly while staff learn to run it, as they did with the scanners, and the line is expected to last six years.

Net cash flow (returns) in each year

Project B Voice picking for the night shift

Headsets that read out each pick, so that pickers keep their hands and eyes free. It cuts errors at once, which is worth most now, while the night shift is new; the returns fall as the shift gains experience and the equipment ages. It is expected to be replaced after four years.

Net cash flow (returns) in each year

Discount rate for NPV HL

Only the rates in the guide's discount table (p. 66), whose factors are used exactly as printed.

Results

Payback, average rate of return and net present value for each project, and which project each method prefers
Method Project A Project B Prefers
Payback period4 years2 years and 6 monthsProject B
Average rate of return9.17%6.25%Project A
Net present value at 10% HL£60,390£8,209Project A

Payback. Project B pays back first: 2 years and 6 months, against 4 years.

Average rate of return. Project A has the higher average rate of return: 9.17% a year, against 6.25%.

Net present value. At 10%, Project A adds more value in today’s money: £60,390, against £8,209 for Project B.

Taken together. The methods disagree: payback prefers Project B; ARR prefers Project A; NPV prefers Project A. That is the judgement to make: speed of recovery against the size of the return.

Cumulative net cash flow of the two projectsProject A: from −£600,000 in year 0 to £330,000 at the end of year 6; pays back in 4 years. Project B: from −£240,000 in year 0 to £60,000 at the end of year 4; pays back in 2 years and 6 months.−£600k−£400k−£200k£0£200k£400k0123456YearCumulative net cash flowProject AProject B
  • Project A (solid line): pays back in 4 years, at the filled dot
  • Project B (dashed line): pays back in 2 years and 6 months, at the filled dot
Chart Cumulative net cash flow, from the capital cost in year 0. A project pays back where its line crosses zero. Simulated estimates; the chart is redrawn from the inputs above.
The chart's figures as a table
Year Project A Project B
Net cash flow Cumulative Net cash flow Cumulative
Year 0−£600,000−£600,000−£240,000−£240,000
Year 1£90,000−£510,000£110,000−£130,000
Year 2£150,000−£360,000£100,000−£30,000
Year 3£180,000−£180,000£60,000£30,000
Year 4£180,000£0£30,000£60,000
Year 5£180,000£180,000EndedEnded
Year 6£150,000£330,000EndedEnded

Present values at 10% HL

Year Discount factor Present value, Project A Present value, Project B
Year 10.9091£81,819£100,001
Year 20.8264£123,960£82,640
Year 30.7513£135,234£45,078
Year 40.6830£122,940£20,490
Year 50.6209£111,762Ended
Year 60.5645£84,675Ended
Sum of present values£660,390£248,209
Less the capital cost−£600,000−£240,000
Net present value£60,390£8,209

Discount factors from the Business management guide, p. 66. The capital cost is paid now, in year 0, so it is not discounted.

The workings

Payback period

Project A

Given
  • Capital cost (year 0): £600,000
  • Net cash flow, year 1: £90,000
  • Net cash flow, year 2: £150,000
  • Net cash flow, year 3: £180,000
  • Net cash flow, year 4: £180,000
  • Net cash flow, year 5: £180,000
  • Net cash flow, year 6: £150,000
Formula
Payback period = years before the cost is recovered + (amount still to recover ÷ net cash flow in the payback year) × 12 months
Substitution
= 4 years: the cumulative net cash flow reaches zero exactly at the end of year 4
Working
End of year 1: −£600,000 + £90,000 = −£510,000
End of year 2: −£510,000 + £150,000 = −£360,000
End of year 3: −£360,000 + £180,000 = −£180,000
End of year 4: −£180,000 + £180,000 = £0
Answer
4 years
Unit
years and months
Interpretation
Project B pays back first: 2 years and 6 months, against 4 years.
Business implication
The methods disagree: payback prefers Project B; ARR prefers Project A; NPV prefers Project A. That is the judgement to make: speed of recovery against the size of the return.

Project B

Given
  • Capital cost (year 0): £240,000
  • Net cash flow, year 1: £110,000
  • Net cash flow, year 2: £100,000
  • Net cash flow, year 3: £60,000
  • Net cash flow, year 4: £30,000
Formula
Payback period = years before the cost is recovered + (amount still to recover ÷ net cash flow in the payback year) × 12 months
Substitution
= 2 years + (30,000 ÷ 60,000) × 12 months
Working
End of year 1: −£240,000 + £110,000 = −£130,000
End of year 2: −£130,000 + £100,000 = −£30,000
End of year 3: −£30,000 + £60,000 = £30,000
Still to recover at the start of year 3: £30,000
30,000 ÷ 60,000 = 0.5000 of year 3
0.5000 × 12 = 6.00 months
Answer
2 years and 6 months

Assumes the year’s cash arrives evenly through the year. If an answer must be in whole months, round up: the cost is recovered during that month.

Unit
years and months
Interpretation
Project B pays back first: 2 years and 6 months, against 4 years.
Business implication
The methods disagree: payback prefers Project B; ARR prefers Project A; NPV prefers Project A. That is the judgement to make: speed of recovery against the size of the return.
Average rate of return

Project A

Given
  • Capital cost (year 0): £600,000
  • Net cash flow, year 1: £90,000
  • Net cash flow, year 2: £150,000
  • Net cash flow, year 3: £180,000
  • Net cash flow, year 4: £180,000
  • Net cash flow, year 5: £180,000
  • Net cash flow, year 6: £150,000
Formula
ARR = ((total returns − capital cost) ÷ years of use) ÷ capital cost × 100
Substitution
= ((930,000 − 600,000) ÷ 6) ÷ 600,000 × 100
Working
Total returns = 90,000 + 150,000 + 180,000 + 180,000 + 180,000 + 150,000 = 930,000
Total profit = 930,000 − 600,000 = 330,000
Average profit a year = 330,000 ÷ 6 = 55,000.00
55,000.00 ÷ 600,000 × 100 = 9.17
Answer
9.17%
Unit
per cent of the capital cost, per year
Interpretation
Project A has the higher average rate of return: 9.17% a year, against 6.25%.
Business implication
The methods disagree: payback prefers Project B; ARR prefers Project A; NPV prefers Project A. That is the judgement to make: speed of recovery against the size of the return.

Project B

Given
  • Capital cost (year 0): £240,000
  • Net cash flow, year 1: £110,000
  • Net cash flow, year 2: £100,000
  • Net cash flow, year 3: £60,000
  • Net cash flow, year 4: £30,000
Formula
ARR = ((total returns − capital cost) ÷ years of use) ÷ capital cost × 100
Substitution
= ((300,000 − 240,000) ÷ 4) ÷ 240,000 × 100
Working
Total returns = 110,000 + 100,000 + 60,000 + 30,000 = 300,000
Total profit = 300,000 − 240,000 = 60,000
Average profit a year = 60,000 ÷ 4 = 15,000.00
15,000.00 ÷ 240,000 × 100 = 6.25
Answer
6.25%
Unit
per cent of the capital cost, per year
Interpretation
Project A has the higher average rate of return: 9.17% a year, against 6.25%.
Business implication
The methods disagree: payback prefers Project B; ARR prefers Project A; NPV prefers Project A. That is the judgement to make: speed of recovery against the size of the return.
Net present value HL

Project A

Given
  • Capital cost (year 0): £600,000
  • Net cash flow, year 1: £90,000
  • Net cash flow, year 2: £150,000
  • Net cash flow, year 3: £180,000
  • Net cash flow, year 4: £180,000
  • Net cash flow, year 5: £180,000
  • Net cash flow, year 6: £150,000
  • Discount rate: 10%
Formula
NPV = sum of the present values of the returns − original cost
Substitution
= (90,000 × 0.9091 + 150,000 × 0.8264 + 180,000 × 0.7513 + 180,000 × 0.6830 + 180,000 × 0.6209 + 150,000 × 0.5645) − 600,000
Working
Year 1: 90,000 × 0.9091 = 81,819
Year 2: 150,000 × 0.8264 = 123,960
Year 3: 180,000 × 0.7513 = 135,234
Year 4: 180,000 × 0.6830 = 122,940
Year 5: 180,000 × 0.6209 = 111,762
Year 6: 150,000 × 0.5645 = 84,675
Sum of present values = 660,390
660,390 − 600,000 = 60,390
Answer
£60,390

Discount factors at 10% 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 10%, Project A adds more value in today’s money: £60,390, against £8,209 for Project B.
Business implication
The methods disagree: payback prefers Project B; ARR prefers Project A; NPV prefers Project A. That is the judgement to make: speed of recovery against the size of the return.

Project B

Given
  • Capital cost (year 0): £240,000
  • Net cash flow, year 1: £110,000
  • Net cash flow, year 2: £100,000
  • Net cash flow, year 3: £60,000
  • Net cash flow, year 4: £30,000
  • Discount rate: 10%
Formula
NPV = sum of the present values of the returns − original cost
Substitution
= (110,000 × 0.9091 + 100,000 × 0.8264 + 60,000 × 0.7513 + 30,000 × 0.6830) − 240,000
Working
Year 1: 110,000 × 0.9091 = 100,001
Year 2: 100,000 × 0.8264 = 82,640
Year 3: 60,000 × 0.7513 = 45,078
Year 4: 30,000 × 0.6830 = 20,490
Sum of present values = 248,209
248,209 − 240,000 = 8,209
Answer
£8,209

Discount factors at 10% 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 10%, Project A adds more value in today’s money: £60,390, against £8,209 for Project B.
Business implication
The methods disagree: payback prefers Project B; ARR prefers Project A; NPV prefers Project A. That is the judgement to make: speed of recovery against the size of the return.

What the methods leave out

  • Payback ignores everything after the cost is recovered, so Project A's last two years count for nothing. It also treats a pound in year 3 as worth the same as a pound today.
  • The average rate of return ignores timing. A return of £150,000 in year 6 counts for as much as one in year 1.
  • Net present value turns timing into money, but the answer depends on the rate chosen and on estimates that grow less reliable each year. It does not measure risk, except through the rate.
  • None of the three counts what the figures leave out. Project B arrives in time for the peak that decides Lumen Home's contract; Project A removes six jobs from a workforce that is already unsettled.

Think it through

  1. Halden had £17,000 in the bank at 30 June 2026 (see the ratio desk). How should that affect the weight you give to payback?
  2. At which rate in the guide's table does neither project add value? What would choosing that rate say about how risky the owners think the projects are?
  3. Project A removes six packing roles. Which stakeholders would judge that differently from the owners, and how would you include it in a recommendation?
  4. If Halden could afford only one project in 2027, which would you recommend, and on what conditions?

Section 02: The calculations

Each method's formula, a worked example from the case and the errors that cost marks.

Investment appraisal

Payback period

SL and HL Verification: Verified IB 3.8

Formula

Payback period = years before the cost is recovered + (amount still to recover ÷ net cash flow in the payback year) × 12 months

C
Capital cost, paid in year 0 (currency)
R
Net cash flow in each year of use (currency)

Unit. years and months

How long the project takes to return its cost in cash. Quicker payback means less time exposed to risk and earlier cash, which matters most to a business that is short of it.

Worked example: from the case Halden Distribution

Halden Distribution: payback on the pack-and-label line (Project A)

Given
  • Capital cost (year 0): £600,000
  • Net cash flow, year 1: £90,000
  • Net cash flow, year 2: £150,000
  • Net cash flow, year 3: £180,000
  • Net cash flow, year 4: £180,000
  • Net cash flow, year 5: £180,000
  • Net cash flow, year 6: £150,000
Formula
Payback period = years before the cost is recovered + (amount still to recover ÷ net cash flow in the payback year) × 12 months
Substitution
= 4 years: the cumulative net cash flow reaches zero exactly at the end of year 4
Working
End of year 1: −£600,000 + £90,000 = −£510,000
End of year 2: −£510,000 + £150,000 = −£360,000
End of year 3: −£360,000 + £180,000 = −£180,000
End of year 4: −£180,000 + £180,000 = £0
Answer
4 years
Unit
years and months
Interpretation

The line pays for itself in exactly four years, two years before the end of its expected life.

Business implication

Four years is a long wait for a business with £17,000 in the bank, which is why voice picking's faster payback is tempting.

Errors that cost marks
  • Working out the months without assuming the year's cash arrives evenly, or without saying so.
  • Choosing between projects on payback alone, ignoring the returns after payback.

3.8: Payback is in the syllabus (p. 30); the guide's formula sheet gives no formula for it, so the method here is the standard one.

Investment appraisal

Average rate of return (ARR)

SL and HL Verification: Verified IB 3.8

Formula

ARR = ((total returns − capital cost) ÷ years of use) ÷ capital cost × 100

ΣR
Total returns over the project's life (currency)
C
Capital cost (currency)
n
Years of use (years)

Unit. per cent of the capital cost, per year

The average yearly profit from the project as a share of its cost. Compare it with the interest rate on borrowing and with other uses of the money.

Worked example: from the case Halden Distribution

Halden Distribution: ARR on the pack-and-label line (Project A)

Given
  • Capital cost (year 0): £600,000
  • Net cash flow, year 1: £90,000
  • Net cash flow, year 2: £150,000
  • Net cash flow, year 3: £180,000
  • Net cash flow, year 4: £180,000
  • Net cash flow, year 5: £180,000
  • Net cash flow, year 6: £150,000
Formula
ARR = ((total returns − capital cost) ÷ years of use) ÷ capital cost × 100
Substitution
= ((930,000 − 600,000) ÷ 6) ÷ 600,000 × 100
Working
Total returns = 90,000 + 150,000 + 180,000 + 180,000 + 180,000 + 150,000 = 930,000
Total profit = 930,000 − 600,000 = 330,000
Average profit a year = 330,000 ÷ 6 = 55,000.00
55,000.00 ÷ 600,000 × 100 = 9.17
Answer
9.17%
Unit
per cent of the capital cost, per year
Interpretation

On average the line earns 9.17% of its cost a year over its six years.

Business implication

That is above voice picking's 6.25%, but it says nothing about when the money arrives.

Errors that cost marks
  • Dividing total profit by the capital cost without first dividing by the years of use.
  • Using total returns instead of total returns minus the capital cost.

3.8: Formula: guide, p. 65

Investment appraisal

Net present value (NPV)

HL only Verification: Verified IB 3.8

Formula

NPV = sum of the present values of the returns − original cost

R
Net cash flow in each year of use (currency)
DF
Discount factor for the year and the chosen rate, from the guide's table (a number below 1)
C
Original (capital) cost, paid now (currency)

Unit. currency, in today's money

What the project's future returns are worth in today's money, less what it costs now. A positive NPV means the project earns more than the discount rate; the higher the rate, the less later returns count.

Worked example: from the case Halden Distribution

Halden Distribution: NPV of the pack-and-label line at 10% (Project A)

Given
  • Capital cost (year 0): £600,000
  • Net cash flow, year 1: £90,000
  • Net cash flow, year 2: £150,000
  • Net cash flow, year 3: £180,000
  • Net cash flow, year 4: £180,000
  • Net cash flow, year 5: £180,000
  • Net cash flow, year 6: £150,000
  • Discount rate: 10%
Formula
NPV = sum of the present values of the returns − original cost
Substitution
= (90,000 × 0.9091 + 150,000 × 0.8264 + 180,000 × 0.7513 + 180,000 × 0.6830 + 180,000 × 0.6209 + 150,000 × 0.5645) − 600,000
Working
Year 1: 90,000 × 0.9091 = 81,819
Year 2: 150,000 × 0.8264 = 123,960
Year 3: 180,000 × 0.7513 = 135,234
Year 4: 180,000 × 0.6830 = 122,940
Year 5: 180,000 × 0.6209 = 111,762
Year 6: 150,000 × 0.5645 = 84,675
Sum of present values = 660,390
660,390 − 600,000 = 60,390
Answer
£60,390

Discount factors at 10% 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 10%, the line's returns are worth £60,390 more in today's money than its cost.

Business implication

On this test it is worth doing. At 20%, the highest rate in the guide's table, it is not.

Errors that cost marks
  • Discounting the capital cost, which is paid now and is not discounted.
  • Taking a factor from the wrong row (year) or column (rate) of the table.

3.8: HL only. Formula: guide, p. 65; discount factors: guide, p. 66

HL Net present value is HL-only material, hidden while you are viewing SL content. Switch to HL above to see it.

Section 03: The discount table

As printed in the Business management guide, p. 66. A table like it is given in the examination when a question needs it.

Discount factors for years 1 to 10 at 4, 6, 8, 10 and 20 per cent
Year 4%6%8%10%20%
1 0.96150.94340.92590.90910.8333
2 0.92460.89000.85730.82640.6944
3 0.88900.83960.79380.75130.5787
4 0.85480.79210.73500.68300.4823
5 0.82190.74730.68060.62090.4019
6 0.79030.70500.63020.56450.3349
7 0.75990.66510.58350.51320.2791
8 0.73070.62710.54030.46650.2326
9 0.70260.59190.50020.42410.1938
10 0.67560.55840.46320.38550.1615

Each factor is the present value of one unit of money received at the end of that year. Multiply a year's net cash flow by its factor to find its present value. One factor in the guide's table differs from the formula: 6% in year 8 is printed as 0.6271, where 1 ÷ 1.068 gives 0.6274. The platform uses the printed figure, because that is the table an examination provides; check with your teacher if a question uses it.

Back: ratio analysis The Finance Desk