Question
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
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.Ratio Analysis:Briefly explain what the ratio meansTrend AnalysisCompare 2019 results with 2018 and explain if the ratios improved or declined and briefly why this could have occurredtotal revenue$193,494Comparative AnalysisCompare HPMC 2019 with industry averages and explain how HPMC did compared to other comparable hospitals.INCOME STATEMENT - HIGH PLAINS MEDICAL CENTERRATIOS2019HPMC 2019HPMC 2018Industry AveragesPatient service revenue$179,3055.0%PROFITABILITYLess: Provision for bad debts9,65587.7%Total Margin4.1%4.9%4.4%Net patient service revenue$169,6503.7%Premium revenue7,2501.7%Other revenue3,21493.1%Total operating revenue$180,1140.0%Operating Margin2.0%3.0%1.6%44.2%Nursing services$85,6204.3%Dietary services8,37315.5%General services29,90712.2%ROA (return on assets)5.5%4.8%3.7%Administrative services23,6746.9%Employee health and welfare13,3750.9%Malpractice insurance1,7925.4%Depreciation10,4331.7%ROE (return on equity)9.6%6.4%8.3%Interest expense3,34491.2%Total expenses$176,5161.9%Operating income$3,5981.9%Nonoperating income$3,7253.8%LIQUIDITY RATIOSNet income$7,3230.0%0.0%Current Ratio2.32.01.9BALANCE SHEET - HIGH PLAINS MEDICAL CENTER1.0%20193.1%Cash and equivalents$6,0112.6%26135%Short-term investments4,99715.6%Days Cash on Hand12.22329.9Net patient accts receivable30,1344.3%Inventories8,36125.6%Total current assets$49,503100.8%Gross plant and equipment195,04757.8%Debt Ratio42.3%32.7%33.7%Accumulated depreciation111,75043.0%Net plant and equipment$83,29768.6%Total Assets$132,8000.0%5.2%Times Interest Earned3.24.44.4Accounts payable$10,0153.1%Accrued expenses5,9862.7%Notes payable5,25011.0%Total current liabilities$21,25117.0%ASSET MANAGEMENT RATIOSLong-term debt$32,9561.0%Capital lease obligations1,92518.0%Fixed Asset Turnover2.21.21.9Total long-term liabilities$34,88139.6%Net assets (equity)$76,66868.6%Total liabilities & equity$132,8000.0%Total Asset Turnover1.40.90.8Days in Patient AR14,006,118.159.047.5Average Age of Plant18.79.911.5Days in Patient AR =Net Patient AR / (Net patient rev / 365)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started