Complete the vertical and horizontal analysis, as instructed in the spreadsheet, for the balance sheet and the income statement. (b) Review the operating indicators and indicate in the blank cells if the comparisons are better or worse. 2. Then reviewing all of the three types of analyses (vertical/horizontal, financial ratio analysis, and operating indicators) and the other relevant data in the spreadsheet (excluding the ROE strategies referenced starting at row 203), prepare a financial report (in a MS Word document) covering the following key elements: (a) Summarize your findings relative to the vertical and horizontal analysis for both the incomes statement and balance sheet, the financial ratio analysis (addressing profitability, liquidity, asset management, and debt management), and any significant findings from the operating indicator analysis. Indicate possible causes for some of your findings. (b) Briefly, describe at least 3 strengths and 3 weaknesses of this hospitals financial situation as identified from your analysis. (c) Describe recommendations for improvements and/or areas you would investigate further.
