Advanced financial analysis · Beyond the IB course

Capital budgeting comparator

Which project adds most value, and how much do the answers depend on the estimates and the discount rate?

Back to 3.8 Investment appraisal

  • Beyond the IB course
  • Builds on IB 3.8
  • Undergraduate, MBA, professional and teacher
  • Simulated data Example: Emberly Roasters, fictional

The comparator

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

Project 1

Net cash flow each year

Project 2

Net cash flow each year

Project 3

Net cash flow each year

Discount rate
The weighted average cost of capital
The return on government bonds, for example.
How much the shares move with the market; 1 is the market’s own risk.
The extra return investors expect from shares over the risk-free rate.
Sensitivity
Currency

Emberly Roasters’s figures are in dollars.

The figures

Project 1
Nitrogen-flush packaging line
Nitrogen-flush packaging line: initial investment
$120,000
Nitrogen-flush packaging line: year 1
$22,000
Nitrogen-flush packaging line: year 2
$30,000
Nitrogen-flush packaging line: year 3
$36,000
Nitrogen-flush packaging line: year 4
$38,000
Nitrogen-flush packaging line: year 5
$34,000
Project 2
Second roaster for supermarket orders
Second roaster for supermarket orders: initial investment
$180,000
Second roaster for supermarket orders: year 1
$36,000
Second roaster for supermarket orders: year 2
$38,000
Second roaster for supermarket orders: year 3
$40,000
Second roaster for supermarket orders: year 4
$42,000
Second roaster for supermarket orders: year 5
$44,000
Second roaster for supermarket orders: year 6
$44,000
Second roaster for supermarket orders: year 7
$44,000
Second roaster for supermarket orders: year 8
$44,000
Project 3
Café kiosk at the roastery
Café kiosk at the roastery: initial investment
$45,000
Café kiosk at the roastery: year 1
$28,000
Café kiosk at the roastery: year 2
$25,000
Café kiosk at the roastery: year 3
$14,000
Discount rate
8.625% (the WACC worked out below)
Risk-free rate
4%
Beta
1.20
Market risk premium
5%
Cost of debt, before tax
6%
Tax rate
25%
Market value of equity
$600,000
Market value of debt
$200,000
Tornado: each estimate moved by
10%

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

Your figures are kept in this browser once you change them. Nothing is sent anywhere.

Result

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

Highest net present value at 8.625%

$49,956

Second roaster for supermarket orders

Discount rate Beyond the IB course
8.625%the WACC worked out below
Highest IRR Beyond the IB course
25.95%Café kiosk at the roastery
Quickest payback IB
1.68 yearsCafé kiosk at the roastery
Highest profitability index Beyond the IB course
1.286Café kiosk at the roastery
Do the methods agree?
NoNPV prefers Second roaster for supermarket orders; IRR Café kiosk at the roastery, payback Café kiosk at the roastery, PI Café kiosk at the roastery

Section 01: The discount rate

The weighted average cost of capital, with the cost of equity by the capital asset pricing model, in eight parts.

Given
  • Risk-free rate: 4%
  • Beta: 1.20
  • Market risk premium: 5%
  • Cost of debt, before tax: 6%
  • Tax rate: 25%
  • Market value of equity (E): $600,000
  • Market value of debt (D): $200,000
Formula
WACC = E ÷ (D + E) × cost of equity + D ÷ (D + E) × cost of debt × (1 − tax rate), where cost of equity = risk-free rate + beta × market risk premium
Substitution
= 75.00% × 10% + 25.00% × 6% × (1 − 0.25)
Working
Cost of equity = 4% + 1.20 × 5% = 10%
Cost of debt after tax = 6% × (1 − 0.25) = 4.5%
Weights: E ÷ (D + E) = 600,000 ÷ 800,000 = 75.00%; D ÷ (D + E) = 25.00%
WACC = 75.00% × 10% + 25.00% × 4.5% = 8.625%
Answer
8.625%

The cost of equity by the capital asset pricing model (Sharpe, 1964); market-value weights.

Unit
per cent a year
Interpretation
The business must earn 8.625% a year on a project of ordinary risk to satisfy its lenders and its owners together.
Business implication
This is the discount rate every project below is worked at.

