I also need to know how to do these correctly so I can study for the test. Thank you so much in advance (:

HCM 3570 Principles of Financial Management for Health Care Homework #4 Fall 2017 Name: Financial Statement Analysis 1. Given the balance sheet and income statement on the accompanying spreadsheet, calculate the following ratios: 2011 2012 2013 2014 Current Ratio Days Cash on Hand Days in A/R Debt Ratio Debt to Equity Times Interest Earned Cash Flow Coverage Total Asset Turnover Fixed Asset Turnover Total Margin Return on Equity 2. Explain the calculated results, why did the ratio increase or decrease, for the following ratios: 1) Days Cash on Hand 2) Times Interest Earned 3) Total Asset Turnover 3. Create four run charts for 1) profitability including total margin, ROE, and ROA, 2) turnover ratios including TAT, CAT, and FAT, 3) days in AR, and 4) debt to equity ratio. 4. Comment on the change in the financial condition of this organization based on your analysis and provide any specific operating recommendations, as needed, to improve it's financial performance. HCM 3570 Principles of Financial Management for Health Care Homework #4 Fall 2017 Name: Financial Statement Analysis 1. Given the balance sheet and income statement on the accompanying spreadsheet, calculate the following ratios: 2011 2012 2013 2014 Current Ratio Days Cash on Hand Days in A/R Debt Ratio Debt to Equity Times Interest Earned Cash Flow Coverage Total Asset Turnover Fixed Asset Turnover Total Margin Return on Equity 2. Explain the calculated results, why did the ratio increase or decrease, for the following ratios: 1) Days Cash on Hand 2) Times Interest Earned 3) Total Asset Turnover 3. Create four run charts for 1) profitability including total margin, ROE, and ROA, 2) turnover ratios including TAT, CAT, and FAT, 3) days in AR, and 4) debt to equity ratio. 4. Comment on the change in the financial condition of this organization based on your analysis and provide any specific operating recommendations, as needed, to improve it's financial performance