Question Paper
Security Analysis – II (212) : January 2006

Section D : Case Study (50 Marks)

This section consists of questions with serial number 1 - 6.

Answer all questions.   

Marks are indicated against each question.

Do not spend more than 80 - 90 minutes on Section D.

Case Study

Read the case carefully and answer the following questions:

1.      Discuss the factors that affect Dabur India Ltd. and its competitors regarding the demand and supply of its products, also explain a logical framework for analyzing and forecasting revenue for the same.

(10 marks) < Answer >

2.      Perform the four factor ROE analysis for Dabur India Ltd. for the last five years, and comment on the same.

(8 marks) < Answer >

3.      a.       Find the P/E ratio for Dabur India Ltd., considering the projected EPS as on 31st March 2006, and the market price as on 31st March 2005. Growth rate for projecting EPS as on 31st March 2006 will be based on the simple average growth rate of the last five years.

         b.      What growth rate is consistent with the market price of the company as on 31st March 2005 according to free cash flow model assuming growth rate increase in first five years and then it linearly comes down in the next 5 years to stabilize at 5%. The required rate of return by equity shareholders is 12%.

(4 + 1 0 = 14 marks) < Answer >

4.      Based on the information given in Annexure1, determine the suitability of the Dabur India Ltd., stock for investment if an individual investor wants the proportion of unsystematic risk in his investment not to exceed 60%.

(7 marks) < Answer >

5.      Valuing a company with inconsistent schedule of earning, or worse with no earning at all, requires a delicate balancing act on part of analyst. In such instances traditional methods of valuations befall to helplessness. With respect to this explain the importance of Price to Sales ratio as an alternative for Price to Earning ratio for valuing a company.

(6 marks) < Answer >

6.      Comment on whether the stock should be bought, sold or held at points A, B, C, D, and E based on the share price charts given in Annexure II.

(5 marks)  < Answer >

FMCG Sector

Fast Moving Consumer Goods (FMCG) sector is the fourth largest sector in the economy with a total market size of around Rs 60,000 crores. This industry comprises of consumer non durable products and provides the day-to-day need of the inhabitants. The FMCG sector is an essential component of the India’s GDP and plays a significant role in the employment generation. Around 5% of factory employment is through this sector. This sector also creates employment for more than three million people, who are in small towns and rural areas. The 2005-06 Union Budget also have few things to offer to this sector and thus prospects have come under sharp focus.

Features of FMCG Sector

The FMCG are generally described as products, which are used regularly by the consumer. They are branded, non-durable products sold in packaged forms that are used by the consumer.

The industry includes products used by various categories of peoples. The products can be segmented in personal care, household care, packaged food and beverages, spirits, tobacco, etc. One or more players in the industry dominate each of the above product segments. Godrej Soaps, Colgate-Palmolive, Marico, Dabur and Procter & Gamble dominate personal care products. In household care segment major companies are Hindustan Lever, Nirma, Reckitt & Colman etc., Food and beverages segment includes Hindustan Lever, Nestle, Cadbury and Dabur as the major players. ITC, Godfrey Philips, UB and Shaw Wallace dominate the spirit and tobacco segment of the FMCG industry.

According to the opinion of the inhabitants, the perception of FMCG sector are as producer of luxury items targeted at the privileged, but in reality the sector meets the every day needs throughout the country. Lower income and lower-middle income groups’ explains around 60 per cent of the total FMCG sector’s sales. The majority of sales volume comes from low-priced products. FMCG outlets had reached even in small villages where basic needs such as schools and transportation facility is not available. The rural market account for 56 per cent of total domestic FMCG demand.

The FMCG sector has several other salient features. The sector is strongly associated with the agro-based products. It is a significant value creator with market capitalization of second only to the IT sector and is a key contributor to the exchequer. Its contribution to corporate tax, central excise and sales tax and state tax is also noteworthy.

Sectoral Snapshot

FMCG sector is under tremendous pressure from last three years, however due to renew market expectations and prospects things seem to have changed from last four quarters. In India, companies like HLL, ITC, Colgate, Nestle, Nirma and Cadbury dominated the FMCG sector, with each one having their own market niche. But gradually the outlook is changing; new players are entering with huge expectations and proving their point. In the last four quarters, things have changed and the FMCG sector is back on track towards the path for recovery. Growth is being witnessed in urban as well as rural areas. But this time around, small companies are making good profits, as they follow a simple strategy to give more incentive to encourage the customers than their bigger brothers. The last year’s revenue and net profit growth for the companies in this sector are as under:

Summary of company results

Companies

Revenue (31.3.2004)

Revenue (31.3.2005)

Growth (%)

Increase in net profit (%)

HLL

102430.99

105201.90

-2.63

-32.68

ITC

78238.60

66137.00

18.30

9.75

Nirma

18804.40

22239.50

-15.45

18.53

Dabur

12310.95

10864.76

13.31

46.50

P & G

5921.25

4493.07

31.79

34.27

Britannia

16070.58

14554.21

10.42

69.29

Colgate

9920.44

9636.30

2.95

11.10

Tata Tea

9559.50

8410.31

13.66

47.21

Marico

9480.20

8474.46

11.87

20.41

GlaxoSmithkline

8841.10

8230.50

7.42

-5.37

Radico Khaitan

3138.05

2719.33

15.40

-7.21

Dynamics

