Midrand Compute Distribution Business Plan — Financial Plan

Five-year projections: revenue to R549.1m, gross margin near 19% and EBITDA reaching R41.4m at a 7.5% margin.

Section 19 of 25

Financial Plan

Jump to section

Operating leverage on a thin-margin base: revenue triples-and-a-half, gross margin holds, and EBITDA margin quadruples — all reconciling to a balance sheet that balances every year.

Figure 1. Profitability ramp — EBITDA, net profit and margins, Years 1–5 (base case).

Key assumptions

Assumption	Basis
Revenue	Bottom-up: units × ASP by four segments, plus accessories/services attach and SADC re-export
Unit volume	14,000 notebooks in Year 1 growing to ~44,000 by Year 5 across segments
Gross margin	Segment margins 12.5–19%; accessories ~32%; services ~56%; blended ~19%
Landed cost / FX	USD purchase, ZAR sale; 0% duty on notebooks (HS 8471.30); 15% import VAT recoverable; ~70% forward-covered
Working capital	Inventory 55–62 days; receivables 38–42 days (on ~62% credit revenue); payables 25–31 days
Personnel	22 heads in Year 1 rising to 50; fully-loaded cost ~R372k–R442k per head
Financing	Prime-linked; term 12.5%, asset finance 13.5%, revolver 14.0%
Tax	27% corporate; assessed-loss carry-forward with an 80% set-off cap

Table 23. Principal modelling assumptions (base case).

Projected income statement

ZAR ‘000	Y1	Y2	Y3	Y4	Y5
Revenue	155,887	226,537	314,958	422,828	549,125
Cost of sales	(127,349)	(184,644)	(256,305)	(343,460)	(445,296)
Gross profit	28,538	41,893	58,653	79,369	103,828
Gross margin %	18.3%	18.5%	18.6%	18.8%	18.9%
Operating expenses	(25,824)	(33,124)	(42,224)	(51,915)	(62,475)
EBITDA	2,714	8,768	16,429	27,454	41,353
EBITDA margin %	1.7%	3.9%	5.2%	6.5%	7.5%
Depreciation	(3,380)	(3,620)	(3,980)	(3,253)	(3,773)
EBIT	-666	5,148	12,449	24,200	37,580
Net finance cost	(2,993)	(3,918)	(3,786)	(3,619)	(2,404)
Profit before tax	-3,659	1,230	8,663	20,581	35,175
Taxation	–	(66)	(1,617)	(5,557)	(9,497)
Net profit / (loss)	-3,659	1,164	7,046	15,024	25,678

Table 24. Projected income statement (base case).

Operating-expense breakdown

Operating expenses are dominated by people, premises and logistics, the running cost of a distribution platform, and fall steadily as a share of revenue as fixed costs are spread over a larger base.

Operating expense (R’000)	Y1	Y2	Y3	Y4	Y5
Personnel	8,184	11,640	15,390	18,612	22,100
Premises / rent	3,600	3,834	4,083	4,349	4,631
Logistics & distribution	3,741	5,210	6,929	8,879	10,982
Marketing	3,430	4,531	5,669	7,188	8,786
IT & systems	1,550	1,250	1,400	1,540	1,690
Insurance	1,403	1,926	2,520	3,298	4,118
Professional & compliance	1,450	1,150	1,250	1,360	1,480
Bad-debt provision	1,063	1,545	2,148	2,884	3,745
Other administration	1,403	2,039	2,835	3,805	4,942
Total operating expenses	25,824	33,124	42,224	51,915	62,475
OpEx as % of revenue	16.6%	14.6%	13.4%	12.3%	11.4%

Table 25. Operating-expense breakdown (base case). Operating leverage shows in the falling OpEx-to-revenue ratio.

Year-1 monthly phasing

The annual Year-1 result masks a pronounced ramp. The phasing below distributes the audited Year-1 figures across the twelve months on a realistic build curve, slow while channels and stock are established, accelerating into the education and corporate buying seasons. It shows why the business runs an operating loss and a deepening cash draw through the first three quarters before turning: the trough, not the annual average, is what the funding must cover.

