1. Conduct a financial statement and operating indicator analysis and interpret the resulting data. Use both national and state competitor data in the analysis. (Note that all ratios do not have a complete set of comparative data)

a. Explain Operating Indicators

Administrative Cost Ratio (Percent Administrative Expense) 2012 2013 Sparta State average State median Upper quartie Praxima Signet Healthcare Welllife Commonwealth Median Lower Quartile 23.946 15.5% 14.8% 14.4% 13.8% 12 296 12 1% 12.1961 120% 9.0% Sparta State Bage Praxime Siste median Upper quartile Signet Healthcare Commonwealth Median WellLife Love Quartile 28.8% 17.4% 18.4% 15.7% 14.496 13.496 12.8% 120% 11.596 9.0% Percent Inpatient Expense 2012 2013 Welllife Commonwealth State aves State median Signe Healthcare Prasime Sparta 32.296 26.590 25.296 23.8% 22.896 21.296 18.2% Wellife Commonwealth State median Siste sissage Praxima Signet Healthcare Sparta 30.39% 26.596 24396 22.3% 23.09 224% 18.8% Percent Physician Expense 2012 2013 WellLife Commonwealth Signet Healthcare State median Siste avec so Pt come Sparta 54.1% 41.296 31.3% 31.1% 28.8% 22796 12 896 Welllife Commonwealth Stale medie SER Signet Healthcare Proacima Sparta 58.996 37.3% 31.896 31.3% 30.396 24996 18.696 Percent Other Medical Expense 2012 2013 Sparta Proxima Commonwealth State average State median Signet Healthcare Wellife 45.7% 27.5% 18.6% 14.8% 10.29% 8.99% 0.1% Sparta Praxima. Commonwealth State average State median Signet Health care WellL te 35.0% 30.2% 21.996 12.576 8.9% 7.896 0 196 Medical Loss Ratio Based on the three ratios above) 2012 2013 Upper quartile We Life Commonwealth Median Lower quartie Proxima State average Siste median Signet Healthcare 89.0% 86.496 86.4% 84.9% 80.0% 71.496 68.896 84.9% 03.096 Upper quartile WellLife Commonwealth Madian Lower quartile Praxima Stane sverige BE Signet Healthcare 89.096 87.396 85.796 849% 80.0% 78.16 67. 196 64596 62496