Our Services

Get 15% Discount on your First Order

Cortiva Institute Horizontal and Vertical Analysis Ascension Health Paper

May 20, 2023

Financial Performance in Non-Profit Healthcare

Please review:

Professor Office. (n.d.). Excel: Horizontal analysis and vertical analysis. Retrieved from

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.

Discuss your findings by answering the following:

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.

Analysis, Ascension, Cortiva, Health, Horizontal, Institute, paper, Vertical

Share This Post

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

Related Questions

EHHA 501 Patient Journey Flow Chart

Develop an existing patient journey that crosses the three sectors of care in your organization (the organization is military hospital) Hwo could this be improved ? As a chart flow You are a medical professor in charge of creating college assignments and answers for medical college students. You design and

MDC Gabapentin in the Context of Bipolar Disorder

A new patient presents to your office for treatment of bipolar disorder. In his medical history, he reports that he takes gabapentin prescribed by his primary care provider, but he is not sure what he takes it for. He states he is almost out of his gabapentin and is asking

KEMUL Health & Medical Using Technology to Prevent Patient

Using Technology To Prevent Patient Falls Review the concepts of technology application as presented in the Resources. Reflect on how emerging technologies such as artificial intelligence may help fortify nursing informatics as a specialty by leading to increased impact on patient outcomes or patient care efficiencies. In a project proposal

KEMUL Organizational Conflict and Effectiveness

1. Conflict 2.Relationship Between Organizational Conflict and Effectiveness 3.Common Sources of Organizational Conflict 4.Managerial Response to Conflict 5.Categories of Conflict 6.Stages of Conflict 7.Conflict Resolution Outcomes 8.Common Conflict Resolution Strategies. 9.Compromising 10.Competing 11.Cooperating/Accommodating 12.Common Causes of Organizational Conflict 13.Helpful Tips in Conflict Resolution. 14.Negotiation 15.Types of Alternative Dispute Resolution (ADR)

HSA 405 SU?Healthcare Quality Case Study

Overview In order to complete this case study, refer to this week’s readings for policy information required to analyze and make recommendations on this case. As a healthcare quality fraud analyst, you are responsible for identification of root causes and providing recommendations in an action plan to ensure compliance with

Needs to be 3 paragraphs You are the sole psychologist on

Needs to be 3 paragraphs You are the sole psychologist on what is considered a small-sized base, with a population of approximately 6,000 people, including civilians, dependents, reservists, and active duty personnel. You have an appointment scheduled today with a patient whom you know works within the MTF (Military Treatment

Homework Content ScenarioThe administrator’s presentation,

Homework Content Scenario The administrator’s presentation, based on your briefing, was so well received by the board members that they asked to see a proposal for a hospital-based outpatient facility. In fact, the board suggested that the administrator ask you to take the lead in the project. Your administrator is

The CEO of a health care system has asked you, the system’s

The CEO of a health care system has asked you, the system’s strategic planner, to explain the factors they must consider when deciding the resources that should be devoted to a new facility project. List and describe the factors that determine the location, physical size, projected staffing, and effective décor

AMU HIMA 410 Hospital Data Modeling and Entity Relationship

A data model provides a view of how the data is structured throughout an organization. You’ve been provided with a set of data points from a local hospital. Instructions: Using the data points provided, create a model. Your data model should structure the data to support the business practices of

HIMA 360 AMU Encoder Selection for HIM Director Report

Case Scenario: Part 1: You are the HIM Director at Community General Hospital. As the director, you are in charge of purchasing an encoder for your 20 coders. You have identified the criteria that you will use to make the determination and put it in the grid below. Vendor 1

NUR 3846 BCC Deep Vein Thrombosis Questions

Using the video from Episode 2 on Samantha, answer the following prompts: Prompt 1: Explain in detail the pathogenesis of a DVT (Deep Vein Thrombosis) and how it can lead to a PE (Pulmonary Embolism). Prompt 2: Research and list all the possible treatment options for a DVT. Please correlate

MDC Key Elements of Psychiatric Assessment Discussion Reply

response to post: Discuss the Key elements of Psychiatric assessment and Interviewing of children. Assessing children and adolescents is challenging. A psychiatric assessment can determine if a child is experiencing a disorder or if there are other factors that may be causing their difficulties. Establishing rapport is the first and

MDC Conducting Psychiatric Assessments Discussion Reply

Respond to Ste: Discuss the Key Elements of Psychiatric Assessment and Interviewing of Children When conducting psychiatric assessments and interviewing of children, there are several important elements to consider. According to Sharma et al. (2019), creating a rapport is crucial to building a relationship of trust with children while encouraging

MDC Assessing Childrens Mental Health Discussion Reply

post response Mari: Assessing children and adolescents is challenging. Generally, the child/adolescent in question would not have initiated the consultation or may not be in agreement with the need for a consultation. The consultation may or may not even be sought for the most impairing problem at hand. While children

MU African American Counselors in Training Project

Task summary: You are to do Exploring clinical supervision with African American counselors in Training editing Full description: please write Exploring clinical supervision with African American counselors in Training You are a medical professor in charge of creating college assignments and answers for medical college students. You design and

Few people have not heard about the Food and Drug

Few people have not heard about the Food and Drug Administration (FDA). The COVID pandemic has placed a renewed focus on its role in assuring safety of drug approval. It is not nearly as well known that the FDA is tasked with regulating multiple categories of products. One cannot work in healthcare

MHA 543 UP Health & Medical Generational Work Trait

Work traits vary considerably between various generations. Each individual has a unique manner for interacting with others and solving problems or addressing issues that arise. In this assignment, you will address work trait differences and how these differences might impact the organizational culture and succession planning. Part I: Individual Work

Health & Medical Health Screening Tests Issues and Concerns

Describe what you already know about the module’s topics (if anything) With your limited understanding, how you would answer the module’s guiding question: “Do you think most people undergoing a screening test understand how to assess the benefits and risks of the test?” What other questions does the guiding question