Explore BrainMass
Share

Explore BrainMass

    Dell and Apple - Using ratio analysis

    This content was COPIED 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 9, 2019, 10:33 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