The comparative balance sheets of XYZ Healthcare are presented here. XYZ Healthc
ID: 346983 • Letter: T
Question
The comparative balance sheets of XYZ Healthcare are presented here.
XYZ Healthcare
Comparative Balance Sheets
December 31
($ in millions)
Assets 2017 2016
Current assets $17,275 $17,238
Property, plant, and equipment (net) 15,137 15,303
Other assets 52,556 46,526
Total assets $84,968 $79,067
Liabilities and Stockholders’ Equity
Current liabilities $20,653 $26,976
Long-term liabilities 44,695 37,086
Stockholders’ equity 19,620 15,005
Total liabilities and stockholders’ equity $84,968 $79,067
Instructions
Prepare a percentage change analysis of the balance sheet data for XYZ Healthcare.
Prepare a common size analysis of the balance sheet data for XYZ Healthcare for 2017.
Explanation / Answer
XYZ Healthcare col A COL B COL C COL D COL E COL F Comparative Balance Sheets Common size balance sheet analysis A percentage change analysis of the balance sheet data Value change ($ in millions) Dec-31 Col F calculated Col E Assets 2017 2016 2017 2016 2017 2016 Current assets $17,238 17275 $17,238 20% 22% 0.2% $37 COL B-COL A COL F/COL A Property, plant, and equipment (net) 15137 15,303 18% 19% -1.1% ($166) Other assets 52,556 46,526 52556 46,526 62% 59% 11.5% $6,030 Total assets 84968 $79,067 100% 100% 6.9% $5,901 Liabilities and Stockholders’ Equity Current liabilities 20653 $26,976 24% 34% -30.6% ($6,323) Long-term liabilities 44695 37,086 53% 47% 17.0% $7,609 Stockholders’ equity 15,005 19620 15,005 23% 19% 23.5% $4,615 Total liabilities and stockholders’ equity $79,067 84968 $79,067 100% 100% 6.9% $5,901 Instructions Benefits Prepare a percentage change analysis of the balance sheet data for XYZ Healthcare. How a balance sheet changes from year to year & quarter to quarter Prepare a common size analysis of the balance sheet data for XYZ Healthcare for 2017. Compares the historical trend of accounting