To complete the Module 5 Excel Assignment, follow the steps below

| February 25, 2017

Question
To complete the Module 5 Excel Assignment, follow the steps below:

Step 1: Obtain the “Consolidated Statements of Earnings” and “Consolidated Balance Sheets” for HCA and THC for 2014.

Step 2: Prepare common size income statements for both on a worksheet of a spreadsheet 3. Prepare common size balance sheets for both on a worksheet of a spreadsheet

Step 3: Make three (3) observations on any key points of difference between the two companies

The information to answer the question above comes from the following website.

Financial statements for many publicly traded firms are available at:

.sec.gov/edgar.shtml”>http://www.sec.gov/edgar.shtml

This site is maintained by the Securities and Exchange Commission (SEC) and is called EDGAR. The annual reports are 10-K reports while quarterly reports are 10-Q reports. HCA Holdings (HCA) and Tenet Healthcare Corporation (THC) are two publicly traded hospital companies that we will study.

Get a 25 % discount on an order above $ 100
Use the following coupon code:
25%OFF
Positive SSL