September 30, 2013
MEMORANDUM Finance Department 3. Net income for the fiscal quarter was $1,940,473 which was a result of a onetime extraordinary income of $1.3 million from the City of Lake Worth legal settlement. Depreciation expense has not been calculated at this time which may 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 and Fund B), 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 superior financial condition. OTHER FUNDS This report does not incorporate some of the Town’s smaller special revenue and internal service funds. These funds include the Police Education, Police Forfeiture, Grants, and Insurance. If you would like a review of these funds, please contact me at (561) 540-5035.
STATE BOARD OF ADMINISTRATION LOCAL GOVERNMENT SURPLUS TRUST FUNDS INVESTMENT POOL As of September 30th, $326,410 was in the Florida Prime account which is liquid and available for withdrawal. In Fund B, the Town’s balance was $90,275 which is not liquid nor is it available for withdrawal. The total unrealized gain is $11,972 for all accounts. If you have any questions, please do not hesitate to contact me.
BUDGET-IN-BRIEF as of September 30, 2013 (100% of year elapsed) YTD-Townwide Expense Allocation
Capital, 1,899,872 , 14%
Other Town Funds
Debt, 626,140 , 5% Wages, 4,764,242 , 37%
Operating & Maint., 3,603,817 , 28%
Benefits, 2,121,176 , 16%
General Fund Revenues Revenues Budget Year-to-Date Taxes 4,376,125 4,089,548 Licenses & Permits 443,520 557,304 Intergovernmental Revenue 1,022,636 966,617 Charges for Services 1,610,398 1,516,364 Fines & Forfeitures 99,415 131,548 Misc. Revenue 725,535 754,797 Appropriations & Carryover 1,172,463 Total Revenues $ 9,450,092 $ 8,016,178
% 93.5% 125.7% 94.5% 94.2% 132.3% 104.0% 0.0% 84.8%
General Fund Expenditures Expenditures Budget Year-to-Date Town Council 74,820 67,332 Town Manager 184,068 179,970 Finance 331,641 295,401 Town Attorney 178,534 151,036 Non-Departmental 216,522 172,044 Police 3,750,474 3,613,485 Development Services 605,680 555,256 Operations Department 2,167,440 1,993,850
% 90.0% 97.8% 89.1% 84.6% 79.5% 96.3% 91.7% 92.0%
Library Holiday Events Capital Outlay Debt Service Total Expenditures
149,047
139,314
93.5%
47,500 1,314,216
31,263 853,037
65.8% 64.9%
430,150 $
9,450,092
$
Utility Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 6,358,244 1,408,547 7,766,791 7,766,791
Year-to-Date 6,098,756 6,098,756 4,140,584
% 95.9% 0.0% 78.5% 53.3%
Police Education Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 2,761 1,839 4,600 4,600
Year-to-Date 3,810 3,810 1,628
% 138.0% 0.0% 82.8% 35.4%
Police Forfeiture Fund* Budget Total Revenues Total Expenses *Per Florida Statute fund is not budgeted
Year-to-Date 1,570 6,870
% 0.0% 0.0%
Grants Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 354,726 354,726 354,726
Year-to-Date 70,131 70,131 70,131
% 19.8% N/A 19.8% 19.8%
Insurance Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 397,743 397,743 397,743
Year-to-Date 355,435 355,435 314,511
% 89.4% N/A 89.4% 79.1%
Expenditures
YTD-Total Townwide Budget Budget Year-to-Date
429,535
99.9%
Total Townwide Budget
8,481,523
89.8%
(not including Police Forfeiture Fund)
17,973,952
13,008,377
% 72.4%
TOWN OF LANTANA, FLORIDA General Fund Balance Sheet (unaudited) September 30, 2013 Prior Year
Current Year Assets and Other Debits: Assets: Cash and cash equivalents Investments Accounts 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 Revenue refunding bonds Deferred revenue Total liabilities Fund balances: Assigned for Encumbrances Unassigned, assigned, committed Total equity and other credits Total liabilities, equity and other credits
$
8,273,352 241,940 36,365 11,274 210 8,563,141
$
$
8,352,626 281,242 41,906 11,364 8,687,137
149,136 7,205
283,432 6,474
167,958 356,137 680,436
162,057 373,309 825,272
5,054 7,877,651 7,882,705 8,563,141
7,861,865 7,861,865 8,687,137
$
TOWN OF LANTANA, FLORIDA General Fund Statement of Revenues, Expenditures and Changes in Fund Balance – Budget and Actual (unaudited) Period Ended September 30, 2013
Revenues: Taxes Licenses and permits Intergovernmental Charges for services Fines and forfeitures Miscellaneous Total revenues Expenditures: Current: General government Public safety Development services Physical environment Culture and recreation Capital outlay Debt service: Principal & Interest General contingency Total expenditures Deficiency of revenues under expenditures Other financing sources: Sale of general fixed assets Operating transfers in Operating transfers out 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
Variance Favorable (Unfavorable)
Prior Year Actual
Budget
Actual
$ 4,376,125 443,520 1,022,636 1,610,398 99,415 719,535 8,271,629
$ 4,089,547 557,304 966,618 1,516,364 131,548 747,618 8,008,999
985,586 3,750,474 605,680 1,124,709 1,239,278 1,314,215
865,781 3,613,484 555,257 1,015,858 1,148,569 853,038
119,805 136,990 50,423 108,851 90,709 461,177
753,862 3,570,621 506,359 1,003,324 1,267,667 3,067,949
430,150 9,450,092
429,535 8,481,522
615 968,570
429,535 10,599,317
705,940
(2,360,259)
(1,178,463) 6,000 1,072,793 99,670 1,178,463 -
(472,523) 7,181 7,181 (465,342) 8,348,051 $ 7,882,705
$
(286,578) 113,784 (56,018) (94,034) 32,133 28,083 (262,630)
1,181 (1,072,793) (99,670) (1,171,282)
$ 4,103,126 577,579 966,118 1,541,946 133,460 916,829 8,239,058
538,883 (515,883) 23,000 (2,337,260) 10,199,126 $ 7,861,865
TOWN OF LANTANA, FLORIDA General Fund Schedule of Revenues and Other Financing Sources – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget
Actual
$ 2,120,000 666,158 999,853 325,605 264,509 4,376,125
$ 2,105,853 559,222 942,910 262,524 219,038 4,089,547
263,177 180,343 443,520
Intergovernmental revenues: State revenue sharing Mobile home licenses Alcoholic beverage licenses Local government ½ cent sales tax Government grants Total intergovernmental revenues Charges for services: Sanitation and waste removal Recycling fees Public Safety Nature Preserve Maintenance Total charges for services
Taxes: Ad Valorem taxes Franchise taxes Utility service taxes Local Communications Services Tax Gasoline taxes Total taxes
Variance Favorable (Unfavorable) (14,147) (106,936) (56,943) (63,081) (45,471) (286,578)
$ 2,181,084 516,026 902,998 280,289 222,729 4,103,126
255,284 302,020 557,304
(7,893) 121,677 113,784
252,548 325,031 577,579
297,000 21,251 11,020 669,500 23,865 1,022,636
310,382 21,490 9,831 605,087 19,828 966,618
13,382 239 (1,189) (64,413) (4,037) (56,018)
321,707 23,203 10,747 574,834 35,627 966,118
767,483 105,816 686,619 50,480 1,610,398
704,879 73,047 687,762 50,676 1,516,364
(62,604) (32,769) 1,143 196 94,034
728,281 99,609 664,322 49,734 1,541,946
99,415
131,548
32,133
133,460
Miscellaneous revenues: Interest Beach parking Contributions Leases Other Total miscellaneous revenues
11,080 119,736 2,150 478,397 108,172 719,535
21,271 157,878 3,650 478,645 86,174 747,618
10,191 38,142 1,500 248 (21,998) 28,083
38,985 195,470 14,400 420,131 247,843 916,829
Other financing sources: Sale of general fixed assets Interfund Transfers Capital Carryover Use of Fund Balance Loan Proceeds Total other financing sources TOTAL REVENUES
6,000 1,072,793 99,670 1,178,463 $ 9,450,092
7,181 7,181 $ 8,016,180
1,181 (1,072,793) (99,670) (1,171,282) $ (1,433,912)
538,883 538,883 $ 8,777,941
Licenses and permits: Business services taxes Building and other permits Total licenses and permits
Fines and forfeitures
$
Prior Year Actual
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget General government: Legislative: Personal services Operating Total Legislative
$
64,515 10,305 74,820
Actual
$
55,217 12,113 67,330
Variance Favorable (Unfavorable)
$
9,298 (1,808) 7,490
Prior Year Actual
$
66,354 10,908 77,262
Executive: Personal services Operating Capital Total Executive
102,290 12,789 3,850 118,929
105,733 8,788 3,851 118,372
(3,443) 4,001 (1) 557
103,633 13,595 117,228
Town Clerk: Personal services Operating Capital Total Town Clerk
45,925 23,065 68,990
45,027 20,422 65,449
898 2,643 3,541
45,150 16,120 61,270
Financial Administration: Personal services Operating Capital Total Financial Administration
239,480 92,161 57,760 389,401
225,119 70,282 1,851 297,252
14,361 21,879 55,909 92,149
210,628 72,855 4,559 288,042
Legal Counsel: Personal services Operating Total Legal Counsel
11,695 166,839 178,534
11,594 139,442 151,036
101 27,397 27,498
11,228 145,467 156,695
215,522 45,552 1,000 262,074 1,092,748
171,544 500 172,044 871,483
43,978 45,552 500 90,030 221,265
57,424 2,157,761 500 2,215,685 2,916,182
383,420 76,415 50,921 510,756
385,079 70,471 42,853 498,403
Non-Departmental Personal services Operating Capital Other Expenses Total Non-Departmental Total General Government Public Safety: Administration: Personal services Operating Capital Total Administration
(1,659) 5,944 8,068 12,353
398,969 66,827 9,679 475,475
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
Uniform Patrol: Personal services Operating Capital Total Uniform Patrol
2,121,205 180,087 152,588 2,453,880
2,032,604 174,480 134,278 2,341,362
Services: Personal services Operating Capital Total Police Services
439,650 154,179 7,500 601,329
439,815 119,361 6,555 565,731
(165) 34,818 945 35,598
425,023 149,409 574,432
Uniform Patrol (Hypoluxo): Personal services Operating Capital Total Uniform Patrol (Hypoluxo)
374,265 21,253 2,950 398,468
373,552 18,122 391,674
713 3,131 2,950 6,794
353,965 22,133 30,546 406,644
3,964,433
3,797,170
167,263
3,701,077
172,260 15,259 2,538 190,057
165,291 14,052 1,173 180,516
6,969 1,207 1,365 9,541
87,855 14,191 102,046
Total Public Safety Development Services: Administration : Personal services Operating Capital Total Administration
88,601 5,607 18,310 112,518
1,978,501 175,794 90,231 2,244,526
Building Inspections: Personal services Operating Capital Total Building Inspections Code Enforcement: Personal services Operating Capital Total Code Enforcement
121,150 109,067 12,000 242,217
100,411 109,120 209,531
20,739 (53) 12,000 32,686
117,905 109,952 13,637 241,494
169,195 18,749 187,944
150,454 15,929 166,383
18,741 2,820 21,561
159,760 16,696 639 177,095
Total Development Services
620,218
556,430
63,788
520,635
Physical Environment: Operations Administration Personal services Operating Capital Total Operations Administration
153,791 14,423 168,214
158,575 11,795 170,370
(4,784) 2,628 (2,156)
120,034 11,852 1,237 133,123
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget Vehicle Maintenance: Personal services Operating Capital Total Vehicle Maintenance
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
64,510 14,448 4,000 82,958
66,656 19,049 3,461 89,166
(2,146) (4,601) 539 (6,208)
62,216 8,791 71,007
Solid waste control services: Personal services Operating Capital Total Solid Waste Control Services
145,917 49,056 194,973
114,355 35,095 149,450
31,562 13,961 45,523
203,143 65,813 268,956
Trash Collection: Personal services Operating Capital Total Trash Collection
156,444 61,233 217,677
132,735 54,676 187,411
23,709 6,557 30,266
227,681 81,284 308,965
Recycling Collection: Personal services Operating Capital Total Recycling Collection
43,414 9,660 53,074
36,576 9,518 46,094
6,838 142 6,980
46,310 11,130 57,440
Streets & Highways: Personal services Operating Capital Total Streets & Highways
69,307 342,506 510,774 922,587
53,629 323,199 420,633 797,461
15,678 19,307 90,141 125,126
165,070 596,111 761,181
1,639,483
1,439,952
199,531
1,600,672
11,412 122,300 133,712
10,919 121,957 132,876
493 343 836
9,016 121,957 130,973
Library: Personal services Operating Capital Total library Services
105,180 43,867 37,200 186,247
104,402 34,913 17,522 156,837
778 8,954 19,678 29,410
102,737 35,715 21,780 160,232
Marine Services: Personal services Operating Capital Total Marine Services
265,281 14,368 43,111 322,760
265,391 12,503 19,995 297,889
(110) 1,865 23,116 24,871
312,452 12,100 24,598 349,150
Total Physical Environment Cultural and Recreation: Sports complex: Operating Debt service Total Sports Complex Services
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
Public Grounds & Forestry: Personal services Operating Capital Total Public Grounds & Forestry
305,625 152,851 180,274 638,750
285,219 131,035 102,826 519,080
20,406 21,816 77,448 119,670
306,443 128,351 55,819 490,613
Facilities Maintenance: Personal services Operating Capital Total Building Maintenance
153,995 139,199 203,197 496,391
144,497 128,428 98,040 370,965
9,498 10,771 105,157 125,426
169,374 148,471 61,352 379,197
Miscellaneous: Holiday events Total Miscellaneous Total Culture and Recreation
47,500 47,500 1,825,360
31,262 31,262 1,508,909
16,238 16,238 316,451
43,008 43,008 1,553,173
Debt Service Transfers Out General Contingency TOTAL EXPENDITURES
307,850 9,450,092
307,578 8,481,522
272 968,569
307,578 515,883 $ 11,115,200
$
$
$
TOWN OF LANTANA, FLORIDA Utility Fund Balance Sheet (unaudited) September 30, 2013 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 Other liabilities 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
$
4,300 509,892 20,486,913 810,847 19,142 193,821 22,024,915 (12,513,800) 9,511,115
Less accumulated depreciation & amortization Net fixed assets Unamortized bond costs Total assets and other debits
8,097,681 238,686 141,131 411,977 140 8,889,615
Prior Year
$
1,261,785 19,662,515
8,744,184 283,738 160,581 411,511 9,600,013 4,300 509,892 20,480,143 808,302 19,142 12,953 21,834,732 (11,757,547) 10,077,185
$
1,428,758 21,105,956
225,156 5,376,657 -
1,267,655 1,897,201 553,196
186,546 226,646 26,805 6,041,810
178,065 208,186 5,283,129 9,387,432
2,445,897 4,482 11,170,326 13,620,705
2,445,897 1,614,405 7,658,222 11,718,524
19,662,515
$
21,105,956
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Revenues, Expenses and Changes in Retained Earnings – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget Revenues: Water sales Wastewater sales Miscellaneous Total operating revenues Expenditures: Operating expenses Water/Sewer plant operations Personnel Current expenses Total
$
Variance Favorable (Unfavorable)
Actual
2,445,022 2,402,110 140,671 4,987,803
$
2,314,537 2,238,424 164,792 4,717,753
$
(130,485) (163,686) 24,121 (270,050)
$
2,286,690 2,325,347 148,932 4,760,969
784,595 1,742,581 2,527,176
761,598 1,439,220 2,200,818
874,684
734,838
139,846
738,446
Debt Services Capital outlay
1,073,378 3,291,553 4,364,931
196,605 1,026,019 1,222,624
876,773 2,265,534 3,142,307
772,644 372,370 1,145,014
Total operating expenses
7,766,791
4,158,280
3,608,511
4,316,867
Administrative expenses
Operating income/(loss) Non-operating revenues (expenses) Investment income Sale of assets Settlements-Lake Worth Operating Transfers Out Retained Earnings-capital carryforward Total non-operating revenues (expenses) Net income/(loss) Net assets, beginning Net assets, ending
22,997 303,361 326,358
Prior YTD Actual
(2,778,988)
559,473
8,441 1,362,000
18,847 1,362,153
1,408,547
-
(1,408,547)
34,356 (23,000) -
2,778,988
1,381,000
(1,397,988)
11,356
-
1,940,473
1,940,473
455,458
11,680,232 $ 13,620,705
(3,878,561)
729,318 1,704,089 2,433,407
10,406 153
444,102
11,263,064 $ 11,718,524
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget Administrative Legislative: Personal services Operating Total legislative Executive: Personal services Operating Capital
$
43,010 6,870 49,880
Actual
$
36,812 8,080 44,892
Variance Favorable (Unfavorable)
$
6,198 (1,210) 4,988
Prior Year Actual
$
44,236 6,991 51,227
102,285 12,789 115,074
105,728 8,853 114,581
(3,443) 3,936 493
103,384 13,522 116,906
Town Clerk: Personal services Operating
30,620 15,375
30,013 13,711
607 1,664
30,047 10,747
Total Town Clerk
45,995
43,724
2,271
40,794
393,020 170,877 4,983 568,880
360,600 111,345 4,891 476,836
32,420 59,532 92 92,044
344,036 110,401 2,426 456,863
2,950 80,655 83,605
2,921 42,051 44,972
29 38,604 38,633
2,807 60,055 62,862
11,250 11,250
9,833 9,833
1,417 1,417
9,794 9,794
874,684
734,838
139,846
738,446
Total executive
Financial administration: Personal services Operating Capital Total Financial Administration Legal: Personal services Operating Total Legal Non Departmental: Personal services Operating Capital Total Non Departmental Total Administrative
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget Operations/Utilities Utilities Administration Personal services Operating Capital
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
126,510 87,105 213,615
123,896 59,861 183,757
2,614 27,244 29,858
122,547 55,329 177,876
64,155 13,273 77,428
66,708 10,789 77,497
(2,553) 2,484 (69)
62,074 10,238 72,312
415,930 639,025 1,312,385 2,367,340
410,545 542,738 560,160 1,513,443
5,385 96,287 752,225 853,897
388,291 466,772 355,145 1,210,208
178,000 1,003,178 1,979,168 3,160,346
160,449 825,832 465,859 1,452,140
17,551 177,346 1,513,309 1,708,206
156,406 1,171,750 17,225 1,345,381
Total operations/utilities
5,818,729
3,226,837
2,591,892
2,805,777
Debt Services Transfers Out Contingency
1,073,378 -
196,605 -
876,773 -
772,644 23,000 -
$ 7,766,791
$ 4,158,280
3,608,511
$ 4,339,867
Total Utilities Administration Vehicle Maintenance Personal services Operating Capital Total Vehicle Maintenance Water/waterplant operations Personal services Operating Capital Total Water plant operations Wastewater operations Personal services Operating Capital Total Wastewater operations
TOTAL EXPENDITURES
$
TOWN OF LANTANA, FLORIDA Investment Earnings Quarter Closing September 30, 2013 FLORIDA STATE BOARD OF ADMINISTRATION (SBA) *EACH ACCOUNT COMBINES FLORIDA PRIME AND FUND B
SBA Rate General Fund Beginning Bal.
October
November
December
January
February
March
April
May
June
July
August
September
Total
0.29%
0.28%
0.25%
0.22%
0.23%
0.23%
0.22%
0.20%
0.20%
0.18%
0.18%
0.18%
0.24%
177,217
Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
23
177,241 -
177,262 -
177,283 -
177,302 -
177,319 -
177,339 -
177,360 -
177,381 -
177,402 -
177,423 -
177,444 -
177,217
22
21
19
18
19
21
21
21
21
21
20
248
177,241
177,262
177,283
177,302
177,319
177,339
177,360
177,381
177,402
177,423
177,444
177,465
177,465
183,851
183,875
183,898
183,919
183,939
183,957
183,977
183,999
184,021
184,043
184,065
184,087
183,851
Utility Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
24
-
-
-
-
-
-
-
-
-
-
-
23
21
19
18
20
22
21
22
22
22
21
257
183,875
183,898
183,919
183,939
183,957
183,977
183,999
184,021
184,043
184,065
184,087
184,108
184,108
6,831
6,832
6,833
6,833
6,834
6,835
6,836
6,836
6,837
6,838
6,839
6,840
6,831
-
-
-
-
-
-
-
-
-
-
-
-
-
*
Impact Fee Reserve Beginning Bal.
Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
1
1
1
1
1
1
1
1
1
1
1
10
6,832
6,833
6,833
6,834
6,835
6,836
6,836
6,837
6,838
6,839
6,840
6,840
6,840
27,404
27,407
27,411
27,414
27,417
27,419
27,423
27,426
27,429
27,432
27,436
27,439
27,404
-
-
-
-
-
-
-
-
-
-
-
-
-
1998 Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
4
3
3
3
3
3
3
3
3
3
3
3
38
27,407
27,411
27,414
27,417
27,419
27,423
27,426
27,429
27,432
27,436
27,439
27,442
27,442
4,017
4,018
4,018
4,019
4,019
4,020
4,020
4,021
4,021
4,022
4,022
4,023
4,017
-
-
-
-
-
-
-
-
-
-
-
-
-
RR&I Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
0
0
0
0
0
1
0
1
0
0
0
6
4,018
4,018
4,019
4,019
4,020
4,020
4,021
4,021
4,022
4,022
4,023
4,023
4,023
October
November
December
January
February
March
April
May
June
July
August
September
Total
Bond Fund Beginning Bal.
16,782
16,785
16,787
16,789
16,791
16,792
16,794
16,796
16,798
16,800
16,802
16,804
16,782
-
-
-
-
-
-
-
-
-
-
-
-
-
Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
2
2
2
2
2
2
2
2
2
2
2
2
23
16,785
16,787
16,789
16,791
16,792
16,794
16,796
16,798
16,800
16,802
16,804
16,806
16,806
55 55
51 51
48 48
44 44
41 41
46 46
50 50
48 48
50.48 50
49.14 49
50.02 50
47.93 48
582 582
26 29 55
24 27 51
23 26 48
21 23 44
19 22 41
21 24 46
21 27 50
21 26 48
21 27 50
21 26 49
21 27 50
20 26 48
259 310 582
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 Investment Credit Per SunTrust General Fund Utility Fund Forfeiture Fund Bank Charges (net of interest credit)
0.100% 626 656 4 (231)
Investment Earnings
0.100% 576 642 4 (340)
0.100% 666 660 4 (284)
0.100% 728 609 4 (273)
0.100% 654 560 4 (823)
0.10% 721 623 4 (793)
0.08% 519 492 3 (775)
0.070% 475 465 3 (838)
0.070% 449 451 3 (892)
0.070% 452 483 3 (477)
0.070% 454 487 3 (629)
0.070% 434 447 3 (519)
1,056
882
1,046
1,068
395
555
238
106
10
461
314
366
Operating Water Plant Reserve
16,778,219 373,297
16,379,488 373,334
17,722,813 373,372
17,475,877 373,410
17,562,605 373,444
17,519,930 373,482
17,586,484 373,514
17,194,318 373,546
17,218,874 373,577
17,381,245 373,609
17,235,484 373,640
16,323,348 373,297
Ending Balances
17,151,516
16,752,821
18,096,185
17,849,287
17,936,049
17,893,412
17,959,998
17,567,864
17,592,451
17,754,853
17,609,125
16,696,645
0.09% 6,754 6,575 41 (6,874) 6,496
Checking Account Ending Balances per Statement
TD BANK ACCOUNT TD Bank Rate Investment Earnings (Utility Fund) Ending Balance
0.20% 11 124,996
0.20% 13 83,803
0.20% 24 167,642
0.20% 21 126,467
0.20% 21 210,293
0.20% 28 169,125
0.20% 22 127,951
0.20% 33 211,788
0.20% 28 170,621
472.62 531 3 1,008
474.83 546 3 1,026
454.80 502 3 961
0.20% 201
TOTAL INVESTMENT EARNINGS BY FUND General Fund Utility Fund Forfeiture Fund $
651 686 4 1,342
$
600 669 4 1,274
$
689 685 4 1,378
$
749 643 4 1,396
$
674 595 4 1,272
$
742 672 4 1,418
$
540 539 3 1,084
$
496 512 3 1,013
$
470 506 3 981
$
$
$
$
7,013 7,087 41 14,153
STATE BOARD OF ADMINISTRATION LOCAL GOVERNMENT SURPLUS TRUST FUNDS INVESTMENT POOL As of September 30th, $326,410 was in the Florida Prime account which is liquid and available for withdrawal. In Fund B, the Town’s balance was $90,275 which is not liquid nor is it available for withdrawal. The total unrealized gain is $11,972 for all accounts. If you have any questions, please do not hesitate to contact me.
BUDGET-IN-BRIEF as of September 30, 2013 (100% of year elapsed) YTD-Townwide Expense Allocation
Capital, 1,899,872 , 14%
Other Town Funds
Debt, 626,140 , 5% Wages, 4,764,242 , 37%
Operating & Maint., 3,603,817 , 28%
Benefits, 2,121,176 , 16%
General Fund Revenues Revenues Budget Year-to-Date Taxes 4,376,125 4,089,548 Licenses & Permits 443,520 557,304 Intergovernmental Revenue 1,022,636 966,617 Charges for Services 1,610,398 1,516,364 Fines & Forfeitures 99,415 131,548 Misc. Revenue 725,535 754,797 Appropriations & Carryover 1,172,463 Total Revenues $ 9,450,092 $ 8,016,178
% 93.5% 125.7% 94.5% 94.2% 132.3% 104.0% 0.0% 84.8%
General Fund Expenditures Expenditures Budget Year-to-Date Town Council 74,820 67,332 Town Manager 184,068 179,970 Finance 331,641 295,401 Town Attorney 178,534 151,036 Non-Departmental 216,522 172,044 Police 3,750,474 3,613,485 Development Services 605,680 555,256 Operations Department 2,167,440 1,993,850
% 90.0% 97.8% 89.1% 84.6% 79.5% 96.3% 91.7% 92.0%
Library Holiday Events Capital Outlay Debt Service Total Expenditures
149,047
139,314
93.5%
47,500 1,314,216
31,263 853,037
65.8% 64.9%
430,150 $
9,450,092
$
Utility Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 6,358,244 1,408,547 7,766,791 7,766,791
Year-to-Date 6,098,756 6,098,756 4,140,584
% 95.9% 0.0% 78.5% 53.3%
Police Education Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 2,761 1,839 4,600 4,600
Year-to-Date 3,810 3,810 1,628
% 138.0% 0.0% 82.8% 35.4%
Police Forfeiture Fund* Budget Total Revenues Total Expenses *Per Florida Statute fund is not budgeted
Year-to-Date 1,570 6,870
% 0.0% 0.0%
Grants Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 354,726 354,726 354,726
Year-to-Date 70,131 70,131 70,131
% 19.8% N/A 19.8% 19.8%
Insurance Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 397,743 397,743 397,743
Year-to-Date 355,435 355,435 314,511
% 89.4% N/A 89.4% 79.1%
Expenditures
YTD-Total Townwide Budget Budget Year-to-Date
429,535
99.9%
Total Townwide Budget
8,481,523
89.8%
(not including Police Forfeiture Fund)
17,973,952
13,008,377
% 72.4%
TOWN OF LANTANA, FLORIDA General Fund Balance Sheet (unaudited) September 30, 2013 Prior Year
Current Year Assets and Other Debits: Assets: Cash and cash equivalents Investments Accounts 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 Revenue refunding bonds Deferred revenue Total liabilities Fund balances: Assigned for Encumbrances Unassigned, assigned, committed Total equity and other credits Total liabilities, equity and other credits
$
8,273,352 241,940 36,365 11,274 210 8,563,141
$
$
8,352,626 281,242 41,906 11,364 8,687,137
149,136 7,205
283,432 6,474
167,958 356,137 680,436
162,057 373,309 825,272
5,054 7,877,651 7,882,705 8,563,141
7,861,865 7,861,865 8,687,137
$
TOWN OF LANTANA, FLORIDA General Fund Statement of Revenues, Expenditures and Changes in Fund Balance – Budget and Actual (unaudited) Period Ended September 30, 2013
Revenues: Taxes Licenses and permits Intergovernmental Charges for services Fines and forfeitures Miscellaneous Total revenues Expenditures: Current: General government Public safety Development services Physical environment Culture and recreation Capital outlay Debt service: Principal & Interest General contingency Total expenditures Deficiency of revenues under expenditures Other financing sources: Sale of general fixed assets Operating transfers in Operating transfers out 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
Variance Favorable (Unfavorable)
Prior Year Actual
Budget
Actual
$ 4,376,125 443,520 1,022,636 1,610,398 99,415 719,535 8,271,629
$ 4,089,547 557,304 966,618 1,516,364 131,548 747,618 8,008,999
985,586 3,750,474 605,680 1,124,709 1,239,278 1,314,215
865,781 3,613,484 555,257 1,015,858 1,148,569 853,038
119,805 136,990 50,423 108,851 90,709 461,177
753,862 3,570,621 506,359 1,003,324 1,267,667 3,067,949
430,150 9,450,092
429,535 8,481,522
615 968,570
429,535 10,599,317
705,940
(2,360,259)
(1,178,463) 6,000 1,072,793 99,670 1,178,463 -
(472,523) 7,181 7,181 (465,342) 8,348,051 $ 7,882,705
$
(286,578) 113,784 (56,018) (94,034) 32,133 28,083 (262,630)
1,181 (1,072,793) (99,670) (1,171,282)
$ 4,103,126 577,579 966,118 1,541,946 133,460 916,829 8,239,058
538,883 (515,883) 23,000 (2,337,260) 10,199,126 $ 7,861,865
TOWN OF LANTANA, FLORIDA General Fund Schedule of Revenues and Other Financing Sources – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget
Actual
$ 2,120,000 666,158 999,853 325,605 264,509 4,376,125
$ 2,105,853 559,222 942,910 262,524 219,038 4,089,547
263,177 180,343 443,520
Intergovernmental revenues: State revenue sharing Mobile home licenses Alcoholic beverage licenses Local government ½ cent sales tax Government grants Total intergovernmental revenues Charges for services: Sanitation and waste removal Recycling fees Public Safety Nature Preserve Maintenance Total charges for services
Taxes: Ad Valorem taxes Franchise taxes Utility service taxes Local Communications Services Tax Gasoline taxes Total taxes
Variance Favorable (Unfavorable) (14,147) (106,936) (56,943) (63,081) (45,471) (286,578)
$ 2,181,084 516,026 902,998 280,289 222,729 4,103,126
255,284 302,020 557,304
(7,893) 121,677 113,784
252,548 325,031 577,579
297,000 21,251 11,020 669,500 23,865 1,022,636
310,382 21,490 9,831 605,087 19,828 966,618
13,382 239 (1,189) (64,413) (4,037) (56,018)
321,707 23,203 10,747 574,834 35,627 966,118
767,483 105,816 686,619 50,480 1,610,398
704,879 73,047 687,762 50,676 1,516,364
(62,604) (32,769) 1,143 196 94,034
728,281 99,609 664,322 49,734 1,541,946
99,415
131,548
32,133
133,460
Miscellaneous revenues: Interest Beach parking Contributions Leases Other Total miscellaneous revenues
11,080 119,736 2,150 478,397 108,172 719,535
21,271 157,878 3,650 478,645 86,174 747,618
10,191 38,142 1,500 248 (21,998) 28,083
38,985 195,470 14,400 420,131 247,843 916,829
Other financing sources: Sale of general fixed assets Interfund Transfers Capital Carryover Use of Fund Balance Loan Proceeds Total other financing sources TOTAL REVENUES
6,000 1,072,793 99,670 1,178,463 $ 9,450,092
7,181 7,181 $ 8,016,180
1,181 (1,072,793) (99,670) (1,171,282) $ (1,433,912)
538,883 538,883 $ 8,777,941
Licenses and permits: Business services taxes Building and other permits Total licenses and permits
Fines and forfeitures
$
Prior Year Actual
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget General government: Legislative: Personal services Operating Total Legislative
$
64,515 10,305 74,820
Actual
$
55,217 12,113 67,330
Variance Favorable (Unfavorable)
$
9,298 (1,808) 7,490
Prior Year Actual
$
66,354 10,908 77,262
Executive: Personal services Operating Capital Total Executive
102,290 12,789 3,850 118,929
105,733 8,788 3,851 118,372
(3,443) 4,001 (1) 557
103,633 13,595 117,228
Town Clerk: Personal services Operating Capital Total Town Clerk
45,925 23,065 68,990
45,027 20,422 65,449
898 2,643 3,541
45,150 16,120 61,270
Financial Administration: Personal services Operating Capital Total Financial Administration
239,480 92,161 57,760 389,401
225,119 70,282 1,851 297,252
14,361 21,879 55,909 92,149
210,628 72,855 4,559 288,042
Legal Counsel: Personal services Operating Total Legal Counsel
11,695 166,839 178,534
11,594 139,442 151,036
101 27,397 27,498
11,228 145,467 156,695
215,522 45,552 1,000 262,074 1,092,748
171,544 500 172,044 871,483
43,978 45,552 500 90,030 221,265
57,424 2,157,761 500 2,215,685 2,916,182
383,420 76,415 50,921 510,756
385,079 70,471 42,853 498,403
Non-Departmental Personal services Operating Capital Other Expenses Total Non-Departmental Total General Government Public Safety: Administration: Personal services Operating Capital Total Administration
(1,659) 5,944 8,068 12,353
398,969 66,827 9,679 475,475
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
Uniform Patrol: Personal services Operating Capital Total Uniform Patrol
2,121,205 180,087 152,588 2,453,880
2,032,604 174,480 134,278 2,341,362
Services: Personal services Operating Capital Total Police Services
439,650 154,179 7,500 601,329
439,815 119,361 6,555 565,731
(165) 34,818 945 35,598
425,023 149,409 574,432
Uniform Patrol (Hypoluxo): Personal services Operating Capital Total Uniform Patrol (Hypoluxo)
374,265 21,253 2,950 398,468
373,552 18,122 391,674
713 3,131 2,950 6,794
353,965 22,133 30,546 406,644
3,964,433
3,797,170
167,263
3,701,077
172,260 15,259 2,538 190,057
165,291 14,052 1,173 180,516
6,969 1,207 1,365 9,541
87,855 14,191 102,046
Total Public Safety Development Services: Administration : Personal services Operating Capital Total Administration
88,601 5,607 18,310 112,518
1,978,501 175,794 90,231 2,244,526
Building Inspections: Personal services Operating Capital Total Building Inspections Code Enforcement: Personal services Operating Capital Total Code Enforcement
121,150 109,067 12,000 242,217
100,411 109,120 209,531
20,739 (53) 12,000 32,686
117,905 109,952 13,637 241,494
169,195 18,749 187,944
150,454 15,929 166,383
18,741 2,820 21,561
159,760 16,696 639 177,095
Total Development Services
620,218
556,430
63,788
520,635
Physical Environment: Operations Administration Personal services Operating Capital Total Operations Administration
153,791 14,423 168,214
158,575 11,795 170,370
(4,784) 2,628 (2,156)
120,034 11,852 1,237 133,123
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget Vehicle Maintenance: Personal services Operating Capital Total Vehicle Maintenance
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
64,510 14,448 4,000 82,958
66,656 19,049 3,461 89,166
(2,146) (4,601) 539 (6,208)
62,216 8,791 71,007
Solid waste control services: Personal services Operating Capital Total Solid Waste Control Services
145,917 49,056 194,973
114,355 35,095 149,450
31,562 13,961 45,523
203,143 65,813 268,956
Trash Collection: Personal services Operating Capital Total Trash Collection
156,444 61,233 217,677
132,735 54,676 187,411
23,709 6,557 30,266
227,681 81,284 308,965
Recycling Collection: Personal services Operating Capital Total Recycling Collection
43,414 9,660 53,074
36,576 9,518 46,094
6,838 142 6,980
46,310 11,130 57,440
Streets & Highways: Personal services Operating Capital Total Streets & Highways
69,307 342,506 510,774 922,587
53,629 323,199 420,633 797,461
15,678 19,307 90,141 125,126
165,070 596,111 761,181
1,639,483
1,439,952
199,531
1,600,672
11,412 122,300 133,712
10,919 121,957 132,876
493 343 836
9,016 121,957 130,973
Library: Personal services Operating Capital Total library Services
105,180 43,867 37,200 186,247
104,402 34,913 17,522 156,837
778 8,954 19,678 29,410
102,737 35,715 21,780 160,232
Marine Services: Personal services Operating Capital Total Marine Services
265,281 14,368 43,111 322,760
265,391 12,503 19,995 297,889
(110) 1,865 23,116 24,871
312,452 12,100 24,598 349,150
Total Physical Environment Cultural and Recreation: Sports complex: Operating Debt service Total Sports Complex Services
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
Public Grounds & Forestry: Personal services Operating Capital Total Public Grounds & Forestry
305,625 152,851 180,274 638,750
285,219 131,035 102,826 519,080
20,406 21,816 77,448 119,670
306,443 128,351 55,819 490,613
Facilities Maintenance: Personal services Operating Capital Total Building Maintenance
153,995 139,199 203,197 496,391
144,497 128,428 98,040 370,965
9,498 10,771 105,157 125,426
169,374 148,471 61,352 379,197
Miscellaneous: Holiday events Total Miscellaneous Total Culture and Recreation
47,500 47,500 1,825,360
31,262 31,262 1,508,909
16,238 16,238 316,451
43,008 43,008 1,553,173
Debt Service Transfers Out General Contingency TOTAL EXPENDITURES
307,850 9,450,092
307,578 8,481,522
272 968,569
307,578 515,883 $ 11,115,200
$
$
$
TOWN OF LANTANA, FLORIDA Utility Fund Balance Sheet (unaudited) September 30, 2013 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 Other liabilities 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
$
4,300 509,892 20,486,913 810,847 19,142 193,821 22,024,915 (12,513,800) 9,511,115
Less accumulated depreciation & amortization Net fixed assets Unamortized bond costs Total assets and other debits
8,097,681 238,686 141,131 411,977 140 8,889,615
Prior Year
$
1,261,785 19,662,515
8,744,184 283,738 160,581 411,511 9,600,013 4,300 509,892 20,480,143 808,302 19,142 12,953 21,834,732 (11,757,547) 10,077,185
$
1,428,758 21,105,956
225,156 5,376,657 -
1,267,655 1,897,201 553,196
186,546 226,646 26,805 6,041,810
178,065 208,186 5,283,129 9,387,432
2,445,897 4,482 11,170,326 13,620,705
2,445,897 1,614,405 7,658,222 11,718,524
19,662,515
$
21,105,956
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Revenues, Expenses and Changes in Retained Earnings – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget Revenues: Water sales Wastewater sales Miscellaneous Total operating revenues Expenditures: Operating expenses Water/Sewer plant operations Personnel Current expenses Total
$
Variance Favorable (Unfavorable)
Actual
2,445,022 2,402,110 140,671 4,987,803
$
2,314,537 2,238,424 164,792 4,717,753
$
(130,485) (163,686) 24,121 (270,050)
$
2,286,690 2,325,347 148,932 4,760,969
784,595 1,742,581 2,527,176
761,598 1,439,220 2,200,818
874,684
734,838
139,846
738,446
Debt Services Capital outlay
1,073,378 3,291,553 4,364,931
196,605 1,026,019 1,222,624
876,773 2,265,534 3,142,307
772,644 372,370 1,145,014
Total operating expenses
7,766,791
4,158,280
3,608,511
4,316,867
Administrative expenses
Operating income/(loss) Non-operating revenues (expenses) Investment income Sale of assets Settlements-Lake Worth Operating Transfers Out Retained Earnings-capital carryforward Total non-operating revenues (expenses) Net income/(loss) Net assets, beginning Net assets, ending
22,997 303,361 326,358
Prior YTD Actual
(2,778,988)
559,473
8,441 1,362,000
18,847 1,362,153
1,408,547
-
(1,408,547)
34,356 (23,000) -
2,778,988
1,381,000
(1,397,988)
11,356
-
1,940,473
1,940,473
455,458
11,680,232 $ 13,620,705
(3,878,561)
729,318 1,704,089 2,433,407
10,406 153
444,102
11,263,064 $ 11,718,524
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget Administrative Legislative: Personal services Operating Total legislative Executive: Personal services Operating Capital
$
43,010 6,870 49,880
Actual
$
36,812 8,080 44,892
Variance Favorable (Unfavorable)
$
6,198 (1,210) 4,988
Prior Year Actual
$
44,236 6,991 51,227
102,285 12,789 115,074
105,728 8,853 114,581
(3,443) 3,936 493
103,384 13,522 116,906
Town Clerk: Personal services Operating
30,620 15,375
30,013 13,711
607 1,664
30,047 10,747
Total Town Clerk
45,995
43,724
2,271
40,794
393,020 170,877 4,983 568,880
360,600 111,345 4,891 476,836
32,420 59,532 92 92,044
344,036 110,401 2,426 456,863
2,950 80,655 83,605
2,921 42,051 44,972
29 38,604 38,633
2,807 60,055 62,862
11,250 11,250
9,833 9,833
1,417 1,417
9,794 9,794
874,684
734,838
139,846
738,446
Total executive
Financial administration: Personal services Operating Capital Total Financial Administration Legal: Personal services Operating Total Legal Non Departmental: Personal services Operating Capital Total Non Departmental Total Administrative
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended September 30, 2013
Budget Operations/Utilities Utilities Administration Personal services Operating Capital
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
126,510 87,105 213,615
123,896 59,861 183,757
2,614 27,244 29,858
122,547 55,329 177,876
64,155 13,273 77,428
66,708 10,789 77,497
(2,553) 2,484 (69)
62,074 10,238 72,312
415,930 639,025 1,312,385 2,367,340
410,545 542,738 560,160 1,513,443
5,385 96,287 752,225 853,897
388,291 466,772 355,145 1,210,208
178,000 1,003,178 1,979,168 3,160,346
160,449 825,832 465,859 1,452,140
17,551 177,346 1,513,309 1,708,206
156,406 1,171,750 17,225 1,345,381
Total operations/utilities
5,818,729
3,226,837
2,591,892
2,805,777
Debt Services Transfers Out Contingency
1,073,378 -
196,605 -
876,773 -
772,644 23,000 -
$ 7,766,791
$ 4,158,280
3,608,511
$ 4,339,867
Total Utilities Administration Vehicle Maintenance Personal services Operating Capital Total Vehicle Maintenance Water/waterplant operations Personal services Operating Capital Total Water plant operations Wastewater operations Personal services Operating Capital Total Wastewater operations
TOTAL EXPENDITURES
$
TOWN OF LANTANA, FLORIDA Investment Earnings Quarter Closing September 30, 2013 FLORIDA STATE BOARD OF ADMINISTRATION (SBA) *EACH ACCOUNT COMBINES FLORIDA PRIME AND FUND B
SBA Rate General Fund Beginning Bal.
October
November
December
January
February
March
April
May
June
July
August
September
Total
0.29%
0.28%
0.25%
0.22%
0.23%
0.23%
0.22%
0.20%
0.20%
0.18%
0.18%
0.18%
0.24%
177,217
Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
23
177,241 -
177,262 -
177,283 -
177,302 -
177,319 -
177,339 -
177,360 -
177,381 -
177,402 -
177,423 -
177,444 -
177,217
22
21
19
18
19
21
21
21
21
21
20
248
177,241
177,262
177,283
177,302
177,319
177,339
177,360
177,381
177,402
177,423
177,444
177,465
177,465
183,851
183,875
183,898
183,919
183,939
183,957
183,977
183,999
184,021
184,043
184,065
184,087
183,851
Utility Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
24
-
-
-
-
-
-
-
-
-
-
-
23
21
19
18
20
22
21
22
22
22
21
257
183,875
183,898
183,919
183,939
183,957
183,977
183,999
184,021
184,043
184,065
184,087
184,108
184,108
6,831
6,832
6,833
6,833
6,834
6,835
6,836
6,836
6,837
6,838
6,839
6,840
6,831
-
-
-
-
-
-
-
-
-
-
-
-
-
*
Impact Fee Reserve Beginning Bal.
Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
1
1
1
1
1
1
1
1
1
1
1
10
6,832
6,833
6,833
6,834
6,835
6,836
6,836
6,837
6,838
6,839
6,840
6,840
6,840
27,404
27,407
27,411
27,414
27,417
27,419
27,423
27,426
27,429
27,432
27,436
27,439
27,404
-
-
-
-
-
-
-
-
-
-
-
-
-
1998 Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
4
3
3
3
3
3
3
3
3
3
3
3
38
27,407
27,411
27,414
27,417
27,419
27,423
27,426
27,429
27,432
27,436
27,439
27,442
27,442
4,017
4,018
4,018
4,019
4,019
4,020
4,020
4,021
4,021
4,022
4,022
4,023
4,017
-
-
-
-
-
-
-
-
-
-
-
-
-
RR&I Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
0
0
0
0
0
1
0
1
0
0
0
6
4,018
4,018
4,019
4,019
4,020
4,020
4,021
4,021
4,022
4,022
4,023
4,023
4,023
October
November
December
January
February
March
April
May
June
July
August
September
Total
Bond Fund Beginning Bal.
16,782
16,785
16,787
16,789
16,791
16,792
16,794
16,796
16,798
16,800
16,802
16,804
16,782
-
-
-
-
-
-
-
-
-
-
-
-
-
Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
2
2
2
2
2
2
2
2
2
2
2
2
23
16,785
16,787
16,789
16,791
16,792
16,794
16,796
16,798
16,800
16,802
16,804
16,806
16,806
55 55
51 51
48 48
44 44
41 41
46 46
50 50
48 48
50.48 50
49.14 49
50.02 50
47.93 48
582 582
26 29 55
24 27 51
23 26 48
21 23 44
19 22 41
21 24 46
21 27 50
21 26 48
21 27 50
21 26 49
21 27 50
20 26 48
259 310 582
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 Investment Credit Per SunTrust General Fund Utility Fund Forfeiture Fund Bank Charges (net of interest credit)
0.100% 626 656 4 (231)
Investment Earnings
0.100% 576 642 4 (340)
0.100% 666 660 4 (284)
0.100% 728 609 4 (273)
0.100% 654 560 4 (823)
0.10% 721 623 4 (793)
0.08% 519 492 3 (775)
0.070% 475 465 3 (838)
0.070% 449 451 3 (892)
0.070% 452 483 3 (477)
0.070% 454 487 3 (629)
0.070% 434 447 3 (519)
1,056
882
1,046
1,068
395
555
238
106
10
461
314
366
Operating Water Plant Reserve
16,778,219 373,297
16,379,488 373,334
17,722,813 373,372
17,475,877 373,410
17,562,605 373,444
17,519,930 373,482
17,586,484 373,514
17,194,318 373,546
17,218,874 373,577
17,381,245 373,609
17,235,484 373,640
16,323,348 373,297
Ending Balances
17,151,516
16,752,821
18,096,185
17,849,287
17,936,049
17,893,412
17,959,998
17,567,864
17,592,451
17,754,853
17,609,125
16,696,645
0.09% 6,754 6,575 41 (6,874) 6,496
Checking Account Ending Balances per Statement
TD BANK ACCOUNT TD Bank Rate Investment Earnings (Utility Fund) Ending Balance
0.20% 11 124,996
0.20% 13 83,803
0.20% 24 167,642
0.20% 21 126,467
0.20% 21 210,293
0.20% 28 169,125
0.20% 22 127,951
0.20% 33 211,788
0.20% 28 170,621
472.62 531 3 1,008
474.83 546 3 1,026
454.80 502 3 961
0.20% 201
TOTAL INVESTMENT EARNINGS BY FUND General Fund Utility Fund Forfeiture Fund $
651 686 4 1,342
$
600 669 4 1,274
$
689 685 4 1,378
$
749 643 4 1,396
$
674 595 4 1,272
$
742 672 4 1,418
$
540 539 3 1,084
$
496 512 3 1,013
$
470 506 3 981
$
$
$
$
7,013 7,087 41 14,153
