ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Statement of Net Cash Flow
3
4
#REF!#REF!#REF!#REF!#REF!#REF!
5
6
EBITDA #REF!#REF!#REF!#REF!
7
Less other costs #REF!#REF!#REF!#REF!
8
Less change in NWC #REF!#REF!#REF!#REF!
9
Less Tax paid #REF!#REF!#REF!#REF!
10
Operating Cash Flow #REF!#REF!#REF!#REF!
11
12
Capex #REF!#REF!#REF!#REF!
13
Investing Cash Flow #REF!#REF!#REF!#REF!
14
15
Interest paid #REF!#REF!#REF!#REF!
16
Movement in debt #REF!#REF!#REF!#REF!
17
Payment of dividends #REF!#REF!#REF!#REF!
18
Financing Cash Flow #REF!#REF!#REF!#REF!
19
20
Net cash flow #REF!#REF!#REF!#REF!
21
22
Movement of Cash as per BS
#REF!#REF!#REF!#REF!
23
24
Check net cash flow #REF!#REF!#REF!#REF!
25
26
Data for computation
27
28
#REF!20132014201520162017
29
30
NWC #REF!#REF!#REF!#REF!#REF!
31
Change in NWC #REF!#REF!#REF!#REF!
32
33
Fixed Assets #REF!#REF!#REF!#REF!#REF!
34
Change in fixed assets #REF!#REF!#REF!#REF!
35
D&A in P&L #REF!#REF!#REF!#REF!#REF!
36
Capex #REF!#REF!#REF!#REF!
37
38
LT Debt #REF!#REF!#REF!#REF!#REF!
39
Movement in LT Debt #REF!#REF!#REF!#REF!
40
41
Retained Earnings #REF!#REF!#REF!#REF!#REF!
42
Net income #REF!#REF!#REF!#REF!#REF!
43
44
Movement in retained earnings before NI
#REF!#REF!#REF!#REF!
45
Last year net income #REF!#REF!#REF!#REF!
46
Dividends paid #REF!#REF!#REF!#REF!
47
48
Cash and equivalents #REF!#REF!#REF!#REF!#REF!
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