Financial Analysis Of Dg Khan Cement Factory, Ratio Analysis

  • Uploaded by: M Fahim Arshed
  • 0
  • 0
  • May 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 Financial Analysis Of Dg Khan Cement Factory, Ratio Analysis as PDF for free.

More details

  • Words: 14,734
  • Pages: 57
Financial Analysis of DG Khan Cement Company Ltd.

Preface As the world is growing rapidly, the businesses are also moving to become the huge one. And by that result, more and more people want to become a master in these businesses. The main purpose in the finance field is to know how the financial analysis is done. We all know that finance is the blood of any business and without it no business can run. Financial analysis of a company is very difficult and the most important task and by doing this I am able to know the whole financial position and financial structure of the company. Simply by looking at how much cash a company has does not provide enough information. The financial statements need to be analyzed to measure a company’s performance and to compare it with other firm’s in the same industry. The resulting information is intended to be useful to owners, potential investors, creditors, analysts, and others as the analysis evaluates the past performance, future potential and financial position of the firm. This report is an analysis of financial statements of D.G. Khan Cement Company Ltd. This report has been prepared with an objective to develop analytical skills required to interpret the information (explicit as well as implicit) provided by the financial statements and to measure the company’s performance during the past few years. The financial statements are analyzed using traditional evaluation techniques such as horizontal analysis, vertical analysis and trend analysis. Ratios are an important tool in analyzing the financial statements & the company’s profitability, solvency & liquidity. Sincere attempts have been made to make this report error free but if any errors and omissions are found then I apologize for that.

Rabia Chaudhary

Page 1

Financial Analysis of DG Khan Cement Company Ltd.

Acknowledgement In the name of “Allah”, the most beneficent and merciful who gave us strength and knowledge to complete this report. This report is a part of our course “Financial Statement Analysis”. This has proved to be a great experience. I would like to express our gratitude to our Finance teacher Mr. Waseem Rabani who gave us this opportunity to fulfill this report. We would also like to thank our colleagues who participated in a focus group session. They gave us many helpful comments which helped us a lot in preparing our report.

Page 2

Financial Analysis of DG Khan Cement Company Ltd.

Table of Contents .................................................................................................................................... ....2 Table of Contents..................................................................................................... .............3 Introduction............................................................................................................ ...............5 Mission Statement.................................................................................................... .........5 Vision Statement........................................................................................ .......................5 D.G. Khan Cement Company Limited................................................... ............................5 NISHAT GROUP.................................................................................................... ........5 D.G. Khan Cement Company................................................................ ........................6 Acquisition of DGKCC by Nishat Group............................................................ .............6 Capacity Addition........................................................................................... ................6 Expansion -Khairpur Project.................................................................. ........................6 Power Generation............................................................................................... ...........7 Environmental Management......................................................................... .................7 BOARD OF DIRECTORS........................................................................... ...................7 Why cement sector for our project.............................................................................. .......7 INDUSTRY REVIEW......................................................................................................... ..10 Overview of income statement......................................................................... ...................11 Overview of Balance sheet.............................................................................................. ....11 Liquidity Position with Graphical Presentation................................................................... ..12 Liquidity Position.................................................................................. ...........................12 Activity Ratios........................................................................................................... .......13 Operating Cycle............................................................................................................. ..14 Debt Ratios....................................................................................... ..............................14 Profitability Ratios......................................................................................................... ...15 Profitability - Financial Year 2002 to Financial Year 2008 ...................................... ......16 Assets Utilization.............................................................................................. ...............17 Return on Investment.................................................................................... ..................19 Return on total equity............................................................................................ .......19 Investment Ratios......................................................................................................... ...19 Investment Ratios......................................................................................................... ...21 Univariate Model................................................................................................... ..............23 Multivariate Model....................................................................................................... ........24 DuPont Analysis .......................................................................................................... .......26 SWOT ANALYSIS............................................................................................ ...................27 Strengths............................................................................................................... ..........27 Weaknesses............................................................................................................ ........30 Threats............................................................................................................. ...............32 Opportunities....................................................................................................... ............33 Recommendations................................................................................................ ..............37 International Trend.............................................................................. ............................38 FUTURE OUTLOOK............................................................................... ........................39 Annexure................................................................................................. ...........................41 Summarized Income Statement.............................................................. ........................41 Summarized Balance Sheet............................................................................ ................45 Horizontal Analysis of Income Statements...................................................................... .46 Vertical Analysis of Income Statements................................................................ ...........46 Horizontal Analysis of Balance Sheet.............................................................. ................47

Page 3

Financial Analysis of DG Khan Cement Company Ltd. Vertical analysis of balance sheet................................................................................... .48 Liquidity Ratios.................................................................................................. ..............51 Long Term Debt Paying Ability.................................................................................. .......53 Profitability Ratios......................................................................................................... ...54 Assets Utilization............................................................................... ........................54 Investment Ratios......................................................................................................... ...56

Page 4

Financial Analysis of DG Khan Cement Company Ltd.

Introduction

Mission Statement To provide quality products to customers and explore new markets to promote/expand sales of the Company through good governance and foster a sound and dynamic team, so as to achieve optimum prices of products of the Company for sustainable and equitable growth and prosperity of the Company.

Vision Statement To transform the Company into modern and dynamic cement manufacturing company with qualified professionals and fully equipped to play a meaningful role on sustainable basis in the economy of Pakistan.

D.G. Khan Cement Company Limited NISHAT GROUP Nishat Group is one of the leading and most diversified business groups in South East Asia. With assets over PRs.300 billion, it ranks amongst the top five business houses of Pakistan. The group has strong presence in three most important business sectors of the region namely Textiles, Cement and Financial Services. In addition, the Group has also interest in Insurance, Power Generation, Paper products and Aviation. It also has the distinction of being one of the largest players in each sector. The Group is considered at par with multinationals operating locally in terms of its quality of products & services and management skills. Mian Mohammad Mansha, the chairman of Nishat Group continues the spirit of

entrepreneurship and has led the Group successfully to make it the premier business group of the region. The group has become a multidimensional corporation and has played an important role in the industrial development of the country. In recognition of his unparallel

Page 5

Financial Analysis of DG Khan Cement Company Ltd. contribution, the Government of Pakistan has also conferred him with “Sitara-e-Imtiaz”, one of the most prestigious civil awards of the country.

D.G. Khan Cement Company D.G. Khan Cement Company Limited (DGKCC), a unit of Nishat group, is the largest cement-manufacturing unit in Pakistan with a production capacity of 5,500 tons clinker per day. It has a countrywide distribution network and its products are preferred on projects of national repute both locally and internationally due to the unparallel and consistent quality. It is list on all the Stock Exchanges of Pakistan. DGKCC was established under the management control of State Cement Corporation of Pakistan Limited (SCCP) in 1978. DGKCC started its commercial production in April 1986 with 2000 tons per day (TPD) clinker based on dry process technology. Plant & Machinery was supplied by UBE Industries of Japan.

Acquisition of DGKCC by Nishat Group Nishat Group acquired DGKCC in 1992 under the privatization initiative of the government. Starting from the privatization, the focus of the management has been on increasing capacity as well as utilization level of the plant. The company undertook the optimization by raising the capacity immediately after the privatization by 200tpd to 2200tpd in 1993.

Capacity Addition To meet the increasing demand and to capitalize on its geographic location, the management further expanded the capacity by adding another production line with a capacity of 3,300 tons per day in year 1998. Design of the new plant is based on latest dry process technology, energy efficient and environmental protection from particulate pollution according to the international standards. The plant and machinery was supplied by M/s F.L. Smidth of Denmark. As a result, DGKCC emerged as the largest cement production plant in Pakistan with annual production capacity of 1,650,000 M tons of clinker (1,732,000 M.Tons Cement) constituting about 10% share of the total cement production capacity of the country. The optimization plan is still underway to increase the total capacity of the two units to 6700 TPD by mid of 2005 from 5500 TPD at present.

Expansion -Khairpur Project Furthermore, the Group is also setting up a new cement production line of 6,700 TPD clinker near Kalar Kahar, Distt. Chakwal, the single largest production line in the country. First of its kind in cement industry of Pakistan, the new plant will have two strings of preheater towers, the advantage of twin strings lies in the operational flexibility whereby production may be adjusted according to market conditions. The project will be equipped with two vertical cement grinding mills. The cement grinding mills are first vertical Mills in Pakistan. The new plant would not only increase the capacity but would also provide proximity to the untapped market of Northern Punjab and NWFP besides making it more convenient to export to Afghanistan from northern borders.

Page 6

Financial Analysis of DG Khan Cement Company Ltd.

Power Generation For continuous and smooth operations of the plant uninterrupted power supply is very crucial. The company has its own power generation plant along with WAPDA supply. The installed generation capacity is 23.84 MW.

Environmental Management DG Khan Cement Co. Ltd., production processes are environment friendly and comply with the World Bank’s environmental standards. It has been certified for “Environment Management System” ISO 14001 by Quality Assurance Services, Australia. The company was also certified for ISO-9002 (Quality Management System) in 1998. By achieving this landmark, DG Khan Cement became the first and only cement factory in Pakistan certified for both ISO 9002 & ISO 14001...

BOARD OF DIRECTORS •

Mrs. Naz Mansha

Chairperson/Director



Mian Raza Mansha

Chief Executive/Director



Saqib Elahi

Director



Khalid Qadeer Qureshi

Director



Mohammad Azam

Director



Zaka ud din

Director



Inayat Ullah Niazi

Director & Chief Financial Officer

Why cement sector for our project At the time of independence in 1947, only one or two units were producing grey cement in the country. During the decade of 1948-58, the number of cement units increased to six. During the Ayub era the economy started to grow and the construction activities underwent a boom. To meet the growing demand of cement new units were set up. During the decade of 1958-68, the number of cement units increased from 6 to 9. During the following period of Zulfiqar Ali Bhutto all the industrial units, including cement industry, were nationalized, therefore, no new unit was set up during 1971-77. During the period of General Zia-ul-Haq, 1977-88, denationalization of industrial units boosted the investments. Housing and construction industries picked up and the demand for cement increased. Thus, the number of cement units increased from 9 to 23 and finally 24. The cement industry in Pakistan has become a long way since independence when country had less than half a million tones per annum production capacity. By now it has exceeded 10 million tones per annum as a result of establishment of new manufacturing facilities and expansion by existing units. Privatization and effective price decontrol in 1991-92 heralded a new era in which the industry has reached a level where surplus production after meeting local demand is expected in 1997.

Page 7

Financial Analysis of DG Khan Cement Company Ltd. The cement industry is needed a highly important segment of industrial sector that plays a pivotal role in the socio-economic development. Through the cement industry in Pakistan has witnessed its lows and high in recent past, it has recovered during the last couple of years and is buoyant once again. There are total number of units are 23, from which 4 units are in the public sector while the remaining 19 units are owned by the private sector. Two of the four units in the public sector had to close down their operations due to stiff competition and heavy cost of production. The cement plants are located in every province of Pakistan. The province-wise distribution of cement plant is as under. Providence Punjab Sindh NWFP Baluchistan Total

