Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

The data file presents balance-sheet percentages and selected ratios for one company chosen from each of the 5 industries listed below. Study this information and

The data file presents balance-sheet percentages and selected ratios for one company chosen from each of the 5 industries listed below. Study this information and match each set of numbers with the correct industry.

  • Automobile manufacturer (General Motors)
  • Department store chain (Macy's)
  • Drug store chain (Walgreen)
  • Regional airline (Southwest Air)
  • Supermarket chain (Safeway)

image text in transcribed

Balance Sheet (in percentage of assets) 1 12.7% 2 5.4% 25.8 Company 3 3.3% 5.2 55.3 4 16.5% 0.5% 6.2 2.5 30.2 11.0 19.3 Cash and securities Receivables Inventories Other current assets Plant, property, and equipment (net) Total assets 0.6 1.0 79.4 100.0% 7.3 50.4 100.0% 1.8 34.3 100.0% 1.1 60.6 100.0% 25.9 2.9 40.4 100.0% 4.9% 1.9% 10.3% 0.9% 17.1 9.6 9.6 1.0% 2.0 7.0 36.1 19.4 15.8 19.8 Notes payable Accounts payable Other current liabilities Long-term debt and leases Preferred stock Owner's equity Total liabilities and equity 8.2 16.2 40.7 13.3 29.0 0.0 0.0 0.0 0.0 21.5 0.3 43.9 100.0% 49.6 44.8 23.2 53.9 100.0% 100.0% 100.0% 100.0% Selected Ratios D E F J K 2.07 1.45 1.77 1.50 0.77 1.65 0.93 2.00 1.13 0.28 LIFO LIFO LIFO LIFO 6.20 16.80 5 3 5.60 28 1.46 5.1% 3.41 8.3% 2.4% Current ratio Acid test Inventory method Inventory turnover (as reported) AR collection period (days) Net sales/Total assets Net profit/Total assets (return on assets) Net profit/Net sales (net profit margin) Net profit/Net worth (return on equity) Dividends/Net income (payout ratio) Total assets/Net worth Notes payable and long-term debt/Total assets Long-term debt/Net worth Market price/Book value Dividends/Market price Price/Earnings ratio Beta AvCost 125.00 28 0.79 1.8% 2.3% 3.4% 23.6% 185.5% 37.1% 67.0% 0.85 0.9% 6.50 68 161. 0% 1.8% 1.1% 7.9% 55.0% 430.3% 16.6% 3.5% 11.5% 50.0% 225.7% 3.50 9.3% 2.7% 20.8% 26.9% 223.3% 29.9% 64.8% 2.62 2.1% 12.7 26.3% 32.1% 201.6% 15.2% 26.8% 2.87 1.9% 17.3 1.2 48.4% 0.63 50.9% 175.0% 0.67 6.1% 25.5 1.2 7.9% 6.3 1.0 9.0 0.9 0.9 Balance Sheet (in percentage of assets) 1 12.7% 2 5.4% 25.8 Company 3 3.3% 5.2 55.3 4 16.5% 0.5% 6.2 2.5 30.2 11.0 19.3 Cash and securities Receivables Inventories Other current assets Plant, property, and equipment (net) Total assets 0.6 1.0 79.4 100.0% 7.3 50.4 100.0% 1.8 34.3 100.0% 1.1 60.6 100.0% 25.9 2.9 40.4 100.0% 4.9% 1.9% 10.3% 0.9% 17.1 9.6 9.6 1.0% 2.0 7.0 36.1 19.4 15.8 19.8 Notes payable Accounts payable Other current liabilities Long-term debt and leases Preferred stock Owner's equity Total liabilities and equity 8.2 16.2 40.7 13.3 29.0 0.0 0.0 0.0 0.0 21.5 0.3 43.9 100.0% 49.6 44.8 23.2 53.9 100.0% 100.0% 100.0% 100.0% Selected Ratios D E F J K 2.07 1.45 1.77 1.50 0.77 1.65 0.93 2.00 1.13 0.28 LIFO LIFO LIFO LIFO 6.20 16.80 5 3 5.60 28 1.46 5.1% 3.41 8.3% 2.4% Current ratio Acid test Inventory method Inventory turnover (as reported) AR collection period (days) Net sales/Total assets Net profit/Total assets (return on assets) Net profit/Net sales (net profit margin) Net profit/Net worth (return on equity) Dividends/Net income (payout ratio) Total assets/Net worth Notes payable and long-term debt/Total assets Long-term debt/Net worth Market price/Book value Dividends/Market price Price/Earnings ratio Beta AvCost 125.00 28 0.79 1.8% 2.3% 3.4% 23.6% 185.5% 37.1% 67.0% 0.85 0.9% 6.50 68 161. 0% 1.8% 1.1% 7.9% 55.0% 430.3% 16.6% 3.5% 11.5% 50.0% 225.7% 3.50 9.3% 2.7% 20.8% 26.9% 223.3% 29.9% 64.8% 2.62 2.1% 12.7 26.3% 32.1% 201.6% 15.2% 26.8% 2.87 1.9% 17.3 1.2 48.4% 0.63 50.9% 175.0% 0.67 6.1% 25.5 1.2 7.9% 6.3 1.0 9.0 0.9 0.9

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

The Practice Of Statistics

Authors: Daren S. Starnes, Josh Tabor

6th Edition

9781319113339

Students also viewed these Finance questions