Explore BrainMass

Explore BrainMass

    Conduct Comparative Dupont Analysis Two Companies: Ford GM

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    Conduct a comparative DuPont analysis of two companies. Find one large corporation included in the S&P 500. Then, find one of its largest competitors. Go to the investor relations portion of each corporation's homepage and find their most recent annual report. Calculate a complete DuPont analysis calculating the ROE, ROA, the profit margin, total asset turnover and equity multiplier. Critique the differences between the two corporations in approximately 100 words.

    Part II
    Using the most recent income statements (annual) for the two corporations from Part I of the assignment, calculate a common size analysis using a spreadsheet. Discuss the differences in the two corporations in approximately 75 words. Your answer can be completed below your spreadsheet analysis.

    © BrainMass Inc. brainmass.com March 5, 2021, 12:41 am ad1c9bdddf

    Solution Preview

    I used Ford and GM. Ford?s 2012 annual report is not released yet so I used their 2011 annual report. GM's 2012 report was already posted so I used it.
    Part I
    Ford has outperformed GM in nearly all the measures. Their net income as a percent of sales is larger, meaning that they kept more of each dollar sold. Ford's asset turnover was lower than GM indicating that they generated fewer sales for the assets employed. Ford had ...

    Solution Summary

    Your tutorial is in excel, attached, and includes the balance sheet and income statement for Ford and GM (cut and pasted into Excel), the ratios computed with the numerator and denominator shown for easy comprehension.