Units 8 8 6 1 23

Capacity (Million Tons) 7.488 3.851 4.945 0.758 17.040

Three additional cement plants with installed capacity of over 2.1 million tons are in the final stage of completion despite the available excess capacity in this sector. The following table shows installation of new cement factories and expansion of the existing facilities during the current decade.

Page 8

Financial Analysis of DG Khan Cement Company Ltd. The industry is divided into two broad regions, the northern region and the southern region. The northern region has over 87 percent share in total cement dispatches while the units based in the southern region contributes 13 percent to the annual cement sales. Name of company Northern Region Askari Cement Askari cement Bestway cement D.G Khan cement Fauji cement Lucky cement Maple Leaf cement Pioneer cement Sub-Total Southern Region Essa cement Total

New/ Expansion

Year Commission

of

New Capacity Created(Tons)

Expansion New New Expansion New New Expansion New

1964 1996 1988 1988 1997 1996 1998 1994

945,000 630,000 1,039,500 1,039,500 945,000 1,260,000 1,039,500 630,000 7,528,500

Expansion

1988

315,000 7,843,500

Page 9

Financial Analysis of DG Khan Cement Company Ltd.

INDUSTRY REVIEW The cement industry of Pakistan again set a new record and sold 30.112M tons during FY 2008 against 24.222M tons last year, with a growth of over 24%. During the period under report the capacity utilization of the industry was 81% against 79% last year. The slight increase in capacity utilization is due to the fact that during the year industry added another 6.5M tons of new capacity. Pakistani Cement industry fully tapped the export prospects of cement and managed to export hefty 6.610M tons against 2.797M tons last year. The cement manufacturers fully poised to explore new export markets. Contrary to past, now the cement is being exported not only to regional neighboring countries, rather Pakistani cement is finding its place in South East Asian countries, Russia and in African countries as well. Clouds of recession are hovering over the economy of Pakistan and having achieved consecutive growth of over 6% in real GDP during last four years, economic growth slowed down to 5.8% in FY 2008 against 6.8% recorded last year. Demand of cement is directly related with prevailing economic conditions. During FY 2008 cement sales in the country remained bleak due to uncertainty in political and economic front coupled with fading law and order situation. Total sales in the country were 22.395M tons against 21.034M tons last year, witnessing an increase of only over 6%. Dilemma of price war among the cement manufacturers to find out the market share has badly affected the financial health of the

cement sector. In addition, all time high oil and coal prices coupled with expanding inflationary trend in the country hit badly the cost of production. Going forward, monetary tightening stance of the State Bank of Pakistan to curb inflation in the country posed additional burden in the form of increased lending rates.

Page 10

Financial Analysis of DG Khan Cement Company Ltd.

Overview of income statement Overview of Income statement Sales

2008 12,445,996

Cost of sales

-10,530,723

Gross profit Administrative expenses Selling and distribution expenses Other operating expenses Other operating income Profit from operations Finance cost Share of loss of associated companies Profit\ Loss before tax

1,915,273 -111,658 -561,465 -581,913 847,344 1,507,581 -1,749,837 -8,674 -250,930

