comparative & common size income & balance sheet

19
Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities Application Of Funds Gross Block Less: Accum. Depreciation Net Block Capital Work in Progress Investments Inventories Sundry Debtors Cash and Bank Balance Total Current Assets Loans and Advances Fixed Deposits Total CA, Loans & Advances Deffered Credit Current Liabilities Provisions Total CL & Provisions Net Current Assets Miscellaneous Expenses Total Assets

Upload: anil-kumar

Post on 08-Dec-2015

13 views

Category:

Documents


2 download

DESCRIPTION

comparison between TATA STEEL & SAIL

TRANSCRIPT

Page 1: Comparative & Common Size Income & Balance Sheet

Balance Sheet

Tata Steel Mar' 2014

Sources Of Funds

Total Share Capital 971.41

Equity Share Capital 971.41

Share Application Money 0

Preference Share Capital 0

Reserves 60,176.58

Revaluation Reserves 0

Networth 61,147.99

Secured Loans 4,400.55

Unsecured Loans 21,726.23

Total Debt 26,126.78

Total Liabilities 87,274.77

Application Of Funds

Gross Block 39,019.72

Less: Accum. Depreciation 14,753.97

Net Block 24,265.75

Capital Work in Progress 18,509.40

Investments 54,661.80

Inventories 6,007.81

Sundry Debtors 770.81

Cash and Bank Balance 961.16

Total Current Assets 7,739.78

Loans and Advances 5,863.68

Fixed Deposits 0

Total CA, Loans & Advances 13,603.46

Deffered Credit 0

Current Liabilities 19,957.78

Provisions 3,807.86

Total CL & Provisions 23,765.64

Net Current Assets -10,162.18

Miscellaneous Expenses 0

Total Assets 87,274.77

Page 2: Comparative & Common Size Income & Balance Sheet

Balance Sheet

SAIL(Steel Authority Of India) % Change Tata Steel

4,130.53 1.113047906055784,130.53 1.11304790605578

0 00 0

38,535.82 68.95071737227150 0

42,666.35 70.0637652783273

11,560.895.04217885650114

12,705.81 24.894055865171624,266.70 29.936234721672766,933.05 100

53,874.36 44.709049362146727,103.71 16.90519493778126,770.65 27.803854424365733,650.54 21.2081910957772

720.2 62.631846523342315,200.82 6.883787834674335,481.98 0.8831991192872812,855.95 1.10130338928421

23,538.75 8.868290343245827,281.75 6.71864274176833

0 030,820.50 15.5869330850141

0 019,105.61 22.86775433495845,923.23 4.36307079354091

25,028.84 27.23082512849935,791.66 -11.6438920434852

0 066,933.05 100

Page 3: Comparative & Common Size Income & Balance Sheet

Balance Sheet

% Change SAIL

6.171136680608466.17113668060846

00

57.57367996826680

63.7448166488752

17.27231913083318.982864220291836.2551833511247

100

80.489922392599840.493762050287639.996160342312250.27492397253671.0760005707195522.71048458123458.190243833203484.2668756316946635.167604046132710.8791546179354

046.0467586640681

028.54435887801328.8494846716233637.39384354963658.65291511443151

0100

Page 4: Comparative & Common Size Income & Balance Sheet

Mar '14

Sources Of FundsTotal Share Capital 971.41Equity Share Capital 971.41Share Application Money 0Preference Share Capital 0Reserves 60,176.58Revaluation Reserves 0

Networth 61,147.99Secured Loans 4,400.55Unsecured Loans 21,726.23

Total Debt 26,126.78

Total Liabilities 87,274.77

Application Of FundsGross Block 39,019.72Less: Accum. Depreciation 14,753.97

Net Block 24,265.75Capital Work in Progress 18,509.40

Investments 54,661.80Inventories 6,007.81Sundry Debtors 770.81Cash and Bank Balance 961.16Total Current Assets 7,739.78Loans and Advances 5,863.68Fixed Deposits 0Total CA, Loans & Advances 13,603.46Deffered Credit 0Current Liabilities 19,957.78Provisions 3,807.86Total CL & Provisions 23,765.64

Net Current Assets -10,162.18Miscellaneous Expenses 0

Total Assets 87,274.77

Comparative Balance Sheet

Page 5: Comparative & Common Size Income & Balance Sheet

Mar '13Absolute Change % change

971.41 0 0971.41 0 0

0 0 00 0 0

54,238.27 5938.31000000001 10.94856085933420 0 0

55,209.68 5938.31 10.75592178762854,311.02 89.5299999999998 2.07677069463839

21,600.49 125.739999999998 0.582116424210738

25,911.51 215.27 0.830789097200435

81,121.19 6,153.58 7.58566288290396

38,056.28 963.44 2.5316189601295813,181.23 1,572.74 11.9316634335339

24,875.05 -609.30 -2.449442312678778,722.29 9,787.11 112.208032523569

50,418.80 4,243.00 8.415511674216765,257.94 749.87 14.2616690186651

796.92 -26.11 -3.276364001405412,218.11 -1,256.95 -56.66761341863128,272.97 -533.19 -6.444964746638759,587.82 -3,724.14 -38.8424063029969

0 0.00 017,860.79 -4,257.33 -23.8361796986584

0 0.00 017,098.06 2,859.72 16.7254062741621

3,657.68 150.18 4.1058813236805920,755.74 3,009.90 14.501530660916

-2,894.95 -7,267.23 251.0312786058480 0.00 0

81,121.19 6,153.58 7.58566288290396

Comparative Balance Sheet

Page 6: Comparative & Common Size Income & Balance Sheet

IncomeSales Turnover

Excise Duty

