Tarlton Beetroot Business Plan — Projected Balance Sheet
The balance sheet across the projection, including land, packhouse, irrigation and the net debt position.
Section 24 of 37
Projected Balance Sheet
Jump to section
- i. Important Notice and Basis of Preparation
- 1. Executive Summary
- 2. Investment Thesis
- 3. Company, Structure and Stage of Development
- 4. Customer Problem, Value Proposition and Monetisation
- 5. Products, Portfolio and Unit Economics
- 6. Industry Analysis
- 7. Market Analysis and Sizing
- 8. Customer and Channel Analysis
- 9. Competitive Landscape
- 10. Business Model
- 11. Go-to-Market Strategy
- 12. Operating Model: Agronomy and Production
- 13. Operating Model: Post-Harvest, Packhouse and Logistics
- 14. Water, Energy and Land: The Three Binding Constraints
- 15. Management and Organisation
- 16. Strategic Plan
- 17. SWOT Analysis
- 18. Risk Analysis and Register
- 19. ESG and Development Impact
- 20. Implementation Roadmap
- 21. Financial Assumptions
- 22. Projected Income Statement
- 23. Projected Balance Sheet
- 24. Projected Cash Flow
- 25. Capital Expenditure and Working Capital
- 26. Funding Requirement and Structure
- 27. Break-even Analysis
- 28. Debt Serviceability
- 29. Investment Returns and Valuation
- 30. Sensitivity and Scenario Analysis
- 31. Phase 3: Processing Optionality
- 32. Key Performance Indicators and Management Dashboard
- 33. Conclusion and Investment Recommendation
- A. Appendix A: Monthly Projections, Year 1
- B. Appendix B: Detailed Assumptions Register
- C. Appendix C: Glossary
A land-heavy balance sheet from Year 3, with accumulated losses of R11.6 million still carried at Year 5.
Table 37 Projected balance sheet at each financial year end, R thousand, base case
|
R’000 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|---|---|---|---|---|---|
|
ASSETS |
|||||
|
Cash and cash equivalents |
667 |
0 |
0 |
0 |
0 |
|
Trade receivables |
22 |
106 |
782 |
1 621 |
2 463 |
|
Growing crop (biological asset) |
34 |
145 |
674 |
692 |
922 |
|
VAT receivable |
22 |
47 |
143 |
228 |
308 |
|
Total current assets |
746 |
298 |
1 600 |
2 541 |
3 694 |
|
Property, plant and equipment, net |
2 097 |
1 799 |
17 783 |
16 752 |
14 282 |
|
Land at cost |
0 |
0 |
10 620 |
10 620 |
10 620 |
|
Total non-current assets |
2 097 |
1 799 |
28 403 |
27 372 |
24 902 |
|
Total assets |
2 842 |
2 097 |
30 003 |
29 913 |
28 596 |
|
LIABILITIES |
|||||
|
Trade and other payables |
177 |
374 |
1 144 |
1 826 |
2 470 |
|
Overdraft |
0 |
1 211 |
2 185 |
3 737 |
1 235 |
|
Total current liabilities |
177 |
1 585 |
3 329 |
5 563 |
3 705 |
|
Interest-bearing debt |
551 |
438 |
10 474 |
9 476 |
8 298 |
|
Deferred tax liability |
244 |
357 |
2 473 |
3 405 |
3 782 |
|
Total liabilities |
972 |
2 379 |
16 276 |
18 444 |
15 785 |
|
EQUITY |
|||||
|
Share capital |
3 950 |
3 950 |
24 450 |
24 450 |
24 450 |
|
Accumulated loss |
(2 079) |
(4 233) |
(10 723) |
(12 981) |
(11 639) |
|
Total equity |
1 871 |
(283) |
13 727 |
11 469 |
12 811 |
|
Total equity and liabilities |
2 842 |
2 097 |
30 003 |
29 913 |
28 596 |
|
Balance check |
0.00 |
-0.00 |
0.00 |
-0.00 |
0.00 |
The model is built monthly and iterated to convergence. The balance sheet balances to less than one rand in all 60 months, in each of the base, downside and stress cases.
Two features of this balance sheet deserve comment. First, cash is nil at every year end from Year 2 onward, because the model sweeps surplus cash against the overdraft and draws on it when short; the overdraft balance is therefore the correct measure of liquidity, and it peaks at R3.74 million at the Year 4 close. Second, equity at Year 5 is R12.8 million against R24.45 million of capital subscribed, the difference being R11.6 million of accumulated losses. An investor is subscribing for shares in a company that will not have recovered its accumulated deficit by the end of the plan period.
24