Assignment: GENERAL MOTORS and The AUTO INDUSTRY
Intro- Desiree
1-6 Desiree
7-8 Ken
9-10 Melissa
11-12 Ross
13 Melissa
14 Ross
Conclusion - Desiree
Researching Industry Financial Statistics
Instructions: Purpose of Assignment
The purpose of this assignment is to allow the students an opportunity to complete their financial evaluation of a company using the financial research database Plunkett Research Online. Plunkett Research Online provides in-depth analysis of a company's financials, comparisons to industry averages, a list of top executives, how the company compares to other competitors in terms of revenue, number of employees, market capitalization and other key financial metrics. Assignment Steps Resources: Plunket Research Online located in the Electronic Reserve Readings; Microsoft® Excel. Access the Plunkett Research database in the University Library by following these steps:
A. Click on the University Library link.
B. Click "Company Directories and Financials" under Library Resources.
C. Click "Plunkett Research Online" tinder Company Directory and Financials.
D. Review the following "HOW TO USE" videos:
• Plunkett Research Online Overview How to Export Company and Exec. Lists
• How to Build-a-Report
• How to Use Industry Analytics
• How to Research an Industry
• How to Use Company Profiles
E. Click "Research A Company."
F Select a company (i.e. Walmart) and input into the Search Box.
G. Scroll through the search results to choose the correct company.
H. The company profile (in blue).
Review the Company Profile and answer the following questions in Microsoft® Word:
1. What is the Ticker Symbol for the company you have selected?
2. When was the company established?
3. How many employees does it have?
4. What is the NAICS Code?
5. Who is the CEO?
6. Where does the company rank in terms of Total Revenue when compared to its competitors?
7. Where does the company rank in terms of Net Income when compared to its competitors?
8. Where does the company rank in terms of Return on Assets when compared to its competitors?
9. What is the Revenue in 2014 and 2015?
10. What was the Gross Margin in 2014 and 2015?
11. What was the Earnings per Share in 2014 and 2015?
12. Save the Company Profile as a PDF document.
13. Compare the 2015 Company Financials to the Industry Averages and export the results into a Microsoft Excel document.
14. Add a new column in your Microsoft Excel document titled "Change" and calculate the difference between the company's 2015 financial results and the industry averages.
Explain in 1,050 words how the company you selected compares to the industry averages in terms of financial profitability, liquidity and solvency, and why the difference is important.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.