Attachment 2
CAPITAL ASSETS/ AVAILABLE
TOTAL ACTUAL ACTUAL TOTAL NON-SPENDABLE/ (UNRESTRICTED) FUND FY 2023-24 FY 2023-24 FUND RESTRICTED/ FUND
BALANCE REVENUES EXPENDITURES TRANSFERS T RANSFERS BALANCE COMMITTED/ BALANCE AS OF 7/1/2023 12 MONTHS 12 MONTHS IN OUT AS OF 6/30/24 ASSIGNED* AS OF 6/30/24* 001 GENERAL FUND 56,921,885 $ 20,217,348 $ (49,746,363) $ 40,150,895 $ (6,683,195) $ 60,860,570 $ (127,446) $ 60,733,124$ 002 EMID 1,845,803$ 40,896,367 $ (262,410) $ - $ (40,150,895)$ 2,328,865 $ - $ 2,328,865$ 003 RECREATION 36,980 $ 2,359,196$ (2,942,453) $ 546,277 $ - $ - $ - $ - $ GENERAL FUND (001-003) 58,804,668$ 63,472,911 $ (52,951,226) $ 40,697,172 $ (46,834,090) $ 63,189,435 $ (127,446) $ 63,061,989$ 005 GENERAL FUND - COMMUNITY BENEFITS PROGRAM 1,180,393 $ 52,054 $ (155,668)$ - $ - $ 1,076,779$ (1,076,779) $ - $ 006 GENERAL FUND - DARE 41,733 $ 1,923 $ - $ - $ - $ 43,656$ (43,656) $ - $ 007 GENERAL FUND - SOLAR INCENTIVE GRANT PROGRAM 68,884 $ 2,618 $ (19,000)$ - $ - $ 52,502$ (52,502) $ - $ 008 GENERAL FUND - RENTAL ASSISTANCE PROGRAM 61,859 $ 2,851 $ - $ - $ - $ 64,710$ (64,710) $ - $ 009 GENERAL FUND - ASSET SEIZURE/FORFEITURE 24,853 $ 1,145 $ - $ - $ - $ 25,998$ (25,998) $ - $ 010 GENERAL FUND - PENSION STABILIZATION 94,514 $ 4,355 $ - $ - $ - $ 98,869$ (98,869) $ - $ 011 GENERAL FUND - FACILITIES REPLACEMENT 2,474,874 $ 114,045 $ - $ - $ - $ 2,588,919$ (2,588,919) $ - $ 012 GENERAL FUND - SUSTAINABLE FOSTER CITY 207,804 $ 11,733 $ (5,932) $ 50,000 $ - $ 263,605$ (263,605) $ - $ TOTAL ALL GENERAL FUND (FUNDS 001-009) 62,959,582 $ 63,663,635 $ (53,131,826) $ 40,747,172 $ (46,834,090) $ 67,404,473 $ (4,342,484) $ 63,061,989 $
SPECIAL REVENUE FUNDS
101 TRAFFIC SAFETY 7,497 $ 42,389 $ (43,605) $ - $ - $ 6,281$ (6,281) $ (0) $ 102 MEASURE "A" 4,686,950 $ 1,183,512 $ (657,846) $ - $ - $ 5,212,616$ (4,686,950) $ 525,666 $ 103 GAS TAX 517,184 $ 951,739 $ (935,549) $ - $ - $ 533,374$ (517,184) $ 16,190 $ 104 PARK-IN-LIEU FEES 2,902,945 $ 133,771 $ - $ - $ - $ 3,036,716$ (2,902,945) $ 133,771 $ 105 MEASURE "M" - $ 100,000$ (100,000) $ - $ - $ - $ - $ - $ 108 SLESF/COPS GRANT - $ 186,159$ (186,159) $ - $ - $ - $ - $ - $ 114 CALOPPS 459,335 $ 533,753 $ (336,379) $ - $ - $ 656,709$ - $ 656,709$ 116 FOSTER CITY FOUNDATION 413,212 $ 41,261 $ (44,288) $ - $ (21,948)$ 388,237 $ (20,103) $ 368,134 $ 119 SB 1 ROAD MAINTENANCE AND REHAB 863,817 $ 929,762 $ - $ - $ - $ 1,793,579$ (450,000) $ 1,343,579 $ 122 HOUSING SUCCESSOR-LMIHF 2,441,355$ 190,399 $ (133,801) $ 63,564 $ - $ 2,561,517$ - $ 2,561,517$ 124 FC AFFORDABLE HOUSING FUND 4,642,671$ 134,697 $ (43,717) $ - $ - $ 4,733,651$ (4,023,577) $ 710,074 $ 128 GENERAL PLAN MAINTENANCE 1,927,194$ 488,945 $ (128,968) $ - $ - $ 2,287,171$ - $ 2,287,171$ 129 CONSTRUCTION AND DEMO RECYCLING 758,768$ 119,666 $ (105,716) $ - $ (50,000)$ 722,718 $ - $ 722,718$ 130 TECHNOLOGY MAINTENANCE 226,770$ 74,238 $ (91,081) $ - $ - $ 209,928$ - $ 209,928$ 131 SB 1186 39,618$ 8,931 $ (1,300) $ - $ - $ 47,249$ - $ 47,249$ 132 SMIP FEE 5,385$ 416 $ - $ - $ - $ 5,801$ - $ 5,801$ 133 CRV GRANT FUND 14,124$ 8,984 $ (11,993)$ - $ - $ 11,115$ - $ 11,115$ 134 CURBSIDE RECLYCLING 253,249$ 24,775 $ - $ - $ - $ 278,024$ - $ 278,024$ 135 GREEN BUILDING FEE 6,928$ 747 $ - $ - $ - $ 7,675$ - $ 7,675$ 136 MEASURE W 1,234,883$ 476,881 $ (240,215) $ - $ - $ 1,471,549$ (575,000) $ 896,549 $ 137 COMMERCIAL LINKAGE FEE 588,598 $ 4,888,484$ (9,909) $ - $ - $ 5,467,173$ - $ 5,467,173$ 138 TENANT RELOCATION ASSISTANCE 234,143 $ 10,790 $ - $ - $ - $ 244,933$ - $ 244,933$ 139 WORKFORCE HOUSING 158,351 $ 632,613 $ (790,965) $ - $ (557,446)$ (557,447) $ - $ (557,447)$ 140 EQUIPMENT REPLACEMENT-WORKFORCE HOUSING 22,418 $ 23,577 $ - $ - $ - $ 45,995$ - $ 45,995$ 141 SB 1383 IMPLEMENTATION 31,221 $ 94,628 $ (42,495) $ - $ - $ 83,354$ - $ 83,354$ 142 PARK FACILITIES IMPACT FEE -$ 568,798$ - $ - $ - $ 568,798$ - $ 568,798$ 143 PUBLIC SAFETY IMPACT FEE -$ 61,579$ - $ - $ - $ 61,579$ - $ 61,579$ 144 TRANSPORTATION IMPACT FEE -$ 192,840$ - $ - $ - $ 192,840$ - $ 192,840$ TOTAL SPECIAL REVENUE FUNDS 22,436,616 $ 12,104,334 $ (3,903,986) $ 63,564 $ (629,394)$ 30,071,134$ (13,182,040) $ 16,889,094 $
CITY OF FOSTER CITY/ESTERO MUNICIPAL IMPROVEMENT DISTRICT
CHANGE IN FUND BALANCES
FOR THE TWELVE MONTHS ENDED JUNE 30, 2024
Attachment 2
CAPITAL ASSETS/ AVAILABLE
TOTAL ACTUAL ACTUAL TOTAL NON-SPENDABLE/ (UNRESTRICTED) FUND FY 2023-24 FY 2023-24 FUND RESTRICTED/ FUND
BALANCE REVENUES EXPENDITURES TRANSFERS T RANSFERS BALANCE COMMITTED/ BALANCE AS OF 7/1/2023 12 MONTHS 12 MONTHS IN OUT AS OF 6/30/24 ASSIGNED* AS OF 6/30/24*
CITY OF FOSTER CITY/ESTERO MUNICIPAL IMPROVEMENT DISTRICT
CHANGE IN FUND BALANCES
FOR THE TWELVE MONTHS ENDED JUNE 30, 2024
DEBT SERVICE FUNDS
230 LEVEE DEBT SERVICE FUND 5,505,921 $ 4,409,256 $ (5,348,588) $ - $ - $ 4,566,590$ - $ 4,566,590$ 231 LEVEE DEBT SERVICE FUND -2023 GO BONDS - $ 231,466$ (109,012) $ - $ - $ 122,454$ - $ 122,454$
CAPITAL PROJECTS FUNDS
301 CIP PROJECTS-CITY 77,484,135 $ 4,767,085 $ (3,727,290) $ 6,095,303 $ - $ 84,619,233$ (67,228,640) $ 17,390,593 $ 326 CAPITAL ASSET ACQUISITION AND REPLACEMENT FUND 2,880,117$ 1,297,873 $ - $ 557,446$ - $ 4,735,436$ - $ 4,735,436$ 327 LEVEE PROJECT FUND 5,080,547$ 124,815 $ (7,320,333)$ 5,017,517 $ - $ 2,902,546$ (2,118,579) $ 783,967 $ 328 LEVEE PROJECT FUND - 2023 GO Bonds -$ 5,031,254$ - $ - $ (5,017,517)$ 13,737 $ - $ 13,737$ TOTAL CAPITAL PROJECTS FUNDS 85,444,799 $ 11,221,027 $ (11,047,623) $ 11,670,266 $ (5,017,517) $ 92,270,952 $ (69,347,219) $ 22,923,733 $
ENTERPRISE FUNDS
401 WATER REVENUE 10,347,049 $ 19,108,497 $ (17,478,788) $ - $ (1,132,993)$ 10,843,765 $ (782,143) $ 10,061,622$ 405 CIP-WATER 28,827,164 $ 11,909 $ (548,480)$ 1,173,535 $ - $ 29,464,128$ (25,428,244) $ 4,035,884 $ 408 WATER EQUIPMENT REPLACEMENT 4,070,150 $ 448,097 $ (56,695) $ - $ (40,543)$ 4,421,009$ (140,928) $ 4,280,081 $ 409 WATER CONNECTION FEES 1,206,901 $ 49,158 $ (1,100,000)$ - $ - $ 156,059$ - $ 156,059$ 451 WASTEWATER REVENUE 27,456,097 $ 24,287,239 $ (24,341,797) $ 4,275 $ (16,734,175)$ 10,671,639 $ - $ 10,671,639$ 453 WASTEWATER RATE STABLIZATION 2,000,000 $ - $ - $ 2,089,225$ (2,089,225) $ 2,000,000 $ (2,000,000) $ - $ 454 SM-FC PUBLIC FINANCING AUTHORITY LOAN (38,478,808) $ - $ (1,248,866)$ 2,089,225 $ - $ (37,638,449)$ - $ (37,638,449)$ 455 CIP-WASTEWATER 157,697,380 $ - $ (1,793,328)$ 11,500,000 $ - $ 167,404,052$ (155,697,380)$ 11,706,672 $ 456 WASTEWATER PLANT EXPANSION 1,478 $ 2,797 $ - $ - $ (4,275)$ - $ - $ - $ 458 WASTEWATER EQUIPMENT REPLACEMENT 4,027,644 $ 342,955 $ (184,367) $ - $ - $ 4,186,232$ (1,570,314) $ 2,615,918 $ 459 WASTEWATER NOTES/WIFIA LOAN (59,130,828) $ 5,884,510 $ (2,127,502) $ 3,144,950 $ - $ (52,228,870)$ - $ (52,228,870)$ 460 WASTEWATER CONNECTION FEES 347,531 $ 16,015 $ - $ - $ - $ 363,546$ - $ 363,546$ 461 STATE REVOLVING LOAN FUND - $ - $ - $ - $ - $ - $ - $ - $ TOTAL ENTERPRISE FUNDS 138,371,758 $ 50,151,177 $ (48,879,823) $ 20,001,210 $ (20,001,211) $ 139,643,111 $ (185,619,009) $ (45,975,898) $
INTERNAL SERVICE FUNDS
501 VEHICLE RENTAL FUND 7,918,310 $ 2,337,218 $ (1,548,694) $ - $ - $ 8,706,834$ (2,041,370) $ 6,665,464 $ 502 EQUIPMENT REPLACEMENT FUND 9,107,957 $ 626,962 $ (298,504) $ - $ - $ 9,436,415$ (1,863,870) $ 7,572,545 $ 503 SELF INSURANCE FUND 973,000 $ 1,554,463$ (1,471,459) $ - $ - $ 1,056,004$ - $ 1,056,004$ 504 INFORMATION TECHNOLOGY 5,900,800 $ 2,973,910 $ (2,160,517) $ - $ - $ 6,714,193$ (390) $ 6,713,803$ 505 BUILDING MAINTENANCE 8,073,496 $ 4,107,704 $ (2,605,014) $ - $ - $ 9,576,186$ - $ 9,576,186$ 507 LONGEVITY RECOGNITION PLAN 2,660,354 $ 374,053 $ (209,918) $ - $ - $ 2,824,490$ - $ 2,824,490$ 508 PEMHCA FUND 6,287,274 $ 579,697 $ (204,288) $ - $ - $ 6,662,683$ - $ 6,662,683$ 509 COMPENSATED ABSENCES FUND 3,464,914 $ 742,701 $ (132,397) $ - $ - $ 4,075,218$ - $ 4,075,218$ TOTAL INTERNAL SERVICE FUNDS 44,386,105 $ 13,296,708 $ (8,630,791) $ - $ - $ 49,052,022$ (3,905,630) $ 45,146,392 $
FIDUCIARY FUND
604 SUCCESSOR AGENCY (590,865) $ 497,524 $ (291,718) $ - $ - $ (385,059)$ - $ (385,059)$ 607 TOURISM ASSESSMENT - $ - $ - $ - $ - $ - $ - $ - $ 608 SMC FIRE -$ 117,640$ (117,640) $ - $ - $ - $ - $ - $ TOTAL CITY / EMID FUNDS 358,513,916 $ 155,692,767 $ (131,461,006) $ 72,482,212 $ (72,482,212) $ 382,745,677 $ (276,396,382) $ 106,349,295 $ -$
* Available Balance excludes Capital Assets and Non-Spendable, Restricted, Committed, and/or Assigned Funds, including Prepayments, Inventory, Garbage Stabilization Reserve, unrealized investment gains, and unspent funds for previously approved CIP projects.