Sparkle Lane Business Plan — Financial Projections

Five-year projections: revenue building to R8.32m and EBITDA to R1.36m at a 16.4% margin, with the full cost stack by line.

Financial Projections

Jump to section
On this page

  • 13.1 Basis of preparation
  • 13.2 Projected income statement
  • 13.3 The cost base as a share of revenue
  • 13.4 Projected cash flow
  • 13.5 Projected balance sheet

13.1 Basis of preparation

  • All amounts are in nominal South African rand. Revenue is built from sites open, cars washed per day, the blended walk-in ticket and the subscriber base, with subscription washes counted inside total throughput.
  • Site operating costs are modelled per site and scale with the rollout. Labour, rent, chemicals, electricity, water, card fees and plant maintenance are stated separately.
  • Group overhead — owner and management, administration, marketing, technology, compliance and insurance — is carried above site level and does not scale proportionally with sites.
  • R78 000 per site of opening consumables and pre-opening payroll is a period cost and is charged to income in the year the site opens, escalating with site cost.
  • Depreciation is charged on the capitalised element of site cost, net of the landlord installation allowance, over the useful lives of the canopy, plant and equipment.
  • Interest derives from the facility-level schedules in Appendix C across five instruments.
  • Corporate income tax is applied at 27 per cent with assessed losses carried forward subject to the section 20 limitation. No tax arises within the projection.
  • The balance sheet is derived rather than plugged; shareholders’ funds roll forward from the two equity subscriptions and retained earnings, and the closing cash position reconciles exactly to the cash flow statement.

13.2 Projected income statement

R’000

Year 1

Year 2

Year 3

Year 4

Year 5

Walk-in washes

972

1 679

2 525

3 376

4 368

Subscriptions

381

1 149

2 211

3 518

Ancillary

53

113

202

307

434

Total revenue

1 025

2 174

3 876

5 894

8 320

Labour

(354)

(728)

(1 271)

(1 898)

(2 629)

Rent

(351)

(501)

(893)

(1 147)

(1 636)

Chemicals and consumables

(64)

(135)

(240)

(365)

(516)

Electricity

(37)

(78)

(140)

(212)

(300)

Water

(23)

(46)

(78)

(119)

(166)

Card fees

(27)

(57)

(101)

(153)

(216)

Plant maintenance

(25)

(52)

(93)

(141)

(200)

Site-level EBITDA

144

577

1 060

1 859

2 657

Site-level margin

14.0%

26.5%

27.3%

31.5%

31.9%

Owner and management

(252)

(296)

(348)

(402)

(456)

Administration

(76)

(96)

(136)

(166)

(198)

Marketing

(96)

(122)

(172)

(208)

(252)

Technology

(46)

(60)

(86)

(104)

(128)

Compliance and permits

(58)

(70)

(100)

(122)

(148)

Insurance

(42)

(52)

(76)

(92)

(112)

EBITDA

(426)

(119)

142

765

1 363

EBITDA margin

-41.6%

-5.5%

3.7%

13.0%

16.4%

Pre-opening cost

(78)

(83)

(88)

Depreciation

(215)

(215)

(444)

(444)

(689)

Interest

(79)

(221)

(321)

(343)

(356)

Profit / (loss) before tax

(798)

(555)

(706)

(22)

230

Taxation

Profit / (loss) after tax

(798)

(555)

(706)

(22)

230

Revenue against the cost stack
Figure 16. Revenue against the cost stack.

Site-level EBITDA is positive from Year 1 at R146 000 and reaches R2.66 million by Year 5. Group EBITDA turns positive only in Year 3, because in Years 1 and 2 a full group overhead of R570 000 and R696 000 is carried on a single site. Assessed losses of R2.08 million accumulate across Years 1 to 4 and shelter the Year 5 profit entirely, so no tax is payable within the projection and R1.85 million of loss is carried forward.

13.3 The cost base as a share of revenue

Site costs scale with the rollout; group overhead does not. The build below shows each as a share of revenue, which is the only way to see whether a cost is being controlled or merely growing more slowly than the top line.

