June 30, 2015 AWS
MEMORANDUM Finance Department INVESTMENT REPORT On June 30th, the Town’s funds were in the Florida Local Government Surplus Trust Funds Investment Pool (Florida Prime), TD Bank, and SunTrust, with the majority at SunTrust. As of the date of this memorandum, SunTrust and TD Bank continue to participate in the Qualified Public Depository (QPD) program where Town funds are guaranteed 100% above the $250k insured by the FDIC. Additionally, both SunTrust and TD Bank possess a four-star rating from BauerFinancial which indicates the banks are in excellent financial condition. OTHER FUNDS The following pages include smaller funds not included in the Executive Summary. These include the Police Education, Police Forfeiture, Grants, and Insurance funds.
If you have any questions, please do not hesitate to contact me.
-2-
BUDGET-IN-BRIEF as of June 30, 2015 (75% of year elapsed) YTD-Townwide Expense Allocation
Other Town Funds
Debt, 388,499 , 4% Capital, 1,336,372 , 14%
Wages, 3,432,383 , 35%
Benefits, 1,807,447 , Operating 19% & Maint., 2,738,245 , 28%
General Fund Revenues Revenues Budget Year-to-Date Taxes 4,961,175 4,066,430 Licenses & Permits 580,440 514,316 Assessments 675,206 652,292 Intergovernmental Revenue 1,359,203 795,009 Charges for Services 795,909 734,501 Fines & Forfeitures 154,897 229,144 Misc. Revenue 1,984,031 599,986 Appropriations & Carryover 1,738,439 Total Revenues $ 12,249,300 $ 7,591,678
% 82.0% 88.6% 96.6% 58.5% 92.3% 147.9% 30.2% 0.0% 62.0%
General Fund Expenditures Expenditures Budget Year-to-Date Town Council 119,443 86,059 Town Manager 191,122 129,202 Finance 340,833 233,983 Town Attorney 186,670 74,317 Non-Departmental 43,560 29,122 Police 4,403,977 3,198,777 Development Services 644,010 425,760
% 72.1% 67.6% 68.7% 39.8% 66.9% 72.6% 66.1%
Public Works Library Holiday Events Capital Outlay Debt Service Contingency Total Expenditures
Utility Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 5,201,789 2,129,474 7,331,263 7,331,263
Year-to-Date 4,147,170 4,147,170 2,703,877
% 79.7% 0.0% 56.6% 36.9%
Police Education Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 5,560 5,560 5,560
Year-to-Date 3,121 3,121 1,302
% 56.1% N/A 56.1% 23.4%
Police Forfeiture Fund* Budget Total Revenues Total Expenses *Per Florida Statute fund is not budgeted
Year-to-Date 25,326 5,794
% 0.0% 0.0%
Grants Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 1,167,084 (51,674) 1,115,410 1,115,410
Year-to-Date 32,400 32,400 30,954
% 2.8% 0.0% 2.9% 2.8%
Insurance Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 385,910 385,910 385,910
Year-to-Date 255,724 255,724 304,699
% 66.3% N/A 66.3% 79.0%
2,041,197
1,325,841
65.0%
153,600 40,670
99,627 3,950
64.9% 9.7%
3,541,818
697,041
19.7%
Total Townwide Budget
492,400
352,641
71.6%
(not including Police Forfeiture Fund)
50,000 $ 12,249,300
$
-
0.0%
6,656,320
54.3%
Expenditures
-3-
YTD-Total Townwide Budget Budget Year-to-Date 21,087,443
9,697,152
% 46.0%
TOWN OF LANTANA, FLORIDA General Fund Balance Sheet (unaudited) June 30, 2015 Current Year Assets and Other Debits: Assets: Cash and cash equivalents Investments Accounts receivable Inventory Due from other funds Accrued revenues Other Total assets and other debits
$
$
Liabilities, Equity and Other Credits: Liabilities: Accounts payable Other liabilities Payable from restricted assets: Accrued wages payable Deferred revenue Total liabilities Fund balances: Assigned for Encumbrances Unassigned, assigned, committed Total equity and other credits Total liabilities, equity and other credits
$
-4-
8,370,393 2,199,389 19,561 13,946 249,865 549,396 11,402,550
Prior Year
$
$
6,701,988 2,215,498 10,765 12,172 252,206 9,192,628
89,160 108,952
199,509 7,895
607,032 805,144
101,038 308,442
3,874,243 6,723,163 10,597,406 11,402,550
304,357 8,579,829 8,884,186 9,192,628
$
TOWN OF LANTANA, FLORIDA General Fund Statement of Revenues, Expenditures and Changes in Fund Balance – Budget and Actual (unaudited) Period Ended June 30, 2015
Revenues: Taxes Licenses, permits & fees Intergovernmental Charges for services Fines and forfeitures Miscellaneous Total revenues
Budget
Actual
$ 4,961,175 1,255,646 1,359,203 795,909 154,897 1,982,031 10,508,861
$ 4,066,430 1,166,608 795,010 734,501 229,144 532,267 7,523,960
Variance Favorable (Unfavorable) $
(894,745) (89,038) (564,193) (61,408) 74,247 (1,449,764) (2,984,901)
Prior Year Actual $ 3,880,357 1,108,301 759,337 740,491 180,780 542,308 7,211,574
Expenditures: Current: General government Public safety Development services Physical environment Culture and recreation Capital outlay Debt service: Principal & Interest Total expenditures
881,628 4,402,958 640,885 281,746 1,943,058 3,556,625
552,685 3,198,778 425,761 160,808 1,268,610 697,041
328,943 1,204,180 215,124 120,938 674,448 2,859,584
1,154,632 3,128,523 400,808 912,455 644,149 333,236
492,400 12,249,300
352,640 6,656,323
139,760 5,592,977
352,640 6,926,443
Deficiency of revenues under expenditures
(1,740,439)
867,637
2,608,076
285,131
2,000 706,530 1,031,909 1,740,439
67,720 67,720
65,720 (706,530) (1,031,909) (1,672,719)
212,090 212,090
-
935,357
497,220
9,662,047 $ 10,597,406
8,386,963 $ 8,884,186
Other financing sources: Sale of general fixed assets Use of Fund Balance-capital carryfwd Use of Fund Balance-adopted Total other financing sources Deficiency of revenues and other financing sources under expenditures Fund balance, beginning of year FUND BALANCE, END OF PERIOD
-5-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Revenues and Other Financing Sources – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget
Actual
$ 2,245,434 1,106,624 1,082,096 252,644 274,377 4,961,175
$ 2,200,902 757,184 762,969 173,749 171,626 4,066,430
Licenses, permits & fees: Business tax receipts Building and other permits Solid waste assessment Gas line assessment Total licenses, permits & fees
262,292 318,148 593,245 81,961 1,255,646
Intergovernmental revenues: Insurance premium tax State revenue sharing Mobile home licenses Alcoholic beverage licenses Local government ½ cent sales tax Government grants Total intergovernmental revenues
Taxes: Ad Valorem taxes Franchise taxes Utility service taxes Local Communications Services Tax Gasoline taxes Total taxes
Variance Favorable (Unfavorable) (44,532) (349,440) (319,127) (78,895) (102,751) (894,745)
$ 2,091,706 742,411 731,982 154,211 160,047 3,880,357
238,773 275,543 576,329 75,963 1,166,608
(23,519) (42,605) (16,916) (5,998) (83,040)
237,400 311,227 559,674 1,108,301
93,000 320,952 23,885 11,100 775,000 135,266 1,359,203
240,616 21,834 10,317 502,617 19,626 795,010
(93,000) (80,336) (2,051) (783) (272,383) (115,640) (564,193)
230,893 20,739 8,915 473,036 25,754 759,337
Charges for services: Public Safety Nature Preserve Maintenance Total charges for services
743,658 52,251 795,909
695,451 39,050 734,501
(48,207) (13,201) 61,408
702,122 38,369 740,491
Fines and forfeitures
154,897
229,144
74,247
180,780
Miscellaneous revenues: Interest Parking Contributions Leases Other Total miscellaneous revenues
8,770 190,975 1,532,061 174,683 75,542 1,982,031
7,998 235,348 33,168 170,322 85,431 532,267
(772) 44,373 (1,498,893) (4,361) 9,889 (1,449,764)
15,979 156,766 21,500 209,879 138,184 542,308
Other financing sources: Sale of general fixed assets Interfund Transfers Capital Carryover Use of Fund Balance Total other financing sources TOTAL REVENUES
2,000 706,530 1,031,909 1,740,439 $ 12,249,300
67,720 67,720 $ 7,591,680
65,720 (706,530) (1,031,909) (1,672,719) $ (4,657,620)
212,090
-6-
$
Prior Year Actual
212,090 $ 7,423,664
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget General government: Legislative: Personal services Operating Total Legislative
$
Actual
66,814 52,629 119,443
$
51,850 34,210 86,060
Variance Favorable (Unfavorable)
$
14,964 18,419 33,383
Prior Year Actual
$
50,302 34,176 84,478
Executive: Personal services Operating Total Executive
159,660 31,462 191,122
113,999 15,203 129,202
45,661 16,259 61,920
114,208 15,468 129,676
Finance: Personal services Operating Capital Total Finance
250,610 90,223 7,621 348,454
168,047 65,937 6,320 240,304
82,563 24,286 1,301 108,150
168,681 68,792 59,328 296,801
Legal Counsel: Personal services Operating Total Legal Counsel
186,670 186,670
74,317 74,317
112,353 112,353
10,394 68,224 78,618
42,560 45,552 1,000 89,112 934,801
28,622 500 29,122 559,005
13,938 45,552 500 59,990 375,796
623,887 500 624,387 1,213,960
Public Safety: Administration: Personal services Operating Capital Total Administration
408,660 69,395 33,150 511,205
307,810 56,685 29,683 394,178
100,850 12,710 3,467 117,027
301,225 55,978 357,203
Uniform Patrol: Personal services Operating Capital Total Uniform Patrol
2,293,695 192,508 43,344 2,529,547
1,633,665 125,539 40,578 1,799,782
660,030 66,969 2,766 729,765
1,615,080 127,877 19,189 1,762,146
Non-Departmental Operating Capital Other Expenses Total Non-Departmental Total General Government
-7-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
Detectives: Personal services Operating Capital Total Detectives
240,755 24,887 6,325 271,967
189,349 11,790 6,325 207,464
51,406 13,097 64,503
176,917 13,606 62,903 253,426
Services: Personal services Operating Total Police Services
287,930 151,435 439,365
205,377 115,178 320,555
82,553 36,257 118,810
186,341 114,033 300,374
Uniform Patrol (Hypoluxo): Personal services Operating Total Uniform Patrol (Hypoluxo)
423,320 22,960 446,280
340,527 7,252 347,779
82,793 15,708 98,501
313,560 12,051 325,611
Marine Safety: Personal services Operating Capital Total Marine Safety
271,010 16,403 23,115 310,528
197,090 8,516 18,440 224,046
73,920 7,887 4,675 86,482
202,371 9,484 211,855
4,508,892
3,293,804
1,215,088
3,210,615
174,970 12,730 3,125 190,825
119,848 12,960 132,808
55,122 (230) 3,125 58,017
105,163 10,222 3,231 118,616
Total Public Safety Development Services: Administration : Personal services Operating Capital Total Administration Building Inspections: Personal services Operating Capital Total Building Inspections Code Enforcement: Personal services Operating Capital Total Code Enforcement
120,620 129,430 1,500 251,550
66,692 88,491 155,183
53,928 40,939 1,500 96,367
53,770 95,261 11,260 160,291
186,210 16,925 203,135
123,880 13,890 137,770
62,330 3,035 65,365
125,651 10,741 5,357 141,749
Total Development Services
645,510
425,761
219,749
420,656
-8-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget Physical Environment: Public Works Administration Personal services Operating Total Public Works Administration
Variance Favorable (Unfavorable)
Actual
Prior Year Actual
181,320 20,637 201,957
94,308 14,449 108,757
87,012 6,188 93,200
120,592 28,691 149,283
66,463 13,326 1,500 81,289
41,922 10,129 201 52,252
24,541 3,197 1,299 29,037
43,621 23,087 1,299 68,007
-
-
-
122,234 574,230 62,041 758,505
283,246
161,009
122,237
975,795
3,000 3,000
1,902 1,902
1,098 1,098
5,843 5,843
107,410 46,190 20,006 173,606
76,023 23,604 12,632 112,259
31,387 22,586 7,374 61,347
77,931 35,415 22,046 135,392
Streets & Grounds Maintenance: Personal services Operating Capital Total Streets & Grounds Maintenance
349,330 1,043,734 503,786 1,896,850
255,957 661,388 219,413 1,136,758
93,373 382,346 284,373 760,092
157,592 136,965 62,140 356,697
Facilities Maintenance: Personal services Operating Capital Total Facilities Maintenance
203,718 149,006 2,867,601 3,220,325
147,066 98,720 363,449 609,235
56,652 50,286 2,504,152 2,611,090
110,899 94,996 24,442 230,337
Miscellaneous: Holiday events Total Miscellaneous Total Culture and Recreation
40,670 40,670 5,334,451
3,950 3,950 1,864,104
36,720 36,720 3,470,347
24,508 24,508 752,777
492,400 50,000 $ 12,249,300
352,640 6,656,323
139,760 50,000 5,592,977
352,640 6,926,443
Vehicle Maintenance: Personal services Operating Capital Total Vehicle Maintenance Streets & Sanitation: Personal services Operating Capital Total Streets & Sanitation Total Physical Environment Cultural and Recreation: Sports Complex: Operating Total Sports Complex Services Library: Personal services Operating Capital Total Library services
Debt Service General Contingency TOTAL EXPENDITURES
-9-
$
$
$
TOWN OF LANTANA, FLORIDA Utility Fund Balance Sheet (unaudited) June 30, 2015 Current Year Assets and Other Debits: Assets: Cash and cash equivalents Investments Accounts receivable Restricted Assets Other Total current assets
$
Fixed assets Land Buildings Improvements Machinery and equipment Intangibles Construction in progress
$
Liabilities, Equity and Other Credits: Liabilities: Accounts payable Notes Payable Payable from restricted assets: Accrued wages payable Deposits Revenue refunding bonds Deferred revenue Total liabilities Net Assets: Contributed capital Reserved Unreserved Total net assets Total liabilities, equity and other credits
$
- 10 -
$
4,300 509,892 20,970,815 871,362 5,146 92,326 22,453,841 (13,368,310) 9,085,531
Less accumulated depreciation & amortization Net fixed assets Unamortized bond costs Total assets and other debits
7,517,887 1,660,169 348,514 440,406 9,966,976
Prior Year
903,234 19,955,741
7,193,571 1,740,195 141,692 379,936 9,455,394 4,300 509,892 20,737,967 791,817 5,146 18,445 22,067,567 (13,143,593) 8,923,974
$
1,066,495 19,445,863
96,789 4,302,455
357,589 5,045,738
163,670 223,366 28,670 4,814,950
158,362 234,490 27,760 5,823,939
2,445,897 1,428,662 11,266,232 15,140,791
2,445,897 1,028,018 10,148,009 13,621,924
19,955,741
$
19,445,863
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Revenues, Expenses and Changes in Retained Earnings – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget Revenues: Water sales Wastewater sales Miscellaneous Total operating revenues Expenditures: Operating expenses Water/Sewer plant operations Personnel Current expenses Total
$
Actual
2,601,694 2,406,249 185,007 5,192,950
$
2,072,161 1,864,381 200,598 4,137,140
Variance Favorable (Unfavorable) $
(529,533) (541,868) 15,591 (1,055,810)
$
1,801,915 1,688,968 121,487 3,612,370
893,921 1,937,554 2,831,475
591,968 864,862 1,456,830
845,784
576,036
269,748
572,333
Debt Services Capital outlay
862,800 2,791,204 3,654,004
35,858 635,152 671,010
826,942 2,156,052 2,982,994
40,685 775,385 816,070
Total operating expenses
7,331,263
2,703,876
4,627,387
3,109,757
(2,138,313)
1,433,264
(5,683,197)
502,613
Administrative expenses
Operating income/(loss)
301,953 1,072,692 1,374,645
Prior YTD Actual
600,967 1,120,387 1,721,354
Non-operating revenues (expenses) Investment income Sale of assets Use of reserves-capital carry forward
8,839 2,129,474
6,919 3,111 -
(1,920) 3,111 (2,129,474)
16,259 -
Total non-operating revenues (expenses)
2,138,313
10,030
(2,128,283)
16,259
-
1,443,294
1,443,294
518,872
Net income/(loss) Net assets, beginning Net assets, ending
13,697,498 $ 15,140,791
- 11 -
13,103,050 $ 13,621,924
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget Administrative Legislative: Personal services Operating Total Legislative Executive: Personal services Operating
$
Actual
44,536 35,086 79,622
$
34,579 22,807 57,386
Variance Favorable (Unfavorable)
$
9,957 12,279 22,236
Prior Year Actual
$
33,562 22,751 56,313
104,094 12,078 116,172
42,176 12,501
Total Executive
146,270 24,579 170,849
54,677
103,267 12,468 115,735
Finance Personal services Operating Capital Total Finance
408,780 128,983 537,763
265,048 103,694 368,742
143,732 25,289 169,021
254,924 105,843 7,235 368,002
Total Legal
39,485 39,485
25,617 25,617
13,868 13,868
2,598 20,632 23,230
Non Departmental: Operating
18,065
8,119
9,946
9,053
Total Administrative
845,784
576,036
269,748
572,333
184,700 91,844 18,000 294,544
100,090 25,559 2,800 128,449
84,610 66,285 15,200 166,095
102,502 95,919 198,421
Legal: Personal services Operating
Public Works/Utilities Utilities Administration Personal services Operating Capital Total Utilities Administration
- 12 -
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget Vehicle Maintenance Personal services Operating Total Vehicle Maintenance
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
66,463 11,726 78,189
41,346 6,095 47,441
25,117 5,631 30,748
42,837 5,073 47,910
458,888 658,013 820,749 1,937,650
323,717 343,051 143,467 810,235
135,171 314,962 677,282 1,127,415
328,385 382,386 168,062 878,833
Total Wastewater operations
183,870 1,175,971 1,952,455 3,312,296
126,815 490,157 488,885 1,105,857
57,055 685,814 1,463,570 2,206,439
127,243 637,009 607,323 1,371,575
Total Public Works/Utilities
5,622,679
2,091,982
3,530,697
2,496,739
862,800
35,858
826,942
40,685
$ 7,331,263
$ 2,703,876
4,627,387
$ 3,109,757
Water/water plant operations Personal services Operating Capital Total Water/water plant operations Wastewater operations Personal services Operating Capital
Debt Services TOTAL EXPENDITURES
- 13 -
$
TOWN OF LANTANA, FLORIDA Investment Earnings Quarter Closing June 30, 2015 FLORIDA STATE BOARD OF ADMINISTRATION (SBA) October SBA Rate General Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
November
0.16% 2,194,123
December
0.16% 2,197,082
0.16% 2,197,368
2,662
January
February
March
April
May
June
0.17%
0.19%
0.19%
0.19%
0.20%
0.22%
2,198,664
2,199,011
2,199,389
2,194,123
2,197,676
2,198,002
2,198,321
Total 0.18%
0
297
286
307
326
319
344
347
378
399
2,662 3,002
2,197,082
2,197,368
2,197,676
2,198,002
2,198,321
2,198,664
2,199,011
2,199,389
2,199,787
2,199,787
1,718,340
1,724,641
1,724,865
1,725,108
1,725,363
1,722,102
1,677,172
1,677,436
1,677,724
1,718,340
Utility Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
6,068
1
(3,511)
(45,196)
(17,555)
(60,194) 2,326
233
225
241
256
250
265
265
288
303
1,724,641
1,724,865
1,725,108
1,725,363
1,722,102
1,677,172
1,677,436
1,677,724
1,660,473
1,660,473
1,084
0
0
-
3,511
48,712
48,719
48,728
1,084
3,511
45,196
17,555
-
0
4
8
8
9
65,178 30
-
3,511
48,712
48,719
48,728
66,292
66,292
-
-
-
-
-
-
4,346 (4,346) 1
Impact Fee Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
(1,084)
-
(0)
0 0
0
4,346
1
-
1998 Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
(4,346) 1
(1) -
1
1
638
0
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0
-
-
-
-
-
-
638
RR&I Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
0
(638) 0 0
(0) 0
-
-
-
-
-
-
-
(638) 0
-
-
-
-
-
-
-
(0)
- 14 -
October
November
December
January
February
March
April
May
June
Total
Bond Fund Beginning Bal.
2,662
Transfers In (Out) Admin. Charges Investment Earnings
0
0
(2,662)
-
-
-
-
-
2,662
(0)
0
Ending Bal.
-
-
-
-
-
-
-
-
-
(2,662) 0
-
-
-
-
-
-
-
(0)
0
0
531 531
511 511
549 549
581 581
570 570
613 613
619 619
674 674
711 711
5,359 5,359
297 234 531
286 225 511
307 241 549
326 256 581
319 251 570
344 270 613
347 272 619
378 296 674
399 313 711
3,002 2,357 5,359
0.20% 0.04% 126 101 6 (229)
0.20% 0.04% 120 98 6 (172)
0.20% 0.06% 1,733 1,204 57 (1,930)
SBA TOTALS Total Investment Earnings Total Admin. Charges Net Investment Earnings Investment Earnings Net of Admin. Charges General Fund Utility Fund
SUNTRUST BANK ACCOUNTS Checking Account Earnings Demand Deposit (earnings credit) Checking account APY General Fund Utility Fund Forfeiture Fund Bank Charges (net of interest credit) Investment Earnings
0.20% 0.07% 146 118 1 (316)
0.20% 0.07% 145 116 3 (293)
(50)
(30)
0.20% 0.07% 229 135 5 (105)
0.20% 0.07% 259 157 6 (244)
0.20% 0.07% 225 144 10 (137)
0.20% 0.07% 249 166 11 (211)
0.20% 0.07% 233 170 10 (222)
263
178
241
214
191
5
51
1,064
Ending Account Balances per Statement Operating Demand Deposit Water Plant Reserve Payment Card Receipts Forfeiture Fund Ending Balances
4,135,423 6,000,000 373,980 10,561
4,522,445 6,000,000 374,002 15,980 77,339
6,315,432 6,000,000 374,024 27,341 77,342
6,647,554 6,000,000 374,046 37,545 212,580
6,709,088 6,000,000 374,067 51,375 210,548
6,897,574 6,000,000 374,089 70,860 210,557
6,710,569 6,000,000 374,110 84,009 148,678
6,305,957 6,000,000 374,123 97,020 148,683
6,342,923 6,000,000 374,135 111,481 148,688
10,519,964
10,989,766
12,794,140
13,271,726
13,345,077
13,553,080
13,317,366
12,925,782
12,977,227
TD BANK ACCOUNT TD Bank Rate Investment Earnings (Utility Fund) Investment Earnings (General Fund) Investment Earnings
0.20% 482 340 823
Ending Balance
0.20% 460 329 790
4,843,613
0.20% 481 334 814
4,803,207
0.20% 483 340 823
4,887,826
0.20% 430 308 738
4,847,454
0.20% 487 338 826
4,806,996
0.20% 468 330 797
0.20% 476 341 817
0.20% 472 328 800
4,891,626
4,851,227
4,810,849
4,895,453
931 923 11 1,864
910 910 10 1,829
845 874 6 1,725
846 883 6 1,735
0.20% 4,240 2,988 7,228
TOTAL INVESTMENT EARNINGS BY FUND General Fund Utility Fund Forfeiture Fund $
784 834 1 1,619
$
761 801 3 1,564
$
870 857 5 1,732
$
926 895 6 1,827
- 15 -
$
852 824 10 1,686
$
$
$
$
$
7,724 7,801 57 15,581
If you have any questions, please do not hesitate to contact me.
-2-
BUDGET-IN-BRIEF as of June 30, 2015 (75% of year elapsed) YTD-Townwide Expense Allocation
Other Town Funds
Debt, 388,499 , 4% Capital, 1,336,372 , 14%
Wages, 3,432,383 , 35%
Benefits, 1,807,447 , Operating 19% & Maint., 2,738,245 , 28%
General Fund Revenues Revenues Budget Year-to-Date Taxes 4,961,175 4,066,430 Licenses & Permits 580,440 514,316 Assessments 675,206 652,292 Intergovernmental Revenue 1,359,203 795,009 Charges for Services 795,909 734,501 Fines & Forfeitures 154,897 229,144 Misc. Revenue 1,984,031 599,986 Appropriations & Carryover 1,738,439 Total Revenues $ 12,249,300 $ 7,591,678
% 82.0% 88.6% 96.6% 58.5% 92.3% 147.9% 30.2% 0.0% 62.0%
General Fund Expenditures Expenditures Budget Year-to-Date Town Council 119,443 86,059 Town Manager 191,122 129,202 Finance 340,833 233,983 Town Attorney 186,670 74,317 Non-Departmental 43,560 29,122 Police 4,403,977 3,198,777 Development Services 644,010 425,760
% 72.1% 67.6% 68.7% 39.8% 66.9% 72.6% 66.1%
Public Works Library Holiday Events Capital Outlay Debt Service Contingency Total Expenditures
Utility Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 5,201,789 2,129,474 7,331,263 7,331,263
Year-to-Date 4,147,170 4,147,170 2,703,877
% 79.7% 0.0% 56.6% 36.9%
Police Education Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 5,560 5,560 5,560
Year-to-Date 3,121 3,121 1,302
% 56.1% N/A 56.1% 23.4%
Police Forfeiture Fund* Budget Total Revenues Total Expenses *Per Florida Statute fund is not budgeted
Year-to-Date 25,326 5,794
% 0.0% 0.0%
Grants Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 1,167,084 (51,674) 1,115,410 1,115,410
Year-to-Date 32,400 32,400 30,954
% 2.8% 0.0% 2.9% 2.8%
Insurance Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 385,910 385,910 385,910
Year-to-Date 255,724 255,724 304,699
% 66.3% N/A 66.3% 79.0%
2,041,197
1,325,841
65.0%
153,600 40,670
99,627 3,950
64.9% 9.7%
3,541,818
697,041
19.7%
Total Townwide Budget
492,400
352,641
71.6%
(not including Police Forfeiture Fund)
50,000 $ 12,249,300
$
-
0.0%
6,656,320
54.3%
Expenditures
-3-
YTD-Total Townwide Budget Budget Year-to-Date 21,087,443
9,697,152
% 46.0%
TOWN OF LANTANA, FLORIDA General Fund Balance Sheet (unaudited) June 30, 2015 Current Year Assets and Other Debits: Assets: Cash and cash equivalents Investments Accounts receivable Inventory Due from other funds Accrued revenues Other Total assets and other debits
$
$
Liabilities, Equity and Other Credits: Liabilities: Accounts payable Other liabilities Payable from restricted assets: Accrued wages payable Deferred revenue Total liabilities Fund balances: Assigned for Encumbrances Unassigned, assigned, committed Total equity and other credits Total liabilities, equity and other credits
$
-4-
8,370,393 2,199,389 19,561 13,946 249,865 549,396 11,402,550
Prior Year
$
$
6,701,988 2,215,498 10,765 12,172 252,206 9,192,628
89,160 108,952
199,509 7,895
607,032 805,144
101,038 308,442
3,874,243 6,723,163 10,597,406 11,402,550
304,357 8,579,829 8,884,186 9,192,628
$
TOWN OF LANTANA, FLORIDA General Fund Statement of Revenues, Expenditures and Changes in Fund Balance – Budget and Actual (unaudited) Period Ended June 30, 2015
Revenues: Taxes Licenses, permits & fees Intergovernmental Charges for services Fines and forfeitures Miscellaneous Total revenues
Budget
Actual
$ 4,961,175 1,255,646 1,359,203 795,909 154,897 1,982,031 10,508,861
$ 4,066,430 1,166,608 795,010 734,501 229,144 532,267 7,523,960
Variance Favorable (Unfavorable) $
(894,745) (89,038) (564,193) (61,408) 74,247 (1,449,764) (2,984,901)
Prior Year Actual $ 3,880,357 1,108,301 759,337 740,491 180,780 542,308 7,211,574
Expenditures: Current: General government Public safety Development services Physical environment Culture and recreation Capital outlay Debt service: Principal & Interest Total expenditures
881,628 4,402,958 640,885 281,746 1,943,058 3,556,625
552,685 3,198,778 425,761 160,808 1,268,610 697,041
328,943 1,204,180 215,124 120,938 674,448 2,859,584
1,154,632 3,128,523 400,808 912,455 644,149 333,236
492,400 12,249,300
352,640 6,656,323
139,760 5,592,977
352,640 6,926,443
Deficiency of revenues under expenditures
(1,740,439)
867,637
2,608,076
285,131
2,000 706,530 1,031,909 1,740,439
67,720 67,720
65,720 (706,530) (1,031,909) (1,672,719)
212,090 212,090
-
935,357
497,220
9,662,047 $ 10,597,406
8,386,963 $ 8,884,186
Other financing sources: Sale of general fixed assets Use of Fund Balance-capital carryfwd Use of Fund Balance-adopted Total other financing sources Deficiency of revenues and other financing sources under expenditures Fund balance, beginning of year FUND BALANCE, END OF PERIOD
-5-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Revenues and Other Financing Sources – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget
Actual
$ 2,245,434 1,106,624 1,082,096 252,644 274,377 4,961,175
$ 2,200,902 757,184 762,969 173,749 171,626 4,066,430
Licenses, permits & fees: Business tax receipts Building and other permits Solid waste assessment Gas line assessment Total licenses, permits & fees
262,292 318,148 593,245 81,961 1,255,646
Intergovernmental revenues: Insurance premium tax State revenue sharing Mobile home licenses Alcoholic beverage licenses Local government ½ cent sales tax Government grants Total intergovernmental revenues
Taxes: Ad Valorem taxes Franchise taxes Utility service taxes Local Communications Services Tax Gasoline taxes Total taxes
Variance Favorable (Unfavorable) (44,532) (349,440) (319,127) (78,895) (102,751) (894,745)
$ 2,091,706 742,411 731,982 154,211 160,047 3,880,357
238,773 275,543 576,329 75,963 1,166,608
(23,519) (42,605) (16,916) (5,998) (83,040)
237,400 311,227 559,674 1,108,301
93,000 320,952 23,885 11,100 775,000 135,266 1,359,203
240,616 21,834 10,317 502,617 19,626 795,010
(93,000) (80,336) (2,051) (783) (272,383) (115,640) (564,193)
230,893 20,739 8,915 473,036 25,754 759,337
Charges for services: Public Safety Nature Preserve Maintenance Total charges for services
743,658 52,251 795,909
695,451 39,050 734,501
(48,207) (13,201) 61,408
702,122 38,369 740,491
Fines and forfeitures
154,897
229,144
74,247
180,780
Miscellaneous revenues: Interest Parking Contributions Leases Other Total miscellaneous revenues
8,770 190,975 1,532,061 174,683 75,542 1,982,031
7,998 235,348 33,168 170,322 85,431 532,267
(772) 44,373 (1,498,893) (4,361) 9,889 (1,449,764)
15,979 156,766 21,500 209,879 138,184 542,308
Other financing sources: Sale of general fixed assets Interfund Transfers Capital Carryover Use of Fund Balance Total other financing sources TOTAL REVENUES
2,000 706,530 1,031,909 1,740,439 $ 12,249,300
67,720 67,720 $ 7,591,680
65,720 (706,530) (1,031,909) (1,672,719) $ (4,657,620)
212,090
-6-
$
Prior Year Actual
212,090 $ 7,423,664
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget General government: Legislative: Personal services Operating Total Legislative
$
Actual
66,814 52,629 119,443
$
51,850 34,210 86,060
Variance Favorable (Unfavorable)
$
14,964 18,419 33,383
Prior Year Actual
$
50,302 34,176 84,478
Executive: Personal services Operating Total Executive
159,660 31,462 191,122
113,999 15,203 129,202
45,661 16,259 61,920
114,208 15,468 129,676
Finance: Personal services Operating Capital Total Finance
250,610 90,223 7,621 348,454
168,047 65,937 6,320 240,304
82,563 24,286 1,301 108,150
168,681 68,792 59,328 296,801
Legal Counsel: Personal services Operating Total Legal Counsel
186,670 186,670
74,317 74,317
112,353 112,353
10,394 68,224 78,618
42,560 45,552 1,000 89,112 934,801
28,622 500 29,122 559,005
13,938 45,552 500 59,990 375,796
623,887 500 624,387 1,213,960
Public Safety: Administration: Personal services Operating Capital Total Administration
408,660 69,395 33,150 511,205
307,810 56,685 29,683 394,178
100,850 12,710 3,467 117,027
301,225 55,978 357,203
Uniform Patrol: Personal services Operating Capital Total Uniform Patrol
2,293,695 192,508 43,344 2,529,547
1,633,665 125,539 40,578 1,799,782
660,030 66,969 2,766 729,765
1,615,080 127,877 19,189 1,762,146
Non-Departmental Operating Capital Other Expenses Total Non-Departmental Total General Government
-7-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
Detectives: Personal services Operating Capital Total Detectives
240,755 24,887 6,325 271,967
189,349 11,790 6,325 207,464
51,406 13,097 64,503
176,917 13,606 62,903 253,426
Services: Personal services Operating Total Police Services
287,930 151,435 439,365
205,377 115,178 320,555
82,553 36,257 118,810
186,341 114,033 300,374
Uniform Patrol (Hypoluxo): Personal services Operating Total Uniform Patrol (Hypoluxo)
423,320 22,960 446,280
340,527 7,252 347,779
82,793 15,708 98,501
313,560 12,051 325,611
Marine Safety: Personal services Operating Capital Total Marine Safety
271,010 16,403 23,115 310,528
197,090 8,516 18,440 224,046
73,920 7,887 4,675 86,482
202,371 9,484 211,855
4,508,892
3,293,804
1,215,088
3,210,615
174,970 12,730 3,125 190,825
119,848 12,960 132,808
55,122 (230) 3,125 58,017
105,163 10,222 3,231 118,616
Total Public Safety Development Services: Administration : Personal services Operating Capital Total Administration Building Inspections: Personal services Operating Capital Total Building Inspections Code Enforcement: Personal services Operating Capital Total Code Enforcement
120,620 129,430 1,500 251,550
66,692 88,491 155,183
53,928 40,939 1,500 96,367
53,770 95,261 11,260 160,291
186,210 16,925 203,135
123,880 13,890 137,770
62,330 3,035 65,365
125,651 10,741 5,357 141,749
Total Development Services
645,510
425,761
219,749
420,656
-8-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget Physical Environment: Public Works Administration Personal services Operating Total Public Works Administration
Variance Favorable (Unfavorable)
Actual
Prior Year Actual
181,320 20,637 201,957
94,308 14,449 108,757
87,012 6,188 93,200
120,592 28,691 149,283
66,463 13,326 1,500 81,289
41,922 10,129 201 52,252
24,541 3,197 1,299 29,037
43,621 23,087 1,299 68,007
-
-
-
122,234 574,230 62,041 758,505
283,246
161,009
122,237
975,795
3,000 3,000
1,902 1,902
1,098 1,098
5,843 5,843
107,410 46,190 20,006 173,606
76,023 23,604 12,632 112,259
31,387 22,586 7,374 61,347
77,931 35,415 22,046 135,392
Streets & Grounds Maintenance: Personal services Operating Capital Total Streets & Grounds Maintenance
349,330 1,043,734 503,786 1,896,850
255,957 661,388 219,413 1,136,758
93,373 382,346 284,373 760,092
157,592 136,965 62,140 356,697
Facilities Maintenance: Personal services Operating Capital Total Facilities Maintenance
203,718 149,006 2,867,601 3,220,325
147,066 98,720 363,449 609,235
56,652 50,286 2,504,152 2,611,090
110,899 94,996 24,442 230,337
Miscellaneous: Holiday events Total Miscellaneous Total Culture and Recreation
40,670 40,670 5,334,451
3,950 3,950 1,864,104
36,720 36,720 3,470,347
24,508 24,508 752,777
492,400 50,000 $ 12,249,300
352,640 6,656,323
139,760 50,000 5,592,977
352,640 6,926,443
Vehicle Maintenance: Personal services Operating Capital Total Vehicle Maintenance Streets & Sanitation: Personal services Operating Capital Total Streets & Sanitation Total Physical Environment Cultural and Recreation: Sports Complex: Operating Total Sports Complex Services Library: Personal services Operating Capital Total Library services
Debt Service General Contingency TOTAL EXPENDITURES
-9-
$
$
$
TOWN OF LANTANA, FLORIDA Utility Fund Balance Sheet (unaudited) June 30, 2015 Current Year Assets and Other Debits: Assets: Cash and cash equivalents Investments Accounts receivable Restricted Assets Other Total current assets
$
Fixed assets Land Buildings Improvements Machinery and equipment Intangibles Construction in progress
$
Liabilities, Equity and Other Credits: Liabilities: Accounts payable Notes Payable Payable from restricted assets: Accrued wages payable Deposits Revenue refunding bonds Deferred revenue Total liabilities Net Assets: Contributed capital Reserved Unreserved Total net assets Total liabilities, equity and other credits
$
- 10 -
$
4,300 509,892 20,970,815 871,362 5,146 92,326 22,453,841 (13,368,310) 9,085,531
Less accumulated depreciation & amortization Net fixed assets Unamortized bond costs Total assets and other debits
7,517,887 1,660,169 348,514 440,406 9,966,976
Prior Year
903,234 19,955,741
7,193,571 1,740,195 141,692 379,936 9,455,394 4,300 509,892 20,737,967 791,817 5,146 18,445 22,067,567 (13,143,593) 8,923,974
$
1,066,495 19,445,863
96,789 4,302,455
357,589 5,045,738
163,670 223,366 28,670 4,814,950
158,362 234,490 27,760 5,823,939
2,445,897 1,428,662 11,266,232 15,140,791
2,445,897 1,028,018 10,148,009 13,621,924
19,955,741
$
19,445,863
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Revenues, Expenses and Changes in Retained Earnings – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget Revenues: Water sales Wastewater sales Miscellaneous Total operating revenues Expenditures: Operating expenses Water/Sewer plant operations Personnel Current expenses Total
$
Actual
2,601,694 2,406,249 185,007 5,192,950
$
2,072,161 1,864,381 200,598 4,137,140
Variance Favorable (Unfavorable) $
(529,533) (541,868) 15,591 (1,055,810)
$
1,801,915 1,688,968 121,487 3,612,370
893,921 1,937,554 2,831,475
591,968 864,862 1,456,830
845,784
576,036
269,748
572,333
Debt Services Capital outlay
862,800 2,791,204 3,654,004
35,858 635,152 671,010
826,942 2,156,052 2,982,994
40,685 775,385 816,070
Total operating expenses
7,331,263
2,703,876
4,627,387
3,109,757
(2,138,313)
1,433,264
(5,683,197)
502,613
Administrative expenses
Operating income/(loss)
301,953 1,072,692 1,374,645
Prior YTD Actual
600,967 1,120,387 1,721,354
Non-operating revenues (expenses) Investment income Sale of assets Use of reserves-capital carry forward
8,839 2,129,474
6,919 3,111 -
(1,920) 3,111 (2,129,474)
16,259 -
Total non-operating revenues (expenses)
2,138,313
10,030
(2,128,283)
16,259
-
1,443,294
1,443,294
518,872
Net income/(loss) Net assets, beginning Net assets, ending
13,697,498 $ 15,140,791
- 11 -
13,103,050 $ 13,621,924
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget Administrative Legislative: Personal services Operating Total Legislative Executive: Personal services Operating
$
Actual
44,536 35,086 79,622
$
34,579 22,807 57,386
Variance Favorable (Unfavorable)
$
9,957 12,279 22,236
Prior Year Actual
$
33,562 22,751 56,313
104,094 12,078 116,172
42,176 12,501
Total Executive
146,270 24,579 170,849
54,677
103,267 12,468 115,735
Finance Personal services Operating Capital Total Finance
408,780 128,983 537,763
265,048 103,694 368,742
143,732 25,289 169,021
254,924 105,843 7,235 368,002
Total Legal
39,485 39,485
25,617 25,617
13,868 13,868
2,598 20,632 23,230
Non Departmental: Operating
18,065
8,119
9,946
9,053
Total Administrative
845,784
576,036
269,748
572,333
184,700 91,844 18,000 294,544
100,090 25,559 2,800 128,449
84,610 66,285 15,200 166,095
102,502 95,919 198,421
Legal: Personal services Operating
Public Works/Utilities Utilities Administration Personal services Operating Capital Total Utilities Administration
- 12 -
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended June 30, 2015
Budget Vehicle Maintenance Personal services Operating Total Vehicle Maintenance
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
66,463 11,726 78,189
41,346 6,095 47,441
25,117 5,631 30,748
42,837 5,073 47,910
458,888 658,013 820,749 1,937,650
323,717 343,051 143,467 810,235
135,171 314,962 677,282 1,127,415
328,385 382,386 168,062 878,833
Total Wastewater operations
183,870 1,175,971 1,952,455 3,312,296
126,815 490,157 488,885 1,105,857
57,055 685,814 1,463,570 2,206,439
127,243 637,009 607,323 1,371,575
Total Public Works/Utilities
5,622,679
2,091,982
3,530,697
2,496,739
862,800
35,858
826,942
40,685
$ 7,331,263
$ 2,703,876
4,627,387
$ 3,109,757
Water/water plant operations Personal services Operating Capital Total Water/water plant operations Wastewater operations Personal services Operating Capital
Debt Services TOTAL EXPENDITURES
- 13 -
$
TOWN OF LANTANA, FLORIDA Investment Earnings Quarter Closing June 30, 2015 FLORIDA STATE BOARD OF ADMINISTRATION (SBA) October SBA Rate General Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
November
0.16% 2,194,123
December
0.16% 2,197,082
0.16% 2,197,368
2,662
January
February
March
April
May
June
0.17%
0.19%
0.19%
0.19%
0.20%
0.22%
2,198,664
2,199,011
2,199,389
2,194,123
2,197,676
2,198,002
2,198,321
Total 0.18%
0
297
286
307
326
319
344
347
378
399
2,662 3,002
2,197,082
2,197,368
2,197,676
2,198,002
2,198,321
2,198,664
2,199,011
2,199,389
2,199,787
2,199,787
1,718,340
1,724,641
1,724,865
1,725,108
1,725,363
1,722,102
1,677,172
1,677,436
1,677,724
1,718,340
Utility Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
6,068
1
(3,511)
(45,196)
(17,555)
(60,194) 2,326
233
225
241
256
250
265
265
288
303
1,724,641
1,724,865
1,725,108
1,725,363
1,722,102
1,677,172
1,677,436
1,677,724
1,660,473
1,660,473
1,084
0
0
-
3,511
48,712
48,719
48,728
1,084
3,511
45,196
17,555
-
0
4
8
8
9
65,178 30
-
3,511
48,712
48,719
48,728
66,292
66,292
-
-
-
-
-
-
4,346 (4,346) 1
Impact Fee Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
(1,084)
-
(0)
0 0
0
4,346
1
-
1998 Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
(4,346) 1
(1) -
1
1
638
0
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0
-
-
-
-
-
-
638
RR&I Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
0
(638) 0 0
(0) 0
-
-
-
-
-
-
-
(638) 0
-
-
-
-
-
-
-
(0)
- 14 -
October
November
December
January
February
March
April
May
June
Total
Bond Fund Beginning Bal.
2,662
Transfers In (Out) Admin. Charges Investment Earnings
0
0
(2,662)
-
-
-
-
-
2,662
(0)
0
Ending Bal.
-
-
-
-
-
-
-
-
-
(2,662) 0
-
-
-
-
-
-
-
(0)
0
0
531 531
511 511
549 549
581 581
570 570
613 613
619 619
674 674
711 711
5,359 5,359
297 234 531
286 225 511
307 241 549
326 256 581
319 251 570
344 270 613
347 272 619
378 296 674
399 313 711
3,002 2,357 5,359
0.20% 0.04% 126 101 6 (229)
0.20% 0.04% 120 98 6 (172)
0.20% 0.06% 1,733 1,204 57 (1,930)
SBA TOTALS Total Investment Earnings Total Admin. Charges Net Investment Earnings Investment Earnings Net of Admin. Charges General Fund Utility Fund
SUNTRUST BANK ACCOUNTS Checking Account Earnings Demand Deposit (earnings credit) Checking account APY General Fund Utility Fund Forfeiture Fund Bank Charges (net of interest credit) Investment Earnings
0.20% 0.07% 146 118 1 (316)
0.20% 0.07% 145 116 3 (293)
(50)
(30)
0.20% 0.07% 229 135 5 (105)
0.20% 0.07% 259 157 6 (244)
0.20% 0.07% 225 144 10 (137)
0.20% 0.07% 249 166 11 (211)
0.20% 0.07% 233 170 10 (222)
263
178
241
214
191
5
51
1,064
Ending Account Balances per Statement Operating Demand Deposit Water Plant Reserve Payment Card Receipts Forfeiture Fund Ending Balances
4,135,423 6,000,000 373,980 10,561
4,522,445 6,000,000 374,002 15,980 77,339
6,315,432 6,000,000 374,024 27,341 77,342
6,647,554 6,000,000 374,046 37,545 212,580
6,709,088 6,000,000 374,067 51,375 210,548
6,897,574 6,000,000 374,089 70,860 210,557
6,710,569 6,000,000 374,110 84,009 148,678
6,305,957 6,000,000 374,123 97,020 148,683
6,342,923 6,000,000 374,135 111,481 148,688
10,519,964
10,989,766
12,794,140
13,271,726
13,345,077
13,553,080
13,317,366
12,925,782
12,977,227
TD BANK ACCOUNT TD Bank Rate Investment Earnings (Utility Fund) Investment Earnings (General Fund) Investment Earnings
0.20% 482 340 823
Ending Balance
0.20% 460 329 790
4,843,613
0.20% 481 334 814
4,803,207
0.20% 483 340 823
4,887,826
0.20% 430 308 738
4,847,454
0.20% 487 338 826
4,806,996
0.20% 468 330 797
0.20% 476 341 817
0.20% 472 328 800
4,891,626
4,851,227
4,810,849
4,895,453
931 923 11 1,864
910 910 10 1,829
845 874 6 1,725
846 883 6 1,735
0.20% 4,240 2,988 7,228
TOTAL INVESTMENT EARNINGS BY FUND General Fund Utility Fund Forfeiture Fund $
784 834 1 1,619
$
761 801 3 1,564
$
870 857 5 1,732
$
926 895 6 1,827
- 15 -
$
852 824 10 1,686
$
$
$
$
$
7,724 7,801 57 15,581
