ASSESSMENT TASK 1 – STUDENT EVIDENCE TO BE SUBMITTED TO THEIR ASSESSOR For this Assessment Task as...

Question

ASSESSMENT TASK 1 – STUDENT EVIDENCE TO BE SUBMITTED TO THEIR ASSESSOR

For this Assessment Task as a Case Study, in the role of the Head Chef in AVETA’s Café, you will be required to satisfactorily complete three (3) Assessment Activities, relating to managing finances; namely Assessment Activities 1A, 1B & 1C detailed below:.

Assessment Activity 1 A –

As a Case Study, in the role of the newly appointed Head Chef for AVETA’s Café you have been ask by the Café owners to manage finances for the Café during the 2020/2021 financial year. They specifically have requested that you to:

•
plan for the financial management of the Café by developing a budget for the 2020/2021 financial year

•
read and review the Café’s profit and loss statements, cash flows and aging summaries that are detailed in the Café’s Business Plan 2019/2020 (see Attachment

A)

•
prepare and implement your revised budget which aligns with their new business plan, that is based on your research and analysis of previous financial data and cash flow trends (see Attachment A), and meets all compliance requirements and which contributes to financial bids and estimates in addition to establishing a budget and allocates funds in accordance with statutory (i.e. reviewing statutory requirements for compliance and liabilities for tax) and organisational requirements.

o
When you have developed your budget for 2020/2021 submit it to your Assessor, as evidence for summative assessment.

During the above Assessment Activity you will be observed by your Assessor when you are planning for financial management and establishing a budget and allocate funds.

Assessment Activity 1 B –

As a Case Study, following on from Assessment Activity 1A, in the role of the newly appointed Head Chef for AVETA’s Café you will now be required to:

As a role play, communicate with other kitchen supervisory staff by reporting on financial activity so that these staff are clear about the up‐coming budget so that they can make recommendations in addition to identifying and prioritising significant issues that affect kitchen operations; during this role play you will also need to communicate how the Café should:

•
Manage risks by checking there are no opportunities for misappropriation of funds and that systems are in place to properly record all financial transactions;

•
Maintain audit trails to ensure accurate tracking and to identify discrepancies between agreed and actual allocations

•
Revising the budget, as required, to deal with any contingencies that have been brought to notice during the discussion

Note ‐ 1 Your Assessor will role play a kitchen supervisor for this activity

During the above Assessment Activity you will be observed by your Assessor when you are implementing a budget.

Assessment Activity 1 C –

As a Case Study, following on from Assessment Activity 1A, in the role of the newly appointed Head Chef for AVETA’s Café you will now be required to developing a Management Report outlining the effectiveness of financial management processes and as a result submitting recommendations (in the report) to ensure financial viability of AVETA’s Café during 2020/2021:


Analyse the effectiveness of their existing financial management approaches including reviewing:
o
their financial management software,
o
managing risks of misappropriation of funds,
o
ensuring systems are in place to record all transactions,
o
maintaining an audit trail and
o
complying with due diligence.

o
Once you have developed your Management Report, submit it to your Assessor, as evidence for summative assessment.

During the above Assessment Activity you will be observed by your Assessor when reporting on finances.

Your Assessor will use the Observable Behaviours ‐ Assessor Checklist Task 1 to ensure that you have satisfactorily completed all assessment requirements for this Assessment Task. OBSERVABLE BEHAVIOURS ‐ ASSESSMENT TASK 1 –

Task 2 ‐ Student Assessment Instructions: The evidence needed to be provided for assessment

For this Assessment Task you will be required to answer four questions on a separate, typed sheet:

Question 1.	Identify the requirements for financial probity
Question 2.	Describe the principles of accounting and financial systems
Question 3.	Explain Australian, international and local legislation and conventions that are relevant to financial management in the organisation
Question 4.	Outline the requirements of the Australian Tax Office, including Goods and Services Tax, Company Tax, Pay As You Go

(Reminder – you will need to identify your source as part of your answer)

bsbfim601-manage-finances-summative-assessemnt-tool-1-pigt1ygh-t2f0kq5s.docx

Ishmeet Singh · Accepted Answer

Contents
		Table of Contents - Section & Sheet Titles
		Go to the Cover Sheet
		1.		Reports							What each tab does
	1				a.	Financial Statements Summary					On this tab you may get a quick glance at your Financial Statement Summary and have
	1				a.						a better understanding of the Income Statement, Cash Flow, and the Balance Sheet 
	1				a.						as well as the Monthly view of a fiscal year, and the annual view of the five-year forecast.
	2				b.	DashBoard					DashBoard tab gives you a snapshot of your business financial viability. 
	2				b.						Core financials, Cash Flow data, Revenue Breakdown, Profitability forecasts, and 
	2				b.						cumulative Cash Flow are shown there.
	1				c.	Top Revenue					In here you can see your annual revenue on the midweeks as well as weekends and holidays.
	2				d.	Top Expenses					This tab displays your 4 biggest expense categories and the rest of the expenses as the "other".
	1				e.	Break Even Analysis					Here you can compare your overall revenues with the expenses.
	2				f.	Valuation					Displays your company’s estimated value based on Discounted Cash Flow method.
	1				g.	Financial Charts					On this tab you can visually track your key financial figures in form of charts.
	2				h.	Operational Charts					Here you may visually track your key performance indicators in form of charts.
	1				i.	Benchmark KPIs					This tab shows a comparison of performance indicators in the model and in the industry.
					j.	Sources and Uses					On this tab you can see the funding structure as well as sources and uses of the funds.
		2.		Assumptions and calculations
	1				a.	Seasonality Setup					On this tab you can see sales seasonality.
	2				b.	Revenue Calculation					Overall revenue are shown here.
	1				c.	Fixed Expenses					Enter fixed expenses and their annual growth rate.
	2				d.	Wages					Fields to enter your employees assumptions: annual salary, taxes, 
	2				d.						hire/fire dates, would-be annual FTEs, etc.
	1				e.	Variable Expenses					Here you can fill up your variable expenses associated with revenue.
	2				f.	Development Expenses					Here you can input Capital Expenses (CAPEX) for the cafe.
	1				g.	Capitalization Table					Shareholder's ownership dilution is calculated here. This tab consists of 4 rounds of financing.
	2				h.	Book Assets					Here you check internal calculations of the assets depreciation and the closing book value.
		3.		Statements
	1				a.	Income Statement					On this tab you can see the monthly Income Statement report - Revenue, EBITDA, Net Profit.
	2				b.	Cash Flow Statement					Here you can have a comprehensive Monthly Cash Flow Statement (direct method).
	1				c.	Cash Flow Statement (indirect method)					Here you can have a comprehensive Monthly Cash Flow Statement (indirect method).
	2				d.	Balance Sheet					The Balance Sheet Statement. Assets, Liabilities, and Equity are displayed.
	1				e.	Capital					Here you see internal calculations of the loans, interest, and equity. 
	1				e.						In case of capital return, please, use yellow entry line.
	2				f.	Outputs					This is the engine of this tool. All core calculations are done here.
	1				g.	Inventory					On this sheet you can track your inventory within 60 months period.
		4.		Setup
	2				a.	Time Series					The tab to set up: Fiscal Year End, First Fiscal Year.
&12Built with finmodelslab.com template	&12Table of Contents	&D
TimeSeries
		Time Series
		Go to the Table of Contents
		Time Series - Assumptions
			Fiscal Year End					December
								12
			First Fiscal Year					2020
			Term (Years)					5
			Your Business Model Start Date					1-Jan-04
			Your Business Model End Date					1-Jan-04
			Denomination					$
			Denomination					2
			Denomination Conversion Factor					1,000
			Currency exch rate $ / $					1.0000
