final project of analysis

8/14/2019 Final Project of Analysis

1/40

(Million R

2001 2002 2003 2004 2005

1.Gross sales 33237.70 36841.30 38320.10 45537.30 58628.70

2.Cost of Sales 31091.60 32399.10 35707.10 36895.00 46063.603.Gross profit 2146.10 4442.20 2612.90 8642.30 12565.10

4.Overhead and Other Expenses 32199.30 33681.80 37327.60 39919.40 48646.90

5.Operating profit 1572.00 3604.60 1556.80 6185.70 12351.80

6.Financial expenses 3276.20 3224.70 2491.20 1486.20 1890.10

7.Net profit before tax (D5-D6) -1704.20 379.90 -934.30 4699.50 10461.70

8.Tax provision 178.40 262.50 231.60 622.20 1070.10

9.Total amount of dividend 442.10 572.80 707.60 1131.90 867.80

10.Total value of bonus shares issued 0.00 97.90 109.70 677.80 1113.10

(Million R

VERTICAL ANALSIS OF IS CEMENT INDUSTRY FROM 2001-2006

2001% 2002% 2003% 2004% 2005%1.Gross sales 100.00 100.00 100.00 100.00 100.00

2.Cost of Sales 93.54 87.94 93.18 81.02 78.57

3.Gross profit 6.46 12.06 6.82 18.98 21.43




7.Net profit before tax (D5-D6) -5.13 1.03 -2.44 10.32 17.84

8.Tax provision 0.54 0.71 0.60 1.37 1.83



(Million R

HORITONAL ANALSIS OF IS CEMENT INDUSTRY FROM 2001-2006

2001% 2002% 2003% 2004% 2005%Gross sales 100. 110.84 115.29 137.00 176.39

Cost of Sales 100. 104.21 114.84 118.67 148.15

Gross profit 100. 206.99 121.75 402.70 585.49

Overhead and Other Expenses 100. 104.60 115.93 123.98 151.08

Operating profit 100. 229.30 99.03 393.49 785.74

Financial expenses 100. 98.43 76.04 45.36 57.69

Net profit before tax (D5-D6) 100. -22.29 54.82 -275.76 -613.88Tax provision 100. 147.14 129.82 348.77 599.83

Total amount of dividend 100. 129.56 160.05 256.03 196.29

Total value of bonus shares issued . 100.00 112.05 692.34 1136.98

NOTE: 2001 IS BASE YEAR FOR ALL EXCEPT FOR TOTAL VALUE OF BONUS SHARE ISSUED IN 2002

INCOME STATEMENT OF CEMENT INDUSTRY

INCOME STATEMENT OF CEMENT INDUSTRY FROM 2001-2006


2/40

Equity and LiabilitiesEquity 2001 2002 2003 2004 2005Ordinary Share Capital 21,570. 24,289.8 24,964.8 27,287.3 29,625.2

Surplus 3,454.3 6,316.5 5,519.6 8,024.1 19,586.

Other long terms liabilitiesPrefrence Shares 0.0 487. 840.5 840.5 1,028.5

Debentures 9,778.7 10,893.4 12,543.7 3,857.7 5,527.1

Other Fixed Laibilities 14,601.3 17,032. 16,691.8 18,931.2 25,541.1Current liablitiesCurrent Liabilities 20,746.2 16,799.5 20,380.7 25,679.2 31,905.3

Total 70,150.5 75,818.2 80,941.1 84,620. 113,213.2

Fixed AssetsFixed assets after A. depreciatio 57,605.7 62,022.5 63,904.4 63,939.5 85620.5

Currents AssetsCash 762. 1,220.7 1,032.4 3,298.3 4,287.3

Investments 3,368.9 3,347.4 5,702. 5,698.1 8,993.

Inventories 0.0 0.0 1,687.1 2,100.6 2,156.5

Other Current Assets 8,414. 9,227.5 8,615.3 9,583.8 12,155.9

Total 70,150.6 75,818.1 80,941.2 84,620.3 113,213.2

Equity and LiabilitiesEquity 2001% 2002% 2003% 2004% 2005%Ordinary Share Capital 30.75 32.04 30.84 32.25 26.17

Surplus 4.92 8.33 6.82 9.48 17.30

Other long terms liabilitiesPrefrence Shares 0.00 0.64 1.04 0.99 0.91

Debentures 13.94 14.37 15.50 4.56 4.88

Other Fixed Laibilities 20.81 22.46 20.62 22.37 22.56Current liablitiesCurrent Liabilities 29.57 22.16 25.18 30.35 28.18

Total

Fixed AssetsFixed assets after A. depreciatio 82.12 81.80 78.95 75.56 75.63

Currents AssetsCash 1.09 1.61 1.28 3.90 3.79

Investments 4.80 4.42 7.04 6.73 7.94

Inventories 0.00 0.00 2.08 2.48 1.90

Other Current Assets 11.99 12.17 10.64 11.33 10.74

Total 100.00 100.00 100.00 100.00 100.00

BALANCE SHEET OF CEMENT INDUSTRY

BS VERTICAL ANALYSIS CEMENT INDUSTRY

(Millio

(Millio


3/40

Equity and LiabilitiesEquity 2001 2002 2003 2004 2005Ordinary Share Capital 21,570. 24,289.8 24,964.8 27,287.3 29,625.2

Surplus 3,454.3 6,316.5 5,519.6 8,024.1 19,586.

Other long terms liabilitiesPrefrence Shares 0.0 487. 840.5 840.5 1,028.5

Debentures 9,778.7 10,893.4 12,543.7 3,857.7 5,527.1

Other Fixed Laibilities 14,601.3 17,032. 16,691.8 18,931.2 25,541.1Current liablitiesCurrent Liabilities 20,746.2 16,799.5 20,380.7 25,679.2 31,905.3

Total 70,150.5 75,818.2 80,941.1 84,620. 113,213.2

Fixed AssetsFixed assets after A. depreciatio 57,605.7 62,022.5 63,904.4 63,939.5 85620.5

Currents AssetsCash 762. 1,220.7 1,032.4 3,298.3 4,287.3

Investments 3,368.9 3,347.4 5,702. 5,698.1 8,993.

Inventories 0.0 0.0 1,687.1 2,100.6 2,156.5

Other Current Assets 8,414. 9,227.5 8,615.3 9,583.8 12,155.9

Total 70,150.6 75,818.1 80,941.2 84,620.3 113,213.2


Surplus 100.00 182.86 159.79 232.29 567.00


Debentures 100.00 111.40 128.28 39.45 56.52

Other Fixed Laibilities 100.00 116.65 114.32 129.65 174.92Current liablitiesCurrent Liabilities 100.00 80.98 98.24 123.78 153.79

Total



Investments 100.00 99.36 169.25 169.14 266.94

Inventories 0.00 0.00 0.00 0.00 0.00


Total 100.00 108.08 115.38 120.63 161.39

BALANCE SHEET OF CEMENT INDUSTRY

BS HORIZONTAL ANALYSIS CEMENT INDUSTRY

(Millio

(Millio


4/40

INCOME STATEMENT OF KOHAT CEMENT LTD.


5/40

2001 2002 2003 2004 2005

1.Gross sales 1,369.3 1,597.9 1,620.1 1,979.6 2,353.7

2.Cost of Sales 1,227.5 1,323.3 1,531. 1,484.1 1,689.5

3.Gross profit 141.8 274.6 89.1 495.5 664.2

4.Overhead and Other Expenses 1,283.7 1,394.6 1,602.7 1,564.4 1,778.7

5.Operating profit 87. 217.6 38. 419.6 584.16.Financial expenses 12.4 7.1 14.1 24.4 23.2

7.Net profit before tax (D5-D6) 74.6 210.5 23.9 395.2 560.9

8.Tax provision 24.4 69.5 18.1 130.9 176.3



VERTICAL ANALSIS OF IS KOHAT CEMENT LTD. FROM 2001-2006

2001% 2002% 2003% 2004% 2005%

1.Gross sales 100.00 100.00 100.00 100.00 100.002.Cost of Sales 89.64 82.81 94.50 74.97 71.78

3.Gross profit 10.36 17.19 5.50 25.03 28.22





8.Tax provision 1.78 4.35 1.12 6.61 7.49



HORITONAL ANALSIS OF IS KOHAT CEMENT LTD. FROM 2001-2006

2001% 2002% 2003% 2004% 2005%

Gross sales 100. 116.69 118.32 144.57 171.89

Cost of Sales 100.00 100.00 100.00 100.00 100.00

Gross profit 100.00 20.75 5.82 33.39 39.31

Overhead and Other Expenses 100. 105.39 104.68 105.41 105.28

Operating profit 100. 16.44 2.48 28.27 34.57

Financial expenses 100. 0.54 0.92 1.64 1.37

Net profit before tax (D5-D6) 100. 15.91 1.56 26.63 33.20

Tax provision 100. 5.25 1.18 8.82 10.44

Total amount of dividend 100. 0.00 2.15 0.00 0.00

Total value of bonus shares issued . 0.00 7.17 0.00 9.74

NOTE: 2001 IS BASE YEAR FOR ALL EXCEPT FOR TOTAL VALUE OF BONUS SHARE ISSUED IN 2002

Equity and LiabilitiesEquity 2001 2002 2003 2004 2005

BALANCE SHEET OF KOHAT CEMENT LTD.

INCOME STATEMENT OF KOHAT CEMENT LTD. FROM 2001-2006

(Millio

(Millio

(Millio

(Millio


6/40

Ordinary Share Capital 219.3 219.3 219.3 329. 493.5

Surplus 384.4 453. 291.1 384.1 603.9


Debentures 0.0 0.0 0.0 0.0 0.0

Other Fixed Laibilities 4. .4 191.2 189.3 117.1

Current liablitiesCurrent Liabilities 209.1 341.7 444.2 520.6 437.4

Total 816.8 1,014.4 1,145.8 1,423. 1,651.9

Fixed AssetsFixed assets after A. depreciatio 608.7 588.8 839.9 905.5 1,119.9


Investments 0.0 0.0 0.0 0.0 0.0

Inventories 0.0 0.0 26. 15.1 22.3


Total 816.8 1,014.4 1,145.8 1,423. 1,651.9


Surplus 47.06 44.66 25.41 26.99 36.56


Debentures 0.00 0.00 0.00 0.00 0.00

Other Fixed Laibilities 0.49 0.04 16.69 13.30 7.09


Total



Investments 0.00 0.00 0.00 0.00 0.00

Inventories 0.00 0.00 2.27 1.06 1.35


Total 100.00 100.00 100.00 100.00 100.00

Equity and LiabilitiesEquity 2001 2002 2003 2004 2005Ordinary Share Capital 219.3 219.3 219.3 329. 493.5

BS VERTICAL ANALYSIS KOHAT CEMENT LTD.

BALANCE SHEET OF KOHAT CEMENT LTD (Millio

(Millio


7/40

Surplus 384.4 453. 291.1 384.1 603.9


Debentures 0.0 0.0 0.0 0.0 0.0

Other Fixed Laibilities 4. .4 191.2 189.3 117.1


Total 816.8 1,014.4 1,145.8 1,423. 1,651.9

Fixed Assets

Fixed assets after A. depreciatio 608.7 588.8 839.9 905.5 1,119.9Currents AssetsCash 49.8 169.2 53.5 168.1 289.1

Investments 0.0 0.0 0.0 0.0 0.0

Inventories 0.0 0.0 26. 15.1 22.3


Total 816.8 1,014.4 1,145.8 1,423. 1,651.9


Surplus 100.00 117.85 75.73 99.92 157.10


Debentures 0.00 0.00 0.00 0.00 0.00



Total 140.28 174.22 202.24



Investments 0.00 0.00 0.00 0.00 0.00

Inventories 0.00 0.00 0.00 0.00 0.00


Total 100.00 124.19 140.28 174.22 202.24

BS HORIZONTAL ANALYSIS KOHAT CEMENT LTD (Millio


8/40

2001 2002 2003 2004 2005

1.Gross sales 4,243.4 4,502.4 5,149.6 5,697.6 7,372.2

INCOME STATEMENT OF DG KHAN CEMENT LTD.


9/40

2.Cost of Sales 4,218.5 3,731.6 4,472. 4,312.1 5,423.3

3.Gross profit 24.9 770.8 677.6 1,385.5 1,948.9

4.Overhead and Other Expenses 4,279.2 3,810.3 4,569.4 4,481. 5,654.5

5.Operating profit 169.6 809.2 765.4 1,345.1 2,425.4

6.Financial expenses 600.3 515.1 410. 189.3 304.

7.Net profit before tax (D5-D6) -430.7 294.1 355.4 1,155.8 2,121.4

8.Tax provision 13.2 0.0 16. 28.7 40.



VERTICAL ANALSIS OF IS DG KHAN CEMENT LTD. FROM 2001-2006

2001% 2002% 2003% 2004% 2005%

1.Gross sales 100.00 100.00 100.00 100.00 100.00

2.Cost of Sales 99.41 82.88 86.84 75.68 73.56

3.Gross profit 0.59 17.12 13.16 24.32 26.44




7.Net profit before tax (D5-D6) -10.15 6.53 6.90 20.29 28.78

8.Tax provision 0.31 0.00 0.31 0.50 0.54

9.Total amount of dividend 0.00 0.00 3.39 5.03 3.4110.Total value of bonus shares issued 0.00 0.00 0.00 2.94 2.27

HORITONAL ANALSIS OF IS DG KHAN CEMENT LTD. FROM 2001-2006

2001% 2002% 2003% 2004% 2005%

Gross sales 100. 106.10 121.36 134.27 173.73

Cost of Sales 100.00 88.46 106.01 102.22 128.56

Gross profit 100.00 3095.58 2721.29 5564.26 7826.91

Overhead and Other Expenses 100.00 89.04 106.78 104.72 132.14

Operating profit 100.00 477.12 451.30 793.10 1430.07

Financial expenses 100.00 85.81 68.30 31.53 50.64Net profit before tax (D5-D6) 100.00 -68.28 -82.52 -268.35 -492.55

Tax provision 100.00 0.00 121.21 217.42 303.03

Total amount of dividend 0.00 0.00 0.00 0.00 0.00

Total value of bonus shares issued 0.00 0.00 0.00 0.00 0.00

Equity and LiabilitiesEquity 2001 2002 2003 2004 2005Ordinary Share Capital 1,523.9 1,523.9 1,676.3 1,676.3 1,843.9

Surplus 1,669.7 1,992.1 2,940.1 4,427.5 7,519.8

Other long terms liabilities

BALANCE SHEET OF DG KHAN CEMENT LTD.

(Millio

(Millio


10/40

Prefrence Shares 0.0 0.0 353.5 353.5 0.0

Debentures 0.0 0.0 199.9 199.9 0.0

Other Fixed Laibilities 3,633.4 3,598.3 2,796.3 2,260.6 5,031.3

Current liablitiesCurrent Liabilities 1,891.3 1,559.7 1,545.5 2,796.8 3,621.5

Total 8,718.3 8,674. 9,511.6 11,714.6 18,016.5

Fixed AssetsFixed assets after A. depreciatio 6,846.8 6,668. 6,410. 7,420.8 10,937.7

Currents Assets

Cash 52.5 69.5 65.3 84. 93.8Investments 1,005.7 1,053.1 1,983.2 2,774.5 5,379.8

Inventories 0.0 0.0 186. 298.5 101.

Other Current Assets 813.3 883.4 867.1 1,136.8 1,504.2

Total 8,718.3 8,674. 9,511.6 11,714.6 18,016.5


Surplus 19.15 22.97 30.91 37.79 41.74

Other long terms liabilitiesPrefrence Shares 0.00 3.72 3.02 0.00

Debentures 0.00 0.00 2.10 1.71 0.00



Total

Fixed Assets 0.00 0.00 0.00 0.00 0.00Fixed assets after A. depreciatio 78.53 76.87 67.39 63.35 60.71


Investments 11.54 12.14 20.85 23.68 29.86

Inventories 0.00 0.00 1.96 2.55 0.56


Total 100.00 100.00 100.00 100.00 100.00

Equity and LiabilitiesEquity 2001 2002 2003 2004 2005Ordinary Share Capital 1,523.9 1,523.9 1,676.3 1,676.3 1,843.9

Surplus 1,669.7 1,992.1 2,940.1 4,427.5 7,519.8


BS VERTICAL ANALYSIS DG KHAN CEMENT LTD.

BALANCE SHEET OF DG KHAN CEMENT LTD. (Millio

(Millio


11/40

Debentures 0.0 0.0 199.9 199.9 0.0

Other Fixed Laibilities 3,633.4 3,598.3 2,796.3 2,260.6 5,031.3

Current liablitiesCurrent Liabilities 1,891.3 1,559.7 1,545.5 2,796.8 3,621.5

Total 8,718.3 8,674. 9,511.6 11,714.6 18,016.5

Fixed AssetsFixed assets after A. depreciatio 6,846.8 6,668. 6,410. 7,420.8 10,937.7

Currents AssetsCash 52.5 69.5 65.3 84. 93.8

Investments 1,005.7 1,053.1 1,983.2 2,774.5 5,379.8Inventories 0.0 0.0 186. 298.5 101.

Other Current Assets 813.3 883.4 867.1 1,136.8 1,504.2

Total 8,718.3 8,674. 9,511.6 11,714.6 18,016.5


Surplus 100.00 130.72 192.93 290.54 493.46


Debentures 0.00 0.00 13.12 13.12 0.00



Total



Investments 100.00 69.11 130.14 182.07 353.03

Inventories 0.00 0.00 12.21 19.59 6.63


Total 100.00 569.20 624.16 768.72 1182.26

BS HORIZONTAL ANALYSIS DG KHAN CEMENT LTD. (Millio


12/40

vertical analysis of industry, kohat cement bench mark

industry kohat Bench industry kohat

2001% 2001% 2001% 2002% 2002%1.Gross sales 100 100 100 100 100

2.Cost of Sales 93.54 89.64 99.41 87.94 82.81

3.Gross profit 6.46 10.36 0.59 12.06 17.19


5.Operating profit 4.73 6.35 4 9.78 13.62


7.Net profit before tax (D5-D6) 5.13 5.45 -10.15 1.03 13.17

8.Tax provision 0.54 1.78 0.31 0.71 4.35


13/40

9.Total amount of dividend 1.33 3.21 0 1.55 0

10.Total value of bonus shares issued 0 0 0 0.27 0


2003% 2003% 2003% 2004% 2004%1.Gross sales 100 100 100 100 100

2.Cost of Sales 93.18 94.5 86.84 81.02 74.97

3.Gross profit 6.82 5.5 13.16 18.98 25.03

4.Overhead and Other Expenses 97.41 98.93 88.73 87.66 79.035.Operating profit 4.06 2.35 14.86 13.58 21.2


7.Net profit before tax (D5-D6) -2.44 1.48 6.9 10.32 19.96

8.Tax provision 0.6 1.12 0.31 1.37 6.61

9.Total amount of dividend 1.85 2.03 3.39 2.49 0

10.Total value of bonus shares issued 0.29 6.77 0 1.49 0


2005% 2005% 2005% 2006% 2006%1.Gross sales 100 100 100 100 100

2.Cost of Sales 78.57 71.78 73.56 72.05 89.64

3.Gross profit 21.43 28.22 26.44 27.95 10.36





8.Tax provision 1.83 7.49 0.54 1.54 1.78

9.Total amount of dividend 1.48 0 3.41 2.83 3.21

10.Total value of bonus shares issued 1.9 6.99 2.27 0.85 0

horizontal analysis of industry,kohat cement bench mark


2001% 2001% 2001% 2002% 2002%1.Gross sales 100 100 100 110.84 116.69

2.Cost of Sales 100 100 100 104.21 100

3.Gross profit 100 100 100 206.98 20.75

4.Overhead and Other Expenses 100 100 100 104.6 105.39

5.Operating profit 100 100 100 229.3 16.44

6.Financial expenses 100 100 100 98.43 0.54

7.Net profit before tax (D5-D6) 100 100 100 -22.29 15.91

8.Tax provision 100 100 100 147.14 5.25

9.Total amount of dividend 100 100 0.00 129.56 0


14/40

10.Total value of bonus shares issued 100 0.00 100


2003% 2003% 2003% 2004% 2004%1.Gross sales 115.29 118.32 121.36 137 144.57

2.Cost of Sales 114.84 100 106.01 118.67 100

3.Gross profit 121.75 5.82 2721.29 402.7 33.39


5.Operating profit 99.03 2.48 451.3 393.49 28.276.Financial expenses 76.04 0.92 68.3 45.36 1.64

7.Net profit before tax (D5-D6) 54.82 1.56 -82.52 -275.76 26.63

8.Tax provision 129.82 1.18 121.21 348.77 8.82

9.Total amount of dividend 160.05 2.15 0.00 256.03 0

10.Total value of bonus shares issued 112.058 7.17 0.00 692.34 0


2005% 2005% 2005% 2006% 2006%1.Gross sales 176.39 171.89 173.73 243.06 213.44

2.Cost of Sales 148.15 100 128.56 187.22 100

3.Gross profit 585.49 39.31 7826.91 1051.99 69.62




7.Net profit before tax (D5-D6) -613.88 33.2 -492.55 -1002 60.33

8.Tax provision 599.83 10.44 303.03 695.35 11.18

9.Total amount of dividend 196.29 0 0.00 517.76 0



Equity and Liabilities 2001% 2001% 2001% 2002% 2002%

EquityOrdinary Share Capital 30.75 26.85 17.48 32.04 21.62

Surplus 4.92 47.06 19.15 8.33 44.66


Prefrence Shares 0 0 0.64 0

Debentures 13.94 0 0 14.37 0


Current liablities

Current Liabilities 29.57 25.6 21.69 22.16 33.68

Total 100 100 100 100 100

Fixed Assets 0

BS VERTICAL ANALYSIS DG KHAN CEMENT LTD. (Millio


15/40

Fixed assets after A. depreciatio 82.12 74.52 78.53 81.8 58.04

Currents Assets

Cash 1.09 6.1 0.6 1.61 16.68

Investments 4.8 0 11.54 4.42 0

Inventories 0 0 0 0 0


Total 100 100 100 100 100

industry kohat Bench industry kohatEquity and Liabilities 2003% 2003% 2003% 2004% 2004%

Equity

Ordinary Share Capital 30.84 19.14 17.62 32.25 23.12

Surplus 6.82 25.41 30.91 9.48 26.99


Prefrence Shares 1.04 0 3.72 0.99 0

Debentures 15.5 0 2.1 4.56 0


Current liablities

Current Liabilities 25.18 38.77 16.25 30.36 36.58Total 100 100 100 100 100

Fixed Assets


Currents Assets

Cash 1.28 4.67 0.69 3.9 11.81

Investments 7.04 0 20.85 6.73 0

Inventories 2.08 2.27 1.96 2.48 1.06


Total 100 100 100 100 100



Equity

Ordinary Share Capital 26.17 29.87 10.23 19.65 30.08Surplus 17.3 36.56 41.74 22.4 44.16


Prefrence Shares 0.91 0 0 0.58 0

Debentures 4.88 0 0 2.76 0


Current liablities


Total 100 100 100 100 100

Fixed Assets


BS VERTICAL ANALYSIS DG KHAN CEMENT LTD.


16/40

Currents Assets

Cash 3.79 21.35 0.23 3.38 21.35

Investments 7.94 0.21 37.97 11.03 0.21

Inventories 1.9 2.86 0.66 1.98 2.86


Total 100 100 100 100 100



Equity

Ordinary Share Capital 100 100 100 112.61 100

Surplus 100 100 100 182.86 117.85


Prefrence Shares 0.00 0.00 0 0.00 0.00

Debentures 100 0.00 0 111.4 0.00

Other Fixed Laibilities 100 100 100 116.65 10

Current liablities

Current Liabilities 100 100 100 80.98 163.41

Total

Fixed Assets

Fixed assets after A. depreciatio 100 100 100 107.67 96.73

BS HORIZONTAL ANALYSIS DG KHAN CEMENT LTD. (Millio


17/40

Currents Assets

Cash 100 100. 100 160.2 339.76

Investments 100 . 100 99.36 0.00

Inventories 0.00 . 0 0.00 0.00

Other Current Assets 100 100. 100 109.67 161.97

Total 100 100. 100 108.08 124.19


Equity and Liabilities 2003% 2003% 2003% 2004% 2004%Equity

Ordinary Share Capital 115.74 100 110 126.51 150.02

Surplus 159.79 75.73 192.93 232.29 99.92


Prefrence Shares 0.00 0.00 23.2 0.00 0.00

Debentures 128.28 0.00 13.12 39.45 0.00

Other Fixed Laibilities 114.32 4780 183.5 129.65 4732.5

Current liablities


Total 115.38 140.28 624.16 120.63 174.22

Fixed Assets

Fixed assets after A. depreciatio 110.93 137.98 420.63 111 148.76

Currents Assets

Cash 135.49 107.43 4.29 432.85 337.55

Investments 169.25 0.00 130.14 169.14 0.00

Inventories 0.00 0.00 12.21 0.00 0.00


Total 115.38 140.28 624.16 120.63 174.22



Equity

Ordinary Share Capital 137.34 225.03 121 161.64 421.93

Surplus 567 157.1 493.46 1150.67 353.43

Other long terms liabilitiesPrefrence Shares 0.00 0.00 0 0.00 0.00

Debentures 56.52 0.00 0 50.16 0.00


Current liablities

Current Liabilities 153.79 209.18 237.65 214.05 264.18Total 161.39 202.24 1182.26 252.94 376.62

Fixed Assets


Currents Assets

Cash 562.64 580.52 6.16 788.16 1319

BS HORIZONTAL ANALYSIS DG KHAN CEMENT LTD.


18/40

Investments 266.94 0.00 353.03 580.72 0.00

Inventories 0.00 0.00 6.63 0.00 0.00


Total 161.39 202.24 1182.26 252.94 376.62


19/40

upees)

2006

80787.60

58210.90

22576.70

61479.80

20188.90

3112.80

17076.10

1240.50

2289.00

687.50

upees)

2006%100.00

72.05

27.95

76.10

24.99

3.85

21.14

1.54

2.83

0.85

upees)

2006%243.06

187.22

1051.99

190.94

1284.28

95.01

-1002.00695.35

517.76

702.25


20/40

200634,864.8

39,747.6

1,028.5

4,904.6

52,484.4

44,407.3

177,437.2

132709.5

6,005.8

19,564.

3,517.8

15,640.1

177,437.2

2006%19.65

22.40

0.58

2.76

29.58

25.03

74.79

3.38

11.03

1.98

8.81

100.00

Rupees)

Rupees)


21/40

200634,864.8

39,747.6

1,028.5

4,904.6

52,484.4

44,407.3

177,437.2

132709.5

6,005.8

19,564.

3,517.8

15,640.1

177,437.2

2006%161.64

1150.67

0.00

50.16

359.45

214.05

230.38

788.16

580.72

0.00

185.88

252.94

Rupees)

Rupees)


22/40


23/40

2006

2,922.6

1,723.

1,199.6

1,848.2

1,093.554.1

1,039.4

192.6

0.0

92.5

2006%

100.0058.95

41.05

63.24

37.42

1.85

35.56

6.59

0.00

3.16

2006%

213.44

100.00

69.62

107.27

63.46

3.14

60.33

11.18

0.00

5.37

2006

Rupees)

Rupees)

Rupees)

Rupees)


24/40

925.3

1,358.6

0.0

0.0

239.9

552.4

3,076.2

2,079.4

656.9

6.6

87.9

245.4

3,076.2

2006%30.08

44.16

0.00

0.00

7.80

17.96

67.60

21.35

0.21

2.86

7.98

100.00

2006925.3

Rupees)

Rupees)


25/40

1,358.6

0.0

0.0

239.9

552.4

3,076.2

2,079.4

656.9

6.6

87.9

245.4

3,076.2

2006%421.93

353.43

0.00

0.00

5997.50

264.18

376.62

341.61

1319.08

0.00

0.00

155.02

376.62

Rupees)


26/40

2006

10,955.9


27/40

6,993.1

3,962.8

7,341.3

3,899.1

450.7

3,448.4

40.5

276.6

184.4

2006%

100.00

63.83

36.17

67.01

35.59

4.11

31.48

0.37

2.521.68

2006%

258.19

165.77

15914.86

171.56

2299.00

75.08-800.65

306.82

0.00

0.00

2006

1,843.9

17,424.3

Rupees)

Rupees)


28/40

0.0

0.0

7,401.4

7,634.9

34,304.5

19,576.5

77.213,026.

226.3

1,398.5

34,304.5

2006%5.38

50.79

0.00

0.00

21.58

22.26

0.00

57.07

0.23

37.97

0.66

4.08

100.00

20061,843.9

17,424.3

0.0

Rupees)

Rupees)


29/40

0.0

7,401.4

7,634.9

34,304.5

19,576.5

77.2

13,026.226.3

1,398.5

34,304.5

2006%121.00

1143.40

0.00

0.00

485.69

501.01

1284.63

5.07

854.78

14.85

91.77

2251.10

Rupees)


30/40

Bench

2002%100

82.88

17.12

84.63

17.97

11.44

6.53

0


31/40

0

0

Bench

2004%100

75.68

24.32

78.6523.61

3.32

20.29

0.5

5.03

2.94

Bench

2006%100

63.83

36.17

67.01

35.59

4.11

31.48

0.37

2.52

1.68

Bench

2002%106.1

88.46

3095.58

89.04

477.12

85.81

-68.28

0

0.00


32/40

0.00

Bench

2004%134.27

102.22

5564.26

104.72

793.131.53

-268.35

217.42

0.00

0.00

Bench

2006%258.19

165.77

15914.86

171.56

2299

75.08

-800.65

306.82

0.00

0.00

Bench

2002%

17.57

22.97

0

0

41.48

17.98

100

0

Rupees)


33/40

76.87

0.8

12.14

0

10.18

100

Bench2004%

14.31

37.79

3.02

1.71

19.3

23.87100

63.35

0.72

23.68

2.55

9.7

100

Bench

2006%

5.3850.79

0

0

21.58

22.26

100

0

57.07


34/40

0.23

37.97

0.66

4.08

100

Bench

2002%

100

130.72

0

0

236.12

102.35

437.56

Rupees)


