please answer all parts to question 2

calculate the table the metrics table

Problem 2 Recent financial statements for Laredo Hospital and other operating data are provided below: Balance Sheet Cash and equivalents Net patient accounts receivable Medical supplies inventory Prepaid expenses Other current assets Total current assets Property, plant, and equipment Accumulated Depreciation Net property, plant, and equipment TOTAL ASSETS Accounts payable Accrued expenses Other current liabilities Total current liabilities Long-term debt TOTAL LIABILITIES NET ASSETS TOTAL LIABILITIES AND NET ASSETS 505,509 685,425 69,831 84,524 493,179 1,838,468 6,802,886 (799,440) 6,003,446 7,841,914 557,284 275,099 535,556 1,367,939 2,251,327 3,619,266 4,222,648 7,841,914 AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEt AaB Normal No Spacing Heading 1 Heading 2 Title Statement of Operations Patient service revenue Provision for bad debt Net patient service revenue 5,447,402 (57400) 5,390,002 Salaries and benefits Medical supplies expense Other operating expenses Depreciation expense Interest expense Total expenses Net income 2,302,399 1,350,708 1,163,315 190,293 121,824 5,128,539 261,463 Other Information Inpatient days Number of licensed beds Total discharges 262,800 1,200 52,560 Calculate the following metrics (complete the table): Ratio Return on assets (ROA) Industry Average 7.0% Evaluation Type your ROA evaluation here Current ratio 2.0 Type your current ratio evaluation here Days cash on hand 36 days Type your days cash on hand evaluation here 60 days Type your ACP evaluation here Days in Patient Accounts Receivable (ACP) Debt ratio 45% Type your debt ratio evaluation here Fixed asset turnover ratio 2.2 Total margin Type your fixed asset turnover evaluation here Type your total margin evaluation here 6.0% Total asset turnover 1 Equity multiplier Type your total asset turnover evaluation here Type your equity multiplier evaluation here 1.7 Return on equity (ROE) 10.2% Type your return on equity evaluation here Occupancy rate 60.0% Type your occupancy rate evaluation here Average length of stay 5 days Type your average length of stay evaluation here