March 31, 2014
MEMORANDUM Finance Department INVESTMENT REPORT On March 31st, 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. During December 2013 and January 2014, significant funds were reallocated to increase yield potential while maintaining safety of principal. 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 March 31st, $3,854,191 was in the Florida Prime account which is liquid and available for withdrawal. In Fund B, the balance was $63,881 which is not liquid nor is it available for withdrawal. The total fiscal year-to-date unrealized gain is $17,161 for all Fund B accounts. If you have any questions, please do not hesitate to contact me.
BUDGET-IN-BRIEF as of March 31, 2014 (50% of year elapsed) YTD-Townwide Expense Allocation
Capital, 420,669 , 7%
Other Town Funds
Debt, 242,476 , 4% Wages, 2,165,179 , 35%
Operating & Maint., 2,233,095 , 36%
Benefits, 1,112,897 , 18%
General Fund Revenues Revenues Budget Year-to-Date Taxes 4,673,687 3,090,785 Licenses & Permits 1,086,092 959,344 Intergovernmental Revenue 1,202,503 460,527 Charges for Services 785,612 676,477 Fines & Forfeitures 105,040 121,568 Misc. Revenue 578,864 662,626 Appropriations & Carryover 964,307 Total Revenues $ 9,396,105 $ 5,971,327
% 66.1% 88.3% 38.3% 86.1% 115.7% 114.5% 0.0% 63.6%
General Fund Expenditures Expenditures Budget Year-to-Date Town Council 114,843 57,055 Town Manager 191,226 82,550 Finance 346,945 161,978 Town Attorney 183,075 49,433 Non-Departmental 120,232 84,672 Police 4,163,611 1,958,567 Development Services 635,112 256,678 Public Works 2,033,260 972,380
% 49.7% 43.2% 46.7% 27.0% 70.4% 47.0% 40.4% 47.8%
Library
158,635
68,967
43.5%
Holiday Events Capital Outlay
78,042 940,424
20,934 153,338
26.8% 16.3%
Debt Service Total Expenditures
430,700 $
9,396,105
$
Utility Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 4,972,876 2,488,888 7,461,764 7,461,764
Year-to-Date 2,286,566 2,286,566 1,834,068
% 46.0% 0.0% 30.6% 24.6%
Police Education Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 3,851 3,851 -
Year-to-Date 2,096 2,096 85
% 54.4% N/A 54.4% N/A
Police Forfeiture Fund* Budget Total Revenues Total Expenses *Per Florida Statute fund is not budgeted
Year-to-Date 2,509 1,404
% 0.0% 0.0%
Grants Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 315,810 315,810 315,810
Year-to-Date 136,653 136,653 16,125
% 43.3% N/A 43.3% 5.1%
Insurance Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 397,320 397,320 397,320
Year-to-Date 159,935 159,935 241,314
% 40.3% N/A 40.3% 60.7%
Expenditures
YTD-Total Townwide Budget Budget Year-to-Date
214,768
49.9%
Total Townwide Budget
4,081,320
43.4%
(not including Police Forfeiture Fund)
17,574,850
6,172,912
% 35.1%
TOWN OF LANTANA, FLORIDA General Fund Balance Sheet (unaudited) March 31, 2014 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 Deferred revenue Total liabilities Fund balances: Assigned for Encumbrances Unassigned, assigned, committed Total equity and other credits Total liabilities, equity and other credits
$
8,084,008 2,232,533 15,040 12,307 242,934 10,586,822
Prior Year
$
$
9,392,526 280,366 42,963 11,733 266,537 9,994,125
198,704 10,289 100,862 309,855
564,889 5,057 198,589 768,535
457,550 9,819,417 10,276,967 10,586,822
483,355 8,742,235 9,225,590 9,994,125
$
TOWN OF LANTANA, FLORIDA General Fund Statement of Revenues, Expenditures and Changes in Fund Balance – Budget and Actual (unaudited) Period Ended March 31, 2014
Revenues: Taxes Licenses, permits & fees 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
Budget
Actual
Variance Favorable (Unfavorable)
$ 4,673,687 1,086,092 1,202,503 785,612 105,040 428,864 8,281,798
$ 3,090,785 959,343 460,526 676,477 121,568 450,536 5,759,235
$ (1,582,902) (126,749) (741,977) (109,135) 16,528 21,672 (2,522,563)
956,321 4,163,611 635,112 1,311,249 965,816 933,296
435,691 1,958,566 256,677 640,850 421,432 153,338
520,630 2,205,045 378,435 670,399 544,384 779,958
491,510 1,866,598 278,553 444,998 419,330 528,751
430,700 9,396,105
214,768 4,081,322
215,932 5,314,783
214,768 4,244,508
(1,114,307)
1,677,913
2,792,220
870,358
62,090 (671,019) (293,288) (902,217)
Prior Year Actual $ 2,648,201 352,246 427,723 1,015,126 86,738 584,832 5,114,866
150,000 671,019 293,288 1,114,307
212,090 212,090
7,181 7,181
-
1,890,003
877,538
8,386,963 $ 10,276,967
8,348,051 $ 9,225,590
TOWN OF LANTANA, FLORIDA General Fund Schedule of Revenues and Other Financing Sources – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget
Actual
$ 2,133,000 979,596 1,008,768 293,000 259,323 4,673,687
$ 1,896,308 547,059 469,656 90,045 87,717 3,090,785
Licenses, permits & fees: Business tax receipts Building and other permits Solid waste assessment Total licenses, permits & fees
264,386 232,423 589,283 1,086,092
Intergovernmental revenues: 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) $
Prior Year Actual
(236,692) (432,537) (539,112) (202,955) (171,606) (1,582,902)
$ 1,830,547 195,606 415,998 120,580 85,470 2,648,201
221,312 236,824 501,207 959,343
(43,074) 4,401 (88,076) (126,749)
218,769 133,477 352,246
312,000 22,603 11,100 725,000 131,800 1,202,503
153,928 18,107 514 266,858 21,119 460,526
(158,072) (4,496) (10,586) (458,142) (110,681) (741,977)
148,705 16,399 24 248,162 14,433 427,723
Charges for services: Sanitation and waste removal Recycling fees Public Safety Nature Preserve Maintenance Total charges for services
734,179 51,433 785,612
650,954 25,523 676,477
(83,225) (25,910) 109,135
342,814 46,525 600,542 25,245 1,015,126
Fines and forfeitures
105,040
121,568
16,528
86,738
Miscellaneous revenues: Interest Beach parking Contributions Leases Other Total miscellaneous revenues
11,445 132,500 20,000 207,633 57,286 428,864
11,176 110,518 20,000 198,299 110,543 450,536
(269) (21,982) (9,334) 53,257 21,672
12,102 78,187 456,123 38,420 584,832
Other financing sources: Sale of general fixed assets Interfund Transfers Capital Carryover Use of Fund Balance Loan Proceeds Total other financing sources TOTAL REVENUES
150,000 671,019 293,288 1,114,307 $ 9,396,105
212,090 212,090 $ 5,971,325
62,090 (671,019) (293,288) (902,217) $ (3,424,780)
7,181 7,181 $ 5,122,047
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget General government: Legislative: Personal services Operating Total Legislative
$
64,490 50,353 114,843
Actual
$
34,974 22,083 57,057
Variance Favorable (Unfavorable)
$
29,516 28,270 57,786
Prior Year Actual
$
27,048 7,714 34,762
Executive: Personal services Operating Capital Total Executive
110,900 11,208 122,108
51,322 3,643 54,965
59,578 7,565 67,143
48,676 4,204 3,851 56,731
Town Clerk: Personal services Operating Capital Total Town Clerk
45,905 23,213 69,118
21,393 6,193 27,586
24,512 17,020 41,532
21,724 13,362 35,086
Finance: Personal services Operating Capital Total Finance
244,700 102,245 55,860 402,805
105,865 56,113 52,207 214,185
138,835 46,132 3,653 188,620
105,511 52,826 1,851 160,188
Legal Counsel: Personal services Operating Total Legal Counsel
12,740 170,335 183,075
7,254 42,179 49,433
5,486 128,156 133,642
6,761 60,747 67,508
119,232 45,552 1,000 165,784 1,057,733
84,172 500 84,672 487,898
35,060 45,552 500 81,112 569,835
142,937 142,937 497,212
394,050 70,267 4,700 469,017
185,395 49,485 234,880
208,655 20,782 4,700 234,137
183,675 49,857 4,303 237,835
Non-Departmental Personal services Operating Capital Other Expenses Total Non-Departmental Total General Government Public Safety: Administration: Personal services Operating Capital Total Administration
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Uniform Patrol: Personal services Operating Capital Total Uniform Patrol
Actual
Variance Favorable (Unfavorable)
2,174,640 165,337 6,757 2,346,734
1,002,951 67,481 18,396 1,088,828
Detectives: Personal services Operating Capital Total Detectives
235,240 26,552 76,750 338,542
109,425 8,455 1,677 119,557
125,815 18,097 75,073 218,985
-
Services: Personal services Operating Capital Total Police Services
239,580 146,259 385,839
119,603 82,123 201,726
119,977 64,136 184,113
206,900 66,091 6,555 279,546
Uniform Patrol (Hypoluxo): Personal services Operating Capital Total Uniform Patrol (Hypoluxo)
398,340 22,990 2,950 424,280
190,094 7,881 197,975
208,246 15,109 2,950 226,305
175,523 6,523 182,046
Marine Safety: Personal services Operating Capital Total Marine Safety
272,420 17,936 23,115 313,471
130,486 5,187 135,673
141,934 12,749 23,115 177,798
131,782 5,185 13,284 150,251
4,277,883
1,978,639
2,299,244
1,943,923
172,950 12,190 185,140
63,685 7,221 70,906
109,265 4,969 114,234
81,891 5,386 1,173 88,450
139,957 109,070 12,000 261,027
29,476 69,156 4,332 102,964
110,481 39,914 7,668 158,063
55,954 58,836 114,790
Total Public Safety Development Services: Administration : Personal services Operating Capital Total Administration Building Inspections: Personal services Operating Capital Total Building Inspections
1,171,689 97,856 (11,639) 1,257,906
Prior Year Actual 970,048 71,014 53,183 1,094,245
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Code Enforcement: Personal services Operating Capital Total Code Enforcement
Variance Favorable (Unfavorable)
Actual
Prior Year Actual
181,115 19,830 200,945
80,100 7,039 87,139
101,015 12,791 113,806
70,315 6,171 76,486
Total Development Services
647,112
261,009
386,103
279,726
Physical Environment: Public Works Administration Personal services Operating Capital Total Public Works Administration
171,540 26,818 198,358
80,071 12,051 92,122
91,469 14,767 106,236
60,462 5,974 66,436
61,793 10,896 1,299 73,988
29,129 31,154 1,447 61,730
32,664 (20,258) (148) 12,258
36,340 1,138 3,461 40,939
Solid waste control services: Personal services Operating Capital Total Solid Waste Control Services
-
-
-
77,410 29,804 107,214
Trash Collection: Personal services Operating Capital Total Trash Collection
-
-
-
104,155 41,840 145,995
Recycling Collection: Personal services Operating Capital Total Recycling Collection
-
-
-
22,326 5,294 27,620
Streets & Sanitation: Personal services Operating Capital Total Streets & Sanitation
160,749 879,453 221,726 1,261,928
78,461 409,984 12,666 501,111
82,288 469,469 209,060 760,817
60,255 384,669 444,924
Total Physical Environment
1,534,274
654,963
879,311
833,128
Vehicle Maintenance: Personal services Operating Capital Total Vehicle Maintenance
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Cultural and Recreation: Sports Complex: Operating Debt service Total Sports Complex Services
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
9,260 122,200 131,460
3,273 60,979 64,252
5,987 61,221 67,208
2,844 60,979 63,823
Library: Personal services Operating Capital Total Library services
108,530 50,105 34,677 193,312
48,701 20,265 17,253 86,219
59,829 29,840 17,424 107,093
48,831 16,854 8,408 74,093
Public Grounds & Forestry: Personal services Operating Capital Total Public Grounds & Forestry
219,436 216,081 336,014 771,531
101,666 89,843 39,168 230,677
117,770 126,238 296,846 540,854
146,720 61,912 37,713 246,345
Facilities Maintenance: Personal services Operating Capital Total Building Maintenance
156,299 128,063 111,896 396,258
70,961 65,789 6,192 142,942
85,338 62,274 105,704 253,316
75,836 63,345 10,300 149,481
Miscellaneous: Holiday events Total Miscellaneous Total Culture and Recreation
78,042 78,042 1,570,603
20,934 20,934 545,024
57,108 57,108 1,025,579
2,988 2,988 536,730
Debt Service Transfers Out General Contingency TOTAL EXPENDITURES
308,500 9,396,105
153,789 4,081,322
154,711 5,314,783
153,789 4,244,508
$
$
$
$
TOWN OF LANTANA, FLORIDA Utility Fund Balance Sheet (unaudited) March 31, 2014 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
$
4,300 509,892 20,737,967 791,817 5,146 18,445 22,067,567 (13,143,593) 8,923,974
Less accumulated depreciation & amortization Net fixed assets Unamortized bond costs Total assets and other debits
6,918,009 1,760,011 142,963 379,869 9,200,852
Prior Year
$
1,066,495 19,191,321
7,981,385 282,713 167,982 411,718 8,843,798 4,300 509,892 20,486,913 810,847 19,142 193,821 22,024,915 (12,513,800) 9,511,115
$
1,261,785 19,616,698
61,935 5,156,349
1,415,784 5,879,270
158,362 231,367 27,760 5,635,773
140,007 216,677 26,805 7,678,543
2,445,897 1,715,691 9,393,960 13,555,548
2,445,897 2,074,710 7,417,548 11,938,155
19,191,321
$
19,616,698
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Revenues, Expenses and Changes in Retained Earnings – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Revenues: Water sales Wastewater sales Miscellaneous Total operating revenues
Actual
$ (1,325,814) (1,301,048) (64,539) (2,691,401)
829,446 1,610,874 2,440,320
394,701 770,962 1,165,663
434,745 839,912 1,274,657
902,095
376,186
525,909
374,462
Debt Services Capital outlay
860,450 3,258,899 4,119,349
27,708 264,511 292,219
832,742 2,994,388 3,827,130
88,464 328,741 417,205
Total operating expenses
7,461,764
1,834,068
5,627,696
1,950,049
Administrative expenses
Operating income/(loss)
2,457,136 2,359,779 148,656 4,965,571
(2,496,193)
$
Prior YTD Actual
1,131,322 1,058,731 84,117 2,274,170
Expenditures: Operating expenses Water/Sewer plant operations Personnel Current expenses Total
$
Variance Favorable (Unfavorable)
440,102
(8,319,097)
$
1,067,512 1,046,588 79,864 2,193,964
363,704 794,678 1,158,382
243,915
Non-operating revenues (expenses) Investment income Sale of assets Operating Transfers Out Retained Earnings-capital carryforward
7,305 -
12,396
2,488,888
-
(2,488,888)
12,980 1,033 -
Total non-operating revenues (expenses)
2,496,193
12,396
(2,483,797)
14,013
-
452,498
Net income/(loss) Net assets, beginning Net assets, ending
13,103,050 $ 13,555,548
5,091 -
452,498
257,928 11,680,229 $ 11,938,155
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Administrative Legislative: Personal services Operating Total legislative Executive: Personal services Operating Capital
$
42,805 32,854 75,659
Actual
$
23,330 14,688 38,018
Variance Favorable (Unfavorable)
$
19,475 18,166 37,641
$
18,032 5,142 23,174
110,900 11,938 122,838
51,320 3,619 54,939
67,899
48,674 4,219 52,893
Town Clerk: Personal services Operating
30,875 15,532
14,275 4,128
16,600 11,404
14,480 9,009
Total Town Clerk
46,407
18,403
28,004
23,489
Finance Personal services Operating Capital Total Finance
399,510 167,974 30,000 597,484
161,598 80,033 2,820 244,451
237,912 87,941 27,180 353,033
164,697 70,601 3,457 238,755
3,250 39,570 42,820
1,813 11,553 13,366
1,437 28,017 29,454
1,701 28,708 30,409
16,887 16,887
7,009 7,009
9,878 9,878
5,742 5,742
902,095
376,186
525,909
374,462
Total executive
Legal: Personal services Operating Total Legal Non Departmental: Personal services Operating Capital Total Non Departmental Total Administrative
59,580 8,319 -
Prior Year Actual
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Public Works/Utilities Utilities Administration Personal services Operating Capital Total Utilities Administration Vehicle Maintenance Personal services Operating Capital Total Vehicle Maintenance Water/water plant operations Personal services Operating Capital Total Water/water plant operations Wastewater operations Personal services Operating Capital Total Wastewater operations Total operations/utilities Debt Services Transfers Out Contingency TOTAL EXPENDITURES
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
140,728 94,989 235,717
67,210 46,187 113,397
73,518 48,802 122,320
60,804 31,228 92,032
61,793 12,195 73,988
28,574 2,904 31,478
33,219 9,291 42,510
36,337 4,671 41,008
449,795 555,921 926,865 1,932,581
217,966 234,371 93,274 545,611
231,829 321,550 833,591 1,386,970
190,879 260,568 94,629 546,076
177,130 947,769 2,332,034 3,456,933
80,951 487,500 171,237 739,688
96,179 460,269 2,160,797 2,717,245
75,684 498,211 234,112 808,007
5,699,219
1,430,174
4,269,045
1,487,123
860,450 -
27,708 -
832,742 -
88,464 -
$ 7,461,764
$ 1,834,068
5,627,696
$ 1,950,049
$
TOWN OF LANTANA, FLORIDA Investment Earnings Quarter Closing March 31, 2014 FLORIDA STATE BOARD OF ADMINISTRATION (SBA) *EACH ACCOUNT COMBINES FLORIDA PRIME AND FUND B October SBA Rate General Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
November
0.18%
December
0.17%
0.16%
January
February
March
0.15%
0.16%
0.15%
Total 0.16%
177,465
177,486
177,506
177,526
2,177,672
2,177,935
177,465
21
20
19
2,000,000 147
262
14,155 285
2,014,155 754
177,486
177,506
177,526
2,177,672
2,177,935
2,192,374
2,192,374
184,108
184,130
184,151
184,171
1,684,287
1,684,489
184,108
22
21
20
1,500,000 116
202
32,263 222
1,532,263 602
184,130
184,151
184,171
1,684,287
1,684,489
1,716,973
1,716,973
6,840
6,841
6,842
6,843
6,844
6,844
6,840
-
-
-
-
-
(5,761) 0
(5,761) 4
Utility Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal. Impact Fee Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
1
1
1
1
6,841
6,842
6,843
6,844
6,844
1,083
1,083
27,442
27,445
27,448
27,451
27,454
27,457
27,442
-
-
-
-
-
(23,114) 0
(23,114) 16
1998 Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
3
3
3
3
3
27,445
27,448
27,451
27,454
27,457
4,343
4,343
4,023
4,024
4,024
4,024
4,025
4,025
4,023
-
-
-
-
-
(3,388) 0
(3,388) 2
RR&I Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
0
0
0
0
4,024
4,024
4,024
4,025
4,025
638
638
16,806
16,808
16,810
16,812
16,814
16,815
16,806
-
-
-
-
-
(14,155) 0
(14,155) 10
Bond Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
2
2
2
2
2
16,808
16,810
16,812
16,814
16,815
2,660
2,660
50 50
47 47
46 46
268 268
470 470
507 507
1,388 1,388
23 27 50
22 25 47
21 24 46
148 120 268
264 206 470
285 222 507
764 624 1,388
SBA TOTALS Total Investment Earnings Total Admin. Charges Net Investment Earnings Investment Earnings Net of Admin. Charges General Fund Utility Fund
October
November
December
January
February
March
Total
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)
0.40% 0.07% 433 451 3 (564)
0.40% 0.07% 412 459 3 (732)
0.40% 0.07% 443 308 3 (368)
0.40% 0.07% 337 226 3 0
0.20% 0.07% 241 171 2 (640)
0.20% 0.07% 235 173 2 (630)
323
143
385
565
(226)
(219)
Operating Demand Deposit Water Plant Reserve
15,122,983 2,000,000 373,703
13,480,513 4,000,000 373,733
10,948,425 4,000,000 373,762
7,358,198 4,000,000 373,785
7,643,775 4,000,000 373,805
5,479,559 6,000,000 373,827
Ending Balances
17,496,685
17,854,246
15,322,188
11,731,983
12,017,579
11,853,386
0.20% 22
0.20% 26
0.20% 481 340 821
0.20% 428 307 736
0.20% 487 339 826
4,832,150
4,791,690
4,876,320
812 806 2 1,620
859 882 2 1,743
Investment Earnings
0.33% 0.07% 2,102 1,788 15 (2,934) 970
Ending Account Balances per Statement
TD BANK ACCOUNT TD Bank Rate Investment Earnings (Utility Fund) Investment Earnings (General Fund) Investment Earnings
22
26
0.20% 261 182 443
Ending Balance
129,447
213,278
4,872,525
General Fund Utility Fund Forfeiture Fund
457 499 3 959
0.20% 1,706 1,168
TOTAL INVESTMENT EARNINGS BY FUND
$
$
434 511 3 948
$
646 594 3 1,243
$
825 826 3 1,654
$
$
$
4,034 4,118 15 8,167
STATE BOARD OF ADMINISTRATION LOCAL GOVERNMENT SURPLUS TRUST FUNDS INVESTMENT POOL As of March 31st, $3,854,191 was in the Florida Prime account which is liquid and available for withdrawal. In Fund B, the balance was $63,881 which is not liquid nor is it available for withdrawal. The total fiscal year-to-date unrealized gain is $17,161 for all Fund B accounts. If you have any questions, please do not hesitate to contact me.
BUDGET-IN-BRIEF as of March 31, 2014 (50% of year elapsed) YTD-Townwide Expense Allocation
Capital, 420,669 , 7%
Other Town Funds
Debt, 242,476 , 4% Wages, 2,165,179 , 35%
Operating & Maint., 2,233,095 , 36%
Benefits, 1,112,897 , 18%
General Fund Revenues Revenues Budget Year-to-Date Taxes 4,673,687 3,090,785 Licenses & Permits 1,086,092 959,344 Intergovernmental Revenue 1,202,503 460,527 Charges for Services 785,612 676,477 Fines & Forfeitures 105,040 121,568 Misc. Revenue 578,864 662,626 Appropriations & Carryover 964,307 Total Revenues $ 9,396,105 $ 5,971,327
% 66.1% 88.3% 38.3% 86.1% 115.7% 114.5% 0.0% 63.6%
General Fund Expenditures Expenditures Budget Year-to-Date Town Council 114,843 57,055 Town Manager 191,226 82,550 Finance 346,945 161,978 Town Attorney 183,075 49,433 Non-Departmental 120,232 84,672 Police 4,163,611 1,958,567 Development Services 635,112 256,678 Public Works 2,033,260 972,380
% 49.7% 43.2% 46.7% 27.0% 70.4% 47.0% 40.4% 47.8%
Library
158,635
68,967
43.5%
Holiday Events Capital Outlay
78,042 940,424
20,934 153,338
26.8% 16.3%
Debt Service Total Expenditures
430,700 $
9,396,105
$
Utility Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 4,972,876 2,488,888 7,461,764 7,461,764
Year-to-Date 2,286,566 2,286,566 1,834,068
% 46.0% 0.0% 30.6% 24.6%
Police Education Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 3,851 3,851 -
Year-to-Date 2,096 2,096 85
% 54.4% N/A 54.4% N/A
Police Forfeiture Fund* Budget Total Revenues Total Expenses *Per Florida Statute fund is not budgeted
Year-to-Date 2,509 1,404
% 0.0% 0.0%
Grants Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 315,810 315,810 315,810
Year-to-Date 136,653 136,653 16,125
% 43.3% N/A 43.3% 5.1%
Insurance Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 397,320 397,320 397,320
Year-to-Date 159,935 159,935 241,314
% 40.3% N/A 40.3% 60.7%
Expenditures
YTD-Total Townwide Budget Budget Year-to-Date
214,768
49.9%
Total Townwide Budget
4,081,320
43.4%
(not including Police Forfeiture Fund)
17,574,850
6,172,912
% 35.1%
TOWN OF LANTANA, FLORIDA General Fund Balance Sheet (unaudited) March 31, 2014 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 Deferred revenue Total liabilities Fund balances: Assigned for Encumbrances Unassigned, assigned, committed Total equity and other credits Total liabilities, equity and other credits
$
8,084,008 2,232,533 15,040 12,307 242,934 10,586,822
Prior Year
$
$
9,392,526 280,366 42,963 11,733 266,537 9,994,125
198,704 10,289 100,862 309,855
564,889 5,057 198,589 768,535
457,550 9,819,417 10,276,967 10,586,822
483,355 8,742,235 9,225,590 9,994,125
$
TOWN OF LANTANA, FLORIDA General Fund Statement of Revenues, Expenditures and Changes in Fund Balance – Budget and Actual (unaudited) Period Ended March 31, 2014
Revenues: Taxes Licenses, permits & fees 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
Budget
Actual
Variance Favorable (Unfavorable)
$ 4,673,687 1,086,092 1,202,503 785,612 105,040 428,864 8,281,798
$ 3,090,785 959,343 460,526 676,477 121,568 450,536 5,759,235
$ (1,582,902) (126,749) (741,977) (109,135) 16,528 21,672 (2,522,563)
956,321 4,163,611 635,112 1,311,249 965,816 933,296
435,691 1,958,566 256,677 640,850 421,432 153,338
520,630 2,205,045 378,435 670,399 544,384 779,958
491,510 1,866,598 278,553 444,998 419,330 528,751
430,700 9,396,105
214,768 4,081,322
215,932 5,314,783
214,768 4,244,508
(1,114,307)
1,677,913
2,792,220
870,358
62,090 (671,019) (293,288) (902,217)
Prior Year Actual $ 2,648,201 352,246 427,723 1,015,126 86,738 584,832 5,114,866
150,000 671,019 293,288 1,114,307
212,090 212,090
7,181 7,181
-
1,890,003
877,538
8,386,963 $ 10,276,967
8,348,051 $ 9,225,590
TOWN OF LANTANA, FLORIDA General Fund Schedule of Revenues and Other Financing Sources – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget
Actual
$ 2,133,000 979,596 1,008,768 293,000 259,323 4,673,687
$ 1,896,308 547,059 469,656 90,045 87,717 3,090,785
Licenses, permits & fees: Business tax receipts Building and other permits Solid waste assessment Total licenses, permits & fees
264,386 232,423 589,283 1,086,092
Intergovernmental revenues: 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) $
Prior Year Actual
(236,692) (432,537) (539,112) (202,955) (171,606) (1,582,902)
$ 1,830,547 195,606 415,998 120,580 85,470 2,648,201
221,312 236,824 501,207 959,343
(43,074) 4,401 (88,076) (126,749)
218,769 133,477 352,246
312,000 22,603 11,100 725,000 131,800 1,202,503
153,928 18,107 514 266,858 21,119 460,526
(158,072) (4,496) (10,586) (458,142) (110,681) (741,977)
148,705 16,399 24 248,162 14,433 427,723
Charges for services: Sanitation and waste removal Recycling fees Public Safety Nature Preserve Maintenance Total charges for services
734,179 51,433 785,612
650,954 25,523 676,477
(83,225) (25,910) 109,135
342,814 46,525 600,542 25,245 1,015,126
Fines and forfeitures
105,040
121,568
16,528
86,738
Miscellaneous revenues: Interest Beach parking Contributions Leases Other Total miscellaneous revenues
11,445 132,500 20,000 207,633 57,286 428,864
11,176 110,518 20,000 198,299 110,543 450,536
(269) (21,982) (9,334) 53,257 21,672
12,102 78,187 456,123 38,420 584,832
Other financing sources: Sale of general fixed assets Interfund Transfers Capital Carryover Use of Fund Balance Loan Proceeds Total other financing sources TOTAL REVENUES
150,000 671,019 293,288 1,114,307 $ 9,396,105
212,090 212,090 $ 5,971,325
62,090 (671,019) (293,288) (902,217) $ (3,424,780)
7,181 7,181 $ 5,122,047
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget General government: Legislative: Personal services Operating Total Legislative
$
64,490 50,353 114,843
Actual
$
34,974 22,083 57,057
Variance Favorable (Unfavorable)
$
29,516 28,270 57,786
Prior Year Actual
$
27,048 7,714 34,762
Executive: Personal services Operating Capital Total Executive
110,900 11,208 122,108
51,322 3,643 54,965
59,578 7,565 67,143
48,676 4,204 3,851 56,731
Town Clerk: Personal services Operating Capital Total Town Clerk
45,905 23,213 69,118
21,393 6,193 27,586
24,512 17,020 41,532
21,724 13,362 35,086
Finance: Personal services Operating Capital Total Finance
244,700 102,245 55,860 402,805
105,865 56,113 52,207 214,185
138,835 46,132 3,653 188,620
105,511 52,826 1,851 160,188
Legal Counsel: Personal services Operating Total Legal Counsel
12,740 170,335 183,075
7,254 42,179 49,433
5,486 128,156 133,642
6,761 60,747 67,508
119,232 45,552 1,000 165,784 1,057,733
84,172 500 84,672 487,898
35,060 45,552 500 81,112 569,835
142,937 142,937 497,212
394,050 70,267 4,700 469,017
185,395 49,485 234,880
208,655 20,782 4,700 234,137
183,675 49,857 4,303 237,835
Non-Departmental Personal services Operating Capital Other Expenses Total Non-Departmental Total General Government Public Safety: Administration: Personal services Operating Capital Total Administration
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Uniform Patrol: Personal services Operating Capital Total Uniform Patrol
Actual
Variance Favorable (Unfavorable)
2,174,640 165,337 6,757 2,346,734
1,002,951 67,481 18,396 1,088,828
Detectives: Personal services Operating Capital Total Detectives
235,240 26,552 76,750 338,542
109,425 8,455 1,677 119,557
125,815 18,097 75,073 218,985
-
Services: Personal services Operating Capital Total Police Services
239,580 146,259 385,839
119,603 82,123 201,726
119,977 64,136 184,113
206,900 66,091 6,555 279,546
Uniform Patrol (Hypoluxo): Personal services Operating Capital Total Uniform Patrol (Hypoluxo)
398,340 22,990 2,950 424,280
190,094 7,881 197,975
208,246 15,109 2,950 226,305
175,523 6,523 182,046
Marine Safety: Personal services Operating Capital Total Marine Safety
272,420 17,936 23,115 313,471
130,486 5,187 135,673
141,934 12,749 23,115 177,798
131,782 5,185 13,284 150,251
4,277,883
1,978,639
2,299,244
1,943,923
172,950 12,190 185,140
63,685 7,221 70,906
109,265 4,969 114,234
81,891 5,386 1,173 88,450
139,957 109,070 12,000 261,027
29,476 69,156 4,332 102,964
110,481 39,914 7,668 158,063
55,954 58,836 114,790
Total Public Safety Development Services: Administration : Personal services Operating Capital Total Administration Building Inspections: Personal services Operating Capital Total Building Inspections
1,171,689 97,856 (11,639) 1,257,906
Prior Year Actual 970,048 71,014 53,183 1,094,245
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Code Enforcement: Personal services Operating Capital Total Code Enforcement
Variance Favorable (Unfavorable)
Actual
Prior Year Actual
181,115 19,830 200,945
80,100 7,039 87,139
101,015 12,791 113,806
70,315 6,171 76,486
Total Development Services
647,112
261,009
386,103
279,726
Physical Environment: Public Works Administration Personal services Operating Capital Total Public Works Administration
171,540 26,818 198,358
80,071 12,051 92,122
91,469 14,767 106,236
60,462 5,974 66,436
61,793 10,896 1,299 73,988
29,129 31,154 1,447 61,730
32,664 (20,258) (148) 12,258
36,340 1,138 3,461 40,939
Solid waste control services: Personal services Operating Capital Total Solid Waste Control Services
-
-
-
77,410 29,804 107,214
Trash Collection: Personal services Operating Capital Total Trash Collection
-
-
-
104,155 41,840 145,995
Recycling Collection: Personal services Operating Capital Total Recycling Collection
-
-
-
22,326 5,294 27,620
Streets & Sanitation: Personal services Operating Capital Total Streets & Sanitation
160,749 879,453 221,726 1,261,928
78,461 409,984 12,666 501,111
82,288 469,469 209,060 760,817
60,255 384,669 444,924
Total Physical Environment
1,534,274
654,963
879,311
833,128
Vehicle Maintenance: Personal services Operating Capital Total Vehicle Maintenance
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Cultural and Recreation: Sports Complex: Operating Debt service Total Sports Complex Services
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
9,260 122,200 131,460
3,273 60,979 64,252
5,987 61,221 67,208
2,844 60,979 63,823
Library: Personal services Operating Capital Total Library services
108,530 50,105 34,677 193,312
48,701 20,265 17,253 86,219
59,829 29,840 17,424 107,093
48,831 16,854 8,408 74,093
Public Grounds & Forestry: Personal services Operating Capital Total Public Grounds & Forestry
219,436 216,081 336,014 771,531
101,666 89,843 39,168 230,677
117,770 126,238 296,846 540,854
146,720 61,912 37,713 246,345
Facilities Maintenance: Personal services Operating Capital Total Building Maintenance
156,299 128,063 111,896 396,258
70,961 65,789 6,192 142,942
85,338 62,274 105,704 253,316
75,836 63,345 10,300 149,481
Miscellaneous: Holiday events Total Miscellaneous Total Culture and Recreation
78,042 78,042 1,570,603
20,934 20,934 545,024
57,108 57,108 1,025,579
2,988 2,988 536,730
Debt Service Transfers Out General Contingency TOTAL EXPENDITURES
308,500 9,396,105
153,789 4,081,322
154,711 5,314,783
153,789 4,244,508
$
$
$
$
TOWN OF LANTANA, FLORIDA Utility Fund Balance Sheet (unaudited) March 31, 2014 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
$
4,300 509,892 20,737,967 791,817 5,146 18,445 22,067,567 (13,143,593) 8,923,974
Less accumulated depreciation & amortization Net fixed assets Unamortized bond costs Total assets and other debits
6,918,009 1,760,011 142,963 379,869 9,200,852
Prior Year
$
1,066,495 19,191,321
7,981,385 282,713 167,982 411,718 8,843,798 4,300 509,892 20,486,913 810,847 19,142 193,821 22,024,915 (12,513,800) 9,511,115
$
1,261,785 19,616,698
61,935 5,156,349
1,415,784 5,879,270
158,362 231,367 27,760 5,635,773
140,007 216,677 26,805 7,678,543
2,445,897 1,715,691 9,393,960 13,555,548
2,445,897 2,074,710 7,417,548 11,938,155
19,191,321
$
19,616,698
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Revenues, Expenses and Changes in Retained Earnings – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Revenues: Water sales Wastewater sales Miscellaneous Total operating revenues
Actual
$ (1,325,814) (1,301,048) (64,539) (2,691,401)
829,446 1,610,874 2,440,320
394,701 770,962 1,165,663
434,745 839,912 1,274,657
902,095
376,186
525,909
374,462
Debt Services Capital outlay
860,450 3,258,899 4,119,349
27,708 264,511 292,219
832,742 2,994,388 3,827,130
88,464 328,741 417,205
Total operating expenses
7,461,764
1,834,068
5,627,696
1,950,049
Administrative expenses
Operating income/(loss)
2,457,136 2,359,779 148,656 4,965,571
(2,496,193)
$
Prior YTD Actual
1,131,322 1,058,731 84,117 2,274,170
Expenditures: Operating expenses Water/Sewer plant operations Personnel Current expenses Total
$
Variance Favorable (Unfavorable)
440,102
(8,319,097)
$
1,067,512 1,046,588 79,864 2,193,964
363,704 794,678 1,158,382
243,915
Non-operating revenues (expenses) Investment income Sale of assets Operating Transfers Out Retained Earnings-capital carryforward
7,305 -
12,396
2,488,888
-
(2,488,888)
12,980 1,033 -
Total non-operating revenues (expenses)
2,496,193
12,396
(2,483,797)
14,013
-
452,498
Net income/(loss) Net assets, beginning Net assets, ending
13,103,050 $ 13,555,548
5,091 -
452,498
257,928 11,680,229 $ 11,938,155
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Administrative Legislative: Personal services Operating Total legislative Executive: Personal services Operating Capital
$
42,805 32,854 75,659
Actual
$
23,330 14,688 38,018
Variance Favorable (Unfavorable)
$
19,475 18,166 37,641
$
18,032 5,142 23,174
110,900 11,938 122,838
51,320 3,619 54,939
67,899
48,674 4,219 52,893
Town Clerk: Personal services Operating
30,875 15,532
14,275 4,128
16,600 11,404
14,480 9,009
Total Town Clerk
46,407
18,403
28,004
23,489
Finance Personal services Operating Capital Total Finance
399,510 167,974 30,000 597,484
161,598 80,033 2,820 244,451
237,912 87,941 27,180 353,033
164,697 70,601 3,457 238,755
3,250 39,570 42,820
1,813 11,553 13,366
1,437 28,017 29,454
1,701 28,708 30,409
16,887 16,887
7,009 7,009
9,878 9,878
5,742 5,742
902,095
376,186
525,909
374,462
Total executive
Legal: Personal services Operating Total Legal Non Departmental: Personal services Operating Capital Total Non Departmental Total Administrative
59,580 8,319 -
Prior Year Actual
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended March 31, 2014
Budget Public Works/Utilities Utilities Administration Personal services Operating Capital Total Utilities Administration Vehicle Maintenance Personal services Operating Capital Total Vehicle Maintenance Water/water plant operations Personal services Operating Capital Total Water/water plant operations Wastewater operations Personal services Operating Capital Total Wastewater operations Total operations/utilities Debt Services Transfers Out Contingency TOTAL EXPENDITURES
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
140,728 94,989 235,717
67,210 46,187 113,397
73,518 48,802 122,320
60,804 31,228 92,032
61,793 12,195 73,988
28,574 2,904 31,478
33,219 9,291 42,510
36,337 4,671 41,008
449,795 555,921 926,865 1,932,581
217,966 234,371 93,274 545,611
231,829 321,550 833,591 1,386,970
190,879 260,568 94,629 546,076
177,130 947,769 2,332,034 3,456,933
80,951 487,500 171,237 739,688
96,179 460,269 2,160,797 2,717,245
75,684 498,211 234,112 808,007
5,699,219
1,430,174
4,269,045
1,487,123
860,450 -
27,708 -
832,742 -
88,464 -
$ 7,461,764
$ 1,834,068
5,627,696
$ 1,950,049
$
TOWN OF LANTANA, FLORIDA Investment Earnings Quarter Closing March 31, 2014 FLORIDA STATE BOARD OF ADMINISTRATION (SBA) *EACH ACCOUNT COMBINES FLORIDA PRIME AND FUND B October SBA Rate General Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
November
0.18%
December
0.17%
0.16%
January
February
March
0.15%
0.16%
0.15%
Total 0.16%
177,465
177,486
177,506
177,526
2,177,672
2,177,935
177,465
21
20
19
2,000,000 147
262
14,155 285
2,014,155 754
177,486
177,506
177,526
2,177,672
2,177,935
2,192,374
2,192,374
184,108
184,130
184,151
184,171
1,684,287
1,684,489
184,108
22
21
20
1,500,000 116
202
32,263 222
1,532,263 602
184,130
184,151
184,171
1,684,287
1,684,489
1,716,973
1,716,973
6,840
6,841
6,842
6,843
6,844
6,844
6,840
-
-
-
-
-
(5,761) 0
(5,761) 4
Utility Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal. Impact Fee Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
1
1
1
1
6,841
6,842
6,843
6,844
6,844
1,083
1,083
27,442
27,445
27,448
27,451
27,454
27,457
27,442
-
-
-
-
-
(23,114) 0
(23,114) 16
1998 Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
3
3
3
3
3
27,445
27,448
27,451
27,454
27,457
4,343
4,343
4,023
4,024
4,024
4,024
4,025
4,025
4,023
-
-
-
-
-
(3,388) 0
(3,388) 2
RR&I Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
0
0
0
0
4,024
4,024
4,024
4,025
4,025
638
638
16,806
16,808
16,810
16,812
16,814
16,815
16,806
-
-
-
-
-
(14,155) 0
(14,155) 10
Bond Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
2
2
2
2
2
16,808
16,810
16,812
16,814
16,815
2,660
2,660
50 50
47 47
46 46
268 268
470 470
507 507
1,388 1,388
23 27 50
22 25 47
21 24 46
148 120 268
264 206 470
285 222 507
764 624 1,388
SBA TOTALS Total Investment Earnings Total Admin. Charges Net Investment Earnings Investment Earnings Net of Admin. Charges General Fund Utility Fund
October
November
December
January
February
March
Total
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)
0.40% 0.07% 433 451 3 (564)
0.40% 0.07% 412 459 3 (732)
0.40% 0.07% 443 308 3 (368)
0.40% 0.07% 337 226 3 0
0.20% 0.07% 241 171 2 (640)
0.20% 0.07% 235 173 2 (630)
323
143
385
565
(226)
(219)
Operating Demand Deposit Water Plant Reserve
15,122,983 2,000,000 373,703
13,480,513 4,000,000 373,733
10,948,425 4,000,000 373,762
7,358,198 4,000,000 373,785
7,643,775 4,000,000 373,805
5,479,559 6,000,000 373,827
Ending Balances
17,496,685
17,854,246
15,322,188
11,731,983
12,017,579
11,853,386
0.20% 22
0.20% 26
0.20% 481 340 821
0.20% 428 307 736
0.20% 487 339 826
4,832,150
4,791,690
4,876,320
812 806 2 1,620
859 882 2 1,743
Investment Earnings
0.33% 0.07% 2,102 1,788 15 (2,934) 970
Ending Account Balances per Statement
TD BANK ACCOUNT TD Bank Rate Investment Earnings (Utility Fund) Investment Earnings (General Fund) Investment Earnings
22
26
0.20% 261 182 443
Ending Balance
129,447
213,278
4,872,525
General Fund Utility Fund Forfeiture Fund
457 499 3 959
0.20% 1,706 1,168
TOTAL INVESTMENT EARNINGS BY FUND
$
$
434 511 3 948
$
646 594 3 1,243
$
825 826 3 1,654
$
$
$
4,034 4,118 15 8,167
