Financial Modelling

Modelanswer.xlsx

Home >Business & Finance homework help >Financial Modelling

Overview

Model Map
Section 1	Section 2	Section 3	Section 4
Inputs	Calculations	Outputs 1	Outputs 2	Styles	Arial 11
				Inputs and Assumptions
Financial information				Calcs
Historical and Budget Income Statement (annual)				Blanks
Historical and Budget Balance Sheet (annual)				Outputs
Historical Cashflow (annual)
Assumptions
Operational information
Sales reports	Store revenue (monthly)
Rent report	Rental expense (monthly)
Wages report	Retail store wages (monthly)
	Online sales revenue (monthly)
YTD Actual Income statement		2023 Monthly budget
		2024 Monthly budget
	Working capital control accounts (monthly)		Forecast Income Statement (monthly)
			Forecast Balance sheet (monthly)
	YTD Actuals - mapping		Forecast Cashflow (monthly)
			Summary Financial statements (annual)
			Dashboard
			Sensitivity Analysis

Inputs>>

IncSt

SUBTERRAIN LIMITED				Source: Subterrain Management Accounts
Management accounts
Income statement
		Year ended 31 December	2021	2022	2023	2023	2022 vs 2021	2023 vs 2022
			Actual	Actual	Budget	Forecast *
Acc code			($000s)	($000s)	($000s)	($000s)	($000s)	($000s)
10000	Sales revenue		92,574	90,150	94,500	92,000	(2,424)	4,350
		Opening Inventory	(11,089)	(11,159)	(12,400)	(12,400)	(70)	(1,241)
		Purchases	(44,598)	(44,341)	(41,994)	(41,564)	257	2,347
		Closing Inventory	11,159	12,400	11,000	11,000	1,241	(1,400)
	Cost of sales		(44,528)	(43,100)	(43,394)	(42,964)	1,428	(294)
	Gross profit		48,046	47,050	51,106	49,036	(996)	4,056
			51.9%	52.2%	54.1%	53.3%
	Overheads
82105		Accounting and consulting fees	96	135	135	135	39	- 0
84302		Advertising and marketing	1,900	2,050	2,200	2,400	150	150
75000		IT Expenses	1,774	1,568	1,700	1,600	(206)	132
84306		Legal and professional fees	75	85	85	85	10	- 0
84380		Motor vehicle expenses	280	220	220	220	(60)	- 0
76000		Power and utilities	767	725	725	800	(42)	- 0
70000		Rent	9,620	11,049	11,530	11,600	1,429	481
84390		Repairs and Maintenance	455	345	345	370	(110)	- 0
64110		Staff training and amenities	500	670	750	770	170	80
61000		Superannuation	1,812	1,888	1,940	1,970	76	52
64350		Travel	420	487	600	500	67	113
60000		Wages and salaries	19,074	18,880	19,400	19,700	(194)	520
85300		Other expenses	6,903	5,463	5,500	5,300	(1,440)	37
	Total overheads		43,676	43,565	45,130	45,450	(111)	1,565
	EBITDA		4,370	3,485	5,976	3,586	(885)	2,491
	Depreciation		1,200	1,020	1,050	1,050	(180)	30
	Operating profit		3,170	2,465	4,926	2,536	(776)	2,461
	Financing income		760	800	- 0	- 0	40	(800)
	Interest		(141)	(146)	(150)	(150)	(5)	(4)
	PBT		3,789	3,119	4,776	2,386	(670)	1,657
	Income tax		(1,158)	(873)	(1,336)	(716)	285	(463)
	Profit after tax		2,631	2,246	3,440	1,670	(385)	1,194
	Dividends		3,960	- 0	- 0	- 0	(3,960)	- 0
* 2023 Forecast includes 5 months actual results (Jan-May) and 7 months budget
Operational data: Wages and Rent breakdown
Source: Subterrain
				Actual	Budget
Acc code				20X2	20X3
				($000s)	($000s)
		Wages
60100		Retail stores		14,800	15,200
60200		Distribution		1,650	1,700
60300		Head office		2,430	2,500
				18,880	19,400
		Rent		TRUE	TRUE
70100		Retail stores		9,369	9,800
70200		Warehouse		1,200	1,250
70300		Head office		480	480
				11,049	11,530
				TRUE	TRUE

BS

SUBTERRAIN LIMITED			Source: Subterrain Management Accounts
Statement of Financial Position
	2021	2022	2023
	Actual	Actual	Budget
As at 31 December	($000s)	($000s)	($000s)
CURRENT ASSETS
Cash and cash equivalents	16,543	16,230	20,620
Trade receivables	1,232	1,038	1,065
Prepayments and other receivables	1,609	1,080	1,580
Inventories	11,159	12,400	11,000
Total current assets	30,543	30,748	34,265
NON-CURRENT ASSETS
Property, plant and equipment	20,405	18,385	18,335
Intangible assets	716	716	716
Total non-current assets	21,121	19,101	19,051
TOTAL ASSETS	51,664	49,849	53,316
CURRENT LIABILITIES
Trade payables	7,453	7,920	8,006
Current borrowings	842	805	820
Employee benefits	1,082	1,056	1,600
Taxation payable	117	90	250
Other payables	3,256	3,583	3,631
Total current liabilities	12,750	13,454	14,307
NON-CURRENT LIABILITIES
Non-current borrowings	2,585	1,780	960
Total non-current liabilities	2,585	1,780	960
Total liabilities	15,335	15,234	15,267
NET ASSETS	36,329	34,615	38,049
EQUITY
Contributed equity ($1 par)	12,000	12,000	12,000
Retained earnings	24,329	22,615	26,049
TOTAL EQUITY	36,329	34,615	38,049

CF

SUBTERRAIN LIMITED				Source: Subterrain Management Accounts
Statement of Cashflow
Year ended 31 December	2021	2022	2023
	Actual	Actual	Budget
	($000s)	($000s)	($000s)
Operating cashflows
Cash receipts
Sales receipts from customers	92,482	89,940	94,377
Other cash receipts	(301)	29	0
Cash payments
Payments to suppliers	(44,506)	(44,874)	(41,720)
Payments to staff	(20,948)	(20,794)	(21,296)
Interest	(141)	(146)	(150)
Taxes	(1,929)	(900)	(1,226)
Other cash expenses	(22,790)	(23,526)	(24,790)
Net operating cashflows	1,867	(271)	5,195
Investing activities
Purchase of PP&E	(2,720)	0	0
Net investing cashflows	(2,720)	0	0
Financing activities
Financing income	760	800	0
Repayment of loan	(830)	(842)	(805)
Dividends paid	(3,960)	0	0
Net financing cashflows	(4,030)	(42)	(805)
Increase/(decrease) in cash	(4,883)	(313)	4,390
Reconciliation of cash balance
Cash balance at start of year	21,426	16,543	16,230
Cash balance at end of year	16,543	16,230	20,620
Increase/(decrease) in cash	(4,883)	(313)	4,390

Assumptions

SUBTERRAIN Assumptions				2023	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
Timeline				Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
					1	2	3	4	5	6	7	8	9	10	11	12
Start date	01-Jan-24			31-Dec-23	01-Jan-24	01-Feb-24	01-Mar-24	01-Apr-24	01-May-24	01-Jun-24	01-Jul-24	01-Aug-24	01-Sep-24	01-Oct-24	01-Nov-24	01-Dec-24
End date					31-Jan-24	29-Feb-24	31-Mar-24	30-Apr-24	31-May-24	30-Jun-24	31-Jul-24	31-Aug-24	30-Sep-24	31-Oct-24	30-Nov-24	31-Dec-24
Days in period		Switch			31	29	31	30	31	30	31	31	30	31	30	31
Reporting period	Budget	Actual		Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget
Units	$000	Budget		$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000
Closing Inventory				11,000	11,000	11,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000
Revenue and Wages Seasonality					10.0%	10.0%	7.5%	7.5%	7.5%	10.0%	7.5%	7.5%	7.5%	7.5%	7.5%	10.0%	100%
Other (1/12 per month)	8.3%				8.3%	8.3%	8.3%	8.3%	8.3%	8.3%	8.3%	8.3%	8.3%	8.3%	8.3%	8.3%
Sales split		GM% of Rev (2023 Budget)	GM% of Rev (2024 Budget)
Retail	75.0%	54.0%	54.0%
Online	5.0%	54.0%	54.0%
Corp/clubs	20.0%	54.4%	54.4%
	100%	54.1%	54.1%
Working Capital
Credit terms (C&C)	21
Supplier terms	30	Days
Superannuation	10.0%	Quarterly
Wages	14	Days
Store name	Closure date (2024)	2023 Budget Total Revenue	2023 Budget Gross margin
Bass Coast	31-May-24	452,076	216,996
Orange	15-Jun-24	624,900	287,454
Alice Springs	30-Apr-24	756,204	370,553
Sydney - Auburn	01-Jul-24	1,490,324	760,238
Townsville	30-Sep-24	956,213	478,107
Tauranga	01-Aug-24	784,529	381,429
Melbourne - Chadstone	01-Oct-24	1,634,890	784,747
Greenhills	01-Nov-24	653,078	326,539
Mildura	15-Jul-24	590,342	295,835
Perisher	01-Sep-24	402,389	285,104
Average retail rent increase	4.6%
Online sales assumptions
Capital spend $000	4,000	01-Jan-24	1
Amortisation (S/L)	01-Apr-24	5	4
Uplift to sales		years
New website visitors (pm)	300,000
Start date	01-Apr-24
Monthly increase	5.0%
Conversion rate	6.0%
Average net spend (pp)	$ 100.00
Marketing spend (pm)	75,000	01-Apr-24
Tax rate	28.0%
Payable	next month
Source: Subterrain FP&A Manager
Data Tables
	Online sales revenue	Average spend $				Row input cell
$000	19,848	110	100	90	75	=B50
Conversion rates %	7%	25,471	23,156	20,840	17,367
	6%	21,833	19,848	17,863	14,886
	5%	18,194	16,540	14,886	12,405
	4%	14,555	13,232	11,909	9,924
Column input cell	=B49
	EBITDA	Average spend $				Row input cell
$000	14,175	110	100	90	75	=B50
Conversion rates %	7%	17,242	15,979	14,716	12,821
	6%	15,257	14,175	13,092	11,468
	5%	13,272	12,370	11,468	10,114
	4%	11,287	10,566	9,844	8,761
Column input cell	=B49
	Online sales revenue	Launch date				Row input cell
$000	19,848	Mar-22	Apr-22	May-22	Aug-22	=B47
Growth rates %	3%	20,635	18,286	16,006	9,556
	4%	21,611	19,049	16,586	9,749
	5%	22,640	19,848	17,188	9,946
	6%	23,725	20,684	17,815	10,147
	7%	24,870	21,560	18,468	10,351
Column input cell	=B48

Sales In

Sales report 2022								Sales report 2022
By product category								By sales channel
Category	Sub-category	Gross sales value (RRP)	Discounts	Net sales value	COGS	Gross margin		Channel	Sub-category	Gross sales value (RRP)	Discounts	Net sales value	COGS	Gross margin
Clothing								Retail sales (stores)
	Men	25,164,218	-4,537,810	20,626,409	-9,075,620	11,550,789			Clothing	38,447,316	-6,102,196	32,345,120	-14,511,864	17,833,256
	Womens	21,826,802	-2,943,642	18,883,160	-8,692,095	10,191,064			Footwear	12,891,326	-1,636,211	11,255,114	-5,383,384	5,871,730
	Childrens	5,569,130	-412,528	5,156,602	-1,871,847	3,284,756			Accessories	31,260,245	-7,492,743	23,767,502	-12,728,274	11,039,228
Clothing total		52,560,151	-7,893,980	44,666,170	-19,639,562	25,026,609		Retail total		82,598,886	-15,231,150	67,367,736	-32,623,522	34,744,215	51.6%
Footwear								Online
	Men	7,152,892	-878,425	6,274,467	-2,948,999	3,325,467			Clothing	3,597,609	-757,694	2,839,915	-1,265,432	1,574,483
	Womens	6,671,850	-920,255	5,751,595	-2,588,218	3,163,377			Footwear	545,232	-118,868	426,364	-222,077	204,287
	Childrens	1,150,319	-104,574	1,045,744	-418,298	627,447			Accessories	1,655,748	-328,885	1,326,862	-763,431	563,431
Footwear total		14,975,061	-1,903,255	13,071,806	-5,955,515	7,116,291		Online total		5,798,589	-1,205,447	4,593,141	-2,250,940	2,342,201	51.0%
Accessories								Corporate & Clubs
	Camping & hiking	21,628,728	-4,412,012	17,216,716	-9,250,525	7,966,191			Clothing	10,515,226	-1,034,091	9,481,135	-3,862,265	5,618,870
	Packs & bags	11,616,553	-1,515,203	10,101,351	-5,343,581	4,757,770			Footwear	1,538,504	-148,176	1,390,328	-350,054	1,040,274
	Travel gear	7,939,251	-2,844,907	5,094,344	-2,904,154	2,190,190	43.0%		Accessories	8,268,540	-950,494	7,318,046	-4,006,555	3,311,491
Accessories total		41,184,532	-8,772,122	32,412,411	-17,498,260	14,914,151		Corporate & Clubs total		20,322,269	-2,132,760	18,189,510	-8,218,874	9,970,635	54.8%
Total		108,719,744	-18,569,357	90,150,387	-43,093,336	47,057,051		Total		108,719,744	-18,569,357	90,150,387	-43,093,336	47,057,051
Source: Subterrain (FP&A Manager)
Working (not in source doc)								Working
Gross margin % all categories						52.2%		Retail % of total				74.7%		73.8%
Gross margin % Travel gear						43.0%		Online % of total				5.1%		5.0%
Gross margin total exc travel gear						52.7%		CC % of total				20.2%		21.2%
								Combined online and CC							54.0%

Rent In

Store name	Annual rent (2023 budget)	Annual increases (per lease) %	Lease end dates	Break lease fee	Source: Subterrain (FP&A Manager)
Alice Springs	87,056	4.2	Aug-23	0 mths
Auckland	188,523	6.6	Sep-26	0 mths
Ballarat	58,500	2	Jan-26	1 mths
Bass Coast	68,554	5.66	Jan-26	2 mths
Brisbane - CBD	280,486	2.2	May-25	0 mths
Brisbane - Fortitude Valley	298,786	3.6	Jun-23	0 mths
Cairns	138,564	7.2	Jan-24	12 mths
Canberra	182,568	7	Mar-26	0 mths
Central Coast	59,785	5.2	Jul-25	0 mths
Christchurch	158,502	2	Oct-25	3 mths
Darwin	63,654	2.5	Dec-23	1 mths
Darwin	116,565	6	Feb-26	0 mths
Dubbo	78,905	5.4	Jan-24	0 mths
Dunedin	75,789	7	Sep-25	0 mths
Gosford	92,506	7	Oct-23	0 mths
Greenhills	55,221	8	Sep-23	0 mths
Hervey Bay	82,072	4	Oct-25	1 mths
Hobart	147,823	0	Jan-26	0 mths
Horsham	95,784	0	Apr-25	0 mths
Katoomba	86,306	7	Jul-24	0 mths
Latrobe	145,057	2	Jul-24	0 mths
Melbourne - Camberwell	342,455	2	Jul-23	12 mths
Melbourne - CBD	467,605	7	Jun-23	3 mths
Melbourne - Chadstone	348,798	7	Jul-23	0 mths
Melbourne - Docklands	358,212	7	Apr-24	0 mths
Melbourne - Doncaster	285,987	4	Feb-26	3 mths
Melbourne - Fitzroy	423,560	6.23	Apr-25	3 mths
Melbourne - Richmond	485,555	1.56	Jun-25	3 mths
Melbourne - Spencer Street	387,525	6.23	Dec-26	1 mths
Mildura	60,124	6.2	Apr-25	3 mths
Newcastle	256,989	2	Feb-24	0 mths
Orange	62,358	0	Jul-23	3 mths
Parramatta	295,465	3.8	Sep-26	0 mths
Perisher	64,354	3.6	Nov-23	3 mths
Perth	18,552	8	Mar-24	0 mths
Port Macquarie	119,750	3.6	Jun-23	0 mths
Sydney - Auburn	325,789	5	Sep-24	3 mths
Sydney - Bondi	420,065	6	Jan-24	0 mths
Sydney - CBD	450,525	6.5	Nov-25	0 mths
Sydney - Chatswood	386,060	4.3	Sep-24	3 mths
Sydney - Homebush	258,655	3.6	Nov-24	0 mths
Sydney - Macquarie	393,785	2.8	Nov-25	0 mths
Sydney - Pitt Street	492,256	7.2	Jan-26	0 mths
Tamworth	62,154	6.2	Jul-23	0 mths
Tauranga	60,789	1.8	Jun-24	0 mths
Townsville	141,436	5	Oct-25	1 mths
Wagga Wagga	92,870	2	Oct-25	0 mths
Wellington	177,521	7.5	Nov-26	3 mths
$	9,800,200	4.60
$000	9,800

