Murrieta City Council
December 5, 2023

ESTIMATED ENDING FUND BALANCE BY FUND FOR FISCAL YEAR 2022/23 Fund No. Fund Description Beginning Balance Estimated Revenues Transfers In Transfers Out Estimated Expenditures Estimated Ending Balance Amount Unavailable Amount Available 110 General Fund 53,491,681$ 70,969,884$ 41,532$ (1,306,275)$ (59,030,469)$ 64,166,353$ 27,574,985$ 36,591,368$ 111 Gen Fund Measure T 43,510,404 28,538,253$ -$ (6,032,272)$ (13,093,289)$ 52,923,095 21,710,292 31,212,803 151 Fire District Admin 3,979,165 18,865,709$ 2,863,919$ -$ (21,792,987)$ 3,915,806 3,923,278 (7,472) 171 Community Service District Fund 1,118,568 2,891,764$ 1,696,112$ -$ (4,551,908)$ 1,154,536 1,162,197 (7,661) 311 Library Fund 1,405,213 2,750,410$ 61,541$ -$ (2,829,028)$ 1,388,137 1,388,137 - Sum of All Major Funds 103,505,031$ 124,016,019$ 4,663,104$ (7,338,547)$ (101,297,681)$ 123,547,926$ 55,758,888$ 67,789,038$ Fund No. Fund Description Beginning Balance Estimated Revenues Transfers In Transfers Out Estimated Expenditures Estimated Ending Balance* 112 General Fund Capital 6,702,061$ -$ 1,996,200$ (61,644)$ (521,532)$ 8,115,085$ 118 Traffic Safety Fund 116,834 12,899$ -$ -$ (11,039)$ 118,695 119 Crime Prevention Fund 80,043 51,200$ -$ -$ (135,896)$ (4,652) 127 DIF Fire Fund 1,495,148 594,596$ -$ -$ (16,998)$ 2,072,746 128 DIF Freeway overcrossing Bridg 8,454,376 196,159$ -$ -$ (12,338)$ 8,638,197 129 DIF General Facility Fund (91,296) 212,572$ -$ -$ (43)$ 121,233 130 DIF Law Enforcement Fund 1,088,579 541,868$ -$ -$ (436)$ 1,630,010 131 DIF Library Fund 1,135,844 358,771$ -$ -$ (6,180)$ 1,488,434 132 DIF Open Space Fund 1,778,677 41,272$ -$ -$ (856)$ 1,819,093 133 DIF Park Land Fund 2,805,277 3,808,528$ 28,917$ (34,668)$ (527,192)$ 6,080,862 134 DIF Storm Drain Fund 4,681,589 481,384$ -$ -$ (2,157)$ 5,160,817 135 DIF Street Fund 10,701,936 248,714$ -$ -$ (12,155)$ 10,938,495 136 DIF Traffic Signal Fund 2,442,319 1,018,851$ -$ -$ (98,684)$ 3,362,486 137 DIF Community Center Fund 1,134,670 682,012$ -$ -$ (445)$ 1,816,237 138 DIF-FWY,Street,Bridge 4,952,539 5,137,973$ -$ -$ (209,702)$ 9,880,811 140 RSA Fees Fund 200,799 4,659$ -$ -$ (94)$ 205,364 141 SWRBBD Fund 192,659 74,889$ -$ -$ (94)$ 267,453 161 TUMF Fund 12,115 -$ -$ -$ (393,378)$ (381,263) 180 CSD Exempt Maintenance 251,357 1,759,772$ 78,189$ -$ (2,089,318)$ - 181 Local Zone A Fund - 195,582$ 35,987$ (47,958)$ (183,611)$ - 182 Local Zone B Fund 372,636 480,277$ -$ (107,299)$ (442,115)$ 303,500 183 Local Zone C Fund 75,172 43,597$ -$ (9,823)$ (44,939)$ 64,006 184 Local Zone D Fund 22,828 105,147$ 13,187$ (34,784)$ (106,378)$ - 185 Local Zone E Fund (0) 14,960$ 12,657$ (9,765)$ (17,852)$ - 186 Local Zone F Fund 57,060 57,446$ -$ (3,871)$ (51,355)$ 59,280 188 Local Zone H Fund 51,471 140,880$ 2,194$ (16,699)$ (177,846)$ - 189 Local Zone I Fund 17,729 4,847$ -$ -$ (3,550)$ 19,026 200 LLD 1 Copper Canyon Fund 131,998 489,983$ -$ (15,485)$ (488,049)$ 118,447 202 LLD 2 Grizzly Ridge Fund 99,800 136,278$ -$ (5,836)$ (140,666)$ 89,575 203 LLD 3 Cherry Street Fund 11,074 18,307$ -$ (693)$ (12,947)$ 15,741 204 LLD 4 Western Pacific Fund 124,476 61,779$ -$ (5,258)$ (57,107)$ 123,891 205 LLD 5 Murrieta Ranchos Fund 9,999 26,988$ -$ (3,987)$ (23,381)$ 9,618 206 LLD 6 Fallsgrove Fund 64,315 20,718$ -$ (3,640)$ (16,688)$ 64,705 207 LLD 7 Continental Homes Fund 20,077 31,600$ -$ (3,987)$ (24,296)$ 23,394 208 LLD 8 Lincoln Ranch Fund 189,516 147,274$ -$ (8,609)$ (164,706)$ 163,475 209 LLD 9 Tapestry Fund 21,766 53,956$ -$ (1,965)$ (43,845)$ 29,912 210 LLD 10 Hwy 79/Hunter Rd Fund (25,511) 154,117$ 36,388$ (12,250)$ (152,744)$ - 211 LLD 11 Masters/Winchester Fnd (0) 48,279$ 6,512$ (16,410)$ (38,381)$ - 212 LLD 12 Warm Springs Fund 1,117,709 738,663$ -$ (35,304)$ (512,348)$ 1,308,719 213 LLD 13 Mira Mosa Fund 15,700 292,209$ -$ (11,903)$ (271,616)$ 24,390 214 LLD 14 Sycamore Ranch Fund 31,068 55,310$ -$ (4,218)$ (43,432)$ 38,727 215 LLD 15 Greer Ranch Fund 37,773 90,543$ -$ (636)$ (98,429)$ 29,251 216 LLD 16 Mapleton Fund 420,950 642,369$ -$ (16,930)$ (578,982)$ 467,407 217 LLD 17 Country Gate Fund 127,193 67,846$ -$ (4,218)$ (62,741)$ 128,080 218 LLD 18 Vineyards Fund 135,785 91,989$ -$ (3,178)$ (119,338)$ 105,259 219 LLD 19 Murrieta Oaks Fund 355,527 393,934$ -$ (10,458)$ (442,471)$ 296,532 220 LLD 20 Blackmore Ranch Fund 293,509 155,562$ -$ (3,582)$ (218,547)$ 226,943 221 LLD 21 Northstar Ranch Fund 566,670 246,479$ -$ (11,267)$ (264,533)$ 537,349 222 LLD 22 US Homes Fund 5,432 7,446$ -$ (347)$ (5,106)$ 7,424 11/28/2023
1 ESTIMATED ENDING FUND BALANCE BY FUND FOR FISCAL YEAR 2022/23 Fund No. Fund Description Beginning Balance Estimated Revenues Transfers In Transfers Out Estimated Expenditures Estimated Ending Balance* 223 LLD 23 Creekside Village Fund 280,150 206,701$ -$ (5,085)$ (186,769)$ 294,997 224 LLD 24 Springbrook Fund 12,935 35,540$ -$ (1,676)$ (34,608)$ 12,191 225 LLD 25 Golden Cities Fund 707,123 235,055$ -$ (3,005)$ (332,517)$ 606,656 226 LLD 26 Murrieta Field Fund 26,607 12,489$ -$ (1,560)$ (9,738)$ 27,798 227 LLD 27 Hunter Ridge Fund 266,250 98,814$ -$ (2,600)$ (87,839)$ 274,625 228 LLD 28 Lantana 10,804 68,119$ -$ (1,560)$ (51,788)$ 25,575 229 LLD 29 Gallery Esstates 9,642 9,296$ -$ -$ (6,872)$ 12,067 302 Measure A Fund 8,882,672 3,964,827$ -$ (730,600)$ (882,331)$ 11,234,568 306 State Gas Tax (HUTA) Fund 10,428,482 3,064,073$ -$ -$ (3,007,931)$ 10,484,623 307 SB1 Road Maintenance and Rehab 5,129,219 2,601,517$ -$ -$ (2,877,984)$ 4,852,752 316 Developer Agreement Fund 1,849,797 124,233$ -$ -$ (93,152)$ 1,880,878 319 Reimbursement Agreement Fund (19,450) -$ -$ -$ -$ (19,450) 322 Low Mod Income Housing Fund 12,581,996 161,399$ -$ -$ (43,270)$ 12,700,125 323 Housing Authority 992,537 23,031$ -$ -$ (471)$ 1,015,097 335 Prop 68 Grant Fund - -$ -$ -$ -$ - 336 Air Quality Management Fund 692,973 165,199$ -$ -$ (66,246)$ 791,926 341 Community Development Block Gr (181,647) 75,714$ 34,668$ -$ (64,199)$ (135,464) 353 Recycling Grant Fund 71,312 142,253$ -$ -$ (136,069)$ 77,496 354 Projects Funded Via Grants Fun 70,446 -$ -$ -$ (71,888)$ (1,443) 355 OTS Grant Fund (20,683) 92,349$ -$ -$ (81,776)$ (10,111) 357 Library Grant Fund 3,470 69,145$ -$ -$ (48,914)$ 23,701 358 Other State Grants Fund 57,056 175,602$ -$ (8,805)$ (414,270)$ (190,417) 361 Federal Grant - DOJ (12,965) 35,466$ -$ -$ (21,418)$ 1,083 371 Federal Funding-Toll Credits (0) -$ 0$ -$ -$ 0 376 Homeland Security - Federal Gr (121,114) 3,932$ -$ -$ (9,417)$ (126,599) 374 ARPA Federal Grant Fund 78,072 5,709,870$ -$ (1,500,000)$ (3,883,684)$ 404,258 377 Federal Grant FEMA-EMPG (1,133,109) 1,688,987$ -$ -$ (1,067,692)$ (511,814) 380 State Transportation Imp Fund (72,986) 1,921$ -$ -$ -$ (71,065) 402 Seized Assets Fund-State 118,939 8,653$ -$ -$ (111)$ 127,481 403 Seized Assets Fund-Federal DOJ 799,888 17,652$ 83,696$ -$ (261,209)$ 640,028 404 Seized Asset Fnd-Fed Treasury 190,508 4,421$ -$ -$ -$ 194,930 405 Undercover Operations 37,611 (2,500)$ -$ -$ (47)$ 35,063 411 Supplemental Law Fund 222,826 291,181$ -$ -$ (374,664)$ 139,343 431 NPDES CSA 152 Fund 1,390,937 421,134$ 300,000$ -$ (872,291)$ 1,239,781 451 City Wide Debt Service (0) -$ 577,811$ -$ (577,811)$ - 502 SuccessrAgncy-2005 TABS Residu 156,306 3,627$ -$ -$ (26)$ 159,908 511 Obligation Payment Fund 344,128 8,054$ -$ -$ (163)$ 352,019 512 Obligation Pmt Fund 2005 TABs (9,712) -$ -$ -$ (789)$ (10,501) 513 Obligation Pmnt Fnd 2007 TABs 1,975,629 45,263$ -$ -$ (100,534)$ 1,920,358 551 Area Drainage Fund 5,622,926 246,758$ -$ -$ (22,529)$ 5,847,155 576 CFD'S Bond Proceeds 1,583,674 47,964$ -$ -$ (10,548)$ 1,621,090 601 SuccessrAgncy-TaxIncr-Residual 21,779 228,100$ -$ -$ (186,272)$ 63,607 602 SuccessrAgency RPTTF Debt Serv (32,803,607) 2,862,693$ -$ -$ (1,120,428)$ (31,061,343) 655 2020A LRB Debt Service Fund 1,946 6,236$ 730,600$ -$ (728,285)$ 10,496 656 MFA (LARB 2016A) 40,046,708 56,369$ 3,612,020$ (9,495)$ (3,612,020)$ 40,093,583 657 MFA (LARB 2016B) 7,210,784 9,872$ 628,588$ (662)$ (628,588)$ 7,219,994 658 MFA (LARB 2022) 30,563,488 42,118$ 2,655,855$ (20,911)$ (2,655,855)$ 30,584,695 659 MFA (STRRB 2012) 218,196 -$ -$ -$ -$ 218,196 701 Risk Management Fund (4,054,006) 8,080,375$ -$ -$ (10,754,271)$ (6,727,902) 715 Vehicle Replacement Fund 1,062,645 24,658$ -$ -$ (488)$ 1,086,815 726 Information Services/GIS Fund 4,670,318 3,855,708$ -$ -$ (4,295,562)$ 4,230,465 810 Mur Valley Town Hall Endowment 502,699 11,614$ -$ -$ (4,583)$ 509,730 811 Community Facilities Districts (3,643,906) 9,731,784$ 31,068$ (6,896,463)$ (1,749,271)$ (2,526,788) 812 Com. Facilities Dist Formation 26,777 -$ -$ -$ -$ 26,777 Sum of All Other Funds 149,334,320$ 65,014,326$ 10,864,537$ (9,689,094)$ (50,286,896)$ 165,237,193$ 11/28/2023
2 ESTIMATED ENDING FUND BALANCE BY FUND FOR FISCAL YEAR 2022/23 Fund No. Fund Description Beginning Balance Estimated Revenues Transfers In Transfers Out Estimated Expenditures Estimated Ending Balance* Sum of All Funds 252,839,351$ 189,030,345$ 15,527,641$ (17,027,641)$ (151,584,577)$ 288,785,120$ *The available fund balance may be less than the amount shown on this report due to other commitments and/or funds restricted for other purposes 11/28/2023
3