Analysis Of 2005.08 Hcl Tech

  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Analysis Of 2005.08 Hcl Tech as PDF for free.

More details

  • Words: 1,816
  • Pages: 11
BALANCE SHEET Jun '04 Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth(A) Secured Loans Unsecured Loans Total Debt(B) Total Liabilities(A+B)

%jun 04 Jun '05

59.22 59.22 0.03 0 2,231.96 0 2,291.21 97.9 0.33 98.23 2,389.44

2.48 63.84 2.48 63.84 0 1.64 0 0 93.41 2,796.14 0 0 95.89 2,861.62 4.1 96.42 0.01 0.27 4.11 96.69 100 2,958.31

Application Of Funds Gross Block 412.32 Less: Accum. Depreciation 207.04 Net Block 205.28 Capital Work in Progress 118.63 Investments 2,250.36 TOTAL(A) 2,574.27 Inventories 0 Sundry Debtors 168.59 Cash and Bank Balance 61.24 Total Current Assets 229.83 Loans and Advances 154.36 Fixed Deposits 11.54 Total CA, Loans & Advances(B)395.73 Deffered Credit 0 Current Liabilities 426.29 Provisions 154.27 Total CL & Provisions 580.56 Net Current Assets -184.83 Miscellaneous Expenses 0 Total Assets 2,389.44

17.26 632.06 8.66 272.11 8.59 359.95 4.96 71.78 94.18 2,654.66 107.74 3,086.39 0 0 7.06 306.41 2.56 81.14 9.62 387.55 6.46 166.02 0.48 3.39 16.56 556.96 0 73.43 511.11 26.57 173.93 100 685.04 -128.08 0 100.00 2,958.31

%jun 05 Jun '06

2.16 64.69 2.16 64.69 0.06 1.33 0 0 94.52 2,511.18 0 0 96.73 2,577.20 3.26 13.17 0.01 0.21 3.27 13.38 100 2,590.58

%jun 06

2.5 2.5 0.05 0 96.94 0 99.48 0.51 0.01 0.52 100

123.66 1,014.08 108.46 156.45 488.4 244.10 52.54 525.68 46.31 -56.04 163.63 -2,521.26 0.00 1,907.76 0.00 104.33 2,597.07 100.25 0 59.95 645.98 69.09 46.65 104.51 52.23 56.57 750.49 66.12 -129.62 376.41 -5,799.85 0 1.71 0.00 18.83 1,128.61 43.57 0 293.86 935.02 467.32 25.39 200.08 17.63 100 1,135.10 100.00 -6.49 0 100.00 2,590.58 100.00

BALANCE SHEET OF VERTICAL METHOD Jun '07

%jun 07 Jun '08

%jun 08

132.74 132.74 0 0 3,292.28 0 3,425.02 40.77 0.12 40.89 3,465.91

3.83 133.27 3.83 133.27 0 1.71 0 0 94.99 3,079.85 0 0 98.82 3,214.83 1.18 25.24 0 0.09 1.18 25.33 100 3,240.16

4.11 4.11 0.05 0 95.05 0 99.22 0.78 0 0.78 100

1,332.67 662.58 670.09 212.86 1,988.86 2,871.81 0 712.48 105.93 818.41 934.44 275.01 2,027.86 0 1,003.02 430.74 1,433.76 594.1 0 3,465.91

132.87 1,599.61 153.82 874.32 46.74 725.29 35.83 419.03 0.00 1,797.34 82.86 2,941.66 0 71.03 980.02 24.59 162.87 57.08 1,142.89 157.29 1,183.99 0.00 524.01 58.51 2,850.89 0 232.86 1,828.85 30.04 723.54 100.00 2,552.39 298.5 0 100.00 3,240.16

87.47 120.84 28.42 140.38 0 90.79 53.59 22.51 44.78 396.65 0.00 87.99 252.76 28.35 100.00

100.00

BALANCE SHEET OF HORIZONTAL METHOD Jun '04 Jun '05

Jun '06

Jun '07

Jun '08

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

59.22 63.84 64.69 132.74 133.27 59.22 63.84 64.69 132.74 133.27 0.03 1.64 1.33 0 1.71 0 0 0 0 0 2,231.96 2,796.14 2,511.18 3,292.28 3,079.85 0 0 0 0 0 2,291.21 2,861.62 2,577.20 3,425.02 3,214.83 97.9 96.42 13.17 40.77 25.24 0.33 0.27 0.21 0.12 0.09 98.23 96.69 13.38 40.89 25.33 2,389.44 2,958.31 2,590.58 3,465.91 3,240.16

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