2007 6,419,625 -4,387,64 0 2,031,985 -104,169 -65,122 (139,721 479,420 2,202,393 -467,759 -14,163 1,720,471

Taxation

197,700

-98,000

Profit\ Loss for the year Basic earnings per share Rupees Diluted earnings per share

-53,230 -0.21

1,622,471 6.43 6.43

2006 7,955,665 -3,992,82 2 3,962,843 -121,953 -34,352 -191,850 294,114 3,908,802 -450,696 -9,573 3,448,533 -1,030,07 8 2,418,455 10.37 9.14

2005 5,279,560 -3,330,76 9 1,948,791 -76,480 -60,905 -93,786 707,692 2,425,312 -304,041

2004 3,882,756 -2,497,26 2 1,385,494 -68,645 -38,560 -61,735 128,462 1,345,016 -224,601

2,121,271

1,120,415

-439,193

-325,922

1,682,078 9.12 7.82

794,493 4.31 3.78

Overview of Balance sheet Overview of Balance sheet

2008

2007

2006

2005

2004

30528440

33923185

19268200

9317998

6317055

Non-current Liabilities

10250352

10430917

9020740

5642649

3020575

Current Liabilities

12899306

7390229

6015436

3055858

2376989

Non-current Assets

33835927

32529377

24394481

13819736

8833476

Current Assets

19842171

19214954

9909895

4196769

2881143

Capital and Reserve

Assets

Page 11

Financial Analysis of DG Khan Cement Company Ltd.

Liquidity Position with Graphical Presentation Liquidity Position Liquidity Position

2008

2007

2006

2005

2004

Current Ratio Acid Test Ratio Cash Ratio

1.54 1.22 1.18

2.60 2.33 2.31

1.65 1.44 1.43

1.37 0.96 0.94

1.21 0.64 0.62

3 2.5 2

current ratio

1.5

acid test ratio cash ratio

1 0.5 0 2008

2007

2006

2005

2004

The liquidity position of DGKC deteriorated during the first nine months of FY'09. This was due to a 40% decrease in current assets and a 14% increase in current liabilities if the company. The current liabilities of the company increased due to 14% rise in trade payables, 61% increase in accrued markup and around 7% increase in short term borrowing by the company. On the other hand, current assets of the company declined due to decrease in investments from Rs 15 billion at the end of FY08 to Rs 7 billion at the end of March FY09. Also the cash and bank balance of the company decreased by 22%. Thus, decrease in current assets and a corresponding increase in current liabilities resulted in a less favorable liquidity position as compared to that in FY08. DGKC's liquidity stance had been strengthening since FY04 and in FY07 its liquidity position was the most favorable. The increase in current assets had brought about this change. There was a 98% increase in short term investments. Furthermore, the cash and bank balances had also risen considerably. In FY08 the current assets of the company declined slightly but a 63% rise in current liabilities caused a decrease in the liquidity of the company. Investments constitute nearly 79% of the company's total current assets and they declined by 11% in FY08. The investments decreased further from Rs 15 billion at year-end FY08 to Rs 10.9 billion by end of 1Q09.

Page 12

Financial Analysis of DG Khan Cement Company Ltd.

Activity Ratios Activity Ratios Days Sales in Receivables Account Receivables Turnover Account Receivables Turnover in Days

2008

2007

2006

2005

2004

13.57 days

8.20 days

3.40 days

5.27 days

4.95 days

41.02 times

58.78 times

105.79 times

81.94 times

73.78 times

8.89 days

6.20 days

3.45 days

4.45 days

4.94 days

120 100

days sales in receivables

80

A/R turnover

60 40

A/R turnover in days

20 0 2008

Activity Ratio Inventory Turnover in days Inventory Turnover

2007

2006

2005

2004

2008

2007

2006

2005

2004

27.66 days

21.69 days

14.96 days

21.89 days

43.63 days

13.19 times

16.83 times

24.40 times

16.67 times

8.36 times

Page 13

Financial Analysis of DG Khan Cement Company Ltd. Days Sales in Inventory

45.08 days

24.55 days

20.68 days

11.07 days

43.63 days

Operating Cycle Activity Ratio Operating Cycle

2008

2007

2006

2005

2004

36.55days

27.89 days

18.41 days

26.34 days

48.58 days

60 50 40 30

operating cycle

20 10 0 2008

2007

2006

2005

2004

Debt Ratios Debt Ratios Debt to Tangible net worth Debt To Equity Ratio Debt Ratio

2008

2007

2006

2005

2004

77

52

78

93

85

76

53

78

93

85

43

34

44

48

46

Page 14

Financial Analysis of DG Khan Cement Company Ltd.

250 200 debt to tangible networth

150

debt/equity ratio

100

debt ratio

50 0 2008

2007

2006

2005

2004

The debt management ratios of DGKC showed a positive trend during FY07. The debt to asset and equity ratios as well as the long-term debt ratio all receded during the period and this reflected a reduction in the company's dependence on debt financing. However, during FY08 the debt ratios of the company rose because the total debt increased in FY08 mainly due to a 63% increase in the current liabilities which form 55% of the total debt. Long term debt however decreased. The long term debt to equity increased because of a decline in the equity base due to fall in reserves. The TIE ratio continued to fall in FY08 against a positive trend that prevailed before FY07. The reason is substantial rise in finance charges due to high interest rates in the economy. Also the operating income in FY08 decreased, thus reducing the extent to which operating income can decline before the firm is rendered unable to meet its interest costs. Due to the losses that DGKC experienced in FY08 and the decrease in profitability during July-March FY09, its Earning per Share (EPS) and Price to Earning (P/E) Ratio have been negative. During July-May 2009 the share price averaged around Rs 31.1. This shows that the dismal profits of the company have started reflecting in the low investor confidence and falling share price. The average share price of DGKC had hovered around Rs 100/share except during the fourth quarter of FY08 when share price fell well below the average. The management did not recommend any dividend for FY08 due to the dismal profitability situation in the period.

Profitability Ratios Profitability Ratios

2008

2007

2006

2005

2004

Gross Profit Margin Operating Profit Margin Net Profit Margin

15 12 7.84

32 34 25

49 49 31

37 46 31

36 35 20

Page 15

Financial Analysis of DG Khan Cement Company Ltd.

140 120

gross profit margin

100 80 60

operating income magin

40

net profit margin

20 0 2008

2007

2006

2005

2004

After experiencing declining profitability during FY08, the cement sector came back strongly to post a growth of 167% in earnings during first quarter (July-September) of fiscal year 2009. The cement sector posted profit after taxation of Rs 1.3 billion in first quarter of FY09 as compared to Rs 500 million in the corresponding period of a year earlier. This growth was mainly due to higher local retention prices and depreciation of the rupee against the dollar that resulted in an increase of rupee-based export sales. The net sales of the cement sector in the period July-March FY09 was 58% higher than the net sales generated during the corresponding period of FY08. It is believed that the profits of cement companies increased due to an arrangement among them to keep prices high in the local market. However, higher sales revenue could not be translated into an increase in profits during the period. Increased costs of sales, operating expenses and finance expenses caused the profitability of DGKC to remain low during July-March FY09. The cost of sales of the company increased by 30% during the period and resulted in a gross profit of Rs 3,733 million. The furnace oil/coal costs for the period July-March FY09 was Rs 5,258.6 million as compared to Rs 3,095.7 million during the corresponding period of FY08. The electricity and gas costs were lower, however, the cost of raw material and packing material consumed increased by 12%. The administration expenses increased by 31% while the selling & distribution expenses increased drastically by 456% (from Rs 246 million in JulyMarch FY08 to Rs 1,370 million in July-March FY09). Selling expenses may have increased due to higher transportation costs involved with exports and higher fuel costs. Also, the finance costs increased substantially by 77% as interest rates rose owing to tight monetary policy and liquidity crunch in the market. These rising costs greatly hampered the profitability of the company and resulted in a profit after taxation of Rs 321 million in the period July-March FY09, which is 34% lower than the profit (Rs 487 million) during July-March FY08. Therefore, the earning per share (EPS) of the company declined from Rs 1.92 in July-March FY08 to Rs 1.27.

Profitability - Financial Year 2002 to Financial Year 2008 The profitability ratios of the company have shown a declining trend since after FY05. The gross profit margin increased in FY06 only to fall in FY07 and FY08. The profit margin of

Page 16

Financial Analysis of DG Khan Cement Company Ltd. the company has decreased continuously along with return on assets (ROA) and return on equity (ROE). The profit after taxation had declined by 33% in FY07 due to lower net retention prices caused by a supply overhang in the overall industry. Also the problem of rising input costs had begun in FY07. This rise in cost of production and raw material have continued into FY08 and further aggravated, causing the declining trend of the profitability of DGKC. Despite a strong growth in cement dispatches, the cement sector experienced declining profitability during FY08. The profitability of the sector fell by 73.6% to Rs 562 million till March 2008 from Rs 2,133 million in the corresponding period of FY07. Although the sales volume of the cement companies increased, the net sales revenue did not increase to an equal extent due to decrease in net retention prices in the sector. Over the years all cement manufacturers undertook huge capacity expansion plans. This created a situation of excess supply in the market. Companies resorted to price wars leading to a fall in prices and reduced the profit margins for the companies. The average cement price during the period July-March FY08 was Rs 128.3 per bag as compared to Rs 133.6 per bag in the same period in FY07. Similar was the case with DGKCC. Increased production facilitated higher sales volume which in turn translated into almost doubling of sales revenue in FY08. The company had earned the highest sales revenue of Rs 12.445 billion in FY08. However, despite this, the gross profit of DGKC in FY08 (amounting to Rs 1.9 billion) was around 6% lower than the gross profit posted in FY07 (Rs 2.0 billion). The reason for lower gross profit was a 140% increase in the cost of sales during the fiscal year. Major input costs increased and dampened the profitability of DGKC and resulted in a loss after taxation of Rs 53.230 million in FY08 against a profit after taxation of Rs 1.622 billion in FY07. The cement manufacturers in the industry were faced with rising fuel and power costs during FY08. The cost of production for the cement companies went up due to rise in the prices of imported coal. The cement companies in Pakistan have shifted from oil to coal or gas during the past few years. Coal is now used as a basic fuel by all cement manufacturers. Pakistan has huge reserves of coal, but cement companies are compelled to import it, as local coal has high sulphur content. Crude oil prices shot up during FY08 and had its impact on prices of coal and natural gas. The rise in the costs of international coal prices has been one of the biggest reasons behind the dampening of gross margins of cement companies during FY08. There was a nearly 50% rise in the coal prices in FY08 Along with the hike in the international coal prices, the depreciation of the rupee against the dollar also added to the cost of importing coal. Finance charges rose due to higher interest rates, long term finances, short term borrowing and inclusion of workers' profit participation fund in FY08.

Assets Utilization Asset Utilization Sales to Fixed Assets Return on Operating Assets Operating Asset turnover Return on Assets

2008 54

2007 43

2006 108

2005 80

2004 62

24

33

10

13

11

20

9.6

20

28

33

18.5

3.8

23

11

6.60

Page 17

Financial Analysis of DG Khan Cement Company Ltd.

250

sales to fixed assets

200 150

return on operating assets

100

operating assets turnover return on assets

50

total asset turnover

0 2008

2007

2006

2005

2004

The performance of DGKC in terms of asset management was weak during FY07. During the year, the inventory turnover (days) of the company more than doubled compared to FY06 when the management of inventory seemed most efficient (evident from the lowest inventory turnover in days). This could be traced back to lower sales revenue for the period, coupled with a higher stock of inventory. At the same time, the average time taken by the company to recover cash from sales also increased. The increase in inventory turnover in days and Days sales outstanding (DSO) prolonged the operating cycle of the company in FY07. However, in FY08 the asset management of DGKC improved as the inventory turnover rate increased because the company earned sales revenue more in proportion to the increase in inventory. Thus the days to convert inventory into sales became less (from approx. 100 days in FY07 to 79 days in FY08). Although the days to convert sales into cash (DSO) increased slightly, the substantial decrease in ITO (days) led to the shortening of the operating cycle in FY08. The days sales outstanding was higher because the trade debt increased substantially (by 153%) during FY08 as against sales. Besides this the sales to equity and total asset turnover of the company which had a declining trend till FY07 increased in FY08. The sales to equity ratio had been decreasing because of an increase in the paid up capital. But the trend was reversed in FY08 because the paid up capital remained same while the reserves fell, causing a decrease in the equity base of the company. Also higher growth in sales increased the sales/equity ratio. Total asset turnover also improved because the management of the company's assets was effective in generating higher sales revenue. The company's performance in the area has improved as full-scale production from the newly inaugurated Khairpur plant has augmented the sales.

Page 18

Financial Analysis of DG Khan Cement Company Ltd.

Return on Investment Return on total equity Return Ratios Return on Investment Return on Total Equity

2008

2007

2006

2005

2004

2.92

5.34

12.58

15.47

10.07

0.30

0.37

17

22

13

25 20 15

Return on investment Return on total equity

10 5 0 2008

2007

2006

2005

2004

One of the most important profitability metrics is return on equity [or ROE for short]. Return on equity reveals how much profit a company earned in comparison to the total amount of shareholder equity found on the balance sheet. If you think back to lesson three, you will remember that shareholder equity is equal to total assets minus total liabilities. It's what the shareholders "own". Shareholder equity is a creation of accounting that represents the assets created by the retained earnings of the business and the paid-in capital of the owners. The return on Equity has decreased drastically and there is quite a hell of decrement in ROE, which is not very much encouraging for the investors in shares.

Investment Ratios • • •

Degree of financial leverage Earning per common shares Price earning ratio

Page 19

Financial Analysis of DG Khan Cement Company Ltd.

Investment ratios

2008

2007

2006

2005

2004

Degree of financial leverage

15.48

1.27

1.13

1.14

1.20

Earning per common shares

0.017

0.60

0.10

0.76

0.35

258.08

4.81

3.38

3.96

8.19

Price earning ratio

100% 80%

Price earning ratio

60%

Earning per common shares Degree of financial leverage

40% 20% 0% 2008

2007

2006

2005

2004

A leverage ratio summarizing the affect a particular amount of financial leverage has on a company's earnings per share (EPS). Financial leverage involves using fixed costs to finance the firm, and will include higher expenses before interest and taxes (EBIT). The higher the degree of financial leverage, the more volatile EPS will be, all other things remaining the same. Most likely, the firm under evaluation will be trying to optimize EPS, and this ratio can be used to help determine the most appropriate level of financial leverage to use to achieve that goal. The company’s ratio ha increased dramatically in the year 2008 by 15 times. So there is quite a margin for company to get leveraged. The portion of a company's profit allocated to each outstanding share of common stock. Earnings per share serve as an indicator of a company's profitability. Earnings per share are generally considered to be the single most important variable in determining a share's price. It is also a major component used to calculate the price-toearnings valuation ratio. The EPS of company is fluctuating but in current year it has decreed drastically which is not a good sign for share holders. An important aspect of EPS that's often ignored is the capital that is required to generate the earnings (net income) in the calculation. Two companies could generate the same EPS number, but one could do so with less equity (investment) - that company would be more efficient at using its capital to generate income and, all other things being equal would be a "better" company. Investors also need to be aware of earnings manipulation that will affect the quality of the earnings

Page 20

Financial Analysis of DG Khan Cement Company Ltd. number. It is important not to rely on any one financial measure, but to use it in conjunction with statement analysis and other measures. A valuation ratio of a company's current share price compared to its per-share earnings is Price Earning ratio. In general, a high P/E suggests that investors are expecting higher earnings growth in the future compared to companies with a lower P/E. However, the P/E ratio doesn't tell us the whole story by itself. It's usually more useful to compare the P/E ratios of one company to other companies in the same industry, to the market in general or against the company's own historical P/E. It would not be useful for investors using the P/E ratio as a basis for their investment to compare the P/E of a technology company (high P/E) to a utility company (low P/E) as each industry has much different growth prospects. The P/E is sometimes referred to as the "multiple", because it shows how much investors are willing to pay per dollar of earnings. It is important that investors note an important problem that arises with the P/E measure, and to avoid basing a decision on this measure alone. The denominator (earnings) is based on an accounting measure of earnings that is susceptible to forms of manipulation, making the quality of the P/E only as good as the quality of the underlying earnings number.

Investment Ratios • • •

Dividend payout ratio Dividend yield ratio Book value per share

Investment ratios

2008

2007

2006

2005

2004

Dividend payout ratio

19.83

23.62

48.31

28.37

27.74

7.68

4.90

14.23

7.17

3.38

18.74

20.87

16.62

7.80

5.29

Dividend yield ratio Book value per share

Page 21

Financial Analysis of DG Khan Cement Company Ltd.

60 50 40

Dividend payout ratio

30

Dividend yield ratio

20

Book value per share

10 0 2008

2007

2006

2005

2004

Indicates the proportion of earnings that are used to pay dividends to shareholders. A reduction in dividends paid is looked poorly upon by investors, and the stock price usually depreciates as investors seek other dividend paying stocks . A stable dividend payout ratio indicates a solid dividend policy by the company's board of directors. The situation of DG Khan Cement Co. Ltd. Shows increment in 2006 but from there is consistent decrement in this ratio by more than two times so company is trying to build there retained earnings instead of giving dividend. During bull markets the stock price is more likely to trade significantly higher than book value, and in a bear market the two values may be close to equal. The dividend yield or the dividend-price ratio on a company stock is the company's annual dividend payments divided by its market cap, or the dividend per share divided by the price per share. It is often expressed as a percentage. There is quite fluctuations in this ratio which shows there is lack of stability in the company policy towards this section. Now if we look at the book value per share, as we know that somewhat similar to the earnings per share, but it relates the stockholder's equity to the number of shares outstanding, giving the shares a raw value. Comparing the market value to the book value can indicate whether or not the stock in overvalued or undervalued. During bull markets the stock price is more likely to trade significantly higher than book value, and in a bear market the two values may be close to equal.

Page 22

Financial Analysis of DG Khan Cement Company Ltd.

Univariate Model 1. Cash flow/Total debt Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) (641970)/23149658 475661/17821146 4190452/15036176 2484759/8698507 945521/8698507

Values -2.773% 2.67 27.869 28.57 10.8

2. Net Income/Total Assets (Return on Assets) Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) 25685/53678098 1622471/51744331 2418455/34304376 1682078/18016505 794493/11714619

