Precision Coachworks Business Plan — Appendix A: Consolidated Financial Summary
Consolidated five-year summary: booths, floor positions, cycle time, vehicles, revenue, EBITDA, profit after tax and debt service cover.
Appendix A: Consolidated Financial Summary
Jump to section
- Overview & contents
- i. Important Notice and Basis of Preparation
- 1. Executive Summary
- 2. Market and Structure
- 3. Accreditation and Compliance
- 4. How a Panel Shop Actually Makes Money
- 5. SWOT and Competitive Position
- 6. Operations and the Capacity Build
- 7. Route to Market
- 8. Management and Governance
- 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 |
|---|---|---|---|---|---|
|
Spray booths |
1 |
1 |
2 |
2 |
2 |
|
Floor positions |
16 |
20 |
32 |
36 |
38 |
|
Key-to-key cycle time, days |
14.0 |
12.0 |
10.5 |
9.5 |
9.0 |
|
Utilisation |
48% |
66% |
70% |
77% |
81% |
|
Booth capacity, vehicles |
588 |
588 |
1 176 |
1 176 |
1 176 |
|
Floor capacity, vehicles |
280 |
408 |
747 |
928 |
1 034 |
|
Vehicles repaired |
134 |
270 |
523 |
715 |
838 |
|
Average repair value |
35 821 |
35 278 |
35 078 |
35 035 |
34 975 |
|
Labour revenue |
1 536 000 |
3 048 000 |
5 871 000 |
8 016 000 |
9 379 000 |
|
Paint and materials |
768 000 |
1 524 000 |
2 935 000 |
4 008 000 |
4 689 000 |
|
Parts |
2 496 000 |
4 953 000 |
9 540 000 |
13 026 000 |
15 241 000 |
|
Total revenue |
4 800 000 |
9 525 000 |
18 346 000 |
25 050 000 |
29 309 000 |
|
Cost of sales |
(2 905 000) |
(5 764 000) |
(11 103 000) |
(15 160 000) |
(17 738 000) |
|
Gross profit |
1 895 000 |
3 761 000 |
7 243 000 |
9 890 000 |
11 571 000 |
|
Gross margin |
39.5% |
39.5% |
39.5% |
39.5% |
39.5% |
|
Overhead |
(3 671 000) |
(4 261 000) |
(6 294 000) |
(6 975 000) |
(7 470 000) |
|
EBITDA |
(1 776 000) |
(500 000) |
949 000 |
2 915 000 |
4 101 000 |
|
Depreciation |
(969 950) |
(1 063 250) |
(1 346 416) |
(1 351 966) |
(1 355 666) |
|
Interest |
(478 944) |
(518 092) |
(684 861) |
(687 345) |
(590 605) |
|
Taxation |
— |
— |
— |
— |
(116 355) |
|
Profit / (loss) after tax |
(3 224 894) |
(2 081 342) |
(1 082 277) |
875 689 |
2 038 374 |
|
Cumulative profit / (deficit) |
(3 224 894) |
(5 306 236) |
(6 388 513) |
(5 512 824) |
(3 474 450) |
|
Cash generated from operations |
(2 437 634) |
(1 487 912) |
(523 514) |
1 546 132 |
2 967 090 |
|
Capital deployed |
(8 564 000) |
(700 000) |
(2 982 000) |
(44 400) |
(29 600) |
|
Asset finance drawn |
3 614 675 |
295 455 |
1 258 636 |
18 740 |
12 494 |
|
Debt capital repaid |
— |
— |
— |
(742 606) |
(901 701) |
|
Closing cash |
4 713 041 |
2 820 584 |
573 706 |
1 351 572 |
3 399 855 |
|
Insurer debtor book |
683 836 |
1 356 986 |
2 613 677 |
3 568 767 |
4 175 529 |
|
Total assets |
13 120 356 |
11 665 195 |
12 548 458 |
13 154 610 |
14 598 448 |
|
Asset finance outstanding |
3 614 675 |
3 910 130 |
5 168 766 |
4 444 900 |
3 555 693 |
|
Total equity |
8 875 106 |
6 793 764 |
5 711 487 |
6 587 176 |
8 625 550 |
|
Debt service cover |
n/a |
n/a |
1.39x |
2.04x |
2.75x |