According to some experts and market analysts, FMGC sector should be dealt with active approach, as the sector will continue to see the price wars where the business will be the prime factor for the profit growth of the company. Sector has observed good growth in the volume but, price cuts in products by over 25% hit the value growth for the companies. Companies are also taking advantages by virtue of setting up their manufacturing units in tax havens like Himachal Pradesh, Jammu and Kashmir, Assam and Uttranchal. Many companies started manufacturing rather than outsourcing their product to protect the profit margins in absence of increasing prices. Government is also taking a step forward to make India an outsourcing hub for agri-products. It will help the farmers in expanding and increasing their efficiency. Due to increasing use of information technology, companies are improving their working capital cycle and reducing their inventory levels. This will help the company by controlling cost and increasing margins. Most of the companies are spending their money and effort in promoting their brands. Building the brand name is of utmost importance in the FMCG industry. Distribution network for the FMCG companies also helps them in achieving the growth in revenues.

On the other hand monsoon affects the industry in a major way. Despite a lower than optimal monsoon last year, agricultural production is good. However the monsoon this year has been good throughout the country and a better year for agriculture is predicted. Surge in crude oil prices also affected the margins of the companies and the volatilities in the price of the crude oil will keep pressure on the FMCG sector. Mergers and acquisitions also play a crucial factor in the dynamics of this sector. Last year, two major acquisitions took place in the FMCG sector – Procter & Gamble announced the global acquisition of Gillette and homegrown Dabur announced that it would take over domestic toothpaste and household care company Balsara Hygiene.

Outlook

The FMCG sector will continue to grow the business considering the overall economy of the country. The per capita consumption in India for the FMCG product is amongst the lowest in the world. This shows the scope of expansion in India in the FMCG sector. Even if we compare the consumption with the countries like China and Thailand there is enough scope for FMCG sector to grow.  Companies are changing the mindset of the people by offering new generation products. Companies are reaching to the rural sector where the penetration is low and thus building up the infrastructure facilities. Companies like HLL and ITC have started Project Shakti and E-Choupal, but still unable to capture significant share in the market. Owing to the vast growth potential, many big corporates are jumping into the sector like Reliance industries, ITC etc. International giants are also viewing India as its retail chain destination like Wal-Mart, etc.

Dabur India Ltd. (DIL)

Background

Dabur India is the country’s fourth largest FMCG Company with interests in Health care, Personal care and Food products. Dabur has a turnover of Rs1240 crores with brands such as Dabur Amla, Dabur Chyawanprash, Vatika, Hajmola & Real. The company has its manufacturing units at Alwar, Rajasthan - Baddi near Solan, Himachal Pradesh - Katni near Jabalpur, Madhya Pradesh - Sahibabad near Ghaziabad, Uttar Pradesh. The company has wide and deep market penetration with 47 C&F agents, more than 5000 distributors and over 1.5 million retail outlets all over India.  The company demerged its pharma business w.e.f 1st April 2003 to unlock value in both pharma & FMCG business. Consequently upon demerger of the pharmaceutical division fixed assets of Rs. 5574 crores, General Reserve Rs.18618, Investment Rs.7652, Secured Loans Rs. 437, Current Assets Rs. 8854, Unsecured Loans Rs. 2394, Loan & Advances Rs. 631, Current Liabilities & Provisions Rs. 1324 and Deferred Tax/Misc Expenditure Rs. 62 has been transferred to Dabur Pharma Ltd.

Business and Products

Dabur is a trusted name in natural health care for over 100 years and is known for providing a range of efficacious products based on the principles of Ayurveda. It has some famous brands like Vatika, Hajmola, Anmol, Real and Balsara. Vatika is a premium brand and a leader in its category as one of the flagship brand with a popular name in the natural personal care products. Hajmola is a tasty fun-filled digestive available in various forms from tablets, traditional churnas to modern formats like center-filler candy appealing to all age groups. Anmol is a relatively new member in the family of Dabur’s key brands, provided a range of herbal and natural products across various FMCG categories with a focus on providing quality and affordability. Real is the country’s leading brand of packaged fruit juices, provide the largest range of refreshing and health fruit juices that are 100 per cent natural and free of preservatives. Balsara is a leading producer of oral care and household care products in the Indian market and a new member in the Dabur range of products. Company has acquired three Balsara group companies – Balsara Hygiene Products, Balsara Home Products and Besta Cosmetics. The company is expecting further strengthening of its oral care portfolio and making its debut in the high-growth home care segment.

This acquisition declares Dabur as a prominent FMCG brand which includes like Promise, Babool and Meswak toothpaste and in household care it has Odonil, Odopic and Odomos, which adds Rs.2 billion to its revenues. Oral care products account for 56% of Balsara’s revenues while household products contributes 44%. In addition to its core oral care and household care businesses, Balsara also has export business consists of 15% of its revenue.

In India, three divisions — Consumer Care Division (CCD), Consumer Healthcare Division (CHD) and the wholly owned subsidiary Dabur Foods Limited, carry out the company’s business. On a consolidated basis CCD contributes 82 per cent, CHD contributes 8 per cent and DFL contributes 10 per cent to the Company’s domestic revenues, while CCD remains the leading division and a focus area. During 2004-05 the Company undertook several initiatives to grow deliberately in smaller divisions — CHD and Foods. These divisions, with relatively smaller sales base, are seen as key drivers of future growth.

International Business

