Linking Financial Ratios and Stock Returns

Chapter I INTRODUCTION pecuniary pro role analysis is a technique for trying to help interpret monetary reports and to determine the intrinsic re valuate of a credentials by c atomic takings 18ful examination of key economic survey drivers lots(prenominal) as risk, maturement, and competitive position. Various dimensions can be footing from the pecuniary accounts. These proportionalitys ordain then help us to examine the lodges performance over a number of diaphragms by canvass the identical dimensions in previous classs accounts and excessively the accounts of sepa rove line of businesses operating(a) in a similar environment (Most common benchmarks atomic number 18 exertion leaders and application averages). monetary ratio analysis provides inborn learning and serve (Investors, Stockholders, l block upers, corporation circumspection, Fundamental analysts. ) with a lot of distinguish fit contexts for varied kinds of decisions. 1. 1 Statement o f the Problem The enormous number of monetary ratios utilize by fiscal managers and financial analysts and their coitionship with agate line give up is the principal(prenominal) problem in interpreting the financial statements. found on, the ultimate oddment of financial managers is to maximize the wealth of their business lineholders financial managers must understand the engender-to doe with of their managerial decisions on their political partys financial statements and financial ratios think which volition consequently ingrain the fall price of their comp either. Interpreting such a huge number of ratios distracts attention from the around(prenominal) relevant factors that affect live course prices. 1. 2 Purpose of the studyA number of studies such as Timo Salmi (1990) were conducted to reduce the information load resulting from com come ining a outsized number of ratios and categorize those ratios that were believed valuable. This study aims to identify th ose variables that are intimately relevant to the stock lights of pharmaceutic welkin in Egyptian stock grocery store. 1. 3 Statement of objectives This study attempt to achieve the fol let outing objective -The approximately relevant nonsymbiotic variables (financial ratios) with stock returns as a dependent variable.Chapter II FINANCIAL RATIOS AND STOCK MARKET 2. 1 Literature Review The main goal of our research is to pronounce the congenatorship in the midst of common financial ratios as independent variables and stock returns of the pharmaceutic business smasheds as dependent variable. The relation mingled with financial statement information and stock return was examined by Ou and Penman (1989) who observed returns to investment strategies that are based on a bar that summarizes the information in financial statements to identify the relevant financial ratios.Their study indicate that the predicted returns can non be let finished by return based risk measures a nd that financial statements capture fundamentals that are non reflected in stock prices. The results of the study suggest that it is possible for investors to shew waste ne bothrks utilise publicly lendable information. More recently, the relation in the midst of financial statement information and stock return was ex escapeed by Holtausen and larcker (1992) who identify look upon-relevant fundamentals in the context of a return-fundamentals relation.Holtausen (1992) examined the faculty of be information to sire profitable art strategies (using 60 accounting ratios). The wasted returns were observed in the fourth month following the caller-ups fiscal course of instruction end. The results of the study suggest that the trading strategy was able to earn momentously abnormal returns during the conclusion of 1978-1988. The equal loss was examined ulterior by Lev and Thiagarajan (1993) who used fundamental ratios as the basis of analysts description of several(pred icate) ratios to identify the value relevance of the financial ratios and their value in security valuation.Afterward, Belkoui (1997) employed the common financial ratios to show the value relevance, where the hotity of these financial ratios is matched by their usefulness in security valuation. He shows that value relevance of popular financial ratios in both a non contextual setting and a setting conditioned by trains of inflation and growth. 2. 2 Classification of financial ratios The classification of financial ratios was studied by Timo Salmi (1990) who split these financial ratios into quintet-spot somewhat arbitrary groups Profit exponent how good is the business as an investment. runniness the amount of sueing chief city available. Capital Adequacy measure the leverage percentage. Debt service coverage how near is the business to bankruptcy. Efficiency how good is the management of the business. Each financial ratio has its own signal and its own relation to t he stock return. Based on these previous studies, the study selected the around popular financial ratios guided in major(ip) financial analysis books such as Mishkin (2001) 2. 3 An overview of Egyptian stock sup proveEgyptWatch (2002) studied the freshlys report of the egyptian stock exchange and mentioned that the Egyptian Stock Exchange is comprised of ii exchanges the peachy of Egypt &038 Alexandria Stock Exchanges (CASE), and is governed by the same board of directors that lot the same trading, clearing &038 settlement systems. The Alexandria Stock Exchange was move outici each(prenominal)y established in 1888 followed by that of Cairo in 1903. The two Exchanges were precise active until the 1940s, when the Egyptian Stock Exchange ranked fifth in the world.Nevertheless, the political din of the mid-1950s led to the demise of exercise on the Exchange, which remained dormant throughout the period among 1961 and 1992 (MohieEldin and Sourial, 2000). In 1990, the Egyptia n politics started on economic restore &038 restructuring program. The move towards a free- marketplace economy has been remarkably swift and the process of deregulating and privatization has simulated stock market activity.The Capital securities industry Authority (2002) play an instrumental authority in initiating and leading the effort for the revival of the Egyptian stock market in the period between 1992 and 1996. The Capital food market Authority (CMA) is the restrictive body in charge of enforcing, regulating &038 ensuring conformism as well as monitoring market performance. Relevant indemnity actions undertaken by the CMA include introducing all types of investment vehicles, allowing open competition in the pricing of market services and providing exuberant investor protection.The main features of the ope clear-sighted exemplar are fair trading procedures and practices as well as an prompt transfer of ownership of divvy upd securities optional listing on the sto ck exchange quarterly disclosure requirements for companies adequate protection of minority dole outholder rights and meliorate data collection schemes. Capital police 95/1992 has put in place the regulatory framework in which financial intermediaries such as brokers, venture- jacket crown steadys, underwriters and fund managers are to operate.With respect to the managerial framework of CASE, a dogged organizational structure with a clear division of authority &038 responsibilities was established, creating new divisions &038 departments such as unexclusiveations &038 national Relations, Research, Surveillance &038 foodstuff Control, and Information Technology. Additionally, in May 1998, CASE signed a contract with EFA Software Ltd. , to huckster the new electronic trading, clearing &038 settlement system that will step in the existing one. The Board of Directors athe likes of set up several(prenominal) committees with specific responsibilities.At the senior level, an in ternational advisory committee made up of internationally prominent economists, investment bankers, financiers &038 investors has been developed in order to tell that CASE stays closely linked to the intl arena. This group overly provides continuous feedback on its policies. Both the CMA &038 the CASE monitor market activity to detect possible market manipulation or insider trading. Accordingly, they whitethorn hang offers &038 bids for institutions suspected of price manipulation.In the case of an emergency, the CASE and/or the CMA may halt trading and/or place ceilings on floors trading prices (maximum 5% up or down), based on the closing prices of the preceding day. In the case of individuals, mutual funds &038 international funds, no taxes are levied on sortnds, capital gain &038 enkindle on bonds. Profits of Egyptian corporations from securities investments are subject to a capital gains tax. 2. 3. 1 Recent developments On 21 July 2002, CASE commenced its new price ceiling system with regard to the most actively traded stocks.According to the new practice, the five-percent ceiling on daily prices was outside for a set of selected active stocks ( incumbently twelve). This set of stocks comprises 12 out of the most actively traded stocks on CASE. The chosen of this set of stocks was based on meeting some stated criteria decided by CASE (2002) Stocks must be dematerialized. Minimum trading days per confederacy per year is 220. Average number of proceedings per stock must be 20. Minimum market capitalization per conjunction amounts to LE 200 million. Minimum free float amounts to 15 percent of the be listed treats. Minimum derangement ratio per company is 10 percent. The company must prepare financial statements for three consecutive years. proceedings conducted on the shares of the company must be executed by at least 20 brokerage unwaveringlys. The new practice will pin down the halt of trading on any of the twelve stocks for a period of th irty minutes, forty-five minutes or till the end of the trading session, if the stock prevailing weighted average price exceeds 10 percent, 15 percent or 20 percent respectively over spread price.When trading is halted, brokers should inform their clients rough the temporary suspension, its reasons, duration and should take the indispensable actions in order to fulfill their clients requests. Brokers are allowed to cancel, any of their clients orders, when trading is halted. 2. 3. 2 Background of Privatization computer programme The Ministry of world opening (MPE) is dedicated to achieve the long-term goal of complete implementation of Egypts overall privatization plan. In 1991 Public Enterprise Law No. 203 was introduced as a transitional measure. Dr. Khatab M. (Minister of Public Enterprise) (2002) has explained hisMinistrys plans and objectives to facilitate privatization in Egypt and the orders that hit been followed in this regard. Also Dr. Mokhtar Khatab has mentioned to the disposal of Egypt (GOE) his efforts in undertaking an extensive privatization program whereby state-owned companies are transferred to the cloak-and-dagger vault of heaven through several methods McKinney (1996). The transfer of ownership &038 control of state-owned enterprise to the private sector through a partial or a full public share flotation on both the domestic or foreign stock exchanges. Direct sale of a dogmatic interest to domestic or foreign investors. Direct sale of a controlling interest to employees. The law also allows the sale or lease of company assets, unlimited sale of government-owned shares, or liquidation. Primary objectives of the plan are to generate high(prenominal) productivity and faster (but sustainable) growth, and as a consequence an ontogeny in returns on assets and equity composition at the same conviction raising internal energy, improving capital structure and increasing capital expenditure. Since the early 1990s a number of key programs entertain been put into place to greatly liberalize commerce and trade and to re-frame the countrys legal, regulatory, judicial, and tax structures.An equally important focus of the plan is the creation of new jobs that an expanding economy will provide for the workforce. Over the past five years, the GOE has achieved rattling gratifying results in macroeconomic terms. This is due to the creation of policies to remove trade barriers, the reform of trade and financial markets, and the reform of the legal taxation and regulatory frameworks, Field (1995) 2. 3. 3 Updates on the Situation of the Privatized Companies The Government of Egypt (GOE) has designed a balanced privatization program, which includes the following share gross sales strategies.The Egyptian Ministry of Public Enterprise Sector (2001) revealed that Public Offerings on the Cairo and Alexandria Stock Exchange 37 companies extradite so far been authorize by the GOE for privatization and gestate been ch ange through Initial Public Offering (IPO) or second offerings. The sales of these companies netted 5. 6 billion jampacks which represents 36% of privatization proceeds to date. 16 companies waste achieved partial privatization netting the government nearly 1. 76 billion LE. barter to Anchor and Strategic Investors 3 companies have been privatized by this method, accounting for 6. 4 billion pounds LE in proceeds to the government. Sales to anchor investors have amounted to 42% of the total privatization proceeds thus far. Employee Stock Ownership Programs (ESOPs) The GOE has approved the allocation through the sale of 10 percent of the public enterprises share offerings to the employees as part of the Employee Stock Ownership Program. In early(a) cases, and according to the circumstance circumstances of each company, the majority of shares have been change to its management and employees.To date, mainly medium-sized companies in the public works sector have implemented this sc heme. So far, 30 Employee Shareholder Association (ESA) sales transactions have taken place bringing in 870 million pounds LE. strike Management Contracts In this method, Companies were offered for management by the government to the private sector with an option to buy at a future date. This alternative is not very distinguishable to the anchor investor approach if and when the managing company exercises its option to buy. v contracts of this type are topically active. Chapter III PHARMACEUTICAL SECTOR OVERVIEWThe government has set a 40% ceiling (maximum that could be privatized), 10% of which is reserved for Employee Shareholder Associations (ESA), on the privatization of any public pharmaceutic company. The restriction relates to the governments desire to maintain control of the industry for its world-shattering role in society, The Egyptian Ministry of Public Enterprise Sector (2001). The first five companies that have been privatized Alexandria, Cairo, Memphis, Arab and Nile pharmaceuticals. These companies have already been 40% privatized. The privatization plan then spread out to cover 11 companies at the end of June 2002. . 1 pharmaceutic industry Highlights Drug policy and planning center (2002) has published the following statistics 199920002001 Market Size (LE bn)4. 655. 42 No. of Products (thousand)3. 63. 84 Per capita spending (LE)72. 6677. 1882. 14 3. 2 pharmaceutic Products Total exports made by Egypt to the whole world includes a lot of commodities which are classified to (Fuels Products, Cotton, Raw Materials, Semi washed-up commodities and finish commodities). central Bank of Egypt (2002) revealed that Pharmaceutical products are look into as part of finished commodities, they represent 3% of finished commodities and 1. % of the total export. Also, Pharmaceutical products play a significant role in Egypts import. They represent 4% of the total import and 21% of their classification division (consumer goods). Figure (1) shows Pha rmaceutical exporting and Import situation. Figure (1) Local production of medicine satisfies 92% of the market demand, whereas the remainder is balanced by imports. Kompass Egypt (2002-2003) classified the local market players as 1) Public-sector companies. 2) one-on-one-sector companies. 3) Multinationals Figure (2) Note The term Private sector encompasses Multinationals and another(prenominal) Private companies.The government has set a relatively low tariff on imported medicates, which averages around 5%. The main reason for this comparatively low duty is the states policy of making medicine available to the bulk of the commonwealth at the cheapest possible price. 3. 3 Pricing form _or_ system of government Prior to the reform program in 1991, the governments major consideration when setting prices for drugs was to make medicine affordable to the bulk of the population regardless of a companys cost structure. The focus on the social role of medicine, rather than the positi vity of pharmaceutical companies, is the main reason behind this policy.The Drug constitution &038 Planning Center (DPPC) is the main regulatory authority controlling the pharmaceutical industry. The center is in charge of drug registration and pricing. The DPPC (2002) uses a Cost Plus Formula to price drugs. The order stipulates a price equivalent to the products cost plus a real profit beach. The profit permissiveness is 25% for nonessential products, and 15% for essential products. It is notepricey that once a product has been priced, it is seldom eligible for re-pricing to account for increasing costs.The heavy drop in the value of the Egyptian pound was mirrored in an increasing raw material costs burdening the Egyptian Pharmaceutical companies, which import around 80% of their raw material requirements. In order to save the profit valuation accounts from the aftermath of the devaluation, the Ministry of Health finally concur to raise the prices of five products for each pharmaceutical company starting February 2002. 3. 4 GATT and TRIPS Egypt is a signatory to the General Agreement on Tariffs and Trade (GATT) which will come into effect for the pharmaceutical sector in Egypt in 2005.The proportionateness is likely to have serious repercussions for the pharmaceutical industries of developing countries including Egypt. The pledge calls for the abolition of both quantitative and qualitative barriers to entry for pharmaceutical products, thus eliminating any governmental protection of the industry. Under GATT, Egyptian companies have to abide by the restrictions imposed by patents and property rights for a period of 20 years. Based on the Egyptian commitment with the agreement on Trade-Related Aspects of Intellectual plaza Rights (TRIPS), which is part of the GATT, President of Egypt published The Law No. 2 for year (2002), calling for the Protection of any invention whether industrial or intellectual. The agreement will result in the extension of a patent to 20 years and will grant protection to the product and the production process. Chapter IV METHODOLOGY AND EMPERICAL MODELS 4. 1 Data Set In our study, we select all the pharmaceutical companies quoted in the Egyptian stock exchange which consists of 11 pharmaceutical companies representing the pharmaceutical sector. We covered the period from 1996 to 2001. Analyzing six continuous years of data, inflect and support results and give our conclusion stability and reasonability.Kompass Egypt monetary Year password and the Egyptian Capital Market Authority were the prime sources for our data set. Additionally, for the designing of this analysis, we prefigure the returns using one-yearly prices of securities for years starting from 1996 to 2001. 4. 2 endurance of Financial proportions (Independent variables) According to the literature, we determine the most useful financial ratios that could be functional in security valuation by analyzing and comparing several papers an d texts were analyzed and differentiated.The reasons behind the selection of these financial ratios Their talent in theoretical explanation of fundamental bloods and signals experienced by the pixilateds. Foster 1986 The importance of their innovation in published annual reports. Gibson 1982 Surveys proved that chief executive officers and other senior executives are concerning popular financial ratios for various types of decision making. Walsh 1984 The following table provides the most common financial ratios that might affect stock returns.For each financial ratio, we provide the way of calculation, the hypothesized collateral or negatively charged relationship with stock returns. Table (1) The common financial ratios and their prediction with stock returns GroupFinancial ratiosVariablesEquationsPrediction of relationship ProfitabilityEarning per ShareEPS brighten income / Number of shares smashingPositive fork out on impartialityROENet income / owners equity Return on summationsROANet income / total assets Profit MarginPMNet income / total sales Liquidity present-day(prenominal) balanceCTR circulating(prenominal) assets / menses liabilitiesNegative truehearted ratioQR( new assets Inventory) / authoritative liabilities Operating hard currency spring RatioOCFCash draw from operations / on-going liabilitiesPositive LeverageDebt to Equity RatioDERLong term liabilities / owners equityNegative reportage elicit CoverageICEBIT / interest expensePositive EfficiencyAssets turnover rateATOSales r as yetue / Total assetsPositive dues TurnoverRTOSales / forecast Receivables EBIT Earnings forwards refer and Taxes We refer to the explanantion of these financial ratios (independent variables) in the Appendix section. . 3 Buy-and-Hold Returns (BHR) As far as the dependent variable is concerned, stock returns, there is no consensus on the appropriate methodology for astute the long-run stock returns (see among other, groom and Lyon, 1997 Kothari an d Warner, 1997 Brav and Gompers, 1997 and Barber, Lyon and Tsai, 1999). Researchers use several methods to calculate long run returns, in particular Buy-and-Hold returns (BHRs) method. The first step in calculating Buy-and Hold return method is to calculate rate of return on stocks.We consider that the appropriate rate of return on a given stock is the difference between the stock prices in clipping t plus dividends in clock t-1 and the stock prices in clipping t-1 , as follows (1) Where is the return for security I for period t, refers to the closing price of security I at meter t , and is the price of security I at cadence t-1 , is the dividend have for period t-1 for the solid I As far as we consider time t as a year, rate of return on stocks ( ) that we cypher from the previous equality is the Buy-and-Hold return method for a financial year. (2) Where is Buy-and-Hold Return for security i in period t. we consider it a year. 4. 4 retroversion Model To determine the rela tionship between the independent variables (financial ratios) and the dependent variable (stock return), we follow a similar methodology to that of Belkaoui (1997) and enumerate the following atavism (3) Where is the annual stock return of firm I at time t, is the earning per share for firm I at time t, is the return on equity for firm I at time t, is the return on assets for firm I at time t, is the profit margin for firm I at time t, is the current ratio for firm I at time t, is the quick ratio for firm I at time t, s the operating cash in flow for firm I at time t, is the debt to equity ratio for firm I at time t, is the interest coverage ratio for firm I at time t, is the asset turnover for firm I at time t, is the receivable turnover for firm I at time t. Since the return of a given stock is based on a period extending from 9 months prior to the fiscal year-end and 3 months after the fiscal year-end, corresponding roughly with the period between announcing the financial stat ement, the starting month would be declination for firms whose fiscal years end at Jun, the 30th and June for firms whose fiscal years end at December the 31st.CHAPTER V RESEARCH FINDINGS 5. 1 Results We present results of a statistical regression seat where independent variables in the regression equation are chosen in two ways (both general and step wise regression). Multicollinearity adjudicates the correlation among two or more than of the independent variables (financial ratios) used in the regression equation. Multicollinearity is a problem because it increases the likelihood of rounding errors in the calculation of the beta estimates and mensuration error, and also it may produces confusing and misleading (signs of beta parameters are different from those signs esteem) results (Mendenhall, 1996).Table (2) shows that the existing problem in this Multicollinearity is especially evident for the correlation between the Current Ratio and the Quick Ratio reaching 0. 92 an d significant at 99% level. Current Ratio and Quick Ratio are two faces for the same coin. They are categorized under liquidness ratios group, they have the same explanation active the result and there is a little bit difference in their equations (In Quick Ratio, Inventory is excluded from the Current Assets). So we eliminate Quick ratio from the independent variables (financial ratios) and retain on Current Ratio because it is more popular. Table (2)Correlation Matrix to explain the relationships among the financial ratios as independent variables VariablesQRATODERCTRICEPSOCFPMRTOROAROE QR1. 000 ATO-0. 4204*1. 000 DER0. 03920. 3860*1. 000 CTR0. 9239*-03478*0. 08801. 000 IC0. 3752*-0. 3246**-0. 15040. 3610*1. 000 EPS0. 1884-0. 2604**-0. 12480. 0724-0. 03061. 000 OCF0. 0641-0. 3243-0. 29300. 15720. 19970. 32021. 000 PM0. 1659-0. 4338*-0. 2835**0. 23450. 04750. 6245*0. 34311. 000 RTO-0. 2999**0. 1663-0. 0413-0. 0230-0. 0298-0. 19220. 6846*0. 16561. 000 ROA0. 0535-0. 1600-0. 4080*0. 16850. 17500. 6342*0. 6703*0. 6392*0. 3761*1. 000 ROE0. 1264-0. 1178-0. 01580. 21150. 10610. 11030. 8970. 2610**0. 18200. 3693*1. 000 * prodigious at the 1% level ** Significant at the 5% level Table (3) &038 (4) show the four-fold and step-wise regressions of the relationship between explanatory variables (financial ratios) and stock returns utilizing buy-and-hold return (BHR) method. The relationship between stock returns and common financial ratios is estimated using the following equation Where is the annual stock return of firm i at time t. BHR is deliberate as follows Where is buy- and- hold return for security i, in period T, T is the trading month number 12, and indicates the first event month of calculating the return. s the dependent variable in the regression equation. Table (3) octuple Regressions of the affinity between Financial Ratios and Stock Returns Independent variables BetaT testSig. T 1- Current ratio (CTR)0. 7821993. 0940. 0055* 2- Interest coverage ratio (IC)0. 6895873. 0850. 0056* 3 Profit margin ratio (PM)0. 6434102. 5740. 0177** 4- Earnings per share (EPS)0. 3790681. 1190. 2757 5- Operating cash flow ratio (OCF)0. 2002970. 5430. 5931 6- Assets turnover (ATO)0. 1150700. 4550. 6537 7- Return on Equity (ROE)0. 0966730. 5010. 6215 8- Debt to equity ratio (DER)0. 0622020. 3040. 7640 Receivables turnover (RTO)-0. 165573-0. 4660. 6457 10- Return on Assets (ROA)-0. 121268-0. 3320. 7433 Multiple R = 0. 68529F = 6. 76472 R square = 0. 46962Significant F = 0. 0031 * Significant at the 1% level ** Significant at the 5% level The results from table (3) show that the F test used to test the overall utility of the pretense indicates that the model is significant at the 99% level. However, the R square is 46. 96% indicating that the ten independent variables together explained slightly half of the divergency in the yearly return of pharmaceutical sector as a dependent variable.Also, T test of the individual Betas (financial ratios) indicate s that the most active ratios in determining stock returns are Current Ratio (CTR), Interest Coverage Ratio (IC) and Profit Margin Ratio (PM) with a significant level of 99%, 99% and 95% respectively. To check on the signs of the beta coefficient, the dependent variable (stock return) was regressed on each of the independent variables (financial ratios) and the signs of the resulting betas were checked against that of the original equation.There are three ratios which are Current Ratio, Receivable Turnover and Return on Assets that had different signs from the original regression equation The verificatory coefficient estimated for Current Ratio with stock returns is not expected because nonprogressive policies that tend to keep current asset high than current obligation have lower risk and also have lower expected return than the aggressive policies. So we conclude that rational investors put more pledge in low risky stocks and look forward for electrostatic stocks more than t he temporary profitable stocks.On the other hand, Receivable Turnover ratio and Return on Assets ratio are completely peanut as show in table (3), so there is nada important to explain their different signs from the original prediction. Table (4) Step-wise Regression of the Relationship between Financial Ratios and Stock Returns Independent variables R? BetaT testSig. T ChangeAccumulation 1- Current ratio 0. 194050. 194050. 7302745. 2990. 0000* 2- Interest coverage ratio 0. 121330. 315380. 7161115. 2420. 0000* 3 Profit margin ratio 0. 072850. 388230. 4597934. 1170. 0001* Multiple R = 0. 62308F= 12. 69213R square = 0. 38823 * Significant at the 1% level ** Significant at the 5% level In the next step, we utilize the step-wise regression to reach the final model that contains the significant explanatory variables and give better explanation for the relationship. Consistent with the general regression models, the step-wise results confirm the above mentioned findings as Current Ratio (CRT) is the most significant variable at the 99% and explained roughly 19% of the variance in the yearly return of pharmaceutical sector with R square about 19%, while R square for the model is about 39%.Interest coverage ratio has also explained about 12% of the variance in the yearly return of pharmaceutical sector. Interest coverage ratio is regarded as a measure of a companys recognitionworthiness because it shows how practically income there is to cover interest pay backments on outstanding debt. Profit margin ratio explained about 7% of the variance in the yearly return of pharmaceutical sector with R square 7%.From results we conclude that rational investors and stockholders are looking for medium and stability first then profitability when evaluating a pharmaceutical stock company. Table (5) Stepwise Multiple regression analysis for the good predictors Company R? BetaT testSig. T ChangeAccumulation 1- Memphis0. 466240. 466240. 73001412. 4530. 0000* 2- Cairo0. 213940. 6 80180. 6092937. 6880. 0000* 3- Alexandria0. 094360. 77454-0. 521862-4. 6470. 0001* Multiple R = 0. 88006F= 23. 73573 R square = 0. 77454 * Significant at the 1% level ** Significant at the 5% levelStepwise multiple regression model yielded a reduced equation containing only three companies (independent variables) explaining about 77% of the variance in the yearly return of pharmaceutical sector as a dependent variable the analysis yielded three good predictors as demonstrated at table (5), the results proved that Beta value of Memphis Pharmaceutical and Chemical Industries was 0. 73 and it is significant at 99% level. Additionally, Memphis Company altogether explained about 47% of the variance in the yearly return of the pharmaceutical sector.The second good predictor is Cairo Pharmaceutical and Chemical Industries while its Beta value was 0. 60 and it is significant at 99% level. Cairo Company alone explained about 21% and together with Memphis Company explained about 68% of the v ariance in the yearly return of the pharmaceutical sector. The ordinal and last predictor is Alexandria Pharmaceutical and Chemical Industries with a Beta value of -0. 52 and significant at 99% level. Alexandria Company explained alone about 9% of the variance in the yearly return. 5. 2 Summary and finisThe relationship between financial ratios and stock returns has been a popular issue in the area of accounting and finance for a long time, so we found that it is a good issue to discuss on the Egyptian stock market. Here, an analysis is undertaken to show the value relevance of the financial ratios and their usefulness in security valuation in the Egyptian pharmaceutical sector. In our research, we use step-wise multiple regressions between financial ratios and stock returns, also between pharmaceutical companies returns and pharmaceutical sector returns.The results from using step-wise and multi regression indicate that Current Ratio (CTR), Interest Coverage Ratio (IC) and Profit Margin Ratio (PM) respectively, are the most relevant ratios in determining stock returns. Additionally, Memphis Pharmaceutical and Chemical Industries is the most relevant company in explaining the variance of the pharmaceutical sector return as a whole. Finally, it seems that Current Ratio (CTR), Interest Coverage Ratio (IC) and Profit Margin Ratio (PM) play a significant role in mandateting investment decisions in the Egyptian stock market (specifically, Pharmaceutical sector).Egyptian rational investors put more effrontery in low risky stocks and look forward for stable stocks more than the temporary profitable stocks. 5. 3 Further Research The study was conducted on Egyptian pharmaceutical sector and taken all pharmaceutical companies (11 companies) that have been quoted in Egyptian stock exchange, covered the period from 1996 to 2001. Replicating the study on other sectors in Egypt such as (Agriculture, Food &038 Beverages, Construction, Banks) at different times could be v ery useful. The study could be also replicated on the valuable Egyptian market indices such as (Case 30, IFCG, MSCI, EFG Hermes).These studies could help in determining more clearly the relationship between financial ratios as independent variables and stock returns as dependent variable. CHAPTER VI REFRENCES Barber, B. , Lyon, J. , and Tsai, C. , (1999), Improved Methods for Tests of long run deviate Stock Returns, diary of Finance, 54 (1), 165-201. Baraber, B. , and Lyon, J. , (1997), Detecting long Abnormal Stock Returns The Empirical Power and Specification of Test Statistics, diary of Financial Economics, 43 (3), 41-72. Brav, A. , and Gompers, P. , (1997), Myth or Reality?The Long-Run Underperformance of Initial Public Offerings Evidence from Venture Capital and non-Venture Capital-Backed Companies, Journal of Finance, 52 (5). Capital Law 95/1992, Intermediation Companies, (CMA. gov. eg), gettable http//www. cma. gov. eg /En-nf/index4. hypertext mark-up language, (Access ed 2003, January 20). CASE, (2002), Whats New, (Egyptse. com), Available http//www. egyptse. com, (Accessed 2003, February 7). Central Bank of Egypt (2002), Proceeds of commodity Exports and Imports by degree of processing, (CBE. org. eg), Available http//www. cbe. org. g, (Accessed 2003, February 9). Charles, P. J. , (2002), Investments epitome and Management, Seventh edition, John Wiley &038 Sons Inc. , NY Third track. David, I. , and Pitman, (2001) Foundation for SME learning Key Financial Ratios Available www. google. com , (Financial Ratios). EgyptWatch, (2002), Egypt Stock Market, (Egyptwatch. com), Available http//www. egyptwatch. com/en/Finance/Indicators/stock. doc (Accessed 2003, February 16). Eugene F. B. , and Joel H. H. , (1998), Fundamentals of financial management, eightth edition, The Dryden Press. Field, M. (1995), The Slow itinerary to Privatization, Euro bullion, Middle eastside Markets Supplement, November 12-13. Foster, G. (1974). Financial statements Analy sis A New nuzzle, Englewood Cliffs, NJ Prentice Hall. Gibson, C. H. (1982a), How Industry Perceives Financial Ratios, Management Accounting. April, p. 13-19 Gibson, C. H. (1982b), Financial Ratios in Annual Reports, The CPA Journal, September, p. 18-29 Holthausen, R. W. , and Larcker, D. F. , (1992), The prediction of stock return using financial statement information, Journal of Accounting and Economics, Vol. 15, p. 373-412. John M. R. and Jeanne Y. H. (1998), The power of cash flow ratio, Journal of Accountancy, October, p. 53-55, 56-58, 60-61. Khatab, M. , (2002), Ministers Message, Available www. mpe-Egypt. gov. eg Kompass Egypt Financial Yearbook (2002 2003), Pharmaceutical &038 Health Care, Published by Fiani &038 Partners, Cairo, Egypt. Kothari, S. , and Warner, J. , (1997), Measuring Long-Run Horizon Security Price Performance, Journal of Financial Economics, 43 (3), 30-40. Lev, B. , and Thiagarajan, S. , (1993), Fundamental Information Analysis, Journal of Accounting Rese arch. Autumn, p. 190-250. McKinney, B. M. (1996), Recent Development in Egyptian Investment Policies and Programs, and Pending Reform Legislation Middle East Executive Reports, 19 (7), 9-12. Mendenhall, W. , and Sincich, T. , (1996), A Second Course in Statistics Regression Analysis, Fifth edition, Prentice Hall. Mishkin, F. S. (2001), The Economics of money, banking, and financial markets, Sixth Edition, Adison Wisely, Boston. MohieEldin, M. and Sourial, M. S. , institutional Aspects, Distributional Characteristics and Efficiency of Egyptian Securities Market, in Arab Stock Markets Recent Trends and Performance, modify by Riad Dahel, (Cairo AUC Press, 2000), 1-44.Ou, J. , Penman, S. 1989. Financial statement analysis and the prediction of stock returns, Journal of Accounting and Economics, Vol. 11, p. 295-330. Peter S. R. , (1999), Commercial bank management, fourth edition, McGraw-Hill Companies, NY Avenue of the Americas. Riahi-Belkaoui, A. (1997). Value relevance of popular fin ancial ratios, Advances in Quantitative Analysis of Finance and Accounting, Vol. 5, pp. 193-201. Ross, Westerfield, and Jaffe, (2002) Corporate Finance, Sixth edition, McGraw-Hill Companies, NY Avenue of the Americas. The Capital Market Authority, (2002), CMA Public Information Center, (CMA. ov. eg), Available http//www. cma. gov. eg/En-nf/index5. html (Accessed 2003, January 20). The Drug Policy and Planning Center, (2002), Pharmaceutical Industry Statistics, (DPPC. gov. eg), (Accessed 2003, February 10) The Egyptian Ministry of Public Enterprise Sector, (2001), Privatization Program performance from the start to February 2001, (Cairo MPES), http//www. mpe-egypt. gov. eg/privatize. aspmethods. (Accessed 2003, February 16) The Law No. 82 for year (2002), Trade-Related Aspects of Intellectual Property Rights (TRIPS), Pharmacy and Medicine, March 2003, Vol. 24, p. 44-55 Timo S. , Ilkka V. , Paavo Y.O. (1990), On the Classification of Financial Ratios, published on the Word Wide Web as http//www. uwasa. fi/ts/sera/sera. html Walsh, F. J. (1986), The Relative Information Content of Accruals and Cash Flows Combined Evidence at the Earnings Announcement and Annual Report Release Date Journal of Accounting Research, p. 165-200 CHAPTER VII APPENDIX (A) Financial Ratios Financial ratios are very important for new investors who would like to invest in the firm and also for stockholders who are the investors of the firm because financial ratios give them several indicators which they can evaluate the firm with. 1) Profitability Ratios The main goal of these ratios is to help us to guess how good the firms profit performance. Profitability ratios refer to the ability of a firm to generate revenues in excess of expenses. 1. 1 Earnings per Share The portion of a companys profit allocated to each outstanding share of a companys common stock. Earnings per share is only when a fundamental measure of profitability that shows how much profit was generated on a per-share-of-sto ck basis. EPS doesnt reveal a great deal.Its true value lies in comparing EPS figures across several quarters, or years, to judge the growth of a companys earnings on a per-share basis. David Irwin (2001) Therefore, perusing refers to a positive relationship between EPS and stock market return. To calculate EPS, start with net income (earnings) for the period in question, subtract the total value of any preferred stock dividends and then divide the resulting figure by the number of shares outstanding during that period. Or Net income / Number of shares outstanding 1. 2 Return on EquityROE is a fundamental denotation of a companys ability to increase its earnings per share and thus the quality of its stock, because it reveals how well a company is using its money to generate additional earnings. ROE allows investors to compare a companys use of their equity with other investments, and to compare the performance of companies in the same industry. ROE can also help to evaluate trends in a business. Businesses that generate high returns on equity are businesses that pay off their shareholders handsomely and create substantial assets for each dollar invested as mentioned by Peter S. 1999). To calculate ROE, divide the net income shown on the income statement by shareholders equity, which appears on the balance carpenters plane Net income / owners equity 1. 3 Return on Assets A Companys profitability expressed as a percentage of its total assets. Return on assets measures how effectively a company has used the total assets at its disposal to generate earnings. Because the ROA formula reflects total revenue, total cost, and assets deployed, the ratio itself reflects a managements ability to generate income during the course of a given period, usually a year.Ross (2002) Naturally, the high the return the better the profit performance. ROA is a convenient way of comparing a companys performance with that of its competitors. ROA should have a positive relationship w ith the stock market return. To calculate ROA, divide a companys net income by its total assets, then multiply by 100 to express the figure as a percentage Net income / total assets 1. 4 Profit Margin Profit Margin is a companys net profit or loss as a percentage of total sales for a given period, typically a year.This ratio shows how efficiently management uses the sales revenue, thus reflecting its ability to manage costs and overhead and operate efficiently. It also indicates a firms ability to withstand adverse conditions such as locomote prices, rising costs, or declining sales. Ross (2002) The higher the figure, the better a company is able to endure price wars and falling prices. Investors tend to prefer a higher percentage of profit margins, which considered being an indication of a positive relationship between profit margin and stock market return. The calculation is very base Net profit / total sales (2) Liquidity RatiosThese are ratios that measure the liquidity of the firm. Firms have to ensure that they have the liquidity involve to meet all their commitments. To the extent a firm has sufficient cash flow it will be able to avoid defaulting on its financial obligations and, thus avoid experiencing financial distress. 2. 1 Current Ratio Current ratio is the companys liquidity and its ability to meet its short-run debt obligations. By comparing a companys current assets with its current liabilities, the current ratio reflects its ability to pay its upcoming bills in the tall(a) event of all creditors demanding payment at once.Current liabilities are debts that are due within one year from the date of the balance sheet as mentioned by Charles P. (2002). The basic source from which to pay these debts is a current asset. As long as firms are searching for no risks by increasing current assets, profitability will be getting shrunk. So that current ratio should have a negative relationship with stock market return. Working capital is also called ne t current assets or current capital, and is expressed as Current assets / Current liabilities 2. 2 Quick RatioHow quickly a companys assets can be turned into cash, which is why assessment of a companys liquidity also is known as the quick ratio, or manifestly the sexually transmitted disease ratio. Regardless of how this ratio is labeled, it is considered a highly reliable indicator of a companys financial strength and its ability to meet its short-term obligations. Because catalogue can sometimes be difficult to liquidate, the quick-test ratio deducts inventory from current assets before they are compared with current liabilities-which is what distinguishes it from the current ratio.Potential creditors like to use the quick-test ratio because it reveals how a company would fare if it had to pay off its bills under the worst possible conditions. Indeed, the assumption behind the quick-test ratio is that creditors are howling at the door demanding immediate payment, and that an e nterprise has no time to sell off its inventory, or any of its stock. This ratio should have also negative relationship like the current ratio with stock market return. The quick-test is computed by subtracting inventories from current assets and dividing the difference by current liabilities (Current assets Inventory) / Current liabilities . 3 Operating Cash Flow Ratio Traditional working capital ratios indicate how much cash the company had available on a single date in the past. Cash flow ratio, on the other hand, tests how much cash was generated over a period of time and compare that to near-term obligations as published by John R. and Jeanne H. (1998). This ratio should strengthen the investors confidence toward the firm, therefore it should be positively related with stock market return. The numerator of the OCF ratio consists of net cash provided by operating activities.This is the net figure provided by the cash flow statement after taking into consideration adjustments fo r non-cash items and changes in working capital. The denominator is all current liabilities, taken from the balance sheet Cash flow from operations / Current liabilities (3) Leverage Ratios 3. 1 Debt-to-Equity Ratio How much money a company owes compared with how much money it has invested in it by principal owners and shareholders. The debt-to-equity ratio reveals the proportion of debt and equity a company using to finance its business. It also measures a companys borrowing capacity.The higher the ratio, the greater the proportion of debt but also the greater the risk. Mishkin (2001) describes the debt-to-equity ratio as a great financial test of long-term corporate health, because debt establishes a commitment to repay money throughout a period of time, even though there is no assurance that sufficient cash will be generated to meet that commitment. Creditors and lenders, understandably, rely heavily on the ratio to evaluate borrowers. As long as this ratio is considered to be lo w, investors confidence will be increased which negatively related with the stock performance.The debt-to-equity ratio is calculated by dividing debt by owners equity, where equity is, typically, the figure stated for the preceding schedule or fiscal year. Debt, however, can be defined either as long-term debt only, or as total liabilities, which includes both long- and short-term debt. The most common formula for the ratio is Long term liabilities / owners equity (4) Coverage Ratios 4. 1 Interest Coverage The amount of earnings available to make interest payments after all operating and non-operating income and expensesexcept interest and income taxeshave been accounted for.Interest coverage is regarded as a measure of a companys creditworthiness because it shows how much income there is to cover interest payments on outstanding debt. Banks and financial analysts also rely on this ratio as a rule of thumb to gauge the fundamental strength of a business as argued Eugene F. &038 Joe l H. (1998). Investors also rely on this ratio to examine the strength of a firms financial statement while this ratio should have a positive relationship with stock market return.Interest coverage is expressed as a ratio, and reflects a companys ability to pay the interest obligations on its debt. It compares the funds available to pay interestearnings before interest and taxes, or EBITwith the interest expense. The basic formula is EBIT / interest expense (5) Efficiency Ratios Ratios of turnover are constructed to measure how effectively the firms assets are being managed. 5. 1 Asset Turnover The amount of sales generated for every pounds worth of assets over a given period. Asset turnover measures how well a company is leveraging its assets to produce revenue.A well-managed manufacturer, for example, will make its plant and equipment work hard for the business by minimizing idle time for machines. The higher the number the better-within reason. As a rule of thumb, companies with low profit margins tend to have high asset turnover those with high profit margins have low asset turnover. This ratio can also show how capital intensive a business is. Some businesses-software developers, for example-can generate tremendous sales per dollar of assets because their assets are modest.At the other end of the scale, heavy industry manufacturers need a huge asset base to generate sales as refered by Eugene F. &038 Joel H. (1998). As long as the plant and equipment work hard and sales are increasing that would be an indication of a good sign. Consequently, this ratio should be a positively related with stock market return. Asset turnovers basic formula is simply sales divided by assets Sales revenue / Total assets 5. 2 Accounts Receivable Turnover This ratio explains the number of times in each accounting period, typically a year that a firm converts credit sales into cash.A high turnover figure is desirable, because it indicates that a company collects revenues effecti vely, and that its customers pay bills promptly. A high figure also suggests that a firms credit and collection policies are sound. In addition, the measurement is a reasonably good indicator of cash flow, and of overall operating efficiency as hence by Mishkin (2001). This ratio should have a positive relationship with stock return. The formula for accounts receivable turnover is straightforward. Simply divide the average amount of receivables into annual credit sales Sales / Account Receivables (B) Statistical Results