Year 1 (R’000)	M1	M2	M3	M4	M5	M6
Revenue	7,015	7,794	8,574	10,133	10,912	12,471
Gross profit	1,284	1,427	1,570	1,855	1,998	2,283
Operating expenses	(1,829)	(1,888)	(1,947)	(2,005)	(2,064)	(2,123)
EBITDA	-545	-461	-377	-150	-66	161
Cumulative EBITDA	-545	-1,006	-1,382	-1,532	-1,598	-1,437

Table 26. Year-1 monthly phasing, first half. The cumulative line deepens through the ramp.

Year 1 (R’000)	M7	M8	M9	M10	M11	M12
Revenue	13,250	14,030	14,809	16,368	18,706	21,824
Gross profit	2,426	2,569	2,712	2,997	3,425	3,996
Operating expenses	(2,181)	(2,240)	(2,299)	(2,357)	(2,416)	(2,475)
EBITDA	245	329	413	640	1,009	1,521
Cumulative EBITDA	-1,193	-864	-451	189	1,198	2,719

Table 27. Year-1 monthly phasing, second half. Monthly EBITDA turns positive as volume builds; the twelve months sum to the Year-1 total.

So what? The monthly view is the clearest statement of the central risk: the business consumes cash before it generates it, and the depth of that trough, not the annual result, sets the working-capital facility the plan must have committed from day one.

Projected balance sheet

ZAR ‘000	Y1	Y2	Y3	Y4	Y5
Cash	3,000	3,000	3,000	3,000	3,000
Trade receivables	12,790	18,143	24,610	32,213	40,762
Inventory	21,632	30,353	40,728	52,695	67,099
Property, plant & equipment	12,720	10,300	8,120	7,067	5,893
Total assets	50,141	61,796	76,458	94,974	116,754
Trade payables	8,723	13,659	19,662	28,230	37,820
Debt (term + asset + revolver)	30,078	25,632	27,245	22,169	8,681
Share capital	15,000	25,000	25,000	25,000	25,000
Retained earnings	-3,659	-2,495	4,551	19,576	45,254
Total equity & liabilities	50,141	61,796	76,458	94,974	116,754
Balance check	-0	0	0	0	-0

Table 28. Projected balance sheet (base case). The balance check is nil in every period.

Projected cash-flow statement

ZAR ‘000	Y1	Y2	Y3	Y4	Y5
Operating cash flow	-25,978	-4,355	187	7,275	16,088
Investing cash flow	(16,100)	(1,200)	(1,800)	(2,200)	(2,600)
Financing cash flow	45,078	5,555	1,613	-5,075	-13,488
Net movement in cash	3,000	-0	-0	-0	-0
Closing cash	3,000	3,000	3,000	3,000	3,000

Table 29. Projected cash-flow statement (base case). Reconciles to the balance-sheet cash line.

Figure 2. Working capital and the cash conversion cycle — the core financing challenge.

Reading the statements together. Year 1 posts a small net loss as the cost base is absorbed ahead of full-year revenue. From Year 2 the business is profitable and increasingly cash-generative; cash is held at a R3m operating floor while surplus is used to fund the growing working-capital book and to repay the facility, so closing cash appears flat by design, the value accrues in a larger, better-financed balance sheet, not in idle cash.

Break-even analysis

Figure 3. Cumulative revenue versus full-cost recovery — break-even reached early in Year 2.

Where the business breaks even. With a Year-1 contribution ratio of ~14% against fixed costs (including depreciation and finance) of ~R25m, accounting break-even requires revenue of about R183m. Year 1 revenue of R156m falls short, hence the first-year loss, and the ramp closes the gap around month 20, early in Year 2. From that point the high operating leverage of a distribution model converts incremental revenue into EBITDA quickly, which is why margins expand so sharply thereafter.