Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

Source of Revenue: Viability

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 PointsPrepared a vertical analysis, listed all items of data and performed necessary calculations correctly.    20 pointsPrepared a horizontal analysis, listed all items of data and performed necessary calculations correctly.  20 pointsDrew valid conclusions about viability.  5 pointsCommunicated ideas and opinions explicitly and clearly in writing. 5 pointsTotal    50 points

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question