Values 0.047% 3.13 7.05 9.34 6.78

3. Total debt/Total Assets (debt ratio) Year Calculation in (Rupees’ 000) 2008 23149658/53678098 2007 17821146/51744331

Values 43.13% 34.44

2006 15036176/34304376 2005 8698507/18016505 2004 5397564/11714619

43.83 48.28 46.07s

Page 23

Financial Analysis of DG Khan Cement Company Ltd.

Multivariate Model X1= Working Capital/Total Assets Year 2008 2007 2006 2005

Calculation in (Rupees’ 000) 6942865/53678098 11824725/51744331 3894459/34304376 1140911/18016505

X1 12.934% 22.85 11.35 6.33

2004

504154/11714619

4.30

X2=Retained Earning/Total Assets Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) 30202533/53678098 33923185/51744331 19259849/34304376 9317998/18016505 6317055/11714619

X2 56.27% 65.56 56.144 51.72 53.9

X3=EBIT/Total assets Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) 1513505/53678098 2202393/5174 3908802/34304376 2425312/18016505 1345016/11714619

X3 2.82% 4.26 21.69 13.46 11.48

X4= Market value of equity/Book value of total debt Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) 253541157*30.97/23149658 253541157*30.97/17821146 184393569*30.97/1503176 184393569*30.97/8698507 167630518*30.97/5397564

X4 339.19% 440.60 379.79 656.51 961.82s

X5=Sales/Total Assets Page 24

Financial Analysis of DG Khan Cement Company Ltd.

Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) 12464347/53678098 6419625/51744331 7955665/34304376 5279560/18016505 3882756/11714619

X5 23.22% 124.79 23.19 29.30 33.14

Page 25

Financial Analysis of DG Khan Cement Company Ltd.

DuPont Analysis 1. Dupont Return on Assets=Net profit margin*Total assets turnover Year

Calculation in (Rupees,000)

2008 2007 2006 2005 2004

7.84*0.24 0.25*0.15 0.31*0.74 0.31*0.35 0.20*0.33

Dupont Return on Assets 1.88 3.75 22.94 10.85 6.60s

DuPont return on Assets has a decreasing trend. In 2008 net profit of co decrease due to high cost of goods sold. Co does not utilize its assets properly in 2008. In 2007 trend of this ratio is good. But in last 3 years it also has increasing trend.

2. DuPont returns on Operating Assets Year

Calculation in (Rupees,000)

Dupont Return on operating Assets

2008 2007 2006 2005 2004 DuPont return on Operating Assets decrease in 2008 as compare to 2007. Co utilizes its operating assets in 2007 as compare to 2008. Co invests in more long term investments. It is necessary for the co to change its policy.

Page 26

Financial Analysis of DG Khan Cement Company Ltd.

SWOT ANALYSIS Strengths 1. Availability of Raw Material. 2. Imported Machinery and plants in most of companies, which provide better quality to over all process. 3. During fiscal year 2007-08, country exports stood at 7.712 million tones ($435 million) and Pakistan has already established its position as an exporter of cement and clinker in the region, Sources said the industry projections suggested that the cement industry exports would reach to $735 million by the end of 2008-09 and it would touch $1.043 billion by the end of 2009-10. 4. Availability of foreign investment and loans has also played an important role in softening the demand for bank credit. The moderation in fixed investment demand in cement, construction and textile is more of a reflection of the fact that these industries had already expanded their capacities in recent years and floatation of debt instruments (e.g., chemical, cement, real estate and ship yard) in the domestic market cement, real estate and ship yard) in the domestic market 5. The compressive strength is a very important factor of cement. The Portland cement achieves its maximum strength in 28 days. The Pakistan standard PSS 232-1883 (R) & British Standard BS 12: 1978 provides for 28 days strength of 5000Psi and 5950Psi respectively for mortar cubes. 6. Cement industries in Pakistan are currently operating at their maximum capacity due to the boom in commercial and industrial construction within Pakistan. 7. Effect of GDP Following effects of GDP will govern the growth of cement industry in Pakistan 1. Higher GDP growth has positive impact on cement demand 2. Cement demand growth rate was double the GDP growth rate in last three years 3. GDP growth is expected to continue to have same positive impact on demand growth 8. Housing demand to grow: Following indications have showed a considerable demand of cement in Pakistan: • Housing projects consume roughly 40% of cement demand • Currently 0.3mn houses are built annually against demand of 0.5mn • Low interest rates, post 9/11 remittances’ inflow, and real estate boom have helped housing sector growth

Page 27

Financial Analysis of DG Khan Cement Company Ltd. •

Easy mortgage availability and announcement of low cost housing schemes will determine housing sector growth in the long-run. 9. Government’s development spending shall continue to rise due to: •

Government development expenditures count for one third of total cement consumption



Increase in development expenditures has helped cement demand to grow at very high rates



Increase in PSDP- as announced in Medium Term Development Framework 2005-10 will help cement demand to grow in the country



Infrastructure development in a region triggers private development projects having even positive impact on cement demand

10.Pakistan cement industry is one the largest exporter in Asia, major markets are of Afghanistan and Iraq will be after peace. It’s increased GDP by exports, providing cements in Large Dams Project and earthquake rehabilitations projects. 11.Laboratory testing facilities meeting all American and European standards and Vertical cement grinding mills. 12. Cement industry called major Performance Blue Chip in current economic survey 2007-08 because during the first three quarters of the fiscal year 200708, the combined paid-up capital of ten big companies was Rs. 91 billion, which

Page 28

Financial Analysis of DG Khan Cement Company Ltd. constituted 13.17 percent of the total listed capital at KSE in which Fauji Fertilizer, DG Khan Cement, Lucky Cement played major role. 13. Today, we find a relatively better scenario as compare to past. Most of the cement plants, that used to operate on furnace oil, have now been converted into coal system, which has substantially reduced cost of production. 14. The most modern selection of production equipment possible in every major department of the plant. 15. Cement export to India through railway • Most of the cement export to India is through railway. In order to facilitate cement export to India, the railways has doubled its cement capacity and increase its frequency of trains to India from Pakistan. This step has been taken by Pakistan Railways in order to increase cement export to India. Which is regarded as a highly profitable market? 16. Use of Coal •

Coal is found in all the four provinces of Pakistan. The country has huge coal resources, about 185 billion tones, out of which 3.3 billion tones are in proven/measured category and about 11 billions are indicated reserves, the bulk of it is found in Sindh.



At present most of the cement companies have switch to coal or gas as their basic fuel; the process has been completed in the last 6 to 7 years. According to the data of the All Pakistan Cement Manufacturing Association of mid-2007, the cost of cement production per tone by furnace oil was around Rs2, 083 whereas the cost of production per tone by coal was Rs8, 68, saving Rs1, 215 per tone. Similarly, the saving per bag was Rs60.75, which is a huge difference. Reserves of coal can become strength for Pakistani cement industry if Pakistan import sulphur washing plant from European country than Pakistan cement industry is able to utilize local coal to meet its energy requirement

17. Cheaper labor •

The labor of Pakistan is very cheap. This is the important strength of the cement industry as the cement companies of Pakistan has to pay less to there labor which result in saving of there income which later on can be utilized in the expansion of cement plant. Which will increase the cement production?

18. Good Domestic and Foreign Market •

The export may reach to $ 500 million increase during 2008. Data for the first quarter of FY08 shows that Afghanistan is Pakistan’s largest cement export market. The prospects for cement exports seem bright in the medium term due to rising domestic as well as regional cement demand.

Page 29

Financial Analysis of DG Khan Cement Company Ltd. 19. Good Government Policies •

Government policies are in the favor of cement sector. Due to the government favorable policies the cement sector gets the highest growth rate of 21.11% among all the industries of Pakistan in year 2006-07. The total industry installed capacity is expected to reach 49.1 million tons per annum by FY10

20. High Quality of Cement •

Pakistan produces good quality of cement. This is the main reason due to which recently Russia is offering high price for Pakistani cement. Globally Pakistan is recognized for producing good quality of cement due to which countries like Afghanistan, India, Middle East and some African countries prefer to import cement from Pakistan.

Weaknesses 1. The stage of industrial development, in most of the segments, is still at a very low level of technology and the existing industrial base is very narrow and consists of very basic industries such as cement, sugar, textile, cigarette, edible oil, fertilizer, soda ash, caustic soda, PVC etc. 2. Since cement is a specialized product, requiring sophisticated infrastructure and production location. So, most of the cement industries in Pakistan are located near/within mountainous regions that are rich in clay, iron and mineral capacity. Structure of Cement industry in Pakistan is as such that there is not much substitutability to buyers. Which shows that the Cross elasticity of demand is negligible. 3. The customer has no choice at all to switch between two brands of cement due to cartel of all of the cement manufacturers in Pakistan. 4. The freight charges are a massive 20% of the retail prices. The plants located very close to each other and tapping the same market will have to expand their markets which will increase their freight expenses. Dandot, Pioneer, Maple Leaf and Garibwal are all located within a radius of 100 kilometers and are selling bulk of their production in the same areas and will thus face serious competition from each other. 5. Consumers face a tough decision with regards to prefer which brand over which because of the similar pricing of cement industry. The formation of cartel by the cement manufacturers have exploited local consumers a lot and this has led to the concentrated degree of oligopoly, where the firms are acting as a single unit to perform their monopoly. Their combined market power is simply a diluted version of the dominance that a single firm with a monopoly market share can exert. 6. Increase freight charges •

Exporters of the cement often complain that railways freight charges for carrying cement from Lahore city to the border of India are Rs500 per ton Page 30

Financial Analysis of DG Khan Cement Company Ltd. ($8 per ton) while it covers only 35 km. Against this, they say on the Indian side, the freight is only $3 per ton for bringing goods from Chundrigar to the border area. Cement exports have been badly hit by high fee that is being charged by trucks and also by foreign shipping companies for the haulage of cement from Pakistan to India. This increase in freight charges effect our exports due to which our exports is declining 7. Logistic Problem •

Some of the cement companies of Pakistan have received orders from Russia with a price tag of Rs 860 per bag. But our logistics is the biggest hurdle in the way as our transportation system is not good enough to transport cement to Russia due to which our cement companies might lose the chance to capture the Russian market which is a highly profitable market.

8. Usage of Paper bag •

Pakistani cement companies export there cement in paper bags because paper bags are cheap as compared to plastic bags. But the Cement exported in paper bags is against the International standards and companies have to pack the cement in plastic bag. The cement export to India could be affected by the shortage of plastic bags used for transporting the commodity. Although there are two companies that are manufacturing plastic bags for cement but they are not able meet the demand. So that’s why Pakistan cement companies export cement in paper bags.

9. Idle capacity of various players: •

The biggest problem of cement industry is the idle capacity of various players. As many cement players are not operating at there full capacity.

Page 31

Financial Analysis of DG Khan Cement Company Ltd.

