EssenceLabs Hair Studio Business Plan — Appendix B: Debt Schedules
Loan-by-loan drawdown, interest and amortisation schedules across the term loan, asset finance and revolving facility.
Appendix B: Debt Schedules
Jump to section
- Overview & contents
- i. Important Notice
- 1. Executive Summary
- 2. The Business
- 3. Market Analysis
- 4. Service Offering, Pricing and Yield
- 5. Operations
- 6. Marketing and Client Acquisition
- 7. People and Management
- 8. SWOT and Competitive Position
- 9. Financial Plan
- 10. Break-Even and Sensitivity
- 11. Risk Management
- 12. The Funding Proposition
- 13. Implementation Plan
- 14. Key Performance Indicators
- 15. Conclusion
- A. Appendix A: Consolidated Financial Summary
- B. Appendix B: Debt Schedules
- C. Appendix C: Risk Register
- D. Appendix D: Assumption Register
- E. Appendix E: Glossary
- B.1 Term loan — R1 000 000 at 13.50% over seven years
- B.2 Asset finance — R322 000 at 15.0% over four years
- B.3 Revolving facility — R650 000 at prime plus 4%
- B.4 Combined debt service
B.1 Term loan — R1 000 000 at 13.50% over seven years
Interest only for the first twelve months, then amortising over the remaining six years at an annual instalment of R254.
|
R’000 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|---|---|---|---|---|---|
|
Opening balance |
1 000 |
1 000 |
881 |
747 |
594 |
|
Interest at 13.50% |
135 |
135 |
119 |
101 |
80 |
|
Capital repaid |
— (moratorium) |
119 |
135 |
153 |
174 |
|
Closing balance |
1 000 |
881 |
747 |
594 |
420 |
B.2 Asset finance — R322 000 at 15.0% over four years
|
R’000 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|---|---|---|---|---|---|
|
Opening balance |
322 |
258 |
183 |
98 |
0 |
|
Interest at 15.0% |
48 |
39 |
28 |
15 |
0 |
|
Capital repaid |
65 |
74 |
85 |
98 |
113 |
|
Closing balance |
258 |
183 |
98 |
0 |
0 |
B.3 Revolving facility — R650 000 at prime plus 4%
|
R’000 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|---|---|---|---|---|---|
|
Drawn at year end |
105 |
380 |
472 |
500 |
79 |
|
Interest charged |
8 |
35 |
62 |
70 |
42 |
|
Undrawn headroom |
545 |
270 |
178 |
150 |
571 |
|
Utilisation of limit |
16.2% |
58.5% |
72.6% |
76.9% |
12.2% |
B.4 Combined debt service
|
R’000 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|---|---|---|---|---|---|
|
Term loan and asset finance interest |
183 |
174 |
146 |
116 |
80 |
|
Facility interest |
8 |
35 |
62 |
70 |
42 |
|
Total interest |
191 |
209 |
208 |
186 |
122 |
|
Capital repaid |
64 |
193 |
220 |
251 |
286 |
|
Total debt service |
255 |
402 |
428 |
437 |
408 |
|
EBITDA |
(348) |
196 |
406 |
554 |
980 |
|
Debt service cover ratio |
n/a |
0.49x |
0.95x |
1.27x |
2.40x |
|
Total debt outstanding |
1 363 |
1 445 |
1 317 |
1 094 |
499 |