Skillshare - Cash Flow Example - STL.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Cash Flow Statement	STL Store Simulation
2
3	Cash Flow		2024
4			January	February	March	April	May	June	July	August	September	October	November	December

5
6	Starting Cash Balance		1000	944	1510	1400	1814	4907	8432	11815	14584	17057	22118	27919
7
8	Revenue
9		Cults3D	320	615	361	410	1287	260	1512	1600	1080	650	1235	1480
10		Patreon	430	473	371	790	1814	2158	1422	540	1800	2893	2795	1040
11		Gumroad	155	615	234	302	1287	2158	1800	2000	940	2763	3153	1840
12		MyMiniFactory	105	675	634	205	1307	2236	1800	1240	1060	2275	1755	280
13
14	Total Revenue		1010	1703	965	1502	4388	4576	4734	4140	3820	6305	7183	4360
15
16	Cost of Goods Sold
17		Labour	750	750	750	750	750	750	750	750	750	750	750	750
18		Overhead	0	0	0	0	0	0	0	0	0	0	0	0
19		Fees	76	146	85	97	305	62	361	381	257	154	292	354
20
21	Total C.O.G.S.		826	896	835	847	1055	812	1111	1131	1007	904	1042	1104
22
23	Gross Profit		184	806	130	655	3333	3764	3623	3009	2813	5401	6140	3256
24
25	Operating Expenses
26		Labour	0	0	0	0	0	0	0	0	0	0	0	0
27		Equiptment	0	0	0	0	0	0	0	0	0	0	0	0
28		Utilities	0	0	0	0	0	0	0	0	0	0	0	0
29		Insurance	0	0	0	0	0	0	0	0	0	0	0	0
30		Software	40	40	40	40	40	40	40	40	40	40	40	40
31		Legal	0	0	0	0	0	0	0	0	0	0	0	0
32		Accounting	50	50	50	50	50	50	50	50	50	50	50	150
33		Marketing	150	150	150	150	150	150	150	150	250	250	250	250
34		R&D	0	0	0	0	0	0	0	0	0	0	0	0
35
36	Total Operating Expenses		240	240	240	240	240	240	240	240	340	340	340	440
37
38	Cash Inflow/outflow		-56	566	-110	415	3093	3524	3383	2769	2473	5061	5800	2816
39
40	Ending bank Balance		944	1510	1400	1814	4907	8432	11815	14584	17057	22118	27919	30734