EBITDA 229 288 264 288 297 200 212 329 331 238 348 365 ...
Income Statement Summary ($'000) - FY2021
Income Statement
Last Year Comparison
Year to Date Comparison
Month Type
Coco Bix Sales Just Wrong Sales Nutri Bubbles Sales Revenue
Cost of Goods Sold Gross Margin Gross Margin (%)
Salaries & Wages Television & Media Advertising Other Operating Expenditure
Other Revenue & Expenses Net Operating Expenses EBITDA EBITDA / Revenue (%) Depreciation & Amortisation EBIT EBIT / Revenue (%) Net Interest Expense Net Profit Before Tax NPBT / Revenue (%) Tax Expense Net Profit After Tax NPAT / Revenue (%)
Jan 21 Historical
835 723 556 2,114
(1,586) 529
25.0%
(168) (63) (68) (299)
(1) (300) 229 10.8%
(72) 157 7.4% (32) 125 5.9% (50)
75 3.5%
Feb 21 Historical
944 818 630 2,392
(1,794) 598
25.0%
(168) (71) (70) (309)
(1) (310) 288 12.0%
(72) 215 9.0% (32) 183 7.7% (73) 110 4.6%
Mar 21 Historical
900 780 600 2,281
(1,711) 570
25.0%
(168) (68) (69) (305)
(1) (306) 264 11.6%
(73) 191 8.4% (32) 159 7.0% (64)
95 4.2%
Apr 21 Historical
944 818 630 2,392
(1,794) 598
25.0%
(168) (71) (70) (309)
(1) (310) 288 12.0%
(73) 215 9.0% (31) 183 7.7% (73) 110 4.6%
May 21 Historical
961 833 641 2,434
(1,826) 609
25.0%
(168) (72) (71) (311)
(1) (312) 297 12.2%
(74) 223 9.2% (31) 192 7.9% (77) 115 4.7%
Jun 21 Historical
780 676 520 1,975
(1,481) 494
25.0%
(168) (59) (67) (293)
(1) (294) 200 10.1%
(74) 126 6.4% (31)
95 4.8%
(38) 57 2.9%
Jul 21 Forecast
804 696 536 2,036
(1,527) 509
25.0%
(168) (59) (69) (296)
(296) 212 10.4%
(63) 149 7.3% (30) 119 5.8% (36)
83 4.1%
Aug 21 Forecast
1,016 881 677
2,574
(1,930) 643
25.0%
(168) (75) (74) (317)
3 (314) 329 12.8%
(64) 266 10.3% (31) 235 9.1% (70) 164 6.4%
Sep 21 Forecast
1,033 895 689
2,617
(1,963) 654
25.0%
(168) (76) (75) (319)
(5) (323) 331 12.6%
(64) 267 10.2% (31) 236 9.0% (71) 165 6.3%
Oct 21 Forecast
861 746 574 2,181
(1,636) 545
25.0%
(168) (64) (71) (302)
(5) (307) 238 10.9%
(64) 174 8.0% (31) 143 6.5% (43) 100 4.6%
Nov 21 Forecast
1,068 925 712
2,705
(2,028) 676
25.0%
(168) (79) (76) (322)
(6) (328) 348 12.9%
(65) 284 10.5% (31) 253 9.4% (76) 177 6.5%
Dec 21 Forecast
1,091 945 727
2,763
(2,072) 691
25.0%
(168) (80) (76) (324)
(1) (325) 365 13.2%
(65) 300 10.9% (31) 269 9.7% (81) 188 6.8%
FY2021 Projected
11,236 9,738 7,491 28,465
(21,348) 7,116 25.0%
(2,013) (838) (857)
(3,708)
(19) (3,727) 3,390 11.9%
(823) 2,567 9.0%
(376) 2,191 7.7%
(751) 1,440 5.1%
FY2020 Historical
9,983 8,652 6,655 25,289
(18,967) 6,322 25.0%
(1,830) (770) (796)
(3,396)
(10) (3,407) 2,916 11.5%
(836) 2,080 8.2%
(397) 1,683 6.7%
(673) 1,010 4.0%
Change +/-
1,254 1,086
836 3,176
(2,382) 794
0.0%
(183) (68) (61) (311)
(9) (320) 474 0.4%
13 487 0.8%
21 508 1.0% (78) 430 1.1%
Change %
12.6% 12.6% 12.6% 12.6%
12.6% 12.6% 0.0%
10.0% 8.8% 7.6% 9.2%
82.2% 9.4%
16.3% 3.3% (1.6%) 23.4% 9.7% (5.2%) 30.2% 15.7% 11.5% 42.6% 26.7%
YTD Historical
5,364 4,649 3,576 13,589
(10,192) 3,397 25%
(1,007) (404) (416)
(1,827)
(5) (1,832) 1,565
12% (438) 1,127 8% (190) 937 7% (375) 562 4%
Last Year Historical
4,876 4,226 3,251 12,354
(9,265) 3,088 25%
(915) (376) (395) (1,687)
(5) (1,692) 1,397
11% (411) 985 8% (203) 782 6% (313) 469 4%
Change +/-
488 423 325 1,235
(927) 309 (0%)
(92) (28) (21) (140)
(0) (140) 168 0%
(26) 142 0%
13 155 1% (62)
93 0%
Change %
10.0% 10.0% 10.0% 10.0%
10.0% 10.0% (0.0%)
10.0% 7.5% 5.2% 8.3%
1.0% 8.3% 12.1% 1.9% 6.4% 14.4% 4.0% (6.4%) 19.8% 8.9% 19.8% 19.8% 8.9%
Quarterly Performance
March Quarter
June Quarter
September Quarter
December Quarter
Net Profit After Tax - FY2021
Year / Change Revenue Cost of Goods Sold Gross Margin Operating Expenditure Other Revenue & Expenses Net Operating Expenses EBITDA Depreciation & Amortisation EBIT Net Interest Expense Net Profit Before Tax Tax Expense Net Profit After Tax
FY2021 6,788 (5,091) 1,697 (913) (3) (916) 781 (217) 564 (97) 467 (187) 280
Last Year Change %
6,171
10.0%
(4,628)
10.0%
1,543
10.0%
(843)
8.3%
(3)
1.0%
(846)
8.3%
697
12.1%
(204)
6.4%
493
14.4%
(103)
(6.2%)
390
19.8%
(156)
19.8%
234
19.8%
FY2021 6,801 (5,101) 1,700 (914) (3) (916) 784 (221) 563 (94) 470 (188) 282
Last Year Change %
6,183
10.0%
(4,637)
10.0%
1,546
10.0%
(844)
8.3%
(3)
1.0%
(846)
8.3%
700
12.1%
(207)
6.4%
492
14.4%
(100)
(6.6%)
392
19.8%
(157)
19.8%
235
19.8%
FY2021 7,227 (5,420) 1,807 (932) (2) (934) 873 (191) 682 (93) 589 (177) 412
Last Year Change %
6,284
15.0%
(4,713)
15.0%
1,571
15.0%
(848)
10.0%
(3) (30.8%)
(850)
9.9%
721
21.0%
(211)
(9.4%)
510
33.6%
(97)
(4.6%)
413
42.6%
(165)
7.0%
248
66.4%
FY2021 7,649 (5,736) 1,912 (948) (12) (960) 952 (194) 758 (93) 665 (199) 465
Last Year Change %
6,651
15.0%
(4,988)
15.0%
1,663
15.0%
(862)
10.0%
(3) 357.7%
(865)
11.0%
798
19.3%
(214)
(9.2%)
584
29.7%
(96)
(3.3%)
488
36.2%
(195)
2.2%
293
58.9%
FY2021
Last Year
Next Year 250
200
150
100
50
Jan 21-H
Feb 21-H
Mar 21-H
Apr 21-H
May 21-H
Jun 21-H
Jul 21-F
Aug 21-F
Sep 21-F
Oct 21-F
Nov 21-F
Dec 21-F
Revenue Summary - FY2021
3,500
Coco Bix Sales Nutri Bubbles Sales Next Year
Just Wrong Sales Last Year
3,000
2,500
2,000
1,500
1,000
500
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
12,000 10,000
8,000 6,000 4,000 2,000
-
Revenue Depth - FY2021
Coco Bix Sales Just Wrong Sales Nutri Bubbles Sales
Expenses Summary
Salaries & Wages Other Next Year
400
Television & Media Advertising Last Year
350
300
250
200
150
100
50
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
2,500 2,000 1,500 1,000
500 -
Expenses Depth - FY2021
Salaries & Wages Television & Media Advertising Other
Page 1 of 5
Balance Sheet Summary ($'000) - FY2021
Balance Sheet
June 2021 vs Prior Year
Month Type Cash Debtors Inventory Other Current Assets Current Assets Fixed Assets Intangible Assets Deferred Tax Assets Other Non-Current Assets Non-Current Assets Total Assets Accounts Payable Corporate Tax Payable Interest Payable Dividends Payable Other Current Liabilities Current Liabilities Debt Deferred Tax Liabilities Other Non-Current Liabilities Non-Current Liabilities Total Liabilities Net Assets Ordinary Equity Other Equity Retained Profits Total Equity
Jan 21 Historical
1,778 2,046 2,732
485 7,042 7,078 2,605
2 580 10,264 17,307 2,449 451
16 2,915 5,506 100 253 5,859 8,774 8,533 1,110 26 7,397 8,533
Feb 21 Historical
1,799 2,392 2,548
485 7,225 7,097 2,587
2 580 10,266 17,490 2,449 524
16 2,989 5,506 100 253 5,859 8,848 8,642 1,110 26 7,506 8,642
Mar 21 Historical
1,901 2,207 2,678
485 7,271 7,116 2,568
2 580 10,266 17,538 2,436 588
16 3,040 5,407 100 253 5,760 8,800 8,738 1,110 26 7,602 8,738
Apr 21 Historical
1,934 2,392 2,517
485 7,329 7,134 2,550
2 580 10,267 17,596 2,311 661
16 2,988 5,407 100 253 5,760 8,748 8,848 1,110 26 7,712 8,848
May 21 Historical
2,250 2,356 2,188
485 7,279 7,153 2,532
2 580 10,267 17,546 2,069 738
16 2,822 5,407 100 253 5,760 8,583 8,963 1,110 26 7,827 8,963
Jun 21 Historical
2,234 1,975 2,294
485 6,989 7,170 2,514
2 580 10,267 17,256 2,143 415
16 2,574 5,309 100 253 5,662 8,236 9,020 1,110 26 7,884 9,020
Jul 21 Forecast
1,883 1,970 2,846
485 7,185 7,186 2,500
2 583 10,272 17,457 2,629
36 -
17 2,682 5,316
100 254 5,670 8,351 9,106 1,110
29 7,967 9,106
Aug 21 Forecast
1,583 2,491 2,755
482 7,310 7,214 2,486
2 591 10,293 17,604 2,539 106
18 2,664 5,318 100 249 5,667 8,331 9,273 1,110 31 8,131 9,273
Sep 21 Forecast
1,815 2,617 2,583
489 7,504 7,222 2,472
2 591 10,288 17,792 2,490 177
20 2,687 5,320 100 244 5,664 8,351 9,440 1,110 34 8,296 9,440
Oct 21 Forecast
2,063 2,111 3,031
488 7,693 7,252 2,458
2 584 10,296 17,990 2,713
43 -
21 2,776 5,327
100 249 5,676 8,452 9,537 1,110
31 8,396 9,537
Nov 21 Forecast
1,816 2,705 2,896
473 7,889 7,277 2,444
2 581 10,306 18,194 2,674 119
23 2,815 5,327 100 241 5,668 8,483 9,712 1,110 29 8,573 9,712
Dec 21 Forecast
2,129 2,674 2,855
464 8,122 7,302 2,445
2 572 10,321 18,444 2,702 199
94 24 3,020 5,284 100 231 5,616 8,636 9,808 1,110 31 8,667 9,808
Jun 21 Historical
2,234 1,975 2,294
485 6,989 7,170 2,514
2 580 10,267 17,256 2,143 415
16 2,574 5,309 100 253 5,662 8,236 9,020 1,110 26 7,884 9,020
Jun 20 Historical
2,282 1,796 2,004
473 6,554 6,947 2,732
2 580 10,260 16,813 2,028 353
30 2,411 5,651 100 241 5,992 8,403 8,410 1,120 9 7,281 8,410
Change +/(48) 180 291 13 435 224
(218) 1 0 7
442 116
62 -
(15) 163 (342)
12 (330) (167) 610 (10) 17 603 610
Change %
(2.1%) 10.0% 14.5%
2.7% 6.6% 3.2% (8.0%) 35.2% 0.0% 0.1% 2.6% 5.7% 17.6%
N/A N/A (48.3%) 6.8% (6.1%)
4.9% (5.5%) (2.0%) 7.3% (0.9%) 188.9% 8.3% 7.3%
(400) (200)
(47.7) -
(217.5) -
(14.7) -
(342.2) -
(330.4) (167.3)
(10.0)
-
-
200 400 600 800
179.6 290.7
12.9 435.4 223.7
0.6 0.2 7.0 442.5 115.7 62.0
163.0 11.8 609.8 17.0 602.8 609.8
Current Ratio (x) Quick Ratio (x) Cash Ratio (x) Debt / Total Assets (%) Debt / Total Equity (%)
2.42x 1.31x 0.61x 31.8% 64.5%
2.42x 1.40x 0.60x 31.5% 63.7%
2.39x 1.35x 0.63x 30.8% 61.9%
2.45x 1.45x 0.65x 30.7% 61.1%
2.58x 1.63x 0.80x 30.8% 60.3%
2.72x 1.64x 0.87x 30.8% 58.9%
2.68x 1.44x 0.70x 30.5% 58.4%
20,000
Net Assets - FY2021
Assets Last Year
Liabilities Next Year
Net Assets
15,000
10,000
5,000
0
-5,000
-10,000
-15,000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
20,000 18,000 16,000 14,000 12,000 10,000
8,000 6,000 4,000 2,000
-
Net Assets Reconciliation - June 2021
2.74x 1.53x 0.59x 30.2% 57.4%
2.79x 1.65x 0.68x 29.9% 56.4%
2.77x 1.50x 0.74x 29.6% 55.9%
2.80x 1.61x 0.64x 29.3% 54.9%
2.69x 1.59x 0.70x 28.7% 53.9%
Balance Sheet Components - June 2021
Non-Current Liabilities, 5,661.8
Other Current Liabilities, 430.8
Cash, 2,234.2
Debtors, 1,975.1
Inventory, 2,294.3
Accounts Payable, 2,143.4
Other Assets, 10,752.1
Current Assets - FY2021
12,000 10,000
8,000 6,000 4,000 2,000
-
14,000 12,000 10,000
8,000 6,000 4,000 2,000
-
Cash
Debtors
Inventory
Other Current Assets
Last Year
Next Year
Jan 21-H
Feb 21-H
Mar 21-H
Ordinary Equity
Apr 21-H
May 21-H
Jun 21-H
Jul 21-F
Equity - FY2021
Aug 21-F
Sep 21-F
Oct 21-F
Nov 21-F
Dec 21-F
Other Equity
Retained Profits
Last Year
Next Year
Jan 21-H
Feb 21-H
Mar 21-H
Apr 21-H
May 21-H
Jun 21-H
Jul 21-F
Aug 21-F
Sep 21-F
Oct 21-F
Nov 21-F
Dec 21-F
Page 2 of 5
Cash Flow Statement Summary ($'000) - FY2021
Month Type Revenue Decrease in Debtors Other Cash Receipts Cash Receipts Cost of Goods Sold Operating Expenditure Decrease in Inventory Increase in Creditors Increase in Inventory Payables Other Cash Payments Cash Payments Interest on Cash Interest Paid Corporate Tax Paid Other Operating Cash Flows Operating Cash Flows Fixed Assets Capital Expenditure Intangibles Capital Expenditure Other Investing Cash Flows Investing Cash Flows Debt Drawdowns Debt Repayments Ordinary Equity Raisings Ordinary Equity Buybacks Ordinary Equity Dividends Paid Other Financing Cash Flows Financing Cash Flows Change in Cash Held
Cash Flow Statement
Jan 21 Historical
2,114 235 4
2,353 (1,586)
(299) (351)
(9) 260
(5) (1,989)
2 (34)
(0) (0) 332 (74) 0
(74)
(500) (500) (241)
Feb 21 Historical
2,392 (346) 4
2,050 (1,794)
(309) 184
16 (15)
(5) (1,924)
2 (34)
0 (0) 94 (74) (0)
(74)
0 0 20
Mar 21 Historical
2,281 185 4
2,470 (1,711)
(305) (129)
(11) (2) (5)
(2,164) 2
(34) 0 0
274 (74)
0 (74) 2 (100) (0) (98) 102
Apr 21 Historical
2,392 (185) 4
2,212 (1,794)
(309) 161
5 (131)
(5) (2,073)
2 (34)
(0) 0 107 (74) (0) (74) 0 0 34
May 21 Historical
2,434 37 4
2,475 (1,826)
(311) 329
(2) (240)
(5) (2,055)
2 (34)
0 (0) 389 (74) 0
(74)
0 0 315
Jun 21 Historical
1,975 380 4
2,360 (1,481)
(293) (106)
(9) 84 (5) (1,811)
3 (34) (361)
157 (74)
0 (74) 2 (100) (0) (98) (15)
Jul 21 Forecast
2,036 5 2
2,043 (1,527)
(296) (552)
12 474
(1) (1,891)
3 (33) (415)
0 (293)
(65) -
(3) (69)
7 4 11 (351)
Aug 21 Forecast
2,574 (521) 4
2,057 (1,930)
(317) 92 13
(103) 1
(2,245) 2
(33) 3
(216) (77) (8) (85) 2 (2) 0
(300)
Sep 21 Forecast
2,617 (127) 3
2,494 (1,963)
(319) 172
9 (58)
(6) (2,165)
2 (33)
(8) 290 (58)
(0) (59) 2
(2) (0) 231
Oct 21 Forecast
2,181 507 1
2,689 (1,636)
(302) (449)
(15) 238
(6) (2,170)
2 (33) (177)
1 312 (81)
8 (73) 7 2 9 249
Nov 21 Forecast
2,705 (594) 3
2,114 (2,028)
(322) 136
18 (56)
(7) (2,260)
3 (33)
15 (162) (76)
2 (74) 0 (12) (11) (248)
Dec 21 Forecast
2,763 31 1
2,795 (2,072)
(324) 40 (6) 34 (0)
(2,328) 2
(33) 9
444 (76) (15)
9 (81)
7 (50)
(7) (50) 313
FY2021 Projected
28,465 (393) 41
28,113 (21,348)
(3,708) (473) 20 485 (51)
(25,077) 28
(404) (953)
21 1,729
(874) (15) 8
(881) 29
(250) -
(500) (17)
(739) 109
Cash 2,020 28,465
(393) 41
28,113 (21,348)
(3,708) (473) 20 485 (51)
(25,077) 28
(404) (953)
21 1,729
(874) (15) 8
(881) 29
(250) -
(500) (17)
(739) 2,129
Cashcade
5,000
10,000 15,000 20,000
25,000 30,000 35,000
Operating Cash Flows - FY2021
Cash Receipts Other Operating Cash Flows
Cash Payments Operating Cash Flows
4,000
3,000
2,000
1,000
-
(1,000)
(2,000)
(3,000) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
Working Capital Management - FY2021
1,000
Decrease in Debtors Increase in Creditors
Decrease in Inventory Increase in Inventory Payables
800
600
400
200
-
(200)
(400)
(600)
(800) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
Investing & Financing Cash Flows - FY2021
Cash Monitor - FY2021
Investing Cash Flows
Financing Cash Flows
100
Change in Cash Held
Closing Cash
2,500
(100) (200) (300) (400) (500)
2,000 1,500 1,000 500 -
(600) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
(500) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
Page 3 of 5
Month Type Revenue Cost of Goods Sold Gross Margin Gross Margin (%) Operating Expenditure Other Revenue & Expenses Net Operating Expenses EBITDA EBITDA / Revenue (%) Depreciation & Amortisation EBIT EBIT / Revenue (%) Net Interest Expense Net Profit Before Tax NPBT / Revenue (%) Tax Expense Net Profit After Tax NPAT / Revenue (%)
Month Revenue Cost of Goods Sold Gross Margin Gross Margin (%) Operating Expenditure Other Revenue & Expenses Net Operating Expenses EBITDA EBITDA / Revenue (%) Depreciation & Amortisation EBIT EBIT / Revenue (%) Net Interest Expense Net Profit Before Tax NPBT / Revenue (%) Tax Expense Net Profit After Tax NPAT / Revenue (%)
Month Revenue Cost of Goods Sold Gross Margin Operating Expenditure Other Revenue & Expenses Net Operating Expenses EBITDA Depreciation & Amortisation EBIT Net Interest Expense Net Profit Before Tax Tax Expense Net Profit After Tax
Gross Margin (+/-%) EBITDA (+/-%) EBIT (+/-%) Net Profit Before Tax (+/-%) Net Profit After Tax (+/-%)
Budget Income Statement Summary ($'000) - FY2021
Projected Income Statement
Jan 21 Historical
2,114 (1,586)
529 25.0%
(299) (1)
(300) 229 10.8% (72) 157 7.4% (32) 125 5.9% (50)
75 3.5%
Feb 21 Historical
2,392 (1,794)
598 25.0%
(309) (1)
(310) 288 12.0% (72) 215 9.0% (32) 183 7.7% (73) 110 4.6%
Mar 21 Historical
2,281 (1,711)
570 25.0%
(305) (1)
(306) 264 11.6% (73) 191 8.4% (32) 159 7.0% (64)
95 4.2%
Apr 21 Historical
2,392 (1,794)
598 25.0%
(309) (1)
(310) 288 12.0% (73) 215 9.0% (31) 183 7.7% (73) 110 4.6%
May 21 Historical
2,434 (1,826)
609 25.0%
(311) (1)
(312) 297 12.2% (74) 223 9.2% (31) 192 7.9% (77) 115 4.7%
Jun 21 Historical
1,975 (1,481)
494 25.0%
(293) (1)
(294) 200 10.1% (74) 126 6.4% (31)
95 4.8%
(38) 57 2.9%
Jul 21 Forecast
2,036 (1,527)
509 25.0%
(296) -
(296) 212 10.4% (63) 149 7.3% (30) 119 5.8% (36)
83 4.1%
Aug 21 Forecast
2,574 (1,930)
643 25.0%
(317) 3
(314) 329 12.8% (64) 266 10.3% (31) 235 9.1% (70) 164 6.4%
Sep 21 Forecast
2,617 (1,963)
654 25.0%
(319) (5)
(323) 331 12.6% (64) 267 10.2% (31) 236 9.0% (71) 165 6.3%
Oct 21 Forecast
2,181 (1,636)
545 25.0%
(302) (5)
(307) 238 10.9% (64) 174 8.0% (31) 143 6.5% (43) 100 4.6%
Nov 21 Forecast
2,705 (2,028)
676 25.0%
(322) (6)
(328) 348 12.9% (65) 284 10.5% (31) 253 9.4% (76) 177 6.5%
Dec 21 Forecast
2,763 (2,072)
691 25.0%
(324) (1)
(325) 365 13.2% (65) 300 10.9% (31) 269 9.7% (81) 188 6.8%
Total Projected
28,465 (21,348)
7,116 25.0% (3,708)
(19) (3,727) 3,390 11.9%
(823) 2,567 9.0%
(376) 2,191 7.7%
(751) 1,440 5.1%
Budget Income Statement
Jan 21 2,153 (1,614) 538
25.0% (300) (0) (301) 237
11.0% (63) 174
8.1% (32) 142
6.6% (43) 100
4.6%
Feb 21 2,436 (1,827) 609
25.0% (311) (1) (312) 297
12.2% (63) 234
9.6% (33) 201
8.3% (60) 141
5.8%
Mar 21 2,323 (1,742) 581
25.0% (307) (1) (308) 273
11.8% (64) 209
9.0% (33) 176
7.6% (53) 123
5.3%
Apr 21 2,436 (1,827) 609
25.0% (311) (6) (318) 291
12.0% (64) 227
9.3% (33) 195
8.0% (58) 136
5.6%
May 21 2,478 (1,859) 620 25.0% (313) (4) (317) 303 12.2% (64) 238 9.6% (33) 206 8.3% (62) 144 5.8%
Jun 21 2,011 (1,508) 503 25.0% (295) (0) (295) 207 10.3% (65) 143 7.1% (32) 111 5.5% (33) 77 3.8%
Jul 21 1,983 (1,487)
496 25.0%
(294) -
(294) 202 10.2% (65) 137 6.9% (32) 105 5.3% (32)
74 3.7%
Variance (Projected vs. Budget)
Aug 21 2,507 (1,880) 627 25.0% (314) 3 (311) 315 12.6% (65) 250 10.0% (32) 218 8.7% (65) 152 6.1%
Sep 21 2,549 (1,912) 637 25.0% (316) (5) (321) 317 12.4% (66) 251 9.8% (33) 218 8.6% (66) 153 6.0%
Oct 21 2,124 (1,593) 531 25.0% (299) (5) (305) 226 10.7% (66) 160 7.5% (32) 128 6.0% (38) 90 4.2%
Nov 21 2,634 (1,976) 659 25.0% (319) (6) (325) 334 12.7% (66) 267 10.1% (32) 235 8.9% (71) 165 6.3%
Dec 21 2,691 (2,018) 673 25.0% (321) (1) (322) 350 13.0% (67) 284 10.5% (32) 251 9.3% (75) 176 6.5%
Total 28,324 (21,243)
7,081 25.0% (3,702)
(26) (3,728) 3,353 11.8%
(778) 2,575 9.1%
(388) 2,186 7.7%
(656) 1,530 5.4%
Jan 21 (38) 29 (10) 2 (0) 1 (8) (9) (17) (0) (18) (7) (25)
(1.8%) (3.5%) (10.0%) (12.3%) (24.8%)
Feb 21 (43) 33 (11) 2 (0) 2 (9) (9) (18) 0 (18) (13) (31)
(1.8%) (3.1%) (7.8%) (8.9%) (21.9%)
Mar 21 (41) 31 (10) 2 (0) 2 (9) (9) (18) 1 (17) (11) (28)
(1.8%) (3.2%) (8.5%) (9.8%) (22.7%)
Apr 21 (43) 33 (11) 2 5 7 (3) (9) (13) 1 (11) (15) (26)
(1.8%) (1.2%) (5.5%) (5.9%) (19.3%)
May 21 (44) 33 (11) 2 3 5 (6) (9) (15) 1 (14) (15) (29)
(1.8%) (2.0%) (6.4%) (6.7%) (20.1%)
Jun 21 (36) 27 (9) 2 (0) 1 (8) (9) (17) 1 (16) (5) (21)
(1.8%) (3.8%) (12.0%) (14.3%) (26.6%)
Jul 21 53 (40) 13 (3) (3) 11 2 12 1 14 (4) 10
2.7% 5.2% 9.0% 12.9% 12.9%
Aug 21 67 (50) 17 (3) (3) 14 2 16 1 17 (5) 12
2.7% 4.4% 6.3% 7.8% 7.8%
Sep 21 68 (51) 17 (3) (3) 14 2 16 1 17 (5) 12
2.7% 4.5% 6.3% 7.9% 7.9%
Oct 21 57 (43) 14 (3) (3) 11 2 13 1 15 (4) 10
2.7% 5.1% 8.2% 11.3% 11.3%
Nov 21 71 (53) 18 (3) (3) 15 2 16 1 18 (5) 12
2.7% 4.4% 6.2% 7.6% 7.6%
Dec 21 72 (54) 18 (3) (3) 15 2 17 1 18 (5) 13
2.7% 4.3% 5.9% 7.2% 7.2%
Total 141 (106) 35 (6) 7 1 36 (44) (8) 13 5 (95) (91)
0.5% 1.1% (0.3%) 0.2% (5.9%)
Historical
Revenue Forecast
Budget
3,000
2,000
1,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
Cost of Goods Sold
Historical
Forecast
Budget
2,500 2,000 1,500 1,000 500
-
1
2
3
4
5
6
7
8
9
10
11
12
Gross Margin
Historical
Forecast
Budget
800
600
400
200
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
EBIT
Historical
Forecast
Budget 400
300
200
100
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
Net Profit Before Tax
Historical
Forecast
Budget
300
200
100
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
Net Profit After Tax
Historical
Forecast
Budget
200
150
100
50
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 21-H 21-H 21-H 21-H 21-H 21-H 21-F 21-F 21-F 21-F 21-F 21-F
Page 4 of 5
Scenarios Summary ($'000) - 12 Months to June 2022
Revenue
3,500 3,000 2,500 2,000 1,500 1,000
500 0 Jul 21-F
Aug 21-F
Sep 21-F
Base Case
Funding
IPO
Oct Nov Dec Jan Feb Mar 21-F 21-F 21-F 22-F 22-F 22-F
Apr 22-F
May 22-F
Jun 22-F
Gross Margin
900 800 700 600 500 400 300 200 100
0 Jul 21-F
Aug 21-F
Sep 21-F
Base Case
Oct Nov Dec 21-F 21-F 21-F
Funding
Jan Feb 22-F 22-F
IPO
Mar Apr 22-F 22-F
May 22-F
Jun 22-F
300 250 200 150 100
50 0 Jul 21-F
Aug 21-F
Sep 21-F
Net Profit After Tax
Base Case
Funding
Oct Nov Dec Jan Feb 21-F 21-F 21-F 22-F 22-F
IPO
Mar 22-F
Apr 22-F
May 22-F
Jun 22-F
Net Assets
12,000 10,000
8,000 6,000 4,000 2,000
0 Jul 21-F
Aug 21-F
Sep 21-F
Base Case
Funding
Oct Nov Dec Jan Feb 21-F 21-F 21-F 22-F 22-F
IPO
Mar 22-F
Apr 22-F
May 22-F
Jun 22-F
Cost of Goods Sold
2,500
Base Case
Funding
IPO
2,000
1,500
1,000
500
0 Jul 21-F
Aug 21-F
Sep 21-F
Oct 21-F
Nov 21-F
Dec 21-F
Jan 22-F
Feb 22-F
Mar 22-F
Apr 22-F
May 22-F
Jun 22-F
Net Operating Expenditure
450 400 350 300 250 200 150 100
50 0 Jul 21-F
Aug 21-F
Sep 21-F
Base Case
Oct Nov Dec 21-F 21-F 21-F
Funding
Jan Feb 22-F 22-F
IPO
Mar Apr 22-F 22-F
May 22-F
Jun 22-F
Closing Cash
4,500 4,000 3,500 3,000 2,500 2,000 1,500 1,000
500 0 Jul 21-F
Aug 21-F
Sep 21-F
Base Case
Funding
Oct Nov Dec Jan Feb 21-F 21-F 21-F 22-F 22-F
IPO
Mar 22-F
Apr 22-F
May 22-F
Jun 22-F
Scenario 1 - Base Case
Change in Cash Held
800 600 400 200
0 Jul
-20021-F -400 -600
Aug 21-F
Sep 21-F
Base Case
Oct Nov Dec 21-F 21-F 21-F
Funding
Jan Feb 22-F 22-F
IPO
Mar Apr 22-F 22-F
May 22-F
Jun 22-F
Income Statement Type Revenue Cost of Goods Sold Gross Margin Net Operating Expenditure EBITDA Depreciation & Amortisation EBIT Net Interest Expense Net Profit Before Tax Tax Expense Net Profit After Tax
Jul 21 Forecast
2,036 (1,527)
509 (296) 212
(63) 149 (30) 119 (36)
83
Aug 21 Forecast
2,574 (1,930)
643 (314) 329
(64) 266 (31) 235 (70) 164
Sep 21 Forecast
2,617 (1,963)
654 (323) 331
(64) 267 (31) 236 (71) 165
Oct 21 Forecast
2,181 (1,636)
545 (307) 238
(64) 174 (31) 143 (43) 100
Nov 21 Forecast
2,705 (2,028)
676 (328) 348
(65) 284 (31) 253 (76) 177
Dec 21 Forecast
2,763 (2,072)
691 (325) 365
(65) 300 (31) 269 (81) 188
Jan 22 Forecast
2,431 (1,823)
608 (326) 282
(66) 216 (30) 186 (56) 130
Feb 22 Forecast
2,751 (2,063)
688 (341) 347
(66) 281 (30) 251 (75) 175
Mar 22 Forecast
2,623 (1,967)
656 (340) 316
(66) 250 (31) 219 (66) 154
Apr 22 Forecast
2,751 (2,063)
688 (347) 341
(66) 274 (30) 244 (73) 171
May 22 Forecast
2,799 (2,099)
700 (349) 351
(67) 284 (30) 254 (76) 178
Jun 22 Forecast
2,271 (1,703)
568 (323) 245
(67) 178 (30) 148 (44) 104
Total Forecast
30,503 (22,877)
7,626 (3,920) 3,706
(783) 2,923
(367) 2,556
(767) 1,789
Balance Sheet Type Closing Cash Current Assets Total Assets Total Liabilities Net Assets
Cash Flow Statement Operating Cash Flows Investing Cash Flows Financing Cash Flows Change in Cash Held
Jul 21 Forecast
1,883 7,185 17,457 8,351 9,106
Aug 21 Forecast
1,583 7,310 17,604 8,331 9,273
Sep 21 Forecast
1,815 7,504 17,792 8,351 9,440
Oct 21 Forecast
2,063 7,693 17,990 8,452 9,537
Nov 21 Forecast
1,816 7,889 18,194 8,483 9,712
Dec 21 Forecast
2,129 8,122 18,444 8,636 9,808
Jan 22 Forecast
2,156 8,133 18,449 8,509 9,940
Feb 22 Forecast
2,054 8,374 18,691 8,575 10,116
Mar 22 Forecast
2,537 8,636 18,958 8,689 10,269
Apr 22 Forecast
2,431 8,566 18,865 8,425 10,441
May 22 Forecast
2,847 8,598 18,895 8,274 10,620
Jun 22 Forecast
3,323 8,849 19,139 8,417 10,723
Jun 22 Forecast
3,323 8,849 19,139 8,417 10,723
Jul 21 (293) (69) 11 (351)
Aug 21 (216) (85) 0 (300)
Sep 21 290 (59) (0) 231
Oct 21 312 (73) 9 249
Nov 21 (162) (74) (11) (248)
Dec 21 444 (81) (50) 313
Jan 22 162 (60) (75) 27
Feb 22 (40) (67) 4
(102)
Mar 22 540 (71) 14 483
Apr 22 (62) (44) (0)
(106)
May 22 464 (64) 15 415
Jun 22 581 (60) (44) 476
Total 2,022
(806) (127) 1,089
Scenario 2 - Funding
Income Statement Type Revenue Cost of Goods Sold Gross Margin Net Operating Expenditure EBITDA Depreciation & Amortisation EBIT Net Interest Expense Net Profit Before Tax Tax Expense Net Profit After Tax
Jul 21 Forecast
2,100 (1,554)
546 (306) 240
(63) 177 (30) 146 (44) 102
Aug 21 Forecast
2,654 (1,963)
691 (324) 367
(64) 304 (31) 273 (82) 191
Sep 21 Forecast
2,699 (1,995)
705 (333) 371
(64) 307 (31) 276 (83) 193
Oct 21 Forecast
2,249 (1,661)
588 (317) 271
(64) 207 (31) 176 (53) 123
Nov 21 Forecast
2,789 (2,059)
731 (338) 393
(65) 328 (31) 298 (89) 208
Dec 21 Forecast
2,849 (2,101)
748 (335) 413
(65) 347 (31) 316 (95) 221
Jan 22 Forecast
2,507 (1,848)
659 (336) 323
(66) 258 (30) 228 (68) 159
Feb 22 Forecast
2,837 (2,090)
748 (352) 396
(66) 330 (30) 300 (90) 210
Mar 22 Forecast
2,705 (1,991)
714 (350) 364
(66) 298 (30) 268 (80) 187
Apr 22 Forecast
2,837 (2,087)
750 (358) 393
(66) 326 (30) 296 (89) 207
May 22 Forecast
2,887 (2,122)
765 (360) 405
(67) 338 (30) 308 (93) 216
Jun 22 Forecast
2,342 (1,721)
622 (333) 289
(67) 222 (29) 193 (58) 135
Total Forecast
31,458 (23,191)
8,268 (4,042) 4,225
(783) 3,442
(365) 3,077
(923) 2,154
Balance Sheet Type Closing Cash Current Assets Total Assets Total Liabilities Net Assets
Cash Flow Statement Operating Cash Flows Investing Cash Flows Financing Cash Flows Change in Cash Held
Jul 21 Forecast
1,880 7,291 17,563 8,438 9,125
Aug 21 Forecast
1,582 7,431 17,724 8,406 9,318
Sep 21 Forecast
1,840 7,651 17,938 8,424 9,514
Oct 21 Forecast
2,103 7,843 18,139 8,505 9,635
Nov 21 Forecast
1,883 8,081 18,387 8,547 9,840
Dec 21 Forecast
2,245 8,360 18,682 8,729 9,953
Jan 22 Forecast
2,268 8,358 18,674 8,560 10,114
Feb 22 Forecast
2,201 8,647 18,963 8,639 10,324
Mar 22 Forecast
2,742 8,954 19,276 8,766 10,511
Apr 22 Forecast
2,641 8,892 19,191 8,472 10,719
May 22 Forecast
3,114 8,974 19,271 8,334 10,937
Jun 22 Forecast
3,648 9,269 19,560 8,489 11,071
Jun 22 Forecast
3,648 9,269 19,560 8,489 11,071
Jul 21 (296) (69) 11 (354)
Aug 21 (214) (85) 0 (298)
Sep 21 317 (59) (0) 258
Oct 21 326 (73) 9 263
Nov 21 (134) (74) (11) (220)
Dec 21 493 (81) (50) 362
Jan 22 174 (60) (91) 23
Feb 22 (5)
(67) 4
(67)
Mar 22 598 (71) 14 541
Apr 22 (57) (44) (0)
(101)
May 22 522 (64) 15 473
Jun 22 638 (60) (44) 534
Total 2,363
(806) (143) 1,413
Scenario 3 - IPO
Income Statement Type Revenue Cost of Goods Sold Gross Margin Net Operating Expenditure EBITDA Depreciation & Amortisation EBIT Net Interest Expense Net Profit Before Tax Tax Expense Net Profit After Tax
Jul 21 Forecast
2,253 (1,644)
608 (336) 272
(63) 209 (30) 178 (53) 125
Aug 21 Forecast
2,848 (2,078)
770 (359) 412
(64) 348 (31) 317 (95) 222
Sep 21 Forecast
2,896 (2,111)
785 (368) 417
(64) 353 (31) 321 (96) 225
Oct 21 Forecast
2,414 (1,758)
655 (349) 307
(64) 242 (31) 211 (63) 148
Nov 21 Forecast
2,993 (2,179)
814 (373) 441
(65) 376 (31) 345 (104) 242
Dec 21 Forecast
3,057 (2,224)
833 (371) 462
(65) 397 (31) 366 (110) 256
Jan 22 Forecast
2,690 (1,956)
734 (371) 364
(66) 298 (30) 268 (80) 188
Feb 22 Forecast
3,044 (2,212)
833 (388) 444
(66) 379 (30) 348 (105) 244
Mar 22 Forecast
2,903 (2,107)
795 (386) 409
(66) 343 (30) 313 (94) 219
Apr 22 Forecast
3,044 (2,209)
836 (395) 441
(66) 375 (30) 345 (104) 242
May 22 Forecast
3,098 (2,246)
852 (397) 455
(67) 388 (30) 358 (108) 251
Jun 22 Forecast
2,513 (1,821)
692 (366) 326
(67) 259 (29) 230 (69) 161
Total Forecast
33,754 (24,546)
9,208 (4,459) 4,750
(783) 3,967
(365) 3,602 (1,081) 2,521
Balance Sheet Type Closing Cash Current Assets Total Assets Total Liabilities Net Assets
Cash Flow Statement Operating Cash Flows Investing Cash Flows Financing Cash Flows Change in Cash Held
Jul 21 Forecast
1,865 7,594 17,866 8,718 9,147
Aug 21 Forecast
1,505 7,706 17,999 8,627 9,372
Sep 21 Forecast
1,767 7,928 18,216 8,616 9,600
Oct 21 Forecast
2,052 8,131 18,427 8,682 9,745
Nov 21 Forecast
1,843 8,416 18,722 8,738 9,984
Dec 21 Forecast
2,262 8,746 19,068 8,954 10,114
Jan 22 Forecast
2,279 8,732 19,048 8,744 10,303
Feb 22 Forecast
2,232 9,070 19,387 8,839 10,548
Mar 22 Forecast
2,838 9,423 19,745 8,980 10,766
Apr 22 Forecast
2,733 9,361 19,661 8,652 11,009
May 22 Forecast
3,264 9,479 19,776 8,515 11,261
Jun 22 Forecast
3,863 9,819 20,109 8,688 11,421
Jun 22 Forecast
3,863 9,819 20,109 8,688 11,421
Jul 21 (311) (69) 11 (369)
Aug 21 (276) (85) 0 (360)
Sep 21 321 (59) (0) 262
Oct 21 348 (73) 9 285
Nov 21 (123) (74) (11) (209)
Dec 21 549 (81) (50) 418
Jan 22 186 (60) (109) 18
Feb 22 16 (67) 4 (47)
Mar 22 663 (71) 14 606
Apr 22 (62) (44) (0)
(105)
May 22 580 (64) 15 531
Jun 22 703 (60) (44) 599
Total 2,596
(806) (160) 1,629
Page 5 of 5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- ucr crimes by geoarea bcs2 new san diego
- pressure temperature chart low pressure refrigerants
- tables for cas exam mas i casualty actuarial society
- aluminum conduit bodies hubbellcdn
- u s cpi u https timeseries cuur0000sa0 amp
- registered enrolled voters statewide
- 192 168 1 100projectsprojects 2018projects 2017 7 23 wa
- vulcraft k series engineering data buildsite
- ebitda 229 288 264 288 297 200 212 329 331 238 348 365
- peggy malone associates inc 888 247 8602
Related searches
- 83rd infantry division 331 infantry
- 348 chevy pistons
- 348 chevy engine rebuild kit
- 348 chevy engine parts
- chevrolet 348 engine for sale
- chevy 348 engine performance parts
- 348 chevy engines for sale
- 348 engine parts for sale
- 348 chevy engine kits
- 348 chevy parts for sale
- ebitda free cash flow conversion
- cash ebitda vs ebitda