September 30, 2015
MEMORANDUM Finance Department 3. Net income for the fourth quarter was $904,454. Depreciation expense was not included in the financial reports and will alter net income for the fund. INVESTMENT REPORT On September 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.
Please contact me with any questions you may have.
-2-
BUDGET-IN-BRIEF as of September 30, 2015 (100% of year elapsed) YTD-Townwide Expense Allocation
Other Town Funds
Debt, 530,760 , 3% Benefits, 2,279,098 , 14% Operating & Maint., 3,915,552 , 25%
Wages, 4,893,583 , 31%
Capital, 4,300,368 , 27%
General Fund Revenues Revenues Budget Year-to-Date Taxes 4,961,175 4,798,485 Licenses & Permits 580,440 629,217 Assessments 675,206 678,324 Intergovernmental Revenue 2,411,158 1,256,549 Charges for Services 795,909 787,415 Fines & Forfeitures 154,897 320,564 Misc. Revenue 2,051,174 1,471,208 Appropriations & Carryover 1,738,439 Total Revenues $ 13,368,398 $ 9,941,762
% 96.7% 108.4% 100.5% 52.1% 98.9% 207.0% 71.7% 0.0% 74.4%
General Fund Expenditures Expenditures Budget Year-to-Date Town Council 119,443 108,721 Town Manager 191,122 181,178 Finance 339,246 308,519 Town Attorney 186,670 102,975 Non-Departmental 43,560 39,438 Police 4,479,065 4,319,747 Development Services 640,885 591,574
% 91.0% 94.8% 90.9% 55.2% 90.5% 96.4% 92.3%
Public Works Library Holiday Events Capital Outlay Debt Service Contingency Total Expenditures
Utility Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 5,219,344 2,129,474 7,348,818 7,348,818
Year-to-Date 5,397,982 5,397,982 4,493,530
% 103.4% 0.0% 73.5% 61.1%
Police Education Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 5,560 5,560 5,560
Year-to-Date 3,784 3,784 4,282
% 68.1% N/A 68.1% 77.0%
Police Forfeiture Fund* Budget Total Revenues Total Expenses *Per Florida Statute fund is not budgeted
Year-to-Date 131,054 6,009
% 0.0% 0.0%
Grants Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 167,084 (51,674) 115,410 115,410
Year-to-Date 36,365 36,365 36,579
% 21.8% 0.0% 31.5% 31.7%
Insurance Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 385,910 385,910 385,910
Year-to-Date 347,913 347,913 347,177
% 90.2% N/A 90.2% 90.0%
2,283,350
1,897,643
83.1%
153,600 42,170
141,098 38,428
91.9% 91.1%
4,346,887
2,872,928
66.1%
Total Townwide Budget
492,400
429,535
87.2%
(not including Police Forfeiture Fund)
50,000
-
0.0%
$ 13,368,398
$ 11,031,784
82.5%
Expenditures
-3-
YTD-Total Townwide Budget Budget Year-to-Date 21,224,096
15,913,352
% 75.0%
TOWN OF LANTANA, FLORIDA General Fund Balance Sheet (unaudited) September 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,092,460 2,210,994 17,570 14,126 550,027 416 10,885,593
Prior Year
$
$
7,632,840 2,196,785 3,642 11,564 1,542 9,846,373
1,159,850 109,068
165,749 4,618
227,908 816,741 2,313,567
188,178 272,401 630,946
8,572,026 8,572,026 10,885,593
9,215,427 9,215,427 9,846,373
$
TOWN OF LANTANA, FLORIDA General Fund Statement of Revenues, Expenditures and Changes in Fund Balance – Budget and Actual (unaudited) Period Ended September 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 2,411,158 795,909 154,897 1,989,689 11,568,474
$ 4,798,485 1,307,540 1,256,550 787,415 320,564 1,402,488 9,873,042
Variance Favorable (Unfavorable) $
(162,690) 51,894 (1,154,608) (8,494) 165,667 (587,201) (1,695,432)
Prior Year Actual $ 4,608,441 1,214,006 1,058,727 797,231 278,974 1,659,544 9,616,923
Expenditures: Current: General government Public safety Development services Physical environment Culture and recreation Capital outlay Debt service: Principal & Interest Total expenditures
881,628 4,456,636 640,885 282,046 2,197,074 4,367,729
740,833 4,319,747 591,573 230,045 1,847,125 2,872,930
140,795 136,889 49,312 52,001 349,949 1,494,799
1,365,786 4,073,146 556,026 1,280,917 857,653 437,483
492,400 13,368,398
429,535 11,031,788
62,865 2,336,610
429,535 9,000,546
Deficiency of revenues under expenditures
(1,799,924)
(1,158,746)
641,178
616,377
Other financing sources: Sale of general fixed assets Use of Fund Balance-capital carryfwd Use of Fund Balance-adopted Total other financing sources
61,485 706,530 1,031,909 1,799,924
Deficiency of revenues and other financing sources under expenditures
-
68,720 68,720 (1,090,026) 9,662,047 $ 8,572,026
Fund balance, beginning of year FUND BALANCE, END OF PERIOD
-5-
7,235 (706,530) (1,031,909) (1,731,204)
212,090 212,090 828,466 8,386,963 $ 9,215,427
TOWN OF LANTANA, FLORIDA General Fund Schedule of Revenues and Other Financing Sources – Budget and Actual (unaudited) Period Ended September 30, 2015
Budget
Actual
$ 2,245,434 1,106,624 1,082,096 252,644 274,377 4,961,175
$ 2,266,736 975,825 1,079,267 233,858 242,799 4,798,485
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) 21,302 (130,799) (2,829) (18,786) (31,578) (162,690)
$ 2,153,179 967,832 1,042,874 218,187 226,369 4,608,441
257,840 371,377 599,646 78,677 1,307,540
(4,452) 53,229 6,401 (3,284) 55,178
256,635 373,227 584,144 1,214,006
101,885 320,952 23,885 11,100 775,000 1,178,336 2,411,158
101,886 349,398 25,027 14,057 696,796 69,386 1,256,550
1 28,446 1,142 2,957 (78,204) (1,108,950) (1,154,608)
327,538 23,110 11,215 655,778 41,086 1,058,727
Charges for services: Public Safety Nature Preserve Maintenance Total charges for services
743,658 52,251 795,909
735,348 52,067 787,415
(8,310) (184) 8,494
745,845 51,386 797,231
Fines and forfeitures
154,897
320,564
Miscellaneous revenues: Interest Parking Contributions Leases Other Total miscellaneous revenues
8,770 190,975 1,534,519 174,683 80,742 1,989,689
23,425 288,770 784,668 205,922 99,703 1,402,488
14,655 97,795 (749,851) 31,239 18,961 (587,201)
13,498 202,245 1,023,500 241,579 178,722 1,659,544
Other financing sources: Sale of general fixed assets Interfund Transfers Capital Carryover Use of Fund Balance Total other financing sources TOTAL REVENUES
61,485 706,530 1,031,909 1,799,924 $ 13,368,398
68,720 68,720 $ 9,941,762
7,235 (706,530) (1,031,909) (1,731,204) $ (3,426,636)
212,090
-6-
$
Prior Year Actual
165,667
278,974
212,090 $ 9,829,013
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 30, 2015
Budget General government: Legislative: Personal services Operating Total Legislative
$
Actual
66,814 52,629 119,443
$
64,335 44,387 108,722
Variance Favorable (Unfavorable)
$
2,479 8,242 10,721
Prior Year Actual
$
62,276 42,129 104,405
Executive: Personal services Operating Total Executive
159,660 31,462 191,122
159,942 21,236 181,178
(282) 10,226 9,944
154,261 24,220 178,481
Finance: Personal services Operating Capital Total Finance
250,610 90,223 7,621 348,454
233,327 75,193 9,282 317,802
17,283 15,030 (1,661) 30,652
232,293 78,488 61,852 372,633
Legal Counsel: Personal services Operating Total Legal Counsel
186,670 186,670
102,975 102,975
83,695 83,695
10,411 109,614 120,025
42,560 45,552 1,000 89,112 934,801
38,938 500 39,438 750,115
3,622 45,552 500 49,674 184,686
651,594 500 652,094 1,427,638
Public Safety: Administration: Personal services Operating Capital Total Administration
408,660 69,828 32,716 511,204
410,145 61,202 32,819 504,166
Uniform Patrol: Personal services Operating Capital Total Uniform Patrol
2,345,650 193,798 42,180 2,581,628
2,246,410 177,902 40,647 2,464,959
Non-Departmental Operating Capital Other Expenses Total Non-Departmental Total General Government
-7-
(1,485) 8,626 (103) 7,038 99,240 15,896 1,533 116,669
395,934 63,342 2,205 461,481 2,080,115 193,408 19,189 2,292,712
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 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
248,944 16,969 6,325 272,238
(8,189) 7,918 (271)
232,559 22,325 68,428 323,312
Services: Personal services Operating Total Police Services
287,930 151,435 439,365
284,891 131,108 415,999
3,039 20,327 23,366
251,541 130,774 382,315
Uniform Patrol (Hypoluxo): Personal services Operating Total Uniform Patrol (Hypoluxo)
423,320 22,960 446,280
451,599 11,431 463,030
(28,279) 11,529 (16,750)
406,018 17,451 423,469
Marine Safety: Personal services Operating Capital Total Marine Safety
271,010 16,403 23,115 310,528
267,770 11,376 20,738 299,884
3,240 5,027 2,377 10,644
266,418 13,261 279,679
4,560,972
4,420,276
140,696
4,162,968
174,970 12,730 3,125 190,825
170,557 15,936 3,124 189,617
4,413 (3,206) 1 1,208
147,883 17,735 3,231 168,849
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
92,806 123,516 216,322
27,814 5,914 1,500 35,228
77,567 130,008 207,575
186,210 16,925 203,135
172,006 16,752 188,758
14,204 173 14,377
166,478 16,355 5,357 188,190
Total Development Services
645,510
594,697
50,813
564,614
-8-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 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
143,453 17,236 160,689
37,867 3,401 41,268
156,392 34,222 190,614
66,413 13,676 1,300 81,389
58,057 11,299 201 69,557
8,356 2,377 1,099 11,832
58,289 8,054 1,299 67,642
-
-
-
164,752 859,208 106,789 1,130,749
283,346
230,246
53,100
1,389,005
3,000 3,000
2,619 2,619
381 381
7,069 7,069
107,410 46,190 20,006 173,606
107,597 33,501 17,853 158,951
Streets & Grounds Maintenance: Personal services Operating Capital Total Streets & Grounds Maintenance
349,330 1,188,456 414,994 1,952,780
348,614 994,712 323,861 1,667,187
716 193,744 91,133 285,593
201,974 156,419 95,550 453,943
Facilities Maintenance: Personal services Operating Capital Total Facilities Maintenance
203,620 256,898 3,769,295 4,229,813
189,584 132,070 2,418,080 2,739,734
14,036 124,828 1,351,215 1,490,079
158,006 130,299 47,237 335,542
Miscellaneous: Holiday events Total Miscellaneous Total Culture and Recreation
42,170 42,170 6,401,369
38,428 38,428 4,606,919
3,742 3,742 1,794,450
54,759 54,759 1,026,786
492,400 50,000 $ 13,368,398
429,535 $ 11,031,788
62,865 50,000 2,336,610
429,535 9,000,546
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-
(187) 12,689 2,153 14,655
$
106,018 43,109 26,346 175,473
$
TOWN OF LANTANA, FLORIDA Utility Fund Balance Sheet (unaudited) September 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,106,016 1,672,143 157,164 440,844 278 9,376,445
Prior Year
903,234 19,365,210
6,536,997 1,718,340 140,252 380,026 262 8,775,877 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 18,766,346
414,412 3,880,709
265,181 4,637,990
235,904 203,565 28,670 4,763,260
210,641 235,708 27,760 5,377,280
2,445,897 12,156,053 14,601,950
2,445,897 10,943,169 13,389,066
19,365,210
$
18,766,346
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Revenues, Expenses and Changes in Retained Earnings – Budget and Actual (unaudited) Period Ended September 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 202,562 5,210,505
$
2,701,125 2,430,401 241,763 5,373,289
Variance Favorable (Unfavorable) $
99,431 24,152 39,201 162,784
$
2,486,083 2,304,131 158,553 4,948,767
901,377 2,352,306 3,253,683
832,123 1,360,989 2,193,112
845,784
775,929
69,855
765,267
Debt Services Capital outlay
862,800 2,386,551 3,249,351
101,225 1,423,262 1,524,487
761,575 963,289 1,724,864
120,094 1,459,063 1,579,157
Total operating expenses
7,348,818
4,493,528
2,855,290
4,671,879
Administrative expenses
Operating income/(loss)
69,254 991,317 1,060,571
Prior YTD Actual
808,137 1,519,318 2,327,455
(2,138,313)
879,761
(2,692,506)
276,888
Non-operating revenues (expenses) Investment income Sale of assets Use of reserves-capital carry forward
8,839 2,129,474
21,582 3,111 -
12,743 3,111 (2,129,474)
9,127 -
Total non-operating revenues (expenses)
2,138,313
24,693
(2,113,620)
9,127
-
904,454
Net income/(loss) Net assets, beginning Net assets, ending
13,697,498 $ 14,601,950
-11-
904,454
286,015 13,103,050 $ 13,389,066
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended September 30, 2015
Budget Administrative Legislative: Personal services Operating Total Legislative Executive: Personal services Operating
$
Actual
44,536 35,086 79,622
$
42,906 29,591 72,497
Variance Favorable (Unfavorable)
$
1,630 5,495 7,125
Prior Year Actual
$
41,545 28,052 69,597
145,904 15,690 161,594
366 8,889
Total Executive
146,270 24,579 170,849
9,255
139,592 18,883 158,475
Finance Personal services Operating Capital Total Finance
408,780 128,983 537,763
371,963 124,269 496,232
36,817 4,714 41,531
354,927 127,017 7,235 489,179
Total Legal
39,485 39,485
35,428 35,428
4,057 4,057
2,603 34,442 37,045
Non Departmental: Personal services Operating
18,065
10,178
7,887
10,971
Total Administrative
845,784
775,929
69,855
765,267
184,700 91,844 18,000 294,544
148,871 28,920 8,783 186,574
35,829 62,924 9,217 107,970
135,854 130,701 266,555
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 September 30, 2015
Budget Vehicle Maintenance Personal services Operating Total Vehicle Maintenance
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
66,463 11,726 78,189
58,044 9,837 67,881
8,419 1,889 10,308
57,508 9,037 66,545
464,399 914,666 576,500 1,955,565
450,241 557,311 254,351 1,261,903
14,158 357,355 322,149 693,662
443,378 544,821 276,835 1,265,034
Total Wastewater operations
185,815 1,334,070 1,792,051 3,311,936
174,967 764,921 1,160,128 2,100,016
10,848 569,149 631,923 1,211,920
171,397 834,759 1,182,228 2,188,384
Total Public Works/Utilities
5,640,234
3,616,374
2,023,860
3,786,518
862,800
101,225
761,575
120,094
$ 7,348,818
$ 4,493,528
2,855,290
$ 4,671,879
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 September 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%
0.16%
2,197,082
2,197,368
297
286
2,197,082
1,718,340
January
February
March
April
May
June
July
August
September
0.17%
0.19%
0.19%
0.19%
0.20%
0.22%
0.23%
0.25%
0.25%
Total 0.18%
2,197,676
2,198,002
2,198,321
2,198,664
2,199,011
2,199,389
2,199,787
2,210,075
2,210,543
2,194,123
307
326
319
344
347
378
399
10,288
468
451
2,662 14,209
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,210,075
2,210,543
2,210,994
2,210,994
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,671,448
1,671,802
1,718,340
2,662
0
Utility Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
6,068
1
(3,511)
(45,196)
(17,555)
(60,194) 13,996
233
225
241
256
250
265
265
288
303
10,976
354
341
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,671,448
1,671,802
1,672,143
1,672,143
1,084
0
0
-
3,511
48,712
48,719
48,728
66,292
66,643
66,657
1,084
3,511
45,196
-
0
4
8
8
9
351
14
14
65,178 409
-
3,511
48,712
48,719
48,728
66,292
66,643
66,657
66,671
66,671
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0
-
-
-
-
-
-
-
0
-
-
-
-
-
-
Impact Fee Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
(1,084)
-
(0)
0 0
0
4,346
1
-
17,555
1998 Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
(4,346) 1
(1) -
1
1
638
0
0
4,346
-
(4,346) 1 0
-
0
RR&I Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
0
(638) 0
(0) -
0
0
2,662
0
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0
638
(0)
(638) 0
-
(0)
Bond Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
0
(2,662) 0
(0) -
0
0
531 531
511 511
0
-
-
-
-
-
-
-
-
0
-
-
-
-
-
-
-
0
0
549 549
581 581
570 570
613 613
619 619
674 674
711 711
21,615 21,615
835 835
0
2,662
(0)
(2,662) 0
-
(0)
SBA TOTALS Total Investment Earnings Total Admin. Charges Net Investment Earnings
-14-
806 806
28,615 28,615
October Investment Earnings Net of Admin. Charges General Fund Utility Fund
November
297 234 531
December
286 225 511
January
307 241 549
February
326 256 581
March
319 251 570
April
344 270 613
May
June
July
347 272 619
378 296 674
399 313 711
0.20% 0.04% 126 101 6 (229)
0.20% 0.04% 120 98 6 (172)
August
10,288 11,327 21,615
September
Total
468 368 835
451 355 806
14,209 14,406 28,615
0.20% 0.04% 127 102 7 (224)
0.20% 0.04% 109 88 7 (144)
0.20% 0.06% 2,102 1,500 77 (2,650)
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
0.20% 0.04% 133 105 6 (352) (107)
12
60
1,029
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
6,726,927 6,000,000 374,148 25,115 148,693
6,279,512 6,000,000 374,161 33,989 148,698
5,360,686 6,000,000 374,173 44,190 148,703
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
13,274,883
12,836,360
11,927,752
TD BANK ACCOUNT TD Bank Rate Investment Earnings (Utility Fund) Investment Earnings (General Fund) Investment Earnings
0.20% 482 340 823
0.20% 460 329 790
0.20% 481 334 814
Ending Balance
4,843,613
4,803,207
4,887,826
General Fund Utility Fund Forfeiture Fund
784 834 1 1,619
761 801 3 1,564
870 857 5 1,732
0.20% 483 340 823
0.20% 430 308 738
4,847,454
0.20% 487 338 826
4,806,996
0.20% 468 330 797
4,891,626
0.20% 476 341 817
4,851,227
0.20% 472 328 800
0.20% 484 341 825
0.20% 477 341 818
0.20% 475 330 805
4,810,849
4,895,453
4,855,082
4,814,704
4,899,313
845 874 6 1,725
846 883 6 1,735
10,762 11,916 6 22,684
936 947 7 1,890
889 918 7 1,815
0.20% 5,676 3,999 9,675
TOTAL INVESTMENT EARNINGS BY FUND
$
$
$
$
926 895 6 1,827
$
852 824 10 1,686
$
-15-
931 923 11 1,864
$
910 910 10 1,829
$
$
$
$
$
$
20,310 21,582 77 41,970
Please contact me with any questions you may have.
-2-
BUDGET-IN-BRIEF as of September 30, 2015 (100% of year elapsed) YTD-Townwide Expense Allocation
Other Town Funds
Debt, 530,760 , 3% Benefits, 2,279,098 , 14% Operating & Maint., 3,915,552 , 25%
Wages, 4,893,583 , 31%
Capital, 4,300,368 , 27%
General Fund Revenues Revenues Budget Year-to-Date Taxes 4,961,175 4,798,485 Licenses & Permits 580,440 629,217 Assessments 675,206 678,324 Intergovernmental Revenue 2,411,158 1,256,549 Charges for Services 795,909 787,415 Fines & Forfeitures 154,897 320,564 Misc. Revenue 2,051,174 1,471,208 Appropriations & Carryover 1,738,439 Total Revenues $ 13,368,398 $ 9,941,762
% 96.7% 108.4% 100.5% 52.1% 98.9% 207.0% 71.7% 0.0% 74.4%
General Fund Expenditures Expenditures Budget Year-to-Date Town Council 119,443 108,721 Town Manager 191,122 181,178 Finance 339,246 308,519 Town Attorney 186,670 102,975 Non-Departmental 43,560 39,438 Police 4,479,065 4,319,747 Development Services 640,885 591,574
% 91.0% 94.8% 90.9% 55.2% 90.5% 96.4% 92.3%
Public Works Library Holiday Events Capital Outlay Debt Service Contingency Total Expenditures
Utility Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 5,219,344 2,129,474 7,348,818 7,348,818
Year-to-Date 5,397,982 5,397,982 4,493,530
% 103.4% 0.0% 73.5% 61.1%
Police Education Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 5,560 5,560 5,560
Year-to-Date 3,784 3,784 4,282
% 68.1% N/A 68.1% 77.0%
Police Forfeiture Fund* Budget Total Revenues Total Expenses *Per Florida Statute fund is not budgeted
Year-to-Date 131,054 6,009
% 0.0% 0.0%
Grants Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 167,084 (51,674) 115,410 115,410
Year-to-Date 36,365 36,365 36,579
% 21.8% 0.0% 31.5% 31.7%
Insurance Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 385,910 385,910 385,910
Year-to-Date 347,913 347,913 347,177
% 90.2% N/A 90.2% 90.0%
2,283,350
1,897,643
83.1%
153,600 42,170
141,098 38,428
91.9% 91.1%
4,346,887
2,872,928
66.1%
Total Townwide Budget
492,400
429,535
87.2%
(not including Police Forfeiture Fund)
50,000
-
0.0%
$ 13,368,398
$ 11,031,784
82.5%
Expenditures
-3-
YTD-Total Townwide Budget Budget Year-to-Date 21,224,096
15,913,352
% 75.0%
TOWN OF LANTANA, FLORIDA General Fund Balance Sheet (unaudited) September 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,092,460 2,210,994 17,570 14,126 550,027 416 10,885,593
Prior Year
$
$
7,632,840 2,196,785 3,642 11,564 1,542 9,846,373
1,159,850 109,068
165,749 4,618
227,908 816,741 2,313,567
188,178 272,401 630,946
8,572,026 8,572,026 10,885,593
9,215,427 9,215,427 9,846,373
$
TOWN OF LANTANA, FLORIDA General Fund Statement of Revenues, Expenditures and Changes in Fund Balance – Budget and Actual (unaudited) Period Ended September 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 2,411,158 795,909 154,897 1,989,689 11,568,474
$ 4,798,485 1,307,540 1,256,550 787,415 320,564 1,402,488 9,873,042
Variance Favorable (Unfavorable) $
(162,690) 51,894 (1,154,608) (8,494) 165,667 (587,201) (1,695,432)
Prior Year Actual $ 4,608,441 1,214,006 1,058,727 797,231 278,974 1,659,544 9,616,923
Expenditures: Current: General government Public safety Development services Physical environment Culture and recreation Capital outlay Debt service: Principal & Interest Total expenditures
881,628 4,456,636 640,885 282,046 2,197,074 4,367,729
740,833 4,319,747 591,573 230,045 1,847,125 2,872,930
140,795 136,889 49,312 52,001 349,949 1,494,799
1,365,786 4,073,146 556,026 1,280,917 857,653 437,483
492,400 13,368,398
429,535 11,031,788
62,865 2,336,610
429,535 9,000,546
Deficiency of revenues under expenditures
(1,799,924)
(1,158,746)
641,178
616,377
Other financing sources: Sale of general fixed assets Use of Fund Balance-capital carryfwd Use of Fund Balance-adopted Total other financing sources
61,485 706,530 1,031,909 1,799,924
Deficiency of revenues and other financing sources under expenditures
-
68,720 68,720 (1,090,026) 9,662,047 $ 8,572,026
Fund balance, beginning of year FUND BALANCE, END OF PERIOD
-5-
7,235 (706,530) (1,031,909) (1,731,204)
212,090 212,090 828,466 8,386,963 $ 9,215,427
TOWN OF LANTANA, FLORIDA General Fund Schedule of Revenues and Other Financing Sources – Budget and Actual (unaudited) Period Ended September 30, 2015
Budget
Actual
$ 2,245,434 1,106,624 1,082,096 252,644 274,377 4,961,175
$ 2,266,736 975,825 1,079,267 233,858 242,799 4,798,485
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) 21,302 (130,799) (2,829) (18,786) (31,578) (162,690)
$ 2,153,179 967,832 1,042,874 218,187 226,369 4,608,441
257,840 371,377 599,646 78,677 1,307,540
(4,452) 53,229 6,401 (3,284) 55,178
256,635 373,227 584,144 1,214,006
101,885 320,952 23,885 11,100 775,000 1,178,336 2,411,158
101,886 349,398 25,027 14,057 696,796 69,386 1,256,550
1 28,446 1,142 2,957 (78,204) (1,108,950) (1,154,608)
327,538 23,110 11,215 655,778 41,086 1,058,727
Charges for services: Public Safety Nature Preserve Maintenance Total charges for services
743,658 52,251 795,909
735,348 52,067 787,415
(8,310) (184) 8,494
745,845 51,386 797,231
Fines and forfeitures
154,897
320,564
Miscellaneous revenues: Interest Parking Contributions Leases Other Total miscellaneous revenues
8,770 190,975 1,534,519 174,683 80,742 1,989,689
23,425 288,770 784,668 205,922 99,703 1,402,488
14,655 97,795 (749,851) 31,239 18,961 (587,201)
13,498 202,245 1,023,500 241,579 178,722 1,659,544
Other financing sources: Sale of general fixed assets Interfund Transfers Capital Carryover Use of Fund Balance Total other financing sources TOTAL REVENUES
61,485 706,530 1,031,909 1,799,924 $ 13,368,398
68,720 68,720 $ 9,941,762
7,235 (706,530) (1,031,909) (1,731,204) $ (3,426,636)
212,090
-6-
$
Prior Year Actual
165,667
278,974
212,090 $ 9,829,013
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 30, 2015
Budget General government: Legislative: Personal services Operating Total Legislative
$
Actual
66,814 52,629 119,443
$
64,335 44,387 108,722
Variance Favorable (Unfavorable)
$
2,479 8,242 10,721
Prior Year Actual
$
62,276 42,129 104,405
Executive: Personal services Operating Total Executive
159,660 31,462 191,122
159,942 21,236 181,178
(282) 10,226 9,944
154,261 24,220 178,481
Finance: Personal services Operating Capital Total Finance
250,610 90,223 7,621 348,454
233,327 75,193 9,282 317,802
17,283 15,030 (1,661) 30,652
232,293 78,488 61,852 372,633
Legal Counsel: Personal services Operating Total Legal Counsel
186,670 186,670
102,975 102,975
83,695 83,695
10,411 109,614 120,025
42,560 45,552 1,000 89,112 934,801
38,938 500 39,438 750,115
3,622 45,552 500 49,674 184,686
651,594 500 652,094 1,427,638
Public Safety: Administration: Personal services Operating Capital Total Administration
408,660 69,828 32,716 511,204
410,145 61,202 32,819 504,166
Uniform Patrol: Personal services Operating Capital Total Uniform Patrol
2,345,650 193,798 42,180 2,581,628
2,246,410 177,902 40,647 2,464,959
Non-Departmental Operating Capital Other Expenses Total Non-Departmental Total General Government
-7-
(1,485) 8,626 (103) 7,038 99,240 15,896 1,533 116,669
395,934 63,342 2,205 461,481 2,080,115 193,408 19,189 2,292,712
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 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
248,944 16,969 6,325 272,238
(8,189) 7,918 (271)
232,559 22,325 68,428 323,312
Services: Personal services Operating Total Police Services
287,930 151,435 439,365
284,891 131,108 415,999
3,039 20,327 23,366
251,541 130,774 382,315
Uniform Patrol (Hypoluxo): Personal services Operating Total Uniform Patrol (Hypoluxo)
423,320 22,960 446,280
451,599 11,431 463,030
(28,279) 11,529 (16,750)
406,018 17,451 423,469
Marine Safety: Personal services Operating Capital Total Marine Safety
271,010 16,403 23,115 310,528
267,770 11,376 20,738 299,884
3,240 5,027 2,377 10,644
266,418 13,261 279,679
4,560,972
4,420,276
140,696
4,162,968
174,970 12,730 3,125 190,825
170,557 15,936 3,124 189,617
4,413 (3,206) 1 1,208
147,883 17,735 3,231 168,849
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
92,806 123,516 216,322
27,814 5,914 1,500 35,228
77,567 130,008 207,575
186,210 16,925 203,135
172,006 16,752 188,758
14,204 173 14,377
166,478 16,355 5,357 188,190
Total Development Services
645,510
594,697
50,813
564,614
-8-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 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
143,453 17,236 160,689
37,867 3,401 41,268
156,392 34,222 190,614
66,413 13,676 1,300 81,389
58,057 11,299 201 69,557
8,356 2,377 1,099 11,832
58,289 8,054 1,299 67,642
-
-
-
164,752 859,208 106,789 1,130,749
283,346
230,246
53,100
1,389,005
3,000 3,000
2,619 2,619
381 381
7,069 7,069
107,410 46,190 20,006 173,606
107,597 33,501 17,853 158,951
Streets & Grounds Maintenance: Personal services Operating Capital Total Streets & Grounds Maintenance
349,330 1,188,456 414,994 1,952,780
348,614 994,712 323,861 1,667,187
716 193,744 91,133 285,593
201,974 156,419 95,550 453,943
Facilities Maintenance: Personal services Operating Capital Total Facilities Maintenance
203,620 256,898 3,769,295 4,229,813
189,584 132,070 2,418,080 2,739,734
14,036 124,828 1,351,215 1,490,079
158,006 130,299 47,237 335,542
Miscellaneous: Holiday events Total Miscellaneous Total Culture and Recreation
42,170 42,170 6,401,369
38,428 38,428 4,606,919
3,742 3,742 1,794,450
54,759 54,759 1,026,786
492,400 50,000 $ 13,368,398
429,535 $ 11,031,788
62,865 50,000 2,336,610
429,535 9,000,546
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-
(187) 12,689 2,153 14,655
$
106,018 43,109 26,346 175,473
$
TOWN OF LANTANA, FLORIDA Utility Fund Balance Sheet (unaudited) September 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,106,016 1,672,143 157,164 440,844 278 9,376,445
Prior Year
903,234 19,365,210
6,536,997 1,718,340 140,252 380,026 262 8,775,877 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 18,766,346
414,412 3,880,709
265,181 4,637,990
235,904 203,565 28,670 4,763,260
210,641 235,708 27,760 5,377,280
2,445,897 12,156,053 14,601,950
2,445,897 10,943,169 13,389,066
19,365,210
$
18,766,346
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Revenues, Expenses and Changes in Retained Earnings – Budget and Actual (unaudited) Period Ended September 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 202,562 5,210,505
$
2,701,125 2,430,401 241,763 5,373,289
Variance Favorable (Unfavorable) $
99,431 24,152 39,201 162,784
$
2,486,083 2,304,131 158,553 4,948,767
901,377 2,352,306 3,253,683
832,123 1,360,989 2,193,112
845,784
775,929
69,855
765,267
Debt Services Capital outlay
862,800 2,386,551 3,249,351
101,225 1,423,262 1,524,487
761,575 963,289 1,724,864
120,094 1,459,063 1,579,157
Total operating expenses
7,348,818
4,493,528
2,855,290
4,671,879
Administrative expenses
Operating income/(loss)
69,254 991,317 1,060,571
Prior YTD Actual
808,137 1,519,318 2,327,455
(2,138,313)
879,761
(2,692,506)
276,888
Non-operating revenues (expenses) Investment income Sale of assets Use of reserves-capital carry forward
8,839 2,129,474
21,582 3,111 -
12,743 3,111 (2,129,474)
9,127 -
Total non-operating revenues (expenses)
2,138,313
24,693
(2,113,620)
9,127
-
904,454
Net income/(loss) Net assets, beginning Net assets, ending
13,697,498 $ 14,601,950
-11-
904,454
286,015 13,103,050 $ 13,389,066
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended September 30, 2015
Budget Administrative Legislative: Personal services Operating Total Legislative Executive: Personal services Operating
$
Actual
44,536 35,086 79,622
$
42,906 29,591 72,497
Variance Favorable (Unfavorable)
$
1,630 5,495 7,125
Prior Year Actual
$
41,545 28,052 69,597
145,904 15,690 161,594
366 8,889
Total Executive
146,270 24,579 170,849
9,255
139,592 18,883 158,475
Finance Personal services Operating Capital Total Finance
408,780 128,983 537,763
371,963 124,269 496,232
36,817 4,714 41,531
354,927 127,017 7,235 489,179
Total Legal
39,485 39,485
35,428 35,428
4,057 4,057
2,603 34,442 37,045
Non Departmental: Personal services Operating
18,065
10,178
7,887
10,971
Total Administrative
845,784
775,929
69,855
765,267
184,700 91,844 18,000 294,544
148,871 28,920 8,783 186,574
35,829 62,924 9,217 107,970
135,854 130,701 266,555
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 September 30, 2015
Budget Vehicle Maintenance Personal services Operating Total Vehicle Maintenance
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
66,463 11,726 78,189
58,044 9,837 67,881
8,419 1,889 10,308
57,508 9,037 66,545
464,399 914,666 576,500 1,955,565
450,241 557,311 254,351 1,261,903
14,158 357,355 322,149 693,662
443,378 544,821 276,835 1,265,034
Total Wastewater operations
185,815 1,334,070 1,792,051 3,311,936
174,967 764,921 1,160,128 2,100,016
10,848 569,149 631,923 1,211,920
171,397 834,759 1,182,228 2,188,384
Total Public Works/Utilities
5,640,234
3,616,374
2,023,860
3,786,518
862,800
101,225
761,575
120,094
$ 7,348,818
$ 4,493,528
2,855,290
$ 4,671,879
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 September 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%
0.16%
2,197,082
2,197,368
297
286
2,197,082
1,718,340
January
February
March
April
May
June
July
August
September
0.17%
0.19%
0.19%
0.19%
0.20%
0.22%
0.23%
0.25%
0.25%
Total 0.18%
2,197,676
2,198,002
2,198,321
2,198,664
2,199,011
2,199,389
2,199,787
2,210,075
2,210,543
2,194,123
307
326
319
344
347
378
399
10,288
468
451
2,662 14,209
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,210,075
2,210,543
2,210,994
2,210,994
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,671,448
1,671,802
1,718,340
2,662
0
Utility Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
6,068
1
(3,511)
(45,196)
(17,555)
(60,194) 13,996
233
225
241
256
250
265
265
288
303
10,976
354
341
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,671,448
1,671,802
1,672,143
1,672,143
1,084
0
0
-
3,511
48,712
48,719
48,728
66,292
66,643
66,657
1,084
3,511
45,196
-
0
4
8
8
9
351
14
14
65,178 409
-
3,511
48,712
48,719
48,728
66,292
66,643
66,657
66,671
66,671
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0
-
-
-
-
-
-
-
0
-
-
-
-
-
-
Impact Fee Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
(1,084)
-
(0)
0 0
0
4,346
1
-
17,555
1998 Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
(4,346) 1
(1) -
1
1
638
0
0
4,346
-
(4,346) 1 0
-
0
RR&I Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
0
(638) 0
(0) -
0
0
2,662
0
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0
638
(0)
(638) 0
-
(0)
Bond Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
0
(2,662) 0
(0) -
0
0
531 531
511 511
0
-
-
-
-
-
-
-
-
0
-
-
-
-
-
-
-
0
0
549 549
581 581
570 570
613 613
619 619
674 674
711 711
21,615 21,615
835 835
0
2,662
(0)
(2,662) 0
-
(0)
SBA TOTALS Total Investment Earnings Total Admin. Charges Net Investment Earnings
-14-
806 806
28,615 28,615
October Investment Earnings Net of Admin. Charges General Fund Utility Fund
November
297 234 531
December
286 225 511
January
307 241 549
February
326 256 581
March
319 251 570
April
344 270 613
May
June
July
347 272 619
378 296 674
399 313 711
0.20% 0.04% 126 101 6 (229)
0.20% 0.04% 120 98 6 (172)
August
10,288 11,327 21,615
September
Total
468 368 835
451 355 806
14,209 14,406 28,615
0.20% 0.04% 127 102 7 (224)
0.20% 0.04% 109 88 7 (144)
0.20% 0.06% 2,102 1,500 77 (2,650)
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
0.20% 0.04% 133 105 6 (352) (107)
12
60
1,029
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
6,726,927 6,000,000 374,148 25,115 148,693
6,279,512 6,000,000 374,161 33,989 148,698
5,360,686 6,000,000 374,173 44,190 148,703
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
13,274,883
12,836,360
11,927,752
TD BANK ACCOUNT TD Bank Rate Investment Earnings (Utility Fund) Investment Earnings (General Fund) Investment Earnings
0.20% 482 340 823
0.20% 460 329 790
0.20% 481 334 814
Ending Balance
4,843,613
4,803,207
4,887,826
General Fund Utility Fund Forfeiture Fund
784 834 1 1,619
761 801 3 1,564
870 857 5 1,732
0.20% 483 340 823
0.20% 430 308 738
4,847,454
0.20% 487 338 826
4,806,996
0.20% 468 330 797
4,891,626
0.20% 476 341 817
4,851,227
0.20% 472 328 800
0.20% 484 341 825
0.20% 477 341 818
0.20% 475 330 805
4,810,849
4,895,453
4,855,082
4,814,704
4,899,313
845 874 6 1,725
846 883 6 1,735
10,762 11,916 6 22,684
936 947 7 1,890
889 918 7 1,815
0.20% 5,676 3,999 9,675
TOTAL INVESTMENT EARNINGS BY FUND
$
$
$
$
926 895 6 1,827
$
852 824 10 1,686
$
-15-
931 923 11 1,864
$
910 910 10 1,829
$
$
$
$
$
$
20,310 21,582 77 41,970