35/40

4.56

69.11

0

57.97

569.2

Bench

2004%

110

290.54

23.2

13.12

148.34

183.53

768.72

486.96

5.51

182.07

19.59

74.6

768.72

Bench

2006%

121

1143.4

0

0

485.69

501.01

2251.1

1284.63

5.07


36/40

854.78

14.85

91.77

2251.1


37/40

Cement Sector

Items 2001 2002 2003

A.Capital Structure:1.Ordinary Share Capital 21,570. 24,289.8 24,964.8

2.Surplus 3,454.3 6,316.5 5,519.6

3.Shareholder's Equity (A1+A2) 25,024.3 30,606.3 30,484.3

4.Prefrence Shares 0.0 487. 840.5

5.Debentures 9,778.7 10,893.4 12,543.7

6.Other Fixed Laibilities 14,601.3 17,032. 16,691.8

7.Total Fixed Laibilities (A4+A5+A6) 24,380. 28,412.4 30,076.1

8.Total Capital Employed (A3+A7) 49,404.3 59,018.7 60,560.4

B.Liquidity:

1.Liquid Assets: 4,130.9 4,568.1 6,734.4

(1)Cash 762. 1,220.7 1,032.4

(II)Investments 3,368.9 3,347.4 5,702.2.Other Current Assets 8,414. 9,227.5 8,615.3

