Please help with these problems, show ALL work on excel!! Thank you!!
1 . Using the information provided in TABLE 12-15 for United Healthcare Group, a major HMO, discuss some of the primary observations that you would conclude regarding the financial performance of the firm . Relate your discussion to the values presented in Table 12-1 .
2 . Using the information in TABLE 12-16 for Kindred Healthcare, a major nursing home firm, discuss some of the primary observations that you would conclude regarding the financial performance of the firm .
Preview File Edit View Go Tools Window Help MO 34% [4 Fri 3:05 PM Manali Shah Q Essentials of health care finance by James O. Cleverley William O. Cleverley (textbook.com).pdf (page 313 of 586 Q Search Essentials of health care... ASSIGNMENTS Cover 1. Using the information provided in TABLE 12-15 for United Healthcare Group, a major HMO, discuss some of the primary observations that you would conclude regarding the financial performance of the firm. Relate your Essentials of Health Car... discussion to the values presented in Table 12-1. Copyright Contents TABLE 12-15 United Healthcare Group, Inc., 2015 (Data in Millions) Preface Balance sheet data Content of the Book Current assets About the Authors Cash and short-term investments $12,911 Contributor Net accounts receivable 6,523 Chapter 1 Financial Infor... Inventory 0 Chapter 2 Billing and Co... Other current assets 12,205 Chapter 3 Financial Envi.. Chapter 4 Legal and Reg.. Total current assets $31,639 Chapter 5 Measuring Co.. Net fixed assets 4,861 Chapter 6 Revenue Dete... Chapter 7 Health Insura... Chapter 8 General Princi... Chapter 9 Financial Stat... Summary 303 Chapter 10 Accounting f... Chapter 11 Analyzing Fin... Long-term investments 18,792 Chapter 12 Financial Ana... Goodwill and other intangible assets 52,844 Chapter 13 Strategic Fin... Other assets 3,247 Chapter 14 Cost Concep... Chapter 15 Product Cost... Total assets $111,383 Chapter 16 The Manage... Liabilities and equity Chapter 17 Cost Varianc... Total current liabilities $42,898 Chapter 18 Financial Mat.. Long-term debt 25,460 Chapter 19 Capital Proje Other liabilities 9,300 Chat A 2 12 9,995 ... RP tv X W O PPreview File Edit View Go Tools Window Help OMO 35% [43 Fri 3:05 PM Manali Shah Q Essentials of health care finance by James O. Cleverley William O. Cleverley (textbook.com).pdf (page 314 of 586) Q Search Total Current Tapes 142,090 Essentials of health care... Long-term debt 25,460 Cover Other liabilities 9,300 Essentials of Health Car... Copyright Equity 33,725 Contents Total liabilities and equity $111,383 Preface Income statement data Content of the Book Total revenue $157,107 About the Authors Expenses Contributor Depreciation and amortization $1,693 Chapter 1 Financial Infor... Chapter 2 Billing and Co... Other operating expense 44,393 Chapter 3 Financial Envi.. Total operating expense $146,086 Chapter 4 Legal and Reg.. Interest expense 790 Chapter 5 Measuring Co.. Net income before taxes $10,231 Chapter 6 Revenue Dete... Income tax 4,363 Chapter 7 Health Insura... Net income after tax $5,868 Chapter 8 General Princi... Chapter 9 Financial Stat... 2. Using the information in TABLE 12-16 for Kindred Healthcare, a major nursing home firm, discuss some of the primary observations that you would conclude regarding the financial performance of the firm. Chapter 10 Accounting f... Chapter 11 Analyzing Fin... TABLE 12-16 Kindred Healthcare, Inc., 2015 (Data in Thousands) Chapter 12 Financial Ana... Balance Sheet Data Chapter 13 Strategic Fin... 12/31/2015 12/31/2014 Chapter 14 Cost Concep... Assets Chapter 15 Product Cost... Current assets Chapter 16 The Manage... Cash and cash equivalents $ 98,758 $ 164,188 Chapter 17 Cost Varianc... Chapter 18 Financial Mat.. Chapter 19 Capital Proje Chat A 2 12 9,995 ... RP "tv X W O PPreview File Edit View Go Tools Window Help OMO 35% [43 Fri 3:05 PM Manali Shah Q Essentials of health care finance by James O. Cleverley William O. Cleverley (textbook.com).pdf (page 315 of 586 Q Search Essentials of health care... Cover Essentials of Health Car... Copyright 304 Chapter 12 Financial Analysis of Alternative Healthcare Firms Contents Preface TABLE 12-16 Kindred Healthcare, Inc., 2015 (Data in Thousands) (continued) Content of the Book About the Authors Balance Sheet Data Contributor 12/31/2015 12/31/2014 Chapter 1 Financial Infor... Net accounts receivable $1,194,868 $944,219 Chapter 2 Billing and Co... Other current assets $207,273 $199,264 Chapter 3 Financial Envi.. Total current assets $ 1,500,899 $ 1,307,671 Chapter 4 Legal and Reg.. Property, plant, and equipment, net $ 971,996 $ 902,104 Chapter 5 Measuring Co.. Goodwill $ 2,669,810 $ 997,597 Chapter 6 Revenue Dete... Intangible assets $ 755,655 $ 400,700 Chapter 7 Health Insura... Other assets $ 620,576 $ 2,044,892 Chapter 8 General Princi... Chapter 9 Financial Stat... Total assets $ 6,518,936 $ 5,652,964 Chapter 10 Accounting f... Liabilities Chapter 11 Analyzing Fin... Total current liabilities $ 1,111,212 $ 857,263 Chapter 12 Financial Ana... Long-term debt $ 3,137,025 $ 2,852,531 Chapter 13 Strategic Fin... Other liabilities $ 263,273 $ 243,614 Chapter 14 Cost Concep... Deferred long-term liability charges $ 301,379 $ 213,584 Chapter 15 Product Cost... Total liabilities $ 4,812,889 $ 4,166,992 Chapter 16 The Manage... Total stockholders equity $ 1,706,047 $ 1,485,972 Chapter 17 Cost Varianc... Chapter 18 Financial Mat.. Income Statement Data Chapter 19 Capital Proje 12/31/2015 12/31/2014 Chat A 2 12 9,995 ... RP "tv X W O P OPreview File Edit View Go Tools Window Help OMO 35% [43 Fri 3:05 PM Manali Shah Q Essentials of health care finance by James O. Cleverley William O. Cleverley (textbook.com).pdf (page 315 of 586 Q Search Essentials of health care... Cover Income Statement Data Essentials of Health Car... 12/31/2015 12/31/2014 Copyright Revenue $ 7,054,907 $ 5,027,599 Contents Expenses Preface Salaries, wages and benefits $ 3,614,091 $ 2,442,879 Content of the Book Supplies $ 384,354 $ 289,043 About the Authors Rent $ 382,609 $ 313,039 Contributor Depreciation and amortization $ 157,251 $ 155,570 Chapter 1 Financial Infor... Interest expense $ 232,395 $ 17,044 Chapter 2 Billing and Co... Chapter 3 Financial Envi.. General and admin expenses $ 1,395,288 $ 973,223 Chapter 4 Legal and Reg.. Chapter 5 Measuring Co.. Chapter 6 Revenue Dete... Chapter 7 Health Insura... Summary 305 Chapter 8 General Princi... Chapter 9 Financial Stat... Income Statement Data Chapter 10 Accounting f... 12/31/2015 12/31/2014 Chapter 11 Analyzing Fin... $ 983,579 $ 831,443 Chapter 12 Financial Ana... Other operating expenses Chapter 13 Strategic Fin... Total operating expenses $ 7,149,567 $ 5,022,241 Chapter 14 Cost Concep... Earnings before taxes $ (94,660) $ 5,358 Chapter 15 Product Cost... Income tax expense $ (42,797) $ 462 Chapter 16 The Manage... Net income from continuing operations $ (51,863) $ 4,896 Chapter 17 Cost Varianc... Discontinued operations, net of income taxes $ (41,521) $ (84,733) Chapter 18 Financial Mat.. Net income $ (93,384) $ (79,837) Chapter 19 Capital Proje Chat A 2 12 9,995 ... RP "tv X W O P O
