signature assignment. please follow the instructions and rubric.
dream86
RatiosTable-Example.docx
Table 1: 3-Year Financial and Operating Ratios with Benchmarks
|
|
HOSPITAL A |
|
HOSPITAL B |
|
BENCHMARKS* |
||||||
|
|
2020 |
2021 |
2022 |
% chg |
2020 |
2021 |
2022 |
% chg |
2020 |
2021 |
2022 |
|
Top Line Indicators |
|
|
|
|
|
|
|
|
|
|
|
|
Total Patient Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
Total Discharges |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
FINANCIAL RATIOS |
|
|
|
|
|
|
|
|
|
|
|
|
Total Operating Margin |
|
|
|
|
|
|
|
|
|
|
|
|
Return on Total Assets |
|
|
|
|
|
|
|
|
|
|
|
|
Current Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
Days in Accounts Rec’bl |
|
|
|
|
|
|
|
|
|
|
|
|
Debt to Equity Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPERATING RATIOS |
|
|
|
|
|
|
|
|
|
|
|
|
Profit per discharge |
|
|
|
|
|
|
|
|
|
|
|
|
Avg Length of Stay |
|
|
|
|
|
|
|
|
|
|
|
|
Occupancy Rate |
|
|
|
|
|
|
|
|
|
|
|
|
Case Mix Index |
|
|
|
|
|
|
|
|
|
|
|
|
FTEs per Adj Occ Bed |
|
|
|
|
|
|
|
|
|
|
|
Source: https://data.chhs.ca.gov/
* https://data.chhs.ca.gov/dataset/hospital-annual-financial-data-selected-data-pivot-tables
