2.2 115. Exercise - before.xlsx.xlsx

	B	C	D
1
2
3	Date	Financials	Amount
4	1.1.2014	Revenue - Supermarkets	72
5	1.1.2014	Cogs - Supermarkets	47
6	1.1.2014	Revenue - Discounters	37
7	1.1.2014	Cogs - Discounters	20
8	1.1.2014	Revenue - Grocery	36
9	1.1.2014	Cogs - Grocery	17
10	1.1.2014	Revenue - Retail	57
11	1.1.2014	Cogs - Retail	32
12	1.1.2014	Operating expenses	95.4
13	1.1.2014	D&A	2
14	1.1.2014	Interest expenses	5
15	1.1.2014	Taxes	17
16	2.1.2014	Revenue - Supermarkets	75
17	2.1.2014	Cogs - Supermarkets	55
18	2.1.2014	Revenue - Discounters	26
19	2.1.2014	Cogs - Discounters	18
20	2.1.2014	Revenue - Grocery	42
21	2.1.2014	Cogs - Grocery	18
22	2.1.2014	Revenue - Retail	54
23	2.1.2014	Cogs - Retail	33
24	2.1.2014	Operating expenses	96.3
25	2.1.2014	D&A	2
26	2.1.2014	Interest expenses	5
27	2.1.2014	Taxes	17
28	3.1.2014	Revenue - Supermarkets	69
29	3.1.2014	Cogs - Supermarkets	58
30	3.1.2014	Revenue - Discounters	32
31	3.1.2014	Cogs - Discounters	12
32	3.1.2014	Revenue - Grocery	41
33	3.1.2014	Cogs - Grocery	11
34	3.1.2014	Revenue - Retail	64
35	3.1.2014	Cogs - Retail	35
36	3.1.2014	Operating expenses	96.6
37	3.1.2014	D&A	3
38	3.1.2014	Interest expenses	5
39	3.1.2014	Taxes	18
40	4.1.2014	Revenue - Supermarkets	68
41	4.1.2014	Cogs - Supermarkets	50
42	4.1.2014	Revenue - Discounters	29
43	4.1.2014	Cogs - Discounters	19
44	4.1.2014	Revenue - Grocery	38
45	4.1.2014	Cogs - Grocery	15
46	4.1.2014	Revenue - Retail	60
47	4.1.2014	Cogs - Retail	32
48	4.1.2014	Operating expenses	99.52
49	4.1.2014	D&A	2
50	4.1.2014	Interest expenses	5
51	4.1.2014	Taxes	17
52	5.1.2014	Revenue - Supermarkets	68
53	5.1.2014	Cogs - Supermarkets	54
54	5.1.2014	Revenue - Discounters	32
55	5.1.2014	Cogs - Discounters	19
56	5.1.2014	Revenue - Grocery	50
57	5.1.2014	Cogs - Grocery	14
58	5.1.2014	Revenue - Retail	64
59	5.1.2014	Cogs - Retail	30
60	5.1.2014	Operating expenses	105.92
61	5.1.2014	D&A	3
62	5.1.2014	Interest expenses	5
63	5.1.2014	Taxes	19
64	6.1.2014	Revenue - Supermarkets	56
65	6.1.2014	Cogs - Supermarkets	49
66	6.1.2014	Revenue - Discounters	31
67	6.1.2014	Cogs - Discounters	14
68	6.1.2014	Revenue - Grocery	36
69	6.1.2014	Cogs - Grocery	15
70	6.1.2014	Revenue - Retail	57
71	6.1.2014	Cogs - Retail	33
72	6.1.2014	Operating expenses	93.12
73	6.1.2014	D&A	3
74	6.1.2014	Interest expenses	4
75	6.1.2014	Taxes	16
76	7.1.2014	Revenue - Supermarkets	66
77	7.1.2014	Cogs - Supermarkets	55
78	7.1.2014	Revenue - Discounters	38
79	7.1.2014	Cogs - Discounters	17
80	7.1.2014	Revenue - Grocery	43
81	7.1.2014	Cogs - Grocery	17
82	7.1.2014	Revenue - Retail	68
83	7.1.2014	Cogs - Retail	33
84	7.1.2014	Operating expenses	114.58
85	7.1.2014	D&A	3
86	7.1.2014	Interest expenses	4
87	7.1.2014	Taxes	19
88	8.1.2014	Revenue - Supermarkets	57
89	8.1.2014	Cogs - Supermarkets	52
90	8.1.2014	Revenue - Discounters	35
91	8.1.2014	Cogs - Discounters	19
92	8.1.2014	Revenue - Grocery	38
93	8.1.2014	Cogs - Grocery	16
94	8.1.2014	Revenue - Retail	57
95	8.1.2014	Cogs - Retail	33
96	8.1.2014	Operating expenses	104.38
97	8.1.2014	D&A	3
98	8.1.2014	Interest expenses	5
99	8.1.2014	Taxes	16
100	9.1.2014	Revenue - Supermarkets	60