Threats 1. Unanticipated increase in interest rates or less than expected demand growth might create severe crises for the sector couple of years forward 2. Lack of demand or depressed demand in future will prove to be lethal for the sector that has just started to recover from the miseries of 90s. Lack of demand forced cement units to operate at very low capacity utilization in nineties. There was a fierce competition among cement manufacturers. 3. A price war was witnessed which ended up with no conqueror. Similar apprehensions exist for the future when there will be plenty of excess capacity. Any hurdle in the growth of cement demand may force the sector into the price war. Yet, we expect cement manufacturers to act prudent and learn lesson from the history. Any mistake, similar to the one made in the last decade, will again coerce the sector into the era where all are losers with no winner. 4. Main component of the cost is fuel. Pakistan's cement industry has converted their plants to coal considering it to be the cheapest fuel, but its price in international markets has gone up by more than 300 per cent in the last one year, which directly relate increasing the cost of production. 5. The demand of cement falls heavily during rainy weather in the country, which directly affects the running cost of a unit. It is only the rising levels of cement exports, which are sustaining the industry. 6. Instead of appreciating the marketing skills of cement entrepreneurs to explore new markets for cement, the industry is being pressurized constantly without realizing that any reduction in cement exports from Pakistan will not only deprive the country of foreign exchange ($2 billion this year), but will also result in losses to the industry. 7. The burden of increased input costs has to be borne by the consumers. It is only the government, which can provide relief to the consumers by cutting down or abolishing the central excise duty. 8. Problems of oversupply situation: Following problems might arise with the oversupply situation in cement industry: •

Lower capacity utilization will reduce benefits of economies of scale. High leverage will also adversely affect profitability of new plants.



New plants will gain market share at the cost of older players, which are not undergoing expansion. Large idle capacity is will create panic in players and this may result in price wars in the coming years.

9. IMF Package in Future can cause to decrease GDP and economical development in Pakistan. Which will also be cause to stop development of infrastructure? So it will have huge effect on cement industry also. 10. Indian and Iran industry is also expanding its cement capacity •

Presently, India faces an acute cement shortage in its Southern states of Tamilnado and Madras and in north Punjab. However, reports indicated that the Indian industry is also working on a fast track to expand their Page 32

Financial Analysis of DG Khan Cement Company Ltd. capacity in these regions to off-set the shortfall Major capacities of countries like India and Iran are expected to come online by FY10 and onwards which are likely to convert these countries from dependent importers to potential exporters. 11. High energy prices •

Recently cement industry of Pakistan is facing high energy prices due to increase in the international prices of coal and oil. As our coal contain high percentage of sulphur. Due to which Pakistan cement industry is not able to use local coal as a source of energy. Due to which Pakistan cement industry has to import coal from different countries at high prices. High finance and depreciation cost as Pakistan cement industry is expanding its capacity to get the proper advantage of strong demand of cement in different countries. The total industry installed capacity is expected to reach 49.1 million tons per annum by FY10 and because of higher expansion finance and depreciation cost is also going to rise by the FY10.

12. Decrease profitability due to competition in cement industry •

The sharp decline in cement prices has been witnessed due to domestic competition among producers has dampened the profitability of the industry. This increase in competition among the players has further decreased the prices of cement in the local market. The cement manufacturers decrease the prices of there products in order to get high market as compared to its competitor.

13. High level of taxation •

Presently, the cement industry of Pakistan is heavily burdened due to levy of Federal Excise Duty @ Rs. 750 per ton and General Sales Tax @ 15% on duty paid value. In addition to Federal Excise Duty and General Sales Tax, cement industry is also paying the provincial levies (Royalty and Excise Duty) on acquiring of raw material for production of cement i.e. lime stone and shall clay.

Opportunities 1. The local cement industry faces high upfront fuel costs. In order to facilitate their conversion to coal, which is widely available in the country, the government has given incentives for imported plant and equipment for coal firing units. 2. The demand of Pakistani cement is expected to continue to grow at the rate of 20 per cent for about four years to come. It may then follow traditional growth rate of

Page 33

Financial Analysis of DG Khan Cement Company Ltd. seven per cent per year. Announcement of major dams will dramatically increase this demand. 3. Deregulation after accession of Pakistan to WTO is expected to open the window of competition from cheaper markets. There may be no tariff after this deregulation on import of cement allowing its entry into Pakistan from cheaper market at lower rate. Cement from cheaper markets may also block Pakistan’s export of cement to its neighboring countries. Global market has vigorously taken up the advantage of economy of scales and multinational giants now control more than 40 per cent of world production (China not included). The recent acquisition of Chakwal Cement by an Egyptian giant, Orascom may be a beginning of such an entry in Pakistan by multinationals. New avenues for export of cement are opening up for the indigenous industry as Sri Lanka has recently shown interest to import 30,000 tons cement from Pakistan every month. If the industry is able for avail the opportunity offered, it may secure a significant share of Sri Lanka market by supplying 360,000 tons of cement annually.

4. Government Development Expenditure •

Government development expenditures count for one third of total cement consumption. Increase in development expenditures has helped cement demand to grow at very high rates. Increase in PSDP- as announced in Medium Term Development Framework 2005-10 – made the cement demand to grow in the country. Infrastructure development in a region triggers private development projects having even positive impact on cement demand.

5. Construction of large dams

Page 34

Financial Analysis of DG Khan Cement Company Ltd. •

Construction of four large dams will generate demand of 3.7mn tons as construction activities start. Our estimate does not include demand generation from Skardu-Katzarah dam as its feasibility study in not yet completed. Extent of demand generation will depend on size of dam, type of dam, and extent of relocation/resettlement activities required. Bhasha dam will generate maximum demand as it is RCC concrete dam whereas other dams being Earth fill/Rock fill dams will require less cement for their construction. Resettlement activities for Kalabagh dam will generate maximum demand as it is located in a highly populated area.

6. Improved access to regional market •

Afghanistan is Pakistan’s largest cement export market. The prospects for cement exports seem bright in the medium term due to rising domestic as well as regional cement demand. Pakistan also achieved improved access to India after the complete removal of the 12.5 percent custom duty on Portland cement imports in this country from January 2007, showing improved export opportunities for Pakistan. India is planning to import more cement from Pakistan to stabilize prices in the market and the government wants a balance in demand and supply of cement in the current fiscal year. The import of cement from Pakistan has increased manifold during last four months. India has registered a number of Pakistani cement manufacturers, a

requirement to facilitate import of cement. Pakistan has already increased the frequency of trains from one to three in a week to carry cement from Pakistan to Wagah border. Due to boom in the construction industry, India needs cement in bulk to meet its growing needs. 7. Demand of Pakistani cement by Russia

Page 35

Financial Analysis of DG Khan Cement Company Ltd. •

Fresh enquiries have been received from Russia and buyers are quoting very attractive prices as Pakistani cement quality is of very high standard and holds good strength.

8. Earthquake in China •

In the month of May china is hit by severe earthquake having the magnitude of 7.8 this earthquake has cause the serious destruction in china. This disaster is also an opportunity for Pakistan cement industry to export cement to china.

9. High prices of cement in the international market •

Cement exports are expected to soar by a massive 107 per cent due to the primary source of overall cement growth in FY08, the high exports owing to the cement supply shortage in India and Middle East which lead to rocketing cement prices in the region.

10. Increase in demand of cement due to the up coming sports event •

South Africa is schedule to host the football world cup of 2010 due to which they need to make the football stadiums for the World Cup and Sri Lanka are also expected to approach Pakistani companies for cement imports because Sri Lanka to co-host the cricket world cup of 2011.

Page 36

Financial Analysis of DG Khan Cement Company Ltd.

Recommendations We would like to conclude this report by ranking overall sector as “Neutral”. We remain neutral on the sector because on hand expansion is the need of hour. Due to expected growth in demand, current capacity appears inadequate. On the other hand, expansion plans set up by the various players of cement sector to grab demand expansion might cause sector to overflow. Along with risk of being oversupplied, unanticipated increase in interest rates or less than expected demand growth might create severe crises for the sector couple of years forward. Weighing risks and rewards, we remain “NEUTRAL” on the sector. To break-up cement manufacturers cartel the Competition Commission of Pakistan raided offices of Association of Cement Manufacturers of Pakistan and confiscated official record. The association condemned this action and said it is against business norms. They accused Commission for blaming cement manufacturers for making a cartel for the last 10 years but could not able to prove it. The capital structure of cement companies may change, as most of the expansions during last two to three years have been debt financed and companies are expected to retire these debts rapidly during next three to five years. Moreover, the slow down in economy may occur due to political uncertainty, which might result in reducing cement demand in future. However, in case of construction of hydro-powered dams, there will be a sudden jump in the local sales of those companies located near these dams. Consolidation is needed for industry stability because of following observations. 1. Cartels are unstable by their nature. 2. Industry needs one or two dominant players for long-term sustainability in prices and profits 3. Top four players command 35% of market share in the industry that will be increased to 46% in FY08. 4. World norm is that top four players have more than 60% market share 5. Consolidation process will be needed to increase market share of larger players rather than going for capacity expansions 6. We may see acquisitions in the industry as the industry goes through overcapacity cycle.

Page 37

Financial Analysis of DG Khan Cement Company Ltd.

International Trend Although international energy prices have declined recently, any beneficial impact on margins has largely been negated by substantial depreciation of Pak Rupee. PACRA, therefore, believes that the performance of cement companies could weaken further impacting their financial profile. Pakistan's cement industry is poised to face a tough challenge as the regional markets, mainly China and India, are likely to emerge as competitors in the export market, following a slowdown in their domestic economies and enhanced production capacity.

Page 38

Financial Analysis of DG Khan Cement Company Ltd.

