Urban Jazz Premium Liquors — Financial Plan & Five-Year Projections
Note: Year 1 payroll reflects a reduced Managing Director salary draw of R15,000/month during the startup phase, increasing to the full R30,000/month from Year 2 onward. The Year 1 operating loss of R135,150 is funded from the working-capital allocation. Profitability is achieved…
Section 9 · Business Plan
Financial Plan & Five-Year Projections
Note: Year 1 payroll reflects a reduced Managing Director salary draw of R15,000/month during the startup phase, increasing to the full R30,000/month from Year 2 onward. The Year 1 operating loss of R135,150 is funded from the working-capital allocation. Profitability is achieved…
Growing from R5.4 million in Year 1, with a blended gross margin of 23–28% and 5-year cumulative net profit above R5.35 million.
9.1 Key Assumptions
| Assumption | Value | Basis |
|---|---|---|
| Average Daily Sales (Year 1) | R 15,000 | Conservative estimate; 50–70 transactions at R215–R300 average |
| Annual Revenue Growth Rate | Year 1–2: 20%; Year 2–3: 15%; Year 3–5: 10% | Driven by customer acquisition, basket growth, premiumisation |
| Blended Gross Margin | 25% (Year 1) increasing to 28% (Year 5) | Mix shift toward higher-margin spirits/wine over time |
| Monthly Rent | R 30,000 (escalating 8% annually) | Gauteng commercial property norms |
| Annual Rent Escalation | 8% | Standard commercial lease terms |
| Monthly Payroll | R 84,000 (base) + 10% statutory | 7 FTEs as per staffing plan |
| Monthly Marketing | R 20,000 | ~4% of revenue; scales with growth |
| Monthly Utilities | R 8,000 (escalating 10% annually) | Electricity, water, internet, phone |
| Annual Insurance | R 36,000 | Comprehensive retail cover + liquor-specific policy |
| Shrinkage Rate | 1.5% of COGS | Industry benchmark for well-managed stores |
| Corporate Tax Rate | 27% | South African corporate income tax |
| Inflation (CPI) | 5–6% per annum | SARB medium-term target range |
| Line Item | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Revenue | 5,400,000 | 6,480,000 | 7,452,000 | 8,197,200 | 9,016,920 |
| Cost of Goods Sold | (4,050,000) | (4,860,000) | (5,440,000) | (5,902,000) | (6,492,182) |
| Gross Profit | 1,350,000 | 1,620,000 | 2,012,000 | 2,295,200 | 2,524,738 |
| Gross Margin % | 25.0% | 25.0% | 27.0% | 28.0% | 28.0% |
| Rent | (360,000) | (388,800) | (419,904) | (453,496) | (489,776) |
| Payroll (incl. statutory) | (554,400) | (582,120) | (611,226) | (641,787) | (673,877) |
| Marketing | (240,000) | (259,200) | (280,000) | (300,000) | (320,000) |
| Utilities | (96,000) | (105,600) | (116,160) | (127,776) | (140,554) |
| Insurance | (36,000) | (38,160) | (40,450) | (42,877) | (45,449) |
| Shrinkage | (60,750) | (72,900) | (81,600) | (88,530) | (97,383) |
| Other Operating Costs | (72,000) | (76,320) | (80,900) | (85,750) | (90,900) |
| Total Operating Expenses | (1,419,150) | (1,523,100) | (1,630,240) | (1,740,216) | (1,857,939) |
| EBITDA | (69,150) | 96,900 | 381,760 | 554,984 | 666,799 |
| Depreciation | (66,000) | (66,000) | (66,000) | (44,000) | (44,000) |
| EBIT | (135,150) | 30,900 | 315,760 | 510,984 | 622,799 |
| Interest | 0 | 0 | 0 | 0 | 0 |
| Profit Before Tax | (135,150) | 30,900 | 315,760 | 510,984 | 622,799 |
| Tax (27%) | 0 | (8,343) | (85,255) | (137,966) | (168,156) |
| Net Profit | (135,150) | 22,557 | 230,505 | 373,018 | 454,643 |
| Net Margin % | -2.5% | 0.3% | 3.1% | 4.6% | 5.0% |
Note: Year 1 payroll reflects a reduced Managing Director salary draw of R15,000/month during the startup phase, increasing to the full R30,000/month from Year 2 onward. The Year 1 operating loss of R135,150 is funded from the working-capital allocation. Profitability is achieved in Year 2, with net margins expanding steadily as revenue scales against a largely fixed cost base.
9.3 Five-Year Cash Flow Statement
| Line Item | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Net Profit / (Loss) | (135,150) | 22,557 | 230,505 | 373,018 | 454,643 |
| Add: Depreciation | 66,000 | 66,000 | 66,000 | 44,000 | 44,000 |
| Operating Cash Flow | (69,150) | 88,557 | 296,505 | 417,018 | 498,643 |
| Inventory Investment | (800,000) | (120,000) | (100,000) | (80,000) | (80,000) |
| Capital Expenditure | (530,000) | (30,000) | (40,000) | (50,000) | (60,000) |
| Total Investing | (1,330,000) | (150,000) | (140,000) | (130,000) | (140,000) |
| Equity Investment | 1,800,000 | 0 | 0 | 0 | 0 |
| Loan Proceeds | 0 | 0 | 0 | 0 | 0 |
| Financing Cash Flow | 1,800,000 | 0 | 0 | 0 | 0 |
| Net Cash Flow | 400,850 | (61,443) | 156,505 | 287,018 | 358,643 |
| Opening Cash Balance | 0 | 400,850 | 339,407 | 495,912 | 782,930 |
| Closing Cash Balance | 400,850 | 339,407 | 495,912 | 782,930 | 1,141,573 |
The cash flow projections demonstrate that the R1.8 million equity investment provides adequate runway through the startup phase, with the business generating positive operating cash flow from Year 2. By Year 5, the accumulated cash balance of R1.14 million provides the foundation for second-store expansion without requiring additional external capital.
9.4 Projected Balance Sheet
| Assets | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Cash & Equivalents | 400,850 | 339,407 | 495,912 | 782,930 | 1,141,573 |
| Inventory | 800,000 | 920,000 | 1,020,000 | 1,100,000 | 1,180,000 |
| Accounts Receivable | 0 | 0 | 0 | 0 | 0 |
| Total Current Assets | 1,200,850 | 1,259,407 | 1,515,912 | 1,882,930 | 2,321,573 |
| Fixed Assets (Gross) | 530,000 | 560,000 | 600,000 | 650,000 | 710,000 |
| Accumulated Depreciation | (66,000) | (132,000) | (198,000) | (242,000) | (286,000) |
| Net Fixed Assets | 464,000 | 428,000 | 402,000 | 408,000 | 424,000 |
| Total Assets | 1,664,850 | 1,687,407 | 1,917,912 | 2,290,930 | 2,745,573 |
| Liabilities & Equity | |||||
| Trade Payables | 0 | 0 | 0 | 0 | 0 |
| Tax Payable | 0 | 8,343 | 85,255 | 137,966 | 168,156 |
| Total Liabilities | 0 | 8,343 | 85,255 | 137,966 | 168,156 |
| Share Capital | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 | 1,800,000 |
| Retained Earnings | (135,150) | (120,936) | 32,657 | 352,964 | 777,417 |
| Total Equity | 1,664,850 | 1,679,064 | 1,832,657 | 2,152,964 | 2,577,417 |
| Total Liabilities & Equity | 1,664,850 | 1,687,407 | 1,917,912 | 2,290,930 | 2,745,573 |
This document contains proprietary and confidential information. Distribution without written consent is prohibited.