412.32 632.06 1,014.08 1,332.67 1,599.61 207.04 272.11 488.4 662.58 874.32 205.28 359.95 525.68 670.09 725.29 118.63 71.78 163.63 212.86 419.03 2,250.36 2,654.66 1,907.76 1,988.86 1,797.34 0 0 0 0 0 168.59 306.41 645.98 712.48 980.02 61.24 81.14 104.51 105.93 162.87 229.83 387.55 750.49 818.41 1,142.89 154.36 166.02 376.41 934.44 1,183.99 11.54 3.39 1.71 275.01 524.01 395.73 556.96 1,128.61 2,027.86 2,850.89 0 0 0 0 0 426.29 511.11 935.02 1,003.02 1,828.85 154.27 173.93 200.08 430.74 723.54 580.56 685.04 1,135.10 1,433.76 2,552.39 -184.83 -128.08 -6.49 594.1 298.5 0 0 0 0 0 2,389.44 2,958.31 2,590.58 3,465.91 3,240.16

2004-05 2005-06 2006-07 2007-08 % 2004-05 %2005-06 %2006-07%2007-08

0.53 -132.74 -133.27 0.53 -132.74 -133.27 1.71 0 -1.71 0 0 0 -212.43 -3292.28 -3079.85 0 0 0 -210.19 -3,425.02 -3214.83 -15.53 -40.77 -25.24 -0.03 -0.12 -0.09 -15.56 -40.89 -25.33 -225.75 -3,465.91 -3240.16

-0.53 -0.53 -1.71 0 212.43 0 210.19 15.53 0.03 15.56 225.75

266.94 -1,332.67 -1,599.61 -266.94 211.74 -662.58 -874.32 -211.74 55.2 -670.09 -725.29 -55.20 206.17 -212.86 -419.03 -206.17 -191.52 -1,988.86 -1,797.34 191.52 0 0.00 0.00 267.54 -712.48 -980.02 -267.54 56.94 -105.93 -162.87 -56.94 324.48 -818.41 -1,142.89 -324.48 249.55 -934.44 -1,183.99 -249.55 249 -275.01 -524.01 -249 823.03 -2,027.86 -2,850.89 -823.03 0 0.00 0.00 0.00 825.83 -1,003.02 -1,828.85 -825.83 292.8 -430.74 -723.54 -292.80 1118.63 -1,433.76 -2,552.39 -1,118.63 -295.6 -594.1 -298.5 295.60 0 0.00 -225.75 -3,465.91 -3,240.16 225.75

0.4 0.4 0

-0.3 -0.3 0

56.53 56.53 0

14157.67 14157.67

-6.45

0.21

0.1

-1.53

-6.14 0.19 -38.09 150.92 -25 27777.78 -38.05 150.23 -6.51 0.2

0.09 -1.48971.78 370370370. -2551.17 ### 37 965.49 -2537.2 0.09 -1.37

20.03 31.96 8.24 96.86 -9.63

-1.25 -3.66 -1.14 -23.11 0.54

0.47 1.73 2.06 11.21 0.28

2.34 5.4 24.98 11.58 -2.91

37.55 53.75 39.65 26.71 90.54 40.59

-3.83 -33 -3.47 -2.26 -17.28 -1.42

1.43 57.96 1.07 0.9 6.94 0.17

3.81 107.83 2.7 3.38 7.66 0.43

82.33 67.98 78.02 -49.76

-4.5 -9.39 -3.06 16.67

0.55 3.21 0.27 5.64

0.66 4.72 0.35 -11.33

-6.51

0.2

0.09

-1.37

------------------- in Rs. Cr. -------------------

Profit & Loss account HORIZAN

Jun '04

Jun '08

Income Sales Turnover 1,127.98 Excise Duty 0 Net Sales 1,127.98 Other Income 126.21 Stock Adjustments 0 Total Income 1,254.19 Expenditure Raw Materials 0 Power & Fuel Cost 0 Employee Cost 362.39 Other Manufacturing Expenses249.77 Selling and Admin Expenses 186.74 Miscellaneous Expenses 44.15 Preoperative Exp Capitalised 0 Total Expenses 843.05 Operating Profit 284.93 PBDIT Interest PBDT Depreciation Other Written Off Profit Before Tax Extra-ordinary items PBT (Post Extra-ord Items) Tax Reported Net Profit

