Tiptop Market — Financial Projections
Five-year projections prepared on a conservative basis, benchmarked against comparable South African and emerging market e-commerce companies. All amounts in South African Rand.
Section 9 · Business Plan
Financial Projections
Five-year projections prepared on a conservative basis, benchmarked against comparable South African and emerging market e-commerce companies. All amounts in South African Rand.
Year 5 GMV
R4,500,000,000
Translating to R855 million Year-5 net revenue and R171 million EBITDA (a 20% margin), with the business reaching profitability from Year 3.
Five-year projections prepared on a conservative basis, benchmarked against comparable South African and emerging market e-commerce companies. All amounts in South African Rand.
9.1 Key Assumptions
| Assumption | Basis |
|---|---|
| GMV growth | Year 1: R280M; CAGR 100%+ declining to 60% by Year 5 |
| Blended take rate | 15% (Y1) increasing to 19% (Y5) |
| Gross margin | 55% (Y1) improving to 70% (Y5) |
| Technology costs | 35% of revenue (Y1) declining to 14% (Y5) |
| Marketing spend | 55% of revenue (Y1) declining to 15% (Y5) |
| Fulfilment costs | 30% of revenue (Y1) declining to 15% (Y5) |
| Corporate tax | 27% (SA statutory rate) |
| Discount rate | 15% WACC |
| Terminal growth | 5% for DCF |
9.2 Projected Income Statement (Profit & Loss)
| Income Statement (R’000) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Net Revenue | 42,000 | 115,000 | 255,000 | 504,000 | 855,000 |
| Cost of Revenue (COGS) | (18,900) | (46,000) | (89,250) | (161,280) | (256,500) |
| Gross Profit | 23,100 | 69,000 | 165,750 | 342,720 | 598,500 |
| Gross Margin % | 55.0% | 60.0% | 65.0% | 68.0% | 70.0% |
| Technology & Platform | (14,700) | (28,750) | (48,450) | (80,640) | (119,700) |
| Marketing & Acquisition | (23,100) | (34,500) | (51,000) | (85,680) | (128,250) |
| Fulfilment & Logistics | (12,600) | (25,300) | (51,000) | (90,720) | (128,250) |
| Staff Costs (excl. above) | (15,000) | (22,000) | (32,000) | (45,000) | (60,000) |
| General & Administrative | (5,700) | (8,050) | (8,800) | (10,080) | (11,130) |
| Total Operating Expenses | (71,100) | (118,600) | (191,250) | (312,120) | (447,330) |
| EBITDA | (48,000) | (12,000) | 25,500 | 80,600 | 171,000 |
| EBITDA Margin % | -114% | -10.4% | 10.0% | 16.0% | 20.0% |
| Depreciation & Amortisation | (8,000) | (10,000) | (12,000) | (15,000) | (18,000) |
| Earnings Before Tax | (56,000) | (22,000) | 13,500 | 65,600 | 153,000 |
| Income Tax (27%) | 0 | 0 | (3,645) | (13,600) | (33,000) |
| NET PROFIT / (LOSS) | (56,000) | (22,000) | 8,913 | 52,000 | 120,000 |
| Net Margin % | -133% | -19.1% | 3.5% | 10.3% | 14.0% |
| Cumulative Net P/(L) | (56,000) | (78,000) | (69,087) | (17,087) | 102,913 |
Figure
Figure 9.1: GMV & Net Revenue Projections
Figure
Figure 9.2: Revenue Breakdown by Stream
Figure
Figure 9.3: EBITDA, Net Income & Margin Trend
9.3 Projected Balance Sheet
| Balance Sheet (R’000) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| ASSETS | |||||
| Non-Current Assets | |||||
| Technology Platform (net) | 32,000 | 38,000 | 42,000 | 45,000 | 48,000 |
| Warehouse & Equipment (net) | 18,000 | 30,000 | 38,000 | 42,000 | 44,000 |
| Intangible Assets | 5,000 | 4,000 | 3,000 | 2,000 | 1,000 |
| Total Non-Current Assets | 55,000 | 72,000 | 83,000 | 89,000 | 93,000 |
| Current Assets | |||||
| Inventory (1P retail) | 4,200 | 8,050 | 12,750 | 17,640 | 21,375 |
| Trade Receivables | 2,100 | 5,750 | 12,750 | 25,200 | 42,750 |
| Cash & Cash Equivalents | 17,000 | (13,000) | 5,088 | 60,088 | 210,088 |
| Seller Escrow Balances | 8,400 | 21,600 | 45,000 | 84,000 | 135,000 |
| Total Current Assets | 31,700 | 22,400 | 75,588 | 186,928 | 409,213 |
| TOTAL ASSETS | 86,700 | 94,400 | 158,588 | 275,928 | 502,213 |
| EQUITY & LIABILITIES | |||||
| Share Capital | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 |
| Retained Earnings | (56,000) | (78,000) | (69,087) | (17,087) | 102,913 |
| Total Equity | 94,000 | 72,000 | 80,913 | 132,913 | 252,913 |
| Non-Current Liabilities | 0 | 0 | 25,000 | 50,000 | 75,000 |
| Current Liabilities | |||||
| Trade Payables | (15,700) | 900 | 7,675 | 9,015 | 39,300 |
| Seller Payables | 8,400 | 21,600 | 45,000 | 84,000 | 135,000 |
| Total Current Liabilities | (7,300) | 22,400 | 52,675 | 93,015 | 174,300 |
| TOTAL EQUITY & LIABILITIES | 86,700 | 94,400 | 158,588 | 275,928 | 502,213 |
9.4 Projected Cash Flow Statement
| Cash Flow Statement (R’000) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| OPERATING ACTIVITIES | |||||
| Net Profit / (Loss) | (56,000) | (22,000) | 8,913 | 52,000 | 120,000 |
| Add: Depreciation & Amortisation | 8,000 | 10,000 | 12,000 | 15,000 | 18,000 |
| Changes in Working Capital | 10,000 | 7,000 | 14,087 | 28,000 | 52,000 |
| Net Cash from Operations | (38,000) | (5,000) | 35,000 | 95,000 | 190,000 |
| INVESTING ACTIVITIES | |||||
| Technology Development | (45,000) | (15,000) | (18,000) | (20,000) | (22,000) |
| Warehouse & Equipment | (35,000) | (8,000) | (10,000) | (12,000) | (15,000) |
| Other CAPEX | (15,000) | (2,000) | (2,000) | (3,000) | (3,000) |
| Net Cash from Investing | (95,000) | (25,000) | (30,000) | (35,000) | (40,000) |
| FINANCING ACTIVITIES | |||||
| Equity Raised | 150,000 | 0 | 0 | 0 | 0 |
| Debt Raised / (Repaid) | 0 | 0 | 0 | 0 | 0 |
| Net Cash from Financing | 150,000 | 0 | 0 | 0 | 0 |
| NET CASH MOVEMENT | 17,000 | (30,000) | 5,000 | 60,000 | 150,000 |
| Opening Cash Balance | 0 | 17,000 | (13,000) | 5,088 | 60,088 |
| Closing Cash Balance | 17,000 | (13,000) | 5,088 | 60,088 | 210,088 |
Figure
Figure 9.4: Cash Flow Summary
9.5 Key Financial Ratios & Operating Metrics
| Metric | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| GMV (R millions) | 280 | 720 | 1,500 | 2,800 | 4,500 |
| Net Revenue (R millions) | 42 | 115 | 255 | 504 | 855 |
| Gross Margin | 55% | 60% | 65% | 68% | 70% |
| EBITDA Margin | -114% | -10% | 10% | 16% | 20% |
| Net Margin | -133% | -19% | 3.5% | 10.3% | 14.0% |
| Active Customers (000s) | 85 | 250 | 520 | 950 | 1,500 |
| Active Sellers | 800 | 2,200 | 5,000 | 8,500 | 14,000 |
| Orders per Month (000s) | 52 | 133 | 275 | 500 | 806 |
| AOV (R) | 450 | 480 | 520 | 570 | 620 |
| CAC (R) | 320 | 240 | 180 | 150 | 130 |
| LTV (R) | 450 | 680 | 950 | 1,250 | 1,600 |
| LTV:CAC Ratio | 1.4x | 2.8x | 5.3x | 8.3x | 12.3x |
| Repeat Purchase Rate | 25% | 38% | 48% | 55% | 62% |
| Revenue per Employee (R’000) | 560 | 920 | 1,288 | 1,800 | 2,221 |
This document contains proprietary and confidential information. Distribution without written consent is prohibited.