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	AM
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
8	Operation	2-Mar	9-Mar	16-Mar	23-Mar	30-Mar	6-Apr	13-Apr	20-Apr	27-Apr	4-May	11-May	18-May	25-May	1-Jun	8-Jun	15-Jun	22-Jun	29-Jun
9	Foundation
10	Labour		10800	10800	10800	10800	10800
11	Material					18000	18000	18000	18000	18000
12	Plant									7200	7200	7200	7200	7200
13	Structural frames
14	Labour					21875	21875	21875	21875
15	Material								56875	56875	56875	56875
16	Plant												8750	8750	8750	8750
17	Claddings
18	Labour							26250	26250	26250	26250
19	Material										41250	41250	41250	41250
20	Plant														7500	7500	7500	7500
21	Roof
22	Labour								20000	20000	20000
23	Material											36666.7	36666.7	36666.6
24	Plant															10000	10000	10000
25	External windows and doors
26	Labour										22000	22000
27	Material													77000	77000
28	Plant																	11000	11000
29
30	Total		£10,800.00	£10,800.00	£10,800.00	£50,675.00	£50,675.00	£66,125.00	£143,000.00	£128,325.00	£173,575.00	£163,991.70	£93,866.70	£170,866.60	£93,250.00	£26,250.00	£17,500.00	£28,500.00	£11,000.00
31
32	Table 1
33	Net Cash Outflow (Payments)
34	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
35	Weekly Date	2-Mar	9-Mar	16-Mar	23-Mar	30-Mar	6-Apr	13-Apr	20-Apr	27-Apr	4-May	11-May	18-May	25-May	1-Jun	8-Jun	15-Jun	22-Jun	29-Jun
36	Direct Costs		£10,800.00	£10,800.00	£10,800.00	£50,675.00	£50,675.00	£66,125.00	£143,000.00	£128,325.00	£173,575.00	£163,991.70	£93,866.70	£170,866.60	£93,250.00	£26,250.00	£17,500.00	£28,500.00	£11,000.00	∑	£1,250,000.00
37	Overheads	8750	8750	8750	8750	8750	8750	8750	8750	8750	8750									∑	£87,500.00
38	Total	£8,750.00	£19,550.00	£19,550.00	£19,550.00	£59,425.00	£59,425.00	£74,875.00	£151,750.00	£137,075.00	£182,325.00	£163,991.70	£93,866.70	£170,866.60	£93,250.00	£26,250.00	£17,500.00	£28,500.00	£11,000.00		£1,337,500.00
39
40
41	Table 2
42	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
43	Payments	£8,750.00	£19,550.00	£19,550.00	£19,550.00	£59,425.00	£59,425.00	£74,875.00	£151,750.00	£137,075.00	£182,325.00	£163,991.70	£93,866.70	£170,866.60	£93,250.00	£26,250.00	£17,500.00	£28,500.00	£11,000.00
44	Receipts						£292,500.00		£219,375.00		£658,125.00	£219,375.00																								£73,125.00
45	Cash flow	-£8,750.00	-£28,300.00	-£47,850.00	-£67,400.00	-£126,825.00	£106,250.00	£31,375.00	£99,000.00	-£38,075.00	£437,725.00	£493,108.30	£399,241.60	£228,375.00	£135,125.00	£108,875.00	£91,375.00	£62,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£125,000.00	£125,000.00	Check it lines up with the profit
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75	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
76	Boundary 1 <0	-£8,750.00	-£28,300.00	-£47,850.00	-£67,400.00	-£126,825.00	#N/A	#N/A	#N/A	-£38,075.00	#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	#N/A
77	Boundary 2 >0	#N/A	#N/A	#N/A	#N/A	#N/A	£106,250.00	£31,375.00	£99,000.00	#N/A	£437,725.00	£493,108.30	£399,241.60	£228,375.00	£135,125.00	£108,875.00	£91,375.00	£62,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£51,875.00	£125,000.00
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100