Wages In

Employee number	Last Name	First Name	Start date	Store	Job Title	Employee status	Total wages 2022 $	Source: Subterrain (FP&A Manager)
33416	Crighton	Ethe	3/30/22	Alice Springs	Retail assistant	Casual	22,500
14160	Lamperti	Hieronymus	9/23/20	Alice Springs	Retail assistant	Casual	23,780
41269	Omrod	Federica	5/30/21	Alice Springs	Retail assistant	Casual	28,920
17432	Trafford	Sandi	11/18/20	Alice Springs	Retail assistant	Casual	49,495
87000	Brimilcome	Catherine	10/4/19	Alice Springs	Retail assistant	Full time	59,000
89296	Rolston	Janis	2/3/17	Alice Springs	Retail assistant	Part-time	42,884
30691	Currer	Kerry	3/28/18	Alice Springs	Supervisor	Full time	64,392
87701	Yoseloff	Cesare	6/1/19	Auckland	Retail assistant	Casual	22,500
67796	Colliss	Luise	4/27/20	Auckland	Retail assistant	Casual	48,345
36975	O'Driscole	Gwenneth	2/27/19	Auckland	Retail assistant	Casual	32,473
90318	Swainston	Waring	11/12/19	Auckland	Retail assistant	Casual	20,125
69369	Cottee	Jeromy	1/10/19	Auckland	Retail assistant	Full time	58,752
36141	Goodsell	Culver	8/30/20	Auckland	Retail assistant	Full time	56,982
51143	Tegeller	Edwin	12/7/12	Auckland	Retail assistant	Part-time	32,123
4801	Egan	Elset	8/14/19	Auckland	Supervisor	Full time	58,194
62456	Kornilyev	Micheil	11/20/21	Ballarat	Retail assistant	Casual	5,086
16504	Waistell	Millisent	4/5/20	Ballarat	Retail assistant	Casual	21,060
19216	Harlett	Ellynn	2/5/20	Ballarat	Retail assistant	Casual	40,484
23164	Olechnowicz	Teddi	4/28/20	Ballarat	Retail assistant	Casual	35,103
63302	Slograve	Nisse	4/3/20	Ballarat	Retail assistant	Full time	54,612
71853	Colly	Gwen	4/29/17	Ballarat	Supervisor	Full time	54,938
15863	Lashmore	Berni	5/10/22	Bass Coast	Retail assistant	Casual	22,012
69496	Allkins	Gae	12/15/20	Bass Coast	Retail assistant	Casual	22,567
87777	Bowfin	Madlen	12/30/21	Bass Coast	Retail assistant	Casual	46,137
238	Petr	Mose	3/27/21	Bass Coast	Retail assistant	Casual	30,569
41291	Toplis	Vikki	6/13/20	Bass Coast	Retail assistant	Full time	58,712
88041	Hay	Coretta	11/25/16	Bass Coast	Retail assistant	Part-time	32,131
43185	O'Kuddyhy	Mohandis	2/11/14	Bass Coast	Supervisor	Full time	57,727
49959	Keyhoe	Del	9/2/21	Brisbane - CBD	Retail assistant	Casual	7,855
17014	Talbot	Maury	3/8/20	Brisbane - CBD	Retail assistant	Casual	46,832
8947	Niven	Freddi	10/26/20	Brisbane - CBD	Retail assistant	Casual	49,564
57351	Crothers	Farrand	3/11/21	Brisbane - CBD	Retail assistant	Full time	44,988
7760	Glascott	Edan	9/29/21	Brisbane - CBD	Retail assistant	Full time	15,219
29830	D'Aulby	Reider	11/7/20	Brisbane - CBD	Retail assistant	Part-time	44,301
3627	Carlone	Stanleigh	10/7/15	Brisbane - CBD	Retail assistant	Part-time	43,465
95520	Clarridge	Emmalyn	2/12/12	Brisbane - CBD	Retail assistant	Part-time	40,850
99056	Whiteland	Johannes	4/7/17	Brisbane - CBD	Retail assistant	Part-time	40,917
65716	Elverstone	Bowie	11/12/21	Brisbane - CBD	Supervisor	Full time	8,398
31134	Bullerwell	Ronna	8/24/20	Brisbane - Fortitude Valley	Retail assistant	Casual	34,451
76685	Danett	Gisele	1/5/21	Brisbane - Fortitude Valley	Retail assistant	Casual	11,402
65435	Liccardo	Loni	6/11/21	Brisbane - Fortitude Valley	Retail assistant	Casual	27,508
96066	Altree	Clareta	10/22/19	Brisbane - Fortitude Valley	Retail assistant	Full time	55,122
61866	McGennis	Susanne	6/12/19	Brisbane - Fortitude Valley	Retail assistant	Full time	58,123
9860	Meeking	Brandise	6/1/19	Brisbane - Fortitude Valley	Retail assistant	Part-time	41,749
13945	Gonsalvo	Cayla	7/17/12	Brisbane - Fortitude Valley	Retail assistant	Part-time	42,277
60750	Becarra	Sharyl	2/17/17	Brisbane - Fortitude Valley	Retail assistant	Part-time	44,081
18150	Dannett	Liuka	11/23/18	Brisbane - Fortitude Valley	Retail assistant	Part-time	40,901
46849	Woodison	Valenka	2/10/21	Brisbane - Fortitude Valley	Supervisor	Full time	56,354
22222	Green	Fairleigh	9/14/21	Cairns	Retail assistant	Casual	12,636
13161	Oller	Curry	7/19/20	Cairns	Retail assistant	Casual	22,356
86517	Gaskins	Terri-jo	9/10/21	Cairns	Retail assistant	Casual	10,534
97897	Betterton	Alleyn	9/24/20	Cairns	Retail assistant	Casual	42,730
16578	Warder	Bucky	1/30/21	Cairns	Retail assistant	Full time	54,292
86447	Jeaneau	Eustace	1/1/19	Cairns	Retail assistant	Full time	58,344
32558	Jesper	Rubi	2/10/14	Cairns	Retail assistant	Part-time	31,232
57961	Marieton	Filberte	11/26/18	Cairns	Supervisor	Full time	57,199
24049	Delgadillo	Giuseppe	5/18/20	Canberra	Retail assistant	Casual	16,780
87391	Cregeen	Fleur	7/31/21	Canberra	Retail assistant	Casual	15,898
49480	Rooksby	Allys	9/20/19	Canberra	Retail assistant	Casual	34,756
7944	Fergyson	Cal	3/28/19	Canberra	Retail assistant	Casual	35,484
85659	Lohmeyer	Ezequiel	8/5/20	Canberra	Retail assistant	Full time	58,816
69279	Shawcross	Bibby	2/16/21	Canberra	Retail assistant	Full time	51,872
41033	Lanigan	Belvia	4/29/17	Canberra	Retail assistant	Part-time	31,007
63202	Baird	Brittni	5/18/21	Canberra	Supervisor	Full time	40,229
92778	Stock	Alvis	12/30/20	Central Coast	Retail assistant	Casual	34,000
6088	Haynesford	Carlie	2/11/21	Central Coast	Retail assistant	Casual	23,138
38349	Carass	Torrance	8/18/21	Central Coast	Retail assistant	Casual	15,922
29267	Shelbourne	Barbaraanne	8/16/20	Central Coast	Retail assistant	Casual	35,208
87297	Trase	Clare	11/8/20	Central Coast	Retail assistant	Full time	58,344
10525	Creber	Erny	12/23/17	Central Coast	Retail assistant	Part-time	44,341
36352	Rickerd	Gifford	11/23/13	Central Coast	Supervisor	Full time	57,542
45848	Vakhonin	Pearle	4/12/19	Christchurch	Retail assistant	Casual	22,500
61448	Grafom	Elizabeth	7/18/20	Christchurch	Retail assistant	Casual	32,305
27094	Manuelli	Eberto	1/1/20	Christchurch	Retail assistant	Casual	45,096
60687	Alben	Nadya	10/24/19	Christchurch	Retail assistant	Casual	32,028
22808	Claringbold	Rick	8/24/19	Christchurch	Retail assistant	Full time	57,131
13859	Black	Lucy	8/5/19	Christchurch	Retail assistant	Full time	59,000
91538	Jobbings	Bria	5/25/12	Christchurch	Retail assistant	Part-time	43,647
63798	Harkes	Dex	8/22/20	Christchurch	Supervisor	Full time	61,865
45161	Lillow	Tammy	3/13/19	Darwin	Retail assistant	Casual	22,231
54436	Brownscombe	Sawyer	12/6/21	Darwin	Retail assistant	Casual	2,679
25795	Overshott	Rudolf	4/20/21	Darwin	Retail assistant	Casual	19,643
18492	Brookwood	Aigneis	6/17/19	Darwin	Retail assistant	Casual	23,671
97656	Turbat	Arty	6/10/19	Darwin	Retail assistant	Casual	12,363
80939	Crowche	Mathias	5/3/19	Darwin	Retail assistant	Casual	44,797
28008	Agass	Lawry	3/4/21	Darwin	Retail assistant	Casual	23,502
16349	Walby	Euphemia	8/18/20	Darwin	Retail assistant	Casual	30,548
53483	Hutfield	Nissa	7/29/19	Darwin	Retail assistant	Full time	57,173
21581	Stuchburie	Keane	12/6/20	Darwin	Retail assistant	Full time	58,720
86995	Rawood	Christophe	7/29/19	Darwin	Retail assistant	Full time	55,478
35760	Eastridge	Verina	9/29/15	Darwin	Retail assistant	Part-time	40,620
7380	Thwaites	Leroi	9/14/16	Darwin	Retail assistant	Part-time	41,026
68538	Alton	Nadya	7/10/16	Darwin	Supervisor	Full time	55,598
67736	Dymond	Gregoire	12/16/12	Darwin	Supervisor	Full time	63,123
69490	Ruprich	Hedda	4/20/19	Dubbo	Retail assistant	Casual	12,560
23362	Meenan	Durward	6/21/19	Dubbo	Retail assistant	Casual	31,035
8602	Garmon	Violet	4/10/20	Dubbo	Retail assistant	Casual	35,941
13423	Folbig	Winfield	2/18/21	Dubbo	Retail assistant	Casual	35,675
92050	Bussell	Christie	1/7/19	Dubbo	Retail assistant	Full time	59,000
12835	Dyke	Laetitia	3/20/12	Dubbo	Supervisor	Full time	54,761
47655	Burgane	Becky	5/15/20	Dunedin	Retail assistant	Casual	31,059
19521	Bolstridge	Igor	5/28/20	Dunedin	Retail assistant	Casual	23,567
95645	Schroder	Gawain	9/5/21	Dunedin	Retail assistant	Casual	14,640
47084	Sparkes	Syd	11/17/20	Dunedin	Retail assistant	Casual	37,530
43789	Richardson	Frans	6/25/19	Dunedin	Retail assistant	Full time	59,000
5799	Matyushonok	Jonas	7/29/13	Dunedin	Supervisor	Full time	58,594
68939	Timbridge	Audrie	3/5/20	Gosford	Retail assistant	Casual	22,765
24382	Hyatt	Vittoria	10/14/19	Gosford	Retail assistant	Casual	46,201
98359	Geke	Eloise	5/20/21	Gosford	Retail assistant	Casual	20,191
32408	Karslake	Judith	11/11/21	Gosford	Retail assistant	Casual	3,303
77735	Buer	Mireille	3/26/19	Gosford	Retail assistant	Full time	58,235
89987	Gosenell	Martynne	2/18/21	Gosford	Retail assistant	Full time	50,833
41846	Hustler	Tibold	4/24/13	Gosford	Retail assistant	Part-time	41,141
59594	Scalia	Rudy	7/8/15	Gosford	Supervisor	Full time	55,834
51542	Demoge	Rosamond	10/26/19	Greenhills	Retail assistant	Casual	33,506
88324	Benoey	Joye	4/17/19	Greenhills	Retail assistant	Casual	23,432
83644	Deme	Woodrow	10/6/19	Greenhills	Retail assistant	Casual	33,686
85210	Guierre	Fredrika	3/21/19	Greenhills	Retail assistant	Casual	49,518
57106	McRae	Gwenette	2/20/20	Greenhills	Retail assistant	Full time	58,712
98801	Boyack	Shanon	6/28/13	Greenhills	Supervisor	Full time	56,211
68774	Melville	Pearla	3/20/21	Hervey Bay	Retail assistant	Casual	16,731
84873	Pluck	Marlow	9/14/19	Hervey Bay	Retail assistant	Casual	12,578
7428	Stanyland	Blaine	12/28/21	Hervey Bay	Retail assistant	Casual	306
10551	Rizzone	Norrie	6/21/20	Hervey Bay	Retail assistant	Full time	56,108
30335	Shiell	Ronna	1/2/16	Hervey Bay	Retail assistant	Part-time	32,150
34690	Grabert	Garwood	6/19/14	Hervey Bay	Supervisor	Full time	62,621
97616	Pettisall	Wendall	1/26/21	Hobart	Retail assistant	Casual	21,046
65815	Nolleau	Otha	9/17/21	Hobart	Retail assistant	Casual	13,506
23923	Dun	Danya	1/18/20	Hobart	Retail assistant	Casual	43,799
11113	Rubinowitsch	Olly	4/8/19	Hobart	Retail assistant	Casual	29,099
79271	Addison	Clair	6/13/21	Hobart	Retail assistant	Full time	32,041
96349	Lepick	Egbert	4/4/21	Hobart	Retail assistant	Full time	44,205
4711	Loffel	Denney	1/5/18	Hobart	Retail assistant	Part-time	43,234
42839	Maxfield	Jodie	8/22/19	Hobart	Supervisor	Full time	59,532
56783	Calvie	Crosby	3/18/21	Horsham	Retail assistant	Casual	26,569
53604	Oxley	Ailee	3/10/19	Horsham	Retail assistant	Casual	21,560
68330	Teggin	Bridgette	3/22/21	Horsham	Retail assistant	Casual	33,327
76509	Cleen	Roxi	7/21/20	Horsham	Retail assistant	Casual	23,780
74638	Rosenfelder	Uriel	10/12/20	Horsham	Retail assistant	Full time	58,712
27027	Alliberton	Warden	3/5/17	Horsham	Retail assistant	Part-time	41,093
37034	Reinhard	Em	10/12/16	Horsham	Supervisor	Full time	54,692
41645	Liversedge	Dacy	5/24/20	Katoomba	Retail assistant	Casual	21,060
38064	Muriel	Bea	9/30/21	Katoomba	Retail assistant	Casual	8,710
73632	Dirand	Karlis	3/1/19	Katoomba	Retail assistant	Casual	42,036
12504	Ordemann	Garnet	6/8/20	Katoomba	Retail assistant	Casual	34,383
9796	Sked	Karry	11/17/20	Katoomba	Retail assistant	Full time	58,344
8761	Bidewell	Jonis	12/14/18	Katoomba	Retail assistant	Part-time	34,512
98145	Brown	Astrix	7/14/12	Katoomba	Supervisor	Full time	58,792
74920	Sheryn	Magnum	2/7/19	Latrobe	Retail assistant	Casual	22,500
10278	Summers	Adrien	2/1/21	Latrobe	Retail assistant	Casual	29,521
41041	Bowerbank	Jeniece	9/18/21	Latrobe	Retail assistant	Casual	10,497
7392	Lescop	Francyne	5/24/19	Latrobe	Retail assistant	Casual	41,548
50385	Ledrane	Michaella	11/14/20	Latrobe	Retail assistant	Full time	57,368
11642	Poles	Sanford	8/15/19	Latrobe	Retail assistant	Full time	54,846
1224	Doxsey	Marj	1/18/13	Latrobe	Retail assistant	Part-time	35,123
59187	Croston	Emalee	3/12/18	Latrobe	Supervisor	Full time	60,894
56922	Neaverson	Clarissa	10/10/19	Melbourne - Camberwell	Retail assistant	Casual	20,000
15913	Breinlein	Indira	7/5/19	Melbourne - Camberwell	Retail assistant	Casual	34,953
26411	Guillet	Bernie	8/20/20	Melbourne - Camberwell	Retail assistant	Casual	37,489
1791	Palk	Zed	9/18/21	Melbourne - Camberwell	Retail assistant	Full time	16,991
79119	Haly	Michaella	11/1/20	Melbourne - Camberwell	Retail assistant	Full time	58,923
82994	Rittmeyer	Kelsy	11/5/20	Melbourne - Camberwell	Retail assistant	Part-time	40,951
26256	Genge	Lyndel	7/9/18	Melbourne - Camberwell	Retail assistant	Part-time	44,857
4062	Ribbens	Natalya	7/21/14	Melbourne - Camberwell	Retail assistant	Part-time	41,037
98769	Schoenleiter	Natalina	10/19/13	Melbourne - Camberwell	Retail assistant	Part-time	43,226
94887	Folk	Katti	1/21/21	Melbourne - Camberwell	Supervisor	Full time	54,156
77722	Ginnaly	Renard	4/26/20	Melbourne - CBD	Retail assistant	Casual	22,670
64439	Ross	D'arcy	3/17/19	Melbourne - CBD	Retail assistant	Casual	37,002
92684	Klausewitz	Evelina	7/28/21	Melbourne - CBD	Retail assistant	Casual	18,011
34007	Merigot	Shea	10/30/19	Melbourne - CBD	Retail assistant	Full time	58,235
24479	Tuddall	Tobie	10/19/20	Melbourne - CBD	Retail assistant	Full time	57,122
68084	Matevushev	Delphine	8/9/21	Melbourne - CBD	Retail assistant	Part-time	17,921
60888	Dmytryk	Aryn	10/29/16	Melbourne - CBD	Retail assistant	Part-time	44,636
35630	O'Conor	Christan	1/18/14	Melbourne - CBD	Retail assistant	Part-time	41,324
5426	Wagenen	Reynolds	8/2/15	Melbourne - CBD	Retail assistant	Part-time	41,951
39943	Crowcum	Casey	1/14/21	Melbourne - CBD	Supervisor	Full time	56,593
85693	Pedgrift	Clarette	11/30/19	Melbourne - Chadstone	Retail assistant	Casual	22,040
46618	Huyche	Sumner	5/25/21	Melbourne - Chadstone	Retail assistant	Casual	22,688
48400	Eccott	Melina	5/24/22	Melbourne - Chadstone	Retail assistant	Casual	26,722
29281	De Domenico	Alysia	5/15/20	Melbourne - Chadstone	Retail assistant	Full time	55,265
79702	Blunden	Zebadiah	12/5/20	Melbourne - Chadstone	Retail assistant	Full time	56,646
46742	Arlidge	Hettie	6/29/22	Melbourne - Chadstone	Retail assistant	Part-time	21,553
40623	Grimley	Harland	8/9/17	Melbourne - Chadstone	Retail assistant	Part-time	40,128
96560	Willimott	Isadore	1/30/15	Melbourne - Chadstone	Retail assistant	Part-time	42,614
62726	Korbmaker	Ingelbert	1/5/13	Melbourne - Chadstone	Retail assistant	Part-time	42,133
17364	Extance	Gabie	6/17/21	Melbourne - Chadstone	Supervisor	Full time	35,326
32678	Kubica	Gina	3/6/21	Melbourne - Docklands	Retail assistant	Casual	24,922
89532	Jozwiak	Karlene	1/22/21	Melbourne - Docklands	Retail assistant	Casual	32,261
47405	Stoffel	Issi	8/27/21	Melbourne - Docklands	Retail assistant	Casual	13,106
61043	Blundin	Reade	7/10/21	Melbourne - Docklands	Retail assistant	Full time	28,428
62680	Dabbs	Brooke	4/30/20	Melbourne - Docklands	Retail assistant	Full time	58,923
37022	Pydcock	Che	8/14/21	Melbourne - Docklands	Retail assistant	Part-time	16,012
98868	Banbridge	Davine	6/17/17	Melbourne - Docklands	Retail assistant	Part-time	41,261
2810	Kitchenside	Bentley	12/6/13	Melbourne - Docklands	Retail assistant	Part-time	42,244
75399	Fancourt	Christean	9/18/18	Melbourne - Docklands	Retail assistant	Part-time	42,730
54482	Bowcock	Kamillah	12/13/19	Melbourne - Docklands	Supervisor	Full time	56,108
30028	Zupo	Pier	1/5/21	Melbourne - Doncaster	Retail assistant	Casual	25,123
77681	Melpuss	Kimbell	12/5/20	Melbourne - Doncaster	Retail assistant	Casual	22,946
17717	Longhorne	Bibi	2/18/21	Melbourne - Doncaster	Retail assistant	Casual	28,254
44621	Kerry	Freida	9/5/20	Melbourne - Doncaster	Retail assistant	Full time	54,307
29263	Tremonte	Tommy	12/7/19	Melbourne - Doncaster	Retail assistant	Full time	58,923
95359	Housiaux	Cary	7/7/19	Melbourne - Doncaster	Retail assistant	Part-time	23,683
58257	Blake	Harris	10/1/15	Melbourne - Doncaster	Retail assistant	Part-time	40,240
24821	McCrossan	Lani	9/12/16	Melbourne - Doncaster	Retail assistant	Part-time	24,770
67985	Novill	Cecilla	6/2/17	Melbourne - Doncaster	Retail assistant	Part-time	44,466
50798	Aharoni	Fanchon	11/25/21	Melbourne - Doncaster	Supervisor	Full time	5,865
97274	Tremmil	Clark	2/26/20	Melbourne - Fitzroy	Retail assistant	Casual	25,895
92906	Bomfield	Delphinia	1/12/19	Melbourne - Fitzroy	Retail assistant	Casual	38,571
83451	Smalecombe	Germaine	11/15/20	Melbourne - Fitzroy	Retail assistant	Casual	16,922
34843	Wederell	Luigi	1/25/20	Melbourne - Fitzroy	Retail assistant	Full time	58,752
23689	Durtnal	Noemi	3/23/21	Melbourne - Fitzroy	Retail assistant	Full time	44,571
16408	Gaymar	Dorie	7/12/19	Melbourne - Fitzroy	Retail assistant	Part-time	44,710
74766	Piercey	Aube	12/28/12	Melbourne - Fitzroy	Retail assistant	Part-time	14,308
9465	Eilhertsen	Carolynn	12/7/13	Melbourne - Fitzroy	Retail assistant	Part-time	44,965
22221	Clemes	Titos	5/11/15	Melbourne - Fitzroy	Retail assistant	Part-time	44,223
37864	Girdler	Nikita	1/10/21	Melbourne - Fitzroy	Supervisor	Full time	54,664
49301	Kivelle	Lorilee	12/17/21	Melbourne - Richmond	Retail assistant	Casual	860
10323	Adelberg	Elyssa	5/9/20	Melbourne - Richmond	Retail assistant	Casual	41,174
71125	Helian	Rupert	9/1/20	Melbourne - Richmond	Retail assistant	Casual	32,416
69112	Learman	Dorolisa	7/24/21	Melbourne - Richmond	Retail assistant	Full time	25,882
91326	Andrusyak	Stacy	10/6/21	Melbourne - Richmond	Retail assistant	Full time	13,545
10109	Timmens	Daniele	9/19/19	Melbourne - Richmond	Retail assistant	Part-time	23,506
48746	Struther	Cassandra	11/26/18	Melbourne - Richmond	Retail assistant	Part-time	41,062
71417	Mollett	Coletta	10/16/17	Melbourne - Richmond	Retail assistant	Part-time	28,539
75967	Bohills	Bernice	2/4/13	Melbourne - Richmond	Retail assistant	Part-time	34,123
27331	Drance	Fidel	2/8/21	Melbourne - Richmond	Supervisor	Full time	53,953
55493	Cainey	Verla	7/12/20	Melbourne - Spencer Street	Retail assistant	Casual	22,056
95436	Kitchingham	Beulah	8/3/21	Melbourne - Spencer Street	Retail assistant	Casual	17,131
39123	Heggadon	Skip	11/29/19	Melbourne - Spencer Street	Retail assistant	Casual	15,159
79053	Cadwell	Denis	5/13/20	Melbourne - Spencer Street	Retail assistant	Full time	58,344
2404	Hopkins	Huntlee	10/22/20	Melbourne - Spencer Street	Retail assistant	Full time	56,746
40445	Jull	Jori	4/26/20	Melbourne - Spencer Street	Retail assistant	Part-time	24,672
85436	Kilner	Monah	8/18/14	Melbourne - Spencer Street	Retail assistant	Part-time	20,749
49816	Andreas	Alexandro	10/20/13	Melbourne - Spencer Street	Retail assistant	Part-time	42,136
66473	Foottit	Jeffy	4/23/13	Melbourne - Spencer Street	Retail assistant	Part-time	40,826
74883	Derle	Reba	4/21/19	Melbourne - Spencer Street	Supervisor	Full time	60,235
77160	Dale	Danie	10/4/19	Mildura	Retail assistant	Casual	22,678
35750	Potbury	Fionna	8/20/22	Mildura	Retail assistant	Casual	11,692
51798	Sherbourne	Karina	1/29/19	Mildura	Retail assistant	Casual	27,758
45542	Stayte	Othilia	10/23/20	Mildura	Retail assistant	Casual	49,838
27082	Wyper	Melosa	3/9/19	Mildura	Retail assistant	Full time	59,000
24961	Heskins	Danit	8/10/15	Mildura	Retail assistant	Part-time	32,345
20662	Slocomb	Donnie	8/31/16	Mildura	Supervisor	Full time	63,332
17480	Dienes	Claire	11/1/20	Newcastle	Retail assistant	Casual	29,032
37961	Boriston	Gussi	6/8/21	Newcastle	Retail assistant	Casual	19,750
42090	Berrill	Coralie	9/24/19	Newcastle	Retail assistant	Casual	42,737
80268	Klimko	Graehme	10/6/19	Newcastle	Retail assistant	Casual	20,180
77096	Giffin	Myer	6/28/19	Newcastle	Retail assistant	Full time	58,816
99753	Searl	Christie	1/9/20	Newcastle	Retail assistant	Part-time	42,886
50841	Redding	Blondy	9/28/17	Newcastle	Retail assistant	Part-time	41,327
49743	Dossett	Nickolas	3/7/14	Newcastle	Retail assistant	Part-time	21,245
66770	Enterlein	Serge	5/21/17	Newcastle	Retail assistant	Part-time	41,444
49871	Edmonston	Hiram	7/7/18	Newcastle	Retail assistant	Part-time	32,134
10325	Cordes	Nevin	11/17/20	Newcastle	Supervisor	Full time	62,464
98296	Cuttelar	Cherye	12/5/22	Orange	Retail assistant	Casual	1,694
9787	Valasek	Billy	12/5/22	Orange	Retail assistant	Casual	2,161
35227	Buesnel	Selena	9/30/22	Orange	Retail assistant	Casual	7,327
72460	Phippen	Juanita	7/13/19	Orange	Retail assistant	Casual	39,034
28599	Tuberfield	Aurelie	6/30/21	Orange	Retail assistant	Full time	29,842
53129	Tombling	Burke	11/27/15	Orange	Retail assistant	Part-time	32,123
34964	Mathely	Rafaela	1/31/14	Orange	Supervisor	Full time	56,201
40295	Prater	Fredric	6/11/19	Parramatta	Retail assistant	Casual	25,000
1308	Battista	Ferdinand	5/10/20	Parramatta	Retail assistant	Casual	49,483
50030	Cheverell	Elna	1/21/19	Parramatta	Retail assistant	Casual	10,841
92937	Claris	Pippo	2/19/21	Parramatta	Retail assistant	Full time	46,537
91598	Exer	Prudy	7/28/20	Parramatta	Retail assistant	Full time	58,344
8410	Dimitriou	Kerianne	12/12/19	Parramatta	Retail assistant	Part-time	25,720
89520	Shalliker	Kirstin	6/25/18	Parramatta	Retail assistant	Part-time	24,575
41985	Gunn	Garnette	3/3/18	Parramatta	Retail assistant	Part-time	42,778
96449	Dosdell	Brew	1/26/14	Parramatta	Retail assistant	Part-time	43,841
57093	Speke	Bertrando	10/7/21	Parramatta	Supervisor	Full time	13,326
11406	MacLucais	Lorenzo	3/2/21	Perisher	Retail assistant	Casual	19,811
99172	Axford	Feodora	11/3/19	Perisher	Retail assistant	Casual	33,289
54094	Sandwich	Shirline	2/21/20	Perisher	Retail assistant	Casual	28,724
64054	Theodore	Rene	10/25/21	Perisher	Retail assistant	Casual	6,983
77542	Cantor	Robbyn	8/23/20	Perisher	Retail assistant	Full time	58,594
20800	Wloch	Fara	3/15/18	Perisher	Retail assistant	Part-time	44,267
43675	Brinklow	Immanuel	1/27/12	Perisher	Supervisor	Full time	61,097
29256	Kingsley	Bartlett	9/20/20	Perth	Retail assistant	Casual	21,432
18189	Grix	Erny	2/2/19	Perth	Retail assistant	Casual	46,375
2038	Germann	Mariejeanne	11/13/19	Perth	Retail assistant	Casual	42,157
9140	Lovie	Magdalena	11/24/19	Perth	Retail assistant	Casual	24,120
49710	Bloss	Sabina	12/10/21	Perth	Retail assistant	Full time	3,400
95243	Rizon	Borden	7/7/19	Perth	Retail assistant	Full time	54,336
85336	Caroline	Charley	1/9/13	Perth	Retail assistant	Part-time	43,791
37471	Trinkwon	Lamar	4/18/21	Perth	Supervisor	Full time	41,539
92721	Dellar	Alessandro	3/23/21	Port Macquarie	Retail assistant	Casual	26,162
85436	Toomey	Mayne	10/3/21	Port Macquarie	Retail assistant	Casual	7,818
10509	Kollach	Ada	7/1/21	Port Macquarie	Retail assistant	Casual	22,006
97721	Meagher	Mattie	11/24/19	Port Macquarie	Retail assistant	Casual	45,298
94847	Hagergham	Harriette	1/25/21	Port Macquarie	Retail assistant	Full time	55,722
37531	Pope	Peg	8/1/15	Port Macquarie	Retail assistant	Part-time	42,067
59239	Lukehurst	Garth	2/8/12	Port Macquarie	Supervisor	Full time	63,888
65149	Schmuhl	Rachel	2/11/22	Sydney - Auburn	Retail assistant	Casual	28,895
84405	Giroldi	Hermy	4/18/21	Sydney - Auburn	Retail assistant	Casual	25,315
77081	Pfeffel	Linet	10/8/19	Sydney - Auburn	Retail assistant	Casual	41,665
3790	Darwent	Benita	8/3/20	Sydney - Auburn	Retail assistant	Full time	58,529
77343	Pischof	Traci	9/13/21	Sydney - Auburn	Retail assistant	Full time	58,235
69828	Dickerline	Massimo	1/7/21	Sydney - Auburn	Retail assistant	Part-time	43,330
46854	Gainseford	Livia	3/18/18	Sydney - Auburn	Retail assistant	Part-time	44,437
50068	Bambrough	Tymon	6/10/13	Sydney - Auburn	Retail assistant	Part-time	40,748
12954	Wellington	Saundra	2/17/12	Sydney - Auburn	Retail assistant	Part-time	42,815
12594	Hallas	Luis	1/1/20	Sydney - Auburn	Supervisor	Full time	64,506
38137	Rickman	Homer	2/6/19	Sydney - Bondi	Retail assistant	Casual	27,728
74404	Waszczykowski	Fremont	8/21/19	Sydney - Bondi	Retail assistant	Casual	30,356
19375	Albrook	Ollie	12/16/19	Sydney - Bondi	Retail assistant	Casual	31,144
55622	Longea	Rafaelia	9/29/19	Sydney - Bondi	Retail assistant	Full time	55,336
37420	Abramamov	Moise	2/10/21	Sydney - Bondi	Retail assistant	Full time	52,510
37000	Venes	Karlan	6/8/21	Sydney - Bondi	Retail assistant	Part-time	23,511
37917	Yakuntzov	Ellwood	4/2/12	Sydney - Bondi	Retail assistant	Part-time	13,255
21817	Billington	Karmen	1/22/12	Sydney - Bondi	Retail assistant	Part-time	40,861
45524	Laurisch	Barthel	4/26/17	Sydney - Bondi	Retail assistant	Part-time	42,087
35486	Bisley	Debee	3/6/21	Sydney - Bondi	Supervisor	Full time	51,068
17664	Levesque	Lynnea	7/30/20	Sydney - CBD	Retail assistant	Casual	28,076
38157	Braid	Kassie	7/24/19	Sydney - CBD	Retail assistant	Casual	48,742
91805	Sallowaye	Adrea	9/20/19	Sydney - CBD	Retail assistant	Casual	40,542
81083	Worge	Tisha	5/2/21	Sydney - CBD	Retail assistant	Full time	36,250
64483	Sawl	Janella	4/16/20	Sydney - CBD	Retail assistant	Full time	58,923
62370	Lasham	D'arcy	5/20/20	Sydney - CBD	Retail assistant	Part-time	42,046
41617	Derye-Barrett	Godfree	2/1/15	Sydney - CBD	Retail assistant	Part-time	23,805
54116	Marcome	Willow	4/22/18	Sydney - CBD	Retail assistant	Part-time	40,913
92586	Iacovaccio	Abbe	3/29/17	Sydney - CBD	Retail assistant	Part-time	31,234
39755	Brockie	Iago	1/4/20	Sydney - CBD	Supervisor	Full time	63,525
63859	Gong	Damiano	9/19/21	Sydney - Chatswood	Retail assistant	Casual	9,345
84065	Quartley	Heinrick	3/10/19	Sydney - Chatswood	Retail assistant	Casual	18,871
18779	Mayling	Elonore	7/4/19	Sydney - Chatswood	Retail assistant	Casual	20,370
78277	Cotterell	Minor	4/29/21	Sydney - Chatswood	Retail assistant	Full time	40,147
61664	Lomath	Peta	11/5/20	Sydney - Chatswood	Retail assistant	Full time	58,923
99185	De Vaar	Sterne	11/12/19	Sydney - Chatswood	Retail assistant	Part-time	43,953
816	Mancer	Marin	4/9/16	Sydney - Chatswood	Retail assistant	Part-time	40,982
3101	McAughtrie	Nealy	8/11/18	Sydney - Chatswood	Retail assistant	Part-time	44,680
78067	Willan	Ariel	9/8/17	Sydney - Chatswood	Retail assistant	Part-time	40,874
34926	Yeardsley	Dacia	3/3/21	Sydney - Chatswood	Supervisor	Full time	54,281
79133	Dursley	Orville	5/8/19	Sydney - Homebush	Retail assistant	Casual	22,156
24130	Truitt	Clio	7/30/21	Sydney - Homebush	Retail assistant	Casual	16,849
88096	Pagitt	Em	9/30/21	Sydney - Homebush	Retail assistant	Casual	7,430
5037	Powelee	Joana	12/21/20	Sydney - Homebush	Retail assistant	Full time	57,490
18796	Le Provost	Kelby	12/22/21	Sydney - Homebush	Retail assistant	Full time	1,456
27775	Harsnep	Marcellina	4/23/20	Sydney - Homebush	Retail assistant	Part-time	24,062
83250	Kamenar	Gabbie	3/11/13	Sydney - Homebush	Retail assistant	Part-time	22,808
55687	Cocksedge	Korie	5/13/13	Sydney - Homebush	Retail assistant	Part-time	43,457
71113	Sprionghall	Toby	8/20/18	Sydney - Homebush	Retail assistant	Part-time	31,567
56669	Danilowicz	Cheryl	11/28/20	Sydney - Homebush	Supervisor	Full time	60,565
82326	Goomes	Calypso	7/7/20	Sydney - Macquarie	Retail assistant	Casual	15,656
39197	Lagde	Celestyn	8/11/20	Sydney - Macquarie	Retail assistant	Casual	34,680
12039	Teasdale	Nollie	2/17/21	Sydney - Macquarie	Retail assistant	Casual	28,409
75893	Kemson	Hunfredo	10/7/21	Sydney - Macquarie	Retail assistant	Full time	13,865
97722	Housbie	Boony	7/21/21	Sydney - Macquarie	Retail assistant	Full time	26,397
55918	Moscone	Darn	3/27/20	Sydney - Macquarie	Retail assistant	Part-time	43,992
81212	Coe	Abagail	12/20/17	Sydney - Macquarie	Retail assistant	Part-time	44,077
92739	Imlaw	Conney	2/8/17	Sydney - Macquarie	Retail assistant	Part-time	40,652
51908	Bartocci	Marcelline	10/30/13	Sydney - Macquarie	Retail assistant	Part-time	42,824
82355	Noir	Matt	11/24/19	Sydney - Macquarie	Supervisor	Full time	55,548
97609	Amery	Georges	9/20/21	Sydney - Pitt Street	Retail assistant	Casual	7,650
10530	Viggars	Jesselyn	6/11/21	Sydney - Pitt Street	Retail assistant	Casual	19,672
14049	Wotton	Clemens	12/20/20	Sydney - Pitt Street	Retail assistant	Casual	32,920
43670	Hovington	Ermengarde	9/25/20	Sydney - Pitt Street	Retail assistant	Full time	54,243
26724	Merit	Mac	3/13/20	Sydney - Pitt Street	Retail assistant	Full time	58,123
28930	Newall	Wally	4/27/19	Sydney - Pitt Street	Retail assistant	Part-time	44,400
61598	Sobczak	Anny	4/28/16	Sydney - Pitt Street	Retail assistant	Part-time	21,691
27289	Smith	Lian	10/17/13	Sydney - Pitt Street	Retail assistant	Part-time	23,283
28603	Wakelin	Datha	7/16/15	Sydney - Pitt Street	Retail assistant	Part-time	44,836
27882	Genn	Katalin	10/17/19	Sydney - Pitt Street	Supervisor	Full time	54,481
41623	Westfalen	Gabriele	9/11/19	Tamworth	Retail assistant	Casual	23,400
85251	Doni	Rodolph	3/19/20	Tamworth	Retail assistant	Casual	21,600
25420	Hufton	Esme	5/19/21	Tamworth	Retail assistant	Casual	20,805
47565	Lardner	Stevana	7/8/20	Tamworth	Retail assistant	Casual	46,652
18362	Riggoll	Sheilakathryn	11/20/19	Tamworth	Retail assistant	Casual	13,282
10871	Mazillius	Umberto	10/23/19	Tamworth	Retail assistant	Full time	58,923
72362	Parvin	Marshall	5/31/17	Tamworth	Retail assistant	Part-time	42,667
74340	St. Pierre	Jeri	10/28/17	Tamworth	Supervisor	Full time	60,985
29302	Nequest	Mindy	10/17/21	Tauranga	Retail assistant	Casual	22,450
61444	Pimbley	Gualterio	4/27/20	Tauranga	Retail assistant	Casual	23,679
59771	Cornforth	Pamella	5/30/21	Tauranga	Retail assistant	Casual	19,813
95871	Borchardt	Angy	7/24/20	Tauranga	Retail assistant	Casual	42,623
95070	Geoghegan	Marisa	1/25/19	Tauranga	Retail assistant	Full time	56,565
68505	Castro	Dalston	9/18/14	Tauranga	Retail assistant	Part-time	40,898
57454	Ruddle	Lorilee	10/29/15	Tauranga	Supervisor	Full time	57,350
32470	Zelley	Allsun	11/12/20	Townsville	Retail assistant	Casual	31,366
75446	Box	Pearline	3/11/22	Townsville	Retail assistant	Casual	28,008
42485	Purser	Harald	4/26/20	Townsville	Retail assistant	Casual	33,976
74893	Brando	Edouard	6/28/21	Townsville	Retail assistant	Casual	23,167
47843	Palfery	Brinn	8/23/19	Townsville	Retail assistant	Full time	58,752
34480	Naul	Donny	1/10/19	Townsville	Retail assistant	Full time	58,712
66406	Hudghton	Bendite	2/27/15	Townsville	Retail assistant	Part-time	42,355
57287	Brompton	Matty	7/1/20	Townsville	Supervisor	Full time	55,824
58096	Dederick	Karole	11/2/20	Wagga Wagga	Retail assistant	Casual	24,444
92169	Bearcroft	Farah	12/12/21	Wagga Wagga	Retail assistant	Casual	1,507
90764	Stamper	Alia	7/4/19	Wagga Wagga	Retail assistant	Casual	44,841
15301	Theobold	Matthus	2/21/19	Wagga Wagga	Retail assistant	Casual	31,646
67124	Burnie	Eustacia	4/29/20	Wagga Wagga	Retail assistant	Full time	56,123
57934	Skyppe	Hephzibah	8/4/18	Wagga Wagga	Supervisor	Full time	61,311
84268	Karpf	Waylon	8/18/19	Wellington	Retail assistant	Casual	33,684
15400	Sorbey	Jillane	10/30/20	Wellington	Retail assistant	Casual	30,474
82679	Hatherall	Dotti	11/10/20	Wellington	Retail assistant	Casual	48,416
41371	Chaney	Justinian	12/18/20	Wellington	Retail assistant	Casual	19,900
71599	Lyddy	Sonny	9/24/19	Wellington	Retail assistant	Full time	47,368
33661	McTrustrie	Frankie	7/7/20	Wellington	Retail assistant	Full time	57,461
32223	Pinwell	Nikolos	5/8/14	Wellington	Retail assistant	Part-time	40,044
61894	Arsmith	Trent	7/13/20	Wellington	Supervisor	Full time	54,630

