Source of Revenue: Viability –Due Monday, September 29, 2015
Use the balance sheet and statement of income you downloaded for Ascension Health during Week 3. In a Microsoft Excel spreadsheet, prepare a vertical analysis of the company for the years 2013 and 2014 and a horizontal analysis from 2013 (base year) to 2014 (subsequent year).
Discuss your findings. Here are a few, but not all, the questions you should consider.
Ascension Healthcare Alliance (2015). Consolidated Financial Statement and Supplementary Information. Retrieved from http://ascension.org/~/media/files/community_investor-relations
Hospital Corporation of America (2014). Patient first; 2014 Annual Report for shareholders. Retrieved from http://investor.hcahealthcare.com/sites/hcahealthcare.investorhq.businesswire.com/files/report/file/HCA_Holdings_Inc._2014_Annual_Report.pdf
References to use are on the attachment.
Attachment is from Week 3.
The key components to consider in Ascension Health’s balance sheet include the current assets, current liabilities, long-term assets, and long-term liabilities. The total current assets for the year ending 2013, is 4,781,290, whereas the total current assets for the year ending 2014 is 4,622,537. The current long term assets for the year ending 2013 is 2,834,780, whereas the long term assets for the year 2014 ended with a total of 2,938,442. The total current assets for both years are 30,047,371 and total long term assets for both years are 31,298,863. (Ascension Healthcare Alliance, 2015)
The current liabilities for the company in the year 2013 are 5,353,769, whereas the current liabilities for 2014 are 5,014,449. On the other hand, the long-term liability for 2013 is 7,564,975, whereas the long term liabilities for 2014 are 7,309,277. The total liabilities for the respective years are 12,918,744 and 12,323,726. (Ascension Healthcare Alliance, 2015)
The income statement for the company on the other hand, reveals that the operating revenue for 2013 is 16,536,898, whereas operating revenue for 2014 is 20,149,720. The total non-operating expenses for the two years are 16,017,377 and 19,386,269. The company experiences non-operating gains of 2,746,950 for 2013 and 1,450,614 for 2014. (Ascension Healthcare Alliance, 2015)
The balance sheet reveals that equity in earnings of affiliates increased from $29 million for 2013 to $43 million for 2014. (Ascension Healthcare Alliance, 2015)
The net cash flow for operating activities for 2014 is 951460 and for 2015 are 977929. The cash flow for investing activities for 2014 is 1,072,510 and respectively, 871,369 in 2015, however, they are both negative. The net flow for financing activities is 618,418 in 2014 and 688,228 in 2015 respectively. (Ascension Healthcare Alliance, 2015)
Apart from these general values, it is possible to calculate financial ratios, which will help in giving better picture of the company. The most common financial ratios are liquidity ratios and the profitability ratios. The current ratio is used for determining whether there are sufficient resources in the company to clear the debt for 12 months. It is determined using the formula, current ratio=current assets/ current liabilities. From the values given, the current ratio for Ascension Health Company is 89.3% for 2013 and 92.1% in 2014. (Ascension Healthcare Alliance, 2015)
The income statement for HCA Holdings, on the other hand, reveals that the revenue for the year 2013 is $34,182, whereas the revenue for 2014 is $36,918 (Hospital Corporation of America 2014). Respectively, total expenses for both years are 31,236 in 2013 and, 33,437 respectively in 2014. (Hospital Corporation of America 2014)
The current liabilities for 2013 is $28831 and 31199 in 2014. The current assets for 2013 is 28,831 and the current assets for 2014 is 31199 (Hospital Corporation of America 2014). The cash flow from operating activities for 2013 is 3680 and for 2014 is 4448. The cash flow from investing activities are both negative. On the other hand, on the other hand, the cash flow from financing activities is $694 for 2013 and $1057 for 2014. (Hospital Corporation of America 2014)
The balance sheet components include assets, liabilities, and long term assets, both current and non-current. Such components are subjected to some kind of analysis to get a refiner picture or by getting the ratios.
HCA Holdings Company’s ratios for both 2013 and 2014 are 1%. The first difference between the two companies is the economies of scale. It is apparent from the values given that the Ascension Health Company is relatively bigger than HCA holdings. This is because its transactions are made in millions of dollars whereas, that of HCA holdings are in thousands of dollars. (HCA, 2014)
The first difference concerns the gross profits and net profits. It is apparent that Ascension’s made a profit of 2,746,950 in 2013 and 2014, their profit was 1,450, whereas, HCA Holdings made a net gain of $1,556 for 2013 and $1,875 in 2014 respectively. The second difference is that the two companies differ in their current ratios. The current ratio for Ascension Health is 89.3% for 2013 and 92.1% for 2014. However, on the other hand, the current ratio for HCA Holdings is 1% for both 2013 and 2014. (HCA, 2014)
The third difference is that the two companies have difference in cash flows. For example, the cash flow from operating activities for HCA Holdings in 2013 is 3680 and for 2014 is 4448. On the other hand, the net cash flow for operating activities for Ascension for HCA Holdings 2014 is 951460 and for 2015 is 977929. The fourth differences are that the equity in earnings of affiliates for Ascension increased from $29 million for 2013 to $43 million for 2014. This is far much higher than that of HCA Holdings Company. The fifth difference is that the two companies have difference in the cash flow from financing activities. The one for HCA Holdings is 694 for 2013 and 1057 for 2014, whereas that of Ascension is 618,418 and 688,228 for 2014 and 2015 respectively. (HCA, 2014)
At 111papers.com, we value all our customers, and for that, always strive to ensure that we deliver the best top-quality content that we can. All the processes, from writing, formatting, editing, and submission is 100% original and detail-oriented. With us, you are, therefore, always guaranteed quality work by certified and experienced writing professionals. We take pride in the university homework help services that we provide our customers.
As the best homework help service in the world, 111 Papers ensures that all customers are completely satisfied with the finished product before disbursing payment. You are not obligated to pay for the final product if you aren’t 100% satisfied with the paper. We also provide a money-back guarantee if you don’t feel that your paper was written to your satisfaction. This guarantee is totally transparent and follows all the terms and conditions set by the company.Read more
All products that we deliver are guaranteed to be 100% original. We check for unoriginality on all orders delivered by our writers using the most advanced anti-plagiarism programs in the market. We, therefore, guarantee that all products that we submit to you are 100% original. We have a zero-tolerance policy for copied content. Thanks to our strict no plagiarized work rule, you can submit your homework to your professor without worrying.Read more
TThis is one of the most cherished courtesy services that we provide to help ensure that our customers are completely satisfied with our finished products. Delivering the best final product to our customers takes multiple inputs. 111papers.com prides itself on delivering the best university homework help services in the writing industry. And, in part, our free revision policy is how we do it. What’s more, all our revisions are 100% free without any strings attached.Read more
Client privacy is important to use. We know and understand just how important customers value their privacy and always want to safeguard their personal information. Thus, all the information that you share with us will always remain in safe custody. We will never disclose your personal information to any third party or sell your details to anyone. 111 Papers uses the most sophisticated, top-of-the-line security programs to ensure that our customers’ information is safe and secured.Read more
Placing your order with us means that you agree with the homework help service we provide. We, in turn, will endear to ensure that we do everything we can to deliver the most comprehensive finished product as per your requirements. We will also count on your cooperation to help us deliver on this mandate. Yes, we also need you to ensure that you have the highest-quality paper.Read more