AutoSave Home Insert Draw Page Layout Formulas Data Review View Tel 112 Ted And HOME 2010 PMC 2011 UN NE NIT LON WEE 1.6N e 133,434 THOPARS MEDIA CONTE BANOS 2015 5179,305 S.ON POMBALITY 855 87.7 May $160,650 . Pium 7,250 1.7 3,214 IN Tout ODNOM 442 35 NI $35.620 36 37 15.5 37 Dan 23.07 12:25 ROA 18 M 21,694 6.95 1 and we 1.71 54 23 Do 10.433 1.NO 3,344 23 $176,516 24Origicom 38,590 25 None came BONGOLOITTRATOS 26 Nincome 52323 0.0 DONC 28 MALANCETHGH PAINS MEDICAL CENTER 23 2013 30 and equivalent 31 Sharma 156 De Cache Hand 32 Ne 30.114 40N NEE NT NOT RELEE 23 196 543,503 WS NEODE ONEES NE 34 to 35 34 Amen Newport 30 40 OSETIT BETES DON 5. Need BIN 4.4 $10.00 40 41 42 Sas 44 45 96 TES SET 17.03. ANT MANAGEMENT RADOS 103 180 de 36 514 S26 11100 NOD 5.1 5.2 + Ready HW+5-1 V View Tell me H Trond Analysis Companive Analysis compare 2019 results with 2018 and explain if the mos improved or dedined and briefly why this could have occurred Compare HPMC 2019 with indusay wraps and explain how HPMC did compared to other comparable hospitals OY * 2x AutoSave AQE 5 HW-5-1 Home Insert Draw Page Layout Formulas Data Review View Tell me 40 G D Instructions: Using the Income Statement and Balance Sheet below, calculate each of the ratios below in the yellow cel. Use formulas to show your work total revenue $193,494 INCOME STATEMENT - HIGH PLAINS MEDICAL CENTER RATIOS Industry Averages 2019 HPMC 2019 HPMC 2018 4.18 4.9% 4.4% $179,305 9,655 $169,650 7,250 3.214 $180,114 S.OX PROFITARNITY 87.7% Total Margin 3.7% 1.7% 93.1% 0.0% Operating Margin 44.25 2.ON 3.0% LEX 7 8 Patient service revenue 9 Less: Provision for bad debts 10 Net patient service revenue 11 Premium revenue 12 other revenue 13 Total operating revenue 14 1s Nursing services 16 Dietary services 17 General services 18 Administrative services 19 Employee health and welfare 20 Malpractice insurance 21 Depreciation 22 Interest expense 23 Total expenses 24 Operating income 25 Nonoperating income 25 Net Income 27 28 BALANCE SHEET MIGH PLAINS MEDICAL CENTER $85,620 8,373 29, 307 23,674 13,375 5.5 X 37 1792 10,433 9.6% 6.4% BUN $176,516 $3,598 $3.725 $7.123 15.5% 12.2% ROA (return on assets) 6.9% 0.9 5.43 1.7% ROE return on equity 912% 193 193 3.8LIQUIDITY RATIOS DON 0.0% Current Ratio 10% 3.1% 2.6 15.6% Days Cash on Hand 2.3 2019 $6,011 4,997 122 23 30 Cash and equivalents 31 Short-term investments 32 Nintendent acts recen 5.1 Ready MacBook Air $ % AutoSave BESSE HW+5-1 Home Insert Draw Page Layout Formulas Data Review View Tell me 540 C D G Nonoperating income Net Income $3.725 $7,323 23 19 26135 122 23 8 BALANCE SHEET - HIGH PLAINS MEDICAL CENTER 29 30 Cash and equivalents 31 Short-term investments 32 Net patient accts receivable 33 Inventories 34 Total current assets 35 Gross plant and equipment 36 Accumulated depreciation 37 Net plant and equipment 38 Total Assets 2019 56,011 4,997 30,134 8.361 $49,503 195,047 111,750 $3,97 $132.800 3.8% LIQUIDITY RATIOS 0.0% 0.0%. Current Ratio 10% 3.1% 20% 15.6% Days Cachon Hand 4.3% 25.6% 100.8% 57.8% Debt Ratio 43.ON 6R 6N 0.0 5.25 Times Interest Eamed 3.15 2.7% 11. ON 17.05 ASSET MANAGEMENT RATIOS 1.0 18.0% Fixed Asset Turnover 327 33.7% 3.2 44 $10,015 5.16 5.250 $21.251 $32.956 1,935 $341 576663 $132.800 2.2 12 40 Accounts payable 41 Accrued expenses 42 Notes payable Total current liabilities 4 Long-term debit 45 Capital lease obligations 46 Total long-term abilities 47 Net assets equity 48 Total liabilities & equity 49 50 51 19 0.0% Total Asset Turnover 14 Days in Patient AR a SC 29 Average Age of Plant 6.2 Ready MacBook Air 888 F3 F4 AutoSave Home Insert Draw Page Layout Formulas Data Review View Tel 112 Ted And HOME 2010 PMC 2011 UN NE NIT LON WEE 1.6N e 133,434 THOPARS MEDIA CONTE BANOS 2015 5179,305 S.ON POMBALITY 855 87.7 May $160,650 . Pium 7,250 1.7 3,214 IN Tout ODNOM 442 35 NI $35.620 36 37 15.5 37 Dan 23.07 12:25 ROA 18 M 21,694 6.95 1 and we 1.71 54 23 Do 10.433 1.NO 3,344 23 $176,516 24Origicom 38,590 25 None came BONGOLOITTRATOS 26 Nincome 52323 0.0 DONC 28 MALANCETHGH PAINS MEDICAL CENTER 23 2013 30 and equivalent 31 Sharma 156 De Cache Hand 32 Ne 30.114 40N NEE NT NOT RELEE 23 196 543,503 WS NEODE ONEES NE 34 to 35 34 Amen Newport 30 40 OSETIT BETES DON 5. Need BIN 4.4 $10.00 40 41 42 Sas 44 45 96 TES SET 17.03. ANT MANAGEMENT RADOS 103 180 de 36 514 S26 11100 NOD 5.1 5.2 + Ready HW+5-1 V View Tell me H Trond Analysis Companive Analysis compare 2019 results with 2018 and explain if the mos improved or dedined and briefly why this could have occurred Compare HPMC 2019 with indusay wraps and explain how HPMC did compared to other comparable hospitals OY * 2x AutoSave AQE 5 HW-5-1 Home Insert Draw Page Layout Formulas Data Review View Tell me 40 G D Instructions: Using the Income Statement and Balance Sheet below, calculate each of the ratios below in the yellow cel. Use formulas to show your work total revenue $193,494 INCOME STATEMENT - HIGH PLAINS MEDICAL CENTER RATIOS Industry Averages 2019 HPMC 2019 HPMC 2018 4.18 4.9% 4.4% $179,305 9,655 $169,650 7,250 3.214 $180,114 S.OX PROFITARNITY 87.7% Total Margin 3.7% 1.7% 93.1% 0.0% Operating Margin 44.25 2.ON 3.0% LEX 7 8 Patient service revenue 9 Less: Provision for bad debts 10 Net patient service revenue 11 Premium revenue 12 other revenue 13 Total operating revenue 14 1s Nursing services 16 Dietary services 17 General services 18 Administrative services 19 Employee health and welfare 20 Malpractice insurance 21 Depreciation 22 Interest expense 23 Total expenses 24 Operating income 25 Nonoperating income 25 Net Income 27 28 BALANCE SHEET MIGH PLAINS MEDICAL CENTER $85,620 8,373 29, 307 23,674 13,375 5.5 X 37 1792 10,433 9.6% 6.4% BUN $176,516 $3,598 $3.725 $7.123 15.5% 12.2% ROA (return on assets) 6.9% 0.9 5.43 1.7% ROE return on equity 912% 193 193 3.8LIQUIDITY RATIOS DON 0.0% Current Ratio 10% 3.1% 2.6 15.6% Days Cash on Hand 2.3 2019 $6,011 4,997 122 23 30 Cash and equivalents 31 Short-term investments 32 Nintendent acts recen 5.1 Ready MacBook Air $ % AutoSave BESSE HW+5-1 Home Insert Draw Page Layout Formulas Data Review View Tell me 540 C D G Nonoperating income Net Income $3.725 $7,323 23 19 26135 122 23 8 BALANCE SHEET - HIGH PLAINS MEDICAL CENTER 29 30 Cash and equivalents 31 Short-term investments 32 Net patient accts receivable 33 Inventories 34 Total current assets 35 Gross plant and equipment 36 Accumulated depreciation 37 Net plant and equipment 38 Total Assets 2019 56,011 4,997 30,134 8.361 $49,503 195,047 111,750 $3,97 $132.800 3.8% LIQUIDITY RATIOS 0.0% 0.0%. Current Ratio 10% 3.1% 20% 15.6% Days Cachon Hand 4.3% 25.6% 100.8% 57.8% Debt Ratio 43.ON 6R 6N 0.0 5.25 Times Interest Eamed 3.15 2.7% 11. ON 17.05 ASSET MANAGEMENT RATIOS 1.0 18.0% Fixed Asset Turnover 327 33.7% 3.2 44 $10,015 5.16 5.250 $21.251 $32.956 1,935 $341 576663 $132.800 2.2 12 40 Accounts payable 41 Accrued expenses 42 Notes payable Total current liabilities 4 Long-term debit 45 Capital lease obligations 46 Total long-term abilities 47 Net assets equity 48 Total liabilities & equity 49 50 51 19 0.0% Total Asset Turnover 14 Days in Patient AR a SC 29 Average Age of Plant 6.2 Ready MacBook Air 888 F3 F4