IncSt Act

SUBTERRAIN LIMITED		2024	2024
Management accounts		Jan	Feb
Profit and loss statement		1	2
		Actual	Actual
Sales revenue	Retail	7,105	7,208
	Online	420	501
	Corp/clubs	2,017	1,893
Sales revenue		9,542	9,602
	Opening Inventory	11,000	10,750
	Purchases	4,188	4,740
	Closing Inventory	10,750	11,078
Cost of sales		4,438	4,412
Gross profit		5,104	5,190
	Retail	3,851	3,920
	Online	207	250
	CC	1,046	1,020
		53.5%	54.1%
Overheads
	Accounting and consulting fees	11	9
	Advertising and marketing	150	190
	IT Expenses	142	142
	Legal and professional fees	7	7
	Motor vehicle expenses	20	22
	Power and utilities	48	62
	Rent	961	961
	Repairs and Maintenance	20	36
	Staff training and amenities	- 0	86
	Travel	25	60
	Other expenses	420	490
	Wages and salaries	2,016	2,035
	Superannuation	202	204
Total overheads		4,022	4,304
EBITDA		1,082	886
Depreciation		88	88
Operating profit		994	798
Financing income
Interest		- 13	- 13
PBT		981	785
Income tax		- 275	- 220
Profit after tax		706	565

