Explore BrainMass
Share

Dell and Apple - Using ratio analysis

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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?

© BrainMass Inc. brainmass.com October 25, 2018, 12:20 am ad1c9bdddf
https://brainmass.com/economics/electrical-utilities/dell-and-apple-using-ratio-analysis-224243

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
See Also This Related BrainMass Solution

Calculating P/E ratios and Profit Margin for Dell and Apple. Which is stronger?

Please see file attached.

Using the financial information of http://www.sec.gov/edgar.shtml as of December 31 of each year, calculate the P/E ratios each year for the last four quarters for Dell and Apple. Which company has made the strongest recovery in terms of profit margin and which has had the strongest growth in P/E ratio. Discuss why these results might be very different with reference to corporate finance policy.

Grading Criteria Maximum Points
Correctly located the Q1 and Q2 2004 10-Qs for each company. 15
Correctly located the corresponding stock price. 15
Correctly calculated a P/E ratio for Dell as of July 30 and April 30 versus the ratio for Apple as of June 27 and March 27. 25
Noted items in the company's reports that can be directly linked to higher valuations. 25
Total: 80

View Full Posting Details