Calculate each of the ratios & provide a ratio analysis please & thank you!!
For each ratio, provide a brief ratio analysis, trend analysis and comparative analysis. | |
Indicator Analysis: | Briefly explain what the indicator means |
Comparative Analysis | Compare WTRH 2017 with industry averages and explain how WTRH did compared to other comparable hospitals. |
Pic 1 is the data, pic 2&3 is the assignment/question
Instructions: for each ratio, Provide a brief indicator analysis and comparative analysis.
File Edit View 75% Insert Format Data Tools Add-ons Help - $ % ... .00 123 - Default (Ca. n Last edit was 12 minutes ago 11 B I & A 2. - - - instructions: Using the income statement and Balance Sheet below, calculate each of the ratios below in the yellow cell. Use formulas to show your work. For each ratio, provide a brief ratio analysis, trend analysis and comparative analysis. Indicator Analysis: Briefly explain what the Indicator means Comparative Analysis Compare WTRH 2017 with industry averages and explain how WTRH did compared to other comparable hospitals WEST TEXAS REGIONAL HOSPITAL OPERATING DATA Net inpatient revenue Net outpatient revenue Net patient service revenue Inpatient operating expenses Total salaries Total discharges Inpatient days 14 licensed and staffed beds Average daily census 16 Total FTES 17 Inpatient FTES 2017 $36.200.000 $67,850,000 $104 050.000 $30,825.000 $31,050,000 5.925 34.575 1.025 575 OPERATING INDICATOR ANALYSIS WTRH2012 Industry Averate indicator Anal Profit per Discharge 5.2 + 5.1 $ 2.00 123- Default (Co., 11BIGA - E L - ... OPERATING INDICATOR ANALYSIS WTRH 2017 industry Average $785 Profit per Discharge Intent profis Total discharges Indicator Analysis Comparative Analysis $5.70 Net Price per Discharge Netinu Total discharges Int Analysis Comparative Analysis Outpatient Reves Nettotieteenue Net patient service revenue Occupany Rate Licensed beds x calendar days Average length of Stay piendin Total discharges ONI 7 7 5 - $ % 0 .00 123- Default (Ca.. 11 - BI&A - EUR- Net patient service revenue Occupany Rate Inpatient days cerved beds calendar days Indicator Analysis Comparative Analysis Average length of Stay Troatients Total discharges Indicator Analysis Comparative Analysis Inpatients per Occupied led roatient ETES Average daily census Indicator Analys Comparative Analysis Salary per FTE Indicator Analysis Comparative Analysis TOFTES hp instructions: Using the income Statement and Balance Sheet below, calculate each of the ratios below in the yellow cell. Use formulas to show your work. in WEST TEXAS REGIONAL HOSPITAL OPERATING DATA Net inpatient revenue Net outpatient revenue Net patient service revenue Inpatient operating expenses Total salaries 12 Total discharges 13 Inpatient days # licensed and staffed beds 15 Average daily census Total FTES 17 Inpatient FTES 2017 $36,200,000 $67,850,000 $104,050,000 $30,825,000 $31,050,000 5,925 34,575 200 95 1,025 575 16 20 OPERATING INDICATOR ANALYSIS WTRH 2017 A O 75% $ % .0 .00 123~ Default (Ca... - 11 B A B C OPERATING INDICATOR ANALYSIS WTRH 2017 Industry Average Profit per Discharge $785 Indicator Analysis Comparative Analysis Inpatient profit Total discharges $5,750 Net Price per Discharge Net inpatient revenue Total discharges Indicator Analysis Comparative Analysis Outpatient Revenue % Net outpatient revenue Net patient service revenue Indicator Analysis Comparative Analysis 49.2% Occupany Rate Inpatient days # Licensed beds x calendar days Indicator Analysis Comparative Analysis Average Length of Stay Inpatient days Total discharges Indicator Analysis Comparative Analysis 5.1 5.2 Net patient service revenue 49,2% Occupany Rate Inpatient days # Licensed beds x calendar days Indicator Analysis Comparative Analysis Average Length of Stay Inpatient days Total discharges Indicator Analysis Comparative Analysis Inpatient FTEs per Occupied Bed Inpatient FTES Average daily census Indicator Analysis Comparative Analysis Salary per FTE $32,987 Indicator Analysis Comparative Analysis Total salaries Total FTES 8986 + 5.1 5.2