Lumière Nail Bar Business Plan — Appendix A: Consolidated Financial Summary
Consolidated five-year summary: stations, rooms, utilisation, members, revenue by line, EBITDA, profit after tax and debt cover.
Appendix A: Consolidated Financial Summary
Jump to section
- Overview & contents
- i. Important Notice and Basis of Preparation
- 1. Executive Summary
- 2. Market and Positioning
- 3. How a Salon Actually Makes Money
- 4. The Membership Programme
- 5. SWOT and Competitive Position
- 6. Operations and the Capacity Build
- 7. Compliance and Standards
- 8. Management and Team
- 9. Financial Plan
- 10. Break-Even and Debt Service
- 11. Investment Analysis
- 12. Sensitivity and Scenario Analysis
- 13. Risk Analysis
- 14. Implementation Roadmap
- 15. Key Performance Indicators
- 16. Key Assumptions
- 17. Conclusion and Recommendation
- A. Appendix A: Consolidated Financial Summary
- B. Appendix B: Capital and Capacity Schedules
- C. Appendix C: Funding, Debt and Working Capital Schedules
- D. Appendix D: Risk Register
- E. Appendix E: Glossary
|
R unless stated |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|---|---|---|---|---|---|
|
Nail stations |
6 |
8 |
8 |
10 |
10 |
|
Treatment rooms |
3 |
4 |
4 |
5 |
5 |
|
Sellable hours |
27 180 |
36 240 |
36 240 |
45 300 |
45 300 |
|
Nail utilisation |
44% |
56% |
63% |
67% |
70% |
|
Room utilisation |
33% |
43% |
50% |
54% |
57% |
|
Treatment hours sold |
10 963 |
18 724 |
21 261 |
28 388 |
29 747 |
|
Members |
90 |
260 |
470 |
640 |
780 |
|
Treatment revenue |
3 518 000 |
6 018 000 |
6 848 000 |
9 154 000 |
9 598 000 |
|
Ancillary and add-ons |
211 000 |
361 000 |
411 000 |
549 000 |
576 000 |
|
Membership retained margin |
194 000 |
560 000 |
1 012 000 |
1 378 000 |
1 679 000 |
|
Package breakage |
35 000 |
86 000 |
144 000 |
189 000 |
221 000 |
|
Retail |
264 000 |
602 000 |
890 000 |
1 373 000 |
1 536 000 |
|
Total revenue |
4 222 000 |
7 626 000 |
9 306 000 |
12 643 000 |
13 610 000 |
|
Direct costs |
(2 815 000) |
(4 319 000) |
(5 064 000) |
(6 431 000) |
(6 821 000) |
|
Gross profit |
1 407 000 |
3 308 000 |
4 242 000 |
6 212 000 |
6 789 000 |
|
Gross margin |
33.3% |
43.4% |
45.6% |
49.1% |
49.9% |
|
Overhead |
(2 250 000) |
(2 600 000) |
(2 875 000) |
(3 305 000) |
(3 530 000) |
|
EBITDA |
(843 000) |
708 000 |
1 367 000 |
2 907 000 |
3 259 000 |
|
Depreciation |
(491 750) |
(545 750) |
(547 917) |
(587 750) |
(587 750) |
|
Interest |
(178 750) |
(178 750) |
(142 294) |
(100 826) |
(53 656) |
|
Taxation |
— |
— |
— |
(368 608) |
(706 750) |
|
Profit / (loss) after tax |
(1 513 500) |
(16 500) |
676 789 |
1 849 816 |
1 910 844 |
|
Cumulative profit / (deficit) |
(1 513 500) |
(1 530 000) |
(853 211) |
996 605 |
2 907 449 |
|
Cash generated from operations |
(617 876) |
710 390 |
1 378 154 |
2 591 197 |
2 586 866 |
|
Capital deployed |
(3 104 000) |
(395 000) |
(13 000) |
(298 000) |
(0) |
|
Debt capital repaid |
— |
(265 132) |
(301 588) |
(343 056) |
(390 224) |
|
Closing cash |
378 124 |
428 382 |
1 491 948 |
3 442 089 |
5 638 731 |
|
Total assets |
3 072 801 |
3 045 553 |
3 620 590 |
5 365 048 |
7 000 216 |
|
Term debt outstanding |
1 300 000 |
1 034 868 |
733 280 |
390 224 |
0 |
|
Deferred prepaid income |
70 000 |
172 000 |
288 000 |
378 000 |
442 000 |
|
Total equity |
1 286 500 |
1 270 000 |
1 946 789 |
3 796 605 |
5 707 449 |
|
Debt service cover |
n/a |
1.60x |
3.08x |
6.55x |
7.34x |
|
Revenue per station and room |
469 111 |
635 500 |
775 500 |
842 867 |
907 333 |