CITY OF FOSTER CITY / EMID
Summary of Resources and Requirements by Funds
For the Fiscal Year Ended June 30, 2024
THIRD QUARTER PROJECTIONS THROUGH JUNE 30, 2024
Total Fund
Balance
July 1, 2023
Estimated
Revenues Transfers In Transfers Out Total Available
Estimated
Operating
Expenditures
Capital
Expenditures
Total
Requirements
Net Increase
(Decrease) in
Reserves
Total Fund
Balance
June 30, 2024
Less:
Nonspendable,
Restricted,
Committed
Available/
Unassigned
June 30, 2024
General Funds
001 General Fund Operating 56,515,374$ 19,482,810$ 41,144,142$ 6,949,939$ 110,192,387$ 55,776,096$ -$ 55,776,096$ (2,099,083)$ 54,416,291$ 150,653$ 54,265,638$ 002 General Fund-District 1,845,803$ 39,672,400$ -$ 41,148,594$ 369,609$ 369,609$ -$ 369,609$ (1,845,803)$ -$
-$
-$
003
General Fund-Special Recreation 36,980$ 2,312,836$ 907,956$ -$ 3,257,772$ 3,257,772$ -$ 3,257,772$
(36,980)$ -$
-$
-$
005
Community Benefits Program Fund 1,180,393$ 45,700$ -$ -$ 1,226,093$ 359,667$
-$ 359,667$
(313,967)$ 866,426$ -$
866,426$
006 DARE 41,733$ 1,700$ -$ -$ 43,433$ 600$ -$ 600$ 1,100$ 42,833$ -$ 42,833$ 007 Solar Incentive Grant Program 68,884$ 2,500$ -$
-$ 71,384$ 25,000$
-$ 25,000$
(22,500)$ 46,384$ -$
46,384$
008 Employee Rental Assistance Program 61,859$ 2,300$ -$
-$ 64,159$ -$
-$ -$
2,300$ 64,159$ -$
64,159$
009 Asset Seizure 24,853$ 2,100$
-$
-$ 26,953$ 4,097$
-$ 4,097$
(1,997)$ 22,856$ -$
22,856$
010 Discretionary Pension Liability Stabilization Fund 94,514$ 4,200$ -$
-$ 98,714$ -$
-$ -$
4,200$ 98,714$ -$
98,714$
011 Facilities Replacement Fund 2,474,874$ 108,200$ -$ -$ 2,583,074$ -$
-$ -$ 108,200$ 2,583,074$ -$ 2,583,074$ 012 Sustainable Foster City 207,804$ 11,100$ 50,000$ -$ 268,904$ 120,945$ -$ 120,945$
(59,845)$ 147,959$ -$
147,959$
Subtotal General Funds 62,553,071$ 61,645,846$ 42,102,098$ 48,098,533$ 118,202,482$ 59,913,786$ -$ 59,913,786$ (4,264,375)$ 58,288,696$ 150,653$ 58,138,043$ Special Revenue Funds
101 Traffic Safety 7,497$ 60,000$ -$ -$ 67,497$ 60,000$
-$ 60,000$
-$
7,497$ -$
7,497$
102
Measure A 4,686,950$ 1,078,300$ -$
-$ 5,765,250$ -$
4,253,588$ 4,253,588$ (3,175,288)$ 1,511,662$ -$ 1,511,662$
103 Gas Tax (2103, 2105-2107.5) 517,184$ 938,002$ -$ -$ 1,455,186$ 16,483$
919,066$ 935,549$ 2,453$ 519,637$ -$ 519,637$
104 Park In-Lieu Fees 2,902,945$ 126,700$ -$ -$ 3,029,645$ -$ -$ -$ 126,700$ 3,029,645$ -$ 3,029,645$ 105 Measure M -$ 121,700$
-$
-$ 121,700$ -$
100,000$ 100,000$ 21,700$ 21,700$ -$ 21,700$
108 SLESF/COPS Grant -$ 155,000$
-$
-$ 155,000$ 100,000$
-$ 100,000$
55,000$ 55,000$ -$
55,000$
114 CalOpps.org 459,335$ 533,377$ -$ -$ 992,712$ 783,050$
-$ 783,050$
(249,673)$ 209,662$ -$
209,662$
116 Foster City Foundation 413,212$ 38,900$ -$ 21,948$ 430,164$ 136,250$ -$ 136,250$ (119,298)$ 293,914$ -$
293,914$
119 SB1 Road Maintenance and Rehabilitation 863,817$ 877,898$ -$ -$ 1,741,715$ -$
455,057$ 455,057$ 422,841$ 1,286,658$ -$ 1,286,658$
122
Low- and Moderate-Income Housing Fund 2,441,355$ 185,500$ 41,983$ -$ 2,668,838$ 278,080$ -$ 278,080$
(50,597)$ 2,390,758$ -$
2,390,758$
124 City Affordable Housing Fund 4,642,671$ 37,000$ -$ -$ 4,679,671$ 235,000$
-$ 235,000$
(198,000)$ 4,444,671$ -$
4,444,671$
125 Sustainable Foster City Fund (Discontinued) -$ -$
-$
-$ -$ -$
-$ -$
-$
-$
-$
-$
127
BAERS (Discontinued) -$ -$
-$
-$ -$ -$
-$ -$
-$
-$
-$
-$
128
General Plan Maintenance Fund 1,927,194$ 90,600$ -$ -$ 2,017,794$ 167,400$
-$ 167,400$
(76,800)$ 1,850,394$ -$
1,850,394$
129 Construction & Demolition Recycling Fund 758,768$ 81,800$ -$ 50,000$ 790,568$ 309,750$ -$ 309,750$ (277,950)$ 480,818$ -$ 480,818$ 130 Technology Maintenance Fund 226,770$ 65,540$ -$ -$ 292,310$ 105,485$
-$ 105,485$
(39,945)$ 186,825$ -$
186,825$
131 SB 1186 Fund 39,618$ 5,800$
-$
-$ 45,418$ 1,300$
-$ 1,300$
4,500$ 44,118$ -$
44,118$
132 SMIP Fee Fund 5,385$ 620$
-$
-$ 6,005$ 500$
-$ 500$
120$
5,505$ -$
5,505$
133
CRV Grant Fund 14,124$ 8,940$
-$
-$ 23,064$ 12,000$
-$ 12,000$
(3,060)$ 11,064$ -$
11,064$
134 Curbside Recycling Fee Fund 253,249$ 26,000$ -$ -$ 279,249$ 25,000$
-$ 25,000$
1,000$ 254,249$ -$
254,249$
135 Green Building Fee Fund 6,928$ 1,000$ -$ -$ 7,928$ 500$ -$ 500$ 500$ 7,428$ -$ 7,428$ 136
Measure W 1,234,883$ 484,300$ -$
-$ 1,719,183$ 815,215$
-$ 815,215$
(330,915)$ 903,968$ -$
903,968$
137 Commercial Linkage Fee 588,598$ 4,844,910$ 5,433,508$ 10,000$ -$ 10,000$ 4,834,910$ 5,423,508$ -$
5,423,508$
138 Tenant Relocation Assistance 234,143$ 10,300$ -$ -$ 244,443$ 51,640$
-$ 51,640$
(41,340)$ 192,803$ -$
192,803$
139 Workforce Housing 158,351$ 636,040$ -$ -$ 794,391$ 386,187$
-$ 386,187$
249,853$ 408,204$ -$
408,204$
140 Equipment Replacement-Workforce Housing 22,418$ 29,000$ -$ -$ 51,418$ -$
-$ -$
29,000$ 51,418$ -$ 51,418$
141
SB 1383 Implementation 31,221$ 93,979$ -$ -$ 125,200$ 29,915$
-$ 29,915$
64,064$ 95,285$ -$
95,285$
142 Park Facilities Impact Fee -$ 594,113$
-$
-$ 594,113$ -$
-$ -$
594,113$ 594,113$ -$
594,113$
143 Public Safety Impact Fee -$ 64,320$
-$
-$ 64,320$ -$
-$ -$
64,320$ 64,320$ -$
64,320$
144 Transportation Impact Fee -$ 190,690$
-$
-$ 190,690$ -$
-$ -$
190,690$ 190,690$ -$
190,690$
Subtotal Special Revenue Funds 22,436,616$ 11,380,329$ 41,983$ 71,948$ 33,786,980$ 3,523,755$ 5,727,711$ 9,251,466$ 2,098,898$ 24,535,514$ -$ 24,535,514$
(Continued on next page)
Fund
ATTACHMENT 2
CITY OF FOSTER CITY / EMID
Summary of Resources and Requirements by Funds
For the Fiscal Year Ended June 30, 2024
(Continued from previous page) THIRD QUARTER PROJECTIONS THROUGH JUNE 30, 2024 Total Fund
Balance
July 1, 2023
Estimated
Revenues Transfers In Transfers Out Total Available
Estimated
Operating
Expenditures
Capital
Expenditures
Total
Requirements
Net Increase
(Decrease) in
Reserves
Total Fund
Balance
June 30, 2024
Less:
Nonspendable,
Restricted,
Committed
Available/
Unassigned
June 30, 2024
Debt Service Fund
230 Levee Debt Service Fund 2020 GO Bonds 5,505,921$ 4,103,800$ - $ - $ 9,609,721$ -$ 5,349,188$ 5,349,188$ (1,245,388) $ 4,260,533 $ - $ 4,260,533$ 231 Levee Debt Service Fund 2023 GO Bonds -$ 461,882$ - $ - $ 461,882$ -$ 109,513$ 109,513$ 352,369 $ 352,369 $ - $ 352,369$ Subtotal Debt Service Funds 5,505,921 $ 4,565,682$ - $ - $ 10,071,603$ -$ 5,458,701$ 5,458,701$ (893,019) $ 4,612,902 $ - $ 4,612,902$ Capital Projects Funds
301 Capital Investment - City 77,484,134$ 3,862,250$ 6,000,000 $ - $ 87,346,384$ -$ 4,395,000$ 4,395,000$ 5,467,250 $ 82,951,384 $ 64,260,349 $ 18,691,035 $ 326 Capital Asset Acquisition and Replacement Fund 2,880,118$ 1,243,355$ - $ - $ 4,123,473$ -$ - $ -$ 1,243,355$ 4,123,473 $ - $ 4,123,473$ 327 Levee Project Fund GO Bonds 5,080,547$ 38,400$ 5,015,737$ - $ 10,134,684$ -$ 9,438,912$ 9,438,912$ (4,384,775) $ 695,772 $ - $ 695,772$ 328 Levee Project Fund - 2023 GO Bonds -$ 5,030,337$ - $ 5,015,737$ 14,600$ -$ - $ -$ 14,600$ 14,600 $ - $ 14,600$ Subtotal Capital Projects Funds 85,444,799 $ 10,174,342$ 11,015,737 $ 5,015,737 $ 101,619,141$ -$ 13,833,912$ 13,833,912$ 2,340,430 $ 87,785,229 $ 64,260,349 $ 23,524,880 $ Enterprise Funds
Water Funds
401 Water Revenue 10,347,049$ 19,067,216$ - $ 1,120,000$ 28,294,265$ 17,922,284$ - $ 17,922,284$ 24,932 $ 10,371,981$ - $ 10,371,981$ 405 Capital Investment - Water 28,827,164$ -$ 1,120,000$ - $ 29,947,164$ -$ - $ -$ 1,120,000$ 29,947,164 $ 25,410,707 $ 4,536,457 $ 408 Water Equipment Replacement 4,070,150$ 448,097$ - $ -$ 4,518,247$ 249,000$ - $ 249,000$ 199,097 $ 4,269,247$ 156,467 $ 4,112,780$ 409 Water Connection Fee 1,206,901$ 307,259$ - $ 1,514,160$ -$ 1,100,000$ 1,100,000$ (792,741) $ 414,160 $ - $ 414,160$ Subtotal Water Funds 44,451,264 $ 19,822,572$ 1,120,000 $ 1,120,000 $ 64,273,836$ 18,171,284$ - $ 19,271,284$ 551,288 $ 45,002,552$ 25,567,174 $ 19,435,378 $ Wastewater Funds
451 Wastewater Revenue 27,456,097$ 23,150,500$ 4,275 $ 27,863,964$ 22,746,908$ 9,981,803$ - $ 9,981,803$ (14,690,992)$ 12,765,105 $ - $ 12,765,105$ 453 Wastewater Rate Stabilization Fund 2,000,000$ -$ 2,089,225$ 2,089,225 $ 2,000,000$ -$ - $ -$ - $ 2,000,000$ - $ 2,000,000$ 454 San Mateo-Foster City Public Financing Authority Loan (38,478,808)$ -$ 2,089,225$ - $ (36,389,583)$ 1,863,716$ - $ 1,863,716$ 225,509 $ (38,253,299)$ - $ (38,253,299)$ 455 Capital Investment - Wastewater 157,697,380$ -$ 36,864,852 -$ 194,562,232$ -$ 11,729,789$ 11,729,789$ 25,135,063 $ 182,832,443 $ 54,376,722 $ 128,455,721 $ 456 Wastewater Plant Expansion 1,478$ 2,797$ - $ 4,275$ -$ -$ - $ -$ (1,478)$ - $ - $ - $ 458 Wastewater Equipment Replacement 4,027,644$ 342,955$ - $ - $ 4,370,599$ 423,501$ - $ 423,501$ (80,546) $ 3,947,098$ 1,522,670 $ 2,424,428 $ 459 Wastewater Notes/WIFIA Loan Fund (59,130,828)$ 1,009,800$ 3,144,950 $ - $ (54,976,078)$ 3,144,950$ - $ 3,144,950$ 1,009,800 $ (58,121,028)$ - $ (58,121,028)$ 460 Wastewater Connection Fees 347,531$ 729,460$ - $ - $ 1,076,991$ -$ - $ -$ 729,460$ 1,076,991$ - $ 1,076,991$ 461 State Revolving Loan Fund -$ -$ - $ 14,235,063$ (14,235,063)$ -$ - $ -$ (14,235,063)$ (14,235,063) $ - $ (14,235,063)$ Subtotal Wastewater Funds 93,920,494 $ 25,235,512$ 44,192,527 $ 44,192,527 $ 119,156,006$ 15,413,970$ 11,729,789 $ 27,143,759$ (1,908,247) $ 92,012,247 $ 55,899,392 $ 36,112,855 $ Subtotal Enterprise Funds 138,371,758 $ 45,058,084$ 45,312,527 $ 45,312,527 $ 183,429,842$ 33,585,254$ 11,729,789 $ 46,415,043$ (1,356,959) $ 137,014,799$ 81,466,566 $ 55,548,233 $ Internal Service Funds
501 Vehicle Replacement 7,918,311$ 2,251,073$ - $ - $ 10,169,384$ 2,134,551$ - $ 2,134,551$ 116,522 $ 8,034,833$ 1,722,153 $ 6,312,680 $ 502 Equipment Replacement 9,107,957$ 379,463$ - $ - $ 9,487,420$ 529,500$ - $ 529,500$ (150,037) $ 8,957,920 $ 2,251,624 $ 6,706,296 $ 503 Self-Insurance 973,000$ 1,546,461$ - $ - $ 2,519,461$ 1,532,807$ - $ 1,532,807$ 13,654 $ 986,654 $ - $ 986,654$ 504 Information Technology 5,900,799$ 2,891,084$ - $ - $ 8,791,883$ 2,892,584$ - $ 2,892,584$ (1,500) $ 5,899,299$ - $ 5,899,299$ 505 Building Maintenance 8,073,496$ 3,953,045$ - $ - $ 12,026,541$ 2,974,968$ 2,974,968$ 978,077 $ 9,051,573$ - $ 9,051,573$ 507 Longevity Recognition Benefits 2,660,354$ 366,500$ - $ - $ 3,026,854$ 238,420$ - $ 238,420$ 128,080 $ 2,788,434$ - $ 2,788,434$ 508 PEMHCA Benefits Plan 6,287,275$ 561,863$ - $ - $ 6,849,138$ 245,843$ - $ 245,843$ 316,020 $ 6,603,295$ - $ 6,603,295$ 509 Compensated Absences 3,464,914$ 681,242$ - $ - $ 4,146,156$ 500,719$ - $ 500,719$ 180,523 $ 3,645,437$ - $ 3,645,437$ Subtotal Internal Service Funds 44,386,106 $ 12,630,731$ - $ - $ 57,016,837$ 11,049,392$ - $ 11,049,392$ 1,581,339 $ 45,967,445 $ 3,973,777 $ 41,993,668 $ Fiduciary Fund
604 Successor Agency of Community Development Agency (590,865)$ 295,800$ - $ - $ (295,065)$ 508,051$ - $ 508,051$ (212,251) $ (803,116) $ - $ (803,116)$ 607 Tourism Assessment -$ -$ - $ - $ -$ -$ - $ -$ - $ - $ - $ - $ 608 SMC Fire -$ 320,000$ - $ - $ 320,000$ 320,000$ - $ 320,000$ - $ - $ - $ - $ Subtotal Agency Fund (590,865) $ 615,800$ - $ - $ 24,935$ 828,051$ - $ 828,051$ (212,251) $ (803,116) $ - $ (803,116)$ Total All Funds 358,107,406 $ 146,070,814 $ 98,472,345 $ 98,498,745 $ 504,151,820 $ 108,900,238 $ 36,750,113 $ 146,750,351 $ (705,937) $ 357,401,469$ 149,851,345 $ 207,550,124 $ Fund