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. INCOME STATEMENT-WEST TEXAS REGIONAL HOSPITAL RATIOS 2017 WTRH 2017 WTRH 2016 Average Patient service sevenue Less: Provision for bad debts 10,500 154,000 7,250 4,850 166,100 Total Margin Net patient service revenue Premium revenve Other revenue Total operating revenac Operating Margin 15% Nursiag services Dictary servikes General services Administrative services Employee bealth and welfare Malpractice insurance Depreciation Interest expense $78,550 7,825 27.950 22,125 12.500 1,673 9,750 ROA (return on assets) 149% 49% ROE (return on equity) TTA% 85% Total expenses Operating income Nonogerating income Nct income $2.600 $4.825 $7,425 LIQUIDITY RATIOS Current Ratio BALANCE SHEET-WEST TEXAS REGIONAL HOSPITAL 2017 Cash and equivalents Short-term investments Nct .275 29.650 Days Cash on Hand patient accts receivable Inventorics Total current assets Gross plant and equipment Accumulated depreciation Debt Ratio $9.730 Net plant and eqaipment Total Assets Times Interest Eareed Accounts payable Accrued expenses Notes payable $9.375 6,855 .250 Total current liabilities Long-term debt Capital lcase obligations ASSET MANAGEMENT RATIoS .925 $35,050 Fixed Asset Turnover Total long.torm liabilitics Nct assets (oquity) Toal liabilities & equity Total Asset Tureover Days in Paticnt AR Average Age ef Plant 6 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. INCOME STATEMENT-WEST TEXAS REGIONAL HOSPITAL RATIOS 2017 WTRH 2017 WTRH 2016 Average Patient service sevenue Less: Provision for bad debts 10,500 154,000 7,250 4,850 166,100 Total Margin Net patient service revenue Premium revenve Other revenue Total operating revenac Operating Margin 15% Nursiag services Dictary servikes General services Administrative services Employee bealth and welfare Malpractice insurance Depreciation Interest expense $78,550 7,825 27.950 22,125 12.500 1,673 9,750 ROA (return on assets) 149% 49% ROE (return on equity) TTA% 85% Total expenses Operating income Nonogerating income Nct income $2.600 $4.825 $7,425 LIQUIDITY RATIOS Current Ratio BALANCE SHEET-WEST TEXAS REGIONAL HOSPITAL 2017 Cash and equivalents Short-term investments Nct .275 29.650 Days Cash on Hand patient accts receivable Inventorics Total current assets Gross plant and equipment Accumulated depreciation Debt Ratio $9.730 Net plant and eqaipment Total Assets Times Interest Eareed Accounts payable Accrued expenses Notes payable $9.375 6,855 .250 Total current liabilities Long-term debt Capital lcase obligations ASSET MANAGEMENT RATIoS .925 $35,050 Fixed Asset Turnover Total long.torm liabilitics Nct assets (oquity) Toal liabilities & equity Total Asset Tureover Days in Paticnt AR Average Age ef Plant 6
