balance sheet and statement of income
Project instructions:
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 2010 and 2011 and a horizontal analysis from 2010 (base year) to 2011 (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 3, 2013, submit your 2?3-page report to the W4: Assignment 2 Dropbox.
Name your document SUO_HCM3005_W4_A2_LastName_FirstInitial.doc.
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.