Frame & Field Studios Business Plan — Appendix A: Consolidated Financial Summary
Consolidated five-year summary: photographers, editors, billable days, day rate, revenue, EBITDA and debt service cover.
Appendix A: Consolidated Financial Summary
Jump to section
- Overview & contents
- i. Important Notice and Basis of Preparation
- 1. What Artificial Intelligence Has Taken, and What It Has Not
- 2. Executive Summary
- 3. Service Lines, Clients and Pricing
- 4. Capacity: The Shooting Day and the Editing Day
- 5. SWOT and Competitive Position
- 6. Organisation, Rights and Compliance
- 7. Financial Plan
- 8. Break-Even and Debt Service
- 9. Investment Analysis
- 10. Sensitivity and Scenario Analysis
- 11. Risk Analysis
- 12. Implementation Roadmap
- 13. Key Performance Indicators
- 14. Key Assumptions
- 15. Conclusion and Recommendation
- A. Appendix A: Consolidated Financial Summary
- B. Appendix B: Capacity, Mix and Cost 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 |
|---|---|---|---|---|---|
|
Photographers |
3.0 |
4.5 |
6.0 |
7.0 |
7.5 |
|
Editors |
1.5 |
2.5 |
3.5 |
4.0 |
4.5 |
|
Billable utilisation |
58% |
64% |
68% |
70% |
71% |
|
Shooting days possible |
404 |
668 |
947 |
1 137 |
1 235 |
|
Editing capacity, in shoot-day terms |
398 |
664 |
929 |
1 062 |
1 195 |
|
Billable days delivered |
398 |
664 |
929 |
1 062 |
1 195 |
|
Average day rate |
20 946 |
21 525 |
22 127 |
22 754 |
23 407 |
|
Revenue |
8 340 055 |
14 284 070 |
20 557 258 |
24 159 695 |
27 959 254 |
|
Revenue per photographer |
2 780 018 |
3 174 238 |
3 426 210 |
3 451 385 |
3 727 901 |
|
Direct costs |
(2 739 405) |
(4 839 616) |
(7 181 989) |
(8 700 467) |
(10 375 307) |
|
Gross profit |
5 600 650 |
9 444 454 |
13 375 269 |
15 459 228 |
17 583 947 |
|
Gross margin |
67.2% |
66.1% |
65.1% |
64.0% |
62.9% |
|
Salaries and wages |
(3 719 707) |
(5 008 755) |
(6 434 819) |
(7 528 889) |
(8 474 005) |
|
Other fixed costs |
(2 483 184) |
(2 812 971) |
(3 172 660) |
(3 481 435) |
(3 771 357) |
|
EBITDA |
(602 241) |
1 622 728 |
3 767 790 |
4 448 903 |
5 338 585 |
|
EBITDA margin |
-7.2% |
11.4% |
18.3% |
18.4% |
19.1% |
|
Depreciation |
(1 205 333) |
(1 205 333) |
(1 205 333) |
(1 205 333) |
(1 205 333) |
|
Finance costs |
(787 912) |
(666 855) |
(529 795) |
(374 615) |
(198 921) |
|
Profit / (loss) before tax |
(4 455 486) |
(249 460) |
2 032 662 |
2 868 955 |
3 934 331 |
|
Taxation |
— |
— |
(109 764) |
(154 924) |
(850 683) |
|
Profit / (loss) after tax |
(4 455 486) |
(249 460) |
1 922 898 |
2 714 031 |
3 083 648 |
|
Cumulative profit / (deficit) |
(4 455 486) |
(4 704 946) |
(2 782 048) |
(68 017) |
3 015 631 |
|
Cash generated from operations |
(2 779 469) |
(22 963) |
2 104 842 |
3 344 972 |
3 688 779 |
|
Debt capital repaid |
(915 708) |
(1 036 765) |
(1 173 825) |
(1 329 005) |
(1 504 697) |
|
Facility drawn at year end |
1 895 177 |
2 954 905 |
2 823 888 |
807 921 |
0 |
|
Closing cash |
1 259 999 |
1 260 000 |
2 060 000 |
2 060 000 |
3 436 162 |
|
Working capital employed |
1 389 316 |
2 368 152 |
3 391 541 |
3 965 933 |
4 566 135 |
|
Total assets |
8 594 129 |
8 528 744 |
9 326 489 |
8 812 034 |
9 711 545 |
|
Debt and asset finance outstanding |
5 044 292 |
4 007 527 |
2 833 702 |
1 504 697 |
0 |
|
Total equity |
1 444 514 |
1 195 054 |
3 117 952 |
5 831 983 |
8 915 631 |
|
Debt service cover |
-0.35x |
0.95x |
2.21x |
2.61x |
3.13x |
|
Gearing |
82.8% |
85.4% |
64.5% |
28.4% |
0.0% |