During 2003-04, the Company started giving greater impetus to the international business. The entire international operation was reorganized and an umbrella organization called Dabur International Limited was created to provide focus and structure to the international initiatives. This entity has an independent team and operates from Dubai. Overseas sales grow up by 43.4% per cent from Rs.128 crores in 2003-04 to Rs.183.6 crores in 2004-05. The overseas impetus has been maintained and the share of overseas in Dabur’s total sales increased from 9.6 per cent in 2003-04 to11.9 percent in 2004-05. The data of relative domestic and overseas sales and net profit for the consolidated entity is given in table given below.

 

Relative share of Sales and Profits of domestic and overseas businesses

 

Particulars

Domestic

Overseas

2004-05

2003-04

2004-05

2003-04

Sales

% of Total

1353.40

88.10

1201.50

90.40

183.60

11.90

128.00

9.60

Net profit

% of Total

151.7

96.60

100.6

92.00

5.30

3.40

8.70

8.00

Recent Developments

The company is intending upon creating a backward integration platform for herbal inputs, especially those on the endangered list. To this end, Dabur has made a foray into contract farming for selected herbs as part of the agro biotechnology initiative. Under this initiative, a number of backward integration programmes have been set up in Andhra Pradesh, Tamil Nadu, Haryana, Uttar Pradesh, Himachal Pradesh, Uttaranchal, Jammu and Kashmir and Nepal to develop sustainable cultivation of these engendered species through contract farming and buy back arrangements. Dabur entered into contract farming agreements with farmers through a local coordinator. The company also organizes quality-planting material with promising genetic potential to farmers on no-profit-no-loss basis and provides additional technical support. In all, about 2500 acres of land and 29 medicinal herbs have been covered under these programmes, which contribute to environment and adds to the income of farmers in addition to providing a sustainable source of herbal inputs to the company.

In the current inflationary backdrop, supply chain efficiencies have assumed even greater importance. Company’s initiatives over the last couple of years in supply chain management have stood them in good despite R&D has been the cornerstone of Dabur’s success. Dabur Research Foundation (DRF) undertakes the Research and development activities. DRF is engaged in a wide spectrum of research on ayurvedic and herbal products, organic substances, phytochemicals (plant derived medicines), tissue culture, foods, cosmetics, oral care and other personal care products. Dabur India Limited recently announced its entry into personal wash segment with the national launch of its new Vatika- Honey & Saffron Soap. This launch marks Dabur's entry into the       Rs.47 billion Indian soap market. Vatika is one of the five master brands of Dabur India with a turnover of over Rs.1 billion and the distinction of being awarded "Super brand" in 2003-04. Important developments that could affect the company’s operations includes a downward trend in the domestic FMCG industry, rise in input costs, exchange rate fluctuations, significant changes in political and economic environment in India, environment standards, tax laws, litigation and labour relations.


Balance Sheet of Dabur India Ltd. as on

(Rs. in million)

Liabilities

31.3.2005

31.3.2004

31.3.2003

31.3.2002

31.3.2001

Share Capital

(Share of Rs.1 each)

286.42

286.25

285.75

285.59

285.21

Reserves & Surplus

3,094.32

2,400.33

3,825.16

3,718.11

3,336.81

Net Worth (1)

3,380.74

2,686.58

4,110.91

4,003.70

3,622.02

Secured Loans (2)

157.04

190.94

290.03

361.79

275.29

Unsecured Loans (3)

327.67

206.16

774.33

1,731.68

1,633.29

Total Liabilities (1+2+3)

3,865.45

3,083.68

5,175.27

6,097.17

5,530.60

 

Assets

 

 

 

 

 

Fixed Assets

 

 

 

 

 

Gross Block

3,174.64

2,681.64

2,971.78

3,764.96

3,621.27

(-) Accumulated Depreciation

1,351.18

1,195.58

1,173.27

1,481.31

1,335.33

Net Block (A)

1,823.46

1,486.06

1,798.51

2,283.65

2,285.94

Capital Work in Progress         (B)

92.61

63.38

248.05

160.58

142.75

Investments      (C)

2,709.42

1,712.27

1,237.38

1,233.20

727.31

 

Current Assets,

Loans & Advances

 

 

 

 

 

Inventories

1,280.26

1,095.19

1,786.52

1,585.33

1,392.51

Sundry Debtors

492.83

420.72

1,159.76

1,199.66

1,376.85

Cash And Bank

106.54

118.87

375.82

217.72

234.37

Loans And Advances

653.87

564.14

735.59

1,073.00

924.78

(i)

2,533.50

2,198.92

4,057.69

4,075.71

3,928.51

 

Current Liabilities & Provision

 

 

 

 

 

Current Liabilities

2,457.79

1,725.93

1,666.58

1,516.44

1,180.97

Provisions

893.85

716.98

523.8

174.34

446.78

(ii)

3,351.64

2,442.91

2,190.38

1,690.78

1,627.75

Net Current Assets

(i - ii)          (D)

-818.14

-243.99

1,867.31

2,384.93

2,300.76

Miscellaneous Expenses          (E)

58.1

65.96

24.02

34.81

73.84

Total Assets

(A+B+C+D+E)

3,865.45

3,083.68

5,175.27

6,097.17

5,530.60

 

 

Profit & Loss Account of Dabur India Ltd. for the year ending on

 (Rs. in million)

 

31.3.2005

31.3.2004

31.3.2003

31.3.2002

31.3.2001

Sales

12,310.95

10,864.76

11,629.27

11,069.97

