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 16, 2018, 10:32 pm 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
Similar Posting

Dell v Apple: Financial Ratio Comparison

Need assistance with Q 9, 10, 11 and B.3.

Prepare an analysis of the two companies selected ( Apple & Dell). In your analysis evaluate their financial performance using trend and financial ratio analysis, and analyze their most recent statements of cash flows. You may include charts summarizing ratio and cash flow findings but need to analyze and evaluate that data in essay form.

a. Evaluate each firm's financial performance for the two most recent years available by (1) performing financial ratio analysis using the University of Phoenix Microsoft® Excel® Ratio Analysis Worksheet, (2) performing trend analysis on those financial ratios, and (3) comparing and contrasting the findings in essay form. Be sure to include a citation and reference the source of your financial information. A copy of the financial information can be attached, a URL provided, or re-created. Your analysis should include at least eight from the following list:
1) Current ratio
2) Quick ratio
3) Average collection period (days sales outstanding)
4) Inventory turnover ratio (if applicable)
5) Times interest earned
6) Debt-to-equity ratio
7) Net profit margin
8) Return on equity
9) Total asset turnover HELP THIS ONE
10) Return on assets HELP THIS ONE
11) Price-earnings ratio HELP THIS ONE
b. For both of these years and companies:
1) Identify the amount of cash generated or used from each of operating, investing, and financing activities,
2) Identify what business changes occurred altering the company's use of cash from one year to the next
3) Discuss whether or not the company is generating cash in a sustainable manner, HELP THIS ONE
4) Make recommendations as to how the company could better manage its cash flows in the future.

View Full Posting Details