Question

Below are Balance Sheet summaries of several companies. Capital = Non-cash Net Trade Working Capital+Tangible Net Noncurrent Assets +Intangible Assets +Excess Cash = Debt +Equity Excess Cash 3496 6796 596 Company ALLERGAN PLC ALLIANCE DATA SYSTEMS AMERICAN AIRLINES GROUP AMERICAN ELECTRIC POWER BRISTOL-MYERS SQUIBB CO CONSOLIDATED EDISON INC DELTA AIR LINES INC EDISON INTERNATIONAL MCDONALD'S CORP MEDTRONIC PLC MICROSOFT CORP SEMPRA ENERGY SOUTHWEST AIRLINES CO STARBUCKS CORP WEC ENERGY GROUP INC XCEL ENERGY INC YUM! BRANDS INC ZIMMER BIOMET HOLDINGS Sector Health Care Information Technology Industrials Utilities Health Care Utilities Industrials Utilities Consumer Discretionary Health Care Information Technology Utilities Industrials Consumer Discretionary Utilities Utilities Consumer Discretionary Health Care Non-cash Net Tangible Net Trade Working Noncurrent Industry Capital Assets Pharmaceuticals -496 -2196 IT Services 33396 1396 Airlines -1796 7196 Electric Utilities -1196 33496 Pharmaceuticals 096 -1096 Multi-Utilities 596 29996 Airlines -2296 5696 Electric Utilities -496 29196 Hotels, Restaurants & Leisure 296 17196 Health Care Equipment & Supp 1896 296 Software -1396 Multi-Utilities -596 43496 Airlines -2396 6495 Hotels, Restaurants & Leisure Multi-Utilities 896 26096 Electric Utilities 196 29396 Hotels, Restaurants & Leisure 196 3696 Health Care Equipment & Supp 3196 1596 Intangible Assets 49896 2096 1396 096 33196 1696 3296 096 1396 19896 4096 1796 696 1696 4196 096 1496 21196 196 5996 596 396 -296 196 2996 10396 -296 1596 Debt 14496 40596 7396 19696 18296 17996 3796 15996 22696 8396 6996 24396 1896 4296 17096 17896 20196 10796 Equity 36296 2896 096 12996 19896 14596 3396 12696 -3996 16496 8196 2019 4496 -2496 13696 11596 -14396 15596 2096 796 -396 -196 896 596 What sector has the highest Tangible Net Noncurrent Assets percent? These long-term assets are primarily Property, Plant & Equipment. What sector has the highest Intangible Asset percent? As a reminder, Intangible Assets are high when there are frequent or sizable acquisitions. What industry has negative Equity? Solvency ratios like Debt/Equity are used to point to potential solvency issues. Are these companies with negative equity at risk of insolvency? What industry has the lowest Non-cash Net Trade Working Capital percent? This industry is generally paid cash in advance (no Accounts Receivables) and no Inventory. What industry has the highest Excess Cash percent?

Answer 1

1.utilities sector

2.Health care,

3.hotels,restaurant & leisure

4.yes they do not have sufficient assets to pay debts

5. Airlines

6.software