Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Finance questions

Question

understand the limitations of classic models of job design.

Answered: 1 week ago