Grade: : out of (max): 1) Develop the Horizontal Analysis of the statements below. . 8 Amount Incl(Dec) Percent " Cash Temporary investments Receivables - patients, net - Inventory Prepaid expenses Total current assets Long-term investments Plant assets, net Other assets Total December 31 20x9 20XB Amount Amount 1,022 925 256 175 812 892 402 378 52 65 2,544 2,435 989 922 9,056 8.254 344 312 12.933 11,923 ble toho *$ 688 Current portion of long-term debt Notes payable Accounts payable Accrued expenses payable Payroll taxes withheld Advances from third-party payers - Other Total current liabilities Long-term debt Total Liabilities net assets 596 185 141 192 84 65 98 1,361 2014 3,375 9,558 12933 1.854 2,631 9,292 11,923 Total Year ended 12/31 20x9 20x8 11,374 11,245 1,878 1.821 9,496 9,424 897 956 10,393 10,380 Gross patient services revenues Deductions from patient services revenues Net patient services revenues Other operating revenues Total operating revenues Less Operating expenses: Nursing services Other professional services Administrative services Depreciation Interest Expense Insurance Expense Supplies Total operating expenses Operating income (loss) Nonoperating revenues, net Excess of revenues over expenses (loss) for the year 3.159 2,456 1,557 788 168 950 310 9,388 1,005 50 1,055 3.122 2,325 1,445 722 154 958 576 9.302 1,078 10 1,088 Directly reference the cells above in an Excel formula 2) Prepare a ratio analysis of the 20x9 operating results: Operating income ratio Operating expense ratio Return on Net assets Return on Assets Times interest earned Directly reference the cells above in an Excel formula 3) Prepare a ratio analysis of the 20x9 financial position: Current ratio Quick ratio Current asset turnover Receivables turnover (Use Average of 20x9 & 20X8 A/R) Number of days' charges uncollected Inventory turnover (Use Average of 20x9 & 20x8 inventory) Average number of days' supply Debt ratio Net asset ratio