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
- Overview & contents
- i. Important Notice
- 1. Executive Summary
- 2. The Competitive Problem
- 3. Water: Compliance First, Saving Second
- 4. The Subscription Model
- 5. SWOT and Competitive Position
- 6. The Site and the Offer
- 7. Site Selection
- 8. Unit Economics
- 9. The Rollout and Its Gates
- 10. Funding
- 11. People and Operations
- 12. Compliance and Permits
- 13. Financial Projections
- 14. Break-Even
- 15. Sensitivity and Scenarios
- 16. Risk Management
- 17. Implementation Timeline
- 18. Returns
- 19. Key Performance Indicators
- 20. Key Assumptions
- 21. Conclusion
- A. Appendix A: Consolidated Financial Summary
- B. Appendix B: Site Capital Schedule
- C. Appendix C: Funding and Debt Schedules
- D. Appendix D: Risk Register
- E. Appendix E: Glossary
- 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 |
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 |
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 |
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.