Section 20 · Business Plan
Scenario Analysis & Stress Testing
To provide investors with a comprehensive understanding of the risk–return profile, three scenarios are presented: a downside case reflecting adverse market conditions, the base case used throughout this plan, and an upside case reflecting favourable dynamics and accelerated execution.
To provide investors with a comprehensive understanding of the risk–return profile, three scenarios are presented: a downside case reflecting adverse market conditions, the base case used throughout this plan, and an upside case reflecting favourable dynamics and accelerated execution.
20.1 Scenario Definitions
| Parameter | Downside | Base Case | Upside |
|---|---|---|---|
| Year 1 Revenue | R 4,320,000 (-20%) | R 5,400,000 | R 6,480,000 (+20%) |
| Annual Growth (Yr 2–5) | 8% | 15–20% | 20–25% |
| Blended Gross Margin | 22% | 25–28% | 28–30% |
| Shrinkage Rate | 2.5% | 1.5% | 1.0% |
| Break-Even Month | Month 12–14 | Month 7–9 | Month 4–5 |
20.2 Five-Year Net Profit by Scenario
| Year | Downside (R) | Base Case (R) | Upside (R) |
|---|---|---|---|
| Year 1 | (380,000) | (135,150) | 95,000 |
| Year 2 | (120,000) | 22,557 | 280,000 |
| Year 3 | 50,000 | 230,505 | 520,000 |
| Year 4 | 180,000 | 373,018 | 780,000 |
| Year 5 | 270,000 | 454,643 | 1,050,000 |
| 5-Year Cumulative | 0 | 945,573 | 2,725,000 |
| Payback Period | ~60 months | ~30–36 months | ~18 months |
| 5-Year IRR | 0–2% | 18–22% | 40–50% |
Even in the downside scenario, the business reaches break-even by Year 3 and generates modest positive returns by Year 5. This resilience reflects the essential nature of liquor demand, the variable-cost structure, and the modest fixed-cost base.
20.3 Stress Test: Regulatory Disruption
The COVID-19 alcohol bans of 2020–2021 demonstrated extreme tail risk. We model a 3-month government-imposed sales ban during Year 2:
| Impact | Base Case | Stress Case | Variance |
|---|---|---|---|
| Year 2 Revenue | R 6,480,000 | R 4,860,000 (-25%) | (R 1,620,000) |
| Year 2 Net Profit | R 22,557 | (R 410,000) | (R 432,557) |
| Cash Position (End Year 2) | R 339,407 | (R 93,000) | (R 432,407) |
| Additional Capital Required | R 0 | R 150,000–200,000 | Emergency funding |
The mitigation strategy involves maintaining a minimum cash buffer of R250,000 at all times, negotiating a standby credit facility, securing business-interruption insurance covering forced closure, and industry lobbying through the National Liquor Traders Council.
This document contains proprietary and confidential information. Distribution without written consent is prohibited.