Final Project of Analysis
Final Project of Analysis
Final Project of Analysis
(Million Rupees)
INCOME STATEMENT OF CEMENT INDUSTRY FROM 2001-2006
2001 2002 2003 2004 2005 2006
1.Gross sales 33237.70 36841.30 38320.10 45537.30 58628.70 80787.60
2.Cost of Sales 31091.60 32399.10 35707.10 36895.00 46063.60 58210.90
3.Gross profit 2146.10 4442.20 2612.90 8642.30 12565.10 22576.70
4.Overhead and Other Expenses 32199.30 33681.80 37327.60 39919.40 48646.90 61479.80
5.Operating profit 1572.00 3604.60 1556.80 6185.70 12351.80 20188.90
6.Financial expenses 3276.20 3224.70 2491.20 1486.20 1890.10 3112.80
7.Net profit before tax (D5-D6) -1704.20 379.90 -934.30 4699.50 10461.70 17076.10
8.Tax provision 178.40 262.50 231.60 622.20 1070.10 1240.50
9.Total amount of dividend 442.10 572.80 707.60 1131.90 867.80 2289.00
10.Total value of bonus shares issued 0.00 97.90 109.70 677.80 1113.10 687.50
(Million Rupees)
VERTICAL ANALSIS OF IS CEMENT INDUSTRY FROM 2001-2006
2001% 2002% 2003% 2004% 2005% 2006%
1.Gross sales 100.00 100.00 100.00 100.00 100.00 100.00
2.Cost of Sales 93.54 87.94 93.18 81.02 78.57 72.05
3.Gross profit 6.46 12.06 6.82 18.98 21.43 27.95
4.Overhead and Other Expenses 96.88 91.42 97.41 87.66 82.97 76.10
5.Operating profit 4.73 9.78 4.06 13.58 21.07 24.99
6.Financial expenses 9.86 8.75 6.50 3.26 3.22 3.85
7.Net profit before tax (D5-D6) -5.13 1.03 -2.44 10.32 17.84 21.14
8.Tax provision 0.54 0.71 0.60 1.37 1.83 1.54
9.Total amount of dividend 1.33 1.55 1.85 2.49 1.48 2.83
10.Total value of bonus shares issued 0.00 0.27 0.29 1.49 1.90 0.85
(Million Rupees)
HORITONAL ANALSIS OF IS CEMENT INDUSTRY FROM 2001-2006
2001% 2002% 2003% 2004% 2005% 2006%
Gross sales 100 110.84 115.29 137.00 176.39 243.06
Cost of Sales 100 104.21 114.84 118.67 148.15 187.22
Gross profit 100 206.99 121.75 402.70 585.49 1051.99
Overhead and Other Expenses 100 104.60 115.93 123.98 151.08 190.94
Operating profit 100 229.30 99.03 393.49 785.74 1284.28
Financial expenses 100 98.43 76.04 45.36 57.69 95.01
Net profit before tax (D5-D6) 100 -22.29 54.82 -275.76 -613.88 -1002.00
Tax provision 100 147.14 129.82 348.77 599.83 695.35
Total amount of dividend 100 129.56 160.05 256.03 196.29 517.76
Total value of bonus shares issued 100.00 112.05 692.34 1136.98 702.25
NOTE: 2001 IS BASE YEAR FOR ALL EXCEPT FOR TOTAL VALUE OF BONUS SHARE ISSUED IN 2002
BALANCE SHEET OF CEMENT INDUSTRY (Million Rupees)
Equity and Liabilities
Equity 2001 2002 2003 2004 2005 2006
Ordinary Share Capital 21,570 24,289.8 24,964.8 27,287.3 29,625.2 34,864.8
Surplus 3,454.3 6,316.5 5,519.6 8,024.1 19,586 39,747.6
Other long terms liabilities
Prefrence Shares 0.0 487 840.5 840.5 1,028.5 1,028.5
Debentures 9,778.7 10,893.4 12,543.7 3,857.7 5,527.1 4,904.6
Other Fixed Laibilities 14,601.3 17,032 16,691.8 18,931.2 25,541.1 52,484.4
Current liablities
Current Liabilities 20,746.2 16,799.5 20,380.7 25,679.2 31,905.3 44,407.3
Total 70,150.5 75,818.2 80,941.1 84,620 113,213.2 177,437.2
Fixed Assets
Fixed assets after A. depreciation 57,605.7 62,022.5 63,904.4 63,939.5 85620.5 132709.5
Currents Assets
Cash 762 1,220.7 1,032.4 3,298.3 4,287.3 6,005.8
Investments 3,368.9 3,347.4 5,702 5,698.1 8,993 19,564
Inventories 0.0 0.0 1,687.1 2,100.6 2,156.5 3,517.8
Other Current Assets 8,414 9,227.5 8,615.3 9,583.8 12,155.9 15,640.1
Total 70,150.6 75,818.1 80,941.2 84,620.3 113,213.2 177,437.2
(Million Rupees)
VERTICAL ANALSIS OF IS KOHAT CEMENT LTD. FROM 2001-2006
2001% 2002% 2003% 2004% 2005% 2006%
1.Gross sales 100.00 100.00 100.00 100.00 100.00 100.00
2.Cost of Sales 89.64 82.81 94.50 74.97 71.78 58.95
3.Gross profit 10.36 17.19 5.50 25.03 28.22 41.05
4.Overhead and Other Expenses 93.75 87.28 98.93 79.03 75.57 63.24
5.Operating profit 6.35 13.62 2.35 21.20 24.82 37.42
6.Financial expenses 0.91 0.44 0.87 1.23 0.99 1.85
7.Net profit before tax (D5-D6) 5.45 13.17 1.48 19.96 23.83 35.56
8.Tax provision 1.78 4.35 1.12 6.61 7.49 6.59
9.Total amount of dividend 3.21 0.00 2.03 0.00 0.00 0.00
10.Total value of bonus shares issued 0.00 0.00 6.77 0.00 6.99 3.16
(Million Rupees)
HORITONAL ANALSIS OF IS KOHAT CEMENT LTD. FROM 2001-2006
2001% 2002% 2003% 2004% 2005% 2006%
Gross sales 100 116.69 118.32 144.57 171.89 213.44
Cost of Sales 100.00 100.00 100.00 100.00 100.00 100.00
Gross profit 100.00 20.75 5.82 33.39 39.31 69.62
Overhead and Other Expenses 100 105.39 104.68 105.41 105.28 107.27
Operating profit 100 16.44 2.48 28.27 34.57 63.46
Financial expenses 100 0.54 0.92 1.64 1.37 3.14
Net profit before tax (D5-D6) 100 15.91 1.56 26.63 33.20 60.33
Tax provision 100 5.25 1.18 8.82 10.44 11.18
Total amount of dividend 100 0.00 2.15 0.00 0.00 0.00
Total value of bonus shares issued 0.00 7.17 0.00 9.74 5.37
NOTE: 2001 IS BASE YEAR FOR ALL EXCEPT FOR TOTAL VALUE OF BONUS SHARE ISSUED IN 2002
(Million Rupees)
HORITONAL ANALSIS OF IS DG KHAN CEMENT LTD. FROM 2001-2006
2001% 2002% 2003% 2004% 2005% 2006%
Gross sales 100 106.10 121.36 134.27 173.73 258.19
Cost of Sales 100.00 88.46 106.01 102.22 128.56 165.77
Gross profit 100.00 3095.58 2721.29 5564.26 7826.91 15914.86
Overhead and Other Expenses 100.00 89.04 106.78 104.72 132.14 171.56
Operating profit 100.00 477.12 451.30 793.10 1430.07 2299.00
Financial expenses 100.00 85.81 68.30 31.53 50.64 75.08
Net profit before tax (D5-D6) 100.00 -68.28 -82.52 -268.35 -492.55 -800.65
Tax provision 100.00 0.00 121.21 217.42 303.03 306.82
Total amount of dividend 0.00 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 0.00
29,625.2 34,864.8
19,586 39,747.6
49,211.2 74,612.4
1,028.5 1,028.5
5,527.1 4,904.6
25,541.1 52,484.4
32,096.7 58,417.5
81307.9 133029.9
13,280.3 25,569.8
4,287.3 6,005.8
8,993 19,564
12,155.9 15,640.2
2,156.4 3,517.8
27,592.6 44,727.8
31,905.4 44,407.3
64002.1 102824.8
-4,312.8 320.5
40,369.1 73,518
-18,625.1 -18,837.5
58,628.7 80,787.6
55,859.3 75,881.6
2,769.4 4,906
46,063.6 58,210.9
12,565.1 22,576.7
48,646.9 61,479.8
12,351.8 20,188.9
1,890.1 3,112.8
10,461.7 17,076.1
1,070.1 1,240.5
867.8 2,289
1,113.1 687.5
22,367.1 51,722
8,523.8 13,546.6
13,843.3 38,175.4
PROFITABILITY RATIOS
1 GROSS-P=GP/N.SALE*100
2 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 + Debentures +Long-term loans
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.SALE
5 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 OVERDRAFT
3 EQUITY RATIO=TOTAL OWNER EQUITY*100/T.ASSETS
ures +Long-term loans