Net Sales

Other Income

Stock Adjustments

Total Income

Expenditure

Raw Materials

Power & Fuel Cost

Employee Cost

Other Manufacturing Expenses

Selling and Admin Expenses

Miscellaneous Expenses

Preoperative Exp Capitalised

Total Expenses

Operating ProfitPBDIT

Interest

PBDT

Depreciation

Other Written Off

Profit Before Tax

Extra-ordinary items

PBT (Post Extra-ord Items)

Tax

Reported Net ProfitTotal Value Addition

Comparative Income Statement

Page 7: Comparative & Common Size Income & Balance Sheet

Preference Dividend

Equity Dividend

Corporate Dividend Tax

Per share data (annualised)

Shares in issue (lakhs)

Earning Per Share (Rs)

Equity Dividend (%)

Book Value (Rs)

Page 8: Comparative & Common Size Income & Balance Sheet

Mar '14 Mar '13 Absolute changeIncome

41,711.03 38,199.43 3,511.60

0 0 0.0041,711.03 38,199.43 3,511.60

645.88 227.51 418.37

155.18 404.6 -249.42

42,512.09 38,831.54 3,680.55

Expenditure

12,641.57 12,421.63 219.94

2,772.31 2,510.17 262.14

3,673.08 3,608.52 64.56

0 0 0.00

0 0 0.00

9,962.35 8,937.47 1,024.88

0 0 0.00

29,049.31 27,477.79 1,571.52

12,816.90 11,126.24 1,690.6613,462.78 11,353.75 2,109.031,820.58 1,876.77 -56.19

11,642.20 9,476.98 2,165.221,928.70 1,640.38 288.32

0 0 0.00

9,713.50 7,836.60 1,876.90

0 0 0.00

9,713.50 7,836.60 1,876.903,301.31 2,773.63 527.68

6,412.19 5,062.97 1,349.2216,407.74 15,056.16 1,351.58

Comparative Income Statement

Page 9: Comparative & Common Size Income & Balance Sheet

0 0 0.00

971.21 776.97 194.24

66.19 128.73 -62.54Per share data (annualised)

9,712.15 9,712.15 0.00

66.02 52.13 13.89

100 80 20.00

629.6 568.46 61.14

Page 10: Comparative & Common Size Income & Balance Sheet

% change

8.418876254074760

8.41887625407476

64.7751904378522

-160.729475447867

8.65765479890543

1.73981554506284

9.45565250639358

1.75765297788232

0

0

10.2875325600887

0

5.4098358962743

13.190865185809415.6656351808468

-3.0863790660119318.598031299926114.9489293306372

0

19.3225922684923

0

19.322592268492315.9839578833857

21.04148504645068.23745378705417

Page 11: Comparative & Common Size Income & Balance Sheet

019.9997940713131

-94.4855718386463

0

21.0390790669494

20

9.71092757306226

Page 12: Comparative & Common Size Income & Balance Sheet

Profit & Loss account

Tata Steel Mar'14

Income

Sales Turnover 41,711.03

Excise Duty 0

Net Sales 41,711.03

Other Income 645.88

Stock Adjustments 155.18

Total Income 42,512.09

Expenditure

Raw Materials 12,641.57

Power & Fuel Cost 2,772.31

Employee Cost 3,673.08

Other Manufacturing Expenses 0

Selling and Admin Expenses 0

Miscellaneous Expenses 9,962.35

Preoperative Exp Capitalised 0

Total Expenses 29,049.31

Operating Profit 12,816.90

PBDIT 13,462.78

Interest 1,820.58

PBDT 11,642.20

Depreciation 1,928.70

Other Written Off 0

Profit Before Tax 9,713.50

Extra-ordinary items 0

PBT (Post Extra-ord Items) 9,713.50

Tax 3,301.31

Reported Net Profit 6,412.19

Total Value Addition 16,407.74

Preference Dividend 0

Equity Dividend 971.21

Corporate Dividend Tax 66.19

Per share data (annualised)

Shares in issue (lakhs) 9,712.15

Earning Per Share (Rs) 66.02

Equity Dividend (%) 100

Book Value (Rs) 629.6

Page 13: Comparative & Common Size Income & Balance Sheet

Profit & Loss account

SAIL Mar'14% Change TATA STEEL % Change SAIL

46,698.41 100 1000 0 0

46,698.41 100 1001,840.53 1.54846332013379 3.9413119204701-894.63 0.37203588595151 -1.91576115760687

47,644.31 101.920499206085 102.025550762863

21,611.97 30.3074989996651 46.2798840474444,942.15 6.64646737325834 10.5831226373669,578.51 8.80601605858211 20.5114264061667

0 0 00 0 0

5,752.88 23.8842100039246 12.31922029036960 0 0

41,885.51 69.6441924354302 89.6936533813464

3,918.27 30.7278434505214 8.390585461046755,758.80 32.2763067706552 12.3318973815168

967.64 4.3647447689496 2.072104810420744,791.16 27.9115620017055 10.25979257109611,716.69 4.62395678073641 3.67612087863377

0 0 03,074.47 23.2876052209691 6.58367169246233

150.08 0 0.3213813917861443,224.55 23.2876052209691 6.90505308424848

608.07 7.91471704247054 1.302121421264662,616.48 15.3728881784986 5.60293166298381

20,273.54 39.3366934357651 43.41376933390240 0 0

834.35 2.32842487946234 1.78667753356056141.67 0.158687042731863 0.303372213315186

41,305.25 23.2843686669929 88.45108430886626.33 0.158279476675594 0.013555065365180520.2 0.239744738981512 0.0432562907388067

103.3 1.5094328766276 0.221206674916769