Section 02: Every method, side by side

The IB’s methods and the ones beyond the course, for every project at the same discount rate.

Every method, every project, at a discount rate of 8.625%
MethodStandingNitrogen-flush packaging lineSecond roaster for supermarket ordersCafé kiosk at the roastery
Initial investmentIB$120,000$180,000$45,000
LifeIB5 years8 years3 years
Total net cash flow, undiscountedIB$160,000$332,000$67,000
Payback periodIB3.84 years4.55 years1.68 years
Average rate of return (ARR)IB6.67%10.56%16.30%
Net present value at 8.625%Beyond the IB course$3,541$49,956$12,887
Internal rate of return (IRR)Beyond the IB course9.67%15.35%25.95%
Discounted payback at 8.625%Beyond the IB course4.84 years5.90 years1.91 years
Profitability index (PV ÷ investment)Beyond the IB course1.0301.2781.286

Net present value itself is in the HL course (3.8), worked with the guide’s table of discount factors at 4, 6, 8, 10 and 20%. Here it is worked from the formula at any rate, which goes beyond the course; the Financial Laboratory’s NPV calculator works it the IB way.

Which project each method puts first

Which project each method puts first
MethodOrder, best first
Net present value1. Second roaster for supermarket orders; 2. Café kiosk at the roastery; 3. Nitrogen-flush packaging line
Internal rate of return (single rates only)1. Café kiosk at the roastery; 2. Second roaster for supermarket orders; 3. Nitrogen-flush packaging line
Profitability index1. Café kiosk at the roastery; 2. Second roaster for supermarket orders; 3. Nitrogen-flush packaging line
Payback period1. Café kiosk at the roastery; 2. Nitrogen-flush packaging line; 3. Second roaster for supermarket orders
Discounted payback1. Café kiosk at the roastery; 2. Nitrogen-flush packaging line; 3. Second roaster for supermarket orders
Average rate of return (IB)1. Café kiosk at the roastery; 2. Second roaster for supermarket orders; 3. Nitrogen-flush packaging line

Section 03: Net present value at every rate

Each project’s NPV as the discount rate rises, and its internal rate of return where the line crosses zero.

Net present value at each discount rateNitrogen-flush packaging line: NPV $3,541 at 8.625%, NPV is zero at 9.67%. Second roaster for supermarket orders: NPV $49,956 at 8.625%, NPV is zero at 15.35%. Café kiosk at the roastery: NPV $12,887 at 8.625%, NPV is zero at 25.95%. NPV falls as the rate rises for a project whose cash comes after its cost.Nitrogen-flush packaging lineSecond roaster for supermarket ordersCafé kiosk at the roastery−$100k−$50k$0$50k$100k$150k$200k0%10%20%30%40%Discount rate 8.625%Nitrogen-flush packaging lineNitrogen-flush packaging line: internal rate of return 9.67%Nitrogen-flush packaging line: NPV $3,541 at 8.625%Second roaster for supermarket ordersSecond roaster for supermarket orders: internal rate of return 15.35%Second roaster for supermarket orders: NPV $49,956 at 8.625%Café kiosk at the roasteryCafé kiosk at the roastery: internal rate of return 25.95%Café kiosk at the roastery: NPV $12,887 at 8.625%Discount rate (diamonds: where NPV is zero, the internal rate of return)
Chart NPV of each project at rates from 0% to 40%. Where a line crosses zero is that project’s internal rate of return; the dashed upright line is the discount rate in use. Lines that cross each other show that the ranking by NPV depends on the rate.
The chart’s figures as a table
NPV at a range of discount rates
Discount rateNitrogen-flush packaging lineSecond roaster for supermarket ordersCafé kiosk at the roastery
0%$40,000$152,000$22,000
5%$17,164$86,219$16,436
8.625% (the figures as entered)$3,541$49,956$12,887
10%−$1,093$38,134$11,634
15%−$15,884$2,175$7,457
20%−$28,011−$25,278$3,796
25%−$38,062−$46,635$568
30%−$46,477−$63,538−$2,296