FUTURE OUTLOOK In the budget FY09 the central excise duty on cement was increased to Rs 900 per ton from current Rs 750 per ton. On each bag the CED increased by Rs 7.50 per bag (from Rs 37.5 per bag to Rs 45 per bag). This increase was not expected to impact the profits of the cement sector because this increment in CED was expected to be passed on to the consumers. However, the rise in the GST by 1% was anticipated to cause an increase in the local cement prices and dampen the demand for cement. Local cement dispatches are expected to remain depressed due to slow down in economy led construction activity in the country and also due to inflation. The government had allocated Rs 550 billion for PSDP in the budget FY09, however owing to budgetary deficit; the government later cut the PSDP expenditure. Cement consumption is correlated to the GDP growth and as the economic condition now stands, we can predict a slowdown in the GDP growth of the country. Thus the per capita cement consumption will also fall during FY09. Exports have so far shown a strong growth and supported the total cement dispatches. Cement manufacturers have been focusing on the international markets to achieve growth in sales Pakistan has been exporting to Afghanistan. Regional shortage of cement had presented a favorable opportunity for our cement manufacturers. Cement demand in Afghanistan is expected to be 1.5m-2.0m tons per annum for the next few years. Cement manufacturers have growing opportunities in Middle East and African countries. New export markets like Russia and European countries have been identified. Growth in export sales may boost the margins of the industry and reduce the negative impact of rising costs on its profitability. However, the effects of global recession have started to impact international demand for cement. Indian market, which was a window of opportunity for Pakistani cement manufacturers, has been closed as India banned import of cement from Pakistan due to escalating tensions between the two countries. Expenses are expected to increase for cement manufacturers. This will negatively impact the gross margins of the cement sector. During the past, our cement manufacturers shifted production from oil to coal or gas. Pakistan has huge reserves of coal but manufacturers need to import coal because the local coal has high sulphur content. The coal prices in the international market have fallen during the 3rd quarter of FY09 and will result in lower cost of production in the future. However, the full positive effect of lower coal prices may not be achieved because of the depreciation of Pakistani rupee which will neutralize the impact of decreasing international coal prices. Also the government has raised the power tariff by nearly 50% with variable rates for peak and off peak hours. The gas prices have also risen. This will increase the cement manufacturers' cost of production and impact their profitability in FY09. The recent cut of 100 basis points in the discount rate by the SBP is expected to lead to further expansionary monetary policy. Interest rates may go down and result in lower financial costs of debt for the company. DGKC seems to be all set to tap new markets for cement exports. The company's largest Vertical Cement Grinding Mill at D.G. Khan Site has started operations. After the start of grinding mill additional quantities of cement will be available. Increased production will help

Page 39

Financial Analysis of DG Khan Cement Company Ltd. DGKC to aggressively export to new markets and generate higher sales. Also, it will help DGKC in energy saving and reducing maintenance cost. DGKC is trying to cut down on costs that have significantly and adversely impacted its profits in FY08. To reduce electricity cost, DGKC has started a project of power generation from waste heat at DGK site. The project is expected to generate substantially cheap electricity of about 10.4MW without using any fuel. This would help to cut down the cost of production. DGKC has also decided to use municipal solid waste as fuel for heating purposes. Thus, negotiations with equipment suppliers are underway and expected to be finalized soon. Also, DGKC is in contact with different city governments to enter into agreements for acquiring solid waste. This project will be beneficial, as it would bring down the company's costs of production, help resolve the environmental issues related with disposal of solid waste and most important, it would save huge foreign exchange spent on importing fossil fuels.

Page 40

Financial Analysis of DG Khan Cement Company Ltd.

Annexure Summarized Income Statement Summarized Income Statement Sales Net Local Sales Export Sales Less. Excise Duty Special Excised Duty Sales tax Commission to stockiest Sales Net -.Cost of Sales Raw and Packing material used Salaries and Wages Electricity and Gas Furnace oil Stores and Spares used Repair and maintenance Insurance Deprecation on property plant and Equipment Deprecation on assets subjects to finance lease Royalty Excise Duty Vehicle Running Postage Telephone ,Telegram Printing and Stationery Legal and Professional Charges Estate Development Rent, Rates and taxes Freight Charges Other Expenses Opening W.I.P Transfer from Trail run Closing W.I.P Cost of Goods Manufactured Opening stock of finished goods Transfer from Trail run Closing Stock of finished goods -)Own consumption

2008 Rs. In’000

2007 Rs. In’000

2006 Rs. in’000

2005 Rs. In’000

2004 Rs. In 000

14732445 2741111

8887306 511826

10348119 607817

6730756 641351

5392393 305191

2729046 99556 1929858 250749 12464347

1679829

1509449

1141756

990124

1159214 140464 6419625

1349755 141067 7955665

877924 72867 5279560

766497 58207 3882756

1368488 480352 1644759 4597486 764204 98530 43904 1354192

580717 293929 605335 1902567 383159 22913 21840 469367

464080 230854 470625 2114667 388113 18233 20542 341940

374287 185914 322979 1493514 357762 9997 23642 330100

330535 161919 217911 1123716 338970 9637 42235 317155

3331

13108

13203

11311

6923

83731 25962 15541 5389 3480 1499 9639 6982 5753 2079 10534013 142686 (118292) 10558407 107804

45349 15373 7159 1784 945 499 6227 4113 3396 9449 4387229 161989 50462 (142686) 4456994 5058

43678 16884 6980 1774 1492 884 4678 3879 5680 7651 4155837 50205 (161989) 4044053 19468

31652 10450 5724 1831 1581 548 3930 3091 4139 4896 3177348 210983 (50205) 3338126 38616

30284 5909 5881 1374 1276 507 3179 6150 4573 6742 2614113 88603 (210983) 2491733 44145

(118863) (11059) 19302 10528046 1936301

39300 (69728) (25370) 43984 4387640 2031985

(5058) 14410 65641 3992822 3962843

(19468) 19148 26505 3330769 1948791

(38616) 5529 2497262 1385494

Page 41

Financial Analysis of DG Khan Cement Company Ltd. Capitalized Cost of Goods Sold Gross Profit -) Administrative Expenses Salaries Wages Electricity Repair and Maintainance Insurance Deprecation on property plant and Equipment Deprecation on assets subjects to finance lease Vehicle Running Postage Telephone ,Telegram Printing and Stationery Legal and Professional Charges Traveling and conveyance Rent, Rates and taxes Entertainment School expenses Fees and subscription Other Expenses Auditors Remuneration Total Administrative Expenses Selling and Distribution Expense Salaries Wages Electricity Repair and Maintenance Insurance Deprecation on property plant and Equipment Deprecation on leased property Vehicle Running Postage Telephone ,Telegram Printing and Stationery Rent, Rates and taxes Traveling and conveyance Entertainment Advertisement and Sales Promotion Freight Charges-local Freight and Handling Charges-Export Other Expenses Total Selling and Distribution Expenses Other Operating Expenses Workers’ profit participation fund Book Value of Asset written off Donation

57150 2985 1620 1685 11956

48958 2678 1324 1277 9027

40950 2684 1210 3147 7261

31056 2566 1243 3099 9742

27342 3125 1461 1992 12425

126

1571

1213

4945

1382

3545 3441 2210 3522 6783 176 1136 9004 1982 3424 110745

5353 2738 1897 3369 6104 2699 2780 8491 2966 2937 104169

4066 6093 4983 6394 10377 2561 3277 6975 3458 17304 121953

2678 3103 1913 1365 2410 872 795 6177 1855 1926 735 76480

1752 3841 1256 2471 2448 439 766 5944 937 360 704 68645

35431 875 299 497 1342

29727 670 884 235 1132

23997 443 225 172 324

17474 345 121 1397 895

14616 383 40 306 900

1940 1235 1553 3438 3720 296 3395

1603 1361 1094 2312 1406 189 2643

1225 855 891 1272 1561 294 1569

814 855 913 981 1045 398 1919

88 765 944 643 495 1432 358 2213

14135 492219

50 19637

23 -

31239 -

13572 -

2595 562970

2179 65122

1501 34352

2419 60905

1805 38560

93145

182006

83058

60829

11050 35112 414 -

9844 -

4530 -

206

9734 5000 580953 595687

139721

191850

6198 93786

61735

Page 42

Financial Analysis of DG Khan Cement Company Ltd. Worker welfare fund Exchange loss Loss on Disposal of Property Plant and Equipment Loss on Sale and Lease back transactions Total Other Operating Expenses Other Operating Income Income from Financial Assets Income on Bank Deposits Interest on Loan to Employees Gain on derecognizing of investment Dividend Income From -Related Parties -Others Total Income from financial Assets Income from non financial assets Rental Income Profit on sales of property plant and assets Scrap Sales Mark up on loans Provisions and unclaimed balances returned back Exchange gain Others Total other operating income Profit from operations Finance Cost Long term finances - Long term loans - Preferred dividend - Non participatory redeemable capital - Finance under markup - Provident fund -Short term borrowings -Finance lease workers profit participation fund Loss on derivative financial instruments Loss on Foreign currency forward Guarantee commission Bank charges Total finance Cost Excess of Acquire Interest in the net assets of acquire Share of loss of Associated company

727 128 -

1659 182 -

363 181 -

582 276 543173

535 290 -

820303 143 821301

465656 118 467615

265763 120 266427

152284 26 696341

34460 85730 121015

1592 4488

1634 4490

2847 3567

2002 3207

1980 -

10394 6973 1858

4170 1208 303

7609 4562 2116

2911 2002 729

3827 1351 289

846606 1513505

479420 2202393

6986 294114 3908802

500 707692 2425312

128462 1345016

1040737 -

323183 28281 -

305027 35351 -

186267 329 42655 35351

141701 20049 35351 12341

499413 584 522

103324 6564 98

73772 12543 101

42655 12439 83

37 9860 90

205308 -

-

-

-

17229

7804

871 4235 224601 -

4165 15569 (1766298) 86194

1813 4496 468173 -

1679 4994 450696

1405 6860 304041

(8674)

(14163)

(9573)

-

(175273)

1720471

3448533

2121271

1120415

108214 (309167)

33000 312435

40500 1027000

40000 464000

28700 297000

(5) -

(247435)

(32422) (5000)

193 (65000)

10222 (10000)

-

Page 43

Financial Analysis of DG Khan Cement Company Ltd.

Profit before Taxation -)Taxation For the year - current - Deferred Prior Year -Current -Deferred Total taxation

Net Income

(200958)

25685

98000

1030078

439193

325922

1622471

2418455

1682078

794493

Page 44

Financial Analysis of DG Khan Cement Company Ltd.

Summarized Balance Sheet Summarized Balance Sheet Equity and Liabilities Capital and Reserves Authorized Capital -950000000@ ordinary share10 -50000000@ preference share10 Issued subscribed and paid up capital Share deposit money Reserves Un-appropriated profit Total capital and Reserve Non Current Liabilities Long term finance Liabilities against subject to finance lease Long term deposits Retirement and other benefits Deferred Taxation Total Non-Current liabilities Current Liabilities Trade and other payables Accrued markup Short term borrowing Current portion of non-current liabilities Derivative foreign currency forward options Provision for taxation Total Current liabilities Total Liabilities Assets Non-Current Assets Property plant and equipment Assets subject to finance lease Capital work in progress Investments Long term loans, advances and deposits Total Non-Current Assets Current Assets Stores spares and loose tools Stock in trade Trade debts Investments Advances, deposits, prepayments and other Receivables Cash and bank balance Total Current Assets Total

2008

2007

2006

2005

9500000 500000 10000000 2535412

9500000 500000 10000000 2535412

2500000 500000 3000000 1843937

2500000 500000 3000000 1843937

27634722 32399 30528440

29630084 1757689 33923185

8351 15085354 2330558 19268200

7196568 277493 9317998

4389088 251661 6317055

8871051 393

8686447 1141

7372468 28886

4899225 131985

2730573 83487

73890 54018 1251000 10250352

79467 39862 1624000 10430917

33814 26572 1559000 9020740

28674 45765 537000 5642649

30365 38150 138000 3020575

1450074 391610 8194330 2828202

1027274 342612 3942972 2042281

1406869 340757 2613695 1619025

1154426 960620 599674

493968 1360677 487254

306048

-

-

-

-

2004

2500000 50000 300000 1676306 -

35090 12899306 53678098

35090 7390229 51744331

35090 6015436 34304376

35090 3055858 18016505

35090 2376989 11714619

24224273 6839 2488307 6592332 524176

22117551 133376 1907063 8174474 196913

7521723 295058 11759677 4482213 335810

6637237 317262 3983175 2610634 271428

6128083 166583 1126108 1387681 25021

33835927

32529377

24394481

13819736

8833476

2323883 1300325 463446 15082605 427832

1496291 295140 144245 16933790 229315

836049 226286 74165 8543763 152465

1035081 100994 76238 2769134 121486

938847 298538 52622 1386816 120329

244080 19842171 53678098

116173 19214954 51744331

77167 9909895 34304376

93836 4196769 18016505

83991 2881143 11714619

Page 45

Financial Analysis of DG Khan Cement Company Ltd.

Horizontal Analysis of Income Statements Net sales Cost of sale Gross profit administrative expense selling &dist. expenses other operating expense other Operating income profit from operation finance cost share of loss of associated company income before taxes Provision for taxation Net profit

2008 321.01 % (421.58) 139.75

2007 165.34 % (175.7) 146.66

2006 204.89 % (159.89) 286.02

2005 135.97 (133.38) 140.66

2004 100 % 100 100

(61.33)

(151.75)

(177.66)

(111.41)

100

(145.98)

(168.88)

(89.09)

(157.95)

100

(964.90)

(226.32)

(310.76)

(151.29)

-100

659.03

373.20

228.95

550.89

100

112.53 (786.41)

163.74 (208.26)

290.61 (200.66)

180.32 (1345.25)

100 100

-

-

15.64 (61.66) 3.23

153.56 (30.06) 204.21

307.79 (316.05) 304.40

189.33 (134.75) 211.72

100 100 100 100

Horizontal analysis of income statement shows that net sales of the Co has increasing trend. But on the other hand Cost of goods sold jump quickly. This is not a good trend. Cost of goods sold of the Co increases due to expensive raw materials. Gross profit of the co decreases from last years due to high cost of goods sold. Administrative and selling expense of the Co has decreasing trend. Other operating expenses of the Company are increasing quickly. Company is also increasing trend in other operating income. Profit from operations also decreases. Co also has high finance cost from last years. Income before taxes has decreasing trend due to high cost of goods sold and finance cost. Net profit of the Company is Very small as compare to last years.

Vertical Analysis of Income Statements Net sales Cost of sale Gross profit administrative expense selling &dist. expenses other operating expense

2008 100% (84.46%) 15.35 (0.88) (4.52) (4.78)

2007 100% (68.35%) 31.64 (1.62) (1.01) (2.17)

2006 100% (50.18%) 49.81 (1.53) (0.43) (2.41)

2005 100% (63.09%) 36.91 (1.45) (1.15) (1.78)

2004 100 % (64.32%) 35.68 (1.77) (0.99) (1.59)

Page 46

Financial Analysis of DG Khan Cement Company Ltd. other Operating income profit from operation finance cost Excess of acquires interest in the net assets of acquire share of loss of associated company income before taxes Provision for taxation Net profit

6.79

7.47

3.70

13.40

3.37

12.14 (14.17) 0.69

34.31 (7.28)

49.13 (5.66)

45.94 (5.76)

34.64 (5.78)

-

-

-

-

(0.66)

(0.22)

(0.12)

1.41 (1.61) 20.20

26.80 (1.53) 25.27

43.34 (12.95) 30.40

40.18 (8.32) 31.86

28.86 (8.39) 20.46

In vertical analysis of income statement shows that has high cost of goods sold from last years. Gross Profit of the Co has decreasing trend. This is decrease due to high cost of goods sold. Operative expense of the co has minimum portion in the income statement. Profit from operations also has decreasing trend. Share of loss of associated co also increases Income before taxes also decreases from last years. Provision for income taxes also has decreasing trend.

Horizontal Analysis of Balance Sheet Assets issued subscribed & paid up capital reserves accumulated profit total Total non-current Liabilities long term finance liabilities against assets subject to lease finance long-term deposits retirement and other benefit deffered taxation current liabilities trade and other payables accrued mark up current portion of long term liabilities provision for taxes

2008

2007

2006

2005

2004

151.25

151.25

110.00

110.00

100

629.62

675.08

343.70

163.96

100

12.87

698.43

926.07

110.26

100

-

537.01

305.02

147.51

100

324.88

318.12

269.99

179.42

100

0.47

1.36

34.50

158.09

100

243.34

261.71

141.59

104.40

69.65

119.96

100

906.52

1176.81

1129.71

389.13

100

293.56

207.96

284.81

233.70

100

28.78

25.18

25.03

70.60

100

580.43

419.14

332.27

123.07

100

100

100

100

100

100 Page 47

Financial Analysis of DG Khan Cement Company Ltd. total assets non-current assets property plant & equipment assets subject to finance lease capital work in progress investment long-term loans &deposits current assets stores spares and loose tools stock in trade trade debts investment advanced deposits cash and bank balance

542.67

310.91

25.47

128.56

100

395.29

360.92

122.74

108.31

100

4.10

80.06

177.12

190.45

100

220.96

169.35

1044.28

353.71

100

475.06

589.07

323

188.13

100

2094.94

99

1342.11

1084.80

100

100

115.7

116.10

121.51

123

247.53

159.37

89.05

110.25

100

435.56 880.71 1087.57 355.55 290.60

98.86 274.11 11221.05 190.57 138.32

75.79 140.94 616.07 126.71 91.88

33.83 144.88 199.67 100.96 111.72

100 100 100 100 100

Liabilities and owner equity of the balance sheet shows that issued and paid up capital of the company is increasing. And reserves of the co also jump 343% to 675% in the year of 2006 to 2007. Accumulated profits of the co have decreasing trend. And it is dangerous for the co. Non current liabilities of the co increases from 2004 to 2007 but there is a decline in 2008. Current liabilities of the co also have increasing trend. This horizontal analysis of balance sheet shows that Fixed Assets of the Co increase from last years. It means Co have much productive assets. It shows a good trend of fixed assets. On other side trend of assets subjects to finance lease going to decrease. Co also have asset that are work in progress but trend of these assets also going to decrease. Co also invests in long term investment and this asset also has increasing trend from 2004 to 2008. Co also has long term deposits and these also have increasing trend. Current Assets of the Co also have increasing trend. Trade debts of the Co also have increasing trend and its debts are not in a good position. Short term investments of the co also increase and Co use its idle cash in good manners. .

Vertical sheet Assets issued subscribed & paid up capital reserves accumulated profit total

analysis

of

balance

2008

2007

2006

2005

2004

4.72%

4.89%

5.37%

10.23%

14.31%

51.48

57.26

43.97

39.94

37.47

0.06

3.39

6.79

1.54

2.15

Page 48

Financial Analysis of DG Khan Cement Company Ltd. Total Non-current Liabilities long term finance liabilities against assets subject to lease finance Long term deposits retirement and other benefit deffered taxation Total Current liabilities Trade & other payables accrued mark up

56.26

65.55

56.16

51.72

53.92

16.52

16.79

2.49

27.19

23.31

0.000732

0.0022

0.084

0.73

0.71

0.13

0.15

0.098

0.16

0.26

0.10

0.077

0.077

0.25

0.32

2.33 19.09

3.14 20.16

4.54 26.29

2.98 31.32

1.18 25.78

2.70

1.98

4.10

6.41

4.22

0.73

0.66

0.99

5.33

11.61

Short term borrowing secured current portion of long term liabilities provision for taxes total assets non-current assets property plant & equipment assets subject to finance lease capital work in progress investment long-term loans &deposits Total Current liabilities stores spares and loose tools stock in trade trade debts investment advanced deposits cash and bank balance Total

15.26

7.62

7.62

5.27

3.95

4.72

3.33

4.16

0.06 24.03

0.068 14.28

0.10 17.54

0.19 16.96

0.29 20.29

45.13

42.74

21.92

36.83

52.31

0.012

0.26

0.86

1.76

1.42

4.63

3.68

34.28

22.11

9.61

12.28 0.97

15.79 0.38

13.06 0.97

14.49 1.51

11.85 0.21

63.03

62.86

71.11

76.71

75.41

4.32

2.89

2.44

5.75

8.01

2.42 0.86 28.09 0.79 0.45

0.57 0.27 32.72 0.44 0.22

0.66 0.22 24.90 0.44 0.22

0.56 0.42 15.37 0.67 0.52

2.55 0.45 11.84 1.03 0.72

36.26

37.13

28.88

23.29

24.59

Vertical Analysis of the balance sheets shows that in 2008 that Equity portion of Co have large portion of equity .And there is minimum portion of non current liabilities. And it shows a good trend. Co finances his assets through equity and pay minimum amount of interest.

Page 49

Financial Analysis of DG Khan Cement Company Ltd. Current liabilities of the co increase from last years. On current assets co do not pay interest. Co pays his obligation timely and there is no chance of insolvency. On the other side of balance sheet are assets of the Co. Co have more productive assets. Analysis show that Company Finance minimum assets at lease. Current assets of the Co slightly decrease from last year.

Page 50

Financial Analysis of DG Khan Cement Company Ltd.

Liquidity Ratios 1. Days, Sales in Receivables = Gross Receivables/Net Sales/365 Year

Calculation in (Rupees,000)

2008 2007 2006 2005 2004

463446/12464347/365 144245/6419625/365 74165/7955665/365 76238/5279560/365 52622/3882756/365

Days, Sales in Receivables 13.57days 8.20 3.40 5.27 4.95

2. Account Receivables Turnover =Net Sales /Average Gross Receivables Year

Calculation in (Rupees,000)

2008 2007 2006 2005 2004

12464347/30384550 6419625/109205 7955665/75201.50 5279560/64430 3882756/52622

Account Receivables Turnover 41.02times 58.78 105.79 81.44 73.78

3. Account Receivables turnover in days =Average Gross Receivables/Net Sales/365 Year

Calculation in (Rupees’000)

2008 2007 2006 2005 2004

30384.50/12464347/365 109205/6419625/365 75201.50/7955665/365 64430/5279560/365 52622/3882756/365

Account Receivables turnover in days 8.89days 6.20 3.45 4.45 4.95

4. Days Sales in Inventory =Ending Inventory/Cost of Goods sold /365 Year 2008 2007 2006 2005 2004

Calculation (Rupees’000) 1300325/10528046/365 295140/4387640/365 226286/3992822/365 100994/3330769/365 298538/2497262/365

Days Sales in Inventory 45.08 days 24.55 days 20.68 days 11.07 days 43.63 days

