final project of analysis
Post on 30-May-2018
216 Views
Preview:
TRANSCRIPT
-
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
4.Overhead and Other Expenses 96.88 91.42 97.41 87.66 82.97
5.Operating profit 4.73 9.78 4.06 13.58 21.07
6.Financial expenses 9.86 8.75 6.50 3.26 3.22
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
9.Total amount of dividend 1.33 1.55 1.85 2.49 1.48
10.Total value of bonus shares issued 0.00 0.27 0.29 1.49 1.90
(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
-
8/14/2019 Final Project of Analysis
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
-
8/14/2019 Final Project of Analysis
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
Equity and LiabilitiesEquity 2001% 2002% 2003% 2004% 2005%Ordinary Share Capital 100.00 112.61 115.74 126.51 137.34
Surplus 100.00 182.86 159.79 232.29 567.00
Other long terms liabilitiesPrefrence Shares 0.00 0.00 0.00 0.00 0.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
Fixed AssetsFixed assets after A. depreciatio 100.00 107.67 110.93 111.00 148.63
Currents AssetsCash 100.00 160.20 135.49 432.85 562.64
Investments 100.00 99.36 169.25 169.14 266.94
Inventories 0.00 0.00 0.00 0.00 0.00
Other Current Assets 100.00 109.67 102.39 113.90 144.47
Total 100.00 108.08 115.38 120.63 161.39
BALANCE SHEET OF CEMENT INDUSTRY
BS HORIZONTAL ANALYSIS CEMENT INDUSTRY
(Millio
(Millio
-
8/14/2019 Final Project of Analysis
4/40
INCOME STATEMENT OF KOHAT CEMENT LTD.
-
8/14/2019 Final Project of Analysis
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
9.Total amount of dividend 43.9 0.0 32.9 0.0 0.0
10.Total value of bonus shares issued 0.0 0.0 109.7 0.0 164.5
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
4.Overhead and Other Expenses 93.75 87.28 98.93 79.03 75.57
5.Operating profit 6.35 13.62 2.35 21.20 24.82
6.Financial expenses 0.91 0.44 0.87 1.23 0.99
7.Net profit before tax (D5-D6) 5.45 13.17 1.48 19.96 23.83
8.Tax provision 1.78 4.35 1.12 6.61 7.49
9.Total amount of dividend 3.21 0.00 2.03 0.00 0.00
10.Total value of bonus shares issued 0.00 0.00 6.77 0.00 6.99
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
-
8/14/2019 Final Project of Analysis
6/40
Ordinary Share Capital 219.3 219.3 219.3 329. 493.5
Surplus 384.4 453. 291.1 384.1 603.9
Other long terms liabilitiesPrefrence Shares 0.0 0.0 0.0 0.0 0.0
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
Currents 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
Other Current Assets 158.3 256.4 226.4 334.3 220.6
Total 816.8 1,014.4 1,145.8 1,423. 1,651.9
Equity and LiabilitiesEquity 2001% 2002% 2003% 2004% 2005%Ordinary Share Capital 26.85 21.62 19.14 23.12 29.87
Surplus 47.06 44.66 25.41 26.99 36.56
Other long terms liabilitiesPrefrence Shares 0.00 0.00 0.00 0.00 0.00
Debentures 0.00 0.00 0.00 0.00 0.00
Other Fixed Laibilities 0.49 0.04 16.69 13.30 7.09
Current liablitiesCurrent Liabilities 25.60 33.68 38.77 36.58 26.48
Total
Fixed AssetsFixed assets after A. depreciatio 74.52 58.04 73.30 63.63 67.79
Currents AssetsCash 6.10 16.68 4.67 11.81 17.50
Investments 0.00 0.00 0.00 0.00 0.00
Inventories 0.00 0.00 2.27 1.06 1.35
Other Current Assets 19.38 25.28 19.76 23.49 13.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
-
8/14/2019 Final Project of Analysis
7/40
Surplus 384.4 453. 291.1 384.1 603.9
Other long terms liabilitiesPrefrence Shares 0.0 0.0 0.0 0.0 0.0
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 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
Other Current Assets 158.3 256.4 226.4 334.3 220.6
Total 816.8 1,014.4 1,145.8 1,423. 1,651.9
Equity and LiabilitiesEquity 2001% 2002% 2003% 2004% 2005%Ordinary Share Capital 100.00 100.00 100.00 150.02 225.03
Surplus 100.00 117.85 75.73 99.92 157.10
Other long terms liabilitiesPrefrence Shares 0.00 0.00 0.00 0.00 0.00
Debentures 0.00 0.00 0.00 0.00 0.00
Other Fixed Laibilities 100.00 10.00 4780.00 4732.50 2927.50
Current liablitiesCurrent Liabilities 100.00 163.41 212.43 248.97 209.18
Total 140.28 174.22 202.24
Fixed AssetsFixed assets after A. depreciatio 100.00 96.73 137.98 148.76 183.98
Currents AssetsCash 100.00 339.76 107.43 337.55 580.52
Investments 0.00 0.00 0.00 0.00 0.00
Inventories 0.00 0.00 0.00 0.00 0.00
Other Current Assets 100.00 161.97 143.02 211.18 139.36
Total 100.00 124.19 140.28 174.22 202.24
BS HORIZONTAL ANALYSIS KOHAT CEMENT LTD (Millio
-
8/14/2019 Final Project of Analysis
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.
-
8/14/2019 Final Project of Analysis
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.
9.Total amount of dividend 0.0 0.0 174.7 286.8 251.4
10.Total value of bonus shares issued 0.0 0.0 0.0 167.6 167.6
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
4.Overhead and Other Expenses 100.84 84.63 88.73 78.65 76.70
5.Operating profit 4.00 17.97 14.86 23.61 32.90
6.Financial expenses 14.15 11.44 7.96 3.32 4.12
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
-
8/14/2019 Final Project of Analysis
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
Equity and LiabilitiesEquity 2001% 2002% 2003% 2004% 2005%Ordinary Share Capital 17.48 17.57 17.62 14.31 10.23
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
Other Fixed Laibilities 41.68 41.48 29.40 19.30 27.93
Current liablitiesCurrent Liabilities 21.69 17.98 16.25 23.87 20.10
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
Currents AssetsCash 0.60 0.80 0.69 0.72 0.52
Investments 11.54 12.14 20.85 23.68 29.86
Inventories 0.00 0.00 1.96 2.55 0.56
Other Current Assets 9.33 10.18 9.12 9.70 8.35
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
Other long terms liabilitiesPrefrence Shares 0.0 0.0 353.5 353.5 0.0
BS VERTICAL ANALYSIS DG KHAN CEMENT LTD.
BALANCE SHEET OF DG KHAN CEMENT LTD. (Millio
(Millio
-
8/14/2019 Final Project of Analysis
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
Equity and LiabilitiesEquity 2001% 2002% 2003% 2004% 2005%Ordinary Share Capital 100.00 100.00 110.00 110.00 121.00
Surplus 100.00 130.72 192.93 290.54 493.46
Other long terms liabilitiesPrefrence Shares 0.00 0.00 23.20 23.20 0.00
Debentures 0.00 0.00 13.12 13.12 0.00
Other Fixed Laibilities 100.00 236.12 183.50 148.34 330.16
Current liablitiesCurrent Liabilities 100.00 102.35 101.42 183.53 237.65
Total
Fixed AssetsFixed assets after A. depreciatio 100.00 437.56 420.63 486.96 717.74
Currents AssetsCash 100.00 4.56 4.29 5.51 6.16
Investments 100.00 69.11 130.14 182.07 353.03
Inventories 0.00 0.00 12.21 19.59 6.63
Other Current Assets 100.00 57.97 56.90 74.60 98.71
Total 100.00 569.20 624.16 768.72 1182.26
BS HORIZONTAL ANALYSIS DG KHAN CEMENT LTD. (Millio
-
8/14/2019 Final Project of Analysis
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
4.Overhead and Other Expenses 96.88 93.75 100.84 91.42 87.28
5.Operating profit 4.73 6.35 4 9.78 13.62
6.Financial expenses 9.86 0.91 14.15 8.75 0.44
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
-
8/14/2019 Final Project of Analysis
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
industry kohat Bench industry kohat
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
6.Financial expenses 6.5 0.87 7.96 3.26 1.23
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
industry kohat Bench industry kohat
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
4.Overhead and Other Expenses 82.97 75.57 76.7 76.41 93.75
5.Operating profit 21.07 24.82 32.9 24.99 6.35
6.Financial expenses 3.22 0.99 4.12 3.85 0.91
7.Net profit before tax (D5-D6) 17.84 23.83 28.78 21.14 5.45
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
industry kohat Bench industry kohat
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
-
8/14/2019 Final Project of Analysis
14/40
10.Total value of bonus shares issued 100 0.00 100
industry kohat Bench industry kohat
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
4.Overhead and Other Expenses 115.93 104.68 106.78 123.98 105.41
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
industry kohat Bench industry kohat
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
4.Overhead and Other Expenses 151.08 105.28 132.14 190.94 107.27
5.Operating profit 785.74 34.57 1430.07 1284.28 63.46
6.Financial expenses 57.69 1.37 50.64 95.01 3.14
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
10.Total value of bonus shares issued 1136.98 9.74 0.00 702.25 5.37
industry kohat Bench industry kohat
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
Other long terms liabilities
Prefrence Shares 0 0 0.64 0
Debentures 13.94 0 0 14.37 0
Other Fixed Laibilities 20.81 0.49 41.68 22.46 0.04
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
-
8/14/2019 Final Project of Analysis
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
Other Current Assets 11.99 19.38 9.33 12.17 25.28
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
Other long terms liabilities
Prefrence Shares 1.04 0 3.72 0.99 0
Debentures 15.5 0 2.1 4.56 0
Other Fixed Laibilities 20.62 16.69 29.4 22.37 13.3
Current liablities
Current Liabilities 25.18 38.77 16.25 30.36 36.58Total 100 100 100 100 100
Fixed Assets
Fixed assets after A. depreciatio 78.95 73.3 67.39 75.56 63.63
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
Other Current Assets 10.64 19.76 9.12 11.33 23.49
Total 100 100 100 100 100
industry kohat Bench industry kohat
Equity and Liabilities 2005% 2005% 2005% 2006% 2006%
Equity
Ordinary Share Capital 26.17 29.87 10.23 19.65 30.08Surplus 17.3 36.56 41.74 22.4 44.16
Other long terms liabilities
Prefrence Shares 0.91 0 0 0.58 0
Debentures 4.88 0 0 2.76 0
Other Fixed Laibilities 22.56 7.09 27.93 29.58 7.8
Current liablities
Current Liabilities 28.18 17.96 20.1 25.03 17.96
Total 100 100 100 100 100
Fixed Assets
Fixed assets after A. depreciatio 75.63 67.6 57.07 74.79 67.6
BS VERTICAL ANALYSIS DG KHAN CEMENT LTD.
-
8/14/2019 Final Project of Analysis
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
Other Current Assets 10.74 7.98 4.08 8.81 7.98
Total 100 100 100 100 100
industry kohat Bench industry kohat
Equity and Liabilities 2001% 2001% 2001% 2002% 2002%
Equity
Ordinary Share Capital 100 100 100 112.61 100
Surplus 100 100 100 182.86 117.85
Other long terms liabilities
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
-
8/14/2019 Final Project of Analysis
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
industry kohat Bench industry kohat
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
Other long terms liabilities
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
Current Liabilities 98.28 212.43 101.42 123.78 248.97
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
Other Current Assets 102.39 143.02 56.9 113.9 211.18
Total 115.38 140.28 624.16 120.63 174.22
industry kohat Bench industry kohat
Equity and Liabilities 2005% 2005% 2005% 2006% 2006%
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
Other Fixed Laibilities 174.92 2927.5 330.16 359.45 5997.5
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
Fixed assets after A. depreciatio 148.63 183.98 717.74 230.38 341.61
Currents Assets
Cash 562.64 580.52 6.16 788.16 1319
BS HORIZONTAL ANALYSIS DG KHAN CEMENT LTD.
-
8/14/2019 Final Project of Analysis
18/40
Investments 266.94 0.00 353.03 580.72 0.00
Inventories 0.00 0.00 6.63 0.00 0.00
Other Current Assets 144.47 139.36 98.71 185.88 155.02
Total 161.39 202.24 1182.26 252.94 376.62
-
8/14/2019 Final Project of Analysis
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
-
8/14/2019 Final Project of Analysis
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)
-
8/14/2019 Final Project of Analysis
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)
-
8/14/2019 Final Project of Analysis
22/40
-
8/14/2019 Final Project of Analysis
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)
-
8/14/2019 Final Project of Analysis
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)
-
8/14/2019 Final Project of Analysis
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)
-
8/14/2019 Final Project of Analysis
26/40
2006
10,955.9
-
8/14/2019 Final Project of Analysis
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)
-
8/14/2019 Final Project of Analysis
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)
-
8/14/2019 Final Project of Analysis
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)
-
8/14/2019 Final Project of Analysis
30/40
Bench
2002%100
82.88
17.12
84.63
17.97
11.44
6.53
0
-
8/14/2019 Final Project of Analysis
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
-
8/14/2019 Final Project of Analysis
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)
-
8/14/2019 Final Project of Analysis
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
-
8/14/2019 Final Project of Analysis
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)
-
8/14/2019 Final Project of Analysis
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
-
8/14/2019 Final Project of Analysis
36/40
854.78
14.85
91.77
2251.1
-
8/14/2019 Final Project of Analysis
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
-
8/14/2019 Final Project of Analysis
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
-
8/14/2019 Final Project of Analysis
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
-
8/14/2019 Final Project of Analysis
40/40
es +Long-term loans
top related