Calcs>>

Store revenue

Store revenue calculation - closing stores					2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
					Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
					1	2	3	4	5	6	7	8	9	10	11	12
Start date					1/1/24	2/1/24	3/1/24	4/1/24	5/1/24	6/1/24	7/1/24	8/1/24	9/1/24	10/1/24	11/1/24	12/1/24
					1/31/24	2/29/24	3/31/24	4/30/24	5/31/24	6/30/24	7/31/24	8/31/24	9/30/24	10/31/24	11/30/24	12/31/24
Store name	Closure date	2023 Budget Revenue $	2023 Budget Gross margin $	GM%	10.0%	10.0%	7.5%	7.5%	7.5%	10.0%	7.5%	7.5%	7.5%	7.5%	7.5%	10.0%
Bass Coast	31/05/2024	452,076	216,996	48.00%	1	1	1	1	1	0	0	0	0	0	0	0	Flags 1=open, 0= closed
Orange	15/06/2024	624,900	287,454	46.00%	1	1	1	1	1	0	0	0	0	0	0	0
Alice Springs	30/04/2024	756,204	370,553	49.00%	1	1	1	1	0	0	0	0	0	0	0	0
Sydney - Auburn	01/07/2024	1,490,324	760,238	51.01%	1	1	1	1	1	1	0	0	0	0	0	0
Townsville	30/09/2024	956,213	478,107	50.00%	1	1	1	1	1	1	1	1	1	0	0	0
Tauranga	01/08/2024	784,529	381,429	48.62%	1	1	1	1	1	1	1	0	0	0	0	0
Melbourne - Chadstone	01/10/2024	1,634,890	784,747	48.00%	1	1	1	1	1	1	1	1	1	0	0	0
Greenhills	01/11/2024	653,078	326,539	50.00%	1	1	1	1	1	1	1	1	1	1	0	0
Mildura	15/07/2024	590,342	295,835	50.11%	1	1	1	1	1	1	0	0	0	0	0	0
Perisher	01/09/2024	402,389	285,104	70.85%	1	1	1	1	1	1	1	1	0	0	0	0
		8,344,945	4,187,002
Revenue 2023 (BAU)
Bass Coast					45,208	45,208	33,906	33,906	33,906	45,208	33,906	33,906	33,906	33,906	33,906	45,208	452,076	TRUE
Orange					62,490	62,490	46,868	46,868	46,868	62,490	46,868	46,868	46,868	46,868	46,868	62,490	624,900	TRUE
Alice Springs					75,620	75,620	56,715	56,715	56,715	75,620	56,715	56,715	56,715	56,715	56,715	75,620	756,204	TRUE
Sydney - Auburn					149,032	149,032	111,774	111,774	111,774	149,032	111,774	111,774	111,774	111,774	111,774	149,032	1,490,324	TRUE
Townsville					95,621	95,621	71,716	71,716	71,716	95,621	71,716	71,716	71,716	71,716	71,716	95,621	956,213	TRUE
Tauranga					78,453	78,453	58,840	58,840	58,840	78,453	58,840	58,840	58,840	58,840	58,840	78,453	784,529	TRUE
Melbourne - Chadstone					163,489	163,489	122,617	122,617	122,617	163,489	122,617	122,617	122,617	122,617	122,617	163,489	1,634,890	TRUE
Greenhills					65,308	65,308	48,981	48,981	48,981	65,308	48,981	48,981	48,981	48,981	48,981	65,308	653,078	TRUE
Mildura					59,034	59,034	44,276	44,276	44,276	59,034	44,276	44,276	44,276	44,276	44,276	59,034	590,342	TRUE
Perisher					40,239	40,239	30,179	30,179	30,179	40,239	30,179	30,179	30,179	30,179	30,179	40,239	402,389	TRUE
Total $					834,495	834,495	625,871	625,871	625,871	834,495	625,871	625,871	625,871	625,871	625,871	834,495	8,344,945	TRUE
Total in $000					834.5	834.5	625.9	625.9	625.9	834.5	625.9	625.9	625.9	625.9	625.9	834.5	8,344.9
Gross margin 2023 (BAU)					418,700	418,700	314,025	314,025	314,025	418,700	314,025	314,025	314,025	314,025	314,025	418,700	4,187,002.0	TRUE
Total in $000					418.7	418.7	314.0	314.0	314.0	418.7	314.0	314.0	314.0	314.0	314.0	418.7	4,187
Revenue 2024
Bass Coast					45,208	45,208	33,906	33,906	33,906	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Orange					62,490	62,490	46,868	46,868	46,868	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Alice Springs					75,620	75,620	56,715	56,715	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Sydney - Auburn					149,032	149,032	111,774	111,774	111,774	149,032	- 0	- 0	- 0	- 0	- 0	- 0
Townsville					95,621	95,621	71,716	71,716	71,716	95,621	71,716	71,716	71,716	- 0	- 0	- 0
Tauranga					78,453	78,453	58,840	58,840	58,840	78,453	58,840	- 0	- 0	- 0	- 0	- 0
Melbourne - Chadstone					163,489	163,489	122,617	122,617	122,617	163,489	122,617	122,617	122,617	- 0	- 0	- 0
Greenhills					65,308	65,308	48,981	48,981	48,981	65,308	48,981	48,981	48,981	48,981	- 0	- 0
Mildura					59,034	59,034	44,276	44,276	44,276	59,034	- 0	- 0	- 0	- 0	- 0	- 0
Perisher					40,239	40,239	30,179	30,179	30,179	40,239	30,179	30,179	- 0	- 0	- 0	- 0
Total $					834,495	834,495	625,871	625,871	569,156	651,177	332,332	273,493	243,314	48,981	- 0	- 0
Total in $000					834.5	834.5	625.9	625.9	569.2	651.2	332.3	273.5	243.3	49.0	- 0	- 0
GM 2024
Bass Coast				48.00%	21,700	21,700	16,275	16,275	16,275	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Orange				46.00%	28,745	28,745	21,559	21,559	21,559	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Alice Springs				49.00%	37,055	37,055	27,791	27,791	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Sydney - Auburn				51.01%	76,024	76,024	57,018	57,018	57,018	76,024	- 0	- 0	- 0	- 0	- 0	- 0
Townsville				50.00%	47,811	47,811	35,858	35,858	35,858	47,811	35,858	35,858	35,858	- 0	- 0	- 0
Tauranga				48.62%	38,143	38,143	28,607	28,607	28,607	38,143	28,607	- 0	- 0	- 0	- 0	- 0
Melbourne - Chadstone				48.00%	78,475	78,475	58,856	58,856	58,856	78,475	58,856	58,856	58,856	- 0	- 0	- 0
Greenhills				50.00%	32,654	32,654	24,490	24,490	24,490	32,654	24,490	24,490	24,490	24,490	- 0	- 0
Mildura				50.11%	29,584	29,584	22,188	22,188	22,188	29,584	- 0	- 0	- 0	- 0	- 0	- 0
Perisher				70.85%	28,510	28,510	21,383	21,383	21,383	28,510	21,383	21,383	- 0	- 0	- 0	- 0
Total $					418,700	418,700	314,025	314,025	286,234	331,200	169,194	140,587	119,204	24,490	- 0	- 0
Total in $000					418.7	418.7	314.0	314.0	286.2	331.2	169.2	140.6	119.2	24.5	- 0	- 0

