Question
Presented below are seven (7) companies that represent different industries, as well as seven (7) sets of ratios and other financial information (Excel file). See
Presented below are seven (7) companies that represent different industries, as well as seven (7) sets of ratios and other financial information (Excel file). See if you can match each set of financial information with the company that produced it.
The seven (7) companies that we are utilizing are as follows:
A. American Electric Power Company: A public utility holding company whose subsidiaries provide electric service to their retail customers.
B. Caesars Entertainment Corporation: A holding company that provides casino entertainment and hospitality services.
C. General Motors Company: A global company that designs, builds, and sells trucks, crossovers, cars and automobile parts.
D. Kellogg Company: A company that manufactures and markets ready-to-eat cereal and convenience foods.
E. Microsoft Corporation: A technology company that develops and supports software, services, devices and solutions.
F. Stifel Financial Corporation: A financial holding company whose principal subsidiary is a retail and institutional wealth management and investment banking firm.
G. Walmart Incorporated: A global company whose operations include retail, wholesale and ecommerce mass merchandising of consumer products.
Company 1 | Company 2 | Company 3 | Company 4 | Company 5 | Company 6 | Company 7 | |
Account: | |||||||
Cash and Equivalents | 8.4% | 46.7% | 4.0% | 7.4% | 5.2% | 0.6% | 2.3% |
Accounts Receivable | 3.0% | 10.3% | 2.7% | 1.7% | 8.0% | 2.2% | 9.0% |
Inventory | 4.6% | 0.7% | 18.8% | 0.1% | 0.0% | 1.5% | 7.0% |
Current Assets | 32.9% | 61.3% | 26.1% | 10.3% | 5.4% | 19.5% | |
Net Fixed Assets | 17.0% | 12.7% | 44.5% | 59.1% | 4.5% | 79.2% | 20.6% |
Other Assets and Goodwill | 34.8% | 26.0% | 29.4% | 30.6% | 8.4% | 15.5% | 57.6% |
Total Assets | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% |
Short-term Debt | 16.4% | 1.9% | 0.2% | 0.3% | 6.4% | 3.7% | 1.2% |
Accounts Payable | 9.2% | 3.3% | 19.9% | 1.8% | 4.7% | 2.7% | 13.6% |
Current Liabilities | 37.2% | 24.2% | 32.9% | 8.1% | 13.6% | 27.2% | |
Long-Term Debt | 42.6% | 23.3% | 18.5% | 33.5% | 4.1% | 33.1% | 41.0% |
Other Liabilities | 5.8% | 15.1% | 14.1% | 7.8% | 0.0% | 16.6% | 8.0% |
Stockholders' Equity | 20.2% | 35.7% | 34.5% | 8.7% | 14.9% | 26.2% | 18.9% |
Total Liabilities and Equity | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% |
Selected Ratjios: | |||||||
Current Ratio | 0.9 | 2.5 | 0.8 | 1.3 | 0.4 | 0.7 | |
Gross Profit % | 0.2 | 0.7 | 0.2 | 0.5 | 0.9 | 0.4 | 0.3 |
Days' Sales Outstanding | 18.1 | 85.6 | 4.4 | 18.2 | 205.6 | 40 | 42.4 |
Inventory Turnover | 12.2 | 18.2 | 8.9 | 108.2 | 8.7 | 7.2 | |
Debt/Equity | 2.5 | 0.7 | 0.7 | 8.7 | 0.3 | 1.5 | 2.9 |
Return on Equity | 16.7 | 42.4 | 20.2 | -44.4 | 13.2 | 9.9 | 36 |
Return on Assets | 3 | 14.4 | 6.5 | -4.7 | 1.8 | 2.7 | 5.5 |
Return on Sales | 0 | 0.3 | 0 | -0.1 | 0.1 | 0.1 | 0.1 |
Revenue/Assets | 0.6 | 0.4 | 2.2 | 0.3 | 0.1 | 0.2 | 0.8 |
Revenue/Employee | 836,811 | 873,910 | 238,165 | 136,594 | 423,489 | 893,922 | 439,203 |
Step by Step Solution
3.38 Rating (139 Votes )
There are 3 Steps involved in it
Step: 1
To match each set of financial information with the corresponding company we can analyze the provide...Get Instant Access to Expert-Tailored Solutions
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