Highveld Detailing Business Plan — Sensitivity and Scenario Analysis

What moves FY32 EBITDA: vehicle volume, pricing, labour cost and site ramp, with scenarios.

Section 32 of 38

Sensitivity and Scenario Analysis

Jump to section

This is the most informative section in the document. The base case is one point in a wide and asymmetric distribution, and the analysis below maps that distribution rather than defending the central estimate.

Scenario definitions

Table 59. Scenario assumptions

Driver

Stress

Downside

Base

Upside

Capacity utilisation

80%

90%

100%

109%

Retail pricing

94%

97%

100%

100%

Contract pricing

95.5%

98%

100%

100%

Consumable and film cost

107%

104%

100%

100%

Direct labour cost

104.5%

102%

100%

100%

Marketing intensity

112%

106%

100%

100%

Exit EBITDA multiple

4.5x

5.5x

6.5x

7.5x

Management mitigating action assumed

None

None

n/a

None

Neither adverse case assumes any management response. In practice a management team facing a ten per cent throughput shortfall would slow mobilisation, defer the second studio and reduce head office. The downside case as modelled is therefore more severe than the realistic outcome, which is deliberate.

Revenue and EBITDA by scenario
Figure 1. Revenue and EBITDA by scenario

Table 60. Scenario outcomes

Stress

Downside

Base

Upside

FY2032 revenue

R67.7m

R78.3m

R89.0m

R99.3m

FY2032 EBITDA

R-4.7m

R2.7m

R10.2m

R17.0m

FY2032 EBITDA margin

-6.9%

3.5%

11.4%

17.1%

Exit multiple applied

4.5x

5.5x

6.5x

7.5x

Equity value at exit

R-70.9m

R-10.2m

R64.9m

R143.1m

Money multiple

-2.95x

-0.43x

2.70x

5.96x

Project IRR

not meaningful

-26.7%

33.4%

68.1%

Additional funding required

R42.5m

R17.8m

None

None

Equity value at exit and additional funding by scenario
Figure 2. Equity value at exit and additional funding by scenario

Sensitivity to individual drivers

Enterprise value sensitivity to key drivers
Figure 3. Enterprise value sensitivity to key drivers

Table 61. Enterprise value sensitivity to individual drivers (R million)

Driver

Adverse

Base

Favourable

Swing

B2B contract pricing

-8.0

12.6

33.2

41.3

Capacity utilisation

-8.5

12.6

30.0

38.4

Direct labour cost

-5.8

12.6

31.0

36.8

Consumable & film cost

3.8

12.6

21.4

17.6

Retail pricing

5.3

12.6

19.9

14.6

Exit EBITDA multiple

5.5

12.6

19.7

14.3

Marketing intensity

9.4

12.6

15.3

5.9

Each driver is flexed independently: pricing by 10%, utilisation by 12.5%, labour cost by 10%, consumables by 15%, exit multiple between 5.0 and 8.0 times, and marketing intensity by 25%. Base enterprise value is R12.6m.

Three of the seven drivers swing enterprise value by more than three times the base-case valuation itself. That is a direct consequence of a thin margin: small proportional movements in revenue or cost produce large proportional movements in EBITDA, which the terminal multiple then amplifies. The practical implication for management is that contract price negotiation and throughput discipline are worth more than any cost-saving initiative available to them.

Two-way sensitivity

Enterprise value by utilisation and exit multiple
Figure 4. Enterprise value by utilisation and exit multiple

Table 62. Enterprise value by utilisation and exit multiple (R million)

Utilisation ↓ / Exit multiple →

5.00x

5.75x

6.50x

7.25x

8.00x

85.0%

-16.5

-15.1

-13.8

-12.5

-11.2

92.5%

-5.4

-3.0

-0.5

1.9

4.4

100.0%

5.5

9.0

12.6

16.2

19.7

107.5%

16.3

21.0

25.6

30.3

35.0

115.0%

27.0

32.8

38.6

44.3

50.1

Table 63. Project internal rate of return by utilisation and exit multiple

Utilisation ↓ / Exit multiple →

5.00x

5.75x

6.50x

7.25x

8.00x

85.0%

-17.4%

-13.4%

-9.8%

-6.4%

-3.3%

92.5%

7.2%

11.6%

15.6%

19.2%

22.6%

100.0%

24.5%

29.2%

33.4%

37.3%

41.0%

107.5%

38.5%

43.4%

47.9%

52.0%

55.8%

115.0%

50.6%

55.7%

60.3%

64.6%

68.7%

Values below the 16.4% cost of capital are shown in red. The entire 85% and 92.5% utilisation rows fail to clear the hurdle at any exit multiple within the tested range, which is the clearest single statement of where the risk in this investment sits.