Lab / Three-statement model
Harmattan Foods LtdAn illustrative company. Not a client, not real numbers.
The kind of model I build for lenders and investors: five years of income statement, balance sheet and cash flow, linked so a change anywhere flows everywhere. Move an assumption or apply a shock and watch the covenant.
Stress it
Assets equal liabilities plus equity in all five years.
Lowest DSCR 1.28x: above the 1.25x covenant.
- Revenue, year 5
- GHS 15.1m
- EBITDA margin, year 5
- 31.1%
- Cash, year 5
- GHS 5.4m
- Revolver drawn, peak
- GHS 0.0m
| GHS thousands | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Revenue | 7,560 | 8,981 | 10,670 | 12,676 | 15,059 |
| Cost of goods sold | (4,385) | (5,209) | (6,188) | (7,352) | (8,734) |
| Gross profit | 3,175 | 3,772 | 4,481 | 5,324 | 6,325 |
| Operating costs | (1,300) | (1,378) | (1,461) | (1,548) | (1,641) |
| EBITDA | 1,875 | 2,394 | 3,021 | 3,775 | 4,683 |
| Depreciation | (406) | (462) | (519) | (575) | (631) |
| EBIT | 1,469 | 1,932 | 2,502 | 3,200 | 4,052 |
| Interest | (720) | (576) | (432) | (288) | (144) |
| Profit before tax | 749 | 1,356 | 2,070 | 2,912 | 3,908 |
| Tax | (187) | (339) | (517) | (728) | (977) |
| Net income | 562 | 1,017 | 1,552 | 2,184 | 2,931 |
How the statements link
Net income closes into retained earnings. Depreciation and the change in working capital turn profit into operating cash. The cash flow statement explains, line by line, why cash moved.
Why it always balances
Cash is not typed in; it is the end of the cash flow. When cash would fall below the minimum a revolver draws, and it is repaid first when cash recovers. Interest runs on opening balances, so there is no circular reference.
What the covenant tells you
DSCR is cash available for debt service over interest plus principal. Lenders often want 1.25x or more. Here the base case clears it in year 1 with little room, and any single shock breaks it.