Share
Explore BrainMass

Rate of return on Equity (ROE)

To procure the basic financial documents for the company go to Intel's 2006 Financial Statements. Then, following the instructions laid out in this presentation on financial ratios and the examples given in this summary, perform a basic financial analysis of the company by calculating the following indicators (There are multiple years in the statements so make sure you use the 2006 figures in making your calculations):

1. Rate of return on Equity (ROE) = Net Income / Shareholders' Equity

This ratio can be re-written as a product of the three principal components:

ROE = (Net Income/Sales) x (Sales/Assets) x (Assets/Shareholders' Equity)

The three components are actually: profit margin, asset turnover, and financial leverage, respectively.

2. Return on Assets (ROA) = Profit margin x Asset turnover = Net income/Assets

3. Gross Margin = Gross profit/Sales

4. Inventory turnover = Cost of goods sold / Ending inventory

5. The Collection Period = Accounts receivable/Credit sales per day, where credit sales per day (or simply "sales per day" are computed by dividing total sales for the year by 365.

6. Fixed-asset turnover = Sales/Net property, plant and equipment

7. Financial leverage ratios:

Debt-to-assets ratio = Total liabilities/Total assets

Debt-to-equity ratio = Total liabilities/Shareholders' equity

8. Liquidity ratios:

Current ratio = Current assets/Current liabilities

Acid test = (Current assets - Inventory)/Current liabilities

Intel's financials use a few different labels than the equations above. Here are some hints:

Total sales is equal to Net Revenue in the Income Statement

Cost of goods sold is equal to Cost of sales in the Income Statement

Current liabilities and current assets are different from total liabilities and total assets. Make sure you add current liabilities and other long-term liabilities to come up with total liabilities.

When you have finished your calculations, summarize them in a brief (2-3 page) report, and describe any conclusions that you can draw about the company from examining these figures. Be sure to show your calculations. If there doesn't seem to be any discernible pattern of information that you can draw forth, say so, but at least tell us a little bit about what you tried to look for. On the basis of one module, you won't have the skill necessary to make a very sophisticated analysis, but at least you can get a sense of how analysts look at the numbers and make them into meaning.

Attachments

Solution Summary

This solution shows step by step calculations for the financial ratios formatted in an attached Word document with discussion in 566 words.

$2.19