Rent C

Rent calculation - closing stores												2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
												Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
												1	2	3	4	5	6	7	8	9	10	11	12
												1/1/24	2/1/24	3/1/24	4/1/24	5/1/24	6/1/24	7/1/24	8/1/24	9/1/24	10/1/24	11/1/24	12/1/24
												1/31/24	2/29/24	3/31/24	4/30/24	5/31/24	6/30/24	7/31/24	8/31/24	9/30/24	10/31/24	11/30/24	12/31/24
												$	$	$	$	$	$	$	$	$	$	$	$
2023 Full year rental expense	Closure date	Annual rent (2023)	Annual increases (per lease) %	Reformat	Lease end dates	Break lease fee	Fee in mths	2024 Annual rent (full year)	Rent per month split	Breaking lease?	Closing month
Bass Coast	5/31/24	68,554	5.7	5.7%	1/1/26	2 mths	2	72,434	8.3%	1	5	6,036	6,036	6,036	6,036	6,036	6,036	6,036	6,036	6,036	6,036	6,036	6,036
Orange	6/15/24	62,358	- 0	0.0%	7/1/23	3 mths	3	62,358	8.3%	0	6	5,197	5,197	5,197	5,197	5,197	5,197	5,197	5,197	5,197	5,197	5,197	5,197
Alice Springs	4/30/24	87,056	4.2	4.2%	8/1/23	0 mths	0	90,712	8.3%	0	4	7,559	7,559	7,559	7,559	7,559	7,559	7,559	7,559	7,559	7,559	7,559	7,559
Sydney - Auburn	7/1/24	325,789	5.0	5.0%	9/1/24	3 mths	3	342,078	8.3%	1	7	28,507	28,507	28,507	28,507	28,507	28,507	28,507	28,507	28,507	28,507	28,507	28,507
Townsville	9/30/24	141,436	5.0	5.0%	10/1/25	1 mths	1	148,508	8.3%	1	9	12,376	12,376	12,376	12,376	12,376	12,376	12,376	12,376	12,376	12,376	12,376	12,376
Tauranga	8/1/24	60,789	1.8	1.8%	6/1/24	0 mths	0	61,883	8.3%	0	8	5,157	5,157	5,157	5,157	5,157	5,157	5,157	5,157	5,157	5,157	5,157	5,157
Melbourne - Chadstone	10/1/24	348,798	7.0	7.0%	7/1/23	0 mths	0	373,214	8.3%	0	10	31,101	31,101	31,101	31,101	31,101	31,101	31,101	31,101	31,101	31,101	31,101	31,101
Greenhills	11/1/24	55,221	8.0	8.0%	9/1/23	0 mths	0	59,639	8.3%	0	11	4,970	4,970	4,970	4,970	4,970	4,970	4,970	4,970	4,970	4,970	4,970	4,970
Mildura	7/15/24	60,124	6.2	6.2%	4/1/25	3 mths	3	63,852	8.3%	1	7	5,321	5,321	5,321	5,321	5,321	5,321	5,321	5,321	5,321	5,321	5,321	5,321
Perisher	9/1/24	64,354	3.6	3.6%	11/1/23	3 mths	3	66,671	8.3%	0	9	5,556	5,556	5,556	5,556	5,556	5,556	5,556	5,556	5,556	5,556	5,556	5,556
Total 2022 (no change)												111,779	111,779	111,779	111,779	111,779	111,779	111,779	111,779	111,779	111,779	111,779	111,779
Convert to $000												111.8	111.8	111.8	111.8	111.8	111.8	111.8	111.8	111.8	111.8	111.8	111.8
2024 Open/Closed flags
Bass Coast	5/31/24											1	1	1	1	1	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Orange	6/15/24											1	1	1	1	1	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Alice Springs	4/30/24											1	1	1	1	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Sydney - Auburn	7/1/24											1	1	1	1	1	1	- 0	- 0	- 0	- 0	- 0	- 0
Townsville	9/30/24											1	1	1	1	1	1	1	1	1	- 0	- 0	- 0
Tauranga	8/1/24											1	1	1	1	1	1	1	- 0	- 0	- 0	- 0	- 0
Melbourne - Chadstone	10/1/24											1	1	1	1	1	1	1	1	1	- 0	- 0	- 0
Greenhills	11/1/24											1	1	1	1	1	1	1	1	1	1	- 0	- 0
Mildura	7/15/24											1	1	1	1	1	1	- 0	- 0	- 0	- 0	- 0	- 0
Perisher	9/1/24											1	1	1	1	1	1	1	1	- 0	- 0	- 0	- 0
2024 Rent after store closures
Bass Coast												6,036	6,036	6,036	6,036	6,036	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Orange												5,197	5,197	5,197	5,197	5,197	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Alice Springs												7,559	7,559	7,559	7,559	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Sydney - Auburn												28,507	28,507	28,507	28,507	28,507	28,507	- 0	- 0	- 0	- 0	- 0	- 0
Townsville												12,376	12,376	12,376	12,376	12,376	12,376	12,376	12,376	12,376	- 0	- 0	- 0
Tauranga												5,157	5,157	5,157	5,157	5,157	5,157	5,157	- 0	- 0	- 0	- 0	- 0
Melbourne - Chadstone												31,101	31,101	31,101	31,101	31,101	31,101	31,101	31,101	31,101	- 0	- 0	- 0
Greenhills												4,970	4,970	4,970	4,970	4,970	4,970	4,970	4,970	4,970	4,970	- 0	- 0
Mildura												5,321	5,321	5,321	5,321	5,321	5,321	- 0	- 0	- 0	- 0	- 0	- 0
Perisher												5,556	5,556	5,556	5,556	5,556	5,556	5,556	5,556	- 0	- 0	- 0	- 0
Total rent (closed stores)												111,779	111,779	111,779	111,779	104,220	92,987	59,160	54,003	48,447	4,970	- 0	- 0
Convert to $000												111.8	111.8	111.8	111.8	104.2	93.0	59.2	54.0	48.4	5.0	- 0	- 0
Break lease fees
Bass Coast												- 0	- 0	- 0	- 0	12,072	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Orange												- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Alice Springs												- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Sydney - Auburn												- 0	- 0	- 0	- 0	- 0	- 0	85,520	- 0	- 0	- 0	- 0	- 0
Townsville												- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	12,376	- 0	- 0	- 0
Tauranga												- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Melbourne - Chadstone												- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Greenhills												- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Mildura												- 0	- 0	- 0	- 0	- 0	- 0	15,963	- 0	- 0	- 0	- 0	- 0
Perisher												- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total												- 0	- 0	- 0	- 0	12,072	- 0	101,483	- 0	12,376	- 0	- 0	- 0
Convert to $000												- 0	- 0	- 0	- 0	12.1	- 0	101.5	- 0	12.4	- 0	- 0	- 0

Wages C

Wages calculation - closing stores	Employee number	Last Name	First Name	Start date	Store	Job Title	Employee status	Total wages (2022)	Closure date	Years in service to	2024 Wages	Status flag	Years in service to	Redundancy pay	1/31/24	2/29/24	3/31/24	4/30/24	5/31/24	6/30/24	7/31/24	8/31/24	9/30/24	10/31/24	11/30/24	12/31/24
Month								$		12/31/22			closure date		1	2	3	4	5	6	7	8	9	10	11	12
Seasonailty %								(actual)			annualised	(1 perm/0 casual)			10%	10%	7.50%	7.50%	7.50%	10.00%	7.50%	7.50%	7.50%	7.50%	7.50%	10.00%
Bass Coast	15863	Lashmore	Berni	5/10/22	Bass Coast	Retail assistant	Casual	22,012	5/31/24	0.64	34,304	0	2.06	- 0	3,430	3,430	2,573	2,573	2,573	0	0	0	0	0	0	0
	69496	Allkins	Gae	12/15/20	Bass Coast	Retail assistant	Casual	22,567	5/31/24	2.04	22,567	0	3.46	- 0	2,257	2,257	1,693	1,693	1,693	0	0	0	0	0	0	0
	87777	Bowfin	Madlen	12/30/21	Bass Coast	Retail assistant	Casual	46,137	5/31/24	1.00	46,137	0	2.42	- 0	4,614	4,614	3,460	3,460	3,460	0	0	0	0	0	0	0
	238	Petr	Mose	3/27/21	Bass Coast	Retail assistant	Casual	30,569	5/31/24	1.76	30,569	0	3.18	- 0	3,057	3,057	2,293	2,293	2,293	0	0	0	0	0	0	0
	41291	Toplis	Vikki	6/13/20	Bass Coast	Retail assistant	Full time	58,712	5/31/24	2.55	58,712	1	3.97	4,479	5,871	5,871	4,403	4,403	4,403	0	0	0	0	0	0	0
	88041	Hay	Coretta	11/25/16	Bass Coast	Retail assistant	Part-time	32,131	5/31/24	6.10	32,131	1	7.52	4,645	3,213	3,213	2,410	2,410	2,410	0	0	0	0	0	0	0
	43185	O'Kuddyhy	Mohandis	2/11/14	Bass Coast	Supervisor	Full time	57,727	5/31/24	8.89	57,727	1	10.31	11,441	5,773	5,773	4,330	4,330	4,330	0	0	0	0	0	0	0
Orange	98296	Cuttelar	Cherye	12/5/22	Orange	Retail assistant	Casual	1,694	6/15/24	0.07	23,455	0	1.53	- 0	2,346	2,346	1,759	1,759	1,759	0	0	0	0	0	0	0
	9787	Valasek	Billy	12/5/22	Orange	Retail assistant	Casual	2,161	6/15/24	0.07	29,922	0	1.53	- 0	2,992	2,992	2,244	2,244	2,244	0	0	0	0	0	0	0
	35227	Buesnel	Selena	9/30/22	Orange	Retail assistant	Casual	7,327	6/15/24	0.25	29,308	0	1.71	- 0	2,931	2,931	2,198	2,198	2,198	0	0	0	0	0	0	0
	72460	Phippen	Juanita	7/13/19	Orange	Retail assistant	Casual	39,034	6/15/24	3.47	39,034	0	4.92	- 0	3,903	3,903	2,928	2,928	2,928	0	0	0	0	0	0	0
	28599	Tuberfield	Aurelie	6/30/21	Orange	Retail assistant	Full time	29,842	6/15/24	1.50	29,842	1	2.96	1,698	2,984	2,984	2,238	2,238	2,238	0	0	0	0	0	0	0
	53129	Tombling	Burke	11/27/15	Orange	Retail assistant	Part-time	32,123	6/15/24	7.09	32,123	1	8.55	5,282	3,212	3,212	2,409	2,409	2,409	0	0	0	0	0	0	0
	34964	Mathely	Rafaela	1/31/14	Orange	Supervisor	Full time	56,201	6/15/24	8.92	56,201	1	10.38	11,213	5,620	5,620	4,215	4,215	4,215	0	0	0	0	0	0	0
Alice Springs	33416	Crighton	Ethe	3/30/22	Alice Springs	Retail assistant	Casual	22,500	4/30/24	0.75	30,000	0	2.08	- 0	3,000	3,000	2,250	2,250	0	0	0	0	0	0	0	0
	14160	Lamperti	Hieronymus	9/23/20	Alice Springs	Retail assistant	Casual	23,780	4/30/24	2.27	23,780	0	3.60	- 0	2,378	2,378	1,784	1,784	0	0	0	0	0	0	0	0
	41269	Omrod	Federica	5/30/21	Alice Springs	Retail assistant	Casual	28,920	4/30/24	1.58	28,920	0	2.92	- 0	2,892	2,892	2,169	2,169	0	0	0	0	0	0	0	0
	17432	Trafford	Sandi	11/18/20	Alice Springs	Retail assistant	Casual	49,495	4/30/24	2.12	49,495	0	3.45	- 0	4,950	4,950	3,712	3,712	0	0	0	0	0	0	0	0
	87000	Brimilcome	Catherine	10/4/19	Alice Springs	Retail assistant	Full time	59,000	4/30/24	3.24	59,000	1	4.57	5,188	5,900	5,900	4,425	4,425	0	0	0	0	0	0	0	0
	89296	Rolston	Janis	2/3/17	Alice Springs	Retail assistant	Part-time	42,884	4/30/24	5.91	42,884	1	7.24	5,972	4,288	4,288	3,216	3,216	0	0	0	0	0	0	0	0
	30691	Currer	Kerry	3/28/18	Alice Springs	Supervisor	Full time	64,392	4/30/24	4.76	64,392	1	6.09	7,540	6,439	6,439	4,829	4,829	0	0	0	0	0	0	0	0
Sydney - Auburn	65149	Schmuhl	Rachel	2/11/22	Sydney - Auburn	Retail assistant	Casual	28,895	7/1/24	0.89	32,507	0	2.39	- 0	3,251	3,251	2,438	2,438	2,438	3,251	0	0	0	0	0	0
	84405	Giroldi	Hermy	4/18/21	Sydney - Auburn	Retail assistant	Casual	25,315	7/1/24	1.70	25,315	0	3.20	- 0	2,532	2,532	1,899	1,899	1,899	2,532	0	0	0	0	0	0
	77081	Pfeffel	Linet	10/8/19	Sydney - Auburn	Retail assistant	Casual	41,665	7/1/24	3.23	41,665	0	4.73	- 0	4,167	4,167	3,125	3,125	3,125	4,167	0	0	0	0	0	0
	3790	Darwent	Benita	8/3/20	Sydney - Auburn	Retail assistant	Full time	58,529	7/1/24	2.41	58,529	1	3.91	4,402	5,853	5,853	4,390	4,390	4,390	5,853	0	0	0	0	0	0
	77343	Pischof	Traci	9/13/21	Sydney - Auburn	Retail assistant	Full time	58,235	7/1/24	1.30	58,235	1	2.80	3,136	5,824	5,824	4,368	4,368	4,368	5,824	0	0	0	0	0	0
	69828	Dickerline	Massimo	1/7/21	Sydney - Auburn	Retail assistant	Part-time	43,330	7/1/24	1.98	43,330	1	3.48	2,903	4,333	4,333	3,250	3,250	3,250	4,333	0	0	0	0	0	0
	46854	Gainseford	Livia	3/18/18	Sydney - Auburn	Retail assistant	Part-time	44,437	7/1/24	4.79	44,437	1	6.29	5,372	4,444	4,444	3,333	3,333	3,333	4,444	0	0	0	0	0	0
	50068	Bambrough	Tymon	6/10/13	Sydney - Auburn	Retail assistant	Part-time	40,748	7/1/24	9.56	40,748	1	11.06	8,665	4,075	4,075	3,056	3,056	3,056	4,075	0	0	0	0	0	0
	12954	Wellington	Saundra	2/17/12	Sydney - Auburn	Retail assistant	Part-time	42,815	7/1/24	10.87	42,815	1	12.37	10,187	4,282	4,282	3,211	3,211	3,211	4,282	0	0	0	0	0	0
	12594	Hallas	Luis	1/1/20	Sydney - Auburn	Supervisor	Full time	64,506	7/1/24	3.00	64,506	1	4.50	5,582	6,451	6,451	4,838	4,838	4,838	6,451	0	0	0	0	0	0