411.14 12.22 398.92 56.89 2.5 339.53 0 339.53 13.81 325.72

Jun '05

Jun '06

Jun '07

1,447.01 3,032.92 3,768.62 0 0 0 1,447.01 3,032.92 3,768.62 61.54 0.68 439.42 0 0 0 1,508.55 3,033.60 4,208.04

4,615.39 0 4,615.39 -108.91 0 4,506.48

0 0 0 0 0 0 488.54 1,123.51 1,322.59 304.93 476.97 577.24 216.75 412.73 617.2 80.26 209.95 314.51 0 0 0 1,090.48 2,223.16 2,831.54 356.53 809.76 937.08

0 0 1,621.35 746.92 639.05 381.11 0 3,388.43 1,226.96

418.07 11.58 406.49 67.56 0 338.93 2.49 341.42 12.15 329.27

810.44 17.81 792.63 138.8 0 653.83 0 653.83 15.45 638.38

1,376.50 20.6 1,355.90 178.21 0 1,177.69 0 1,177.69 75.87 1,101.82

1,118.05 24.93 1,093.12 217.87 0 875.25 0 875.25 94.6 780.65

ofit & Loss account HORIZANTAL 2004-05 846.77 0.00 846.77 -548.33 0.00 298.44 0.00 0.00 0.00 298.76 169.68 21.85 66.60 0.00 556.89 71.6 -258.45 4.33 -262.78 39.66 0 -302.44 0 -302.44 18.73 -321.17

% 2004-052005-06 % 2005-062006-07 %2006-072007-08 %2007-08 22.47 1,585.91 0.00 22.47 1,585.91 -124.78 -60.86 0.00 7.09 1,525.05 0.00 0.00 0.00 22.59 634.97 29.4 172.04 3.54 195.98 21.18 129.69 0.00 19.67 1,132.68 7.64 453.23 0.00 -18.78 392.37 21.02 6.23 -19.38 386.14 22.25 71.24 0 0.00 -25.68 314.90 -2.49 -25.68 312.41 24.69 3.30 -29.15 309.11

109.6 735.70 24.26 0 0.00 0 109.6 735.70 24.26 -98.9 438.74 64520.59 0 0.00 0 101.09 1,174.44 38.71 0 0.00 0 0 0.00 0 0 0.00 0 129.97 199.08 17.72 56.42 100.27 21.02 90.42 204.47 49.54 161.59 104.56 49.8 0 0.00 0 103.87 608.38 27.37 127.12 127.32 15.72 0 0.00 0 93.85 566.06 69.85 53.8 2.79 15.67 94.99 563.27 71.06 105.45 39.41 28.39 0 0.00 0 92.91 523.86 80.12 -100 0.00 0 91.5 523.86 80.12 27.16 60.42 391.07 93.88 463.44 72.6

846.77 0.00 846.77 -548.33 0.00 298.44 0.00 0.00 0.00 298.76 169.68 21.85 66.60 0.00 556.89 289.88 0.00 -258.45 4.33 -262.78 39.66 0.00 -302.44 0.00 -302.44 18.73 -321.17

22.47 0 22.47 -124.78 0 7.09 0 0 0 22.59 29.4 3.54 21.18 0 19.67 30.93 0 -18.78 21.02 -19.38 22.25 0 -25.68 0 -25.68 24.69 -29.15

%2007-08

PROFIT AND LOSS VERTICAL ME Jun '04 Income Sales Turnover 1,127.98 Excise Duty 0 Net Sales 1,127.98 Other Income 126.21 Stock Adjustments 0 Total Income 1,254.19 Expenditure Raw Materials 0 Power & Fuel Cost 0 Employee Cost 362.39 Other Manufacturing Expenses249.77 Selling and Admin Expenses 186.74 Miscellaneous Expenses 44.15 Preoperative Exp Capitalised 0 Total Expenses 843.05 Jun '04 Operating Profit 284.93 PBDIT 411.14 Interest 12.22 PBDT 398.92 Depreciation 56.89 Other Written Off 2.5 Profit Before Tax 339.53 Extra-ordinary items 0 PBT (Post Extra-ord Items) 339.53 Tax 13.81 Reported Net Profit 325.72 Total Value Addition 843.05 Preference Dividend 0 Equity Dividend 295.85 Corporate Dividend Tax 38.21 Per share data (annualised) Shares in issue (lakhs) 2,960.80 Earning Per Share (Rs) 11 Equity Dividend (%) 500 Book Value (Rs) 77.38

