TLR Cashflow Example Spreadsheet.xlsx

	A	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2
3	Week ending	16/6/2023	23/6/2023	30/6/2023	7/7/2023	14/7/2023	21/7/2023	28/7/2023	4/8/2023	11/8/2023	18/8/2023	25/8/2023	1/9/2023	8/9/2023	15/9/2023	Future	Assumptions/Notes

4	INCOME
5	Client, candidate		28,716.00
6	Amazon, Bruce Willis		26,589.00
7	Tesla, Barrack Obama						29,700.00
8	Aldi, Clive Palmer							59,125.00
9	Telstra, Billy Slater															55,000.00	Unknown Start Date
10	Streets, Paddle Pop Lion						26,345.00
11	Google, Steve Jobs															31,900.00	Unknown Start Date
12	Microsoft, Bill Cosby					23,100.00
13	Billabong, Justin Hemmes				26,400.00
14	Avon, Santa Clause	22,608.00
15	Client, candidate										25,000.00
16	Client, candidate					26,400.00
17	Client, candidate		11,550.00
18	Client, candidate					23,100.00
19	Client, candidate						45,000.00
20	Client, candidate					14,850.00
21	Client, candidate															13,200.00	Unknown Date
22	Client, candidate	12,512.50
23	Client, candidate				11,550.00
24	Client, candidate															10,000.00	Unknown Date
25	Client, candidate
26	Client, candidate	6,561.50					6,561.50				6,561.50				6,561.50		Invoice not yet issued
27	Client, candidate	10,183.15															Invoice not yet issued
28	Client, candidate	1,588.20			1,586.20				1,586.20				1,586.20				Invoice not yet issued
29	Client, candidate	578.07					1,629.10				1,629.10				1,629.10
30	Total Income Expected	54,031.42	66,855.00	0.00	39,536.20	87,450.00	109,235.60	59,125.00	1,586.20	0.00	33,190.60	0.00	1,586.20	0.00	8,190.60	110,100.00
31	EXPENSES
32	Cost of sales
33	Wages	8,124.16	8,124.16	8,124.16	8,124.16	8,124.16	8,124.16	8,124.16	8,124.16	8,124.16	8,124.16	8,124.16	8,124.16	8,124.16	8,124.16
34	Super						20,000.00
35	Virtual Assistant's			3,000.00				3,000.00				3,000.00
36	Expense 1																Unknown Start Date
37	Expense 2
38	Expense 3
39
40	Contracted
41	Rent			3,355.00				3,355.00				3,355.00
42	ATS / CRM Contract								1,874.40
43	Car Repayment		818.68				818.68					818.68
44	Linkedin Costs					1,040.68				1,040.68					1,040.68
45
46
47	Other movements
48	AMEX Repayment			20,000.00				20,000.00					20,000.00
49	Mastercard Repayment				200.00				200.00				200.00
50	Savings	4,600.00	4,600.00	4,600.00	4,600.00	4,600.00	4,600.00	4,600.00	4,600.00	4,600.00						4,600.00
51
52
53
54	Tax
55	MIAS		12,616.00
56	QBAS Savings	4,200.00	4,200.00	4,200.00	4,200.00	4,200.00	4,200.00	4,200.00	4,200.00	4,200.00	4,200.00	44,200.00	4,200.00	9.05
57	PAYG Income Tax Instalment							24,159.00
58	PAYG Income Tax Instalment							6,895.00
59
60
61
62
63																30,063.00
64	Tax Top Up		2,838.45				2,838.45									2,838.45
65
66
67	Total Expenses	16,924.16	33,197.29	43,279.16	17,124.16	17,964.84	40,581.29	74,333.16	18,998.56	17,964.84	12,324.16	59,497.84	32,524.16	8,133.21	9,164.84	37,501.45
68
69	Income Surplus/Deficit	37,107.26	33,657.71	-43,279.16	22,412.04	69,485.16	68,654.31	-15,208.16	-17,412.36	-17,964.84	20,866.44	-59,497.84	-30,937.96	-8,133.21	-974.24	72,598.55
70
71	Opening Cash Balance	38,674.53	75,781.79	109,439.50	66,160.34	88,572.38	158,057.54	226,711.85	211,503.69	194,091.33	176,126.49	196,992.93	137,495.09	106,557.13	98,423.92	196,992.93
72
73	Closing Cash Balance	75,781.79	109,439.50	66,160.34	88,572.38	158,057.54	226,711.85	211,503.69	194,091.33	176,126.49	196,992.93	137,495.09	106,557.13	98,423.92	97,449.68	269,591.49
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100