&12Built with finmodelslab.com template	&12Time Series	&D
DashBoard
		DashBoard								CURRENCY, DENOMINATOR & TAX					DEBT ASSUMPTIONS
											Currency Inputs	$			Loan Name		Amount, $		Launch		Term, M	Interest, %		Select Type
		Go to the Table of Contents									Currency Outputs	$			Debt_1		800,000		Jan-20		36	7%		Usual
											Denomination	1,000			Debt_2		100,000		Apr-20		36	7%		Usual					Min Cash Month	Dec-21
											Currency exch rate $ / $	1.000			Debt_3														Min Cash ($'000)	159.1
											Corporate tax, %	10%			Grant
			Core Inputs												Revenue Breakdown ($'000) - 5 Years to December 2024												Profitability ($'000) - 5 Years to December 2024
			WORKING DAYS								INVENTORY
			# of Days Open per Week						7		Safety Stock, %		30%
			# of Working Days per Year						364
			Weekends & Holidays per Year						100
			Midweeks per Year						264
									AVERAGE SALES PER DAY, $
									2020	2021	2022	2023	2024
			Midweek 						3,700	4,350	5,500	6,550	6,700
			Weekends & Holidays						5,500	5,700	6,500	7,000	7,500
									SALES MIX BY PRODUCT CATEGORIES, %
			Product categories						2020	2021	2022	2023	2024
			Food						10%	10%	10%	10%	10%
			Beverage						20%	20%	20%	20%	20%
			Placeholder 1						30%	30%	30%	30%	30%
			Placeholder 2						25%	25%	25%	25%	25%
			Placeholder 3						15%	15%	15%	15%	15%
									COGS BY PRODUCT CATEGORIES, %
			Product categories						2020	2021	2022	2023	2024
			Food						20%	20%	20%	20%	20%
			Beverage						25%	25%	25%	25%	25%
			Placeholder 1						30%	30%	30%	30%	30%
			Placeholder 2						35%	35%	35%	35%	35%
			Placeholder 3						40%	40%	40%	40%	40%
			Core Financials ($'000)												Cash flow ($'000) - 5 Years to December 2024												Cumulative CashFlow ($'000) - 5 Years to December 2024
		Fiscal Year							2020	2021	2022	2023	2024
		Revenue							1,597	1,797	2,199	2,541	2,635
		COGS							(491)	(553)	(676)	(781)	(810)
		GROSS MARGIN							1,106	1,245	1,523	1,760	1,825
		GROSS MARGIN %							69%	69%	69%	69%	69%
		Salaries & Wages							(578)	(590)	(602)	(615)	(629)
		Variable Expenses							(303)	(342)	(418)	(483)	(501)
		Fixed Expenditure							(91)	(91)	(91)	(91)	(91)
		NET MARGIN							134	223	412	571	605
		NET MARGIN %							8%	12%	19%	22%	23%
		EBITDA							134	223	412	571	605
		EBITDA %							8%	12%	19%	22%	23%
		Depreciation & Amortization							(110.6)	(103.6)	(103.6)	(103.3)	(102.0)
		EBIT							23	119	308	468	503
		Net Interest Expense							(48)	(35)	(14)	(0)	-
		Net Profit Before Tax							(25)	84	295	467	503
		Tax Expense							-	(8)	(29)	(47)	(50)
		Net Profit After Tax							(25)	76	265	421	452
		Net Profit After Tax %							0%	4%	12%	17%	17%
		Operating Cash Flows							71	178	365	521	553
		Cash							281	159	224	711	1,265
		Dashboard Source Data
			Displayed Periods Description							5 Years to December 2024
								0	1	2	3	4	5
			Year Ending						2020	2021	2022	2023	2024
			Year End Date						1-Jan-04	1-Jan-04	1-Jan-04	1-Jan-04	1-Jan-04
			Income Statement Source Data
			Revenue						1,597,033	1,797,446	2,198,692	2,540,943	2,634,665
			COGS						(491,088)	(552,715)	(676,098)	(781,340)	(810,159)
			Salaries & Wages						(577,830)	(589,891)	(602,388)	(615,339)	(628,766)
			Variable Expenditure						(303,436)	(341,515)	(417,751)	(482,779)	(500,586)
			Fixed Expenditure						(90,600)	(90,600)	(90,600)	(90,600)	(90,600)
			EBITDA						134,079	222,725	411,855	570,885	604,553
			Depreciation & Amortization						(110,583)	(103,583)	(103,583)	(103,250)	(102,000)
			EBIT						23,496	119,142	308,272	467,635	502,553
			Interest Expense						(48,417)	(34,708)	(13,708)	(292)	-
			Net Profit Before Tax						(24,921)	84,434	294,563	467,343	502,553
			Tax Expense						-	(8,443)	(29,456)	(46,734)	(50,255)
			Net Profit After Tax						(24,921)	75,990	265,107	420,609	452,298
			Balance Sheet Source Data
			Cash						281,324	159,057	224,061	711,442	1,264,879
			Current Assets						295,996	175,569	244,260	734,785	1,289,083
			Non-Current Assets						412,417	308,833	205,250	102,000	(0)
			Total Assets						708,412	484,403	449,510	836,785	1,289,083
			Current Liabilities						-	-	-	-	-
			Non-Current Liabilities						633,333	333,333	33,333	(0)	(0)
			Total Liabilities						633,333	333,333	33,333	(0)	(0)
			Net Assets						75,079	151,069	416,176	836,785	1,289,083
			Ordinary Equity						100,000	100,000	100,000	100,000	100,000
			Retained Profits						(24,921)	51,069	316,176	736,785	1,189,083
			Total Equity						75,079	151,069	416,176	836,785	1,289,083
			Cash Flow Statement Source Data
			Cash Receipts						1,597,033	1,797,446	2,198,692	2,540,943	2,634,665
			Cash Payments						(1,477,625)	(1,576,562)	(1,790,523)	(1,973,202)	(2,030,973)
			Cash Flow from Operating Activities						70,991	177,732	365,004	520,715	553,437
			Fixed Assets Capital Expenditure						(523,000)	-	-	-	-
			Cash Flow from Investing Activities						-	-	-	-	-
			Debt Drawdowns						900,000	-	-	-	-
			Debt Repayments						(266,667)	(300,000)	(300,000)	(33,333)	-
			Ordinary Equity Raisings						100,000	-	-	-	-
			Ordinary Equity Buybacks						-	-	-	-	-
			Cash Flow from Financing Activities						733,333	(300,000)	(300,000)	(33,333)	-
			Net Increase/(Decrease) in Cash Held						281,324	(122,268)	65,004	487,382	553,437
			Change in Cash (Pre-Corporate Tax & Interest on Cash)						329,741	(79,116)	108,169	534,408	603,692
			Chart Data						2020	2021	2022	2023	2024
			1	Midweek 					1,022	1,201	1,519	1,809	1,850
			2	Weekends & Holidays					575	596	680	732	785
			Cash-flow chart data						By years
			Operating Cash Receipts						1,597	1,797	2,199	2,541	2,635
			Financing						685	(335)	(314)	(34)	-
			Investing						(523)	-	-	-	-
			Operating Cash Payments						(1,478)	(1,577)	(1,791)	(1,973)	(2,031)
			Tax Payment						-	(8)	(29)	(47)	(50)
			Cash balance						281	159	224	711	1,265
&12Built with finmodelslab.com template	&12Dashboard	&D
Midweek 	
2020	2021	2022	2023	2024	1021.7328	1201.2264	1518.7919999999999	1808.7431999999999	1850.1648	Weekends 	&	 Holidays	
2020	2021	2022	2023	2024	575.29999999999984	596.22	679.89999999999975	732.19999999999993	784.5	
Revenue	
2020	2021	2022	2023	2024	1597.0327999999997	1797.4463999999998	2198.6919999999996	2540.9431999999993	2634.6648	EBITDA	
2020	2021	2022	2023	2024	134.07898199999971	222.72531600000019	411.85495499999973	570.88507724999954	604.55320304250017	EBITDA %	
2020	2021	2022	2023	2024	8.395505840581341E-2	0.12391207659933572	0.18731816689195205	0.22467447412834718	0.22946114550985772	
Operating Cash Receipts	2020	2021	2022	2023	2024	1597.0327999999997	1797.4463999999998	2198.6919999999996	2540.9431999999993	2634.6648	Operating Cash Payments	2020	2021	2022	2023	2024	-1477.62541175	-1576.5622402499998	-1790.5232012499998	-1973.2023102500002	-2030.9725969575002	Investing	2020	2021	2022	2023	2024	-523	0	0	0	0	Financing	2020	2021	2022	2023	2024	684.91666666666663	-334.70833333333331	-313.70833333333331	-33.625	0	Tax Payment	2020	2021	2022	2023	2024	0	-8.4433649333333207	-29.456328833333306	-46.734341058333328	-50.255320304250013	Cash balance	
2020	2021	2022	2023	2024	281.32405491666657	159.05651639999985	224.06065298333317	711.44220167499975	1264.8790844132495	
Operating	
2020	2021	2022	2023	2024	70.990721583333212	177.73246148333325	365.00413658333338	520.71488202499984	553.43688273824989	Investing	
2020	2021	2022	2023	2024	-523	0	0	0	0	Financing	
2020	2021	2022	2023	2024	733.33333333333326	-300	-300	-33.333333333333336	0	Net Cash Flow	
2020	2021	2022	2023	2024	281.32405491666646	-122.26753851666675	65.004136583333377	487.38154869166652	553.43688273824989	Closing Cash	
2020	2021	2022	2023	2024	281.32405491666657	159.05651639999985	224.06065298333317	711.44220167499975	1264.8790844132495	
Summary
		Financial Statements Summary
																			Select detailed year:	2020
		Go to the Table of Contents
		Income Statement ($'000) - 5 Years to December 2024														Income Statement ($'000) - 2020
		Year Ending								2020	2021	2022	2023	2024		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
		Revenue								1,597	1,797	2,199	2,541	2,635		165	102	127	127	127	127	127	127	127	127	153	159
		Growth %									13%	22%	16%	4%		-	(38%)	25%	-	-	-	0%	(0%)	-	-	20%	4%
		COGS								(491)	(553)	(676)	(781)	(810)		(51)	(31)	(39)	(39)	(39)	(39)	(39)	(39)	(39)	(39)	(47)	(49)
		% of Revenue								(31%)	(31%)	(31%)	(31%)	(31%)		(31%)	(31%)	(31%)	(31%)	(31%)	(31%)	(31%)	(31%)	(31%)	(31%)	(31%)	(31%)
		GROSS MARGIN								1,106	1,245	1,523	1,760	1,825		115	70	88	88	88	88	88	88	88	88	106	110
		GROSS MARGIN %								69%	69%	69%	69%	69%		69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%	69%
		Variable Expenses								(303)	(342)	(418)	(483)	(501)		(31)	(19)	(24)	(24)	(24)	(24)	(24)	(24)	(24)	(24)	(29)	(30)
		% of Revenue								(19%)	(19%)	(19%)	(19%)	(19%)		(19%)	(19%)	(19%)	(19%)	(19%)	(19%)	(19%)	(19%)	(19%)	(19%)	(19%)	(19%)
		Salaries & Wages								(578)	(590)	(602)	(615)	(629)		(48)	(48)	(48)	(48)	(48)	(48)	(48)	(48)	(48)	(48)	(48)	(48)
		% of Revenue								(36%)	(33%)	(27%)	(24%)	(24%)		(29%)	(47%)	(38%)	(38%)	(38%)	(38%)	(38%)	(38%)	(38%)	(38%)	(32%)	(30%)
		Fixed Expenses								(91)	(91)	(91)	(91)	(91)		(8)	(8)	(8)	(8)	(8)	(8)	(8)	(8)	(8)	(8)	(8)	(8)
		% of Revenue								(6%)	(5%)	(4%)	(4%)	(3%)		(5%)	(7%)	(6%)	(6%)	(6%)	(6%)	(6%)	(6%)	(6%)	(6%)	(5%)	(5%)
		EBITDA								134	223	412	571	605		27	(5)	8	8	8	8	8	8	8	8	21	24
		EBITDA %								8%	12%	19%	22%	23%		17%	(4%)	6%	6%	6%	6%	7%	6%	6%	6%	14%	15%
		Depreciation & Amortization								(111)	(104)	(104)	(103)	(102)		(9)	(9)	(9)	(9)	(9)	(9)	(9)	(9)	(9)	(9)	(9)	(9)
		EBIT								23	119	308	468	503		18	(14)	(1)	(1)	(1)	(1)	(1)	(1)	(1)	(1)	12	15
		Net Interest Expense								(48)	(35)	(14)	(0)	-		-	(5)	(5)	(4)	(5)	(5)	(5)	(4)	(4)	(4)	(4)	(4)
		Net Profit Before Tax								(25)	84	295	467	503		18	(18)	(6)	(5)	(6)	(6)	(5)	(5)	(5)	(5)	8	11
		Tax Expense								-	(8)	(29)	(47)	(50)		-	-	-	-	-	-	-	-	-	-	-	-
		Net Profit After Tax								(25)	76	265	421	452		18	(18)	(6)	(5)	(6)	(6)	(5)	(5)	(5)	(5)	8	11
		Net Profit After Tax %								(2%)	4%	12%	17%	17%		11%	(18%)	(4%)	(4%)	(5%)	(4%)	(4%)	(4%)	(4%)	(4%)	5%	7%
		Income Statement ($'000) - 5 Years to December 2024														Income Statement ($'000) - 2020
		Balance Sheet ($'000) - 5 Years to December 2024														Balance Sheet ($'000) - 2020
		Year Ending								2020	2021	2022	2023	2024		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
		Current Assets								296	176	244	735	1,289		907	875	854	436	414	393	372	351	329	309	301	296
		Non-Current Assets								412	309	205	102	(0)		514	505	495	486	477	468	458	449	440	431	422	412
		Total Assets								708	484	450	837	1,289		1,421	1,380	1,350	922	891	861	830	800	770	739	722	708
		Current Liabilities								-	-	-	-	-		503	502	500	-	-	-	-	-	-	-	-	-
		Non-Current Liabilities								633	333	33	(0)	(0)		800	778	756	833	808	783	758	733	708	683	658	633
		Total Liabilities								633	333	33	(0)	(0)		1,303	1,280	1,256	833	808	783	758	733	708	683	658	633
		Net Assets								75	151	416	837	1,289		118	100	94	89	83	77	72	66	61	56	64	75
		Net Current Assets								296	176	244	735	1,289		404	373	354	436	414	393	372	351	329	309	301	296
		Ordinary Equity								100	100	100	100	100		100	100	100	100	100	100	100	100	100	100	100	100
		Other Equity								0	(0)	-	-	-		(0)	(0)	(0)	-	(0)	(0)	(0)	-	-	-	-	0
		Retained Profits								(25)	51	316	737	1,189		18	(0)	(6)	(11)	(17)	(23)	(28)	(34)	(39)	(44)	(36)	(25)
		Total Equity								75	151	416	837	1,289		118	100	94	89	83	77	72	66	61	56	64	75
		Balance Sheet ($'000) - 5 Years to December 2024														Balance Sheet ($'000) - 2020
		Cash Flow Statement ($'000) - 5 Years to December 2024														Cash Flow Statement ($'000) - 2020
		Year Ending								2020	2021	2022	2023	2024		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
		Cash Receipts								1,597	1,797	2,199	2,541	2,635		165	102	127	127	127	127	127	127	127	127	153	159
		Cash Payments								(1,478)	(1,577)	(1,791)	(1,973)	(2,031)		(153)	(100)	(121)	(119)	(119)	(119)	(119)	(119)	(119)	(119)	(134)	(135)
		Other Operating Cash Flows								(48)	(43)	(43)	(47)	(50)		-	(5)	(5)	(4)	(5)	(5)	(5)	(4)	(4)	(4)	(4)	(4)
		Operating Cash Flows								71	178	365	521	553		12	(3)	1	4	3	4	4	4	4	4	15	20
		Capital Expenditure								(523)	-	-	-	-		(20)	(1)	(2)	(500)	-	-	-	-	-	-	-	-
		Other Investing Cash Flows								-	-	-	-	-		-	-	-	-	-	-	-	-	-	-	-	-
		Investing Cash Flows								(523)	-	-	-	-		(20)	(1)	(2)	(500)	-	-	-	-	-	-	-	-
		Debt Drawdowns/(Repayments)								633	(300)	(300)	(33)	-		800	(22)	(22)	78	(25)	(25)	(25)	(25)	(25)	(25)	(25)	(25)
		Equity Raisings/(Buybacks)								100	-	-	-	-		100	-	-	-	-	-	-	-	-	-	-	-
		Other Financing Cash Flows								-	-	-	-	-		-	-	-	-	-	-	-	-	-	-	-	-
		Financing Cash Flows								733	(300)	(300)	(33)	-		900	(22)	(22)	78	(25)	(25)	(25)	(25)	(25)	(25)	(25)	(25)
		Change in Cash Held								281	(122)	65	487	553		892	(27)	(23)	(418)	(22)	(21)	(21)	(21)	(21)	(21)	(10)	(5)
		Closing Cash								281	159	224	711	1,265		892	866	843	424	403	381	360	339	318	297	287	281
		Cash Flow Statement ($'000) - 5 Years to December 2024														Cash Flow Statement ($'000) - 2020
		Dashboard Source Data
			First Displayed Period							1
			Displayed Periods Description							5 Years to December 2024
			Linked In Data Columns Offset							-
			Year Ending							2020	2021	2022	2023	2024		1/31/20	2/29/20	3/31/20	4/30/20	5/31/20	6/30/20	7/31/20	8/31/20	9/30/20	10/31/20	11/30/20	12/31/20
			Year End Date							1-Jan-04	1-Jan-04	1-Jan-04	1-Jan-04	1-Jan-04
			Data Available							TRUE	TRUE	TRUE	TRUE	TRUE
			Income Statement Source Data
			Revenue							1,597,033	1,797,446	2,198,692	2,540,943	2,634,665		165,403.3	101,786.7	127,233.3	127,233.3	127,233.3	127,233.3	127,487.8	127,233.3	127,233.3	127,233.3	152,680.0	159,041.7
			COGS							(491,088)	(552,715)	(676,098)	(781,340)	(810,159)		(50,861.5)	(31,299.4)	(39,124.3)	(39,124.3)	(39,124.3)	(39,124.3)	(39,202.5)	(39,124.3)	(39,124.3)	(39,124.3)	(46,949.1)	(48,905.3)
			Salaries & Wages							(577,830)	(589,891)	(602,388)	(615,339)	(628,766)		(48,152.5)	(48,152.5)	(48,152.5)	(48,152.5)	(48,152.5)	(48,152.5)	(48,152.5)	(48,152.5)	(48,152.5)	(48,152.5)	(48,152.5)	(48,152.5)
			Variable Expenses							(303,436)	(341,515)	(417,751)	(482,779)	(500,586)		(31,426.6)	(19,339.5)	(24,174.3)	(24,174.3)	(24,174.3)	(24,174.3)	(24,222.7)	(24,174.3)	(24,174.3)	(24,174.3)	(29,009.2)	(30,217.9)
			Fixed Expenses							(90,600)	(90,600)	(90,600)	(90,600)	(90,600)		(7,550.0)	(7,550.0)	(7,550.0)	(7,550.0)	(7,550.0)	(7,550.0)	(7,550.0)	(7,550.0)	(7,550.0)	(7,550.0)	(7,550.0)	(7,550.0)
			EBITDA							134,079	222,725	411,855	570,885	604,553		27,412.7	(4,554.7)	8,232.2	8,232.2	8,232.2	8,232.2	8,360.1	8,232.2	8,232.2	8,232.2	21,019.2	24,215.9
			Total Depreciation & Amortization							(110,583)	(103,583)	(103,583)	(103,250)	(102,000)		(9,215.3)	(9,215.3)	(9,215.3)	(9,215.3)	(9,215.3)	(9,215.3)	(9,215.3)	(9,215.3)	(9,215.3)	(9,215.3)	(9,215.3)	(9,215.3)
			EBIT							23,496	119,142	308,272	467,635	502,553		18,197.4	(13,770.0)	(983.0)	(983.0)	(983.0)	(983.0)	(855.2)	(983.0)	(983.0)	(983.0)	11,803.9	15,000.7
			Interest Expense							(48,417)	(34,708)	(13,708)	(292)	-		-	(4,666.7)	(4,537.0)	(4,407.4)	(4,861.1)	(4,715.3)	(4,569.4)	(4,423.6)	(4,277.8)	(4,131.9)	(3,986.1)	(3,840.3)
			Net Profit Before Tax							(24,921)	84,434	294,563	467,343	502,553		18,197.4	(18,436.6)	(5,520.1)	(5,390.4)	(5,844.1)	(5,698.3)	(5,424.6)	(5,406.6)	(5,260.8)	(5,115.0)	7,817.8	11,160.4
			Tax Expense							-	(8,443)	(29,456)	(46,734)	(50,255)		-	-	-	-	-	-	-	-	-	-	-	-
			Net Profit After Tax							(24,921)	75,990	265,107	420,609	452,298		18,197.4	(18,436.6)	(5,520.1)	(5,390.4)	(5,844.1)	(5,698.3)	(5,424.6)	(5,406.6)	(5,260.8)	(5,115.0)	7,817.8	11,160.4
			Balance Sheet Source Data
			Cash							281,324	159,057	224,061	711,442	1,264,879		892,154	865,579	842,705	424,307	402,679	381,196	359,963	338,795	317,749	296,850	286,535	281,324
			Current Assets							295,996	175,569	244,260	734,785	1,289,083		907,413	874,969	854,442	436,045	414,416	392,933	371,723	350,532	329,487	308,587	300,620	295,996
			Non-Current Assets							412,417	308,833	205,250	102,000	(0)	-	513,785	504,569	495,354	486,139	476,924	467,708	458,493	449,278	440,063	430,847	421,632	412,417
			Total Assets							708,412	484,403	449,510	836,785	1,289,083		1,421,197	1,379,539	1,349,796	922,184	891,339	860,641	830,217	799,810	769,549	739,434	722,252	708,412
			Current Liabilities							-	-	-	-	-		503,000.0	502,000.0	500,000.0	-	-	-	-	-	-	-	-	-
			Non-Current Liabilities							633,333	333,333	33,333	(0)	(0)		800,000.0	777,777.8	755,555.6	833,333.3	808,333.3	783,333.3	758,333.3	733,333.3	708,333.3	683,333.3	658,333.3	633,333.3
			Total Liabilities							633,333	333,333	33,333	(0)	(0)		1,303,000.0	1,279,777.8	1,255,555.6	833,333.3	808,333.3	783,333.3	758,333.3	733,333.3	708,333.3	683,333.3	658,333.3	633,333.3
			Net Assets							75,079	151,069	416,176	836,785	1,289,083		118,197.4	99,760.8	94,240.7	88,850.3	83,006.1	77,307.8	71,883.2	66,476.6	61,215.8	56,100.8	63,918.6	75,079.0
			Ordinary Equity							100,000	100,000	100,000	100,000	100,000		100,000.0	100,000.0	100,000.0	100,000.0	100,000.0	100,000.0	100,000.0	100,000.0	100,000.0	100,000.0	100,000.0	100,000.0
			Retained Profits							(24,921)	51,069	316,176	736,785	1,189,083		18,197.4	(239.2)	(5,759.3)	(11,149.7)	(16,993.9)	(22,692.2)	(28,116.8)	(33,523.4)	(38,784.2)	(43,899.2)	(36,081.4)	(24,921.0)
			Total Equity							75,079	151,069	416,176	836,785	1,289,083		118,197.4	99,760.8	94,240.7	88,850.3	83,006.1	77,307.8	71,883.2	66,476.6	61,215.8	56,100.8	63,918.6	75,079.0
			Cash Flow Statement Source Data
			Cash Receipts							1,597,033	1,797,446	2,198,692	2,540,943	2,634,665		165,403.3	101,786.7	127,233.3	127,233.3	127,233.3	127,233.3	127,487.8	127,233.3	127,233.3	127,233.3	152,680.0	159,041.7
			Cash Payments							(1,477,625)	(1,576,562)	(1,790,523)	(1,973,202)	(2,030,973)		(153,249.1)	(100,472.7)	(121,348.5)	(119,001.1)	(119,001.1)	(119,001.1)	(119,151.2)	(118,977.6)	(119,001.1)	(119,001.1)	(134,008.3)	(135,412.6)
			Interest Paid							(48,417)	(34,708)	(13,708)	(292)	-		-	(4,666.7)	(4,537.0)	(4,407.4)	(4,861.1)	(4,715.3)	(4,569.4)	(4,423.6)	(4,277.8)	(4,131.9)	(3,986.1)	(3,840.3)
			Operating Cash Flows							70,991	177,732	365,004	520,715	553,437		12,154.2	(3,352.7)	1,347.8	3,824.8	3,371.1	3,517.0	3,767.2	3,832.1	3,954.5	4,100.3	14,685.6	19,788.8
			Book Assets Capital Expenditure							(523,000)	-	-	-	-		(20,000.0)	(1,000.0)	(2,000.0)	(500,000.0)	-	-	-	-	-	-	-	-
			Investing Cash Flows							(523,000)	-	-	-	-		(20,000.0)	(1,000.0)	(2,000.0)	(500,000.0)	-	-	-	-	-	-	-	-
			Debt Drawdowns							900,000	-	-	-	-		800,000.0	-	-	100,000.0	-	-	-	-	-	-	-	-
			Debt Repayments							(266,667)	(300,000)	(300,000)	(33,333)	-		-	(22,222.2)	(22,222.2)	(22,222.2)	(25,000.0)	(25,000.0)	(25,000.0)	(25,000.0)	(25,000.0)	(25,000.0)	(25,000.0)	(25,000.0)
			Ordinary Equity Raisings							100,000	-	-	-	-		100,000.0	-	-	-	-	-	-	-	-	-	-	-
			Ordinary Equity Buybacks							-	-	-	-	-		-	-	-	-	-	-	-	-	-	-	-	-
			Ordinary Equity Dividends Paid							-	-	-	-	-		-	-	-	-	-	-	-	-	-	-	-	-
			Financing Cash Flows							733,333	(300,000)	(300,000)	(33,333)	-		900,000.0	(22,222.2)	(22,222.2)	77,777.8	(25,000.0)	(25,000.0)	(25,000.0)	(25,000.0)	(25,000.0)	(25,000.0)	(25,000.0)	(25,000.0)
			Change in Cash Held							281,324	(122,268)	65,004	487,382	553,437		892,154.2	(26,575.0)	(22,874.5)	(418,397.4)	(21,628.9)	(21,483.0)	(21,232.8)	(21,167.9)	(21,045.5)	(20,899.7)	(10,314.4)	(5,211.2)
			Error Values							-	-	-	-	-
			EBITDA Reconciliation
			EBIT Reconciliation							-	-	-	-	-
			NPBT Reconciliation							-	-	-	-	-
			NPAT Reconciliation							-	-	-	-	-
			Total Assets Reconciliation							-	-	-	-	-
			Total Liabilities Reconciliation							-	-	-	-	-
			Net Assets Reconciliation							-	-	-	-	-
			Balance Sheet Balances Check							-	-	-	-	-
			Cash Flow Statement Reconciliation							-	-	-	-	-
			Total Error Checks						-	-	-	-	-	-
&12Built with finmodelslab.com template	&12Financial Statements Summary	&D
Top_Revenue
		Top Revenue
		Go to the Table of Contents
		Revenue Summary ($'000) - 5 Years to December 2024
										2020	2021	2022	2023	2024			2020	2021	2022	2023	2024
		Midweek 								1,022	1,201	1,519	1,809	1,850			64.0%	66.8%	69.1%	71.2%	70.2%
		Weekends & Holidays								575	596	680	732	785			36.0%	33.2%	30.9%	28.8%	29.8%
		Total Revenue								1,597	1,797	2,199	2,541	2,635			100.0%	100.0%	100.0%	100.0%	100.0%
		Revenue Summary ($'000) - 5 Years to December 2024
		Revenue Depth ($'000) - 2020														Monthly Run-Rate ($'000) - 2020
																					2020
		Revenue Bridge ($'000) - 2020 Total Revenue to 2024 Total Revenue
																			2020		2024
		Dashboard Source Data
			Timing Information
				First Displayed Period								1
				Displayed Periods Description								5 Years to December 2024
				Linked In Data Columns Offset								-
				Central Chart End Date								1
				Central Chart Periods Description								2020
				Periods of Presentation								1
				Displayed Bridge Dates								1		5
				Year Ending						2020	2021	2022	2023	2024
				Year End Date						1-Jan-04	1-Jan-04	1-Jan-04	1-Jan-04	1-Jan-04
				Data Available						TRUE	TRUE	TRUE	TRUE	TRUE
			Revenue Data
				Heading						Revenue Summary
				Base Categories												Total	Rank	Total	Base Categories
				Midweek 						1,021.7	1,201.2	1,518.8	1,808.7	1,850.2		7,400.7	1	7,400.7	Midweek 
				Weekends & Holidays						575.3	596.2	679.9	732.2	784.5		3,368.1	2	3,368.1	Weekends & Holidays
				Total Revenue						1,597.0	1,797.4	2,198.7	2,540.9	2,634.7		10,768.8		10,768.8
				Summary Categories												Total		Monthly	2020
				Midweek 						1,021.7	1,201.2	1,518.8	1,808.7	1,850.2		7,400.7		85.1	1,021.7
				Weekends & Holidays						575.3	596.2	679.9	732.2	784.5		3,368.1		47.9	575.3
				Total Revenue						1,597.0	1,797.4	2,198.7	2,540.9	2,634.7		10,768.8
					Error Values					-	-	-	-	-
					Balance Check					-	-	-	-	-
				Total Error Checks					-	-	-	-	-	-
			Revenue Bridge
												Positive				Negative		Total
										Value	Cumulative	Invisible +	Green +	Invisble -	Green -	Red +	Red -	Blue
				2020 Total Revenue						1,597.0	1,597.0	-	1,597.0	-	-	-	-	-
				Midweek 						828.4	2,425.5	1,597.0	828.4	-	-	-	-	-
				Weekends & Holidays						209.2	2,634.7	2,425.5	209.2	-	-	-	-	-
				2024 Total Revenue						2,634.7	2,634.7	-	-	-	-	-	-	2,634.7
&12Built with finmodelslab.com template	&12Top Revenue	&D
Top_Expenses
		Top Expenses
		Go to the Table of Contents
		Top 5 Expense Categories ($'000) - 5 Years to December 2024
										2020	2021	2022	2023	2024			2020	2021	2022	2023	2024
		Total Salary and Wages								578	590	602	615	629			51.1%	50.5%	47.9%	46.0%	45.8%
		Direct Labor								160	180	220	254	263			14.1%	15.4%	17.5%	19.0%	19.2%
		Food loss								80	90	110	127	132			7.1%	7.7%	8.7%	9.5%	9.6%
		Total Depreciation								111	104	104	103	102			9.8%	8.9%	8.2%	7.7%	7.4%
		Other								203	206	222	239	246			17.9%	17.6%	17.6%	17.9%	17.9%
		Total Expenses								1,131	1,169	1,257	1,339	1,372			100%	100%	100%	100%	100%
		Top 5 Expense Categories ($'000) - 5 Years to December 2024
		Expenses Depth ($'000) - 2020														Monthly Run-Rate ($'000) - 2020
																					2020
		Expenses Bridge ($'000) - 2020 Total Expenses to 2024 Total Expenses
																			2020		2024
		Dashboard Source Data
			Timing Information
				First Displayed Period								1
				Displayed Periods Description								5 Years to December 2024
				Linked In Data Columns Offset								-
				Central Chart End Date								1
				Central Chart Periods Description								2020
				Periods of Presentation								1
				Displayed Bridge Dates								1		5
				Year Ending						2020	2021	2022	2023	2024
				Year End Date						1-Jan-04	1-Jan-04	1-Jan-04	1-Jan-04	1-Jan-04
				Data Available						TRUE	TRUE	TRUE	TRUE	TRUE
			Expenses Data
				Heading						Top 5 Expense Categories
				Base Categories												Total	Rank	Total	Base Categories
				Direct Labor						159.7	179.7	219.9	254.1	263.5		1,076.9	2	3,014.2	Total Salary and Wages
				Bank fee						16.0	18.0	22.0	25.4	26.3		107.7	8	1,076.9	Direct Labor
				Food loss						79.9	89.9	109.9	127.0	131.7		538.4	3	538.4	Food loss
				Plates						47.9	53.9	66.0	76.2	79.0		323.1	5	523.0	Total Depreciation
				VC_Placeholder5						-	-	-	-	-		-	14	323.1	Plates
				VC_Placeholder6						-	-	-	-	-		-	15	300.0	Rent
				Total Salary and Wages						577.8	589.9	602.4	615.3	628.8		3,014.2	1	134.9	Tax Expense
				Advertising						6.0	6.0	6.0	6.0	6.0		30.0	11	107.7	Bank fee
				Utilities						18.6	18.6	18.6	18.6	18.6		93.0	10	97.1	Interest Expense
				Rent						60.0	60.0	60.0	60.0	60.0		300.0	6	93.0	Utilities
				Web site						2.4	2.4	2.4	2.4	2.4		12.0	13	30.0	Advertising
				Miscellaneous						3.6	3.6	3.6	3.6	3.6		18.0	12	18.0	Miscellaneous
				FC_Placeholder6						-	-	-	-	-		-	16	12.0	Web site
				FC_Placeholder7						-	-	-	-	-		-	17	-	VC_Placeholder5
				FC_Placeholder8						-	-	-	-	-		-	18	-	VC_Placeholder6
				FC_Placeholder9						-	-	-	-	-		-	19	-	FC_Placeholder6
				FC_Placeholder10						-	-	-	-	-		-	20	-	FC_Placeholder7
				FC_Placeholder11						-	-	-	-	-		-	21	-	FC_Placeholder8
				FC_Placeholder12						-	-	-	-	-		-	22	-	FC_Placeholder9
				FC_Placeholder13						-	-	-	-	-		-	23	-	FC_Placeholder10
				FC_Placeholder14						-	-	-	-	-		-	24	-	FC_Placeholder11
				FC_Placeholder15						-	-	-	-	-		-	25	-	FC_Placeholder12
				Total Depreciation						110.6	103.6	103.6	103.3	102.0		523.0	4	-	FC_Placeholder13
				Interest Expense						48.4	34.7	13.7	0.3	-		97.1	9	-	FC_Placeholder14
				Tax Expense						-	8.4	29.5	46.7	50.3		134.9	7	-	FC_Placeholder15
				Total Expenses						1,130.9	1,168.7	1,257.5	1,339.0	1,372.2		6,268.3		6,268.3
				Summary Categories												Total		Monthly	2020
				Total Salary and Wages						577.8	589.9	602.4	615.3	628.8		3,014.2		48.2	577.8
				Direct Labor						159.7	179.7	219.9	254.1	263.5		1,076.9		13.3	159.7
				Food loss						79.9	89.9	109.9	127.0	131.7		538.4		6.7	79.9
				Total Depreciation						110.6	103.6	103.6	103.3	102.0		523.0		9.2	110.6
				Other						202.9	205.6	221.7	239.3	246.2		1,115.8		16.9	202.9
				Total Expenses						1,130.9	1,168.7	1,257.5	1,339.0	1,372.2		6,268.3
					Error Values					-	-	-	-	-
					Balance Check					-	-	-	-	-
				Total Error Checks					-	-	-	-	-	-
			Expenses Bridge
												Positive				Negative		Total
										Value	Cumulative	Invisible +	Green +	Invisble -	Green -	Red +	Red -	Blue
				2020 Total Expenses						1,130.9	1,130.9	-	1,130.9	-	-	-	-	-
				Total Salary and Wages						50.9	1,181.8	1,130.9	50.9	-	-	-	-	-
				Direct Labor						103.8	1,285.6	1,181.8	103.8	-	-	-	-	-
				Food loss						51.9	1,337.4	1,285.6	51.9	-	-	-	-	-
				Total Depreciation						(8.6)	1,328.9	1,328.9	-	-	-	8.6	-	-
				Other						43.3	1,372.2	1,328.9	43.3	-	-	-	-	-
				2024 Total Expenses						1,372.2	1,372.2	-	-	-	-	-	-	1,372.2
&12Built with finmodelslab.com template	&12Top Expenses	&D
BE
		Break Even Analysis
		Go to the Table of Contents
		Break Even Chart ($'000) 
		Break Even Calculation ($'000) 
		Fiscal Year											2020	2021	2022	2023	2024
		Revenue											1,597	1,797	2,199	2,541	2,635
		COGS											(491)	(553)	(676)	(781)	(810)
		Gross Margin											1,106	1,245	1,523	1,760	1,825
		Variable Expenses											(303)	(342)	(418)	(483)	(501)
		Net Margin											803	903	1,105	1,277	1,324
		EBITDA											134	223	412	571	605
		Break Even level											1,647	1,629	1,612	1,611	1,635
		Net Profit Before Tax											(25)	84	295	467	503
		Net Profit Before Tax %											0.0%	4.7%	13.4%	18.4%	19.1%
		Net Profit After Tax											(25)	76	265	421	452
		Net Profit After Tax %											0.0%	4.2%	12.1%	16.6%	17.2%
&12Built with finmodelslab.com template	&12Break Even Analysis	&D
Valuation
		Valuation
		Go to the Table of Contents
														7.5307182411
		WACC Calculation
		Cost of Capital
									Cost of Resources	Resource Share
				Loans					7.00%	90.0%		Terminal Valuation Method		EBITDA X
				Equity					10.00%	10.0%		Multiple of Method		5.00
				Tax Rate					10.00%
				Weighted avg cost of capital (WACC)					6.7%
		Free Cash Flow Calculation ($'000)
										1	2	3	4	5
		Free Cash Flow ($'000)
										1-Jan-04	1-Jan-04	1-Jan-04	1-Jan-04	1-Jan-04
				Financial year						2020	2021	2022	2023	2024
				Operating Income						23	119	308	468	503
					Tax Expense					-	(8)	(29)	(47)	(50)
				Tax-Effected EBIT (Earnings Before Interest)						23	111	279	421	452
					Plus: Depreciation Expense					111	104	104	103	102
					Capital Expenditures					(523)	-	-	-	-
						Inventory balance				147	166	203	234	243
						Accounts Receivable				-	-	-	-	-
						Current Liabilities				-	-	-	-	-
						Non-Current Liabilities				(633)	(333)	(33)	0	0
					Changes in Working Capital					486	(318)	(337)	(65)	(9)
					Changes in Other Assets & Liabilities
				Unlevered Free Cash Flow						97	(104)	45	459	546
		Free Cash Flow Valuation ($'000)
		Discounted Cash Flow ($'000)
				Financial year						2020	2021	2022	2023	2024
				Terminal Value										3,023
				Present Value of Unlevered Free Cash Flow						91	(92)	37	355	2,584
				NPV based on year 5										2,975
				Multiplicator evaluation										8x
&12Built with finmodelslab.com template	&12Valuation	&D
Revenue
		Revenue Calculation
		Go to the Table of Contents
		Revenue ($'000)
						2020	2021	2022	2023	2024
			Midweek 			1,021.7	1,201.2	1,518.8	1,808.7	1,850.2
			Weekends & Holidays			575.3	596.2	679.9	732.2	784.5
			Total Revenue			1,597.0	1,797.4	2,198.7	2,540.9	2,634.7
			Average Revenue per Day			4.4	4.9	6.0	7.0	7.2
		Sales Mix ($'000)
						2020	2021	2022	2023	2024
			Food			159.7	179.7	219.9	254.1	263.5
			Beverage			319.4	359.5	439.7	508.2	526.9
			Placeholder 1			479.1	539.2	659.6	762.3	790.4
			Placeholder 2			399.3	449.4	549.7	635.2	658.7
			Placeholder 3			239.6	269.6	329.8	381.1	395.2
			Total Revenue			1,597.0	1,797.4	2,198.7	2,540.9	2,634.7
&12Built with finmodelslab.com template	&12Revenue Calculation	&D
Fin_Charts
		Financial Charts
		Go to the Table of Contents
			24 months																	5 years
																																					REVENUE BREAKDOWN - $'000
																																					REVENUE BREAKDOWN - $'000
																																					OPERATING CASH FLOW - $'000
																																					CASH BALANCE - $'000
																																					EBITDA - $'000
																																					EBIT - $'000
&12Built with finmodelslab.com template	&12Financial Charts	&D
Op_Charts
		Operational Charts
		Go to the Table of Contents
			24 months																	5 years
																																					PRODUCTIVITY - $'000
																																					WORKFORCE PRODUCTIVITY - $'000
&12Built with finmodelslab.com template	&12Operational Charts	&D
KPI
		Benchmark KPIs
		Go to the Table of Contents
		KPI's								KPI's
			Industry	2020	2021	2022	2023	2024
		Gross margin, %	65.0%	69.3%	69.3%	69.3%	69.3%	69.3%
		Profit margin, %	15.0%	0.0%	4.2%	12.1%	16.6%	17.2%
		Wages as a % of Revenue 	30.0%	36.2%	32.8%	27.4%	24.2%	23.9%
		Avg weekly revenue, $	50,000	30,712	34,566	42,283	48,864	50,667
		Avg weekly net profit, $	10,000	-479	1,461	5,098	8,089	8,698
		KPI's
														2020	2021	2022	2023	2024
				Calculated KPI's
				Gross margin, %										69%	69%	69%	69%	69%
			5	Profit margin, %										0%	4%	12%	17%	17%
			1	Wages as a % of Revenue 										36%	33%	27%	24%	24%
			0	Avg weekly revenue, $										30,712	34,566	42,283	48,864	50,667
			2	Avg weekly net profit, $										-479	1,461	5,098	8,089	8,698
				Industry KPI's
				Industry Gross margin, %										65%	65%	65%	65%	65%
			5	Industry Profit margin, %										15%	15%	15%	15%	15%
			1	Industry Wages as a % of Revenue 										30%	30%	30%	30%	30%
				Industry Avg weekly revenue, $										50,000	50,000	50,000	50,000	50,000
			2	Industry Avg weekly net profit, $										10,000	10,000	10,000	10,000	10,000
&12Built with finmodelslab.com template	&12KPI`s	&D
Sources & Uses
		Sources and Uses
		Go to the Table of Contents
		Funding Structure ($'000)
		Debts	900.0	90.0%						Debts	900
		Equity	100.0	10.0%						Equity	100
		Total Funding	1,000.0	100.0%
		Gearing (debt to equity)	9.0x
		Sources of Funds ($'000)
		Debts								Debt_1	800	1		1	Debt_1	800
		Debt_1	800.0	80.0%						Debt_2	100	2		2	Debt_2	100
		Debt_2	100.0	10.0%						Debt_3	0	0		3	Founders	100
		Debt_3	- 0	-						Grant	0	0		4	0	0
		Grant	- 0	-						Founders	100	3		5	0	0
		Total Debts	900.0	90.0%						Series A	0	0		6	0	0
										Series B	0	0		7	0	0
		Equity								Series C	0	0		8	0	0
		Founders	100.0	10.0%
		Series A	- 0	-
		Series B	- 0	-
		Series C	- 0	-
		Total Equity	100.0	10.0%
		Total Funding	1,000.0	100.0%
		Sources and Uses ($'000)
				First	12	months
		Sources				Uses
		Revenue receipts	1,597.0	61.5%		COGS	505.8	19.5%
		Debt Drawdowns	900.0	34.7%		Variable Expenses	303.4	11.7%
		Equity Raisings	100.0	3.9%		Fixed Expenses	90.6	3.5%
						Salaries & Wages	577.8	22.2%
						Debt Repayments	266.7	10.3%
						Interest Paid	48.4	1.9%
						Corporate Tax Paid	- 0	-
						Capital Expenditure	523.0	20.1%
						Cash in Bank	281.3	10.8%
		Total Sources	2,597.0	100.0%		Total Uses	2,597.0	100.0%
&12Built with finmodelslab.com template	&12Sources and Uses	&D
IS
		Income Statement
		Go to the Table of Contents
		Fiscal year								2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
		Month							Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24
		Period Start Date								01/01/2020	01/02/2020	01/03/2020	01/04/2020	01/05/2020	01/06/2020	01/07/2020	01/08/2020	01/09/2020	01/10/2020	01/11/2020	01/12/2020	01/01/2021	01/02/2021	01/03/2021	01/04/2021	01/05/2021	01/06/2021	01/07/2021	01/08/2021	01/09/2021	01/10/2021	01/11/2021	01/12/2021	01/01/2022	01/02/2022	01/03/2022	01/04/2022	01/05/2022	01/06/2022	01/07/2022	01/08/2022	01/09/2022	01/10/2022	01/11/2022	01/12/2022	01/01/2023	01/02/2023	01/03/2023	01/04/2023	01/05/2023	01/06/2023	01/07/2023	01/08/2023	01/09/2023	01/10/2023	01/11/2023	01/12/2023	01/01/2024	01/02/2024	01/03/2024	01/04/2024	01/05/2024	01/06/2024	01/07/2024	01/08/2024	01/09/2024	01/10/2024	01/11/2024	01/12/2024
		Period End Date								Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24
		Counter								1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
		Current Year								2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
		Income Statement, $
			Revenue
				Midweek 						105,820	65,120	81,400	81,400	81,400	81,400	81,563	81,400	81,400	81,400	97,680	101,750	124,410	76,560	95,700	95,700	95,700	95,700	95,891	95,700	95,700	95,700	114,840	119,625	157,300	96,800	121,000	121,000	121,000	121,000	121,242	121,000	121,000	121,000	145,200	151,250	187,330	115,280	144,100	144,100	144,100	144,100	144,388	144,100	144,100	144,100	172,920	180,125	191,620	117,920	147,400	147,400	147,400	147,400	147,695	147,400	147,400	147,400	176,880	184,250
				Weekends & Holidays						59,583	36,667	45,833	45,833	45,833	45,833	45,925	45,833	45,833	45,833	55,000	57,292	61,750	38,000	47,500	47,500	47,500	47,500	47,595	47,500	47,500	47,500	57,000	59,375	70,417	43,333	54,167	54,167	54,167	54,167	54,275	54,167	54,167	54,167	65,000	67,708	75,833	46,667	58,333	58,333	58,333	58,333	58,450	58,333	58,333	58,333	70,000	72,917	81,250	50,000	62,500	62,500	62,500	62,500	62,625	62,500	62,500	62,500	75,000	78,125
				Total Revenue						165,403	101,787	127,233	127,233	127,233	127,233	127,488	127,233	127,233	127,233	152,680	159,042	186,160	114,560	143,200	143,200	143,200	143,200	143,486	143,200	143,200	143,200	171,840	179,000	227,717	140,133	175,167	175,167	175,167	175,167	175,517	175,167	175,167	175,167	210,200	218,958	263,163	161,947	202,433	202,433	202,433	202,433	202,838	202,433	202,433	202,433	242,920	253,042	272,870	167,920	209,900	209,900	209,900	209,900	210,320	209,900	209,900	209,900	251,880	262,375
			COGS
				Food						(3,308)	(2,036)	(2,545)	(2,545)	(2,545)	(2,545)	(2,550)	(2,545)	(2,545)	(2,545)	(3,054)	(3,181)	(3,723)	(2,291)	(2,864)	(2,864)	(2,864)	(2,864)	(2,870)	(2,864)	(2,864)	(2,864)	(3,437)	(3,580)	(4,554)	(2,803)	(3,503)	(3,503)	(3,503)	(3,503)	(3,510)	(3,503)	(3,503)	(3,503)	(4,204)	(4,379)	(5,263)	(3,239)	(4,049)	(4,049)	(4,049)	(4,049)	(4,057)	(4,049)	(4,049)	(4,049)	(4,858)	(5,061)	(5,457)	(3,358)	(4,198)	(4,198)	(4,198)	(4,198)	(4,206)	(4,198)	(4,198)	(4,198)	(5,038)	(5,248)
				Beverage						(8,270)	(5,089)	(6,362)	(6,362)	(6,362)	(6,362)	(6,374)	(6,362)	(6,362)	(6,362)	(7,634)	(7,952)	(9,308)	(5,728)	(7,160)	(7,160)	(7,160)	(7,160)	(7,174)	(7,160)	(7,160)	(7,160)	(8,592)	(8,950)	(11,386)	(7,007)	(8,758)	(8,758)	(8,758)	(8,758)	(8,776)	(8,758)	(8,758)	(8,758)	(10,510)	(10,948)	(13,158)	(8,097)	(10,122)	(10,122)	(10,122)	(10,122)	(10,142)	(10,122)	(10,122)	(10,122)	(12,146)	(12,652)	(13,644)	(8,396)	(10,495)	(10,495)	(10,495)	(10,495)	(10,516)	(10,495)	(10,495)	(10,495)	(12,594)	(13,119)
				Placeholder 1						(14,886)	(9,161)	(11,451)	(11,451)	(11,451)	(11,451)	(11,474)	(11,451)	(11,451)	(11,451)	(13,741)	(14,314)	(16,754)	(10,310)	(12,888)	(12,888)	(12,888)	(12,888)	(12,914)	(12,888)	(12,888)	(12,888)	(15,466)	(16,110)	(20,495)	(12,612)	(15,765)	(15,765)	(15,765)	(15,765)	(15,797)	(15,765)	(15,765)	(15,765)	(18,918)	(19,706)	(23,685)	(14,575)	(18,219)	(18,219)	(18,219)	(18,219)	(18,255)	(18,219)	(18,219)	(18,219)	(21,863)	(22,774)	(24,558)	(15,113)	(18,891)	(18,891)	(18,891)	(18,891)	(18,929)	(18,891)	(18,891)	(18,891)	(22,669)	(23,614)
				Placeholder 2						(14,473)	(8,906)	(11,133)	(11,133)	(11,133)	(11,133)	(11,155)	(11,133)	(11,133)	(11,133)	(13,360)	(13,916)	(16,289)	(10,024)	(12,530)	(12,530)	(12,530)	(12,530)	(12,555)	(12,530)	(12,530)	(12,530)	(15,036)	(15,662)	(19,925)	(12,262)	(15,327)	(15,327)	(15,327)	(15,327)	(15,358)	(15,327)	(15,327)	(15,327)	(18,393)	(19,159)	(23,027)	(14,170)	(17,713)	(17,713)	(17,713)	(17,713)	(17,748)	(17,713)	(17,713)	(17,713)	(21,256)	(22,141)	(23,876)	(14,693)	(18,366)	(18,366)	(18,366)	(18,366)	(18,403)	(18,366)	(18,366)	(18,366)	(22,040)	(22,958)
				Placeholder 3						(9,924)	(6,107)	(7,634)	(7,634)	(7,634)	(7,634)	(7,649)	(7,634)	(7,634)	(7,634)	(9,161)	(9,542)	(11,170)	(6,874)	(8,592)	(8,592)	(8,592)	(8,592)	(8,609)	(8,592)	(8,592)	(8,592)	(10,310)	(10,740)	(13,663)	(8,408)	(10,510)	(10,510)	(10,510)	(10,510)	(10,531)	(10,510)	(10,510)	(10,510)	(12,612)	(13,137)	(15,790)	(9,717)	(12,146)	(12,146)	(12,146)	(12,146)	(12,170)	(12,146)	(12,146)	(12,146)	(14,575)	(15,182)	(16,372)	(10,075)	(12,594)	(12,594)	(12,594)	(12,594)	(12,619)	(12,594)	(12,594)	(12,594)	(15,113)	(15,742)
				Total COGS						(50,862)	(31,299)	(39,124)	(39,124)	(39,124)	(39,124)	(39,202)	(39,124)	(39,124)	(39,124)	(46,949)	(48,905)	(57,244)	(35,227)	(44,034)	(44,034)	(44,034)	(44,034)	(44,122)	(44,034)	(44,034)	(44,034)	(52,841)	(55,042)	(70,023)	(43,091)	(53,864)	(53,864)	(53,864)	(53,864)	(53,971)	(53,864)	(53,864)	(53,864)	(64,636)	(67,330)	(80,923)	(49,799)	(62,248)	(62,248)	(62,248)	(62,248)	(62,373)	(62,248)	(62,248)	(62,248)	(74,698)	(77,810)	(83,908)	(51,635)	(64,544)	(64,544)	(64,544)	(64,544)	(64,673)	(64,544)	(64,544)	(64,544)	(77,453)	(80,680)
			GROSS MARGIN							114,542	70,487	88,109	88,109	88,109	88,109	88,285	88,109	88,109	88,109	105,731	110,136	128,916	79,333	99,166	99,166	99,166	99,166	99,364	99,166	99,166	99,166	118,999	123,957	157,694	97,042	121,303	121,303	121,303	121,303	121,546	121,303	121,303	121,303	145,564	151,629	182,241	112,148	140,185	140,185	140,185	140,185	140,465	140,185	140,185	140,185	168,222	175,231	188,962	116,285	145,356	145,356	145,356	145,356	145,646	145,356	145,356	145,356	174,427	181,695
			Variable Expenses
				Direct Labor						(16,540)	(10,179)	(12,723)	(12,723)	(12,723)	(12,723)	(12,749)	(12,723)	(12,723)	(12,723)	(15,268)	(15,904)	(18,616)	(11,456)	(14,320)	(14,320)	(14,320)	(14,320)	(14,349)	(14,320)	(14,320)	(14,320)	(17,184)	(17,900)	(22,772)	(14,013)	(17,517)	(17,517)	(17,517)	(17,517)	(17,552)	(17,517)	(17,517)	(17,517)	(21,020)	(21,896)	(26,316)	(16,195)	(20,243)	(20,243)	(20,243)	(20,243)	(20,284)	(20,243)	(20,243)	(20,243)	(24,292)	(25,304)	(27,287)	(16,792)	(20,990)	(20,990)	(20,990)	(20,990)	(21,032)	(20,990)	(20,990)	(20,990)	(25,188)	(26,238)
				Bank fee						(1,654)	(1,018)	(1,272)	(1,272)	(1,272)	(1,272)	(1,275)	(1,272)	(1,272)	(1,272)	(1,527)	(1,590)	(1,862)	(1,146)	(1,432)	(1,432)	(1,432)	(1,432)	(1,435)	(1,432)	(1,432)	(1,432)	(1,718)	(1,790)	(2,277)	(1,401)	(1,752)	(1,752)	(1,752)	(1,752)	(1,755)	(1,752)	(1,752)	(1,752)	(2,102)	(2,190)	(2,632)	(1,619)	(2,024)	(2,024)	(2,024)	(2,024)	(2,028)	(2,024)	(2,024)	(2,024)	(2,429)	(2,530)	(2,729)	(1,679)	(2,099)	(2,099)	(2,099)	(2,099)	(2,103)	(2,099)	(2,099)	(2,099)	(2,519)	(2,624)
				Food loss						(8,270)	(5,089)	(6,362)	(6,362)	(6,362)	(6,362)	(6,374)	(6,362)	(6,362)	(6,362)	(7,634)	(7,952)	(9,308)	(5,728)	(7,160)	(7,160)	(7,160)	(7,160)	(7,174)	(7,160)	(7,160)	(7,160)	(8,592)	(8,950)	(11,386)	(7,007)	(8,758)	(8,758)	(8,758)	(8,758)	(8,776)	(8,758)	(8,758)	(8,758)	(10,510)	(10,948)	(13,158)	(8,097)	(10,122)	(10,122)	(10,122)	(10,122)	(10,142)	(10,122)	(10,122)	(10,122)	(12,146)	(12,652)	(13,644)	(8,396)	(10,495)	(10,495)	(10,495)	(10,495)	(10,516)	(10,495)	(10,495)	(10,495)	(12,594)	(13,119)
				Plates						(4,962)	(3,054)	(3,817)	(3,817)	(3,817)	(3,817)	(3,825)	(3,817)	(3,817)	(3,817)	(4,580)	(4,771)	(5,585)	(3,437)	(4,296)	(4,296)	(4,296)	(4,296)	(4,305)	(4,296)	(4,296)	(4,296)	(5,155)	(5,370)	(6,832)	(4,204)	(5,255)	(5,255)	(5,255)	(5,255)	(5,266)	(5,255)	(5,255)	(5,255)	(6,306)	(6,569)	(7,895)	(4,858)	(6,073)	(6,073)	(6,073)	(6,073)	(6,085)	(6,073)	(6,073)	(6,073)	(7,288)	(7,591)	(8,186)	(5,038)	(6,297)	(6,297)	(6,297)	(6,297)	(6,310)	(6,297)	(6,297)	(6,297)	(7,556)	(7,871)
				VC_Placeholder5						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				VC_Placeholder6						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Total Variable Expenses						(31,427)	(19,339)	(24,174)	(24,174)	(24,174)	(24,174)	(24,223)	(24,174)	(24,174)	(24,174)	(29,009)	(30,218)	(35,370)	(21,766)	(27,208)	(27,208)	(27,208)	(27,208)	(27,262)	(27,208)	(27,208)	(27,208)	(32,650)	(34,010)	(43,266)	(26,625)	(33,282)	(33,282)	(33,282)	(33,282)	(33,348)	(33,282)	(33,282)	(33,282)	(39,938)	(41,602)	(50,001)	(30,770)	(38,462)	(38,462)	(38,462)	(38,462)	(38,539)	(38,462)	(38,462)	(38,462)	(46,155)	(48,078)	(51,845)	(31,905)	(39,881)	(39,881)	(39,881)	(39,881)	(39,961)	(39,881)	(39,881)	(39,881)	(47,857)	(49,851)
				Salary and Wages
				Waiter						(13,090)	(13,090)	(13,090)	(13,090)	(13,090)	(13,090)	(13,090)	(13,090)	(13,090)	(13,090)	(13,090)	(13,090)	(13,745)	(13,745)	(13,745)	(13,745)	(13,745)	(13,745)	(13,745)	(13,745)	(13,745)	(13,745)	(13,745)	(13,745)	(14,432)	(14,432)	(14,432)	(14,432)	(14,432)	(14,432)	(14,432)	(14,432)	(14,432)	(14,432)	(14,432)	(14,432)	(15,153)	(15,153)	(15,153)	(15,153)	(15,153)	(15,153)	(15,153)	(15,153)	(15,153)	(15,153)	(15,153)	(15,153)	(15,911)	(15,911)	(15,911)	(15,911)	(15,911)	(15,911)	(15,911)	(15,911)	(15,911)	(15,911)	(15,911)	(15,911)
				Administrator						(4,675)	(4,675)	(4,675)	(4,675)	(4,675)	(4,675)	(4,675)	(4,675)	(4,675)	(4,675)	(4,675)	(4,675)	(4,722)	(4,722)	(4,722)	(4,722)	(4,722)	(4,722)	(4,722)	(4,722)	(4,722)	(4,722)	(4,722)	(4,722)	(4,769)	(4,769)	(4,769)	(4,769)	(4,769)	(4,769)	(4,769)	(4,769)	(4,769)	(4,769)	(4,769)	(4,769)	(4,817)	(4,817)	(4,817)	(4,817)	(4,817)	(4,817)	(4,817)	(4,817)	(4,817)	(4,817)	(4,817)	(4,817)	(4,865)	(4,865)	(4,865)	(4,865)	(4,865)	(4,865)	(4,865)	(4,865)	(4,865)	(4,865)	(4,865)	(4,865)
				Cleaner						(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)
				Cook						(14,025)	(14,025)	(14,025)	(14,025)	(14,025)	(14,025)	(14,025)	(14,025)	(14,025)	(14,025)	(14,025)	(14,025)	(14,165)	(14,165)	(14,165)	(14,165)	(14,165)	(14,165)	(14,165)	(14,165)	(14,165)	(14,165)	(14,165)	(14,165)	(14,307)	(14,307)	(14,307)	(14,307)	(14,307)	(14,307)	(14,307)	(14,307)	(14,307)	(14,307)	(14,307)	(14,307)	(14,450)	(14,450)	(14,450)	(14,450)	(14,450)	(14,450)	(14,450)	(14,450)	(14,450)	(14,450)	(14,450)	(14,450)	(14,594)	(14,594)	(14,594)	(14,594)	(14,594)	(14,594)	(14,594)	(14,594)	(14,594)	(14,594)	(14,594)	(14,594)
				Chef						(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,545)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,610)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,677)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,743)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)	(6,811)
				Accounting						(3,273)	(3,273)	(3,273)	(3,273)	(3,273)	(3,273)	(3,273)	(3,273)	(3,273)	(3,273)	(3,273)	(3,273)	(3,305)	(3,305)	(3,305)	(3,305)	(3,305)	(3,305)	(3,305)	(3,305)	(3,305)	(3,305)	(3,305)	(3,305)	(3,338)	(3,338)	(3,338)	(3,338)	(3,338)	(3,338)	(3,338)	(3,338)	(3,338)	(3,338)	(3,338)	(3,338)	(3,372)	(3,372)	(3,372)	(3,372)	(3,372)	(3,372)	(3,372)	(3,372)	(3,372)	(3,372)	(3,372)	(3,372)	(3,405)	(3,405)	(3,405)	(3,405)	(3,405)	(3,405)	(3,405)	(3,405)	(3,405)	(3,405)	(3,405)	(3,405)
				HC_Placeholder7						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder8						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder9						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder10						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder11						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder12						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder13						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder14						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder15						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder16						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder17						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder18						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				HC_Placeholder19						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Total Salary and Wages						(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)
				Fixed Expenses
				Advertising						(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)	(500)
				Utilities						(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)	(1,550)
				Rent						(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)	(5,000)
				Web site						(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)	(200)
				Miscellaneous						(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)	(300)
				FC_Placeholder6						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				FC_Placeholder7						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				FC_Placeholder8						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				FC_Placeholder9						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				FC_Placeholder10						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				FC_Placeholder11						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				FC_Placeholder12						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				FC_Placeholder13						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				FC_Placeholder14						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				FC_Placeholder15						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Total Fixed Expenses						(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)
				Total Operating Expenditure						(87,129)	(75,042)	(79,877)	(79,877)	(79,877)	(79,877)	(79,925)	(79,877)	(79,877)	(79,877)	(84,712)	(85,920)	(92,078)	(78,474)	(83,916)	(83,916)	(83,916)	(83,916)	(83,970)	(83,916)	(83,916)	(83,916)	(89,357)	(90,718)	(101,015)	(84,374)	(91,031)	(91,031)	(91,031)	(91,031)	(91,097)	(91,031)	(91,031)	(91,031)	(97,687)	(99,351)	(108,829)	(89,598)	(97,291)	(97,291)	(97,291)	(97,291)	(97,367)	(97,291)	(97,291)	(97,291)	(104,983)	(106,906)	(111,792)	(91,852)	(99,828)	(99,828)	(99,828)	(99,828)	(99,908)	(99,828)	(99,828)	(99,828)	(107,804)	(109,798)
			EBITDA							27,413	(4,555)	8,232	8,232	8,232	8,232	8,360	8,232	8,232	8,232	21,019	24,216	36,838	859	15,250	15,250	15,250	15,250	15,394	15,250	15,250	15,250	29,642	33,240	56,679	12,668	30,272	30,272	30,272	30,272	30,448	30,272	30,272	30,272	47,877	52,278	73,411	22,550	42,895	42,895	42,895	42,895	43,098	42,895	42,895	42,895	63,239	68,325	77,170	24,433	45,528	45,528	45,528	45,528	45,739	45,528	45,528	45,528	66,623	71,896
			Depreciation & Amortization 
				Cafe Development						(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)	(8,400)
				Placeholder1						(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	(104)	-	-	-	-	-	-	-	-	-	-	-	-
				Placeholder2						(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	(28)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Placeholder3						(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)	(100)
				Placeholder4						(583)	(583)	(583)	(583)	(583)	(583)	(583)	(583)	(583)	(583)	(583)	(583)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Placeholder5						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Placeholder6						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Total Depreciation						(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)
			Total Depreciation & Amortization							(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(9,215)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,632)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,604)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)	(8,500)
			EBIT							18,197	(13,770)	(983)	(983)	(983)	(983)	(855)	(983)	(983)	(983)	11,804	15,001	28,206	(7,773)	6,618	6,618	6,618	6,618	6,762	6,618	6,618	6,618	21,010	24,608	48,047	4,036	21,640	21,640	21,640	21,640	21,816	21,640	21,640	21,640	39,245	43,646	64,807	13,946	34,290	34,290	34,290	34,290	34,494	34,290	34,290	34,290	54,635	59,721	68,670	15,933	37,028	37,028	37,028	37,028	37,239	37,028	37,028	37,028	58,123	63,396
				Interest Expense						-	(4,667)	(4,537)	(4,407)	(4,861)	(4,715)	(4,569)	(4,424)	(4,278)	(4,132)	(3,986)	(3,840)	(3,694)	(3,549)	(3,403)	(3,257)	(3,111)	(2,965)	(2,819)	(2,674)	(2,528)	(2,382)	(2,236)	(2,090)	(1,944)	(1,799)	(1,653)	(1,507)	(1,361)	(1,215)	(1,069)	(924)	(778)	(632)	(486)	(340)	(194)	(49)	(32)	(16)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
			Net Profit Before Tax							18,197	(18,437)	(5,520)	(5,390)	(5,844)	(5,698)	(5,425)	(5,407)	(5,261)	(5,115)	7,818	11,160	24,511	(11,322)	3,216	3,361	3,507	3,653	3,943	3,945	4,091	4,236	18,774	22,518	46,102	2,237	19,988	20,133	20,279	20,425	20,747	20,717	20,863	21,008	38,758	43,305	64,613	13,897	34,258	34,274	34,290	34,290	34,494	34,290	34,290	34,290	54,635	59,721	68,670	15,933	37,028	37,028	37,028	37,028	37,239	37,028	37,028	37,028	58,123	63,396
				Tax Expense			12.0	12.0		-	-	-	-	-	-	-	-	-	-	-	-	(2,161)	-	(284)	(296)	(309)	(322)	(348)	(348)	(361)	(374)	(1,655)	(1,986)	(4,610)	(224)	(1,999)	(2,013)	(2,028)	(2,043)	(2,075)	(2,072)	(2,086)	(2,101)	(3,876)	(4,331)	(6,461)	(1,390)	(3,426)	(3,427)	(3,429)	(3,429)	(3,449)	(3,429)	(3,429)	(3,429)	(5,463)	(5,972)	(6,867)	(1,593)	(3,703)	(3,703)	(3,703)	(3,703)	(3,724)	(3,703)	(3,703)	(3,703)	(5,812)	(6,340)
			Net Profit After Tax							18,197	(18,437)	(5,520)	(5,390)	(5,844)	(5,698)	(5,425)	(5,407)	(5,261)	(5,115)	7,818	11,160	22,350	(11,322)	2,932	3,065	3,198	3,331	3,595	3,597	3,730	3,863	17,119	20,532	41,492	2,014	17,989	18,120	18,251	18,383	18,672	18,645	18,776	18,908	34,883	38,975	58,151	12,507	30,832	30,847	30,861	30,861	31,044	30,861	30,861	30,861	49,171	53,749	61,803	14,339	33,325	33,325	33,325	33,325	33,515	33,325	33,325	33,325	52,310	57,057
			Error Check						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
										0	1	2	3	4	5	6	7	8	9	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
&12Built with finmodelslab.com template	&12Income Statement	&D
CF
		Cash Flow Statement
		Go to the Table of Contents
	é	ç	è	x	h	O
		Fiscal year								2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
		Month								Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24
		Period Start Date								01/01/2020	01/02/2020	01/03/2020	01/04/2020	01/05/2020	01/06/2020	01/07/2020	01/08/2020	01/09/2020	01/10/2020	01/11/2020	01/12/2020	01/01/2021	01/02/2021	01/03/2021	01/04/2021	01/05/2021	01/06/2021	01/07/2021	01/08/2021	01/09/2021	01/10/2021	01/11/2021	01/12/2021	01/01/2022	01/02/2022	01/03/2022	01/04/2022	01/05/2022	01/06/2022	01/07/2022	01/08/2022	01/09/2022	01/10/2022	01/11/2022	01/12/2022	01/01/2023	01/02/2023	01/03/2023	01/04/2023	01/05/2023	01/06/2023	01/07/2023	01/08/2023	01/09/2023	01/10/2023	01/11/2023	01/12/2023	01/01/2024	01/02/2024	01/03/2024	01/04/2024	01/05/2024	01/06/2024	01/07/2024	01/08/2024	01/09/2024	01/10/2024	01/11/2024	01/12/2024
		Period End Date								Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24
		Counter								1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
		Current Year								2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2023	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024
		Cash Flow Statement, $
			Cash Flow from Operating Activities
					Revenue					165,403	101,787	127,233	127,233	127,233	127,233	127,488	127,233	127,233	127,233	152,680	159,042	186,160	114,560	143,200	143,200	143,200	143,200	143,486	143,200	143,200	143,200	171,840	179,000	227,717	140,133	175,167	175,167	175,167	175,167	175,517	175,167	175,167	175,167	210,200	218,958	263,163	161,947	202,433	202,433	202,433	202,433	202,838	202,433	202,433	202,433	242,920	253,042	272,870	167,920	209,900	209,900	209,900	209,900	210,320	209,900	209,900	209,900	251,880	262,375
					Inflow					165,403	101,787	127,233	127,233	127,233	127,233	127,488	127,233	127,233	127,233	152,680	159,042	186,160	114,560	143,200	143,200	143,200	143,200	143,486	143,200	143,200	143,200	171,840	179,000	227,717	140,133	175,167	175,167	175,167	175,167	175,517	175,167	175,167	175,167	210,200	218,958	263,163	161,947	202,433	202,433	202,433	202,433	202,838	202,433	202,433	202,433	242,920	253,042	272,870	167,920	209,900	209,900	209,900	209,900	210,320	209,900	209,900	209,900	251,880	262,375
				Cash Receipts						165,403	101,787	127,233	127,233	127,233	127,233	127,488	127,233	127,233	127,233	152,680	159,042	186,160	114,560	143,200	143,200	143,200	143,200	143,486	143,200	143,200	143,200	171,840	179,000	227,717	140,133	175,167	175,167	175,167	175,167	175,517	175,167	175,167	175,167	210,200	218,958	263,163	161,947	202,433	202,433	202,433	202,433	202,838	202,433	202,433	202,433	242,920	253,042	272,870	167,920	209,900	209,900	209,900	209,900	210,320	209,900	209,900	209,900	251,880	262,375
					COGS					(66,120)	(25,431)	(41,472)	(39,124)	(39,124)	(39,124)	(39,226)	(39,101)	(39,124)	(39,124)	(49,297)	(49,492)	(59,746)	(28,622)	(46,676)	(44,034)	(44,034)	(44,034)	(44,148)	(44,008)	(44,034)	(44,034)	(55,483)	(55,703)	(74,517)	(35,011)	(57,096)	(53,864)	(53,864)	(53,864)	(54,004)	(53,831)	(53,864)	(53,864)	(67,868)	(68,138)	(85,001)	(40,461)	(65,983)	(62,248)	(62,248)	(62,248)	(62,410)	(62,211)	(62,248)	(62,248)	(78,433)	(78,744)	(85,737)	(41,954)	(68,417)	(64,544)	(64,544)	(64,544)	(64,712)	(64,506)	(64,544)	(64,544)	(81,326)	(81,648)
					Variable Expenses					(31,427)	(19,339)	(24,174)	(24,174)	(24,174)	(24,174)	(24,223)	(24,174)	(24,174)	(24,174)	(29,009)	(30,218)	(35,370)	(21,766)	(27,208)	(27,208)	(27,208)	(27,208)	(27,262)	(27,208)	(27,208)	(27,208)	(32,650)	(34,010)	(43,266)	(26,625)	(33,282)	(33,282)	(33,282)	(33,282)	(33,348)	(33,282)	(33,282)	(33,282)	(39,938)	(41,602)	(50,001)	(30,770)	(38,462)	(38,462)	(38,462)	(38,462)	(38,539)	(38,462)	(38,462)	(38,462)	(46,155)	(48,078)	(51,845)	(31,905)	(39,881)	(39,881)	(39,881)	(39,881)	(39,961)	(39,881)	(39,881)	(39,881)	(47,857)	(49,851)
					Fixed Expenses					(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)	(7,550)
					Salary and Wages					(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(48,153)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(49,158)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(50,199)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(51,278)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)	(52,397)
					Operating Expenditure					(153,249)	(100,473)	(121,349)	(119,001)	(119,001)	(119,001)	(119,151)	(118,978)	(119,001)	(119,001)	(134,008)	(135,413)	(151,824)	(107,096)	(130,592)	(127,950)	(127,950)	(127,950)	(128,119)	(127,923)	(127,950)	(127,950)	(144,840)	(146,421)	(175,532)	(119,386)	(148,126)	(144,894)	(144,894)	(144,894)	(145,101)	(144,862)	(144,894)	(144,894)	(165,555)	(167,489)	(193,830)	(130,059)	(163,274)	(159,539)	(159,539)	(159,539)	(159,778)	(159,501)	(159,539)	(159,539)	(183,416)	(185,650)	(197,529)	(133,806)	(168,245)	(164,372)	(164,372)	(164,372)	(164,620)	(164,334)	(164,372)	(164,372)	(189,130)	(191,447)
				Cash Payments						(153,249)	(100,473)	(121,349)	(119,001)	(119,001)	(119,001)	(119,151)	(118,978)	(119,001)	(119,001)	(134,008)	(135,413)	(151,824)	(107,096)	(130,592)	(127,950)	(127,950)	(127,950)	(128,119)	(127,923)	(127,950)	(127,950)	(144,840)	(146,421)	(175,532)	(119,386)	(148,126)	(144,894)	(144,894)	(144,894)	(145,101)	(144,862)	(144,894)	(144,894)	(165,555)	(167,489)	(193,830)	(130,059)	(163,274)	(159,539)	(159,539)	(159,539)	(159,778)	(159,501)	(159,539)	(159,539)	(183,416)	(185,650)	(197,529)	(133,806)	(168,245)	(164,372)	(164,372)	(164,372)	(164,620)	(164,334)	(164,372)	(164,372)	(189,130)	(191,447)
				Interest Paid						-	(4,667)	(4,537)	(4,407)	(4,861)	(4,715)	(4,569)	(4,424)	(4,278)	(4,132)	(3,986)	(3,840)	(3,694)	(3,549)	(3,403)	(3,257)	(3,111)	(2,965)	(2,819)	(2,674)	(2,528)	(2,382)	(2,236)	(2,090)	(1,944)	(1,799)	(1,653)	(1,507)	(1,361)	(1,215)	(1,069)	(924)	(778)	(632)	(486)	(340)	(194)	(49)	(32)	(16)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Corporate Tax Paid						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	(8,443)	-	-	-	-	-	-	-	-	-	-	-	(29,456)	-	-	-	-	-	-	-	-	-	-	-	(46,734)	-	-	-	-	-	-	-	-	-	-	-	(50,255)
				CASH INFLOW						165,403	101,787	127,233	127,233	127,233	127,233	127,488	127,233	127,233	127,233	152,680	159,042	186,160	114,560	143,200	143,200	143,200	143,200	143,486	143,200	143,200	143,200	171,840	179,000	227,717	140,133	175,167	175,167	175,167	175,167	175,517	175,167	175,167	175,167	210,200	218,958	263,163	161,947	202,433	202,433	202,433	202,433	202,838	202,433	202,433	202,433	242,920	253,042	272,870	167,920	209,900	209,900	209,900	209,900	210,320	209,900	209,900	209,900	251,880	262,375
				CASH OUTFLOW						(153,249)	(105,139)	(125,886)	(123,408)	(123,862)	(123,716)	(123,721)	(123,401)	(123,279)	(123,133)	(137,994)	(139,253)	(155,518)	(110,645)	(133,994)	(131,207)	(131,061)	(130,915)	(130,938)	(130,597)	(130,477)	(130,332)	(147,076)	(156,954)	(177,477)	(121,184)	(149,779)	(146,401)	(146,256)	(146,110)	(146,170)	(145,786)	(145,672)	(145,526)	(166,041)	(197,285)	(194,024)	(130,108)	(163,306)	(159,555)	(159,539)	(159,539)	(159,778)	(159,501)	(159,539)	(159,539)	(183,416)	(232,385)	(197,529)	(133,806)	(168,245)	(164,372)	(164,372)	(164,372)	(164,620)	(164,334)	(164,372)	(164,372)	(189,130)	(241,702)
				Net Cash Flow from Operating Activities						12,154	(3,353)	1,348	3,825	3,371	3,517	3,767	3,832	3,954	4,100	14,686	19,789	30,642	3,915	9,206	11,993	12,139	12,285	12,548	12,603	12,723	12,868	24,764	22,046	50,240	18,949	25,388	28,765	28,911	29,057	29,347	29,381	29,494	29,640	44,159	21,673	69,139	31,839	39,127	42,878	42,895	42,895	43,061	42,932	42,895	42,895	59,504	20,657	75,341	34,114	41,655	45,528	45,528	45,528	45,700	45,566	45,528	45,528	62,750	20,673
			Cash Flow from Investing Activities
				Capital Expenditure Paid						(20,000)	(1,000)	(2,000)	(500,000)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Fixed Assets Capital Expenditure						(20,000)	(1,000)	(2,000)	(500,000)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Net Cash Flow from Investing Activities						(20,000)	(1,000)	(2,000)	(500,000)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
			Cash Flow from Financing Activities
				Grant						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Debt						800,000	-	-	100,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Debt Drawdowns						800,000	-	-	100,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Debt Repayments						-	(22,222)	(22,222)	(22,222)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(2,778)	(2,778)	(2,778)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Debt Repayments						-	(22,222)	(22,222)	(22,222)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(2,778)	(2,778)	(2,778)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Ordinary Equity Raisings						100,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Ordinary Equity Buybacks						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Ordinary Equity Dividends Paid						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Other Financing Cash Flows Category 1						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Other Financing Cash Flows Category 2						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Other Financing Cash Flows						-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Net Cash Flow from Financing Activities						900,000	(22,222)	(22,222)	77,778	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(2,778)	(2,778)	(2,778)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Net Increase/(Decrease) in Cash Held						892,154	(26,575)	(22,874)	(418,397)	(21,629)	(21,483)	(21,233)	(21,168)	(21,046)	(20,900)	(10,314)	(5,211)	5,642	(21,085)	(15,794)	(13,007)	(12,861)	(12,715)	(12,452)	(12,397)	(12,277)	(12,132)	(236)	(2,954)	25,240	(6,051)	388	3,765	3,911	4,057	4,347	4,381	4,494	4,640	19,159	(3,327)	44,139	29,061	36,349	40,101	42,895	42,895	43,061	42,932	42,895	42,895	59,504	20,657	75,341	34,114	41,655	45,528	45,528	45,528	45,700	45,566	45,528	45,528	62,750	20,673
			Interest on Cash Breakdown
				Net Cash Flow from Investing Activities						(20,000)	(1,000)	(2,000)	(500,000)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Net Cash Flow from Financing Activities						900,000	(22,222)	(22,222)	77,778	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(25,000)	(2,778)	(2,778)	(2,778)	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
				Cash Receipts						165,403	101,787	127,233	127,233	127,233	127,233	127,488	127,233	127,233	127,233	152,680	159,042	186,160	114,560	143,200	143,200	143,200	143,200	143,486	143,200	143,200	143,200	171,840	179,000	227,717	140,133	175,167	175,167	175,167	175,167	175,517	175,167	175,167	175,167	210,200	218,958	263,163	161,947	202,433	202,433	202,433	202,433	202,838	202,433	202,433	202,433	242,920	253,042	272,870	167,920	209,900	209,900	209,900	209,900	210,320	209,900	209,900	209,900	251,880	262,375
				Cash Payments						(153,249)	(100,473)	(121,349)	(119,001)	(119,001)	(119,001)	(119,151)	(118,978)	(119,001)	(119,001)	(134,008)	(135,413)	(151,824)	(107,096)	(130,592)	(127,950)	(127,950)	(127,950)	(128,119)	(127,923)	(127,950)	(127,950)	(144,840)	(146,421)	(175,532)	(119,386)	(148,126)	(144,894)	(144,894)	(144,894)	(145,101)	(144,862)	(144,894)	(144,894)	(165,555)	(167,489)	(193,830)	(130,059)	(163,274)	(159,539)	(159,539)	(159,539)	(159,778)	(159,501)	(159,539)	(159,539)	(183,416)	(185,650)	(197,529)	(133,806)	(168,245)	(164,372)	(164,372)	(164,372)	(164,620)	(164,334)	(164,372)	(164,372)	(189,130)	(191,447)
				Change in Cash (Pre-Corporate Tax & Interest on Cash)						892,154	(21,908)	(18,337)	(413,990)	(16,768)	(16,768)	(16,663)	(16,744)	(16,768)	(16,768)	(6,328)	(1,371)	9,336	(17,536)	(12,392)	(9,750)	(9,750)	(9,750)	(9,632)	(9,723)	(9,750)	(9,750)	2,000	7,579	27,185	(4,252)	2,040	5,272	5,272	5,

ASSESSMENT TASK 1 – STUDENT EVIDENCE TO BE SUBMITTED TO THEIR ASSESSOR For this Assessment Task as a Case Study, in the role of the Head Chef in AVETA’s Café, you will be required to satisfactorily...

ASSESSMENT TASK 1 – STUDENT EVIDENCE TO BE SUBMITTED TO THEIR ASSESSOR

Assessment Activity 1 A –

Assessment Activity 1 B –

Assessment Activity 1 C –

Answer To: ASSESSMENT TASK 1 – STUDENT EVIDENCE TO BE SUBMITTED TO THEIR ASSESSOR For this Assessment Task as...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment