Share
Explore BrainMass

Dell and Apple - Using ratio analysis

I am comparing Dell and Apple as the two major companies in the same industry. Format should be "exactly" as attached example.

These are the things I need

*Create a single Excel file with the same format attached. There are three separate financial statements to analyze:

a. the income statement,
b. the balance sheet, and
c. the cash flow statement.

* Sources to be pulled from MSN Finance or Yahoo Finance as well as SEC Form 10K link from those finance sites.

* Should calculate, and comment upon, all relevant financial ratios for the last 2 fiscal years, including market ratios (such as PE ratios and market to book value of equity) and a full DuPont analysis.

* All financial statements used should be shown. All calculations should be shown, and all answers should be thoroughly explained.

* Whenever you use balance sheet items to calculate ratios, for each year be sure to average the beginning-of-year and end-of-year amounts to get the average for that year.

* What can you tell from your analysis? What are the strengths and weaknesses of each company? Which is the stronger competitor and why?

Attachments

Solution Preview

Dell and Apple - Using ratio analysis, compare two major competitors in the same industry

I am comparing Dell and Apple as the two major companies in the same industry. Format should be "exactly" as attached example.

These are the things I need

*Create a single Excel file with the same format attached. ...

Solution Summary

Response provides the steps to analyze the Dell and Apple - Using ratio analysis

$2.19