4. Inventory turnover = Cost of Goods sold/Average Inventory Year 2008

Calculation (Rupees’000) 10528046/797732.5

Inventory turnover 13.19times

Page 51

Financial Analysis of DG Khan Cement Company Ltd. 2007 2006 2005 2004

4387640/260713 3992822/163640 3330769/199766 2497262/298538

16.83 24.40 16.67 8.36

5. Inventory Turnover in Days =Average inventory /cost of goods sold /365 Year 2008 2007 2006 2005 2004

Calculation (Rupees’000) 797732.5/10528046/365 260713/4387640/365 163640/3992822/365 199766/3330769/365 298538/2497262/365

Inventory turnover in days 27.66 days 21.69 14.96 21.89 43.63

07. Operating cycle = Account Receivables turnover in days + inventory turnover in days 2008 =8.89+27.66 =36.55 days 2007 =6.20+21.69 =27.89 2006 =3.45+14.96 =18.41 2005 =4.45+21.89 =26.34 2004 = 4.95+43.63=48.58 08. Working Capital = Current Assets – Current Liabilities (Amount in Rupees’000) 2008 19842171-12899306 =6942865 2007 19214954-7390229 =11824725 2006 9909895-6015436 =3894459 2005 4196769-3055858 =1140911 2004 2881143-2376989 =504154 09. Current Ratio= Current Assets/Current Liabilities Year Calculation in (Rupees’000) 2008 19842171/12899306 2007 19214954/7390229 2006 9909895/6015436 2005 4196769/3055858 2004 2881143/2376989

Current Ratio 1.54:1 2.60:1 1.65:1 1.37:1 1.21:1

10. Quick Ratio= (Cash Equivalent + Marketable Securities+ Net Receivables)/Current Liabilities Year Calculation in (Rupees’000) Quick Ratio 2008 (244080+15082605+463446)/12899306 1.22:1 2007 (116173+16933790+144245)/7390229 2.33:1 2006 (7235749+502387+969891)/8429327 1.44:1 2005 (6931615+67244)/6344831 0.96:1 2004 (5078613+5503)/4524698 0.64:1 11. Cash Ratio =Cash Equivalent +Marketable Securities /Current liabilities Year Calculation in (Rupees’000) Cash Ratio 2008 (244080+185082605)/12899306 1.18

Page 52

Financial Analysis of DG Khan Cement Company Ltd. 2007 2006 2005 2004

(116173+16933790)/7390229 (77167+8543763)/6015436 5279560/822532.50 3882756/504154

2.31 1.43 6.42 7.70

12. Sales to Working Capital = Sales/Average Working Capital Year Calculation in (Rupees’000) Sales to Working Capital 2008 12464347/9383795 1.33times 2007 6419625/7859592 0.82 2006 7955665/2517685 3.17 2005 5279560/82253.20 6.42 2004 3882756/504154 7.70

Long Term Debt Paying Ability 1. Times Interest Earned =Recurring Earning, Excluding Interest Expenses, Tax expense, Equity Earnings and Minority Earnings / Interest Expense, Including Capitalized Interest Year Calculation in (Rupees’000) Times Interest Earned 2008 1513505/1766298 8.56times 2007 2202393/467759 4.71 2006 3908802/(450696+620534) 3.65 2005 2425312/(304041+75437) 6.39 2004 1345016/(224601+2945) 52.94 2. Fixed Charge Coverage= Recurring Earnings, excluding Interest Expense, Tax expense Equity earnings and minority earnings + interest portion of Rentals/Interest expense including Capitalized interest + Interest portion of rentals Year Calculation in (Rupees’000 ) Fixed Charge coverage 2008 153505+8194330/1766298+8194330 0.84times 2007 2202393+3942972/467759+3942972 1.39times 2006 3908802+2613695/4500616+620534+2613695 0.84times 2005 2425312+960620/304041+75437+960620 2.53times 2004 13450+1360677/22460+2945+1360677 1.95times 3. Debt Ratio =Total Liabilities/Total Assets Year Calculation in (Rupees’000 ) 2008 23149658/53678098 2007 17821146/51744331 2006 15036176/34304376 2005 8698507/9317998 2004 5397564/6317055 4. Debt Equity Ratio=Total Liabilities/Shareholder’s Equity Year Calculation in (Rupees’000) 2008 23149658/30528440 2007 17821146/33923185

Fixed Charge coverage 43% 34% 44% 93% 85%

Debt Equity Ratio 76% 53

Page 53

Financial Analysis of DG Khan Cement Company Ltd. 2006 2005 2004

15036176/19268200 8698507/9317998 5397564/6317055

78 93 85

Profitability Ratios 1. Net Profit Margin= Net Income before minority share of Earnings and Non Recurring Items /Net Sales Year Calculation in (Rupees’ 000) Net Profit Margin 2008 97753/12464347 7.84% 2007 1636634/6419625 25 2006 2428028/7955665 31 2005 1682078/5279560 31 2004 794493/3882756 20 2. Total Asset Turnover = Net Sales/Average total Assets Year Calculation in (Rupees’ 000) Total Assets Turnover 2008 12464347/52711214.50 24 Times 2007 6419625/43024353.50 15 2006 7955665/10723490.50 74 2005 5279560/14865562 35 2004 3882756/11714619 33 3. Return on Assets =Net Income before minority shares of earning and nonrecurring items /Average total Assets Year Calculation in (Rupees’ 000) Return on Assets 2008 97753/52711214.50 18.5% 2007 1636634/43024353.50 3.8 2006 2428028/10723490.50 23 2005 1682078/14865562 11 2004 794493/11714619 6.8 4. Operating income Margin = Operating Income/Net Sales Operating Income Year Calculation in (Rupees’ 000) Margin 2008 1513505/12464347 12% 2007 2202393/6419625 34 2006 3908802/7955665 49 2005 2425312/5279560 46 2004 1345016/3882756 35

Assets Utilization 1. Operating Asset Turnover =Net Sales /Average Operating Assets

Page 54

Financial Analysis of DG Khan Cement Company Ltd.

Year

Calculation in (Rupees’ 000)

2008 2007 2006 2005 2004

12464347/5367098-(6592332+524176+15082605+427832) 6419625/51744331-(8174474+196913+16933790+229315) 7955665/34304376-(4482213+335810+152465+8543763) 5279560/18016505-(2610634+271428+2769134+121486) 3882756/11714619-(1387681+25021+1386816+120329)

Operating Asset turnover 0.20times 0.096times 0.20times 0.28times 0.33times

2. Return on Operating Assets = operating income/Net sales Return on Operating Year Calculation in (Rupees’ 000) Assets 2008 1513505/63120379 24% 2007 22023 9 3/ 66879875 3.3 2006 3908802/38854201 10 2005 2425312/18567919 13 2004 13455016/11859104 11 3. Sales to Fixed Assets =Net Sales /Average Net fixed Assets(Exclude construction in progress) Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000)

Sales to Fixed Assets

12464347/(24231112+22250927)/2 6419625/(7816781++22250927)/2 7955665/(7816781+6954499)/2 5279560/(6954499+6294666)/2 3882756/6294666

54% 43 108 80 62

4. 8.Return on Investment =Net Income before minority share of earning and non recurring items + (Interest expense)*(1-tax rate) Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) 97753+1766298*0.65/42566447 1636634+468173*0.65/3632152 2428028+450696*0.65/21624793.50 1682078+304041*0.65/12149138.50 794493+224601*0.65/9337630

Return on Investment 2.92% 5.34 12.58 15.47 10.07

5. 9.Return on total equity =Net Income before nonrecurring items-Dividend on redeemable preferred stock/Average total equity Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) 97753/(30528440+33923185)/2 1636634/(33923185+19268200)/2 2428028/(19268200+9317998)/2 1682078/(9317998+6317055)/2 794493/6317055

Return on total equity 0.30% 0.37 0.17 0.22 0.13

Page 55

Financial Analysis of DG Khan Cement Company Ltd.

6. 10.Return on Common equity=Net income before Nonrecurring ItemsPreferred dividend/Average common equity Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000)

Return on common equity

7. 11.Gross profit margin=Gross profit/Net sales Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) 1936301/12464347 2031985/6419625 3962843/7955665 1948791/5279560 1385494/3882756

Gross profit margin 15.53% 31.65 49.81 36.91 35.68

Investment Ratios 1. Degree of financial Leverage=EBIT/Earnings before tax Year

Calculation in (Rupees’ 000)

2008 2007 2006 2005 2004

1513505/175273+8674-86194 2202807/1720471+14163 3908802/3448533+9573 2425312/2121271 1345016/1120415

Degree of financial leverage 15.48% 1.27 1.13 1.14 1.20

2. 2.Earnings per common share=Net income-preferred dividend/Weighted Average no. of common share outstanding Year

Calculation in (Rupees’ 000)

2008 2007 2006 2005 2004

25685/252485315 1622471-103324/252485315 2418455-73772/2332578650 1682078-329/219744584 794493-20049/219744584

Earnings per common share 0.017% 0.60 0.10 0.76 0.35

Page 56

Financial Analysis of DG Khan Cement Company Ltd.

3. Price/Earning ratio=Market price per share/Diluted earning per share Year Calculation in (Rupees’ 000) Price/Earning ratio 2008 30.97/0.12 258.08 2007 30.97/6.43 4.81 2006 30.97/9.14 3.38 2005 30.97/7.82 3.96 2004 30.97/3.78 8.19 4. Percentage of Retained earning=Net income-All dividend/Net income Percentage of retained Year Calculation in (Rupees’ 000) Earning 2008 25685-379093/25685 -13.76 2007 1622471-344743/1622471 0.79 2006 2418455-275478/2418455 0.88 2005 1682078-250705/1682078 0.85 2004 794493-138374/794493 0.83 5. Dividend payout=Dividend per common share/Diluted earning per share Year Calculation in (Rupees’ 000) Dividend payout 2008 (379093000/158934068)/0.12 19.83 2007 (344743-103324/158934068)/6.43 23.62 2006 (275478-73772/112835676)/9.14 48.31 2005 (250705-329/112835676)/7.82 28.37 2004 (13874-20049/112835676)/3.78 27.74 6. Dividend yield= Dividend per common share/Market price per common share Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) (379093000/158934068)/30.97 (344743-103324/158934068)/30.97 (275478-73772/112835676)/30.97 (250705-329/112835676)/30.97 (13874-20049/112835676)/30.97

7. Book value per share=Total stockholders equity/Number of common share outstanding Year 2008 2007 2006 2005 2004

Calculation in (Rupees’ 000) 30528440-746071/158934068 33923185-746071/158934068 19268200-515580/112835676 9317998-515580/112835676 6317055-347949/112835676

Dividend yield 7.68% 4.90 14.23 7.17 3.38 equity-preferred

stock

Book value per share 18.74% 20.87 16.62 7.80 5.29

Page 57

Related Documents


More Documents from ""