The internal rate of return, project by project

  • Nitrogen-flush packaging line: the cash flows change sign once, so there is exactly one internal rate of return, 9.67%. It is above the discount rate of 8.625%, which agrees with an NPV above zero.
  • Second roaster for supermarket orders: the cash flows change sign once, so there is exactly one internal rate of return, 15.35%. It is above the discount rate of 8.625%, which agrees with an NPV above zero.
  • Café kiosk at the roastery: the cash flows change sign once, so there is exactly one internal rate of return, 25.95%. It is above the discount rate of 8.625%, which agrees with an NPV above zero.

Section 04: What moves the NPV

A tornado: one estimate at a time moved down and up, its effect on NPV, the widest bar first.

What moves the NPV of Second roaster for supermarket ordersNPV as entered $49,956. Yearly cash flows: every year 10% lower $26,961, every year 10% higher $72,952; Life of the project: one year shorter $27,257, one year longer $70,853; Initial investment: 10% lower $67,956, 10% higher $31,956; Discount rate: 10% lower (7.76%) $57,877, 10% higher (9.49%) $42,430. The widest bar is the estimate that matters most.$0$20k$40k$60k$80kThe estimate lowerThe estimate higherYearly cash flowsYearly cash flows, every year 10% lower: NPV $26,961Yearly cash flows, every year 10% higher: NPV $72,952$27.0k$73.0kLife of the projectLife of the project, one year shorter: NPV $27,257Life of the project, one year longer: NPV $70,853$27.3k$70.9kInitial investmentInitial investment, 10% lower: NPV $67,956Initial investment, 10% higher: NPV $31,956$32.0k$68.0kDiscount rateDiscount rate, 10% lower (7.76%): NPV $57,877Discount rate, 10% higher (9.49%): NPV $42,430$42.4k$57.9kAs entered $49,956Net present value
Chart Each estimate moved 10% down (grey) and up (blue), one at a time, the rest as entered; the life moves by a year. The widest bar is the estimate the decision depends on most.
The chart’s figures as a table
Second roaster for supermarket orders: NPV when one estimate moves
EstimateLowerNPVHigherNPVSwing
Yearly cash flowsevery year 10% lower$26,961every year 10% higher$72,952$45,991
Life of the projectone year shorter$27,257one year longer$70,853$43,596
Initial investment10% lower$67,95610% higher$31,956$36,000
Discount rate10% lower (7.76%)$57,87710% higher (9.49%)$42,430$15,447

Reading. The NPV of Second roaster for supermarket orders, $49,956, depends most on the yearly cash flows: every year 10% lower, it would be $26,961; every year 10% higher, $72,952. It stays positive unless every year’s cash flow falls by more than 21.7%, or the investment rises by more than 27.8%. A tornado moves one estimate at a time; in practice estimates move together, which scenario analysis tests.

Section 05: What it means

For the figures above: the reading, then where each method stops.

The reading

At 8.625%, Second roaster for supermarket orders adds the most value: an NPV of $49,956. Every project is worth more than it costs at this rate.

The methods disagree. The internal rate of return (Café kiosk at the roastery, 25.95%), the profitability index (Café kiosk at the roastery, 1.286), payback (Café kiosk at the roastery, 1.68 years) put another project first. They answer different questions: NPV measures the value added in money; the IRR and the profitability index measure the return per unit of money invested, so they favour small, quick projects; payback measures only how fast the money comes back. When the projects are alternatives and money can be found for the best, choose the highest NPV.

If money is limited and projects can be scaled down, the profitability index ranks them by value per unit of money: Café kiosk at the roastery gives 1.286 of present value for each unit invested. With projects that cannot be split, compare the total NPV of the combinations the budget allows instead.

The IB’s average rate of return prefers Café kiosk at the roastery: it counts every year’s cash equally, however late it comes.

Where each method stops

  • Net present value is only as good as the cash flow estimates and the discount rate, and it assumes the money can be raised at that rate.
  • The internal rate of return ranks by return, not by size, so it favours small, quick projects; it can be more than one rate, or none, when cash flows change sign more than once.
  • Payback and discounted payback ignore every cash flow after the money is recovered, so they say nothing about how much a project adds in the end.
  • The profitability index helps when money is short and projects can be scaled down; when they cannot, compare the total NPV of the combinations the budget allows. Some textbooks define it as NPV ÷ investment instead, which is this figure less 1 and ranks projects the same way.
  • The WACC is the right rate only for a project as risky as the business’s existing assets and paid for in the same mix of debt and equity. Its inputs are estimates; for a business without listed shares, beta is usually taken from similar listed businesses.
  • The tornado moves one estimate at a time. In practice estimates move together, which the integrated forecast’s scenarios test.

Section 06: The working for each project

The net present value in eight parts, and every year’s cash flow, discount factor and running totals.

Nitrogen-flush packaging line: the working
Given
  • Initial investment: $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.625%
Formula
NPV = −initial investment + Σ net cash flow in year t ÷ (1 + r)^t
Substitution
= −120,000 + 22,000 ÷ 1.08625^1 + 30,000 ÷ 1.08625^2 + 36,000 ÷ 1.08625^3 + 38,000 ÷ 1.08625^4 + 34,000 ÷ 1.08625^5
Working
Year 1: 22,000 × 0.920598 = 20,253.16
Year 2: 30,000 × 0.847501 = 25,425.04
Year 3: 36,000 × 0.780208 = 28,087.50
Year 4: 38,000 × 0.718259 = 27,293.83
Year 5: 34,000 × 0.661228 = 22,481.74
Present value of the cash flows = 123,541.28
123,541.28 − 120,000 = 3,541.28
Answer
$3,541.28

Discount factors from the formula, to six places; the IB’s table prints four places at five rates, so its answers differ slightly.

Unit
$, in today’s money
Interpretation
At 8.625%, the cash flows are worth $123,541.28 today, $3,541.28 more than the investment.
Business implication
On NPV alone the project adds value at this rate.
Nitrogen-flush packaging line: cash flows and present values at 8.625%
YearNet cash flowDiscount factorPresent valueCumulativeCumulative present value
Year 0−$120,0001.0000−$120,000.00−$120,000−$120,000.00
Year 1$22,0000.9206$20,253.16−$98,000−$99,746.84
Year 2$30,0000.8475$25,425.04−$68,000−$74,321.79
Year 3$36,0000.7802$28,087.50−$32,000−$46,234.29
Year 4$38,0000.7183$27,293.83$6,000−$18,940.46
Year 5$34,0000.6612$22,481.74$40,000$3,541.28
Second roaster for supermarket orders: the working
Given
  • Initial investment: $180,000
  • Net cash flow, year 1: $36,000
  • Net cash flow, year 2: $38,000
  • Net cash flow, year 3: $40,000
  • Net cash flow, year 4: $42,000
  • Net cash flow, year 5: $44,000
  • Net cash flow, year 6: $44,000
  • Net cash flow, year 7: $44,000
  • Net cash flow, year 8: $44,000
  • Discount rate: 8.625%
Formula
NPV = −initial investment + Σ net cash flow in year t ÷ (1 + r)^t
Substitution
= −180,000 + 36,000 ÷ 1.08625^1 + 38,000 ÷ 1.08625^2 + 40,000 ÷ 1.08625^3 + 42,000 ÷ 1.08625^4 + 44,000 ÷ 1.08625^5 + 44,000 ÷ 1.08625^6 + 44,000 ÷ 1.08625^7 + 44,000 ÷ 1.08625^8
Working
Year 1: 36,000 × 0.920598 = 33,141.54
Year 2: 38,000 × 0.847501 = 32,205.05
Year 3: 40,000 × 0.780208 = 31,208.34
Year 4: 42,000 × 0.718259 = 30,166.86
Year 5: 44,000 × 0.661228 = 29,094.02
Year 6: 44,000 × 0.608725 = 26,783.91
Year 7: 44,000 × 0.560391 = 24,657.22
Year 8: 44,000 × 0.515895 = 22,699.40
Present value of the cash flows = 229,956.34
229,956.34 − 180,000 = 49,956.34
Answer
$49,956.34

Discount factors from the formula, to six places; the IB’s table prints four places at five rates, so its answers differ slightly.