11,132.54

Other Income

29.26

49.19

49.55

59.7

114.84

Total Income

12,340.21

10,913.95

11,678.82

11,129.67

11,247.38

Raw Material Cost

5,467.28

5,079.20

5,253.52

5,191.77

5,422.62

Excise

424.89

653.96

733.75

606.06

593.57

Other Expenses

4,605.65

3,821.20

4,322.18

4,118.23

3,798.44

Operating Profit

1,842.39

1,359.59

1,369.37

1,213.61

1,432.75

Interest Expenses

46.61

75.83

183.96

239.49

296.64

Gross Profit

1,795.78

1,283.76

1,185.41

974.12

1,136.11

Depreciation

185.92

178.53

236.62

253.94

261.88

Profit Before Tax

1,609.86

1,105.23

948.79

720.18

874.23

Tax

169.98

122.37

104.27

110.67

72.5

Net Profit

1,439.88

982.86

844.52

609.51

801.73

Other Non- Recurring Income

39.79

28.6

4.56

40.85

-25.39

Reported Profit

1,479.67

1,011.46

849.08

650.36

776.34

Equity Dividend

715.92

572.5

400.05

142.75

285.21

Corporate Tax on Interim Dividend

37.41

22.01

14.56

14.55

Corporate Tax on Final Dividend

60.26

51.35

32.79

14.55

Annexure I

Closing value of the S & P CNX NIFTY and Dabur India Ltd. for the last one year

End of the month

S & P CNX NIFTY

Dabur India Ltd

September-04

1745.50

73.00

October-04

1786.90

80.65

November-04

1958.80

88.05

December-04

2080.50

92.20

January-05

2057.60

101.35

February-05

2103.25

115.70

March-05

2035.65

111.05

April-05

1902.50

116.25

May-05

2087.55

128.65

June-05

2220.60

131.35

July-05

2312.30

145.40

August-05

2384.65

153.50

September-05

2611.20

162.75

 

Annexure II

Technical Analysis Charts

 Price line

 

 

END OF SECTION D

 

Section E : Caselets (50 Marks)

This section consists of questions with serial number 7 - 13.

Answer all questions.

Marks are indicated against each question.

Do not spend more than 80 - 90 minutes on Section E.           

Caselet 1

Read the caselet carefully and answer the following questions:

7.      According to the caselet, what exactly is Insider Trading? Explain the mechanism through which Insider Trading takes place?

(8 marks) < Answer >

8.      What is the legal status of Insider Trading in India and how SEBI keeps a watch on Insider      trading transactions?

(8 marks) < Answer >

The persons involved in the insider trading are questionable but not the insider trading itself. This can be viewed from various transactions involved in these companies. Promoters affirm on compiling with the corporate governance rules. Investment bankers’ states about there own compliance and their internal systems. So who are the real guilty! Take the stock of Adlabs Films, a company in entertainment sector. Adlabs is priced at Rs.162.05 on the National Stock Exchange as on June 1, 2005. In next ten days the scrip was trading at Rs.189.65, with a trading volume of 19 times compared to volume on June 1, 2005. (volume as on June 1, 2005 is 29,005 shares and volume as on June 10, 2005 is 5,50,578 shares). On June 29 it is trading at around Rs.200 with a volume of 10,99,549 shares. On the last of the month, Reliance Capital send notices to the stock exchange informing them about a decision for acquiring 51% stake in the Adlabs Films Ltd. On that day price zooms to Rs.241.45 with a volume of 30,99,256 shares and on the next day it went to Rs.281.70 with a volume of 64,21,675 shares. The major observation made here is that Nifty got up only 6.37% against Adlabs scrip, which jumped 49% in the same period.

This is only one case but there are many cases like this. Ketan Parekh also rigged the price of Global Trust Bank’s (GTB) scrip in league with its promoters before the announcement of the decision to merge GTB with UTI Bank. SEBI has identified clear evidence of insider trading, price chains and circular trading in the stock exchanges. While a part of the money came from the promoters and brokers, a larger part was derived from illegally diverting depositors’ money from banks such as the Madhavpura Bank. But still a more clear and quiet investigation is needed in the insider trading cases on the part of Securities and Exchange Board of India.

Caselet 2

Read the caselet carefully and answer the following questions:

9.      Discuss the support and resistance level with the help of demand and supply theory and also explain how bulls and bears affect the support and resistance level.

(8 marks) < Answer >

10.    There are some principles to be kept in mind while applying support and resistance lines for     trend analysis. Discuss these principles.

(8 marks) < Answer >

A technical analyst sits with a lot of charts to conclude patterns by viewing how a stock is being traded in a certain period of time. By employing complex statistical tools, analysts study the graph of stock price and its quantity traded over a period of time. After all this efforts an analyst expect the graph to tell about the increase or decrease in the price of the stock. Such type of analysis moreover looks in support of certain price levels in a stock’s performance in the past e.g., 52-week high and the 52-week low. These levels infer about the highest and lowest price of the security for the past one-year. The 52-week low is called the support level as it is generally believed to be the 'support' level below which the stock's price shouldn’t fall except there is something fundamentally wrong in the company. Simply, support is the floor level, below which the stock price cannot fall and resistance is a ceiling price level above which the price should not increase. When the price of the security break through a support or resistance line, the traders will drive the price to the new price level. When a resistance level is penetrated and successfully tested, it becomes a support level and vice-versa.