3.Inventories 0.0 0.0 1,687.1

4.Current Assets (B1+B2+B3) 12,544.9 13,795.6 17,036.7

5.Current Liabilities 20,746.2 16,799.5 20,380.7

6.Total Liabilities(A7+B5) 45,126.2 45,211.9 50,456.7

7.Net Current Assets(B4-B5) -8,201.3 -3,003.9 -3,344.

8.Contractual Liabilities 36,053.8 34,011.5 38,055.6

9.Net liquid assets (B1-B5) -16,615.3 -12,231.4 -13,646.3

C.Fixed Assets:

1.Fixed Asset At Cost 78,367.8 86,494.6 90,963.2

2.Fixed assets after deducting accumulated depreciatio 57,605.7 62,022.5 63,904.4

3.Depreciation for the year 2,702.2 3,109.2 2,642.4

4.Total assets (B4+C2) 70,150.6 75,818.1 80,941.1

D.Operation:

1.Gross sales 33,237.7 36,841.3 38,320.1

(1)Local sales 33,237.7 36,696. 37,856.6

(2)Export sales 0.0 145.3 463.5

2.Cost of Sales 31,091.6 32,399.1 35,707.1

3.Gross profit 2,146.1 4,442.2 2,612.9

4.Overhead and Other Expenses 32,199.3 33,681.8 37,327.6

