Financial Stmts and Wellness Report
Extracted text (via pymupdf)
11158 characters
ASSETS
Cash and investments
15,214,870
$
Accrued interest
44,481
Due from City - premiums
4,039,505
Total assets
19,298,856
LIABILITIES
Compensated absences payable
47,613
Claims incurred but not reported (IBNR) Current 90%
2,034,000
Claims incurred but not reported (IBNR) Non-current 10%
226,000
Employees claims payable, due to Blue Cross Blue Shield
1,632,388
Retirees claims payable, due to Blue Cross Blue Shield
506,100
COBRA claims payable, due to Blue Cross Blue Shield
6,206
Total liabilities
4,452,307
NET POSITION
Unrestricted
14,846,549
Total net position
14,846,549
$
Note: December 31, 2021 minimum end of year reserve including IBNR and two months costs as
projected by Segal Consulting.
$ 6,934,000
CITY OF CHANDLER
Chandler Health Care Benefits Self-Insurance Trust Fund
Statement of Net Position
September 30, 2022
2022
Budget
2022
Budget
Prorated
Actuals
Budget to
Actual
Difference
OPERATING REVENUES
Contributions:
Employer self insurance premiums
19,194,205
$
14,395,654
13,538,396
$
(857,258)
$
Employee self insurance premiums
2,194,830
1,646,123
1,539,519
(106,603)
Retiree premiums
2,051,370
1,538,528
1,701,387
162,859
COBRA premiums
77,095
57,821
33,766
(24,055)
Other:
BCBS wellness programs
25,000
25,000
25,000
-
BCBS wellness coordinator
100,000
100,000
100,000
-
BCBS administration
25,000
25,000
25,000
-
BCBS communication
30,000
30,000
30,000
-
Recovery of medical claims
30,000
22,500
46,153
23,653
Total operating revenues
23,727,500
17,840,625
17,039,220
(801,405)
OPERATING EXPENSES
Personnel support
473,828
364,483
346,297
(18,186)
Audits & financial services
8,600
8,600
8,340
(260)
Promotional
30,000
22,500
570
(21,930)
Operating supplies & equipment
40,027
30,020
12,558
(17,462)
Bank charges
400
300
125
(175)
Contractual services
174,000
130,500
13,234
(117,266)
Other:
Self-insurance administrative fees
2,818,636
2,113,977
1,778,956
(335,021)
PCORI fees
11,000
11,000
9,267
(1,733)
Wellness programs
130,494
97,871
17,073
(80,798)
Health savings & flex spending acct contributions
317,700
317,700
212,450
(105,250)
Claims paid:
Employees
18,862,000
14,146,500
13,377,461
(769,039)
Retirees
4,252,000
3,189,000
2,809,579
(379,421)
COBRA
136,000
102,000
38,757
(63,243)
Total operating expenses
27,254,685
20,534,451
18,624,667
(1,909,784)
OPERATING INCOME (LOSS)
(3,527,185)
(2,693,826)
(1,585,447)
1,108,379
NONOPERATING REVENUES (EXPENSES):
Transfers Out - Technology Fund
(5,530)
(5,530)
(5,530)
-
Transfers In - General Fund
5,000,000
5,000,000
5,000,000
-
Interest income (loss)
106,050
79,538
104,973
25,435
Total nonoperating revenues (expenses)
5,100,520
5,074,008
5,099,443
25,435
Change in net position
1,573,335
2,380,182
3,513,996
1,133,813
NET POSITION:
Total net position, as of January 1, 2022
11,332,553
11,332,553
11,332,553
-
Total net position, as of September 30, 2022
12,905,888
$
13,712,735
$
14,846,549
$
1,133,813
$
CITY OF CHANDLER
Chandler Health Care Benefits Self-Insurance Trust Fund
Statement of Revenues, Expenses and Changes in Net Position
For the Nine Months Ended September 30, 2022
Cash flows from operating activities:
Cash received for premiums and other operating purposes
16,857,811
$
Cash payments for claims
(16,285,228)
Cash payments to suppliers for other services
(2,042,651)
Cash payments to employees for services
(364,111)
Net cash provided by operating activities
(1,834,179)
Cash flows from investing activities:
Investment income
95,474
Proceeds from sales of investments
17,972,071
Purchases of investments
(16,233,365)
Net cash used for investing activities
1,834,179
Net increase in cash and cash equivalents
-
Cash and cash equivalents, January 1, 2022
-
Cash and cash equivalents, September 30, 2022
-
$
Reconciliation of operating income to cash provided by operating activities:
Operating income
(1,585,447)
$
Adjustments to reconcile operating income to net cash provided by
operating activities:
Changes in assets and liabilities:
(Increase)/Decrease in due from (to) City
(181,409)
(Increase)/Decrease in prepaids
12,826
Increase/(Decrease) in claims payable
(59,430)
Increase/(Decrease) in accounts payable
(2,904)
Increase/(Decrease) in accrued payroll
(17,815)
Net cash provided by operating activities
(1,834,179)
$
Reconciliation of Cash and Cash Equivalents to the Statement of Net Position:
Cash and cash equivalents
-
$
Investments
15,214,870
Cash and investments
15,214,870
$
CITY OF CHANDLER
Chandler Health Care Benefits Self-Insurance Trust Fund
Statement of Cash Flows
For the Nine Months Ended September 30, 2022
Wellness Detail
Jan - Dec
2011
Jan - Dec
2012
Jan - Dec
2013
Jan - Dec
2014
Jan - Dec
2015
Jan - Dec
2016
Jan - Dec
2017
Jan - Dec
2018
Jan - Dec
2019
Jan - Dec
2020
Jan - Dec
2021
Jan - Sept
2022
Cumulative
Total Since
Inception
Revenue
Wellness Funds from BCBS
24,031.73
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
299,031.73
YOGA Program Revenues
-
2,150.00
2,288.00
2,466.00
2,266.00
1,820.00
1,062.00
2,148.00
-
-
-
-
14,200.00
Total Wellness Program Revenue
24,031.73
27,150.00
27,288.00
27,466.00
27,266.00
26,820.00
26,062.00
27,148.00
25,000.00
25,000.00
25,000.00
25,000.00
313,231.73
Expenses
YOGA Program Expenses
-
1,820.00
3,360.00
3,220.00
3,150.00
2,905.00
2,555.00
1,000.00
-
-
360.00
-
18,370.00
Other Professional Services
-
-
-
1,200.00
-
93.62
-
-
-
-
-
2,500.00
3,793.62
Promotional/Advertising Svcs
-
7,547.42
22,174.80
24,361.61
10,408.85
8,567.47
15,024.50
10,060.07
17,712.80
9,759.42
10,434.58
9,589.18
145,640.70
Supplies (printing, office, etc.)
-
227.89
2,954.17
1,259.37
1,447.85
1,735.20
12.30
3.02
35.22
-
-
-
7,675.02
Food & Events
-
350.19
375.02
64.56
795.09
677.75
427.82
535.24
1,163.33
424.57
843.38
648.96
6,305.91
Clothing & Uniforms
-
628.00
-
-
-
-
51.58
-
-
-
-
-
679.58
Other Supplies
-
26.16
-
26.75
-
-
-
-
-
-
-
-
52.91
Office Furniture
-
-
-
-
-
-
-
-
-
-
-
489.80
489.80
Employee Activities/Recognition
-
-
-
-
-
1,000.00
-
-
-
-
1,121.00
3,200.73
5,321.73
Postage & Freight
-
-
481.63
-
-
-
-
-
-
-
-
-
481.63
Travel
-
-
27.12
-
-
-
288.50
942.96
1,327.36
-
-
-
2,585.94
Subscriptions & Memberships
-
365.00
352.00
310.00
-
-
395.00
365.00
-
-
-
574.22
2,361.22
Education & Training
-
-
(600.00)
-
120.00
79.00
439.10
625.50
895.50
460.00
419.00
-
2,438.10
Other Wellness Expenses
2,648.92
-
-
-
-
-
-
-
-
-
-
-
2,648.92
Registrations
-
-
-
-
-
-
625.50
-
200.00
-
70.00
70.00
965.50
Total Wellness Program Expenses
2,648.92
10,964.66
29,124.74
30,442.29
15,921.79
15,058.04
19,819.30
13,531.79
21,334.21
10,643.99
13,247.96
17,072.89
199,810.58
Net Wellness Funds Remaining
113,421.15
Chandler Health Care Benefits Trust
Wellness Programs Tracking thru September 30, 2022