Homework #5 Ratio Analysis Choose a public company for which financial data are available . Use the most recent period data available for the computations.

1. Collect data on the company's balance sheet and income statement for the latest year. Copy them on an Excel file. This is required . Attach relevant pages from the company book / website with your submission . (10 pts)

2. Using MS Excel, compute (not just report from a source) the following ratios using the balance sheet and income statement data you collected (14 points) 1. Quick ratio

2. Inventory turnover

3. Debt ratio

4. Net profit margin

5. Return on Investment (or assets) 6. Return on equity

7. P / E ratio