Need assistance with the below assignment.

1. Use The University of Texas Medical System competing companys ratio analysis for the most current year as the benchmark standard in place of an industry standard.

2. Complete a financial and operational ratio analysis in the format and content as presented in the financial analysis Excel template, as described below. This is the minimal ratio analysis to be conducted; you may add further analysis if you desire. Compare (benchmark) your hospitals financial and operational ratio analysis to that of your competitor. You may use the Excel template to calculate the ratios, or create a new spreadsheet or calculate by hand; however, for your report, please present the findings using the financial analysis Excel template provided below. If there are data points you are unable to locate because they are not available, notify me. With my approval, you may be permitted to skip those ratios.

3. Complete a vertical and horizontal analysis on the 2 most recent years of your organizations financial statements (income statement and balance sheet). This analysis is not required for the competitor.

4. Interpret the financial and operational analysis findings in a narrative. For the financial analysis findings, your interpretation should be grouped by the four main categories: profitability, liquidity, asset management, and debt management. Also, include your interpretations of the change in cash flows and the Du Pont analysis. A significant portion of your grade depends upon your interpretation, so spend extra time on this portion.

5. As part of your final paper, include the Excel spreadsheets from which you completed your analysis. You may also submit handwritten work supporting your analysis, but your documents must be scanned into electronic files.

6. Based upon the prior data and model, assess the healthcare organizations revenue cycle management and forecast its reimbursement performance.