### Our Services

Get 15% Discount on your First Order

# 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.

Order a Similar Paper and get 15% Discount on your First Order

## Related Questions

### Please read attached document completely, it has the case study itself.  1. Select one of the case studies presented in the

Please read attached document completely, it has the case study itself.  1. Select one of the case studies presented in the  Assessment 03 Supplement: Applying Ethical Principles [PDF]  Download Assessment 03 Supplement: Applying Ethical Principles [PDF] resource. · Note: The case study may not supply all of the information you

### 1. Select one of the health care problems or issues presented in the  Assessment 02 Supplement: Applying Research Skills

1. Select one of the health care problems or issues presented in the  Assessment 02 Supplement: Applying Research Skills [PDF]  Download Assessment 02 Supplement: Applying Research Skills [PDF] resource. Write a brief overview of the selected health care problem or issue. In your overview: · Summarize the health care problem

### STUDENT 1 Purpose To practice using literary devices and preparing to use them in our Spark Grant Proposals Tasks Choose three literary devices from

STUDENT 1 Purpose To practice using literary devices and preparing to use them in our Spark Grant Proposals Tasks Choose three literary devices from the class list(Word document ) and create original examples for each of those devices. Ideally, these examples should relate to your Spark Grants topic and can be used verbatim

### This Mid-Course Reflection Paper is a synopsis of your thoughts and comprehension of concepts learned thus far in the course. Your paper should be created

This Mid-Course Reflection Paper is a synopsis of your thoughts and comprehension of concepts learned thus far in the course. Your paper should be created using APA format (title page, double spaced, references, etc.). Your paper should be a minimum of two pages and include the following components. Identify all

### Please see the attached document for specific instructions and related questions.  Instructions Format – Examine the

Please see the attached document for specific instructions and related questions.  Instructions Format – Examine the different career counseling theories, and present them in below format. – Name the theorists associated with the theories. – Explain the main elements of the theories. – Discuss the ethical considerations associated with the

### Subject: Centers for Disease Control and Prevention. Power point presentation slides :Identify the benefits and risks of use.

Subject: Centers for Disease Control and Prevention. Power point presentation slides :Identify the benefits and risks of use.

### Para hablar con una persona en Volaris, sigue estos pasos: Prepara tu información: Ten a mano tu número de reserva y datos personales. Visita el sitio

Para hablar con una persona en Volaris, sigue estos pasos: Prepara tu información: Ten a mano tu número de reserva y datos personales. Visita el sitio web de Volaris: Ve a www.volaris.com. Navega a ‘Contáctanos’: Al final de la página principal, haz clic en ‘Contáctanos’1-888-829-1330 OTA. Encuentra el número

### How did Starbucks create its uniqueness in the first place? Why was the uniqueness so successful? To be a source of competitive advantage over

How did Starbucks create its uniqueness in the first place? Why was the uniqueness so successful? To be a source of competitive advantage over time, core competencies need to be continuously honed and upgraded. Why and how did Starbucks lose its uniqueness and struggle in the mid-2000s? What strategic

### After reading the case “Willamette” on pages 173-184 of your text, you are to respond in this discussion area with your observations of the case. Do

After reading the case “Willamette” on pages 173-184 of your text, you are to respond in this discussion area with your observations of the case. Do not discuss eventual outcomes of the case. Sufficient elaboration on the topic is needed. In-text citations and references are needed. Please use the APA

### The Census and Race/Ethnicity * Read through these instructions first. Then proceed through this document, starting at the top. Step 3 contains

The Census and Race/Ethnicity * Read through these instructions first. Then proceed through this document, starting at the top. Step 3 contains the actual post questions. Step 1: Open up two tabs for these sites so you can go back and forth: The first link above is the U.S. Census

### The purpose of this activity is to interview local coaches or sport administrators to learn how their organizations are implementing principles of

The purpose of this activity is to interview local coaches or sport administrators to learn how their organizations are implementing principles of athlete talent development. Select and interview a local coach or sports administrator. Use the list on worksheet 5.9 as an interview guide      Video (2:27) “Carolina Basketball:

### The topic is Incorporating Social Emotional Learning (SEL) and Biblical Worldview in Christian Schools  also follow the advanced side of the grading

The topic is Incorporating Social Emotional Learning (SEL) and Biblical Worldview in Christian Schools  also follow the advanced side of the grading rubric

### Stringer, E. T., & Aragón, O. A. (2020).  Action research (5th ed.). SAGE Publications, Inc. ISBN: 9781544355948. Read chapters 6 & 7.

Stringer, E. T., & Aragón, O. A. (2020).  Action research (5th ed.). SAGE Publications, Inc. ISBN: 9781544355948. Read chapters 6 & 7. Discussion Question: Must be at least 250 words. Why is it important to build a community with a prescribed vision within the AR project? Describe a time when developing a

### Justify your answers with appropriate research and reasoning. Comment on 2 Reponses that is on attachment   Ex plain why Pavlov’s experiments in

Justify your answers with appropriate research and reasoning. Comment on 2 Reponses that is on attachment   Ex plain why Pavlov’s experiments in reflexology were an important part in the development of psychology. De scribe behaviorism from Watson’s perspective; then, compare and contrast his viewpoints with operational positivism and the

### Just 3-5 sentences to answer the question Reply to Destini in a few 2-3 sentences

Just 3-5 sentences to answer the question Reply to Destini in a few 2-3 sentences

### After reading and watching the content for this module, respond to the following questions: 1. What did you already know about social and emotional

After reading and watching the content for this module, respond to the following questions: 1. What did you already know about social and emotional development in infants and toddlers? 2. Did you learn anything new about social and emotional learning and how it influences later development? 3. Do you think

### I just someone to check my work, i have already done all of them but there is missing stuff i didn’t solve  FOR Lab one  what i want  On page 7i need Part

I just someone to check my work, i have already done all of them but there is missing stuff i didn’t solve  FOR Lab one  what i want  On page 7i need Part A : single melting point determination of unknown sample  Table  Page 8 all page, page 9all pages,

### ASSIGNMENT 1:Complete the POA/HAC for the given scenarios. The beginning of Chapter 4 gives a quick review of POA/HAC. The attached AHIMA article gives

ASSIGNMENT 1:Complete the POA/HAC for the given scenarios. The beginning of Chapter 4 gives a quick review of POA/HAC. The attached AHIMA article gives more details. Be sure to read it.Campbell, Angela; D’Amato, Cheryl; Rugg, Donna. “Managing the Present on Admission Reporting Process (2016 update)” Journal of AHIMA 87, no.9