Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote