Shree Cement DCF valuation.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Year	TOTAL SALES	T-1 ACTUALS	MOVING AVERAGE(3)	MOVING AVERAGE (5)	WT MOVING AVG (3)	WT MOVING AVG (5)	EXP SMOOTHENING	LIN REG	MULTI REG
2	2004	494.28
3	2005	602.15	494.28					494.28
4	2006	694.83	602.15					569.789	1188.061366	775.679776
5	2007	1,403.05	694.83	597.0866667		626.916		657.3177	1283.645008	488.8682841
6	2008	2,108.21	1,403.05	900.01		1030.404		1179.33031	2014.053376	962.1300913
7	2009	2,716.47	2,108.21	1402.03	1060.504	1613.986	1301.987	1829.546093	2741.305875	2179.620085
8	2010	3,628.20	2,716.47	2,075.91	1504.942	2271.308	1857.712	2450.392828	3368.62252	3100.954676
9	2011	3,453.53	3,628.20	2,817.63	2110.152	3050.683	2534.831	3274.857848	4308.916809	3330.026362
10	2012	5,898.12	3,453.53	3,266.07	2,661.89	3358.519	3018.939	3399.928355	4128.774438	4355.266936
11	2013	5,590.25	5,898.12	4,326.62	3,560.91	4710.759	4013.603	5148.662506	6649.952875	5875.221965
12	2014	5,887.31	5,590.25	4,980.63	4,257.31	5255.267	4771.684	5457.773752	6332.437379	4865.831781
13	2015	6,453.57	5,887.31	5,791.89	4,891.48	5800.354	5331.065	5758.449126	6638.8042	5707.053333
14	2016	5,513.64	6,453.57	5,977.04	5,456.56	6111.028	5755.479	6245.033738	7222.804994	6461.798945
15	2017	8,594.30	5,513.64	5,951.51	5,868.58	5870.353	5916.462	5733.058121	6253.427206	6461.467455
16	2018	9,833.10	8,594.30	6,853.84	6,407.81	7241.956	6670.852	7735.927436	9430.603567	8036.774294
17	2019	11,722.00	9,833.10	7,980.35	7,256.38	8597.568	7865.036	9203.948231	10708.21488	9996.032126
18	2020	11,904.00	11,722.00	10,049.80	8,423.32	10529.79	9382.111	10966.58447	12656.29368	11500.2871
19			11,904.00						12843.9957
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
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
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