Woolworths Limited and Wesfarmers Limited Financial Analysis - Assignment Example

Content Executive Summary 2 Introduction 3 Financial Analysis 3 Liquidity ratio 4 Capital Structure ratio 6 Profitability Ratios 8 Asset Efficiency Ratios 11 Market Performance Ratio 13 Findings 15 Conclusion 16 Recommendations 17 Limitations 18 References 19 Appendix 21 Executive Summary Woolworths Limited and Wesfarmers Limited have been performing on similar business model and have been successful as retail players. Their market has grown which is reflected by the growth in sales. There is even scope for the company to move further as this sector is showing improvement. The financial analysis also highlights some important fact related to liquidity and capital structure. The findings shows the positives and negatives of both based on financial analysis. The ratios like liquidity ensures to find liquidity and the capital financed by the company are demonstrated by capital structure ratios. The efficiency ratio indicates the area where Wesfarmers need to work to stay ahead of Woolworths Limited. The capital market ratio indicates the companies which are favoured by shareholders and also help to look into the future prospects of the company. The recommendations highlights areas where both the companies need to improve which will help them face competition and help in proper strategy execution. The analysis shows that Wesfarmers performance has improved drastically in 2009. It still needs to work on certain areas to stay ahead of Woolworths as the company has shown stability and Wesfarmers need to inculcate those so that it is able to withstand competition and capture a bigger market. Introduction Wesfarmers Limited is a retail giant. The company has a huge presence and deals in “home improvement, office supplies, insurance, food, liquor, coal and other products”. (Wesfarmers Website, 2010) The fact that the company deals in so many products and huge reach has given a wide market. The company has a presence in supermarkets, malls, departmental stores and provide the basic necessities for people thereby enabling them to grow. Woolworths Limited is also a retail giant. The company deals in “liquor, hotels, petrol, consumer electronic, everyday requirements and home improvements”. (Woolworths Website, 2010) The wide range of product and dispersion has made it a huge success. The company with their policy to satisfy customers has grown and is able to capture a good market. The financial statement of both the companies reveals so. Even the share prices shows improvement. With more consumers moving towards supermarkets gives an opportunity to expand in overseas. Financial Analysis Financial analysis is very important for all business. Analyzing the statement helps in “planning, budgeting, monitoring, forecasting and improving the financial performance by taking vital decision”. (Micro Strategy, 2010) Proper analysing helps a long way to “understand the financial health”. (Micro Strategy, 2010) It helps to identify trends and compare with competitors and industry to gain advantage. The following is the ratios for Woolworths Limited and Wesfarmers Limited. Liquidity Ratios This ratio plays an important part and helps “to identify the firms ability to meet its short term obligations and plays a huge role in the performance”. (Financial Modelling Guide, 2010) The ratios for Wesfarmers and Woolworths are Cash Flow Ratio: It is defined as “the ability of the firm to meet the current liabilities out of its operating activities”. (Financial Modelling Guide, 2010) It is calculated as “Net Cash from Operating Activities / Current Liabilities X 100”. The ratios for both the companies are as follows The ratio for Wesfarmers has improved in 2009. It shows that the ability of Wesfarmers to pay its current bills has improved. Woolworths on the other hand has shown consistency. It is placed better compared to Wesfarmers. Both the companies need to ensure that the operating activities contribute more as it suggests the line of business the company is in and the ability to meet its current obligations from those. Current Ratio: “It measures the ability to pay the short term liabilities out of short term assets”. (Financial Modelling Guide, 2010) This ratio helps creditors, suppliers and investor to identify the liquid position. It is calculated as “Current Assets / Current Liabilities”. The current ratios for both the companies are as (appendix) The ratio shows that Wesfarmers has a better liquidity position as compared to Woolworths. Woolworths need to improve the ratio as it is a concern as the short term obligations are higher. This might make investors and suppliers stay away. Wesfarmers on the other hand is in a better position but still needs to take it slightly up. When we consider the two companies together it shows that Wesfarmers has better policies and strategies as compared to Woolworths. The positive for Wesfarmers is that they have improved it drastically. They need to work more and ensure that it reaches around 2. Woolworths on the other hand needs immediate strategy as it is showing the business in not liquid and facing obstacle. This might make investors stay away. Quick Ratio: It is also known as acid test ratio. “It measures the ability of the firm to meet its short term obligation when inventories are removed as inventories take some time to be converted into cash”. (Financial Modelling Guide, 2010) It is calculated as “(Current Assets – Inventories) / Current Liabilities”. The ratios for both the companies are as The ratio also indicates that Wesfarmers is better positioned as compared to Woolworths. The ratio indicates the inefficiency of the company to meet its immediate debt. Woolworths need to improve this as it is a concern and presenting a bleak picture. Even, Wesfarmers need to concentrate on it and improve it. The ratio when compared to current ratio also indicates huge inventories. Since, both the companies deal in products where the inventory has to be high so having a low ratio is predictable. Still, both the companies especially Woolworths need to improve it so that it presents a better picture. Capital Structure Ratio This ratio is of prime importance and provides relevant information about the company. “It identifies how much of the firm’s assets are financed through debt and includes long term debt”. (Transtutor, 2010) The ratios which help to determine it are as Debt to Equity Ratio: “It determines the proportion of long term debt in relation to the shareholders fund and long term debt”. (Transtutor, 2010) This ratio helps to identify the financial soundness. It is calculated as “Long Term Debts / Equity X 100”. The ratios for both the companies are as The ratio indicates soundness on the part of both the companies. It shows that the company has a scope for more investment through debts. This is a good sign and shows the company has a space for future projects. Wesfarmers has reduced its debt a lot by paying off is a worry and needs to raise it so that it can save on taxes. Wesfarmers need to ensure that it keeps with the industry standard. As both the companies work in a type of market where to grow large debt is needed so the ratio seems to be sound. Debt Coverage Ratio: It is defined as “the ability to pay the monthly debt on the loan taken on the mortgage of property”. (Financial Modelling Guide, 2010) It is widely used by banks. It is calculated as “Non Current Liabilities / Net Cash Flow from Operating Activities”. The ratio for Wesfarmers shows better performance in 2009. It indicates that the company is lowly moving towards its competitor i.e. Woolworths. Woolworths on the other hand has shown consistency though there is a slight change in this ratio. Wesfarmers need to continuously work and ensure that the debt coverage ratio improves further so that growth is better. Interest Coverage ratio: “It measures how well a companies is able to meet its interest cost from in comparison to the finance expenses”. (Transtutor, 2010) It is calculated as “EBIT / Net Finance Expenses”. The ratios for both the companies are as follows The ratio shows that Wesfarmers Limited performance has improved in 2009 as in 2008. The company has improved its interest paying ability showing improvement in performance. The performance on Woolworths Limited on the other hand is steady as shows the ability to meet the interest expenses from financing activities. Wesfarmers need to continue to perform and look forward to improve it against their competitor i.e. Woolworths Limited. Profitability Ratios Profitability ratios form a very vital part of financial analysis. This ratios help to understand the profit which can be attributed to the different factors which work in tandem to achieve the desired results. Comparing it with the previous years and the competitors’ helps to evaluate the shortcomings, and shows area which needs to be improved. The profitability ratios are as follows Gross Profit Margin: “It is defined as the profit generated after deducting cost of goods sold and before the indirect expenses are accounted for and considers only the direct expenses”. (Kennon, 2010) Gross profit helps to find out the actual profit that is attributed directly to the product. It is calculated as– “Gross Profit / Sales X 100”. The ratio for both the companies are The ratio indicates consistency for Wesfarmers and Woolworths. Wesfarmers has a higher gross profit indicating soundness in manufacturing process. It also shows that the strategies are well managed. Woolworths on the other hand has shown improvement but still needs to improve to match its competitor. Net Profit Margin: “It is defined as the profit generated per dollar of sales and is calculated after all the direct and indirect expense has been considered”. (Kennon, 2010) Organisations prefer this to be high. It is calculated as “Earning before Interest and taxes (EBIT) / Sales X 100”. The ratios for both the companies are as The ratio indicates similarity between Woolworths and Wesfarmers Limited. It is seen that the net profit has decreased for Wesfarmers. This is a worrying factor and reflects inefficiency to maintain the indirect expense. When we compare it to the gross profit margin it shows a huge dip signifying the amount of indirect expenses like marketing, distribution and other expenses the company incurs. The ratio for Woolworths has improved signifying better management and control of cost. When we look at the broader picture it shows that Wesfarmers despite having a higher gross profit has a lower net profit showing the amount of indirect cost incurred. It signifies improper management and strategies t cut cost is required. Return on Assets: “It is defined as the amount of profit generated for per dollar of asset”. (Joseph, 2010) It helps to identify whether the assets are utilized properly or underutilized. It is calculated as “Earning before Interest and Taxes (EBIT) / Average assets X 100). The ratios for both the companies are as Here we see that the return on assets for both Wesfarmers and Woolworths have improved in 2009 as compared to 2008. The worrying factor for Wesfarmers is that their assets are underutilized. This has resulted in having more assets that warranted. Woolworths on the other hand has a better return showing proper utilization of assets. The other important part to note is that retail players have huge assets which results in the ratio being lower. Still, on an overall basis we see that Wesfarmers need to improve their return as it is have very heavy assets and needs to improve it as compared to the competitors. Return on Equity: “It is defined as the profit earned as compared to the equity shareholders i.e. earning per dollar of equity”. (Joseph, 2010) It is calculated as “Net Profit available to ordinary shareholders / Average Equity (excluding minority interest and preference capital) X 100”. The ratios for both the companies are as follows We see that Woolworths has a very high return on equity as compared to Wesfarmers. The return for Wesfarmers has improved but is far beyond Woolworths. This is a worrying factor and shows the strategies and policies implemented hasn’t been successful. The return for Wesfarmers is very low which might lead to shareholders moving out to other companies or investing in risk free securities. Wesfarmers need to take urgent steps to improve it. Asset Efficiency Ratios Operating ratios forms a very important part as it helps to “show the efficiency of the management and also indicates the company’s efficiency to manage its capital”. (Joseph, 2010) this ratios help to find the efficiency when it comes to turnover. The following ratio helps to calculate the operating efficiency. They are as Asset Turnover Ratio: It is defined as “the total sales generated per revenue of assets”. (Joseph, 2010) It is calculated as “Sales Revenue / Average Total Assets”. The ratios for both the companies are as follows The ratio indicates improvement for Wesfarmers in 2009. Wesfarmers has been able to use its assets better in 2009. This has made the ratio to improve. Woolworths on the other hand shows soundness in the use of assets. It needs to continue similarly. Wesfarmers on the other hand needs to improve this ratio and look towards matching Woolworths. Receivable Turnover Ratio: “It is defined as the number of times the company is able to recover the dues from the customer”. (Kennon, 2010) The higher it is the better it is. It is calculated as “Credit Sales / Average Receivable”. The ratio for both the companies are Here we see that Woolworths has a very good rate and it recovers its chances of bad debts to be less. Woolworths has also shows consistency and is a good sign. Wesfarmers on the other hand has a poor receivable rate compared to Woolworths. The good sign for Wesfarmers is that it has improved drastically in 2009 as compared to 2008. If the company can continually improve it then it would be a good sign and reduce the chances of debts. Payable Turnover Ratio: “It is defined as the number of times the creditor is paid in the year and companies generally prefer to maintain it good so that reputation is good”. (Kennon, 2010) It is calculated as “Cost of good sold / Average payable”. The ratios for both the companies are as follows It is seen that Wesfarmers has improved its turnover ratio drastically. This is a good sign and shows that the reputation has improved with the suppliers and also ensures steady supplies. Woolworths has a good ratio and is consistent signifying soundness in policy. Both the companies are ensuring that the ratio is good and reckons a good future. Inventory Turnover Ratio: “It is defined as the number of times inventory is rolled over during a year”. (Joseph, 2010) Companies prefer it to be high. It is calculated as “Cost of Goods Sold / Average Inventory”. The ratios for both the companies are as The above ratio indicates that Woolworths has revolved its inventory more compared to Wesfarmers. Woolworths has also been consistent and shows proper management. Wesfarmers on the other hand has improved their turnover ratio in 2009 as compared to 2008. This is a sign of a good company but it needs to be replicated so that the inventory levels come down. This will ensure less money in inventory and help to ensure that the funds are not blocked. Wesfarmers need to improve it and match Woolworths. Days Inventory: It is defined as “how many days a company takes to revolve its inventory”. (Joseph, 2010) It is calculated as “Average Inventory / Cost of Sales X 100”. The ratios for both the companies are as follows It is seen that Wesfarmers performance has improved in 2009. Wesfarmers is able to revolve the inventory quicker in 2009. Woolworths on the other hand shows efficiency. They are able to revolve the inventory very fast. Wesfarmers need to look to reduce it so that less fund are parked there and can be used for other purpose and will help to bring down the level of risk of falling prices of inventory. Market Performance Ratio This ratios help to find the shareholders confidence in the company. This ratio helps to find the prediction the shareholders have and company’s performance is also reflected here. A company having sound capital market ratios ensures that people prefer this companies and this is seen by the growth in share prices. The ratios which will help to find the capital market are as follows P/E Ratio: “It is defined as the earning the shareholders get for every dollar of earning”. (Kennon, 2010) Companies look it as an important measure to now the growth. It is calculated as “Market Price of Ordinary share / Earning per Share”. The ratio for both the companies are as follows The above ratio for 2009 shows, that Woolworths has a good P/E ratio compared to Wesfarmers Limited. It can be due to the fact Wesfarmers is growing so it has not declared dividend which has affected it. Overall the performance of both the companies is good but Wesfarmers need to improve it so that the companies are more preferred by shareholders. Earnings per Share: “It is defined as the profit attributed to the equity shareholders”. (Joseph, 2010) It is calculated as “Net profit available to ordinary shareholders / weighted number of ordinary shares on issue”. The ratios for both the companies are as follows The above ratio indicates soundness on the part of both the companies. Wesfarmers has a higher earning per share indicating that the shareholders are getting a good return. The return for Wesfarmers has decreased in 2009 as compared to 2008 which shows that the profit has dipped. Woolworths on the other hand has improved their earnings and it reflected on the well being of the shareholders. The overall result for both the giants seems sound and is a good prospect to invest. Dividend per Share: “It is defined as the dividend paid per outstanding equity share”. (Joseph, 2010) It helps to find the dividend equity shareholders receive. It is calculated as “Dividend Paid to ordinary shareholders / Weighted Number of Ordinary shares on issue”. The ratios for both the companies are as follows It is seen that both the companies have given dividend for both the years. This is a good sign and shows good prospects. It is seen that Wesfarmers has reduced the dividend paid per share which reflects that Wesfarmers has some future projects so the company instead of paying handsomely to the shareholders it is looking to reinvest it. Woolworths on the other hand has given a higher dividend per share showing that the company is already on a growth pace and has abundant funds. When we compare the two it is seen that Woolworths has a lower dividend per share and Wesfarmers has also reduced it and with projects it should be furthered reduced. Findings The liquidity position especially the current ratio is sound for Wesfarmers and Woolworths needs to improve it. Both the companies due to the nature of business have a huge inventory which are affecting the quick ratio but is according to industry standards. The long term debt ratios is sound for both the companies and have the scope to take loan for further development. The companies have used their short term debt to finance long term assets is a worrying factor and steps needs to be taken. Wesfarmers profit has improved in 2009 as compared to 2008 but it needs to reduce its indirect expenses so that it stays ahead of Woolworths The operating ratio especially the receivable and payable turnover ratio for Wesfarmers has shown tremendous improvement but it needs to still work on it so that it is able to perform at par with Woolworths The capital market analysis ratio shows wide improvement for Wesfarmers in 2009 and when we compare it to Woolworths it shows better performance highlighting that Wesfarmers have better projects and this can help them The financial analysis shows that Wesfarmers performance has improved in 2009 as compared to 2008. Wesfarmers need to improve its strategies and management so that it can stand better that Woolworths who have been performing on a consistent basis. Conclusion Wesfarmers Limited and Woolworths Limited both have been performing on similar lines and have been successful. The financial statement even highlights similar facts. Both the companies can improve with better strategy. The financial ratios of both the companies show some demarcating things and also highlight the different strategies taken by each. This even highlights that companies similar in nature use different strategies and improve their performance. Both this companies have room for improvement and with the growth this sector is showing it gives them opportunity to capture a good market and grow. Recommendations Woolworths needs to improve its current ratio so that it reflects soundness in its policies and strategies Both the companies need to reduce the amount held in inventories as it is high leading to a lot of money being invested Both the companies need to take more debt especially long term so that they are able to save on the taxes Wesfarmers needs to improve its operating ratios so that it can match its competitor Wesfarmers needs to reduce its indirect cost, improve efficiency, bring down assets and improve their management Wesfarmers need to improve the inventory turnover ratio Wesfarmers need to ensure that to stay ahead of competition it comes with new projects which helps them to utilize their assets properly and ensure better efficiency Limitations Inflation and changes in price has not been accounted for which might be misleading Historical cost has been considered which might not be true in the present scenario as value changes with time Changes in technology for production, distribution, marketing has not been accounted for which might give different result References Financial Modelling Guide, 2010, “Liquidity ratios”, retrieved on March 29, 2010 from http://www.financialmodelingguide.com/financial-ratios/liquidity-ratios/ Invest smart, 2010, “Wesfarmers Limited (WES)”, Australian Finance Services, retrieved on April 1, 2010 from http://www.investsmart.com.au/shares/asx/Wesfarmers-WES.asp Invest Smart, 2010, “Woolworths Limited (WOW)”, Australian Finance Services, retrieved on April 1, 2010, from http://www.investsmart.com.au/shares/asx/Woolworths-WOW.asp Joseph K, 2010, “Analyzing an income statement: Return on Assets”, about.com guide, The New York Times Company Joseph K, 2010, “Analyzing an income statement: Return on Equity”, about.com guide, The New York Times Company Joseph K, 2010, “Analyzing an income statement: Inventory Turnover”, about.com guide, The New York Times Company Kennon J, 2010, “Analyzing an income statement: Gross Profit”, about.com guide, The New York Times Company Kennon J, 2010, “Analyzing an income statement: Net Profit Margin”, about.com guide, The New York Times Company Kennon J, 2010, “Analyzing an income statement: Receivable Turnover”, about.com guide, The New York Times Company Micro Strategy, 2010, “Financial Analysis”, retrieved on March 29, 2010 from http://www.microstrategy.com/financial-analysis/ Transtutor, 2010, “Capital Structure Ratios”, retrieved on March 29, 2010 from http://www.transtutors.com/finance-homework-help/dividend-decisions-and-tools-of-financial-planning/Capital-Structure-Ratios.aspx Wesfarmers Website, 2010, retrieved on March 29, 2010 from http://www.wesfarmers.com.au/ Woolworths Website, 2010, retrieved on March 29, 2010 from http://www.woolworths.com.au Wesfarmers Stock Price, 2010, Yahoo Finance, retrieved on April 1, 2010 from http://au.finance.yahoo.com/q?s=WES.AX Woolworths Stock Price, 2010, Yahoo Finance, retrieved on April 1, 2010, from http://au.finance.yahoo.com/q?s=wow.ax Appendix 1. Calculation of Current Ratio for Wesfarmers Limited Current Ratio for 2008 = Current Assets / Current Liabilities = 8676 / 7940 = 1.09 Current Ratio for 2009 = Current Assets / Current Liabilities = 9964 / 7711 = 1.29 2. Calculation of Current Ratio for Woolworths Limited Current Ratio for 2008 = Current Assets / Current Liabilities = 4502.2 / 6424.4 = 0.7 Current Ratio for 2009 = Current Assets / Current Liabilities = 4859.2 / 6414.6 = 0.76 3. Calculation of Quick Ratio for Wesfarmers Limited Quick ratio for 2008 = (Current Assets – Inventories) / Current Liabilities = (8676 – 4638) / 7940 = 0.51 Quick ratio for 2009 = (Current Assets – Inventories) / Current Liabilities = (9964 – 4685) / 7711 = 0.68 4. Calculation of Quick Ratio for Woolworths Limited Quick ratio for 2008 = (Current Assets – Inventories) / Current Liabilities = (4502.2 – 3010) / 6424.2 = 0.23 Quick ratio for 2009 = (Current Assets – Inventories) / Current Liabilities = (4859.2 – 3292.6) / 6414.6 = 0.24 5. Calculation of Debt to Equity for Wesfarmers Limited Debt to Equity Ratio for 2008 = Long Term Debts / Equity = 8256 / 19590 = 0.42 Debt to Equity Ratio for 2009 = Long Term Debts / Equity = 5535 / 24252 = 0.23 6. Calculation of Debt to Equity for Woolworths Limited Debt to Equity Ratio for 2008 = Long Term Debts / Equity = 2224 / 6235.3 = 0.36 Debt to Equity Ratio for 2009 = Long Term Debts / Equity = 2986.3 / 7057.3 = 0.42 7. Calculation of Gross Profit Margin for Wesfarmers Limited Gross Profit Margin for 2008 = Gross Profit / Sales * 100 = 9862 / 31650 *100 = 31.15% Gross Profit Margin for 2009 = Gross Profit / Sales * 100 = 15304 / 49023 * 100 = 31.21% 8. Calculation of Gross Profit Margin for Woolworths Limited Gross Profit Margin for 2008 = Gross Profit / Sales * 100 = 11900.3 / 47034.8 *100 = 25.30% Gross Profit Margin for 2009 = Gross Profit / Sales * 100 = 12723.4 / 49594.8 * 100 = 25.66% 9. Calculation of Net Profit Margin for Wesfarmers Limited Net Profit Margin for 2008 = Net Profit / Sales * 100 = 1050 / 31650 *100 = 3.31% Net Profit Margin for 2009 = Net Profit / Sales * 100 = 1535 / 49023 * 100 = 3.13% 10. Calculation of Net Profit Margin for Woolworths Limited Net Profit Margin for 2008 = Net Profit / Sales * 100 = 1651.5 / 47034.8 *100 = 3.51% Net Profit Margin for 2009 = Net Profit / Sales * 100 = 1860 / 49594.8 * 100 = 3.75% 11. Calculation of Return on Assets for Wesfarmers Limited Return on Assets for 2008 = Net Income / Total Assets * 100 = 1050 / 37306 * 100 = 2.81% Return on Assets for 2009 = Net Income / Total Assets * 100 = 1535 / 39295 * 100 = 3.90% 12. Calculation of Return on Assets for Woolworths Limited Return on Assets for 2008 = Net Income / Total Assets * 100 = 1651.5 / 15672.5 * 100 = 10.53% Return on Assets for 2009 = Net Income / Total Assets * 100 = 1860 / 17084.9 * 100 = 10.88% 13. Calculation of Return on Equity for Wesfarmers Limited Return on Equity for 2008 = Net Income / Equity * 100 = 1050 / 19590 * 100 = 5.35% Return on Equity for 2009 = Net Income / Equity * 100 = 1535 / 24252 * 100 = 6.32% 14. Calculation of Return on Equity for Woolworths Limited Return on Equity for 2008 = Net Income / Equity * 100 = 1651.5 / 6235.3 * 100 = 26.49% Return on Equity for 2009 = Net Income / Equity * 100 = 1860 / 7057.3 * 100 = 26.35% 15. Calculation of Receivable Turnover Ratio for Wesfarmers Limited Receivable Turnover Ratio for 2008 = Sales / Average Receivable = 31650 / 2093 = 15.12 Receivable Turnover Ratio for 2009 = Sales / Average Receivable = 49023 / 1893 = 25.9 16. Calculation of Receivable Turnover Ratio for Woolworths Limited Receivable Turnover Ratio for 2008 = Sales / Average Receivable = 47034.8 / 637.8 = 73.74 Receivable Turnover Ratio for 2009 = Sales / Average Receivable = 49594.8 / 664.2 = 74.69 17. Calculation of Payable Turnover Ratio for Wesfarmers Limited Payable Turnover Ratio for 2008 = Cost of Goods Sold / Average Payable = 21788 / 3966 = 5.49 Payable Turnover Ratio for 2009 = Cost of Goods Sold / Average Payable = 33719 / 4037 = 8.35 18. Calculation of Payable Turnover Ratio for Woolworths Limited Payable Turnover Ratio for 2008 = Cost of Goods Sold / Average Payable = 35257.8 / 4804.9 = 7.33 Payable Turnover Ratio for 2009 = Cost of Goods Sold / Average Payable = 36974.4 / 5110 = 7.24 19. Calculation of Inventory Turnover Ratio for Wesfarmers Limited Inventory Turnover Ratio for 2008 = Cost of Goods Sold / Average Inventory = 21788 / 4638 = 4.7 Inventory Turnover Ratio for 2009 = Cost of Goods Sold / Average Inventory = 33719 / 4685 = 7.2 20. Calculation of Inventory Turnover Ratio for Woolworths Limited Inventory Turnover Ratio for 2008 = Cost of Goods Sold / Average Inventory = 35257.8 / 3010 = 11.71 Inventory Turnover Ratio for 2009 = Cost of Goods Sold / Average Inventory = 36974.4 / 3292.6 = 11.23 21. Calculation of Earning Per Share for Wesfarmers Limited Earning per Share for 2008 = Net Income / Outstanding shares = 180.6 (given in financial statement) Earning per Share for 2009 = Net Income / Outstanding shares = 160 (given in financial statement) 22. Calculation of Earning Per Share for Woolworths Limited Earning per Share for 2008 = Net Income / Outstanding shares = 134.89 (given in financial statement) Earning per Share for 2009 = Net Income / Outstanding shares = 150.71 (given in financial statement) 23. Calculation of Dividend per Share for Wesfarmers Limited Dividend per Share for 2008 = 2 (given) Dividend per Share for 2009 = 1.1(given) 24. Calculation of Dividend per Share for Woolworths Limited Dividend per Share for 2008 = 0.48 (given) Dividend per Share for 2009 = 0.56 (given) 25. Calculation of P/E Ratio for Wesfarmers Limited P/E ratio for 2009 = Market Price of Common Share / Earning per Share = 31.65 (April 1) / 1.1 = 28.77 26. Calculation of P/E Ratio for Woolworths Limited P/E ratio for 2009 = Market Price of Common Share / Earning per Share = 28.2 (April1) / 0.56 = 50.35 27. Calculation of Cash Flow Ratio for Wesfarmers Limited Cash Flow Ratio for 2008 = Net Cash from Operating Activities / Current Liabilities X 100 = 1451 / 7940 * 100 = 18.27% Cash Flow Ratio for 2009 = Net Cash from Operating Activities / Current Liabilities X 100 = 3044 / 7711 * 100 = 39.48% 28. Calculation of Cash Flow Ratio foe Woolworths Limited Cash Flow Ratio for 2008 = Net Cash from Operating Activities / Current Liabilities X 100 = 2654 / 6424.4 * 100 = 41.31% Cash Flow Ratio for 2009 = Net Cash from Operating Activities / Current Liabilities X 100 = 2604.2 / 6414.6 * 100 = 40.6% 29. Calculation of Debt Coverage ratio for Wesfarmers Limited Debt Coverage Ratio for 2008 = Non Current Liabilities / Net Cash Flow from Operating Activities = 9776 / 1451 = 6.74 Debt Coverage Ratio for 2009 = Non Current Liabilities / Net Cash Flow from Operating Activities = 7332 / 3044 = 2.41 30. Calculation of Debt Coverage ratio for Woolworths Limited Debt Coverage Ratio for 2008 = Non Current Liabilities / Net Cash Flow from Operating Activities = 3012.8 / 2654 = 1.14 Debt Coverage Ratio for 2009 = Non Current Liabilities / Net Cash Flow from Operating Activities = 3613 / 2604.2 = 1.39 31. Calculation of Asset Turnover Ratio for Wesfarmers Limited Asset Turnover Ratio for 2008 = Sales Revenue / Average Total Assets = 31650 / 37306 = 0.85 Asset Turnover Ratio for 2009 = Sales Revenue / Average Total Assets = 49023 / 39295 = 1.25 32. Calculation of Asset Turnover Ratio for Woolworths Limited Asset Turnover Ratio for 2008 = Sales Revenue / Average Total Assets = 47034.8 / 15672.5 = 3 Asset Turnover Ratio for 2009 = Sales Revenue / Average Total Assets = 49594.8 / 17084.9 = 2.9 33. Calculation of Days Inventory for Wesfarmers Limited Days Inventory for 2008 = Average Inventory / Cost of Sales X 365 = 4638 / 21788 * 365 = 77.7 days Days Inventory for 2009 = Average Inventory / Cost of Sales X 365 = 4685 / 33719 * 365 = 50.71 days 34. Calculation of Days Inventory for Woolworths Limited Days Inventory for 2008 = Average Inventory / Cost of Sales X 365 = 3010 / 35257.8 * 365 = 31.16 days Days Inventory for 2009 = Average Inventory / Cost of Sales X 365 = 3292.6 / 36974.4 * 365 = 32.5 days 35. Calculation of Interest Coverage Ratio for Wesfarmers Limited Interest Coverage Ratio for 2008 = EBIT / Net Finance Expenses = 2093 / 800 = 2.62 times Interest Coverage Ratio for 2009 = EBIT / Net Finance Expenses = 2858 / 963 = 2.97 times 36. Calculation of Interest Coverage Ratio for Woolworths Limited Interest Coverage Ratio for 2008 = EBIT / Net Finance Expenses = 3012.8 / 191.3 = 13.22 times Interest Coverage Ratio for 2009 = EBIT / Net Finance Expenses = 2815.5 / 189.2 = 14.88 times Read More