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):
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)
3. Gross Margin = Gross profit/Sales
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
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
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.© BrainMass Inc. brainmass.com October 25, 2018, 12:18 am ad1c9bdddf
This solution shows step by step calculations for the financial ratios formatted in an attached Word document with discussion in 566 words.
Determination of change in Return on Equity (ROE)
. Quigley Inc. is considering two financial plans for the coming year. Management expects sales to be $301,770, operating costs to be $266,545, assets to be $200,000, and its tax rate to be 35%. Under Plan A it would use 25% debt and 75% common equity. The interest rate on the debt would be 8.8%, but the TIE ratio would have to be kept at 4.00 or more. Under Plan B the maximum debt that met the TIE constraint would be employed. Assuming that sales, operating costs, assets, the interest rate, and the tax rate would all remain constant, by how much would the ROE change in response to the change in the capital structure?
This was the only question in a long list of questions which I completely failed to comprehend on three levels: 1) I did not understand how you could arrive at just one answer when Quigley Company proposes two plans; 2) I was uncertain where the 25% debt financing and the 75% common equity belong in which profitability ratio, and 3)-I wasn't sure when to deduct for both the 35% tax rate and the 8.8% interest. If willing, I was hoping one of your fine OTA's could explain the ratio calculations used in solving this problem. ThanksView Full Posting Details