Ratio Analysis

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.