Balanced · 0.00Solved in your browser · 9-item circular group converged in 4 iterations
Nothing here is savedThis model runs entirely in your browser. No account exists, nothing is sent to us, and nothing is stored. Any changes you make can be carried into a workspace if you decide to sign up.
Revenue
54,300
FY27F
EBITDA
8,443
FY27F
Net profit
3,796
FY27F
Closing cash
4,705
FY27F
Net debt / EBITDA
0.57x
FY27F
Assumptions
The only editable numbers. Everything else is derived, so the statements cannot be made to stop reconciling. Change one and watch them move.
| Driver | FY25A | FY26B | FY27F |
|---|---|---|---|
| Gross margin | |||
| Operating expenses | |||
| Depreciation charge | |||
| Capital expenditure | |||
| Term debt repayment | |||
| Dividends declared | |||
| Tax rate | |||
| Receivable days | |||
| Inventory days | |||
| Payable days | |||
| Accrual days | |||
| Term debt rate | |||
| Revolver rate | |||
| Minimum cash | |||
| Revolver facility limit | |||
| Revenue | |||
| Share capital |
Integrity checks
| Balance sheet ties | Pass |
| Cash flow reconciles to balance sheet | Pass |
| Cash never below the minimum | Pass |
| Fixed assets never negative | Pass |
Income statement
| $'000 | FY25A | FY26B | FY27F |
|---|---|---|---|
| Revenue | 42,900 | 48,200 | 54,300 |
| Cost of sales | (26,169) | (28,920) | (32,037) |
| Gross profit | 16,731 | 19,280 | 22,263 |
| Operating expenses | (11,480) | (12,450) | (13,820) |
| EBITDA | 5,251 | 6,830 | 8,443 |
| Depreciation & amortisation | (1,760) | (1,940) | (2,180) |
| EBIT | 3,491 | 4,890 | 6,263 |
| Net finance cost | (1,160) | (1,000) | (840) |
| Profit before tax | 2,331 | 3,890 | 5,423 |
| Tax | (699) | (1,167) | (1,627) |
| Net profit | 1,632 | 2,723 | 3,796 |
Balance sheet
| $'000 | FY25A | FY26B | FY27F |
|---|---|---|---|
| Cash and equivalents | 6,827 | 5,506 | 4,705 |
| Trade receivables | 7,287 | 7,923 | 8,926 |
| Inventory and WIP | 4,660 | 5,150 | 5,705 |
| Total current assets | 18,775 | 18,579 | 19,336 |
| Property, plant & equipment | 21,383 | 22,643 | 24,063 |
| Total assets | 40,158 | 41,222 | 43,399 |
| Trade payables | 5,664 | 6,259 | 6,934 |
| Accruals | 1,730 | 1,876 | 2,082 |
| Term borrowings | 13,500 | 11,500 | 9,500 |
| Revolving credit facility | — | — | — |
| Total liabilities | 20,894 | 19,635 | 18,517 |
| Share capital | 8,000 | 8,000 | 8,000 |
| Retained earnings | 11,264 | 13,587 | 16,883 |
| Total equity | 19,264 | 21,587 | 24,883 |
| Total liabilities & equity | 40,158 | 41,222 | 43,399 |
Cash flow statement
| $'000 | FY25A | FY26B | FY27F |
|---|---|---|---|
| Net profit | 1,632 | 2,723 | 3,796 |
| Depreciation & amortisation | 1,760 | 1,940 | 2,180 |
| Change in working capital | (774) | (384) | (677) |
| Cash from operations | 2,618 | 4,279 | 5,299 |
| Capital expenditure | (2,963) | (3,200) | (3,600) |
| Cash from investing | (2,963) | (3,200) | (3,600) |
| Repayment of borrowings | (2,000) | (2,000) | (2,000) |
| Dividends paid | (350) | (400) | (500) |
| Revolver draw / (repayment) | — | — | — |
| Cash from financing | (2,350) | (2,400) | (2,500) |
| Net movement in cash | (2,695) | (1,321) | (801) |
| Opening cash | 9,522 | 6,827 | 5,506 |
| Closing cash | 6,827 | 5,506 | 4,705 |