Unit
$, in today’s money
Interpretation
At 8.625%, the cash flows are worth $229,956.34 today, $49,956.34 more than the investment.
Business implication
On NPV alone the project adds value at this rate.
Second roaster for supermarket orders: cash flows and present values at 8.625%
YearNet cash flowDiscount factorPresent valueCumulativeCumulative present value
Year 0−$180,0001.0000−$180,000.00−$180,000−$180,000.00
Year 1$36,0000.9206$33,141.54−$144,000−$146,858.46
Year 2$38,0000.8475$32,205.05−$106,000−$114,653.41
Year 3$40,0000.7802$31,208.34−$66,000−$83,445.07
Year 4$42,0000.7183$30,166.86−$24,000−$53,278.21
Year 5$44,0000.6612$29,094.02$20,000−$24,184.19
Year 6$44,0000.6087$26,783.91$64,000$2,599.72
Year 7$44,0000.5604$24,657.22$108,000$27,256.94
Year 8$44,0000.5159$22,699.40$152,000$49,956.34
Café kiosk at the roastery: the working
Given
  • Initial investment: $45,000
  • Net cash flow, year 1: $28,000
  • Net cash flow, year 2: $25,000
  • Net cash flow, year 3: $14,000
  • Discount rate: 8.625%
Formula
NPV = −initial investment + Σ net cash flow in year t ÷ (1 + r)^t
Substitution
= −45,000 + 28,000 ÷ 1.08625^1 + 25,000 ÷ 1.08625^2 + 14,000 ÷ 1.08625^3
Working
Year 1: 28,000 × 0.920598 = 25,776.75
Year 2: 25,000 × 0.847501 = 21,187.53
Year 3: 14,000 × 0.780208 = 10,922.92
Present value of the cash flows = 57,887.21
57,887.21 − 45,000 = 12,887.21
Answer
$12,887.21

Discount factors from the formula, to six places; the IB’s table prints four places at five rates, so its answers differ slightly.

Unit
$, in today’s money
Interpretation
At 8.625%, the cash flows are worth $57,887.21 today, $12,887.21 more than the investment.
Business implication
On NPV alone the project adds value at this rate.
Café kiosk at the roastery: cash flows and present values at 8.625%
YearNet cash flowDiscount factorPresent valueCumulativeCumulative present value
Year 0−$45,0001.0000−$45,000.00−$45,000−$45,000.00
Year 1$28,0000.9206$25,776.75−$17,000−$19,223.25
Year 2$25,0000.8475$21,187.53$8,000$1,964.29
Year 3$14,0000.7802$10,922.92$22,000$12,887.21

Section 07: Where the IB course stops

What this tool takes from the IB course, and what it adds beyond it.

IB What the IB course uses

  • 3.8 Investment appraisal SL and HL Investment appraisal by the payback period and the average rate of return (ARR). Guide, p. 30; ARR on the formula sheet, p. 65
  • 3.8 Investment appraisal HL only Net present value, worked with the guide’s table of discount factors at 4, 6, 8, 10 and 20%. Guide, p. 30; formula sheet p. 65; discount table p. 66

Beyond the IB course What this tool adds

  • Net present value at any discount rate, from the formula 1 ÷ (1 + r)^t rather than the guide’s table.
  • The internal rate of return, found by a search that cannot fail to converge, with its limits when cash flows change sign more than once.
  • Discounted payback and the profitability index.
  • Sensitivity analysis shown as a tornado chart, and the change in each estimate that would bring NPV to zero.
  • The weighted average cost of capital, with the cost of equity by the capital asset pricing model.

The course’s content is described in the platform’s words from the Business management guide (first assessment 2024), checked against the guide on 29 October 2026; see the claims register. The formulas the guide gives are on the formula sheet. Nothing on this page is an IB method unless it is marked IB, and no question here is an IB question.

Section 08: Sources

The method rests on standard references, cited here and in the source register. They were not opened for this release; the explanations are the platform’s own.

Section 09: The IB parts, worked on their own

The Financial Laboratory and the Finance Desk work the parts the IB course uses, with the guide’s formulas and layouts.