% of revenue

Year 1

Year 2

Year 3

Year 4

Year 5

Behaviour

Labour

34.5%

33.5%

32.8%

32.2%

31.6%

Barely improves with scale; the roster is the only lever

Rent

34.2%

23.0%

23.0%

19.5%

19.7%

Fixed per site; falls only as a site fills

Chemicals and consumables

6.2%

6.2%

6.2%

6.2%

6.2%

Variable with washes; modest purchasing gain at three sites

Electricity

3.6%

3.6%

3.6%

3.6%

3.6%

Pumps and lighting; the solar and inverter installation caps it

Water

2.2%

2.1%

2.0%

2.0%

2.0%

Falls despite a 12.5% tariff escalation, because litres per car fall faster

Card fees and plant maintenance

5.1%

5.0%

5.0%

5.0%

5.0%

Card fees are a fixed percentage; maintenance rises with plant age

Group overhead

55.6%

32.0%

23.7%

18.6%

15.6%

The whole of the margin expansion sits here

Total cost base

141.6%

105.5%

96.3%

87.0%

83.6%

Water is the only line that falls in absolute percentage terms while its unit price rises 12.5 per cent a year, because litres per car fall from 59 to 40 faster than the tariff climbs. Every other site cost is broadly flat as a share of revenue across the whole plan. Group overhead falls from 55.6 per cent to 15.6 per cent, and that single movement accounts for essentially the entire swing from a minus 41.3 per cent EBITDA margin to a positive 16.4 per cent.

13.4 Projected cash flow

R’000

Year 1

Year 2

Year 3

Year 4

Year 5

EBITDA

(426)

(119)

142

765

1 363

Pre-opening cost

(78)

(83)

(88)

Movement in working capital

21

27

53

58

81

Taxation paid

Operating cash flow

(483)

(92)

112

823

1 356

Capital expenditure, net of allowance

(2 015)

(2 154)

(2 292)

Equity introduced

1 400

2 400

Loans and facilities drawn

1 340

900

780

1 400

Loan repayments

(108)

(241)

(577)

(577)

Interest paid

(79)

(221)

(321)

(343)

(356)

Net cash flow

163

479

576

(97)

(469)

Closing cash

163

642

1 218

1 121

652

Cash flow — a build year in Years 1, 3 and 5
Figure 17. Cash flow — a build year in Years 1, 3 and 5.

Operating cash flow is negative in Years 1 and 2 and turns positive in Year 3 at R112 000, reaching R1.36 million by Year 5. Closing cash never falls below R163 000, which is the Year 1 position and the tightest point in the plan. The Year 5 draw of R469 000 against cash reflects the third site being built out of a R1.40 million term loan against a R2.29 million net cost, with the difference met from accumulated cash.

13.5 Projected balance sheet

R’000

Year 1

Year 2

Year 3

Year 4

Year 5

Site works, plant and equipment

1 800

1 585

3 295

2 850

4 453

Stock

6

12

22

33

46

Receivables

21

43

78

118

166

Cash

163

642

1 218

1 121

652

Total assets

1 990

2 282

4 613

4 122

5 317

Loans outstanding

1 340

2 132

2 671

2 093

2 916

Payables and deferred subscriptions

48

103

201

310

452

Total liabilities

1 388

2 235

2 872

2 403

3 368

Shareholders’ funds

602

47

1 741

1 719

1 949

Total liabilities and shareholders’ funds

1 990

2 282

4 613

4 122

5 317

Balance sheet — asset composition
Figure 18. Balance sheet — asset composition.

Shareholders’ funds fall from R602 000 at Year 1 to R47 000 at Year 2 as the second year of losses is absorbed, recover to R1.74 million on the growth subscription at Year 3, and reach R1.95 million by Year 5. Against R3.80 million subscribed, the equity has absorbed R1.85 million of cumulative losses — which is the cost of building three sites and carrying a group overhead while doing it.

Next section14. Break-Even