Premier Quality Kenya Dairy Business Plan — Appendix A: Consolidated Financial Summary
Consolidated five-year summary: milking cows, litres, revenue by stream, EBITDA, profit after tax and closing cash.
Appendix A: Consolidated Financial Summary
Jump to section
- Overview & contents
- i. Important Notice and Basis of Preparation
- 1. Executive Summary
- 2. Market and Opportunity
- 3. Why the Fodder Block Is the Business
- 4. The Production Model
- 5. SWOT and Competitive Position
- 6. Housing, Water and Equipment
- 7. Regulatory and Compliance Framework
- 8. Management and Organisation
- 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 Herd Schedules
- C. Appendix C: Funding and Debt Schedules
- D. Appendix D: Risk Register
- E. Appendix E: Glossary
|
KES unless stated |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|---|---|---|---|---|---|
|
Average milking herd, head |
16 |
28 |
36 |
45 |
52 |
|
Young stock, head |
18 |
32 |
48 |
62 |
72 |
|
Average yield, litres a cow a day |
17.0 |
19.0 |
21.0 |
22.0 |
23.0 |
|
Litres sold |
83 147 |
163 285 |
239 494 |
307 029 |
365 335 |
|
Milk revenue |
3 991 000 |
7 838 000 |
11 496 000 |
14 737 000 |
17 536 000 |
|
Breeding stock, culls and manure |
377 000 |
624 000 |
2 271 000 |
3 371 000 |
4 432 000 |
|
Total revenue |
4 368 000 |
8 462 000 |
13 767 000 |
18 108 000 |
21 968 000 |
|
Feed — milking herd |
(2 833 000) |
(4 894 000) |
(6 455 000) |
(8 046 000) |
(9 331 000) |
|
Feed — rearing replacements |
(343 000) |
(798 000) |
(1 335 000) |
(1 717 000) |
(2 351 000) |
|
Labour |
(1 080 000) |
(1 380 000) |
(1 680 000) |
(1 860 000) |
(1 980 000) |
|
Vet, AI and animal health |
(217 000) |
(410 000) |
(555 000) |
(678 000) |
(793 000) |
|
Overhead and land lease |
(1 540 000) |
(1 720 000) |
(1 940 000) |
(2 120 000) |
(2 280 000) |
|
EBITDA |
(1 645 000) |
(740 000) |
1 802 000 |
3 687 000 |
5 233 000 |
|
EBITDA margin |
-37.7% |
-8.7% |
13.1% |
20.4% |
23.8% |
|
Depreciation |
(742 500) |
(742 500) |
(742 500) |
(742 500) |
(742 500) |
|
Interest |
(1 550 000) |
(1 550 000) |
(1 550 000) |
(1 550 000) |
(1 412 087) |
|
Taxation |
— |
— |
— |
— |
— |
|
Profit / (loss) after tax |
(3 937 500) |
(3 032 500) |
(490 500) |
1 394 500 |
3 078 413 |
|
Cumulative profit / (deficit) |
(3 937 500) |
(6 970 000) |
(7 460 500) |
(6 066 000) |
(2 987 587) |
|
Cash generated from operations |
(3 474 173) |
(2 677 024) |
(171 000) |
1 764 778 |
3 473 570 |
|
Heifer purchases |
— |
(3 200 000) |
(3 200 000) |
(2 000 000) |
— |
|
Debt capital repaid |
— |
— |
— |
(889 761) |
(1 027 674) |
|
Closing cash |
10 970 827 |
5 093 803 |
1 722 803 |
597 820 |
3 043 716 |
|
Biological assets at cost |
4 000 000 |
7 200 000 |
10 400 000 |
12 400 000 |
12 400 000 |
|
Property, plant and equipment |
8 157 500 |
7 415 000 |
6 672 500 |
5 930 000 |
5 187 500 |
|
Total assets |
23 901 719 |
21 131 329 |
20 867 925 |
21 574 527 |
23 815 457 |
|
Term debt outstanding |
10 000 000 |
10 000 000 |
10 000 000 |
9 110 239 |
8 082 565 |
|
Total equity |
13 407 500 |
10 375 000 |
9 884 500 |
11 279 000 |
14 357 413 |
|
Debt service cover |
-1.06x |
-0.48x |
1.16x |
1.51x |
2.14x |
|
Cost per litre, KES |
68.2 |
51.5 |
44.4 |
41.4 |
39.4 |
|
Feed as % of milk revenue |
71.0% |
62.4% |
56.1% |
54.6% |
53.2% |