Prepare vertical analysis and horizontal analysis of health care company?

  • Post category:Nursing
  • Reading time:2 mins read

Prepare vertical analysis and horizontal analysis of health care company?

Assignment 2: Source of Revenue: Viability

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 thecompany 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?

By Tuesday, December 8, 2015, submit your 2–3-page report to the W4: Assignment 2 Dropbox.

Download and review the financial statements of Ascension Health, a nonprofit, religious-based healthcare system, from

http://www.ascensionhealth.org/index.php?option=com_content&view=article

&id=45&Itemid=160.

Assignment 2 Grading Criteria

Maximum Points

Prepared a vertical analysis, listed all items of data and performed necessary calculations correctly.

20

Prepared a horizontal analysis, listed all items of data and performed necessary calculations correctly.

20

Drew valid conclusions about viability.

5

Communicated ideas and opinions explicitly and clearly in writing.

5

Total

50