Investors usually buy the stock at support line in anticipation of increase in prices and sell the stocks at resistance level expecting the price to come down. Mostly these support and resistance level are triggered through fundamental changes that varies with expectation and also through psychological factors. The foundation of most technical analysis tools is rooted in the concept of supply and demand. In almost all charts support and resistance level are the most popular. It is always wise to again take a note of new facts after the support /resistance level is broken. For example, if there is a breakout above the resistance level, one should again analyze the new trend and should consider new fundamental and then may think about selling the stock. This creates an observable fact that is referred to as "traders’ remorse": prices return to a support/resistance level following a price breakout. The trend of price line after this period is important. There is a possibility of two things here. Firstly, if the expectation is defensive then the price will move back to the earlier level and secondly, if the expectation is positive, then the price will continue in the same direction.

Caselet 3

Read the caselet carefully and answer the following questions:

11.       A value of beta explains the risk associated with a security. With respect to this explain various types of beta values.

(5 marks) < Answer >

12.    Beta is a good tool for assessing the movement of stock based on the relationship between the return on the stock and the market. But there are some problems where only beta is used for determining risk of an investment. Discuss.

(7 marks) < Answer >

13.    The Beta of a security fails to correctly reflect the inherent risk during the period of economic slowdown and recession. Explain.

(6 marks) < Answer >

In the recent market run, there has been a high level of price volatility. If one has to watch out for the movement of the stock of the leading scrip then the most common way to measure this is by means of ‘beta’. Beta is a measure that tells about how much a stock has moved in relation to the index for a defined period of time. Beta value can be readily available from the various websites. Ideally the stock should be such, which can always beat the index. It should rise more when the market are bullish and falls less when market is in a bearish grip. So according to the risk taking ability of the individual, the stock should be selected. A proper strategy should be framed to invest in a portfolio based on the stock’s sensitivity to the market index. Investments that carry higher than average risks should offer the opportunity to earn much higher returns, but in reality, however, it is not very easy to strategic investments, which adhere to that principle. There are many variables that affect the stock return; moreover there is more than one way of calculating risk, thus making risk-reward assessment a complex exercise. Mostly all variables are based on past data and can provide little clue about future.

An analysis of past beta across sectors does not provide enough evidence to suggest, that high beta stocks deliver better returns in rising market, or fall more steeply in falling market. This is primarily because beta values change rapidly based on market moods. Beta values are useful for positioning a portfolio based on your risk appetite and buying a stock based on beta alone is not a good idea. Investors can find the best use of the beta ratio in short-term decision-making, where price volatility is important. If you are planning to buy and sell within a short period, beta is a good measure of risk.  However, as a single predictor in long-term investment, the beta has too many flaws. Careful consideration of a company’s fundamentals will give you a much better picture of the potential long-term risk. Beta is also useful in reducing the combined systematic risk of the portfolio. If an investor has a portfolio of highly volatile stock which had beta greater than 1 during the past one year, then it make sense to reduce overall portfolio risk by adding defensive stocks having beta less than 1.

END OF SECTION E

 

END OF QUESTION PAPER

 

 


 

Suggested Answers
Security Analysis-II (212): January 2006

Section D : Case Study

1.      The consumer markets in India are constantly evolving. Indian market was characterized by some major structural changes like changes in income distribution, increased product availability (in terms of both quality and quantity), increased competition, increased media penetration and improved advertising (impacting lifestyle). These raised the levels of consumer awareness and propensity to consume, etc. The consumer markets in India have entered the new phase of evolution with the turn of the century. And, therefore, the need for detailed and consolidated market information. Among other factors, an analyst should research those relating to supply and demand for FMCG products.

         Demand is affected by demographics, household income, occupational demographics, consumer finance and the overall market structure based on household well–being. These factors affect the demand positively and negatively and the analyst should predict the direction and magnitude these factors have on FMCG companies. Along with Demand of the products in the sector, analyst should also forecast the supply side of the products to know the exact market situation. Supply is affected by Availability of raw materials, Technological capability, Availability of substitutes, Cost of production, Entry and exit barriers, Market size, Access of distribution network, Changes in governmental policies, Climatic changes etc.

         Thus, for forecasting the revenue of the companies an analyst should know the demand and supply factor affecting the product. An analysis of company’s economic and industry context is the first step in understanding the company, as similar economic and technological factors typically affect all companies in an industry. An analyst should know the basic inputs for the industry and how those inputs are affected by the economic, political, social and technological factors.

< TOP >

2.     

                                                                                                                                                                  (Rs. million)       

Particulars

31.3.2005

31.3.2004

31.3.2003

31.3.2002

31.3.2001

Net sales

12,310.95

10,864.76

11,629.27

11,069.97

11,132.54

Profit Before Tax

1,609.86

1,105.23

948.79

720.18

874.23

Profit After Tax

1,439.88

982.86

844.52

609.51

801.73

Net worth

3,380.74

2,686.58

4,110.91

4,003.71

3,622.02

Total Assets

7217.08

5526.60

7365.64

7787.94

7158.35

 

Total assets turnover ratio (NS/TA)

1.7058

1.9659

1.5789

1.4214

1.5552

Leverage ratio (TA/NW)

2.1348

2.0571

1.7917

1.9452

1.9763

Pre–tax Profitability ratio (PBT/NS)

0.1308

0.1017

0.0816

0.0651

0.0785

(PAT /PBT)

0.8944

0.8893

0.8901

0.8463

0.9171

Return on equity (ROE)

0.4259

0.3658

0.2054

0.1522

0.2213

 

         Return on Equity for the year 2001–02 has decreased, but then it has risen from the previous levels. Taxability effect on profitability is more or less constant except in the year 2000–01. Asset turnover has decrease in the year 2001–02 and 04–05. Net worth shows a volatile picture. This is due to the Demerger of Pharma business from Dabur India Ltd. In the year 2003–04 it has increased, and then it dropped in the year 2003–04 and again increased in the year 2004–05. Thus, Leverage ratio for the company after the demerger is on the higher side. Pre–tax profitability is increasing except in the year 2001–02 and increase in this ratio is the main reason for increase in the Return on Equity ratio.

< TOP >

3.      (a)

Particulars

31.3.2005

31.3.2004

31.3.2003

31.3.2002

31.3.2001

Net Profit

1439.88

982.86

844.52

609.51

801.73

Growth

46.50%

16.38%

38.56%

–23.98%

 

Simple average growth rate: –

= 46.5 +16.38 + 38.56 – 23.98 / 4

=77.46 / 4 = 19.365 %.

EPS as on 31st March 2005= 1439.88 / 286.42 = 5.03.

EPS Projected = 5.03 (1.19365) = Rs. 6.00

Market price as on 31st March 2005 = Rs. 111.05

Therefore, P/E based on Simple growth rate = 111.05 / 6 = 18.5083  19.

b.     

            EPS as on 31st March 2005 = Rs. 5.03

Market price as on 31st March 2005= Rs.111.05

Free cash flow

Capital expenditure = 2009.37 – 1486.06 = Rs. 523.31Mn

Depreciation = Rs. 185.92 Mn

Investment in working capital = Rs. (574.16) Mn

Debt ratio= 1– 0.067 = 0.933.

 

(Capital expenditure – Depreciation) (1 – b)

314.79

(Change in Working Capital) (1 – b)

(535.69)

 

                Per share Capital expenditure = 314.79 / 286.42 = 1.10

                Per share Change in working capital = (535.69) / 286.42 = (1.87)

 

Particulars

As on 31.3.2005

EPS

5.03

(Capital expenditure – Depreciation) (1 – b)

1.10

(Change in Working Capital) (1 – b)

(1.87)

Free Cash Flow to Equity (FCFE)

5.80

 

 

Year

EPS

31st March ‘ 05

5.80

1

5.80 (1 + g)

2

5.80 (1 + g)2

3

5.80 (1 + g)3

4

5.80 (1 + g)4

5

5.80 (1 + g)5

6

5.80 (1 + g)5 (1 + g – m)

7

5.80 (1 + g)5 (1 + g – m) (1 + g – 2m)

8

5.80 (1 + g)5 (1 + g – m) (1 + g – 2m) (1 + g – 3m)

9

5.80 (1 + g)5 (1 + g – m) (1 + g – 2m) (1 + g – 3m) (1 + g –4m)

10

5.80 (1 + g)5 (1 + g – m) (1 + g– 2m) (1 + g – 3m) (1 + g– 4m) (1.05)

               

                Where, m =

 

 

               

 

                10% growth rate

Year

FCFE

P.V. factor @ 12%

 

31st March ‘ 05

5.80

 

 

1

6.38

0.8929

5.70

2

7.02

0.7972

5.59

3

7.72

0.7118

5.49

4

8.49

0.6355

5.40

5

9.34

0.5674

5.30

6

10.18

0.5066

5.16

7

11.00

0.4523

4.97

8

11.77

0.4039

4.75

9

12.47

0.3606

4.50

 

187.05

0.3606

67.45

 

 

 

114.32

                Terminal value = (12.47) (1.05)/0.07 = Rs. 187.05

 

                8% growth rate

Year

FCFE

P.V. factor @ 12%

 

31st March ‘ 05

5.80

 

 

1

6.26

0.8929

5.59

2

6.77

0.7972

5.39

3

7.31

0.7118

5.20

4

7.89

0.6355

5.01

5

8.52

0.5674

4.84

6

9.15

0.5066

4.64

7

9.78

0.4523

4.42

8

10.38

0.4039

4.19

9

10.96

0.3606

3.95

 

164.40

0.3606

59.28

 

 

 

102.53

 

Terminal Value = (10.96) (1.05)/0.07 = 164.40

 

Through trial and error method,

 

.

< TOP >

 

4.     

Month

Close price (Rs.)

Return on the stock (%)

Closing value of Index

Return on the market

()

()

(6) x (7)

(1)

(2)

(3) (Ri)

(4)

(5) (Rm)

(6)

(7)

 

 

 

September-04

73.00

 

1745.50

 

 

 

 

 

 

October-04

80.65

10.48

1786.90

2.37

3.47

-1.17

-4.05

12.04

1.36

November-04

88.05

9.18

1958.80

9.62

2.17

6.08

13.17

4.69

36.97

December-04

92.20

4.71

2080.50

6.21

-2.30

2.67

-6.14

5.28

7.14

January-05

101.35

9.92

2057.60

-1.10

2.91

-4.64

-13.52

8.49

21.54

February-05

115.70

14.16

2103.25

2.22

7.15

-1.32

-9.45

51.11

1.75

March-05

111.05

-4.02

2035.65

-3.21

-11.03

-6.75

74.49

121.64

45.62

April-05

116.25

4.68

