Complete below problem on ratio analysis on Financial Management of Health Care Organizations text by Zelman, McCue, Glick, and Thomas. Using an Excel spreadsheet, calculate all the ratios listed in the problem (13 ratios for each year or 26 total for 2 years).
Part Two
Use your answers from part one to complete the following:
Conduct a strategic assessment based on the health care data presented for Longwood Community Hospital.
Analyze the 26 financial ratios calculated for the hospital to state its financial position.
Develop a perspective on long-term financial trends for the hospital.
Assess the potential financial impact on the hospital’s organizational strategy and potential implications on patient care based on the benchmark data provided.
Write a 3–5-page paper based on the above.
Sample Solution
