I picked Dell http://i.dell.com/sites/doccontent/corporate/secure/en/Documents/FY13_Form10K_Web.pdf
ANNUAL REPORT ANALYSIS Term Project AD 630- Fall, 2013 This is an assignment to allow you to pick any public company which piques your interest. The only requirement is that the company must have inventories and accounts receivable on its balance sheet. You may obtain annual reports from most companies on line. Most of the ratios can be obtained online as well, however if any of the ratios do not apply, write in N/A next to the items below. You may use this word doc to complete the requirements, or use your own word or excel documents. Note- Much of the information you need is available on the web site of the company you choose, therefore your analysis of the results is more important than the actual ratios or numbers you use. Attached are the financial statements and year-end summary from the 201_ Annual Report of _____________________ _________. Liquidity: 1. Calculate the company's working capital, current ratio, and acid-test ratio at [balance sheet dates]. 2. Based on the results of your analysis above, assess the company's overall liquidity position. Explain which ratios indicate particular strengths and/or weaknesses. Assume the following industry averages: Working capital = varies in proportion to firm size; Current ratio = 2.0; Acid-test ratio = 1.6. 3. Explain how working capital and the current ratio are related. Would you expect firms with large amounts of working capital to always have high current ratios? Profitability: 4. Calculate ROI, showing margin and turnover, for at least 3 years 5. Calculate ROE for as many of the past three years as you can. 6. Calculate the price/earnings ratio for as many of the past three years as you can. 7. Calculate the dividend payout and dividend yield ratios for as many of the past three years as you can. 8. Based on the results of your analysis above, assess the company's overall profitability. Explain which ratios indicate particular strengths and/or weaknesses within the company. Assume the following industry averages: ROI = 15%; Margin = 10%; Turnover = 1.5; ROE = 20%; Price/earnings = 14.0; Dividend payout = 40%; Dividend yield = 5%. 9. As an investor in this company's stock, would you be pleased with this year's dividend yield? How would your dividend yield "expectations" change, if at all, if the company's ROI was 5% higher? Explain. Page #1 ANNUAL REPORT ANALYSIS Term Project AD 630- Fall, 2013 Page #2 Financial Leverage: 10. Calculate the debt ratio (total liabilities to total liabilities and owners' equity), and the debt/equity ratio (total liabilities to total owners' equity) at______________________, 201_. 11. Based on the results of your analysis above, assess the company's overall leverage position. What would you estimate the industry averages to be for the debt ratio and debt/equity ratio? Explain. 12. Explain the relationship between ROI and ROE, and the concept of financial leverage. Would you expect the percentage difference between ROI and ROE to be high or low for a firm that has a high degree of financial leverage? Activity measures: 13. Calculate the accounts receivable turnover and the number of days' sales in accounts receivable (based on a 365-day year) for the year ended ______________________, 201_. 14. Based on your analysis above, do you believe that the company is doing an effective job at managing accounts receivable? What would you estimate the industry averages to be for accounts receivable turnover and the number of days' sales in accounts receivable? Explain. 15. Calculate the inventory turnover and the number of days' sales in inventory (based on a 365-day year) for the year ended _____________________, 201_. 16. Based on your analysis above, to what extent does the company need to be concerned about its inventory management policies? In assessing inventory management policies, would you be more interested in knowing current ratio or acid-test ratio information? Explain. Overall assessment: 17. Assume that you have $1,000 that you would like to invest in the common stock of a company. Evaluate the common stock of ____________________________ as a potential investment. From the data available on the attached financial statements, identify the five most important criteria that you would use to make your investment decision, and explain why each is important. Page # 3
