Financial Statements and Wellness Report
Extracted text (via pymupdf)
10373 characters
ASSETS
Cash and investments
16,936,882
$
Accrued interest
39,474
Total assets
16,976,356
LIABILITIES
Compensated absences payable
53,570
Claims incurred but not reported (IBNR)
2,152,000
Due to City
697,804
Employees claims payable, due to Blue Cross Blue Shield
1,340,724
Retirees claims payable, due to Blue Cross Blue Shield
223,895
COBRA claims payable, due to Blue Cross Blue Shield
14,423
Total liabilities
4,482,416
NET POSITION
Unrestricted
12,493,941
Total net position
12,493,941
$
Note: December 31, 2020 minimum end of year reserve including IBNR and two months costs as
projected by Segal Consulting.
$ 6,341,000
CITY OF CHANDLER
Chandler Health Care Benefits Self-Insurance Trust Fund
Statement of Net Position
September 30, 2021
2021
Budget
2021
Budget
Prorated
Actuals
Budget to
Actual
Difference
OPERATING REVENUES
Contributions:
Employer self insurance premiums
18,652,660
$
13,989,495
13,356,588
$
(632,907)
$
Employee self insurance premiums
2,366,480
1,774,860
1,535,238
(239,622)
Retiree premiums
1,779,600
1,334,700
1,487,327
152,627
COBRA premiums
93,260
69,945
53,327
(16,618)
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
63,568
41,068
Total operating revenues
23,102,000
17,371,500
16,676,047
(695,453)
OPERATING EXPENSES
Personnel support
469,073
360,825
333,103
(27,723)
Audits & financial services
8,340
8,340
7,370
(970)
Promotional
30,000
22,500
-
(22,500)
Operating supplies & equipment
31,627
23,720
6,452
(17,268)
Bank charges
400
300
250
(50)
Contractual services
151,000
113,250
60,386
(52,864)
Other:
Self-insurance administrative fees
2,505,482
1,879,112
1,650,064
(229,048)
PCORI fees
9,000
9,000
8,800
(200)
Wellness programs
118,742
89,057
6,700
(82,357)
Health savings & flex spending acct contributions
348,606
348,606
225,050
(123,556)
Claims paid:
Employees
17,360,710
13,020,533
13,340,316
319,783
Retirees
4,016,080
3,012,060
2,967,900
(44,160)
COBRA
170,780
128,085
81,575
(46,510)
Total operating expenses
25,219,840
19,015,387
18,687,964
(327,423)
OPERATING INCOME (LOSS)
(2,117,840)
(1,643,887)
(2,011,917)
(368,030)
NONOPERATING REVENUES (EXPENSES):
Transfers Out - Technology Fund
(5,530)
(5,530)
(5,530)
-
Interest income (loss)
327,000
245,250
(77,369)
(322,619)
Total nonoperating revenues (expenses)
321,470
239,720
(82,899)
(322,619)
Change in net position
(1,796,370)
(1,404,167)
(2,094,816)
(690,650)
NET POSITION:
Total net position, as of January 1, 2021
14,588,757
14,588,757
14,588,757
-
Total net position, as of September 30, 2021
12,792,387
$
13,184,590
$
12,493,941
$
(690,650)
$
CITY OF CHANDLER
Chandler Health Care Benefits Self-Insurance Trust Fund
Statement of Revenues, Expenses and Changes in Net Position
For the Three Months Ended September 30, 2021
Cash flows from operating activities:
Cash received for premiums and other operating purposes
17,052,515
$
Cash payments for claims
(17,029,580)
Cash payments to suppliers for other services
(1,972,926)
Cash payments to employees for services
(349,365)
Net cash provided by operating activities
(2,299,356)
Cash flows from noncapital financing activities:
Cash paid to City for technology replacement
(5,530)
Net cash used for noncapital financing activities
(5,530)
Cash flows from investing activities:
Investment income
(55,875)
Proceeds from sales of investments
9,320,274
Purchases of investments
(6,959,513)
Net cash used for investing activities
2,304,886
Net increase in cash and cash equivalents
-
Cash and cash equivalents, January 1, 2021
-
Cash and cash equivalents, September 30, 2021
-
$
Reconciliation of operating income to cash provided by operating activities:
Operating income
(2,011,917)
$
Adjustments to reconcile operating income to net cash provided by
operating activities:
Changes in assets and liabilities:
(Increase)/Decrease in due from (to) City
376,467
(Increase)/Decrease in prepaids
11,082
Increase/(Decrease) in claims payable
(639,789)
Increase/(Decrease) in accounts payable
(18,937)
Increase/(Decrease) in accrued payroll
(16,262)
Net cash provided by operating activities
(2,299,356)
$
Reconciliation of Cash and Cash Equivalents to the Statement of Net Position:
Cash and cash equivalents
-
$
Investments
16,936,882
Cash and investments
16,936,882
$
CITY OF CHANDLER
Chandler Health Care Benefits Self-Insurance Trust Fund
Statement of Cash Flows
For the Three Months Ended September 30, 2021
11/4/2021
Wellness Detail
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-Sep
2021
Total
Revenue
Wellness Funds from BCBS
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
274,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
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
288,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
-
-
-
18,010.00
Other Professional Services
1,200.00
-
93.62
-
-
-
-
360.00
1,653.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
5,036.20
130,653.14
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
5,656.95
Clothing & Uniforms
628.00
-
51.58
-
-
-
-
679.58
Other Supplies
26.16
26.75
-
-
-
-
-
-
52.91
Emp Activities\Recognition
1,000.00
-
-
-
-
-
1,000.00
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
-
-
-
1,787.00
Education & Training
(600.00)
120.00
79.00
439.10
625.50
895.50
460.00
390.00
2,409.10
Other Wellness Expenses
-
-
-
-
-
-
2,648.92
Registrations
625.50
-
200.00
-
70.00
895.50
Total Wellness Program Expenses
10,964.66
29,124.74
30,442.29
15,921.00
15,058.04
19,819.30
13,531.79
21,334.21
10,643.99
6,699.58
176,189.31
Net Wellness Funds Remaining
112,042.42
Net Wellness Funds with 2021 Contribution
112,042.42
Chandler Health Care Benefits Trust
Wellness Programs Tracking January 1 Thru September 30, 2021