Hi I want someone to do the activity ratio based on a hospital report. I provide sample, you can look at it to see what I am looking for.

In order to understand Newman Regional Health’s financial performance, we reviewed the institutions financial statement and conducted a financial ratio analysis. The quantitative data analyzed was obtained from Newman Regional Health’s financial statements ending December 31 for the years 2017 and 2016. Each calculation is interpreted by comparing the calculated ratio to the industry benchmark (which indicates the organization’s desired level of performance). Since Newman Regional Health contains 25 beds, the selected benchmark is for U.S. hospitals with a bed size ranging from 1 to 99 beds. Below is our summary of the organization and its performance (current and future).

Newman Regional Health History and Overview:

George Newman, along with funding from a two-year tax levy raised by the community funded Newman Regional Health. Newman’s generous contribution of $50,000 and the counties efforts, led to the grand opening of the facility on March 6th, 1922 [1].

This governmental entity is owned by Lyon County and located in Emporia, Kansas. Originally, the institution was an 81-bed not-for-profit hospital, but today it is recognized as the “largest and most clinically capable access hospital in Kansas” [1].

Services Provided:
Newman Regional Health is a 25 bed critical access hospital that provides emergency medical, level IV trauma, surgical, obstetrical care, 24 hours a day to more than 7 counties in east central Kansas [3]. Over the years, the facility expanded into a teaching hospital that provides a variety of services including: primary care, inpatient and outpatient services, pharmacy, rehabilitation, home/hospice care and numerous specialty services to meet the communities needs [2].

Facilities and Locations:

Newman Regional Health is owned by Lyon County and located on 1201 W. 12th Avenue Emporia, Kansas. Since 1996, the organization renovated and expanded the institution by adding a medical plaza, cardiovascular lab, cancer centers and a same day surgery center [1]. The organization also invested in an emergency room expansion and software upgrade to improve performance and enhance their patient’s experience.

Financial Ratio Analysis

Liquidity ratios
1. Current Ratio - Total Beds: 47 *Formula: Current Assets / Current Liabilities	2015: 2.95	2016: 2.69
Comment: The HCIA/HCFA standard is 2.18 for a 1-99 bed hospital. The ratio decreased from 2015 to 2016. Both values are higher than the standard, which suggest that as the institutions assets increase, so do the liabilities. As a result, there is improvement in liquidity and the organization is within a desired position.
2. Quick ratio - Total Beds: 47 *Formula: [(Cash + Marketable Securities + Net Receivables) / Current Liabilities]	2015: 2.59	2016: 2.29
Comment: The HCIA/HCFA standard is 1.65 for a 1-99 bed hospital. The ratio decreased from 2015 to 2016. Both values are higher than the standard, which suggest that as the institution assets and liabilities are balanced. Net receivables decreased which indicates that institution’s ability to collect payment is also decreasing.
3. Acid test Ratio - Total Beds: 47 *Formula: [(Cash + Marketable Securities) / Current Liabilities]	2015: 1.36	2016: 1.29
Comment: The HCIA/HCFA standard is 0.35 for a 1-99 bed hospital. The ratio decreased from 2015 to 2016. Both values are higher than the standard, which suggest that the institution’s current liabilities increased dramatically and cash and marketable securities did not show significant change.
4. Days in accounts receivable - Total Beds: 47 *Formula: Net Patient Accounts Receivables / (Net Patient Revenues / 365)	2015: 48.03	2016: 47.45
Comment: The HCIA/HCFA standard is 47 for a 1-99 bed hospital. The ratio decreased from 2015 to 2016 and both values are within the benchmark. This ratio indicates that the institution receives/processes payment within the standard time frame.
5. Days cash on hand - Total Beds: 47 *Formula: {(Cash + Marketable Securities +Long-term Investments) / ((Operating Expenses - Depreciation & Amortization Expense) / 365)}	2015: 93.90	2016:94.24
Comment: The HCIA/HCFA standard is 85 for a 1-99 bed hospital. Both values are slightly higher than the standard. This indicates that the institution can operate longer than average.
6. Average payment period, days - Total Beds: 47 *Formula: {Current Liabilities / {(Total Operating Expenses - Depreciation and Amortization Expenses) / 365]}	2015: 45.77	2016: 49.20
Comment: The HCIA/HCFA standard is 45 for a 1-99 bed hospital. The ratio increased from 2015 to 2016 and both values are higher than the benchmark. This ratio indicates that the institution is paying bills within a reasonable timeframe.

