Using an Excel spreadsheet, calculate all of the ratios listed in the problem 13 on ratio analysis “attached above” (13 ratios for each year or 26 total for 2 years).
Use your answers from the spreadsheet 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.