Centurion Motor Exchange Business Plan — Sensitivity and Scenario Analysis
What moves the outcome: units sold, gross per unit, days to sell and floor-plan cost, with scenarios.
Section 23 of 28
Sensitivity and Scenario Analysis
Jump to section
- 1. Executive Summary
- 2. Investment Thesis
- 3. Company Overview
- 4. Problem, Customer Need and Value Proposition
- 5. Products and Services
- 6. Industry Analysis
- 7. Market Analysis
- 8. Customer Analysis
- 9. Competitive Landscape
- 10. Business Model
- 11. Go-to-Market Strategy
- 12. Operating Model
- 13. Management and Organisation
- 14. Strategic Plan
- 15. SWOT Analysis
- 16. Risk Analysis
- 17. ESG and Sustainability
- 18. Implementation Roadmap
- 19. Financial Plan
- 20. Funding Requirement and Structure
- 21. Debt Serviceability
- 22. Investment Case and Valuation
- 23. Sensitivity and Scenario Analysis
- 24. KPIs and Management Dashboard
- 25. Conclusion
- A. Appendix A: Scenario Parameters
- B. Appendix B: Year-1 Monthly Projections
- C. Appendix C: Sources and Glossary
The downside is survivable on one site; opening Site 2 regardless would not be
Table 23.1: Scenario definitions
|
Driver |
Downside (gated) |
Base |
Upside |
Stress (ungated) |
|---|---|---|---|---|
|
Retail volume vs plan |
–10% |
Plan |
+10% |
–10% |
|
Trading spread |
13.0% |
14.0% |
14.75% |
13.0% |
|
Average selling price (FY28, ex VAT) |
R245,000 |
R245,000 |
R250,000 |
R245,000 |
|
Stock days |
52 |
45 |
40 |
52 |
|
Finance penetration |
58% |
65% |
70% |
58% |
|
Fixed costs |
+3% |
Plan |
Plan |
+3% |
|
Interest rates |
+50bp |
Prime 10.50% |
Prime 10.50% |
+50bp |
|
Site 2 and Tranche B |
Not opened / not drawn |
Opened Mar 2029 |
Opened Mar 2029 |
Opened regardless |
|
Head office payroll |
Cut to R1.5m (management response) |
R2.4m |
R2.4m |
R2.4m |
Each downside driver is individually plausible; the case does not stack worst-case outcomes. The stress case isolates the effect of expanding into a weak market.
Table 23.2: Scenario results
|
Output |
Downside (gated) |
Base |
Upside |
Stress (ungated) |
|---|---|---|---|---|
|
FY32 retail units |
708 |
1,465 |
1,611 |
1,318 |
|
FY32 revenue |
R228.7m |
R473.7m |
R531.1m |
R425.9m |
|
FY32 EBITDA |
R2.7m |
R15.4m |
R25.8m |
R5.0m |
|
Cumulative net profit FY28–FY32 |
(R9.6m) |
R13.6m |
R39.2m |
(R22.2m) |
|
FY32 closing cash / (overdraft) |
(R4.7m) |
R19.3m |
R46.6m |
(R19.2m) |
|
Minimum operating DSCR, FY29–FY32 |
0.52x |
1.96x |
3.97x |
neg. |
|
Peak overdraft (limit R4.0m) |
R4.7m |
Not used |
Not used |
R19.2m |
|
First month overdraft exceeds limit |
Month 56 |
Never |
Never |
Month 26 |
|
Equity invested by Investor |
R12m |
R24m |
R24m |
R24m |
|
Exit equity value (5.0x) |
R8.9m |
R95.6m |
R174.9m |
R5.2m |
|
Investor MOIC |
0.30x |
1.99x |
3.64x |
0.11x |
|
Investor IRR |
(21.6%) |
18.0% |
35.9% |
(43.8%) |
What the downside and stress cases show
In the downside, management declines to open Site 2 and cuts head-office cost. Site 1 remains EBITDA-positive from FY29 but earns only R2.7m by FY32, net profit stays negative until FY32, and the operating DSCR is between 0.52x and 0.92x, a breach in every tested year. The overdraft is first drawn in FY30 and exceeds its R4m limit in month 56, peaking at R4.7m. The Investor recovers 0.30x of Tranche A. The business survives, but only with lender forbearance or a further R3–5m of equity.
In the stress case the same trading conditions apply but Site 2 is opened anyway. The overdraft limit is breached in month 26, within two months of Site 2’s launch, and the funding gap peaks at R19.2m. Equity falls to R7.8m by FY32 and the Investor recovers 0.11x. This is the clearest quantitative argument for the Tranche B gate.
Volume and trading spread are the value drivers; financing terms are second-order
Table 23.3: Single-variable sensitivities
|
Variable (adverse / favourable) |
FY32 EBITDA |
Investor IRR |
Min op. DSCR |
Lowest liquidity* |
|---|---|---|---|---|
|
Retail volume ±10% |
R10.9m / R19.9m |
6.1% / 26.6% |
1.02x / 2.87x |
(R2.1m) |
|
Trading spread ±1.0pp |
R11.1m / R19.7m |
5.7% / 26.7% |
1.05x / 2.84x |
(R3.7m) |
|
Average selling price ±5% |
R12.5m / R18.3m |
10.9% / 23.9% |
1.35x / 2.56x |
(R0.7m) |
|
Finance penetration ±10pp |
R14.8m / R16.0m |
16.7% / 19.4% |
1.83x / 2.09x |
R1.3m |
|
Fixed costs ±10% |
R13.0m / R17.8m |
11.7% / 23.3% |
1.35x / 2.55x |
(R1.8m) |
|
Stock days ±10 days |
R14.4m / R16.4m |
14.8% / 20.9% |
1.74x / 2.16x |
(R0.8m) |
|
Interest rates ±200bp |
R14.6m / R16.2m |
16.1% / 19.8% |
1.73x / 2.21x |
R0.7m |
|
Exit multiple ±1.0x |
R15.4m / R15.4m |
13.2% / 22.3% |
1.96x / 1.96x |
R1.9m |
|
Recon cost per unit ±20% |
R13.1m / R17.7m |
12.4% / 22.9% |
1.48x / 2.44x |
(R0.5m) |
* Lowest month-end cash less peak overdraft in the adverse case. Base case: FY32 EBITDA R15.4m; IRR 18.0%; minimum DSCR 1.96x.
The table also shows how little room the base case has. On its own, a 10% volume shortfall or a one-point fall in trading spread takes the minimum operating DSCR to about 1.02x, below the 1.30x covenant, and pushes the business into its overdraft, even with Site 2 opened on schedule. These are the two variables the Tranche B milestones are designed to test before further capital is committed.
Table 23.4: FY32 EBITDA by volume and trading spread (R million)
|
Volume vs plan \ spread |
12% |
13% |
14% |
15% |
16% |
|---|---|---|---|---|---|
|
80% |
(0.6) |
2.9 |
6.4 |
9.8 |
13.3 |
|
90% |
3.1 |
7.0 |
10.9 |
14.8 |
18.7 |
|
100% |
6.7 |
11.1 |
15.4 |
19.7 |
24.1 |
|
110% |
10.4 |
15.1 |
19.9 |
24.7 |
29.4 |
|
120% |
14.0 |
19.2 |
24.4 |
29.6 |
34.8 |
Table 23.5: Interest-rate stress
|
Prime rate shock |
FY32 EBITDA |
FY32 net profit |
Minimum operating DSCR |
|---|---|---|---|
|
Base |
R15.4m |
R8.5m |
1.96x |
|
+100bp |
R15.0m |
R8.2m |
1.84x |
|
+200bp |
R14.6m |
R7.9m |
1.73x |
|
+300bp |
R14.3m |
R7.6m |
1.62x |