Nonprofit healthcare viability horizontal vertical analysis
Not what you're looking for?
Source of Revenue: Viability
Use the balance sheet and statement of income you downloaded for Ascension Health a nonprofit, religious-based healthcare system, from
http://www.ascensionhealth.org/index.php?option=com_content&view=article
&id=45&Itemid=160.
Download and review the financial statements of HCA, Inc., a for-profit healthcare system, fromhttp://phx.corporate-ir.net/phoenix.zhtml?c=63489&p=irol-reports.
In a Microsoft Excel spreadsheet, prepare a vertical analysis of the company for the years 2012 and 2013 and a horizontal analysis from 2012 (base year) to 2013 (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?
Purchase this Solution
Solution Summary
Your spreadsheet shows subtotals from the balance sheet and income statement for 2012 and 2013 with vertical and horizontal analysis. The discussion is 343 words and briefly examines the large shifts over the two year period.
Solution Preview
Is Ascension Health growing?
Yes, their revenue, assets and net assets are all growing in double digits (over 10%). Their expenses are also growing. Doubtful accounts are growing almost twice as fast as revenues but a large contribution ($2,012,963) in 2013 more than offset the growth in doubtful accounts. Without this large one-time donation, Ascension is still growing but not at the rate that the bottom line would indicate.
HCA is also growth in at similar rates for revenue and slower rates for assets and equity. Their doubtful
Accounts are growing ...
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce