Assignment: 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 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?
By submit your 2-3-page report to the W4: Assignment 2 Dropbox.
This is the link to Ascension Health balance sheet and statement of income:
https://www.ascensionhealth.org/index.php?option=com_content&view=article&id=45&Itemid=160.