how do you calculate days in patient AR and Acerage Age of Plant

AutoSave OT RESU 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 3.8% LIQUIDITY RATIOS 0.0% 0.0%. Current Ratio 23 2.0 19 1.0 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 $6,011 4,97 30,134 8.361 $49,503 195,047 111.750 $83,297 $132,800 42 32.7% 33 3.1% 26% 15.6% Days Cash on Hand 4.3% 25.6 100.8% 57.8% Debt Ratio 43.0 6R 6N DON 5.25 Times interest Eamed 3.15 2.79 110% 17.0% ASSET MANAGEMENT RATIOS 1.0 18.0% Fred Asset Turnover 3.2 44 4.4 $10,015 5. 5.250 2.3 12 19 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 abilities & equity 49 50 51 $32.956 1.925 $341 $76668 $132.00 0.0% Total Asset Turnover 14 Days in Patients SU Average Age of Man 5.1 Ready MacBook Air 30 888 F3 F AutoSave BE 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 $179,305 9,655 4.18 4.9% 4.4% $169,650 7,250 3.214 $180,114 2.ON 3.0% LEX X 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 15 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 - HIGH PLAINS MEDICAL CENTER 5.5 37 $85,620 8,373 29,907 23,674 13,375 S.OX PROFITARNITY 87.7% Total Margin 3.7% 1.7% 9.15 0.0% Operating Margin 44.25 4.3% 15.5 12.2% ROA (return on assets 6.9% 09N 5.4% 1.7% ROE return on equity 912% 19% 19 38% LIQUIDITY RATIOS 0.0% 0.0% Current Ratio 10% 3.1% 2. 15.6% Days Cash on Hand 10,433 9.6% 6.4% UN $176,516 $3,598 $3.725 57123 2.0 2019 $6,011 4,997 26135 23 30 Cash and equivalents 31 Short-term investments 32 vistient acets recen 5.1 Ready MacBook Air 30 F2 go 13 F5 # $ % AutoSave OT RESU 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 3.8% LIQUIDITY RATIOS 0.0% 0.0%. Current Ratio 23 2.0 19 1.0 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 $6,011 4,97 30,134 8.361 $49,503 195,047 111.750 $83,297 $132,800 42 32.7% 33 3.1% 26% 15.6% Days Cash on Hand 4.3% 25.6 100.8% 57.8% Debt Ratio 43.0 6R 6N DON 5.25 Times interest Eamed 3.15 2.79 110% 17.0% ASSET MANAGEMENT RATIOS 1.0 18.0% Fred Asset Turnover 3.2 44 4.4 $10,015 5. 5.250 2.3 12 19 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 abilities & equity 49 50 51 $32.956 1.925 $341 $76668 $132.00 0.0% Total Asset Turnover 14 Days in Patients SU Average Age of Man 5.1 Ready MacBook Air 30 888 F3 F AutoSave BE 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 $179,305 9,655 4.18 4.9% 4.4% $169,650 7,250 3.214 $180,114 2.ON 3.0% LEX X 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 15 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 - HIGH PLAINS MEDICAL CENTER 5.5 37 $85,620 8,373 29,907 23,674 13,375 S.OX PROFITARNITY 87.7% Total Margin 3.7% 1.7% 9.15 0.0% Operating Margin 44.25 4.3% 15.5 12.2% ROA (return on assets 6.9% 09N 5.4% 1.7% ROE return on equity 912% 19% 19 38% LIQUIDITY RATIOS 0.0% 0.0% Current Ratio 10% 3.1% 2. 15.6% Days Cash on Hand 10,433 9.6% 6.4% UN $176,516 $3,598 $3.725 57123 2.0 2019 $6,011 4,997 26135 23 30 Cash and equivalents 31 Short-term investments 32 vistient acets recen 5.1 Ready MacBook Air 30 F2 go 13 F5 # $ %