PLEASE DO THE CALCULATIONS IN EXCEL. PLEASE SHOW WORK.

A B D E F G 4 Calculate the following ratios for Snowflake Regional Hospital 5 INCOME STATEMENT - SNOWFLAKE REGIONAL HOSPITAL 2020 6 Patient service revenue $164,500 7 Less: Provision for bad debts 10,500 Net patient service revenue $154,000 9 Premium revenue 7,250 10 Other revenue 4,850 11 Total operating revenue $166,100 PROFITABILITY Total Margin 8 Operating Margin 12 ROA (return on assets) LIQUIDITY RATIOS Current Ratio Days Cash on Hand 13 Nursing services $78,550 14 Dietary services 7,825 15 General services 27,950 16 Administrative services 22,125 17 Employee health and welfare 12,500 18 Malpractice insurance 1,675 19 Depreciation 9,750 20 Interest expense 3,125 21 Total expenses $163,500 22 Operating income $2,600 23 Nonoperating income $4,825 24 Net income $7,425 25 26 BALANCE SHEET - SNOWFLAKE REGIONAL HOSPITAL 27 2020 28 Cash and equivalents $5,820 29 Short-term investments 5,275 30 Net patient accts receivable 29,650 31 Inventories 8,125 32 Total current assets $48,870 33 Gross plant and equipment 185,125 34 Accumulated depreciation 59,750 35 Net plant and equipment $125,375 36 Total Assets $174,245 37 38 Accounts payable $9,375 39 Accrued expenses 6,855 40 Notes payable 5,250 41 Total current liabilities $21,480 42 Long-term debt $33,125 43 Capital lease obligations 1,925 ILLIULUI Debt Ratio ASSET MANAGEMENT RATIOS Fixed Asset Turnover Total Asset Turnover Days in Patient AR