Professor Office. (n.d.). Excel: Horizontal analysis and vertical analysis. Retrieved from

Use the consolidated balance sheets downloaded from Ascension Health to perform a vertical analysis of the company and a horizontal analysis of the company in an Excel document.

Discuss your findings by answering the following:

  • Is Ascension Health growing? How do you know?
  • 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?

Leave a Reply

Your email address will not be published. Required fields are marked *