*please show work (equations), preferably in excel and compare each ratio with the industry average. Thank you!!*

1. Financial Ratio Analysis Using the data from the attached financial statements for West Texas Regional Hospital (WTRH), calculate the following ratios, then, interpret and briefly explain a trend analysis (compare current to prior year) and a comparative analysis (compare to industry averages) for each ratio. Be sure to show how you obtained your calculations. RATIOS Total Margin Operating Margin Return on Assets (ROA) Return on Equity (ROE) Current Ratio Days Cash on Hand Debt Ratio Times Interest Earned Fixed Asset Turnover Total Asset Turnover Days in Patient A/R Average Age of Plant WTRH 2016 WTRH 2015 Industry Averages 5.3 3.6 4.9 8.3 2.0 31.5 41.8 4.0 2.1 0.98 68.0 9.1