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
- 0. Basis of Preparation and Important Notice
- 1. Executive Summary
- 2. Investment Thesis
- 3. What Must Be True, and What Would Break the Thesis
- 4. Company, Structure and Governance
- 5. The Customer Problem and the Value Proposition
- 6. Service Portfolio, Pricing and Contribution
- 7. Industry Structure and Profitability
- 8. Market Sizing and the Addressable Opportunity
- 9. Customer Segments and Buying Behaviour
- 10. Competitive Landscape
- 11. Business Model and Revenue Architecture
- 12. Channel Economics: Where the Capital Should Go
- 13. Go-to-Market Strategy
- 14. Operating Model
- 15. People and Organisation
- 16. Strategic Plan
- 17. SWOT and Strategic Implications
- 18. Risk Analysis
- 19. ESG, Transformation and Development Impact
- 20. Implementation Roadmap
- 21. Financial Assumptions
- 22. Cost Structure and Operating Leverage
- 23. Projected Income Statement
- 24. Projected Balance Sheet
- 25. Projected Cash Flow
- 26. Capital Expenditure
- 27. Funding Requirement and Structure
- 28. Debt Serviceability
- 29. Break-even Analysis
- 30. Valuation and Investor Returns
- 31. Sensitivity and Scenario Analysis
- 32. Key Performance Indicators and Management Dashboard
- 33. Exit Strategy
- 34. Conclusion and Recommendation
- A. Appendix A: Detailed Assumptions Register
- B. Appendix B: Roll-out Schedule
- C. Appendix C: Model Integrity Verification
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.
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 |
Sensitivity to individual 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
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.