Source of Revenue: Viability

profilecarall

 

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

Attached below is from 3rd week.

    • 9 years ago
    • 5
    Answer(0)