55 NETI VIUI H C BestCare Income Statement BestCare Sector Average 17.4% Calucate the following ratios and compare to the sector average Ratio Formula Total Margin Net Income Total Revenues Return on assets (ROA) Net income/Total assets Revenue Healthcare premiums Fees and other revenue Net investment income Total revenues 32% $ 32,450 $ 3,400 $ 420 $ 36,270 Current ratio Current assets/Current abilities 69% Total liabilities/Total assets Debt ratio Benefits and expenses Healthcare costs $ 18,200 Operating expenses Selling expenses $ 5,200 General and administrative expens 8.400 2.2 Total liabilties/Total equity Debt-to-equity ratio IS Bestare performing well compared to the sector average? Please indicate 'Yes' or 'No'. Interest expense Total expenses Net Income $ 448 $ 32,248 $ 4,022 BestCare Balance Sheet ASSETS Cash and cash equivalents Net premiums receivable Other current assets Total current assets Long-term investments Net property and equipment Total assets 5 3,542 S 1,022 $ 474 S 5,038 $ 6,542 $ 2,700 $ 14,280 LIABILITIES AND EQUITY Healthcare costs payable Accrued expenses Unearned premiums Total current liabilities Long-term debt Total $ 3,252 $ 1,021 $ 640 $ 4,913 S $440 $ 10,353 Attached are the balance sheet and income statement for BestCare which is a for-profit nursing home. Please use the information in the balance sheet and the income statement to calculate the ratios listed in the table. Is BestCare performing well compared to the sector average? Please show your work in Excel. Please make sure that we can see the formula that you have used and that your file is uploaded correctly into Canvas. Case Report 4 Q10 Fall 2020 Question-1.xlsx