Description
This is a spreadsheet about financial analysis of Vedanta India Limited.
VEDANTA INDIA LIMITED Balance sheet
Mar ' 09 Mar ' 08 Mar ' 07 Mar ' 06
Sources of funds
Owner's fund Equity share capital Share application money Preference share capital Reserves & surplus 1.25 1.25 1.25 1.25
10 15.88 10 3.11
10 1.18
10 0.66
Loan funds
Secured loans Unsecured loans Total 11.25 0.49 38.88 16.89 9.3 40.55 5.91 9.22 27.56 9.22 21.12
Uses of funds
Fixed assets Gross block Less : revaluation reserve Less : accumulated depreciation Net block Capital work-inprogress Investments 38.64 20.72 20.81 20.81
-
-
-
5.43 33.21
7.73 12.99 3.94 4.98
7.35 13.46 0.12 4.45
6.64 14.17 0.01 4.86
2.83
Net current assets
Current assets, loans & advances Less : current liabilities & provisions Total net current assets 4.46 20.39 10.61 3.79
1.62 2.84
1.76 18.63
1.08 9.53
1.71 2.08
Miscellaneous expenses not written Total
38.88
40.55
27.56
21.12
Notes:
Book value of unquoted investments Market value of quoted investments Contingent liabilities Number of equity sharesoutstanding (Lacs) 0.03
0.04 -
4.27 -
4.38 -
2.48
125
125
125
125
Mar ' 05
8.31
-7.95
1 12.46 13.82
20.8
-
5.92 14.88 0.03
0.49
1.67 -1.18
0.09 13.82
-
-
83.1
Profit loss account
Mar ' 09 Mar ' 08 Mar ' 07 Mar ' 06 Mar ' 05
Income
Operating income 5.25 3.94 0.01 -
Expenses
Material consumed Manufacturing expenses Personnel expenses 0.26 0.92 0.21 2.56 3.95 1.3 0.44 3.5 0.05 0.05 0.34 0.42 -0.41 0.01 0.02 0.39 0.22 -0.22 0.01 0.05 0.15 1.46 -1.46 1.45 0.01
Selling expenses Adminstrative expenses Expenses capitalised Cost of sales Operating profit Other recurring income Adjusted PBDIT Financial expenses Depreciation Other write offs Adjusted PBT Tax charges Adjusted PAT Non recurring items Other non cash adjustments Reported net profit Earnigs before appropriation
0.37 1.67 1.76 0.72 -0.8 0.01 -0.81 -0.26
0.54 4.05 0.26 0.43 3.36 0.47 2.89 -0.03 -
2.81 2.4 0.11 0.71 1.58 0.12 1.46 -
2.62 2.4 0.07 0.72 1.61 1.61 -
3.74 2.28 0.59 0.72
0.97 0.97
-1.07 -1.07
0.01 2.86 2.86 1.46 1.46
1.61 1.61
0.97 0.97
Equity dividend Preference dividend Dividend tax Retained earnings
-1.07
0.8 0.14 1.93
0.8 0.14 0.53
-
0.35 0.05 1.21 0.97
Ratio Analysis
Mar ' 09 Mar ' 08 Mar ' 07 Mar ' 06 Mar ' 05
Per share ratios
Adjusted EPS (Rs) Adjusted cash EPS (Rs) Reported EPS (Rs) Reported cash EPS (Rs) Dividend per share Operating profit per share (Rs) Book value (excl rev res) per share (Rs) Book value (incl rev res) per share (Rs.) Net operating income per share (Rs) Free reserves per share (Rs) -0.64 -0.07 -0.85 -0.28 1.04 2.8 1.67 2.01 1.65 1.99 -0.32 0.52 1.1 0.61 1.19 -0.17 1.01 1.58 1.01 1.58 -1.76 1.17 2.03 1.17 2.03
-2.64
6.77
1.95
1.53
0.32
-2.64
6.77
1.95
1.53
0.32
4.2 1.5
3.15 2.29
0.01 0.74 0.32
-0.1
Profitability ratios
Operating margin (%) Gross profit margin (%) Net profit margin (%) Adjusted cash margin (%) Adjusted return on net worth (%) 24.8 11.17 -19.06 -1.68 88.91 78.08 63.91 74.02 -3,265.38 -8,921.24 55.69 76.97 -9,677.53 -41,328.95 61.41 88.77 25.93 45.18
-4.72
47.92
27.18
66.09
359.25
Reported return on net worth (%) Return on long term funds (%)
-6.24 2.46
47.31 10.41
31.78 6.33
66.09 7.95
359.25 11.28
Leverage ratios
Long term debt / Equity Total debt/equity Owners fund as % of total source Fixed assets turnover ratio 1.26 1.27 6.96 8.3 9.95 10.32 10.07 10.07 37.39 37.39
44.06 0.13
10.75 0.19 -
8.83 -
9.03 -
2.6
Liquidity ratios
Current ratio Current ratio (inc. st loans) Quick ratio Inventory turnover ratio 2.76 2.16 2.72 97.26 11.58 1.52 11.17 0.1 9.85 3.66 5.66 2.22 2.22 0.17 0.29 0.29 0.17
Payout ratios
Dividend payout ratio (net profit) 6.58 17.57 3.85 -
Dividend payout ratio (cash profit) Earning retention ratio Cash earnings retention ratio -
5.45 93.5 94.6
9.14 79.46 90.12
2.45 96.15 97.55 100 100
Coverage ratios
Adjusted cash flow time total debt 7.89 6.96 3.97 7.96
Financial charges coverage ratio Fin. charges cov.ratio (post tax)
0.94
15.54
22.65
35.35
3.86
0.79
13.64
22.57
35.28
3.86
Component ratios
Material cost component (% earnings) Selling cost Component 4.07 1.25 178.7 2,361.88 -
Exports as percent of total sales Import comp. in raw mat. consumed Long term assets / total Assets
-
-
-
-
-
-
-
-
0.88
0.51
0.62
0.83
0.96
Adjusted EPS (Rs)
2 1.5 1 0.5 0 -0.5 -1 1 2 3 4 5 Adjusted EPS (Rs)
Operating profit per share (Rs)
4 3 2 1 0 -1 -2 1 2 3 4 5 Operating profit per share (Rs)
Net profit margin (%)
80 60 40 20 0 -20 -40 1 2 3 4 5 Net profit margin (%)
Total debt/equity
40 30 20 10 0 1 2 3 4 5 Total debt/equity
0 1 2 3 4 5
Current ratio
14 12 10 8 6 4 2 0 1 2 3 4 5 Current ratio
Quick ratio
12 10 8 6 4 2 0 1 2 3 4 5 Quick ratio
Earning retention ratio 120 100 80 60 40 20 0 1 2 3 4 Earning retention ratio -
Financial charges coverage ratio
40
Financial charges coverage ratio
40 30 20 10 0 1 2 3 4 5 Financial charges coverage ratio
Cash flow Statement
Profit before tax Net cashflowoperating activity Net cash used in investing activity Netcash used in fin. activity Net inc/dec in cash and equivlnt Cash and equivalnt begin of year Cash and equivalnt end of year Mar ' 09 -1.06 7.55 -15.53 -2.37 -10.34 11.1 0.76 Mar ' 08 3.33 -0.59 -3.79 9.87 5.48 5.62 11.1 Mar ' 07 1.57 0.35 0.34 4.93 5.61 0.01 5.62 0.01 Mar ' 06 1.61 6.62 -4.84 -1.77 0.01 Mar ' 05 -1.35 0.3 -0.03 -0.35 -0.08 0.02 -0.06
doc_631466006.xlsx
This is a spreadsheet about financial analysis of Vedanta India Limited.
VEDANTA INDIA LIMITED Balance sheet
Mar ' 09 Mar ' 08 Mar ' 07 Mar ' 06
Sources of funds
Owner's fund Equity share capital Share application money Preference share capital Reserves & surplus 1.25 1.25 1.25 1.25
10 15.88 10 3.11
10 1.18
10 0.66
Loan funds
Secured loans Unsecured loans Total 11.25 0.49 38.88 16.89 9.3 40.55 5.91 9.22 27.56 9.22 21.12
Uses of funds
Fixed assets Gross block Less : revaluation reserve Less : accumulated depreciation Net block Capital work-inprogress Investments 38.64 20.72 20.81 20.81
-
-
-
5.43 33.21
7.73 12.99 3.94 4.98
7.35 13.46 0.12 4.45
6.64 14.17 0.01 4.86
2.83
Net current assets
Current assets, loans & advances Less : current liabilities & provisions Total net current assets 4.46 20.39 10.61 3.79
1.62 2.84
1.76 18.63
1.08 9.53
1.71 2.08
Miscellaneous expenses not written Total
38.88
40.55
27.56
21.12
Notes:
Book value of unquoted investments Market value of quoted investments Contingent liabilities Number of equity sharesoutstanding (Lacs) 0.03
0.04 -
4.27 -
4.38 -
2.48
125
125
125
125
Mar ' 05
8.31
-7.95
1 12.46 13.82
20.8
-
5.92 14.88 0.03
0.49
1.67 -1.18
0.09 13.82
-
-
83.1
Profit loss account
Mar ' 09 Mar ' 08 Mar ' 07 Mar ' 06 Mar ' 05
Income
Operating income 5.25 3.94 0.01 -
Expenses
Material consumed Manufacturing expenses Personnel expenses 0.26 0.92 0.21 2.56 3.95 1.3 0.44 3.5 0.05 0.05 0.34 0.42 -0.41 0.01 0.02 0.39 0.22 -0.22 0.01 0.05 0.15 1.46 -1.46 1.45 0.01
Selling expenses Adminstrative expenses Expenses capitalised Cost of sales Operating profit Other recurring income Adjusted PBDIT Financial expenses Depreciation Other write offs Adjusted PBT Tax charges Adjusted PAT Non recurring items Other non cash adjustments Reported net profit Earnigs before appropriation
0.37 1.67 1.76 0.72 -0.8 0.01 -0.81 -0.26
0.54 4.05 0.26 0.43 3.36 0.47 2.89 -0.03 -
2.81 2.4 0.11 0.71 1.58 0.12 1.46 -
2.62 2.4 0.07 0.72 1.61 1.61 -
3.74 2.28 0.59 0.72
0.97 0.97
-1.07 -1.07
0.01 2.86 2.86 1.46 1.46
1.61 1.61
0.97 0.97
Equity dividend Preference dividend Dividend tax Retained earnings
-1.07
0.8 0.14 1.93
0.8 0.14 0.53
-
0.35 0.05 1.21 0.97
Ratio Analysis
Mar ' 09 Mar ' 08 Mar ' 07 Mar ' 06 Mar ' 05
Per share ratios
Adjusted EPS (Rs) Adjusted cash EPS (Rs) Reported EPS (Rs) Reported cash EPS (Rs) Dividend per share Operating profit per share (Rs) Book value (excl rev res) per share (Rs) Book value (incl rev res) per share (Rs.) Net operating income per share (Rs) Free reserves per share (Rs) -0.64 -0.07 -0.85 -0.28 1.04 2.8 1.67 2.01 1.65 1.99 -0.32 0.52 1.1 0.61 1.19 -0.17 1.01 1.58 1.01 1.58 -1.76 1.17 2.03 1.17 2.03
-2.64
6.77
1.95
1.53
0.32
-2.64
6.77
1.95
1.53
0.32
4.2 1.5
3.15 2.29
0.01 0.74 0.32
-0.1
Profitability ratios
Operating margin (%) Gross profit margin (%) Net profit margin (%) Adjusted cash margin (%) Adjusted return on net worth (%) 24.8 11.17 -19.06 -1.68 88.91 78.08 63.91 74.02 -3,265.38 -8,921.24 55.69 76.97 -9,677.53 -41,328.95 61.41 88.77 25.93 45.18
-4.72
47.92
27.18
66.09
359.25
Reported return on net worth (%) Return on long term funds (%)
-6.24 2.46
47.31 10.41
31.78 6.33
66.09 7.95
359.25 11.28
Leverage ratios
Long term debt / Equity Total debt/equity Owners fund as % of total source Fixed assets turnover ratio 1.26 1.27 6.96 8.3 9.95 10.32 10.07 10.07 37.39 37.39
44.06 0.13
10.75 0.19 -
8.83 -
9.03 -
2.6
Liquidity ratios
Current ratio Current ratio (inc. st loans) Quick ratio Inventory turnover ratio 2.76 2.16 2.72 97.26 11.58 1.52 11.17 0.1 9.85 3.66 5.66 2.22 2.22 0.17 0.29 0.29 0.17
Payout ratios
Dividend payout ratio (net profit) 6.58 17.57 3.85 -
Dividend payout ratio (cash profit) Earning retention ratio Cash earnings retention ratio -
5.45 93.5 94.6
9.14 79.46 90.12
2.45 96.15 97.55 100 100
Coverage ratios
Adjusted cash flow time total debt 7.89 6.96 3.97 7.96
Financial charges coverage ratio Fin. charges cov.ratio (post tax)
0.94
15.54
22.65
35.35
3.86
0.79
13.64
22.57
35.28
3.86
Component ratios
Material cost component (% earnings) Selling cost Component 4.07 1.25 178.7 2,361.88 -
Exports as percent of total sales Import comp. in raw mat. consumed Long term assets / total Assets
-
-
-
-
-
-
-
-
0.88
0.51
0.62
0.83
0.96
Adjusted EPS (Rs)
2 1.5 1 0.5 0 -0.5 -1 1 2 3 4 5 Adjusted EPS (Rs)
Operating profit per share (Rs)
4 3 2 1 0 -1 -2 1 2 3 4 5 Operating profit per share (Rs)
Net profit margin (%)
80 60 40 20 0 -20 -40 1 2 3 4 5 Net profit margin (%)
Total debt/equity
40 30 20 10 0 1 2 3 4 5 Total debt/equity
0 1 2 3 4 5
Current ratio
14 12 10 8 6 4 2 0 1 2 3 4 5 Current ratio
Quick ratio
12 10 8 6 4 2 0 1 2 3 4 5 Quick ratio
Earning retention ratio 120 100 80 60 40 20 0 1 2 3 4 Earning retention ratio -
Financial charges coverage ratio
40
Financial charges coverage ratio
40 30 20 10 0 1 2 3 4 5 Financial charges coverage ratio
Cash flow Statement
Profit before tax Net cashflowoperating activity Net cash used in investing activity Netcash used in fin. activity Net inc/dec in cash and equivlnt Cash and equivalnt begin of year Cash and equivalnt end of year Mar ' 09 -1.06 7.55 -15.53 -2.37 -10.34 11.1 0.76 Mar ' 08 3.33 -0.59 -3.79 9.87 5.48 5.62 11.1 Mar ' 07 1.57 0.35 0.34 4.93 5.61 0.01 5.62 0.01 Mar ' 06 1.61 6.62 -4.84 -1.77 0.01 Mar ' 05 -1.35 0.3 -0.03 -0.35 -0.08 0.02 -0.06
doc_631466006.xlsx