1902.50

-6.54

-2.33

-10.08

23.46

5.42

101.62

May-05

128.65

10.67

2087.55

9.73

3.66

6.19

22.62

13.37

38.27

June-05

131.35

2.10

2220.60

6.37

-4.91

2.83

-13.92

24.12

8.03

July-05

145.40

10.70

2312.30

4.13

3.69

0.59

2.17

13.59

0.35

August-05

153.50

5.57

2384.65

3.13

-1.44

-0.41

0.59

2.07

0.17

September-05

162.75

6.03

2611.20

9.50

-0.98

5.96

-5.86

0.97

35.53

 

Total

84.17

 

42.43

 

 

83.56

262.78

298.35

 

Average

7.01

 

3.54

 

 

 

 

 

         Standard deviation of return on the stock = 4.89 (%)

         Variance of the market returns = 27.12 (%)2

         Beta = Covariance / Variance on the market =

Systematic risk = b2 x Variancem = (0.28)2 x 27.12

2.13 (%)2

Variance of the stock = (4.89)2

23.89 (%)2

Unsystematic risk = 23.89  – 2.13

21.76 (%)2

Unsystematic risk as a % of total risk

91.08%

         As the unsystematic risk is more than 60%, the given investor should not make the investment.

< TOP >

5.      Valuing a company with inconsistent schedule of earning, or worse, with no earning at all requires a delicate balancing act on part of the analysts. At these instances, traditional methods of valuations befall to helplessness. That’s where the price/sales ratio comes in. Just like its more popular alternative the P/E ratio, PSR (Price-to-Sales Ratio) is useful to value any company. Price-to-Sales Ratio for a company can be calculated by dividing the market capitalization of a company by its total revenue for the last four quarters. As compared to PE ratio, Price-to-Sales Ratio is a more reliable measure because, unlike earnings, revenue for a company is difficult to manipulate. Besides earnings is a complex figure which may include inflows from non-recurring events also. Therefore, analysts look to both the PE ratio and PS ratio of companies before taking any investment decision. PS ratio is useful while valuing companies even with no earnings at all. PS ratio comes handy to value companies in today’s dynamic set-up where mergers and divestitures are a part of the daily routine. For examples, need for economy of scale has driven companies in telecom sector for sometime. Owing to write-offs related to merger, several such companies report negative earnings soon after the process. However, strategically and fundamentally, the company may well be on its way to a bright future. This can be verified by analyzing the Price-to-Sales Ratio, which may be growing immediately after the merger, thus presenting a more realistic presentation of the prospect for the company.

         Like any other ratio, a high or low PS ratio connotes different interpretations for an analyst. High or low PS ratio depends on the profit margin of the company. Thus, PS ratio for a steel manufacturer may vary from the PS ratio for a chip maker.

         Price-to-Sales Ratio may also vary consequent to the capital structure of the company. A company with a lot of debt component in its balance sheet may have to allocate more resources for servicing the interest burden, and thus might see erosion in its profits. Another problem with PSR is that sales figure does not contain any information about the debt burden of the company. Thus, it may so happen that some companies may have no profits but only huge debt and could be on the verge of bankruptcy. Due to all these, it is advisable to compare both the PE ratio and PS ratio for the company on a historical basis for a reliable analysis. Mathematically, relationship between these two ratios can be established Ratio x (Profit Margin)

< TOP >

6.       At point A, the price line rises above the moving average line, which is showing a slight down trend. It is an indication to sell. Around that time, the MACD indicator crosses the reference line from below (C), and it is an indication to buy.

         At point B, the price line falls below the moving average line which is showing an uptrend. It can be considered a secondary reaction and a bounce back of prices should be expected and it is an indication to buy. In October, the MACD line crosses the reference line from above (D) and hence is an indication to sell.

< TOP >

Section E: Caselets

Caselet 1

 

7.      SEBI defines Insider trading as any trading by a person who is or was connected with the company or is deemed to have been connected with the company and who is reasonably expected to have access, by virtue of such connection, to unpublished price sensitive information in respect of securities of the company, or who has received or has access to such unpublished price-sensitive information. The parties to the insider trading can be promoters, directors, management, lawyers, accountants, investment bankers, public relation punters and just about anybody with information pertaining to the transaction. The insiders buy the stock in advance, with sufficient information in their hand that sends the price upside and they sell those securities, when the announcement of that price sensitive deal is finally announced, and that’s how they make profit. Someone in the company intimates a group of brokers who are quick to take a position on the stock and by that time the announcement takes place where everybody has profited. The information leaks out when the deal is on the negotiation table, and the point when it is intimated to the stock exchange under the deal is accomplished the insiders cash in. The investment bank concerned in the relevant deal would also be privy to the price sensitive information and the insider trading can take place from there too.

< TOP >

8.      Insider trading is illegal in India with punishments ranging from hefty fines to jail terms. According to SEBI regulations, a person involved in insider trading can be penalized for 25 crores or three times the profit made out of insider trading whichever is higher. Securities & Exchange Board of India (SEBI) follows a standard investigation procedure for cracking down the insider trading. SEBI watches all market movements and captures any unusual movements or deviation in prices and volumes. SEBI also watches Employees, including Directors, in possession of any unpublished price sensitive information, pertaining to the Company, and their involvement in the transactions related to the shares As these persons shall not:
buy/sell securities of the Company, either on their own behalf or on behalf of any other person or Communicate, counsel or procure any unpublished price sensitive information to / from any person. But inspite of this insider trading is still on. This is because; it is not easy to nail an insider and it is notoriously difficult to pin down because much more data is required to be collated to come close to proving that. Insider trading can rarely be proven.

