Aadam

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
Year 1 Revenue: GHS 7,560kYear 1 EBITDA: GHS 1,875kYear 1 Free cash flow: GHS 437kYear 2 Revenue: GHS 8,981kYear 2 EBITDA: GHS 2,394kYear 2 Free cash flow: GHS 901kYear 3 Revenue: GHS 10,670kYear 3 EBITDA: GHS 3,021kYear 3 Free cash flow: GHS 1,469kYear 4 Revenue: GHS 12,676kYear 4 EBITDA: GHS 3,775kYear 4 Free cash flow: GHS 2,129kYear 5 Revenue: GHS 15,059kYear 5 EBITDA: GHS 4,683kYear 5 Free cash flow: GHS 2,898k
Year 1Year 2Year 3Year 4Year 5
RevenueEBITDAFree cash flow
GHS thousandsYear 1Year 2Year 3Year 4Year 5
Revenue7,5608,98110,67012,67615,059
Cost of goods sold(4,385)(5,209)(6,188)(7,352)(8,734)
Gross profit3,1753,7724,4815,3246,325
Operating costs(1,300)(1,378)(1,461)(1,548)(1,641)
EBITDA1,8752,3943,0213,7754,683
Depreciation(406)(462)(519)(575)(631)
EBIT1,4691,9322,5023,2004,052
Interest(720)(576)(432)(288)(144)
Profit before tax7491,3562,0702,9123,908
Tax(187)(339)(517)(728)(977)
Net income5621,0171,5522,1842,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.