Townsville	32470	Zelley	Allsun	11/12/20	Townsville	Retail assistant	Casual	31,366	9/30/24	2.14	31,366	0	3.88	- 0	3,137	3,137	2,352	2,352	2,352	3,137	2,352	2,352	2,352	0	0	0
	75446	Box	Pearline	3/11/22	Townsville	Retail assistant	Casual	28,008	9/30/24	0.81	34,769	0	2.55	- 0	3,477	3,477	2,608	2,608	2,608	3,477	2,608	2,608	2,608	0	0	0
	42485	Purser	Harald	4/26/20	Townsville	Retail assistant	Casual	33,976	9/30/24	2.68	33,976	0	4.43	- 0	3,398	3,398	2,548	2,548	2,548	3,398	2,548	2,548	2,548	0	0	0
	74893	Brando	Edouard	6/28/21	Townsville	Retail assistant	Casual	23,167	9/30/24	1.51	23,167	0	3.26	- 0	2,317	2,317	1,738	1,738	1,738	2,317	1,738	1,738	1,738	0	0	0
	47843	Palfery	Brinn	8/23/19	Townsville	Retail assistant	Full time	58,752	9/30/24	3.36	58,752	1	5.10	5,765	5,875	5,875	4,406	4,406	4,406	5,875	4,406	4,406	4,406	0	0	0
	34480	Naul	Donny	1/10/19	Townsville	Retail assistant	Full time	58,712	9/30/24	3.98	58,712	1	5.72	6,461	5,871	5,871	4,403	4,403	4,403	5,871	4,403	4,403	4,403	0	0	0
	66406	Hudghton	Bendite	2/27/15	Townsville	Retail assistant	Part-time	42,355	9/30/24	7.84	42,355	1	9.59	7,813	4,236	4,236	3,177	3,177	3,177	4,236	3,177	3,177	3,177	0	0	0
	57287	Brompton	Matty	7/1/20	Townsville	Supervisor	Full time	55,824	9/30/24	2.50	55,824	1	4.25	4,560	5,582	5,582	4,187	4,187	4,187	5,582	4,187	4,187	4,187	0	0	0
Tauranga	29302	Nequest	Mindy	10/17/21	Tauranga	Retail assistant	Casual	22,450	8/1/24	1.21	22,450	0	2.79	- 0	2,245	2,245	1,684	1,684	1,684	2,245	1,684	0	0	0	0	0
	61444	Pimbley	Gualterio	4/27/20	Tauranga	Retail assistant	Casual	23,679	8/1/24	2.68	23,679	0	4.26	- 0	2,368	2,368	1,776	1,776	1,776	2,368	1,776	0	0	0	0	0
	59771	Cornforth	Pamella	5/30/21	Tauranga	Retail assistant	Casual	19,813	8/1/24	1.58	19,813	0	3.17	- 0	1,981	1,981	1,486	1,486	1,486	1,981	1,486	0	0	0	0	0
	95871	Borchardt	Angy	7/24/20	Tauranga	Retail assistant	Casual	42,623	8/1/24	2.44	42,623	0	4.02	- 0	4,262	4,262	3,197	3,197	3,197	4,262	3,197	0	0	0	0	0
	95070	Geoghegan	Marisa	1/25/19	Tauranga	Retail assistant	Full time	56,565	8/1/24	3.93	56,565	1	5.52	6,001	5,657	5,657	4,242	4,242	4,242	5,657	4,242	0	0	0	0	0
	68505	Castro	Dalston	9/18/14	Tauranga	Retail assistant	Part-time	40,898	8/1/24	8.29	40,898	1	9.87	7,762	4,090	4,090	3,067	3,067	3,067	4,090	3,067	0	0	0	0	0
	57454	Ruddle	Lorilee	10/29/15	Tauranga	Supervisor	Full time	57,350	8/1/24	7.17	57,350	1	8.76	9,656	5,735	5,735	4,301	4,301	4,301	5,735	4,301	0	0	0	0	0
Melbourne - Chadstone	85693	Pedgrift	Clarette	11/30/19	Melbourne - Chadstone	Retail assistant	Casual	22,040	10/1/24	3.08	22,040	0	4.84	- 0	2,204	2,204	1,653	1,653	1,653	2,204	1,653	1,653	1,653	0	0	0
	46618	Huyche	Sumner	5/25/21	Melbourne - Chadstone	Retail assistant	Casual	22,688	10/1/24	1.60	22,688	0	3.35	- 0	2,269	2,269	1,702	1,702	1,702	2,269	1,702	1,702	1,702	0	0	0
	48400	Eccott	Melina	5/24/22	Melbourne - Chadstone	Retail assistant	Casual	26,722	10/1/24	0.60	44,331	0	2.35	- 0	4,433	4,433	3,325	3,325	3,325	4,433	3,325	3,325	3,325	0	0	0
	29281	De Domenico	Alysia	5/15/20	Melbourne - Chadstone	Retail assistant	Full time	55,265	10/1/24	2.63	55,265	1	4.38	4,653	5,527	5,527	4,145	4,145	4,145	5,527	4,145	4,145	4,145	0	0	0
	79702	Blunden	Zebadiah	12/5/20	Melbourne - Chadstone	Retail assistant	Full time	56,646	10/1/24	2.07	56,646	1	3.82	4,164	5,665	5,665	4,248	4,248	4,248	5,665	4,248	4,248	4,248	0	0	0
	46742	Arlidge	Hettie	6/29/22	Melbourne - Chadstone	Retail assistant	Part-time	21,553	10/1/24	0.51	42,632	1	2.26	1,849	4,263	4,263	3,197	3,197	3,197	4,263	3,197	3,197	3,197	0	0	0
	40623	Grimley	Harland	8/9/17	Melbourne - Chadstone	Retail assistant	Part-time	40,128	10/1/24	5.39	40,128	1	7.14	5,513	4,013	4,013	3,010	3,010	3,010	4,013	3,010	3,010	3,010	0	0	0
	96560	Willimott	Isadore	1/30/15	Melbourne - Chadstone	Retail assistant	Part-time	42,614	10/1/24	7.92	42,614	1	9.67	7,924	4,261	4,261	3,196	3,196	3,196	4,261	3,196	3,196	3,196	0	0	0
	62726	Korbmaker	Ingelbert	1/5/13	Melbourne - Chadstone	Retail assistant	Part-time	42,133	10/1/24	9.99	42,133	1	11.74	9,511	4,213	4,213	3,160	3,160	3,160	4,213	3,160	3,160	3,160	0	0	0
	17364	Extance	Gabie	6/17/21	Melbourne - Chadstone	Supervisor	Full time	35,326	10/1/24	1.54	35,326	1	3.29	2,234	3,533	3,533	2,649	2,649	2,649	3,533	2,649	2,649	2,649	0	0	0
Greenhills	51542	Demoge	Rosamond	10/26/19	Greenhills	Retail assistant	Casual	33,506	11/1/24	3.18	33,506	0	5.01	- 0	3,351	3,351	2,513	2,513	2,513	3,351	2,513	2,513	2,513	2,513	0	0
	88324	Benoey	Joye	4/17/19	Greenhills	Retail assistant	Casual	23,432	11/1/24	3.71	23,432	0	5.54	- 0	2,343	2,343	1,757	1,757	1,757	2,343	1,757	1,757	1,757	1,757	0	0
	83644	Deme	Woodrow	10/6/19	Greenhills	Retail assistant	Casual	33,686	11/1/24	3.24	33,686	0	5.07	- 0	3,369	3,369	2,526	2,526	2,526	3,369	2,526	2,526	2,526	2,526	0	0
	85210	Guierre	Fredrika	3/21/19	Greenhills	Retail assistant	Casual	49,518	11/1/24	3.78	49,518	0	5.61	- 0	4,952	4,952	3,714	3,714	3,714	4,952	3,714	3,714	3,714	3,714	0	0
	57106	McRae	Gwenette	2/20/20	Greenhills	Retail assistant	Full time	58,712	11/1/24	2.86	58,712	1	4.70	5,304	5,871	5,871	4,403	4,403	4,403	5,871	4,403	4,403	4,403	4,403	0	0
	98801	Boyack	Shanon	6/28/13	Greenhills	Supervisor	Full time	56,211	11/1/24	9.51	56,211	1	11.34	12,260	5,621	5,621	4,216	4,216	4,216	5,621	4,216	4,216	4,216	4,216	0	0
Mildura	77160	Dale	Danie	10/4/19	Mildura	Retail assistant	Casual	22,678	7/15/24	3.24	22,678	0	4.78	- 0	2,268	2,268	1,701	1,701	1,701	2,268	0	0	0	0	0	0
	35750	Potbury	Fionna	8/20/22	Mildura	Retail assistant	Casual	11,692	7/15/24	0.36	32,131	0	1.90	- 0	3,213	3,213	2,410	2,410	2,410	3,213	0	0	0	0	0	0
	51798	Sherbourne	Karina	1/29/19	Mildura	Retail assistant	Casual	27,758	7/15/24	3.92	27,758	0	5.46	- 0	2,776	2,776	2,082	2,082	2,082	2,776	0	0	0	0	0	0
	45542	Stayte	Othilia	10/23/20	Mildura	Retail assistant	Casual	49,838	7/15/24	2.19	49,838	0	3.73	- 0	4,984	4,984	3,738	3,738	3,738	4,984	0	0	0	0	0	0
	27082	Wyper	Melosa	3/9/19	Mildura	Retail assistant	Full time	59,000	7/15/24	3.81	59,000	1	5.35	6,070	5,900	5,900	4,425	4,425	4,425	5,900	0	0	0	0	0	0
	24961	Heskins	Danit	8/10/15	Mildura	Retail assistant	Part-time	32,345	7/15/24	7.39	32,345	1	8.93	5,555	3,235	3,235	2,426	2,426	2,426	3,235	0	0	0	0	0	0
	20662	Slocomb	Donnie	8/31/16	Mildura	Supervisor	Full time	63,332	7/15/24	6.33	63,332	1	7.88	9,591	6,333	6,333	4,750	4,750	4,750	6,333	0	0	0	0	0	0
Perisher	11406	MacLucais	Lorenzo	3/2/21	Perisher	Retail assistant	Casual	19,811	9/1/24	1.83	19,811	0	3.50	- 0	1,981	1,981	1,486	1,486	1,486	1,981	1,486	1,486	0	0	0	0
	99172	Axford	Feodora	11/3/19	Perisher	Retail assistant	Casual	33,289	9/1/24	3.16	33,289	0	4.83	- 0	3,329	3,329	2,497	2,497	2,497	3,329	2,497	2,497	0	0	0	0
	54094	Sandwich	Shirline	2/21/20	Perisher	Retail assistant	Casual	28,724	9/1/24	2.86	28,724	0	4.53	- 0	2,872	2,872	2,154	2,154	2,154	2,872	2,154	2,154	0	0	0	0
	64054	Theodore	Rene	10/25/21	Perisher	Retail assistant	Casual	6,983	9/1/24	1.18	6,983	0	2.85	- 0	698	698	524	524	524	698	524	524	0	0	0	0
	77542	Cantor	Robbyn	8/23/20	Perisher	Retail assistant	Full time	58,594	9/1/24	2.36	58,594	1	4.02	4,532	5,859	5,859	4,395	4,395	4,395	5,859	4,395	4,395	0	0	0	0
	20800	Wloch	Fara	3/15/18	Perisher	Retail assistant	Part-time	44,267	9/1/24	4.79	44,267	1	6.46	5,500	4,427	4,427	3,320	3,320	3,320	4,427	3,320	3,320	0	0	0	0
	43675	Brinklow	Immanuel	1/27/12	Perisher	Supervisor	Full time	61,097	9/1/24	10.93	61,097	1	12.59	14,798	6,110	6,110	4,582	4,582	4,582	6,110	4,582	4,582	0	0	0	0
Total wages								2,912,809			3,073,604			245,180	307,360	307,360	230,520	230,520	208,135	225,310	113,545	93,792	74,834	19,130	0	0
Convert to $000								2,913			3,074			245.2	307.4	307.4	230.5	230.5	208.1	225.3	113.5	93.8	74.8	19.1	0.0	0.0
														TRUE
Redundancy													Month
Bass Coast									5/31/24				5	20,564	- 0	- 0	- 0	- 0	20,564	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Orange									6/15/24				6	18,193	- 0	- 0	- 0	- 0	- 0	18,193	- 0	- 0	- 0	- 0	- 0	- 0
Alice Springs									4/30/24				4	18,700	- 0	- 0	- 0	18,700	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Sydney - Auburn									7/1/24				7	40,247	- 0	- 0	- 0	- 0	- 0	- 0	40,247	- 0	- 0	- 0	- 0	- 0
Townsville									9/30/24				9	24,598	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	24,598	- 0	- 0	- 0
Tauranga									8/1/24				8	23,420	- 0	- 0	- 0	- 0	- 0	- 0	- 0	23,420	- 0	- 0	- 0	- 0
Melbourne - Chadstone									10/1/24				10	35,849	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	35,849	- 0	- 0
Greenhills									11/1/24				11	17,564	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	17,564	- 0
Mildura									7/15/24				7	21,216	- 0	- 0	- 0	- 0	- 0	- 0	21,216	- 0	- 0	- 0	- 0	- 0
Perisher									9/1/24				9	24,830	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	24,830	- 0	- 0	- 0
Total redundancy														245,180	- 0	- 0	- 0	18,700	20,564	18,193	61,463	23,420	49,429	35,849	17,564	- 0
Convert to $000														TRUE	- 0	- 0	- 0	18.7	20.6	18.2	61.5	23.4	49.4	35.8	17.6	- 0

Online revenue

Online revenue calculation - new growth				2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
				Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
				1	2	3	4	5	6	7	8	9	10	11	12
	Number	Month	Units
New website visitors (pm)	300,000	4	#	- 0	- 0	- 0	300,000	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Monthly increase	5%	5	% pm	0%	0%	0%	0%	5%	5%	5%	5%	5%	5%	5%	5%
Online visitors (calc)			#	- 0	- 0	- 0	300,000	315,000	330,750	347,288	364,652	382,884	402,029	422,130	443,237
Conversion rate to buyers	6%		#	- 0	- 0	- 0	18,000	18,900	19,845	20,837	21,879	22,973	24,122	25,328	26,594
Average net revenue (pp)	$100		$	- 0	- 0	- 0	1,800,000	1,890,000	1,984,500	2,083,725	2,187,911	2,297,307	2,412,172	2,532,781	2,659,420
Online revenue			$000	- 0	- 0	- 0	1,800	1,890	1,985	2,084	2,188	2,297	2,412	2,533	2,659	19,848

Working Cap

Working capital control accounts		2023	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
		Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
		(Budget)	1	2	3	4	5	6	7	8	9	10	11	12
Days in period			31	29	31	30	31	30	31	31	30	31	30	31
		$000	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget
Receivables - Credit Sales (C&C)
Days Receivable			21	21	21	21	21	21	21	21	21	21	21	21
Opening Receivables			1,065	1,366	1,371	960	992	960	1,323	960	960	992	960	992
Sales (credit)	IS		2,017	1,893	1,418	1,418	1,418	1,890	1,418	1,418	1,418	1,418	1,418	1,890
Cash Receipts	CF		1,716	1,889	1,828	1,385	1,450	1,527	1,780	1,418	1,385	1,450	1,385	1,602
Closing Receivables	BS	1,065	1,366	1,371	960	992	960	1,323	960	960	992	960	992	1,280
Trade Payables
Days Payable			30	30	30	30	30	30	30	30	30	30	30	30
Opening Payables			8,006	4,053	4,903	6,945	4,073	3,953	5,146	3,922	3,939	4,111	3,932	4,094
Purchases	IS		4,188	4,740	7,177	4,073	4,085	5,146	4,053	4,070	4,111	4,064	4,094	5,132
Cash Payments	CF		8,141	3,889	5,135	6,945	4,204	3,953	5,276	4,053	3,939	4,242	3,932	4,259
Closing Payables	BS	8,006	4,053	4,903	6,945	4,073	3,953	5,146	3,922	3,939	4,111	3,932	4,094	4,967
Wages Payable
Days Payable			14	14	14	14	14	14	14	14	14	14	14	14
Opening Payables			1,600	910	982	657	688	666	914	685	668	702	673	687
Wages and redundancy	IS		2,016	2,035	1,455	1,474	1,476	1,958	1,516	1,478	1,504	1,491	1,473	1,940
Cash Payments	CF		2,706	1,963	1,780	1,443	1,497	1,711	1,745	1,496	1,470	1,520	1,459	1,751
Closing Employee entitlements	BS	1,600	910	982	657	688	666	914	685	668	702	673	687	876
Superannuation payable
Opening Payables			- 0	202	406	552	146	291	485	146	291	437	146	291
Super for month	IS		202	204	146	146	146	194	146	146	146	146	146	194
Cash Payments	CF		- 0	- 0	- 0	552			485			437
Closing superannuation payable	BS	0	202	406	552	146	291	485	146	291	437	146	291	485
(assumed included in employee entitlements)

Act - Map

Subterrain Income Statement		2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
		1	2	3	4	5	6	7	8	9	10	11	12
Actual		Actual	Actual	Actual	Actual	Actual	Actual	Actual	Actual	Actual	Actual	Actual	Actual
		$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000
Sales revenue
	Stores - BAU	7,105	7,208
	Stores - closing
	Online - BAU	420	501
	Online - new growth
	Corporate & Clubs BAU	2,017	1,893
Sales revenue		9,542	9,602
Gross margin
	Stores - BAU	3,851	3,920
	Stores - closing
	Online - BAU	207	250
	Online - new growth
	Corporate & Clubs BAU	1,046	1,020
Total gross margin		5,104	5,190
Cost of sales		4,438	4,412
Inventory working
	Opening Inventory	11,000	10,750
	Purchases	4,188	4,740
	Closing Inventory	10,750	11,078
Overheads
BAU	Accounting and consulting fees	11	9
	Advertising and marketing	150	190
	IT Expenses	142	142
	Legal and professional fees	7	7
	Motor vehicle expenses	20	22
	Power and utilities	48	62
	Repairs and Maintenance	20	36
	Staff training and amenities	- 0	86
	Travel	25	60
	Other expenses	420	490
Adjustments
	Additional marketing
Rent	BAU	961	961
	Closing stores
	Break lease fees
Wages and salaries
	BAU	2,016	2,035
	Closing stores
	Redundancy
	Superannuation	202	204
Total overheads		4,022	4,304
EBITDA		1,082	886
Depreciation		88	88
Depreciation on website
Operating profit		994	798
Financing income
Interest		- 13	- 13
PBT		981	785
Income tax		- 275	- 220
Profit after tax		706	565
Check source		706	565
Vs Budget		612	612

Outputs 1>>

Link back to overview

Overview page

2023 Mth Bud

SUBTERRAIN LIMITED				2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023
Monthly Budget 2023 (BAU)				Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
				1	2	3	4	5	6	7	8	9	10	11	12
				Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	CHECKS
		Full Year		$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000
		2023
		Budget
	Seasonality			10%	10%	8%	8%	8%	10%	8%	8%	8%	8%	8%	10%
Sales revenue	Retail		75.0%	7,088	7,088	5,316	5,316	5,316	7,088	5,316	5,316	5,316	5,316	5,316	7,088	70,875
	Online		5.0%	473	473	354	354	354	473	354	354	354	354	354	473	4,725
	Corp/clubs		20.0%	1,890	1,890	1,418	1,418	1,418	1,890	1,418	1,418	1,418	1,418	1,418	1,890	18,900
Sales revenue		94,500		9,450	9,450	7,088	7,088	7,088	9,450	7,088	7,088	7,088	7,088	7,088	9,450	94,500	TRUE
	Opening Inventory	12,400		12,400	11,000	11,000	11,000	11,000	11,000	11,000	11,000	11,000	11,000	11,000	11,000
	Purchases	41,994		2,939	4,339	3,255	3,255	3,255	4,339	3,255	3,255	3,255	3,255	3,255	4,339	41,994
	Closing Inventory	11,000		11,000	11,000	11,000	11,000	11,000	11,000	11,000	11,000	11,000	11,000	11,000	11,000
Cost of sales		43,394		4,339	4,339	3,255	3,255	3,255	4,339	3,255	3,255	3,255	3,255	3,255	4,339	43,394
Gross profit		51,106		5,111	5,111	3,833	3,833	3,833	5,111	3,833	3,833	3,833	3,833	3,833	5,111	51,106	TRUE
	Retail		54.0%	3,827	3,827	2,870	2,870	2,870	3,827	2,870	2,870	2,870	2,870	2,870	3,827	38,273
	Online		54.0%	255	255	191	191	191	255	191	191	191	191	191	255	2,552
	CC		54.4%	1,028	1,028	771	771	771	1,028	771	771	771	771	771	1,028	10,282
Overheads
	Accounting and consulting fees	135	8.3%	11	11	11	11	11	11	11	11	11	11	11	11	135	TRUE
	Advertising and marketing	2,200	8.3%	183	183	183	183	183	183	183	183	183	183	183	183	2,200	TRUE
	IT Expenses	1,700	8.3%	142	142	142	142	142	142	142	142	142	142	142	142	1,700	TRUE
	Legal and professional fees	85	8.3%	7	7	7	7	7	7	7	7	7	7	7	7	85	TRUE
	Motor vehicle expenses	220	8.3%	18	18	18	18	18	18	18	18	18	18	18	18	220	TRUE
	Power and utilities	725	8.3%	60	60	60	60	60	60	60	60	60	60	60	60	725	TRUE
	Rent	11,530	8.3%	961	961	961	961	961	961	961	961	961	961	961	961	11,530	TRUE
	Repairs and Maintenance	345	8.3%	29	29	29	29	29	29	29	29	29	29	29	29	345	TRUE
	Staff training and amenities	750	8.3%	63	63	63	63	63	63	63	63	63	63	63	63	750	TRUE
	Travel	600	8.3%	50	50	50	50	50	50	50	50	50	50	50	50	600	TRUE
	Other expenses	5,500	8.3%	458	458	458	458	458	458	458	458	458	458	458	458	5,500	TRUE
	Wages and salaries	19,400	SEASONALITY	1,940	1,940	1,455	1,455	1,455	1,940	1,455	1,455	1,455	1,455	1,455	1,940	19,400	TRUE
	Superannuation	1,940	10.0%	194	194	146	146	146	194	146	146	146	146	146	194	1,940	TRUE
Total overheads		45,130		4,117	4,117	3,583	3,583	3,583	4,117	3,583	3,583	3,583	3,583	3,583	4,117	45,130	TRUE
		TRUE
EBITDA		5,976		994	994	250	250	250	994	250	250	250	250	250	994	5,976	TRUE
Depreciation		1,050	8.3%	88	88	88	88	88	88	88	88	88	88	88	88	1,050	TRUE
Operating profit		4,926		907	907	162	162	162	907	162	162	162	162	162	907	4,926	TRUE
Financing income		- 0															TRUE
Interest		(150)	8.3%	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(150)	TRUE
PBT		4,776		894	894	150	150	150	894	150	150	150	150	150	894	4,776	TRUE
Income tax		(1,336)	-28.0%	(250)	(250)	(42)	(42)	(42)	(250)	(42)	(42)	(42)	(42)	(42)	(250)	(1,336)	- 0
Profit after tax		3,440		644	644	108	108	108	644	108	108	108	108	108	644	3,440	- 0
Dividends		- 0
		TRUE

2024 Mth Bud

SUBTERRAIN LIMITED					2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2023
2024 Monthly Budget Income Statement					Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total	Total
					1	2	3	4	5	6	7	8	9	10	11	12
		Source	Assumptions		Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget
					$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000
Sales revenue
	Retail Stores - BAU				6,253	6,253	4,690	4,690	4,690	6,253	4,690	4,690	4,690	4,690	4,690	6,253	62,530
	Retail Stores - closing	STORE REV			834	834	626	626	569	651	332	273	243	49	- 0	- 0	5,039
	Online - BAU	2023 BUDGET			473	473	354	354	354	473	354	354	354	354	354	473	4,725
	Online - new growth	ONLINE REV			- 0	- 0	- 0	1,800	1,890	1,985	2,084	2,188	2,297	2,412	2,533	2,659	19,848
	Corporate & Clubs BAU	2023 BUDGET			1,890	1,890	1,418	1,418	1,418	1,890	1,418	1,418	1,418	1,418	1,418	1,890	18,900
Sales revenue					9,450	9,450	7,088	8,888	8,921	11,251	8,878	8,923	9,002	8,923	8,994	11,275	111,042	94,500
			Check		9,450	9,450	7,088
Gross margin
	Stores - BAU				3,409	3,409	2,556	2,556	2,556	3,409	2,556	2,556	2,556	2,556	2,556	3,409	34,085
	Stores - closing	STORE REV			419	419	314	314	286	331	169	141	119	24	- 0	- 0	2,536
																	- 0
	Online - BAU		54.0%		255	255	191	191	191	255	191	191	191	191	191	255	2,552
	Online - new growth	ONLINE REV	54.6%		- 0	- 0	- 0	982	1,031	1,083	1,137	1,194	1,253	1,316	1,382	1,451	10,827
	Corporate & Clubs BAU	2023 BUDGET	54.4%		1,028	1,028	771	771	771	1,028	771	771	771	771	771	1,028	10,282
Total gross margin					5,111	5,111	3,833	4,815	4,836	6,106	4,825	4,853	4,891	4,859	4,901	6,143	60,282	51,106
					54.1%	54.1%	54.1%	54.2%	54.2%	54.3%	54.3%	54.4%	54.3%	54.5%	54.5%	54.5%	54.3%	54.1%
Cost of sales					4,339	4,339	3,255	4,073	4,085	5,146	4,053	4,070	4,111	4,064	4,094	5,132	50,760	43,394
Inventory working
	Opening Inventory	PREV MTH			11,000	11,000	11,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000
	Purchases	CALC			4,339	4,339	7,255	4,073	4,085	5,146	4,053	4,070	4,111	4,064	4,094	5,132
	Closing Inventory	ASSUMPTIONS			11,000	11,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000

Overheads
BAU	Accounting and consulting fees	2023 BUDGET			11	11	11	11	11	11	11	11	11	11	11	11	135
	Advertising and marketing	2023 BUDGET			183	183	183	183	183	183	183	183	183	183	183	183	2,200
	IT Expenses	2023 BUDGET			142	142	142	142	142	142	142	142	142	142	142	142	1,700
	Legal and professional fees	2023 BUDGET			7	7	7	7	7	7	7	7	7	7	7	7	85
	Motor vehicle expenses	2023 BUDGET			18	18	18	18	18	18	18	18	18	18	18	18	220
	Power and utilities	2023 BUDGET			60	60	60	60	60	60	60	60	60	60	60	60	725
	Repairs and Maintenance	2023 BUDGET			29	29	29	29	29	29	29	29	29	29	29	29	345
	Staff training and amenities	2023 BUDGET			63	63	63	63	63	63	63	63	63	63	63	63	750
	Travel	2023 BUDGET			50	50	50	50	50	50	50	50	50	50	50	50	600
	Other expenses	2023 BUDGET			458	458	458	458	458	458	458	458	458	458	458	458	5,500
Adjustments
	Additional marketing	ASSUMPTIONS	$ 75		- 0	- 0	- 0	75	75	75	75	75	75	75	75	75	675
			4
Rent	BAU		4.6%		893	893	893	893	893	893	893	893	893	893	893	893	10,719
	Closing stores	RENT CALC			112	112	112	112	104	93	59	54	48	5	- 0	- 0	811
	Break lease fees	RENT CALC			- 0	- 0	- 0	- 0	12	- 0	101	- 0	12	- 0	- 0	- 0	126
Wages and salaries		SEASONALITY															- 0
	BAU				1,633	1,633	1,224	1,224	1,247	1,715	1,341	1,361	1,380	1,436	1,455	1,940	17,589
	Closing stores	WAGES CALC			307	307	231	231	208	225	114	94	75	19	- 0	- 0	1,811
	Redundancy	WAGES CALC			- 0	- 0	- 0	19	21	18	61	23	49	36	18	- 0	245
	Superannuation	ASSUMPTIONS	10.0%		194	194	146	146	146	194	146	146	146	146	146	194	1,940
