Purchase Solution

Dell and Apple - Using ratio analysis

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution

Solution Summary

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

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. ...

Purchase this Solution


Free BrainMass Quizzes
Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.