Cash flow statement.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL
1													CASH FLOW GRAPH
2
3
4
5
6
7		Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17	Week 18	Week 19	Week 20
8	Operation	1-Mar	8-Mar	15-Mar	22-Mar	29-Mar	5-Apr	12-Apr	19-Apr	26-Apr	3-May	10-May	17-May	24-May	31-May	7-Jun	14-Jun	21-Jun	28-Jun	5-Jul	12-Jul
9	Site Preparation
10	Labour		1500
11	Material					1000
12	Plant									1000
13	Substructure
14	Labour			1500	1500
15	Material						5000	5000
16	Plant										2000	2000
17	Prefab Col./Slabs/Beams
18	Labour					2000	2000
19	Material								7500	7500
20	Plant												1250	1250
21	Claddings
22	Labour						1000	1000
23	Material									2250	2250
24	Plant													750	750
25	Roof
26	Labour								1500
27	Material											4000
28	Plant															2000
29	Wall, windows, doors, & stairs
30	Labour									3000	3000
31	Material												3500	3500
32	Mechanical/Electrical services
33	Labour											3500	3500
34	Material														9000	9000
35	Drainage/External works
36	Labour													2500
37	Material																3500
38	Plant																				2000
39
40	Total		1500	1500	1500	3000	8000	6000	9000	13750	7250	9500	8250	8000	9750	11000	3500	0	0	0	2000
41
42	Table 1
43	Net Cash Outflow (Payments)
44	Week Number	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17	Week 18	Week 19	Week 20	Week 21	Week 22	Week 23	Week 24	Week 25	Week 26	Week 27	Week 28	Week 29	Week 30	Week 31	Week 32	Week 33	Week 34	Week 35	Week 36
45	Weekly Date	1-Mar	8-Mar	15-Mar	22-Mar	29-Mar	5-Apr	12-Apr	19-Apr	26-Apr	3-May	10-May	17-May	24-May	31-May	7-Jun	14-Jun	21-Jun	28-Jun	5-Jul	12-Jul	19-Jul	26-Jul	2-Aug	9-Aug	16-Aug	23-Aug	30-Aug	6-Sep	13-Sep	20-Sep	27-Sep	4-Oct	11-Oct	18-Oct	25-Oct	1-Nov
46	Direct Costs		1500	1500	1500	3000	8000	6000	9000	13750	7250	9500	8250	8000	9750	11000	3500	0	0	0	2000	∑	103500
47	Overheads	833.33	833.33	833.33	833.33	833.33	833.33	833.33	833.33	833.33	833.33	833.33	833.33									∑	9999.96
48	Total	833.33	2333.33	2333.33	2333.33	3833.33	8833.33	6833.33	9833.33	14583.33	8083.33	10333.33	9083.33	8000	9750	11000	3500	0	0	0	2000		113499.96
49
50
51	Table 2
52	Cash flow statements	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17	Week 18	Week 19	Week 20	Week 21	Week 22	Week 23	Week 24	Week 25	Week 26	Week 27	Week 28	Week 29	Week 30	Week 31	Week 32	Week 33	Week 34	Week 35	Week 36
53	Payments	833.33	2333.33	2333.33	2333.33	3833.33	8833.33	6833.33	9833.33	14583.33	8083.33	10333.33	9083.33	8000	9750	11000	3500	0	0	0	2000
54	Receipts										61925		37155	18577.5																							6192.5
55	Cash flow	-833.33	-3166.66	-5499.99	-7833.32	-11666.65	-20499.98	-27333.31	-37166.64	-51749.97	2091.7	-8241.63	19830.04	30407.54	20657.54	9657.54	6157.54	6157.54	6157.54	6157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	10350.04	Check profit
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85	Cash flow statements	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17	Week 18	Week 19	Week 20	Week 21	Week 22	Week 23	Week 24	Week 25	Week 26	Week 27	Week 28	Week 29	Week 30	Week 31	Week 32	Week 33	Week 34	Week 35	Week 36
86	Boundary 1 <0	-833.33	-3166.66	-5499.99	-7833.32	-11666.65	-20499.98	-27333.31	-37166.64	-51749.97	#N/A	-8241.63	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
87	Boundary 2 >0	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	2091.7	#N/A	19830.04	30407.54	20657.54	9657.54	6157.54	6157.54	6157.54	6157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	4157.54	10350.04
88
89
90
91
92
93
94
95
96
97
98
99
100