From Financial Management: Core Concepts (2015). Raymond Brooks. 3rd Edition. Research two companies' financial statements from one of the following industries: Airline Automotive Pharmaceutical Oil/gas
From Financial Management: Core Concepts (2015). Raymond Brooks. 3rd Edition.
Research two companies' financial statements from one of the following industries: Airline Automotive Pharmaceutical Oil/gas Retail Computer Hardware
Pharmaceutical Company Pfizer 2015 Financial Statement following link download: "Might need to copy and paste in browser"
http://www.pfizer.com/system/files/presentation/2015_Pfizer_Financial_Report.pdf
Airline Company Southwest 2015 Financial Statement following link download: "Might need to copy and paste in browser"
http://investors.southwest.com/~/media/Files/S/Southwest-IR/documents/company-reports-ar/ar-2015.pdf
Analyze table 14.8 in Financial Management: Core Concepts, Ch. 14: "Financial Ratios: Industry Averages." Shown Below
Table 14.8 Financial Ratios: Industry Averages
Ratio or Account | Airlines | Auto | Pharmaceuticals | Oil and Gas | Retail | Computer Hardware |
---|---|---|---|---|---|---|
P/E ratio | 22.44 | 7.38 | 87.80 | 5.39 | 34.29 | 20.97 |
Gross margin | 19.28% | 21.77% | 59.54% | 47.47% | 24.51% | 43.54% |
Profit margin | 0.75% | 3.79% | 14.85% | 12.14% | 2.94% | 17.08% |
Current ratio | 0.92 | 0.32 | 2.77 | 1.11 | 1.23 | 2.86 |
Debt-to-equity ratio | 1.69 | 0.34 | 0.11 | 0.19 | 0.81 | 0.19 |
Return on assets | 0.70% | 3.57% | 9.40% | 12.11% | 6.31% | 18.22% |
Return on equity | 0.77% | 10.17% | 14.71% | 20.10% | 16.82% | 26.24% |
Prepare the following ratios for the two sets of financial statements (from Pfizer and Southwest 2015 financial statements from following web links above) in Microsoft Excel:
Price to Earnings
Gross Margin
Profit Margin
Current Ratio
Debt to Equity
Return on Assets
Return on Equity
Compare your completed ratios to the industry average chart from table 14.8 Financial Management: Core Concepts, Ch. 14 Financial Ratios: Industry Averages".
Evaluate in 175 words which company, of the two (Pfizer and Southwest) you have researched, is doing better.
Format your assignment consistent with APA guidelines.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started