Source of revenue | Business & Finance homework help

 

Don't use plagiarized sources. Get Your Custom Essay on
Source of revenue | Business & Finance homework help
Just from $13/Page
Order Essay

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.

 

  • Is Ascension Health growing?
  • What line items reflected the largest-percentage increases and/or decreases?
  • What is the financial impact these changes have on the company’s financial viability currently and in the future?
  • Prepared a vertical analysis, listing all items of data and performed necessary calculations correctly.
  • Prepared a horizontal analysis listing all items of data and performed necessary calculations correctly.
  • Drew valid conclusions about viability

 

References

 

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)

 

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our Guarantees

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.

Money-Back Guarantee

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

Zero-Plagiarism Guarantee

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

Free-Revision Policy

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

Privacy Policy

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

Fair-Cooperation Guarantee

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

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency