Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Attached is an Exhibit which presents the common size Balance Sheet and other selected nancial data from 201? f 2018 for fourteen fairly typical companies
Attached is an Exhibit which presents the common size Balance Sheet and other selected nancial data from 201? f 2018 for fourteen fairly typical companies in fourteen different industries. Try to match the fourteen companies to the fourteen industries listed below. i. ii. iii. iv. v. vi. vii. viii. ix. x. xi. xii. xiii. xiv. Aircraft manufacturer Airline Bookstore chain '3 ommercial bank Computer software developer Department store chain Electric and gas utility IT hardware and storage provider Unline retailer Parcel delivery service Pharmaceutical company Retail grocery chain Software and service provider for customer relationship management Social networking service Give a brief explanation of your reasoning for each. You may want to focus on the most unique industries first, or group similar industries such as services that likely would have little or no inventories. Exhibit 1 Balance Sheet Percentages and Selected Financial Data for Unidentified Industries Line A B C D E F G H K L M N Balance Sheet Percentages Cash and Marketable Securities 12 31 52 22 Accounts Receivable 16 10 10 11 19 Inventories 0 14 48 18 0 SONOWU Other Current Assets 0 0 4 Property, Plant, and Equipment 35 11 14 Other Assets 7. Total Assets 100 100 100 100 100 100 100 100 100 100 100 100 8. Notes Payable 75 10 O 9 . Accounts Payable 30 NM 13 NM INWN 10. Accrued Items 16 17 MON NOWw 11. Other Current Liabilities 18 10 NOONWED 30 10 37 12. Long-term Deb 20 29 28 36 11 32 13. Other Liabilities 21 15 18 8 19 28 11 4 14. Total Liabilities 58 63 77 72 68 76 88 87 89 55 100 81 55 15. Retained Earnings + Accumulated Loss 44 46 10 37 12 56 -7 11 42 38 35 44 -2 16. Treasury Stock -52 -15 -2 -1 32 -64 -79 -1 -4 -2 -5 -47 -39 0 17. Other Equity Accounts 50 6 21 100 35 21 W - 48 13 14 46 18. Total Equity 42 37 23 28 32 24 12 13 11 88 35 0 19 45 19. Total Liabilities and Equity 100 100 100 100 100 100 100 100 100 100 100 100 100 100 Selected Financial Data 20. Current Assets/ Current Liabilities 1.4 1.4 1.0 1.1 2.9 1.1 1.1 0.8 1.1 12.9 0.8 12 0.8 0.9 21. Cash, MS, AR/Current Liabilities 0.9 12 0.8 0.6 2.7 0.1 0.4 0.6 0.8 12.6 0.7 0.4 0.2 0.8 22. Inventory Turnover (X) 1.5 N/A 7.7 8.5 14.4 2.7 1.9 21.9 N/A NA N/A 1.5 14.6 N/A 23. Receivables Collection Period (days) 57 47 22 60 88 6 52 4678 52 16 41 5 136 24 . Total Debt Total Assets 0.25 0.32 0.09 0.30 0.29 0.09 0.34 0.42 0.82 0.00 0.24 0.12 0.42 0.08 25. Payables Period (days) 151 41 105 92 82 66 52 114 N/A 25 13 65 22 10 26. Revenue/Total Assets 0.31 1.25 1.63 0.29 0.43 2.09 1.91 0.64 0.05 0.48 0.74 1.01 3.30 0.50 27. Net Profit Revenue 23% 7% 2% 11% 33% -3% 3% -5% 29% 39% 13% 9% 2% 1% 28. Net Profit Total Assets 7% 9% 3% 3% 14% -7% 5% -3% 1% 19% 10% 9% 5% 1% 29. Total Assets/Equity 2.4 2.7 4.3 3.6 3.1 4.2 8.3 8.0 9.3 1.1 2.9 224.1 5.4 2.2 30. Net Profit Equity 17% 24% 12% 12% 44% 30% 45% -25% 13% 21% 28% 1990% 28% 1% 31. EBIT/Interest Expense 9.7 8.7 8.6 2.8 12.8 2.2 6.8 -1.4 3.5 NA 12.2 28.6 3.5 2.7 32. EBITDA/Revenue 35% 12% 24% 41% 3% 10% 7% 36% 57% 21% 13% 4% 10% Source: Compiled from company annual reports. Note: N/A = Not Applicable; NM = Not meaningful, negligible amount Column totals may not add to 100 due to rounding
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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