Analysis of Financial Statements

Financial statements are analyzed by calculating certain key ratios and then comparing them with the ratios of other firms and by examining the trends in ratios over time. We can also combine ratios to make the analysis more revealing, one below are exceptionally useful for this type of analysis.

1. A company has current liabilities of $800 million, and its current ratio is 2.5. What is its level of current assets? If this firm's quick ratio is 2, how much inventory does it have?

2. A firm has $200 million annual sales, $180 million costs of goods sold, $40 million of inventory, and $60 million of accounts receivable. What is its inventory turnover ratio?

3. A company has EBITDA of $600 million, interest payments of $60 million, lease payments of $40 million, and required principal payments (due this year) of $30 million. What is its EBITDA coverage ratio?

4. A company has $200 billion of sales and $10 billion of net income. Its total assets are $100 billion, financed half by debt and half by common equity. What is its profit margin? What is its ROA? What is its ROE?

5. A company has $6 billion of net income, $2 billion of depreciation and amortization, $80 billion of common equity, and one billion shares of stock. If its stock price is $96 per share, what is its price/earnings ratio? Its price/cash flow ratio? Its market/book ratio?

6. A company has a profit margin of 6%, a total asset turnover ratio of 2, and an equity multiplier of 1.5. What is its ROE?

Attachment:- fin.xlsx