City of South Bend, Indiana
<br />Health Insurance Fund 711 Revenue and Expenditures - Cash Basis
<br />December 31, 2016 - 2015
<br />12/31/2015 12/31/2016 Amount Percentage
<br />Name Actual Actual Change Change
<br />Revenue
<br /> Employee Contributions 2,645,116 2,855,414 210,298 7.95%
<br /> Employer Contributions 11,590,466 13,697,037 2,106,571 18.18%
<br /> Stop Loss Refunds 109,133 1,585,602 1,476,469 1352.91%
<br /> Interest Earnings 28,482 49,659 21,177 74.35%
<br /> Other Revenue 6,316 4,495 (1,821)-28.83%
<br /> Total Revenue 14,379,513 18,192,207 3,812,694 26.51%
<br />
<br />Expenditures
<br /> Wellness Programs 41,113 33,892 (7,221)-17.56%
<br /> Administration Fee Allocation (2)431,763 0 (431,763)-100.00%
<br /> Health Insurance Costs & Claims 13,594,557 14,564,786 970,229 7.14%
<br /> Clinic Costs (1)0 1,231,781 1,231,781 100.00%
<br /> Total Expenditures 14,067,433 15,830,459 1,763,026 12.53%
<br /> Total Expenditures net of Stop Loss Refunds 13,958,300 14,244,857 286,557 2.05%
<br /> Net Surplus 312,080 2,361,748
<br /> Beginning Cash Balance 4,059,314 4,374,721
<br /> Balance Sheet Adjustments 3,327 (17,423)
<br /> Ending Cash Balance 4,374,721 6,719,046
<br /> Outstanding Encumbrances (44,959)(7,350)
<br /> Ending Cash net of Encumbrances 4,329,762 6,711,696
<br /> Net Cash Balance Percentage of Expenditures 30.78%42.40%
<br /> Health Insurance Fund Cash Resrves Target 25.00%25.00%
<br /> (1) The Ativate Health and Welness Center opened in January 2016.
<br /> (2) The Administration fee allocation was discontinued for 2016.
<br />Administration/Finance 1/26/2017 Page 6
|