Midrand Compute Distribution Business Plan — Sensitivity and Scenario Analysis
What moves the outcome: exchange rate, gross margin, volume and credit losses, with downside and upside scenarios.
Section 22 of 25
Sensitivity and Scenario Analysis
Jump to section
- 1. Executive Summary
- 2. Investment Thesis
- 3. Company and Business Overview
- 4. The Problem, Customer Need and Value Proposition
- 5. Industry Analysis
- 6. Market Analysis
- 7. Customer Analysis and Segmentation
- 8. Competitive Landscape
- 9. Business Model
- 10. Products and Services
- 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. Investment Case, Valuation and Returns
- 22. Sensitivity and Scenario Analysis
- 23. KPIs and Management Dashboard
- 24. Conclusion
- 25. Appendix: Detailed Financial Statements
Gross margin and volume decide the outcome; interest rates and FX matter, but less. The model is most exposed to the variables management most directly controls.
Scenario construction
- Base: the considered central case, 37% revenue CAGR, blended margin ~19%, disciplined working capital.
- Downside (individually plausible): ~10% lower volumes, a slower ramp, ~1.2pts lower margin and mild working-capital drag. Survivable within the committed facility, but returns compress to ~6% IRR and facility utilisation reaches ~90%.
- Stress (severe tail): demand, margin, rate and working-capital shocks combined. The facility is exhausted, a residual funding gap of ~R25–30m emerges, and equity is fully impaired, the case the standby equity contingency exists to address.
- Upside: stronger demand and attach, better margin and tighter working capital, Year-5 EBITDA of R68m and an IRR near 59%.
Management implication. Because gross margin and volume dominate, management effort is rightly concentrated on mix discipline (defending margin) and channel execution (defending volume). FX and rates, while material, are managed through hedging and facility structuring rather than through the operating plan.
Single-variable sensitivity — Year-5 EBITDA
Holding all else at base, the table isolates the effect of moving each key driver one increment in each direction. It shows both what the business is most exposed to and how much cushion the base case carries.
|
Variable |
Downside move |
Y5 EBITDA impact |
Upside move |
|---|---|---|---|
|
Gross margin (±1.0 pt) |
−1.0 pt |
∓ ~R5m |
+1.0 pt |
|
Sales volume (±10%) |
−10% |
∓ ~R10m |
+10% |
|
Operating costs (±5%) |
+5% |
∓ ~R3m |
−5% |
|
USD/ZAR (±10%, unhedged portion) |
+10% |
∓ ~R4m |
−10% |
Table 36. Single-variable sensitivity on Year-5 EBITDA (base ~R41m). Margin and volume are the dominant levers.