< TOP >

Caselet 2

9.       Support and resistance are the key point where the forces of demand and supply convene. Usually supply drives the price down and demand increases the price. Thus excess supply is related with bear signal and excess demand is a signal of bullishness. When supply and demand are equal, prices will move sideways. The support and resistance level is an example of the supply and demand theory, where the supply explains the number of shares the seller is willing to give and demand explains the number of shares a buyer is willing to purchase. Thus at higher prices more investor are willing to sell and number of seller increases in the expectation of selling at higher prices, on the other hand the number of buyers decreases as only few investors are willing to buy at higher prices. A breakout above a resistance level is evidence of an upward shift in the demand line as more buyers become willing to buy at higher prices. Similarly, the failure of a support level shows that the supply line has shifted downward. Thus bull pushes prices higher and bear lowers the prices and the direction of prices will show who had actually won the battle. Bull will come in the picture at the support level and prevent the price from falling lower. On the opposite, bear will take control at resistance level and stop the price from rising higher. The trade will take place at the price where both bull and bear agree to do business and this shows the harmony in the idea.

< TOP >

10.    The following principles are to be applied while using support and resistance lines     for trend analysis:

i.         Support and resistance lines are only approximations of the levels, prices may be expected to ‘obey’. They should, therefore, be drawn using judgement, and clues from the past price behavior.

ii.        Penetration of a support and resistance line, also confirmed by an underlying price pattern, is a fairly sure indication of a strong ensuing move in the same direction. New highs are reached after a resistance line is penetrated and new low follow penetration of a support line.

iii.      Prices are said to remain in a ‘congestion zone’ as long as they fluctuate in narrow ranges within a support and resistance level. The direction of breakout from a congestion zone cannot be predicted in advance.

iv.      The higher the volume accompanying the confirmation of a support or resistance level, the more its significance.

v.       The speed and extent of the previous move determines the significance of a support or resistance level. Prices penetrate support (resistance) level generally after slowing down from a previous low (high) and hovering around a level for sometime.

         Support and resistance levels repeat their effectiveness time and again, even if separated by many years.

< TOP >

Caselet 3

11.    The various types of beta values are as under:

Negative beta - A beta less than 0 - which would indicate an inverse relation to the market - is possible but highly unlikely. Some investors used to believe that gold and gold stocks should have negative betas because they tended to do better when the stock market declined, but this hasn't proved to be true over the long term.

Beta of 0 - Basically, cash has a beta of 0. In other words, regardless of which way the market moves, the value of cash remains unchanged (given no inflation).

Beta between 0 and 1 - Companies with volatilities lower than the market have a beta of less than 1 (but more than 0).

Beta of 1 - A beta of 1 represents the volatility of the given index used to represent the overall market, against which other stocks and their betas are measured.

Beta greater than 1 - This denotes a volatility that is greater than the broad-based index. Technology companies on the Nifty have a beta higher than 1.

Beta greater than 100 - This is impossible as it essentially denotes a volatility that is 100 times greater than the market. If a stock had a beta of 100, it would be expected to go to 0 on any decline in the stock market. If you ever see a beta of over 100 on a research site it is usually the result of a statistical error, or the given stock has experienced large swings due to low liquidity, such as an over the counter stock. For the most part, stocks of well-known companies rarely ever have a beta higher than 4.

< TOP >

12.     Beta seems to be good measure for determining risk of an investment but there are some problems with relying on beta scores alone.

·       Beta looks backward and history is not always an accurate predictor of the future.

·       Beta also doesn’t account for changes that are in the works, such as new lines of business or industry shifts.

·       The stocks, which have substantial weight in the portfolio, may result in a lower beta implying that the risk is very low and the other stocks may result in a higher beta implying that the stocks are risky. Thus the accuracy of the beta estimate is based on the right index chosen.

·       Beta suggests a stock’s price volatility relative to the whole market, but that volatility can be upward as well as downward movement. In a sustained advancing market, a stock that is outperforming the whole market would have a beta greater than 1.

·       Before estimating the beta one needs to decide the time horizon over which the regression has to be made. If only few observations are made then the estimate may not reflect the true beta.

·       Accuracy of the beta also depends on the time interval over which the returns are computed. The interval should be chosen based on the trading cycle of the user i.e. if the trading cycle is daily it is better to have monthly returns for regression otherwise results may not be truly reflecting the changes.

 

< TOP >

13.    If we consider the general economic cycle it will be like slowdown in the economy, a recession, revival in the economic activity followed by and economic boom and then slowdown. If we observe the economic activity during each of these phases we find that each one is a distinct phase. The characteristics of slowdown in the economy are different from that of economic recession and the characteristics of recession are different from the characteristics of the revival in the economy. That is, any parameter computed in one phase may not be applicable to study the characteristics of any other phase. Similar is the problem with Beta also. A Beta computed during periods of recession is not applicable during the periods of boom or during the periods of economic revival. It has to be adjusted properly in order to reflect he characteristics of the period under study. Therefore, beta which denotes the systematic risk or undiversified risk component computed in some other period fails to reflect correctly the associated risk of a stock during periods of economic slowdown and recession.

< TOP >

< TOP OF THE DOCUMENT >