5.Operating profit 1,572. 3,604.6 1,556.8

6.Financial expenses 3,276.2 3,224.7 2,491.2

7.Net profit before tax (D5-D6) -1,704.2 379.9 -934.3

8.Tax provision 178.4 262.5 231.6

9.Total amount of dividend 442.1 572.8 707.610.Total value of bonus shares issued 0.0 97.9 109.7

E.Sources of Increase In Capital Employed:

1.Increase/decrease in capital employed (A8 - A8 of pr 5,923.9 9,614.4 1,541.7

2.Retention in business (D7-D8-D9) -2,324.7 -455.4 -1,873.5

3.Finance from outside the company (E1-E2) 8,248.6 10,069.8 3,415.2


38/40

2004 2005 2006

27,287.3 29,625.2 34,864.8

8,024.1 19,586. 39,747.6

35,311.4 49,211.2 74,612.4

840.5 1,028.5 1,028.5

3,857.7 5,527.1 4,904.6

18,931.2 25,541.1 52,484.4

23,629.4 32,096.7 58,417.5

58,940.8 81307.9 133029.9

8,996.4 13,280.3 25,569.8

3,298.3 4,287.3 6,005.8

5,698.1 8,993. 19,564.9,583.8 12,155.9 15,640.2

2,100.6 2,156.4 3,517.8

20,680.8 27,592.6 44,727.8

25,679.2 31,905.4 44,407.3

49,308.6 64002.1 102824.8

-4,998.4 -4,312.8 320.5

29,575.2 40,369.1 73,518.

-16,682.8 -18,625.1 -18,837.5

86146.9 116112.5 166559.8

63,939.5 85620.5 132709.5

2,630.1 3,035.6 3,331.7

84620.3 113213.1 177437.3

45,537.3 58,628.7 80,787.6

44,760.2 55,859.3 75,881.6

777.1 2,769.4 4,906.

36,895. 46,063.6 58,210.9

8,642.3 12,565.1 22,576.7

39,919.4 48,646.9 61,479.8

6,185.7 12,351.8 20,188.9

1,486.2 1,890.1 3,112.8

4,699.5 10,461.7 17,076.1

622.2 1,070.1 1,240.5

1,131.9 867.8 2,289.677.8 1,113.1 687.5

-1,619.6 22,367.1 51,722.

2,945.4 8,523.8 13,546.6

-4,565. 13,843.3 38,175.4


39/40

ROFITABILITY RATIOS

12 NET P=NP/N.SALE*100

3 RETURN ON EQUIRY=N.PROFIT/AVE EQUITY*100

4 ROCE=N.PROFIT BEFORE TAX N INTEREST*100/TOTAL CAPITAL EMPLOYED

Total Capital = ordinary share capital + preference share capital + Reserves + Debentur

ACTIVITY RATIOS

1 INVENTORY TURNOVER=CGS/AVE INVENTORY

2 ACCOUNT RECEIVEABLE TURNOVER=CREDIT SALE/AVE ACCOUNT RECEIV

3 SELLING EXP = T. SELLING EXP*100/N.SALE

4 ADMIN EXPENSES RATIO=T. ADMIN EXP*100/N.SALE5 FINANCE EXP RATIO=TOTAL FINANCE EXP/N.SALE

6 TOTAL OPERATING EXPENSES RATIO=T.OPERATING EXP*100/N.SALE

FINANCIAL STABILITY

1 WORKING CAPITAL=C.A/C.L

2 QUICK ASSETS RATIO=C.A-INVENTORY LESS PREPAID/C.L LESS BANK OVERDRAF

3 EQUITY RATIO=TOTAL OWNER EQUITY*100/T.ASSETS

GROSS-P=GP/N.SALE*100


40/40

es +Long-term loans

final project of analysis

Documents