KTIL - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		Pipavav+Kakinada		1	2	3	4	5	6	7	8	9	10
2			2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022
3	A	Operating Cash Flow	5.6
4	B	- normal CAPEX	2.9
5	C	FCFF	2.7	2.86	3.03	3.22	3.41	4	6	6.8	7.208	7.64048	8.0989088
6		- addttional CAPEX		-12.5	-12.5	-12.5	-12.5	0	0	0	0	0	0
7		Modified FCFF		-9.64	-9.47	-9.28	-9.09	4	6	6.8	7.208	7.64048	8.0989088
8	Cost of Capital	0.18
9		PV		-9.64	-9.47	-9.28	-9.09	4	6	6.8	7.208	7.64048	8.0989088
10		Sum of PV	2.2673888
11		Terminal Value	10.32
12		Total	12.58
13		Present EV	35.5
14
15		Only Pipavav
16			2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022
17		Operating Cash Flow	5.6
18		- normal CAPEX	2.9
19		FCFF	2.7	2.86	3.03	3.22	3.41	4	4.5	5	5.3	5.618	5.95508
20		- addttional CAPEX		-6	-6	-6	-6	0	0	0	0	0	0
21		Modified FCFF		-3.14	-2.97	-2.78	-2.59	4	4.5	5	5.3	5.618	5.95508
22	Cost of Capital	0.18
23		PV		-3.14	-2.97	-2.78	-2.59	4	4.5	5	5.3	5.618	5.95508
24		Sum of PV	18.89308
25		Terminal Value	7.59
26		Total	26.48
27		Present EV	35.5
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