Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

with the ratios given determine which indurty is which Industry List 1. Airline Company 2. Automobile manufacturer 3. Pharmaceutical company 4. Commercial bank 5. Computer

with the ratios given determine which indurty is which

Industry List 1. Airline Company 2. Automobile manufacturer 3. Pharmaceutical company 4. Commercial bank 5. Computer and office equipment manufacturer 6. Discount general-merchandise store chain 7. Electric utility 8. Fast-food chain 9. Wholesale food distributor 10. Supermarket chain 11. Textile manufacturer 12. Tax services company 13. Software development company Ratios Used 1. ROS = Net Income/Net sales 2. Asset Turnover = Net Assets/Average. total assets 3. ROA (Return on assets) = Net sales/Average total assets or ROS X Asset Turnover 4. Financial Leverage = Avg. total assets/Avg. total owners equity 5. ROE (Return on equity) Net Income/Avg. total owners equity or ROA X Financial leverage 6. Long-term debt to capital = Long-term deb there is an excel spreadsheet with all the ratios Ratios Tell A Story 1 2 3 4 5 6 7 8 9 10 11 12 13 Fiscal year-end June Dec Feb Dec Dec Oct Jan Dec April Dec Dec Dec May Percentage of Total Cash and Equivalents 62.3 22.6 11.8 12.1 3.5 14.4 2.2 7.5 35.7 14.7 8.9 4.9 1.7 Receivables 6.8 69.7 3.5 3.4 3.9 25.7 2.1 1.1 27.6 1.8 11.1 3.9 18.1 Inventory 19.4 1.8 1.9 21.3 40.1 2.0 1.2 8.3 22.9 28.2 Other current assets 3.0 2.3 2.3 1.0 4.5 1.0 2.7 3.4 1.3 3.4 3.7 2.4 Total Cureent assets 72.1 92.3 37.0 19.6 10.3 65.9 45.4 13.3 66.7 19.0 31.7 35.4 50.4 Net plant and equipment 10.2 1.6 61.4 65.3 76.6 19.9 51.4 12.4 22.0 80.9 25.6 49.7 21.0 Financial service assets 69.4 Goodwill and equity investments 16.3 0.6 2.6 0.7 4.2 36.1 7.3 15.0 Other assets 1.4 5.5 1.6 12.5 13.1 14.2 3.2 4.2 7.1 0.1 6.6 7.6 13.6 Total Assets 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 Notes payable 2.7 0.5 3.9 14.2 3.9 0.9 Accounts payable 5.0 66.9 16.5 5.5 3.0 10.0 19.3 4.3 10.2 3.8 12.7 6.5 36.0 Accrued expenses 2.3 0.4 5.8 4.0 1.2 13.0 6.1 5.8 6.3 13.7 9.9 8.8 Income taxes 3.2 1.1 0.4 4.8 0.8 0.5 6.8 3.3 Other current liabilities 14.5 1.1 0.4 5.8 3.6 1.6 1.3 3.0 2.1 6.7 1.9 Total Current Liabilities 25.0 70.0 23.9 11.0 10.4 35.3 27.8 11.9 37.5 20.5 22.0 24.0 46.7 Long-term debt 9.5 12.2 12.9 28.4 9.9 25.3 2.5 14.8 5.2 27.6 5.5 Financial service liability 63.5 Deferred-tax liaiblity 0.9 4.2 17.6 1.2 0.4 1.4 10.3 10.9 7.7 3.4 Other liabilities 11.6 4.9 0.6 1.0 3.8 10.4 2.1 7.1 8.8 2.2 Total liabilities 25.0 91.1 41.9 28.7 57.4 49.0 54.3 88.7 41.0 52.7 46.9 61.5 55.6 Minority interest 2.6 6.8 4.6 Translation adj. and other (0.9) (1.0) (0.4) (1.7) Preferred stock 6.8 0.1 10.3 2.2 0.2 0.2 7.5 Common stock 31.4 8.6 4.1 18.8 9.8 3.7 2.0 2.4 26.2 8.9 20.2 12.8 12.4 Retained earnings 36.8 0.2 54.5 43.2 30.6 47.3 42.1 9.1 35.7 38.4 67.0 19.9 32.0 Treasury stock (0.5) (0.1) (9.9) (38.7) Total owners' equity 75.0 8.9 58.1 71.3 42.6 51.0 45.7 11.3 59.0 47.3 53.1 38.5 44.4 Total liabilities and equity 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 Return on Sales 30.4% 9.9% 2.22% 6.41% 10.0% 7.27% 2.91% 5.64% 2.48% 8.33% 19.60% -1.26% 1.74% Asset Turnover 0.93 0.12 2.63 1.09 0.49 1.44 2.72 0.45 1.05 0.96 0.94 1.38 5.96 Return on Assets 28.3% 1.15% 5.84% 7.00% 4.95% 10.47% 7.92% 2.55% 2.60% 7.99% 18.40% -1.74% 10.37% Leverage 1.38 11.25 1.74 1.66 2.34 2.01 2.42 9.43 1.80 2.18 2.04 2.55 2.50 Return on Equity 39.10% 12.90% 10.20% 11.65% 11.59% 21.00% 19.20% 24.10% 4.68% 17.40% 37.50% -4.44% 25.90% Long-term debt/capital 51.6% 17.4% 15.3% 40.1% 16.3% 36.9% 18.1% 23.8% 8.58% 41.8% 11.0% Current Ratio 2.87 1.55 1.79 0.99 1.87 1.64 1.11 1.78 0.93 1.47 1.49 1.08 Inventory turnover 10.60 28.00 10.80 3.77 5.25 18.00 5.49 4.81 18.70 Days receivables outstanding 26 2195 5 11 29 65 3 9 81 7 43 17 10 Revenue growth 31.0% 9.3% 0.5% 7.4% 2.3% 11.6% 12.0% 4.2% 16.5% 12.1% 19.2% -3.9% 4.9% Gross margin 90.4% 29.5% 37.9% 33.9% 20.2% 11.4% 66.5% 50.1% 14.1% 10.5% Dividend payout 0.0% 58.8% 52.3% 24.2% 69.3% 17.0% 15.7% 29.2% 225.0% 2.0% 44.2% 8.7%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Management And Cost Accounting

Authors: Charles T. Horngren, Alnoor Bhimani, Srikant M. Datar, George Foster

1st Edition

0130805475, 978-0130805478

More Books

Students also viewed these Accounting questions

Question

How is the education level required for a position established?

Answered: 1 week ago

Question

Why is a job analysis important?

Answered: 1 week ago