Did I do the first yellow part right and how do I do the 2 and 3? Problem 3 1. Grading Grade: out of (max): 1) Develop the Horizontal Analysis of the statements below Amount Inc Dec) Percent 97 81 (80) Cash Temporary Investments Receivables. patents.net Inventory Prepaid expenses Total current assets Long-term investments Plantassets.net Omer assets Total December 31 20x2 20%. AMAD Amen 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 24 (13) 109 67 802 32 1,010 105% 46.3% -9.0% 63% -20.0% 45% 73% 9.7% 10.3% 8.5% Current portion of long-term debt Notes payable Accounts payable Accrued expenses payable Payroll taxes withheld Advances from third-party payers Omer Total current tables Long-term debt Total Liabilities netassets Total 596 185 141 192 84 65 98 1,361 2014 3,375 9558 12.933 245 92 101 156 85 52 46 351 93 40 36 (1) 13 52 584 160 744 256 1,010 143.3% 101.1% 39.6% 23.1% -12% 25.0% 113.0% 752% 8.6% 28.3% 2.9% 8.5% 777 1.854 2,531 9292 11.923 Year ended 1231 20X2 20 X 11.374 11245 1878 1821 9496 9A24 897 956 10,393 10,380 129 57 72 (59 13 1.1% 3.1% 0.8% -6.2% 0.1% Gross patientservices revenues Deductions from patientservices revenues Net patient services revenues Other operating revenues Total operating revenues Less Operating expenses Nursing services Oher professional services Administrave services Depreciation Interest Expense Insurance Expense Supplies Total operating expenses Operating income foss) Nonoperating revenues.net Excess of revenues over expenses (loss) for the year 3.159 2456 1,557 788 168 950 310 9388 1,005 50 1.055 3,122 2325 1.445 722 154 958 576 9,302 1,078 10 1082 37 131 112 66 14 (8) (266) 86 (73) 40 (33) 12% 5.6% 78% 9.1% 9.1% -0.8% -46.2% 0.9% -6.8% 400.0% -30% Directy reference the cels aboven an Excel formula 2) Prepare a ratio analysis of the 20x9 operating results: Operating income rato Operating expense rato Return on Netasses Rournon Assets Times interestearned Directy reference the cols above in an Excel formula ne 3) Prepare a ratio analysis of the 20 Xe financial position: Currentrato Quick rato Currentassotturnover Receivables turnover (Use Average of20x9 & 20XBAR) Number ofdays' charges uncollected Inventory urnover (Use Average of 20X9 & 20 inventory) ( Average number of days' supply Debtrato Netassetrato Did I do the first yellow part right and how do I do the 2 and 3? Problem 3 1. Grading Grade: out of (max): 1) Develop the Horizontal Analysis of the statements below Amount Inc Dec) Percent 97 81 (80) Cash Temporary Investments Receivables. patents.net Inventory Prepaid expenses Total current assets Long-term investments Plantassets.net Omer assets Total December 31 20x2 20%. AMAD Amen 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 24 (13) 109 67 802 32 1,010 105% 46.3% -9.0% 63% -20.0% 45% 73% 9.7% 10.3% 8.5% Current portion of long-term debt Notes payable Accounts payable Accrued expenses payable Payroll taxes withheld Advances from third-party payers Omer Total current tables Long-term debt Total Liabilities netassets Total 596 185 141 192 84 65 98 1,361 2014 3,375 9558 12.933 245 92 101 156 85 52 46 351 93 40 36 (1) 13 52 584 160 744 256 1,010 143.3% 101.1% 39.6% 23.1% -12% 25.0% 113.0% 752% 8.6% 28.3% 2.9% 8.5% 777 1.854 2,531 9292 11.923 Year ended 1231 20X2 20 X 11.374 11245 1878 1821 9496 9A24 897 956 10,393 10,380 129 57 72 (59 13 1.1% 3.1% 0.8% -6.2% 0.1% Gross patientservices revenues Deductions from patientservices revenues Net patient services revenues Other operating revenues Total operating revenues Less Operating expenses Nursing services Oher professional services Administrave services Depreciation Interest Expense Insurance Expense Supplies Total operating expenses Operating income foss) Nonoperating revenues.net Excess of revenues over expenses (loss) for the year 3.159 2456 1,557 788 168 950 310 9388 1,005 50 1.055 3,122 2325 1.445 722 154 958 576 9,302 1,078 10 1082 37 131 112 66 14 (8) (266) 86 (73) 40 (33) 12% 5.6% 78% 9.1% 9.1% -0.8% -46.2% 0.9% -6.8% 400.0% -30% Directy reference the cels aboven an Excel formula 2) Prepare a ratio analysis of the 20x9 operating results: Operating income rato Operating expense rato Return on Netasses Rournon Assets Times interestearned Directy reference the cols above in an Excel formula ne 3) Prepare a ratio analysis of the 20 Xe financial position: Currentrato Quick rato Currentassotturnover Receivables turnover (Use Average of20x9 & 20XBAR) Number ofdays' charges uncollected Inventory urnover (Use Average of 20X9 & 20 inventory) ( Average number of days' supply Debtrato Netassetrato