Jun '05 100.00 0.00 100.00 11.19 0.00 111.19 0.00 0.00 0.00 32.13 22.14 16.56 3.91 0.00 74.74

1,447.01 0 1,447.01 61.54 0 1,508.55

0 0 488.54 304.93 216.75 80.26 0 1,090.48 Jun '05 25.26 356.53 36.45 418.07 1.08 11.58 35.37 406.49 5.04 67.56 0.22 0 30.10 338.93 0.00 2.49 30.10 341.42 1.22 12.15 28.88 329.27 74.74 1,090.48 0.00 0 26.23 501.75 3.39 68.17 0.00 262.49 3,192.15 0.98 10.31 44.33 800 6.86 89.59

Jun '06 100.00 0.00 100.00 4.25 0.00 104.25 0.00 0.00 0.00 33.76 21.07 14.98 5.55 0.00 75.36

3,032.92 0 3,032.92 0.68 0 3,033.60

0 0 1,123.51 476.97 412.73 209.95 0 2,223.16 Jun '06 24.64 809.76 28.89 810.44 0.80 17.81 28.09 792.63 4.67 138.8 0.00 0 23.42 653.83 0.17 0 23.59 653.83 0.84 15.45 22.76 638.38 75.36 2,223.16 0.00 0 34.67 516.1 4.71 72.38 0.00 220.60 3,234.42 0.71 19.74 55.29 800 6.19 79.64

100.00 0.00 100.00 0.02 0.00 100.02 0.00 0.00 0.00 37.04 15.73 13.61 6.92 0.00 73.30 26.70 26.72 0.59 26.13 4.58 0.00 21.56 0.00 21.56 0.51 21.05 73.30 0.00 17.02 2.39 0.00 106.64 0.65 26.38 2.63

ND LOSS VERTICAL METHOD Jun '07 3,768.62 0 3,768.62 439.42 0 4,208.04 0 0 1,322.59 577.24 617.2 314.51 0 2,831.54 Jun '07 937.08 1,376.50 20.6 1,355.90 178.21 0 1,177.69 0 1,177.69 75.87 1,101.82 2,831.54 0 525.59 81.6 6,636.83 16.6 400 51.61

Jun '08 100.00 0.00 100.00 11.66 0.00 111.66 0.00 0.00 0.00 35.09 15.32 16.38 8.35 0.00 75.13

4,615.39 0 4,615.39 -108.91

0 4,506.48

0 0 1,621.35 746.92 639.05 381.11 0 3,388.43 Jun '08 24.87 1,226.96 36.53 1,118.05 0.55 24.93 35.98 1,093.12 4.73 217.87 0.00 0 31.25 875.25 0.00 0 31.25 875.25 2.01 94.6 29.24 780.65 75.13 3,388.43 0.00 0 13.95 598.58 2.17 101.72 0.00 176.11 6,663.40 0.44 11.72 10.61 450 1.37 48.22

100 0 100 -2.36 0 97.64 0 0 0 35.13 16.18 13.85 8.26 0 73.42 26.58 24.22 0.54 23.68 4.72 0 18.96 0 18.96 2.05 16.91 73.42 0 12.97 2.2 0 144.37 0.25 9.75 1.04

TREND PERCENTAGE sales rs

cgs rs

%

gross profit rs %

%

year 2004 2005 2006 2007 2008

1,127.98 1,447.01 3,032.92 3,768.62 4,615.39

100 128.28 268.88 334.1 409.17

0 0 0 0 0

0 0 0 0 0

406.49 792.63 1,355.90 1,093.12 1,445.81

100 194.99 333.56 268.92 355.68

ENTAGE operating expenses rs % 843.05 1,090.48 2,223.16 2,831.54 3,388.43

100 129.35 263.7 335.87 401.93

operating profit rs % 284.93 356.53 809.76 937.08 1,226.96

100 125.13 284.2 328.88 430.62

Related Documents

200508
May 2020 12
Hcl
June 2020 20
Hcl
June 2020 18
Hcl
June 2020 18