Total overheads					4,161	4,161	3,627	3,721	3,727	4,235	3,813	3,668	3,701	3,631	3,608	4,124	46,176	45,130
EBITDA					950	950	206	1,094	1,109	1,871	1,012	1,185	1,191	1,228	1,293	2,019	14,106	5,976
Depreciation		ASSUMPTIONS			88	88	88	88	88	88	88	88	88	88	88	88	1,050
Amortisation on website		ASSUMPTIONS	$ 4,000	5	0	0	0	67	67	67	67	67	67	67	67	67	600
Operating profit		CALC	4		862	862	118	940	955	1,716	858	1,031	1,036	1,074	1,138	1,865	12,456
Financing income		ASSUMPTIONS															0
Interest		ASSUMPTIONS			(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(150)
PBT		CALC			850	850	106	927	942	1,704	846	1,019	1,024	1,061	1,126	1,852	12,306
Income tax		CALC	-28.0%		(238)	(238)	(30)	(260)	(264)	(477)	(237)	(285)	(287)	(297)	(315)	(519)	(3,447)
Profit after tax		CALC			612	612	76	667	678	1,227	609	734	737	764	811	1,333	8,859
2023 Budget					644	644	108	108	108	644	108	108	108	108	108	644	3,440

Outputs 2>>

Link back to overview

Overview page

F IS

SUBTERRAIN LIMITED				2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
Income Statement				Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
				1	2	3	4	5	6	7	8	9	10	11	12	Full Year
			Map to FS statements	Actual	Actual	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Forecast
				$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000
Sales revenue
	Stores - BAU		Cash receipts	7,105	7,208	4,690	4,690	4,690	6,253	4,690	4,690	4,690	4,690	4,690	6,253	64,337
	Stores - closing		Cash receipts	- 0	- 0	626	626	569	651	332	273	243	49	- 0	- 0	3,370
				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Online - BAU		Cash receipts	420	501	354	354	354	473	354	354	354	354	354	473	4,701
	Online - new growth		Cash receipts	- 0	- 0	- 0	1,800	1,890	1,985	2,084	2,188	2,297	2,412	2,533	2,659	19,848
	Corporate & Clubs BAU		Credit	2,017	1,893	1,418	1,418	1,418	1,890	1,418	1,418	1,418	1,418	1,418	1,890	19,030
Sales revenue				9,542	9,602	7,088	8,888	8,921	11,251	8,878	8,923	9,002	8,923	8,994	11,275	111,286
Gross margin
	Stores - BAU		n/a	3,851	3,920	2,556	2,556	2,556	3,409	2,556	2,556	2,556	2,556	2,556	3,409	35,039
	Stores - closing		n/a	- 0	- 0	314	314	286	331	169	141	119	24	- 0	- 0	1,699
				- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Online - BAU		n/a	207	250	191	191	191	255	191	191	191	191	191	255	2,498
	Online - new growth		n/a	- 0	- 0	- 0	982	1,031	1,083	1,137	1,194	1,253	1,316	1,382	1,451	10,827
	Corporate & Clubs BAU		n/a	1,046	1,020	771	771	771	1,028	771	771	771	771	771	1,028	10,291
Total gross margin				5,104	5,190	3,833	4,815	4,836	6,106	4,825	4,853	4,891	4,859	4,901	6,143	60,355
Cost of sales				4,438	4,412	3,255	4,073	4,085	5,146	4,053	4,070	4,111	4,064	4,094	5,132	50,931
Inventory working
	Opening Inventory			11,000	10,750	11,078	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000
	Purchases		Working capital	4,188	4,740	7,177	4,073	4,085	5,146	4,053	4,070	4,111	4,064	4,094	5,132
	Closing Inventory		Inventory	10,750	11,078	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000

Overheads
BAU	Accounting and consulting fees		Cash expenses	11	9	11	11	11	11	11	11	11	11	11	11	133
	Advertising and marketing		Cash expenses	150	190	183	183	183	183	183	183	183	183	183	183	2,173
	IT Expenses		Cash expenses	142	142	142	142	142	142	142	142	142	142	142	142	1,701
	Legal and professional fees		Cash expenses	7	7	7	7	7	7	7	7	7	7	7	7	85
	Motor vehicle expenses		Cash expenses	20	22	18	18	18	18	18	18	18	18	18	18	225
	Power and utilities		Cash expenses	48	62	60	60	60	60	60	60	60	60	60	60	714
	Repairs and Maintenance		Cash expenses	20	36	29	29	29	29	29	29	29	29	29	29	344
	Staff training and amenities		Cash expenses	- 0	86	63	63	63	63	63	63	63	63	63	63	711
	Travel		Cash expenses	25	60	50	50	50	50	50	50	50	50	50	50	585
	Other expenses		Cash expenses	420	490	458	458	458	458	458	458	458	458	458	458	5,493
Adjustments
	Additional marketing		Cash expenses	- 0	- 0	- 0	75	75	75	75	75	75	75	75	75	675
Rent	BAU		Cash expenses	961	961	893	893	893	893	893	893	893	893	893	893	10,854
	Closing stores		Cash expenses	- 0	- 0	112	112	104	93	59	54	48	5	- 0	- 0	587
	Break lease fees		Cash expenses	- 0	- 0	- 0	- 0	12	- 0	101	- 0	12	- 0	- 0	- 0	126
Wages and salaries
	BAU		Working cap	2,016	2,035	1,224	1,224	1,247	1,715	1,341	1,361	1,380	1,436	1,455	1,940	18,375
	Closing stores		Working cap	- 0	- 0	231	231	208	225	114	94	75	19	- 0	- 0	1,196
	Redundancy		Working cap	- 0	- 0	- 0	19	21	18	61	23	49	36	18	- 0	245
	Superannuation		Cash - lag	202	204	146	146	146	194	146	146	146	146	146	194	1,958
Total overheads				4,022	4,304	3,627	3,721	3,727	4,235	3,813	3,668	3,701	3,631	3,608	4,124	46,180
EBITDA				1,082	886	206	1,094	1,109	1,871	1,012	1,185	1,191	1,228	1,293	2,019	14,175
Depreciation			PP&E	88	88	88	88	88	88	88	88	88	88	88	88	1,051
Amortisation on website			PP&E	0	0	0	67	67	67	67	67	67	67	67	67	600
Operating profit				994	798	118	940	955	1,716	858	1,031	1,036	1,074	1,138	1,865	12,524
Interest			Cash	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(151)
PBT				981	785	106	927	942	1,704	846	1,019	1,024	1,061	1,126	1,852	12,373
Income tax		-28.0%	Lag	(275)	(220)	(30)	(260)	(264)	(477)	(237)	(285)	(287)	(297)	(315)	(519)	(3,466)
Profit after tax				706	565	76	667	678	1,227	609	734	737	764	811	1,333	8,907
2024 Budget		Check		612	612	76	667	678	1,227	609	734	737	764	811	1,333
Actual vs Budget				94	(47)	0	0	0	0	0	0	0	0	0	0

F CF

SUBTERRAIN LIMITED			2023	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
Cashflow			CY	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
				1	2	3	4	5	6	7	8	9	10	11	12
	Mapping	Source	Budget	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast
			($000s)	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000
Operating cashflows
Cash receipts
Sales receipts from customers - CASH		IS	94,377	7,525	7,709	5,670	7,470	7,503	9,361	7,460	7,506	7,585	7,505	7,577	9,385	92,256
Sales receipts from customers - CREDIT		WORKING CAP		1,716	1,889	1,828	1,385	1,450	1,527	1,780	1,418	1,385	1,450	1,385	1,602	18,815
Other cash receipts		2023 BUDGET	0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
				9,241	9,598	7,498	8,855	8,953	10,888	9,240	8,923	8,970	8,955	8,962	10,987	111,071
Cash payments
Payments to suppliers		WORKING CAP	(41,720)	(8,141)	(3,889)	(5,135)	(6,945)	(4,204)	(3,953)	(5,276)	(4,053)	(3,939)	(4,242)	(3,932)	(4,259)	(57,970)
Payments to staff		WORKING CAP	(21,296)	(2,706)	(1,963)	(1,780)	(1,443)	(1,497)	(1,711)	(1,745)	(1,496)	(1,470)	(1,520)	(1,459)	(1,751)	(20,540)
Superannuation payments		WORKING CAP		- 0	- 0	- 0	(552)	- 0	- 0	(485)	- 0	- 0	(437)	- 0	- 0	(1,473)
Interest		IS	(150)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(13)	(151)
Taxes		IS (lag)	(1,226)	(250)	(275)	(220)	(30)	(260)	(264)	(477)	(237)	(285)	(287)	(297)	(315)	(3,197)
Other cash expenses	Cash expenses	IS	(24,790)	(1,804)	(2,065)	(2,027)	(2,102)	(2,106)	(2,083)	(2,151)	(2,044)	(2,051)	(1,995)	(1,990)	(1,990)	(24,406)
				(12,914)	(8,205)	(9,174)	(11,084)	(8,080)	(8,023)	(10,147)	(7,842)	(7,757)	(8,493)	(7,690)	(8,328)	(107,737)
Net operating cashflows				(3,673)	1,392	(1,676)	(2,228)	873	2,865	(906)	1,081	1,213	462	1,272	2,659	3,333
Investing activities
Purchase of PP&E		2023 BUDGET	0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Website				(4,000)	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	(4,000)
Net investing cashflows				(4,000)	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	(4,000)
Financing activities
Financing income		2023 BUDGET	0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Repayment of loan		2023 BUDGET	(805)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(805)
Dividends paid		2023 BUDGET	0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Net financing cashflows				(67)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(67)	(805)
Increase/(decrease) in cash		CALC	4,390	(7,740)	1,325	(1,743)	(2,295)	806	2,798	(973)	1,014	1,146	395	1,205	2,592	(1,472)
Reconciliation of cash balance
Cash balance at start of period		PREV MTH		20,620	12,880	14,205	12,461	10,166	10,972	13,770	12,797	13,810	14,956	15,352	16,556
Increase/(decrease) in cash				(7,740)	1,325	(1,743)	(2,295)	806	2,798	(973)	1,014	1,146	395	1,205	2,592
Cash balance at end of period		CALC	20,620	12,880	14,205	12,461	10,166	10,972	13,770	12,797	13,810	14,956	15,352	16,556	19,148

F BS

SUBTERRAIN LIMITED		2023	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
Balance Sheet		Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
		12	1	2	3	4	5	6	7	8	9	10	11	12
	Source	Budget	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast	Forecast
		($000s)	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000	$000
CURRENT ASSETS
Cash and cash equivalents	CASHFLOW	20,620	12,880	14,205	12,461	10,166	10,972	13,770	12,797	13,810	14,956	15,352	16,556	19,148
Trade receivables	WORKING CAP	1,065	1,366	1,371	960	992	960	1,323	960	960	992	960	992	1,280
Prepayments and other receivables	CASHFLOW	1,580	1,580	1,580	1,580	1,580	1,580	1,580	1,580	1,580	1,580	1,580	1,580	1,580
Prepayments - Website	ASSUMPTIONS		4,000	4,000	4,000	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Inventories	ASSUMPTIONS	11,000	10,750	11,078	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000
Total current assets		34,265	30,576	32,234	34,002	27,738	28,512	31,673	30,337	31,350	32,529	32,892	34,129	37,009
NON-CURRENT ASSETS
Property, plant and equipment	2023 BUDGET	18,335	18,335	18,335	18,335	18,335	18,335	18,335	18,335	18,335	18,335	18,335	18,335	18,335
Less: Depreciation	IS		(88)	(176)	(264)	(351)	(439)	(526)	(614)	(701)	(789)	(876)	(964)	(1,051)
Website	ASSUMPTIONS		- 0	- 0	- 0	4,000	4,000	4,000	4,000	4,000	4,000	4,000	4,000	4,000
Less: Amortisation	IS		- 0	- 0	- 0	(67)	(133)	(200)	(267)	(333)	(400)	(467)	(533)	(600)
Intangible assets	BUDGET	716	716	716	716	716	716	716	716	716	716	716	716	716
Total non-current assets		19,051	18,963	18,875	18,788	22,633	22,479	22,325	22,171	22,017	21,863	21,708	21,554	21,400
TOTAL ASSETS		53,316	49,539	51,109	52,789	50,372	50,991	53,998	52,508	53,367	54,391	54,600	55,683	58,409
CURRENT LIABILITIES
Trade payables	WORKING CAP	8,006	4,053	4,903	6,945	4,073	3,953	5,146	3,922	3,939	4,111	3,932	4,094	4,967
Current borrowings	2023 BUDGET	820	820	820	820	820	820	820	820	820	820	820	820	820
Employee benefits	WORKING CAP	1,600	910	982	657	688	666	914	685	668	702	673	687	876
Superannuation payable	WORKING CAP		202	406	552	146	291	485	146	291	437	146	291	485
Taxation payable	IS	250	275	220	30	260	264	477	237	285	287	297	315	519
Other payables	2023 BUDGET	3,631	3,631	3,631	3,631	3,631	3,631	3,631	3,631	3,631	3,631	3,631	3,631	3,631
Total current liabilities		14,307	9,891	10,963	12,635	9,617	9,625	11,472	9,441	9,633	9,988	9,499	9,838	11,298
NON-CURRENT LIABILITIES
Non-current borrowings	CASHFLOW	960	893	826	759	692	625	557	490	423	356	289	222	155
Total non-current liabilities		960	893	826	759	692	625	557	490	423	356	289	222	155
Total liabilities		15,267	10,784	11,789	13,393	10,309	10,250	12,030	9,931	10,057	10,344	9,788	10,060	11,453
NET ASSETS		38,049	38,755	39,320	39,396	40,063	40,741	41,968	42,577	43,310	44,047	44,812	45,623	46,956
EQUITY
Contributed equity ($1 par)	BUDGET	12,000	12,000	12,000	12,000	12,000	12,000	12,000	12,000	12,000	12,000	12,000	12,000	12,000
Retained earnings	IS	26,049	26,755	27,320	27,396	28,063	28,741	29,968	30,577	31,310	32,047	32,812	33,623	34,956
TOTAL EQUITY		38,049	38,755	39,320	39,396	40,063	40,741	41,968	42,577	43,310	44,047	44,812	45,623	46,956
Balance Check			- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

Summ Fins

SUBTERRAIN
Summary Financial Statements
Summary Income Statement	2023	2023	2024	2024	2023 vs 2024		2024
	Budget	Forecast	Budget	Forecast	Budget vs Budget		Forecast vs Budget
	$000	$000	$000	$000	$000	%	$000	%
Revenue
Retail stores	70,875		67,569	67,707	(3,306)	-5%	138	0%
Online	4,725		24,573	24,549	19,848	420%	(24)	-0%
Corporate & Clubs	18,900		18,900	19,030	0	0%	130	1%
Total revenue	94,500	92,000	111,042	111,286	16,542	18%	244	0%
Check	TRUE
Gross profit	51,106	49,036	60,282	60,355	9,176	18%	73	0%
	54.1%	53.3%	54.3%	54.2%
Overheads
Employee expenses	21,340	21,670	21,585	21,774	245	1%	189	1%
Rent	11,530	11,600	11,656	11,568	126	1%	(88)	-1%
Marketing - online channel	0	0	675	675	675	N/a	0	N/a
Other expenses	12,260	12,180	12,260	12,164	0	0%	(96)	-1%
Total overheads	45,130	45,450	46,176	46,180	1,046	2%	5	0%
Check	TRUE	TRUE	TRUE	TRUE
EBITDA	5,976	3,586	14,106	14,175	8,130	136%	68	0%
Depreciation and Amortisation	(1,050)	(1,050)	(1,650)	(1,651)	(600)	57%	(1)	0%
EBIT	4,926	2,536	12,456	12,524	7,530	153%	67	1%
Interest	(150)	(150)	(150)	(151)	0	0%	(1)	1%
PBT	4,776	2,386	12,306	12,373	7,530	158%	66	1%
Income tax	(1,336)	(716)	(3,447)	(3,466)	(2,111)	158%	(19)	1%
PAT	3,440	1,670	8,859	8,907	5,419	158%	47	1%
Check	TRUE		TRUE	TRUE
Summary Balance sheet	2023		2024	2024	2023 vs 2024		2024
	Budget		Budget	Forecast	Budget vs Budget		Forecast vs Budget
	$000		$000	$000	$000		$000
CURRENT ASSETS
Cash and cash equivalents	20,620		19,100	19,148	(1,520)		48
Trade receivables	1,065		1,280	1,280	215		0
Prepayments and other receivables	1,580		1,580	1,580	0		0
Inventories	11,000		15,000	15,000	4,000		0
Total current assets	34,265		36,960	37,009	2,695		48
NON-CURRENT ASSETS
Property, plant and equipment	18,335		20,685	20,684	2,350		(1)
Intangible assets	716		716	716	0		0
Total non-current assets	19,051		21,401	21,400	2,350		(1)
TOTAL ASSETS	53,316		58,361	58,409	5,045		47
CURRENT LIABILITIES
Trade payables	8,006		4,967	4,967	(3,039)		0
Current borrowings	820		820	820	0		0
Employee benefits	1,600		1,361	1,361	(239)		0
Taxation payable	250		519	519	269		0
Other payables	3,631		3,631	3,631	0		0
Total current liabilities	14,307		11,298	11,298	(3,009)		0
NON-CURRENT LIABILITIES
Non-current borrowings	960		155	155	(805)		0
Total non-current liabilities	960		155	155	(805)		0
Total liabilities	15,267		11,453	11,453	(3,814)		0
							0
NET ASSETS	38,049		46,908	46,956	8,859		48
EQUITY
Contributed equity ($1 par)	12,000		12,000	12,000	0		0
Retained earnings	26,049		34,908	34,956	8,859		48
TOTAL EQUITY	38,049		46,908	46,956	8,859		48
Check	TRUE		TRUE
Summary Cashflow statement	2023		2024	2024	2023 vs 2024		2024
	Budget		Budget	Forecast	Budget vs Budget		Forecast vs Budget
	$000		$000	$000	$000		$000
Operating cashflows
Sales receipts from customers	94,377		110,827	111,071	16,450		244
Payments to suppliers	(41,720)		(57,799)	(57,970)	(16,079)		(171)
Payments to staff	(21,296)		(21,824)	(22,013)	(528)		(189)
Interest	(150)		(150)	(151)	0		(1)
Taxes	(1,226)		(3,178)	(3,197)	(1,952)		(19)
Other cash expenses	(24,790)		(24,591)	(24,406)	199		184
Net operating cashflows	5,195		3,285	3,333	(1,910)		48
Investing activities
Purchase of PP&E	0		(4,000)	(4,000)	(4,000)		0
Net investing cashflows	0		(4,000)	(4,000)	(4,000)		0
Financing activities
Repayment of loan	(805)		(805)	(805)	0		0
Net financing cashflows	(805)		(805)	(805)	0		0
Increase/(decrease) in cash	4,390		(1,520)	(1,472)	(5,910)		48
Reconciliation of cash balance
Cash balance at start of period	16,230		20,620	20,620	4,390		0
Increase/(decrease) in cash	4,390		(1,520)	(1,472)	(5,910)		48
Cash balance at end of period	20,620		19,100	19,148	(1,520)		48
	TRUE		TRUE	TRUE
Check	- 0

Dash

SUBTERRAIN DASHBOARD	2023	2023	2024
	Budget	Forecast*	Budget
	$000	$000	$000
Revenue by channel
Retail stores	70,875		67,569
Online	4,725		24,573
Corporate & Clubs	18,900		18,900
Total revenue	94,500	92,000	111,042
Gross margin (total)	51,106	49,036	60,282
Wages expense	21,340	21,670	21,585
Rent expense	11,530	11,600	11,656
EBITDA	5,976	3,586	14,106
Retail Employees (FTE @ Year End)	280	280	228
EBITDA per retail employee	21	13	62
Profit after tax	3,440	1,670	3,440
Cash balance end of year	20,620		19,100
Net assets	38,049		46,908
Return on investment (website)			271%
Note:
Forecast includes actual results for Jan 23 - May 23
Breakdown at a channel level was not provided for forecast

Sensitivity

Sensitivity analysis - Data Tables re Online Channel
Online sales revenue		Average spend $
$000	19,848	110	100	90	75
Conversion rates %	7%	25,471	23,156	20,840	17,367
	6%	21,833	19,848	17,863	14,886
	5%	18,194	16,540	14,886	12,405
	4%	14,555	13,232	11,909	9,924
EBITDA		Average spend $
$000	14,175	110	100	90	75
Conversion rates %	7%	17,242	15,979	14,716	12,821
	6%	15,257	14,175	13,092	11,468
	5%	13,272	12,370	11,468	10,114
	4%	11,287	10,566	9,844	8,761
Online sales revenue		Launch date
$000	19,848	Mar-22	Apr-22	May-22	Aug-22
Growth rates %	3%	20,635	18,286	16,006	9,556
	4%	21,611	19,049	16,586	9,749
	5%	22,640	19,848	17,188	9,946
	6%	23,725	20,684	17,815	10,147
	7%	24,870	21,560	18,468	10,351