Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles Part 3

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Kinnear, Joan E. Barlow

6th Canadian edition Volume 1

1118306805, 978-1118306802

More Books

Students also viewed these Finance questions