Source of Revenue: Viability

profilebcestevelz1j3

Use the balance sheet 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?
Submit your 2–3-page report by Tuesday, March 21, 2017, .

Assignment 2 Grading Criteria   
Maximum Points
Prepared a vertical analysis, listed all items of data and performed necessary calculations correctly.    20 points
Prepared a horizontal analysis, listed all items of data and performed necessary calculations correctly.  20 points
Drew valid conclusions about viability.  5 points
Communicated ideas and opinions explicitly and clearly in writing. 5 points
Total    50 points

    • 9 years ago
    • 15
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      paper_-_source_of_revenue_-_viability.docx
    • attachment
      ascension_horizontal_and_vertical_analysis.xlsx
    Bids(1)