Purchase Solution

Conduct Comparative Dupont Analysis Two Companies: Ford GM

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

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.

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.
www.ford.com
www.gm.com
 
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 provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Motivation

This tests some key elements of major motivation theories.