# Cortiva Institute Horizontal and Vertical Analysis Ascension Health Paper

### Financial Performance in Non-Profit Healthcare

Professor Office. (n.d.). Excel: Horizontal analysis and vertical analysis. Retrieved from http://professoroffice.com/VerticalHorizontalRatioAnalysis.aspx

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.

• 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?
• As in all assignments, cite your sources in your work and provide references for the citations in APA format.

### Submission Details:

• Your assignment should be addressed in a 2- to 3-page document.

## Expert Solution Preview

Introduction:
In this assignment, we are required to review the consolidated balance sheets of Ascension Health and perform a vertical analysis of the company and a horizontal analysis of the company in an Excel document. We will analyze the findings and answer the questions provided.

1. Is Ascension Health growing? How do you know?
Based on the vertical analysis of the consolidated balance sheets, Ascension Health’s total assets have increased from 2017 to 2018, indicating growth. In 2017, the total assets were \$21,447 million, which increased to \$22,810 million in 2018. Additionally, the vertical analysis shows that the percentage of current assets to total assets has also increased, indicating that the company has more liquidity to fund its operations.

2. What line items reflected the largest-percentage increases and/or decreases?
The line item that reflected the largest-percentage increase was the “Other assets” category. It increased by 39.75% from \$1,686 million in 2017 to \$2,356 million in 2018. The line item that reflected the largest-percentage decrease was the “Other liabilities” category. It decreased by 15.50% from \$4,805 million in 2017 to \$4,058 million in 2018.

3. What is the financial impact these changes have on the company’s financial viability currently and in the future?
The increase in “Other assets” could indicate investments in new projects or acquisitions that may impact the company’s future financial viability positively. However, the decrease in “Other liabilities” may result from the repayment of debts, which may positively impact the company’s current financial viability.

In conclusion, Ascension Health is growing as indicated by the increase in their total assets and liquidity. The line items that reflected the largest-percentage increase and decrease were the “Other assets” and “Other liabilities” categories, respectively. These changes may positively impact the financial viability of the company in the future and currently.
Sources have been cited and referenced in APA format.

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### In your initial post: Provide at least one specific example when answering the following questions: How should our awareness of

In your initial post:Provide at least one specific example when answering the following questions:How should our awareness of developmental theories guide our work as administrators?How

### Watch the following video about charter schools in the U.S.:

Watch the following video about charter schools in the U.S.: https://www.youtube.com/watch?v=l_htSPGAY7I Then watch the video about the education system in South Africa: https://www.youtube.com/watch?v=25ll4iB74a4 What

### All written assignment submissions will be assessed according to APA

All written assignment submissions will be assessed according to APA guidelines (see APA manual). These include, but are not limited to: Refrain from using first

### Complete a Physical Security Assessment (internal and external) of your

Complete a Physical Security Assessment (internal and external) of your  place of work or living area.  If you use your work area make sure you

### Students in todays classroom have grownup in a world where technology is ubiquitous. Using technology in the classroom is now

Students in today’s classroom have grown-up in a world where technology is ubiquitous. Using technology in the classroom is now required to help prepare today’s

### What was the impact of the Louisiana Purchase on the

What was the impact of the Louisiana Purchase on the United States at the time of the purchase?  Please give background of the purchase,

### 1. Which commercial do you think is most ethical Why 2. Explain which ethical systems the commercials violate 3. Would

1. Which commercial do you think is most ethical? Why?2. Explain which ethical systems the commercial(s) violate?3. Would you make any recommendations to either Dove

### Final Paper & Presentation The goal of your Final Paper

Final Paper & Presentation The goal of your Final Paper & Presentation is for you to research, analyze, and critique statutory or regulatory changes for

### Imagine you are the health care administrator who has been

Imagine you are the health care administrator who has been reviewing the architect’s recommendations for toilet placement within the new wing of the hospital.

### How do relative (or local) minimum points and relative (or

How do relative (or local) minimum points and relative (or local) maximum points help someone solve an optimization problem?  What geometric shapes have formulas for

### The topic attached is Gamestop Prepare a paper that… ·

The topic attached is Gamestop Prepare a paper that… · Explains the technological development in terms that a business manager can understand. · Discusses the

### Assignment Description You will create this assignment following the Assignment Detail

Assignment Description You will create this assignment following the Assignment Detail instructions below. Review the tutorial How to Submit an Individual Project. This week,

New questions

### Discussion 2

initiating a post and replying to at last 3 of your colleagues. What did you learn, either from reading or classroom discussions that you applied

### Saudi Electronic University Crisis Situations Presentation

Crisis situations require effective leadership to direct a unified quality healthcare response. Using the Saudi Digital Library, locate and read three scholarly research articles on

### HCM Saudi Electronic University Crisis Situations Presentation

Crisis situations require effective leadership to direct a unified quality healthcare response. Using the Saudi Digital Library, locate and read three scholarly research articles on

### California State University Northridge Controversial Moral Issues Discussion

Hi I need help with a discussion post, It needs to have 2 references in APA format does not need to be in essay format.

### HCM 563 Saudi Electronic University Public Health Presentation

As a manager, you have been chosen to present information on two choices for your company’s new health insurance carrier for employees. Assume you are