Capital structure ratios
1.Long-Term debt to net assets ratio - Total Beds: 47 *Formula: Long-Term Debt / Net Assets	2015: 0.40	2016:1.17
Comment: The HCIA/HCFA standard is 0.18 for a 41-99 bed hospital. The ratio increased from 2015 to 2016 and both values are over the benchmark. This ratio indicates that the institution’s long-term debt increased dramatically.
2.Net assets to total assets ratio - Total Beds: 47 *Formula: Net Assets / Total Assets	2015: 0.48	2016:0.34
Comment: The HCIA/HCFA standard is 0.58 for a 1-99 bed hospital. The ratio decreased from 2015 to 2016 and we are below the benchmark. We increased total assets and decreased net assets (in 2016 we added pre-paid bond insurance).
3.Times interest earned - Total Beds: 47 *Formula: (Excess of Revenues over Expenses + Interest Expense) / Interest Expense	2015: -1.02	2016: 1.97
Comment: The HCIA/HCFA standard is 3.47 for a 1-99 bed hospital. The ratio increased from 2015 to 2016 and we are significantly below the benchmark. We are not making sufficient income to pay our debt/interest.
4.Debt service coverage - Total Beds: 47 *Formula: (Excess of Revenues over Expenses + Interest Expense + Depreciation & Amortization Expense) / (Interest Expense + Principal Payments)	2015: -2.27	2016: -0.32
Comment: The HCIA/HCFA standard is 3.51 for a 1-99 bed hospital. The ratio increased from 2015 to 2016 and we are significantly below the benchmark. We are improving in revenue, but our interest is accumulating and adding to debt.

Revenue, expense, and profitability ratios
1.Salary expense as a percentage of operating expense - Total Beds: 47 *Formula: Salary & Benefits / Total Operating Expense	2015: 54.60%	2016:53.99%
Comment: The HCIA/HCFA standard is 40% for a 1-99 bed hospital. The ratio decreased from 2015 to 2016. Both values are higher than the standard, which suggest that the institution’s operations are increasing.
2.Operating margin - Total Beds: 47 *Formula: Operating Income / Total Operating Revenues	2015: 0.01	2016: -0.01
Comment: The HCIA/HCFA standard 0.02 for a 1-99 bed hospital. The ratio decreased from 2015 to 2016. Both values are below the standard, which suggest that the institution’s operating income decreased but operating revenue continues to grow.
3.Non-operating revenue ratio - Total Beds: 47 *Formula: Non-Operating Revenues and Other Income / Total Operating Revenues	2015: 0.013	2016: 0.01
Comment: The HCIA/HCFA standard is 0.05 for a 1-99 bed hospital. The ratio remained the same from 2015 to 2016. Both values are below the standard, which suggest that the institution low non-operating revenue.
4. Return on total assets - Total Beds: 47 *Formula: Excess of Revenues over Expenses / Total Assets	2015: 0.02	2016: -0.01
Comment: The HCIA/HCFA standard is 0.04 for a 1-99 bed hospital. The ratio decreased from 2015 to 2016. Both values are below the standard that indicates the institution’s annual income decreased.
5. Return on net assets - Total Beds: 47 *Formula: Excess of Revenues over Expenses / Net Assets	2015: 0.03	2016:-0. 03
Comment: The HCIA/HCFA standard is 0.08 for a 1-99 bed hospital. The ratio decreased from 2015 to 2016. Both values are below the standard, which indicates the institution’s expenses are increasing and operating income decreased.

Activity ratios
1.Total asset turnover - Total Beds: 47 *Formula: Total Operating Revenues / Total Assets	2015: 1.39	2016:1.10
Comment: The HCIA/HCFA standard is 1.19 for a 1-99 bed hospital. The ratio decreased from 2015 to 2016. Both values are within the standard, which indicate that our ability to generate revenue is decreasing and the system is not performing efficiently.
2.Net fixed assets turnover ratio - Total Beds: 47 *Formula: Total Operating Revenues / Net Plant and Equipment	2015: 0.72	2016: 0.77
Comment: The HCIA/HCFA standard is 2.17 for a 1-99 bed hospital. The ratio increased from 2015 to 2016. Both values are below the benchmark, which indicates that asset values are decreasing even when operating revenue is increasing.
3.Age of plant ratio - Total Beds: 47 *Formula: Accumulated Depreciation / Depreciation Expense	2015: 15.80	2016: 15.2
Comment: The HCIA/HCFA standard is 10.41 for a 1-99 bed hospital. The ratio decreased from 2015 to 2016. The value of plant and equipment will continue to decrease overtime, but these results indicate that the fixed assets are generating above standard revenue for the institution.