The URL can be used to link to this page

Home My WebLink AboutMinutes - February 8, 2000 SS265 CITY OF LODI INFORMAL INFORMATIONAL MEETING "SHIRTSLEEVE" SESSION CARNEGIE FORUM 305 WEST PINE STREET TUESDAY, FEBRUARY % 2000 An Informal Informational Meeting ("Shirtsleeve" Session) of the Lodi City Council was held Tuesday, February 8, 2000 commencing at 7:00 a.m. ROLL CALL Present: Council Members — Hitchcock, Nakanishi, Pennino and Mann (Mayor) Absent: Council Members — Land Also Present City Manager Flynn, Deputy City Manager Keeler, Economic Development Director Goehring, Public Works Director Prima, Community Development Director Bartlam, Finance Director McAthie, Parks and Recreation Director Williamson, Library Services Director Martinez, Electric Utility Director Vallow, City Attorney Hays and City Clerk Reimche Also in attendance was a representative from the Lodi News Sentinel and The Record. TOPICS) 1. General Fund Long -Term Plan ADJOURNMENT No action was taken by the City Council. The meeting was adjourned at approximately 8:20 a.m. ATTEST: Alice M.. Reimchimch City Clerk v b,A cd o ..r c U � w� w City of Lodi Public Safety Complex Financing February 8, 2000 - - e Public Financial Management 505 Montgomery Street, Suite 800 San Francisco, CA 94111 415 982-5544 City Of Lodi 415 982-4513 fax City of Lodi Since we last met on November 23, 1999 son • Met with City Staff • Adjusted FY00 and FY01 to reflect current budget • Refined revenue projections Included capital expenditures up to FY2010 • Conducted sensitivity analyses in regard to expenditures Assessed further the viability of the public safety building project on a pay-as-you-go basis • Evaluated impact of financing in terms of increased revenue requirements or expenditure controls City of Lodi Current Revenue FY99 General Fund Revenue Breakout by Source Transfers In Property Tax 15% i Ro/ Other Revenue 14% Intergovernmental Revenue (Vehicle License Fees) 9% Other 1 4% III-1.1Cu VId11 MMU Taxes 19% Sales & Use Tax 23% Revenue Assumptions 51, ori,,, • Refined further to produce conservative estimates. City of Lodi • Projected average annual growth equals 3.23%(1) vs. 3.60% from FY95-99. (1) Growth rate = 3.18% when expenditures arc projected at 3.00%, Growth rate = 3.23% when expenditures are projected at 3.50%, Growth rate = 3.29% when expenditures are projected at 4.00% t �3� 2 I Ilsiodcal Average from F1,95 -99.l �1 14 Property tax transfer to Capital bund escalates at the property tax projection rate. 4 One-time transfer in F'YOI. Pru err Tax 2.50% FY 96 = 3.59% FY 98 � 3.55%, FY 99 = 3.25% Sales and Use'1'ax 3.750.0 '11te I ldl. Companies Forecast = 3.11% I listorical Average FY 95-99 = 4.87° o San Ioac uin COG assumption = 5.60% In -Lieu Fr"nehise Tax Assutnes some growth in enterprise revenue Electric 1.001". Consistent with Rating process, SSB recommendation I listorical Average = 5.84% Sewer 1.00°0 1 listorical Average = 15.44% Water 1.000/0 1listorical Average FY 96-99= IAYiu Other'1'axes Public Safety Sales Tax 3.75% l listorical Average = 12.95% 'l'rawir I odging Tax 4.36% I listorical Average = 4.36% Waste Removal Franchise Tax 2.76-e 1 listorical Average = 2.76° o Industrial Franchise 5,46% 1 listorical Average = 5.4610 Gas Franchise 3.41% I listorical Average = 3.41% Cable TV Franchise 6.00010 1 listorical Average = 6.88% Ficctric Franchise 0.990.0 1 listorical Avcragc = 0.99% Real PropertyTransferTax 5.00% I listorical Avera �e = 11.80% Intergovernmental Revenues Motor Vehicle Licolse Fee 3.790, 0 1 listorical Average FY 95-99 = 3.79° o I listorical Average FY 91-99 = 2.96010 Assumes baekfall for any legislative change Oder 1.41 ° o Other Revenues I.icenses and Permits 6.0000 1 listorical Average = 20.12% Charges fur Services 8.000/0 I listorical Average = 14.96% Fines, Forfeits and Penalties 8.000,0 1 listorical Average = 16.620'0 Rental Income 6.00°0 1 listorical Average = 2.18° o Assumes growth due to the Perforniing Arts Center Investment Earnings $400,000 in FY 2000-2002,$350,000 in FY 2003-2010 Miscdlancous Revenue I listorical Average = (4.88%) Apprtmirnately $70,000 per year Other Sources and Uses Varies Operating Transfers In Equal to expenditure projection rate Operating Transfers Otio, 0.00% Other Sources 1.00% from 2003 onward I nlpact Ices 0 $2.000poo Assumes Capital Fund r:imburscd fi,r past expenditures (1) Growth rate = 3.18% when expenditures arc projected at 3.00%, Growth rate = 3.23% when expenditures are projected at 3.50%, Growth rate = 3.29% when expenditures are projected at 4.00% t �3� 2 I Ilsiodcal Average from F1,95 -99.l �1 14 Property tax transfer to Capital bund escalates at the property tax projection rate. 4 One-time transfer in F'YOI. 0" City of Lodi Additional Considerations The following items were not included in the revenue assumptions: • Hutchins Street Square payments could be higher (Capital Fund) • Possible legislation for funding of public safety buildings by a Representative (Capital Fund) • Superfunding of PERS (as much as 7.00%+) • State is considering a number of possibility to return ERAF or other revenue to Cities for the loss that occurred in the early 1990s • Conservative revenue estimates overall: Current estimate is 3.23%, Historical increase is 3.60% • Possible RDA funds to offset some Operating Cost • State infrastructure financing (70% of market) • Lease savings of finance offices $75,000/year • Lease of excess space in new building to other public safety agencies i�r•�t I5 Expenditure Sensitivity Tests • Vat Using the revenue assumptions, PFM conducted sensitivity tests :v o 0 City of Lodi assuming a range of growth (3% to 4%) in annual expenditures. p 25,000 O 20,000 V C 15,000 m = 10,000 LL 5,000 L 0 V O r N M d' lA W ti 00 O O O O O O O O O O O O T- 0 O O O O O O O O O O O N N N N N N N N N N N Fiscal Year ■ Sensitivity 1: 3.00% ■ Sensitivity 2: 3.50% ■ Sensitivity 3: 4.00% Current Viability of Pay-as-you-go >k=�`Based on the current identified capital revenue sources, the City would City of Lodi have a potential shortfall of $13.1 million (with no financing). $18,000 $16,000 $14,000. $12,000 $10,000 Capital Expenditures vs. Funding Sources FY 2000 FY 2000 FY 2001 FY 2001 FY 2002 FY 2002 FY 2003 FY MI Add. Req. Revs. Add. Rey. Revs: $12.9 MM ® Fund Balance 4 Add. Rey. Revs.=$0 Add. Req. Revs.=S0.2 MM i9l� 1y FY 2000 FY 2000 FY 2001 FY 2001 FY 2002 FY 2002 FY 2003 FY 2003 ■ Expenditures ■ Capital Fund Revenue ■ Impact Fees 0 Private Sector ® Fund Balance cc C LL 4) � V cn V � L a"' N o a s Im ca r_ .r. ii U O O 3 CD a iTL L > w J C) m w V C ca m C E O. O 0 O c 0 •� w C c � c� as v' cu :3 = N CD o r. � - r. LLCL L 0 Q a• �_ cc C LL 4) � V cn V � L a"' N o a s Im ca r_ .r. ii U O O 3 CD a iTL L > w J C) Next Steps City of Lodi • Approve revenue assumptions • Direct recommended expenditure rates • Proceed with the survey of the community in regard to any additional required revenues • Discuss financing structure options on February 22 Shirt -Sleeve rr\1 19 x CL CL a�l CITY OF LOW 50"norlo �� SpnsRlvlty� General fund Flnanclat Plan Assumptions; Expendllutes Projected at 3,50% General Fund CashlloW One Projectldns with Level Public safely Complex Financing Hlslwloid Pr eeled R-1 Vow EndkV. 1994 7995 1996 1997 1996 1999 7000 2001 2002 2003 2004 2005 2006 2007 2005 2009 2010 TOlal 1 Beginning a$##." 2,143,455 4.039,567 3.992,"1 3,371,957 2.510.286 2,261,476 2,710.676 J,630,361 5,079,269 6.206.151 7.005,091 6,538,613 6,730,361 6.695.274 6.747.446 6,899.217 7,169,378 840.11,431 SOURCES OF FUNDS Revenue6 Taaet 2 Property Tae 4.949.911 4,077.007 4,223,516 4,224,605 4,374,489 4,516,855 4,629,777 4,745,521 4,864,159 4.985.763 5.110,407 5.238,167 $.309,122 5,503.350 5.640,933 5,781,957 5.926,506 04,162,046 3 S*s 8 L7ae Tea 5.220,919 5.215,787 5,762,763 5,950,307 6,204,966 6,623,512 6.87 1,894 7,129,590 7,396,949 7,674,335 7,962,122 8.260.702 8,570,476 0.891,671 9,225,317 9.571,268 9.930.180 126.463.007 4 PuUic SMMy Sphe Tea (Prop 172) 97,943 148.541 153.6% 154,333 179,846 180,053 186,805 ! AIO 201,075 208,619 216,442 224,556 232.978 241,716 250,780 260,165 269.942 3,401,330 5 7mak lodging Ta 246,648 248,429 277.793 249,072 277,827 305,333 3111.650 332,547 347,050 362.186 377,982 394.465 411,610 429,624 448.361 467.915 488,322 5.983,677 6 W&M. Rm al Fran M. Tax 245,532 250.350 239,985 254,977 275.972 261,349 289.117 297,099 305.302 313,730 322,392 331,293 340.439 349,638 359.497 369.422 379,621 5.205.917 7 IAwdd P -Wee 24,743 22, t35 23,028 25,359 28.442 32,281 34.045 35905 37,866 39,935 42,116 44.417 46,8" 49.403 52.102 54,948 57,950 651,518 9 Ga.R-N.e 108.546 109,042 108,087 104,137 121,490 128,334 132,705 137,225 161,899 146.731 151,730 156.899 162.243 167.769 173,483 179.392 185.502 2415.216 9 G.Me TV R-hdie 118,010 113,666 120.542 128,271 148,706 164,602 174.478 184.947 196,044 207,807 220.275 233.492 247,501 262.351 278,092 294.778 312,464 3406,108 10 Electric F -W. 10,969 10,716 10,9& 11,230 11,697 11,542 11,656 11,771 11,887 12.004 12.173 12,242 12.3&1 12.485 12.606 12,739 12,058 201.866 11 In.Uev Farxline- ElaclnO- 3,218,690 4,160,000 4,174,800 4,O11S11100 4,292,061 4,215,047 4,317,797 4,760,975 4.404,585 4448.971 4493,117 4.$35.049 4,581.429 4,629.263 4.675.556 4,722.312 4,769,535 74.140,653 12 In -Lieu Frnchi5e• Se- 38.5,000 609,000 690.000 719.300 68(1.920 789,212 797,104 005,075 813,126 821,257 629,470 537,764 846.142 854,604 663,150 871,781 860.499 13.102,204 13 In.Ueu FNncti -Wale, 750,000 531.400 547,100 542,400 564,562 562,440 568,064 573,745 579,462 585,277 591,130 597,041 603,012 609,042 615,132 621,264 627497 10.068.609 14 ROM Plop_" TranstwTM 68,145 67,762 74,906_ 65,601 77,344 119,007 124,958 131,205 137,766 144,654 151,887 159,487 167,455 _ 175,828 184,619 193.850 203,54.1 _ 2,248.011 _ 15 Tam Taunt 15,445,074 15,563,838 16,408,023 16,515,390 17,246430 17.989,569 18,457,050 15,979,416 19.437,194 19.950,931 20,481,194 21,028,572 21,593,677-- 22.177,144 22.779,631 23,401.822 24,044,427 331 459,381 18 uca and permde 500,630 633,961 842.295 1,012,418 1,162,610 1,266,630 1,342,628 t423.185 1,508,577 1,598,091 1,695.037 1,796.739 1,904,543 2,010,818 2.139,945 2.268.341 2.404 442 25,545,788 I.WgmV menial Menres 17 6401ar V.W. License Fee 1,685,180 2,023,790 2,143,507 2,270.423 2,220,518 2,270423 2,35&446 2,445,729 2.538,395 2.634,571 2,734,392 2,917,994 2,965.522 3.057.124 3,172,955 3,293,174 3,417,946 44.247,490 18 gear 413.916 729.981 387.066 796,857 552,722 443,933 450,193 06,541 462.976 469,507 476127 692,841 489,649 496.553 503.555 510.656 517,856 9,639,970 19 TdaIh*e m mm&ualrerernee 2,293.096 2,752,171 2,530,573 3,067,200 2,773,240 2,714,356 2,806,639 2.902.270 3,001,373 3,104.070 3.210,519 3,320.835 3,415,171 3,553.677 3.676.510 3.803.829 3,9.1`,6& 52,887420 20 Charges[Or semicee 651.024 421,745 961,184 1,039,313 1,253,326 1,307,379 1,385,622 1,468,971 1,557,109 1,650.536 1,749,566 1,854.12 1,985,515 2,063,7& 2,20$789 2,341,317 2,481,796 26.381,999 21 Fines, Idleil6 and penaN95 407,168 405,818 420.987 452.717 661,761 678.245 945,505 1,024.385 I, t06,336 1,194,843 1,290430 1,393,664 1.505.158 1,625,570 1,755,616 11896.065 2,047,750 19,015,015 22 n.MM In- 127,725 41.775 101.822 39,647 96.383 142.297 150,635 159.585 169478 179.647 190,426 201,851 213,962 226,800 240.408 254.833 270,122 2,797,896 23 Est -ted lnvesvnenl Eamin04 313,146 351.343 332,145 164.505 245.330 502.235 400,000 400.000 350.000 350.000 350.000 350,000 350.000 350,000 350.000 350.000 350.000 5.555.704 24 Mece9anewa rmenre 91,568 130,710 120,347 78.102 112,924 71,301 71,301 71,301 71,301 71,301 71,301 71.301 71,301 71,301 71,301 71,301 71,301 1,309,263 25 Oear Sources 0 0 O 0 0 0 676.000 951.000 597.910 704,889 741,938 719.057 726,240 733,510 740.046 740,254 755,737 6,375,389 26 Trwd sIn 4,581,329 31779,891 3.750,391 4,519,310 4,691,490 4,245,037 4,024,920 4.0',0,960 4,192,744 4,339,490 4491,372 4.648.570 4,811,270 4.979.664 5.153.952 5.334,341 5.621,043 77,067,772 27 s bldalneaeawa 24,402,660 24,001,252 25467,763 26.568.682 28.225,516 29.117,049 30463.699 31 401,373 32.092.021 33.144,005 34.241,783 35,385,132 36,577,145 37,526247 39.116,997 40470.103 41,682,422 550,778,648 USES OF FUNDS FxmndBures Bud I Bdg,t Pre ecled Gummi 28 G6neM gwenvnery 4,898,641 4,822,689 5.216A5 5,881,889 7,065,021 7,230,903 7,895.500 6028,835 5.309,844 8,606,989 8.901,713 9.213,273 9,535.737 9,869.488 10.214920 10.572,442 10,942,478 137,215.041 29 Pu06c pre1oce0n 9.939,558 10,274,500 10,142,448 t0,962.385 10.74 1.11M 11,096702 11,649.235 11,812,315 12,225,746 12.653.647 13.096.525 13,554,903 14029,325 14,520.351 15.028,591 15,554,583 16,098,973 213.381,637 30 Pular -M 3964,240 3,628448 4.327,322 4,976,682 4,482,128 4.544,180 4,067.435 4,248.0.'04.396.732 4,5.50,617 4,709,889 4,874,735 &045.351 5,221,9.16 54&,706 5,593.871 5,780.656 79,770,.580 31 Llilx y 561,274 956.120 9538117 1,012,109 965.606 4029,569 1,073,785 1,056285 1,124,305 1,161,658 1.267.184 1,246917 1,290.1GO 1,335,322 1.382.058 1434430 1,480,495 19,816.086 32 Pans end r ealion 2,307.357 2,299,181 2,197,614 2.312,379 2,173,645 2,230,233 2.596.835 2,683.645 2.777,780 2.875.002 2,975,627 3,079,774 3.187,566 3.298.131 3414,600 3,534,111 3.657,805 47,602,455 33 O# -u- 0 0 O 0 0 0 200,000 0 0 0 0 0 0 0 0 0 0 200,000 Tnnstgr9 ON 34 4'uNb SaletyCw". Financing 0 0 0 0 0 0 0 (46,164) (95,816) 558.852 1,575,735 11577,491 1,577,886 1,576,924 1,574,636 1,575.857 1,575,429 11449.825 35 Ohm 1,545.085 2.147,440 3.261403 2,605.130 3,042,429 2,536.275 2.058.418 2,139,306 2,225,551 1,945,401 1,948,18_9 1,944,871 1.946.201 1,944,921 1,945,749 1.938.664 1.947424 37,141456 36 TWO Trw6fen OA 1,546085 2.147,440 3283,403 2,605,130 3042,429 2.536275 2,058418 2.093,441 2,126,733 2,504,254 3,521,924 3,572,362 3,524,087 3,521,845 3,520.363 3.514.520 3,518.853 48,591,281 37 SUNMVE 23,401455 24,128,378 26,f21,572 27,750,354 28474,327 28,677,962 29.544,208 29,952,47t 30.963139 32,347,864 34410,061 35.491,564 36.612.232 37,768,075 30.985,231 40,199,938 41.488,260 546.377,111 38 NET INGQUE Rev. 195-E 921,205 47,126 551,809 861,671 45.810 439,087 9i9491 1448,902 1,129,882 796,940 168.278 106452 35.087 52,172 151,767 270.165 394,162 4401,537 39 Addill-Ily Required Revenue. 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 FUND BALANCE 40 BeO:any gal- 2,143,465 4,039,567 3.992."1 3.371,957 2,510,266 2.261476 2,710,876 3630,367 5.079,269 6.206,151 7,005,091 6,836.813 6.73D,361 8,695.274 6.747,446 6.899.213 7.169.375 84.031431 41 Reich! ea14y 0aMler M 33A25 10,313 43.638 41 Net Income 921,205 (47,126) (653,509) (881,671) (240.810) 439,087 919491 1448,902 1,128,862 796.940 (166.278) (106452) (35.087) 52,172 151,767 270,165 394,162 4,401,537 42 R-Wenrenhe 974,897 0 0 0 0 0 974,999 43 Ending Beane 4,039,567 3,992.441 3,371,957 2,510,286 2,261476 2.710.616 3,630,367 5.079.269 6209,151 7,009031 6.836.813 6,730.351 6,895,274 6,747446 6,899.213 7,169.378 7,563539 89,451,506 " %Er.dnp BMarlce dAmuM Eglerx-!urea 1720% 18.55% 12.91% 9.05% 7.94% 945% 1229% 16.96% 20.05% 21.66% 18.87/. 1896% 16.29':. 17.87% 1777% 77.85°4 1823: raPra,ev a, ams..vn as 421 Raslalerranl ti 199410 4W, GASB 22 C,enwd Fund (5cenob8-S.I XM".at5 CITY OFLOOI Scenario I sensitivity� Genera! Fund Financia/ Plan Assumdifons Expenditures Projected at 3.50% Other Sources (Uses) Base Projections with Level Public Safety Complex Financing - NISIgICaI Budget Illudilet Pr ectod Ffse4fyaarit- 1994 1995 1996 7997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Total TRANSFERS IN Op -ling Transfers In 1 Cost d S -61.s Traraacli- 2,455.666 2.666.303 2.666.303 3.1720,920 3,046,960 13.856,154 2 51,W FurMyes lar b Mlsat shoot rlWM 640,000 933.800 937,600 960.576 982,563 982.563 1.004,000 1,001,000 7,441,302 3 Olhar 3,921,329 2,846.091 2,816,591 1,103.066 1,D14,624 596,171 0 0 4,192.744 4,339,490 4,491,372 4,648,570 4,811,270 4,979,664 5.153,952 5.334,341 5.521,043 55,770,316 4 Total Oparaling Transfers In 4,561,329 3,779,891 3.750.391 4,519,310 4.663.490 4,245,037 4,024,920 4,050,960 4,192.744 4,379.490 4491,372 4,648,570 4,811,270 4,979,664 5,153.952 5.334,341 5.521,043 77,067,772 5 7.1.17 .... f.. In 4,561,329 IT79.891 3,750,391 4,519.310 4,863,490 4,245.037 4,024,920 4,060,960 4,192.744 4,339,490 4.491,372 4,648,570 4.811,270 4,979,664 5,153.952 5.334.341 5,521,043 77.067,772 TRANSFERS OUT Operating Transfers Oul 6 Opwaling Tfanalws Out 0 7 BaneSts Fund 269,485 269.485 536.970 8 Imurance Fury 400,000 4110.000 flon.r%%1 9 Other 1,546,085 1.536.326 2.016,347 1,337.846 1.730.100 1,182,005 0 0 669.485 669.485 669.465 669,485 669,485 669.465 669,485 669,485 669.485 15,374,074 10 Total Operating Transits Out 1,546,085 1,536.326 2,016,347 1,337,846 1.730.100 1,182,005 669.465 66.9.485 669,485 669.485 669.485 669,485 669.485 669.485 669.485 669,485 669.485 16.713,044 Transfers Out to Capital Proleeb Fund 11 Pfc""7as 0 611,114 1,267,056 1,267,284 1.112,329 1,356,270 1,388,93) 1,1ZI 56 1,459.248 1.495,729 1,533.122 7.571,450 1,610.736 7.651,00$ 1.692.280 1,734,587 1,1952 23.152.751 12 uwOslmenl trlmrrla 0 13 Sufficiency Tr 81w for Data Sorvke 0 0 0 339,040 1,319.317 1,281,427 1,243.865 1,201,355 1.158.618 1.110.448 1,071,416 8.725.a66 14 Or43onaml FurM Cap4al IAs 0 g 15 Total TranslOn Out to Capaal Project s Fund 0 611,114 1,267,056 1,267,284 1,312,329 1,356,270 1.3118,933 1,423.656 1,459.248 1,031,769 2,852,439 2.852,871 2,854,602 2,652,360 2.850,896 2.845.035 2.849.369 37.878.237 P.- fors Out to Ubary Fur d t6 P of ony Tea 0 17 Total Translws Out to Lrorary Food O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16 Total Translers Out 1,546,085 2,147440 3,263,401 2,605.130 3.042.429 2,5.38.275 2.058,416 2,093,141 2,128.733 2.504.X+4 3,521,924 3,522,362 3,524,087 3,521,845 3,520.393 3,514,520 3.518,853 48.591,281 19 TOTAL TRANSFERS OUT 3.015.244 1,632,451 466,986 1,914,180 1.621.061 1,706,762 1,966,502 1,957,819 2,064,011 1,835.236 %9,447 1,126,208 1,287,183 1,457,519 1,633,570 1,819.820 2.002.190 28,476.491 OTHERSOURCES USES 20 Other Somua O 0 0 0 0 0 a76,0D0 961.000 697.910 704,889 711,938 719.057 726.246 133,510 740.846 748.254 755.737 6.375.389 21 Other Use 22 MA-MannUe nent S -y 200.000 200.000 23 Total 011ier Uses 0 0 0 0 0 0 200,000 0 0 0 0 0 0 O 0 0 O 200,000 24 TOTAL -OTHER SOURCES USES 0 0 0 0 0 0 676,000 961,000 697,910 704,889 711.938 719,057 726.248 733,510 740.646 749.254 755,737 8.175.389 PREPARED aYPUDLIC MANCIAL MANAGEMENT INC. 2131101139 AM Gw*a01 Fund (Scer1Oe08-S9n91441y2).ti{ r CITY OF LODI Scenario Sensitivity General Fund Financial Plan Assumptions Expenditures Projected at 3.50% Debt Summary Bass Projections with Level Publir2 Safety COMPkx Financing Hlstplal Sudgel I BUdgel Plojeeftd F7tta0 YeME 1994 4995 1pus 1997 ills 1999 2000 2001 2003 2003 2004 2005 2006 2007 2WS 2009 2010 Total BOND SOURCES AND USES Bond Sources Was 1995 Series 1996 Series 2001 1 Par A-1 WA NM 5,000,000 10,120,000 WA WA WA 22.425.000 WA WA WA N/A N/A WA IVA WA WA 37,545,000 2 S.Wfal Bold Spicas WA WA 5.000.000 10.120.000 WA WA WA 22,425,000 NIA WA WA WA NIA N/A NIA NIA WA 37,545,000 Bond uses Series 1995 Series 1996 Series 2001 3 P90)e01 Fund WA WA 4719.177 9,917,600 WA WA WA 17,703,000 WA WA WA NIA WA WA WA WA NIA 32,339,777 S-4 D.W SReserve Fuld WA WA WA WA WA WA WA 1,675.072 WA WA WA WA WA WA WA WA WA 1.675.072 5 CAputred lMefest Fled WA WA WA WA WA WA WA 2,435,794 WA WA WA WA WA WA WA WA WA 2,435,794 8 C-1 d Issuance WA WA 188,000 202,400 WA WA WA 200.000 WA WA WA WA N/A WA WA NIA NIA 590.400 7 UNWAMMIses D40"I WA WA WA WA WA WA WA 168,188 WA NIA WA WA WA WA WA WA WA 168.188 B Bmdlmuran0a WA WA WA WA WA WA WA 242,236 NIA WA WA WA N/A WA WA WA WA 242,2.16 9 Addill WM Pra6ods WA WA IOO,000 WA NIA WA WA 711 N/A NIA WA WA WA WA WA WA WA 100,711 10 SLNOrN IkNd11se8 WA WA 5,007,177 10,120.000 WA WA WA 22.425.000 NIA NIA N/A NIA WA NIA NIA NIA NIA 37.552,177 BOND DEBT SERVICE O.ou Debt S.-k. 11 See_ 1995 WA WA 131,OBA 426.23{ 429.871 427,881 425.341 427.201 428.4tl 424.074 424,171 423.564 427,014 424,526 42.5,906 421.214 425.396 6,091,916 12 Sed- lam WA WA WA 346,031 850,475 847,945 848.935 848,515 e40,796 043.818 844.508 643,798 841,648 842,685 642,333 639.940 840.518 11.328.142 13 Sedes 2001 WA WA WA WA WA WA WA 655.671 1.311,342 1,311,3421A72..5.54 1,674,309 1.674.704 1,673,712 1,671453 1,672.675 1,672,248 14,990,038 11 Svh".1 Dew Service WA WA 131,084 772.262 1.280,346 1,275.826 1,274,276 1,931,387 2.566.549 2.579.233 2.941,233 2,941,670 2,943,395 2.941,153 2,939,691 2,933,829 2.938.161 32,410,096 Debt S,,,4,r-a RFond ('DSRF') and brninpa 15 Sndes 1995 WA NIA WA WA WA NIA WA WA WA NIA N/A NIA WA WA WA NIA NIA WA 16 Snd- 1996 WA WA WA WA WA WA WA WA NIA NIA NIA N/A WA WA NIA N/A NIA N/A 17 SWdea 2001 WA WA WA WA WA WA WA 50.654 101,308 101,308 101,326 101,309 101.306 101,308 101,308 101.308 101,308 962,430 185u 41)S7(F.WE-W. WA WA WA WA WA WA WA 50.661 101,308 101.308 101,308 101,'tm 101,308 t01.306 101,308 101,309 101,308 962,430 Capitall.edlnlenal 19 Si- 1995 WA WA WA WA WA WA N/A WA NIA WA N. NIA N. WA WA WA N/A NIA 20 Sed- 1996 WA WA WA WA NIA WA WA WA NIA WA WA WA NIA NIA WA NIA WA N/A 21 Sod-2001 WA WA WA WA WA WA WA 655,671 1,311,342 655,671 WA WA WA WA WA WA WA 2,622,983 22 Su6rd.11 Ce*mW,ed/nFMV WA WA WA WA WA WA WA 655.671 1,311,342 655,671 WA WA WA WA WA WA WA 2.622.663 Net Debt 5.-4- 23 Sed.. 1995 WA WA 131,084 426,231 429,871 427,881 425.341 427.201 428.411 424,074 424,111 123.564 427,044 424,526 425.906 421.214 425.396 6.091,916 24 Sed-1996 WA WA WA 346.031 850,475 847,945 648,935 646,515 846.796 843,818 844,508 843,798 841,648 842.885 842.3al 839,940 840,518 11,328.142 25 Sada. 2001 WA WA WA WA NIA WA WA (50,654) (101,308) 554,362 1.571.246 1,573.001 1.573,396 1,572434 1,570.144 1,571,367 1,570,939 11,404,925 26 SuhWM A&W D.N Sa1H.-e WA WA 137,084 772,262 1,280,346 1,275,826 1,274,276 1225.062 1,173.899 1,822,251 2,939,924 2,840,362 2.842,087 2,839,845 2,838,383 2.832.520 2,836.853 28,824,903 Fiscal Charges 21 Sad- 1995 WA WA 3,535 3.535 3,535 3,585 3,535 3.535 3.535 3.535 3.53.5 3,535 3.535 3.535 3,535 3.535 3.535 53,025 28 Sad- 1906 WA WA WA 4.490 4.490 2,948 4,490 4,490 4,490 4.490 4,490 4490 4,490 4.490 4,490 4,490 4,490 51,318 79 5ene52001 WA WA WA WA WA WA WA 4.490 1,490 4490 4,690 4,490 4,490 4,490 1490 4.490 4,490 44,900 30 SLgmm Few a.g- WA WA 3,635 6,025 8,025 6,461 8,025 12,515 12,515 12,515 12,515 12.515 12.515 12,515 12.515 12,515 12,515 159.243 3101her Debt WON 405,160 345,498 365,584 158,580 1,274,622 32 TOM Debt SSMn 405,160 345.498 500.203 938.867 1,288,371 1,282,309 1,282,301 1,237,577 1,186,414 1,634,769 2.852,439 2,852,677 2,854,602 2.852.360 2,850,899 2.845.035 2.849.368 30,259.048 DEBT RATIOS 33 Ge-1 Fund Revenue 25,467,763 26,8118.662 28.22S.516 29.117,049 30.463.699 3T,401,373 32.092.021 33.144.605 34.241,763 35,385.132 36.577,145 37,828247 39,116,997 40,470,103 41.882.422 34 DMA %,,*e Coverage (Lire 33A.1-14) 19429. 3482. 2205. 2262. 23.91. 16.26. 1241. 1285. 11.64. 1203. 12.43. 12.86. 13.31. 13.79. 14 25. 35 Dirml Gmpal Furl 0ab9ieasas^OuISNn3rq 0 0 5.000.000 15,120,000 14,970,000 14,500,000 14,015,000 35,835,000 35,105,000 34,850,000 34,275,000 33,300.000 32.275.000 31,195,000 30,060.000 28.865.000 27,610,000 36 Assessed Ful Cash Vakie ('AV')ej 2,471,754,000 2,471,754,000 2,555.328.000 2.593.000.000 2.593,000,000 2,593,000.000 2,593,000,000 2,593,000,000 2,644.860.000 2.697,757.200 2,751,712,344 2,806,746.591 2.862.881,523 2.920.139,153 2,978,541,936 3.038.112.775 3.096.875,030 37 Ratio or DIreG DebWgases lO AV 0.1956% 0.5831% 0.5773% 0 SSS^ 0.5405% 1.3858% 1.3386% 1.2918% 1.2456% 1.1864% 1.12745: 1.06M 1,0092% 09501% 0 8910% 38 POpulMlone 53.000 53,575 54.473 54.800 55200 55,700 55,700 55.703 55,700 56,257 56,620 57.388 57,962 58,541 59.127 59.718 60.315 39 01u Per Capita (E) 91.79 275.91 268.76 260.32 25L62 64515 63564 619.48 603.23 56026 556.93 532.87 508.40 48336 15776 l 1: Dms nal IrOut% equip-4 leas- 121 AV is Macted b gr at 2% amualN ban 2002 MMM 2 1261098 a IOd W tow al tx AnrNa Irrxn 20P1OnwaN PREPARED BY PfA9LIC FINANCNL MANAGEMENT. MF 2/100 11:39 AN General Fund (ScenabBSensIN8y1).ids r CITY OF LOW Scenario a �ensl(Ivlty 2O General Fund Financial Plan Assumptions Expenditures Projected at 3.50% Capital improvement Fund Base Projections with Level Public Safety Complex Financing Interest Rate (Non -Debt Proceeds): 5.5U1 Historical Budget I Budget Pro glee Ffscal Year Endln : 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2008 2007 2008 2009 2010 Total 1 Beginning Balance 5,099,679 3,765,222 3,933506 6,570.152 12.075.629 2,473,200 2,812,550 283,420 4,965,855 5,115,938 5,199,615 5,493,681 5,752,964 5,975,497 6,159,201 6,301,880 6,401,216 88,379.284 SOURCES Capital Fund Revenue 2 Capital Fund Revenue 5,023,857 4,581,300 11,769,656 25,677,757 19,453,648 6,903,629 2,100.933 21,846.658 3.660.373 11,059.769 4.278.339 4.254,424 4.232.,438 4.207,142 4,183.299 4.155.747 4,109.097162,366.065 3 Total Capital Fund Revenue 5,823,857 4,561,300 11,769,656 25,677,757 19453.646 6,903.629 2,108,933 21.M.6511 3,660,373 11,059,769 4,278,339 4,254,424 4,232,438 4,207,142 4,163,299 4,155,747 4,189,097 142,366,065 4 Total sources 5,623,857 4,561,300 11,769,656 25.677.757 19453,648 6.903,629 2,108,933 21,846,656 3,660,373 11,059,769 4,278,339 4.254424 4,232,438 4,207,142 4,183,299 4,155,747 4,189,097 142,366,065 USES Capital Requirements 5 General Govennmenl 8,007 6.007 6 Punk, Works 71,670 71,670 7 General Fund Requirements 806,592 1,827,953 4,389,642 9,987,944 15,339532 2,732,050 3,140,900 15,771.000 2,201.125 9,025.000 975,900 1,001,548 1,027,836 1054,782 1,082402 1110,712 1139.729 72612,655 e RDA Requirements 8 Total Capital Requirements 884.269 1,827.953 4,369,642 9,997,944 15,339,532 2,732,058 3,140,900 15,771,000 2,201125 9,025,000 975,900 1,001,548 1,027,836 1,054,782 1,082402 1110,712 1139.729 72.692,332 Transfers Out Operalin0 transfer& ad 10 COSI d Services Transaclions 0 11 General Fund a 12 Equipment 6 Replacement 455,443 4DO,000 300,000 300.000 400,000 400.000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 5.055,443 13 Other 5,866,88.5 2,220,702 4,243,2459_245.469 11,972.730 1,952.445 _ _ _ 35.503,476 _ 14 Total OrwaNg; tmnskr3 oul 5,868,885 2220,702 4,243245 9,245,469 12,428,173 2,352,445 300,000 300.000 400.000 400.000 400.000 400,000 400,000 400,000 400,000 400,000 400.000 40.558,919 impact Fees to General Fund 15 Fire 0 16 Pdice 50.000 50,000 50.(1(X) 50,000 50.000 50.000 50.000 350.000 17 Parks 6 Recreation 0 IB Garwral City Facifnies _ 19 Stt",W fmpact Fees to General Fund O 0 0 0 0 0 50,000 50,000 So,000 50,000 50,000 50,000 50,000 350,000 15 Tmnsler to Pay Debt Servke 405,160 345,498 500,203 938,887 1,288,371 1,282,309 1,282,301 1,237,577 1,106,414 1,834,769 2,652,439 2.852,877 2,854,602 2,052,360 2,650,898 2,645,035 2,049,368 30.259,048 20 Total Translers Out 6274,045 2,566,200 4,743,448 10,184,336 13,716,544 3,634,754 1,5112.301 1537,577 1586.414 2,234.769 3,302,439 3,302,877 3,1M,602 3.302.360 3.300.898 3.295.035 3.299.368 71,167.967 21 Total Uses 7.156,314 4,394,153 9,133,090 20,172.280 29,056,076 6,366,812 4,723.201 17,308577 3,787,539 11,259,769 4.278.339 4.304.424 4.332438 4,357,142 4,383,299 4405,747 4439,097 143.660.298 22 Additionally Required Revenues 0 0 0 O 0 0 0 0 a 0 0 0 0 0 0 0 0 0 FUND BALANCE 23 Beginning Balance 5,099,679 3,755,222 3,933.586 6,570,152 12,075,629 2,473,200 2,812,550 283,420 4,965,855 5,115,936 5,/99,615 5.493,681 5,752,964 5.975,497 6.159,201 6,301,860 6,401,216 88,379,284 24 EsBmalad han,slmenl Earnings 85.139 144,355 277,249 283.678 294,066 309,283 322.533 333,704 342.680 349,335 354,953 3.096,974 25 Residual equity transfer iN(outl (197,468) (197,468) 26 E"-W4Deticlency) of Sources mer (under) Uses (1.334,457) 167,147 2,636,566 5.505.477 (9,602,428) 536,817 (2,514,268) 4538,079 (127.166) (200.000) 0 (50.000) (100,000) (150.000) (200,000) (250,000) (250.0001 (1494,234) 27 Restatements 1,217 1,217 28 Endng Balance 3,765222 3,933,586 5570.152 12,075,829 2,473,200 2,812550 287,420 4,965,855 5,115,938 5,199,615 5,493,681 5,752,964 5,975,497 6,159,201 6,301,880 6,401,216 6,506,169 89,785,774 29 % Ending Balance d Annual Expenditures 52.60% 89.52% 71.94% 59.86% 9.51% 44.18% 6.OD% 28.69% 135.07% 48.18% 128.41% 133.65% 137.92% 141.36% 143.77% 145.29% 146.57% PREPARED RY PUBLIC FINANCIAL MANAGEMEM, INC. - 2l.V00 11:39 AM General Fund (Scenork B-SensltMty2).xls r CITYOFLOOI scenario C-B-7senslawfy� General Fund Financial Plan . Assumptions Expenditures Projected at 3.50% Capital Fund Revenue Base Projections with Level Public Safety Complex Financing Historical Budget I Budget Projected Fisear Year Ending, 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Total CAPrrAL FUND REVENUE Intergovernmental Revenues I Electric Mary 130,000 130,000 0 0 0 260,000 2 Water Mary 45,000 45,000 0 0 0 90,000 3 Sewer Utility 45,000 45.000 0 0 0 90,000 4 Total lnfargtivemmatnalRavaaras 0 0 0 0 289,601 87,973 220,000 220,000 0 0 0 0 0 0 O 0 0 817,574 Charges Iw Services 5 Private Sector 0 0 300,000 0.775,000 0 9,075,000 Irrpacl Faea 6 Fke 41,513 42,550 43,614 44,704 45,822 9640,500 46,0 3D5.671 7 Police 86,400 88,560 90,774 93,043 95,369 97,754 100,198 652,096 8 Parks B Recreatied" 1.000,000 1,401,125 548,000 561,700 575,743 590,136 604,889 620,012 635,512 6.537,117 e Genaral OiryFaciklies 1,000,000 351,000 359,775 360,769 377,989 307,438 397,124 1117 '."2 3,649.140 0 2,000.000 1,401,125 0 1,025,900 1,051,548 1,077,836 1,104,782 1,132,402 1,160,712 1,169,729 10 Soblatal ltrpact Fees 0 0 0 0 0 0 11,144,034 I1 Total Charges ler SeMcas 1,060,813 1,243252 767.739 400,132 850,722 1,17J,940 0 2,000,000 1,701,125 8,775,000 1,025,900 1,051,548 1,077,036 1,104,782 1,132.402 1,160,712 1,189,729 25,723,632 Rental Income 12 Olherpaymenl from Foundation 150,000 150,000 150,000 150,000 150,00D 150.000 150.000 150,000 150.000 150,000 150,000 11650,000 13 Total Rental Income 557,429 172,1160 342,251 753.431 583,082 205.734 150,000 150,000 150,000 150,000 150.000 150,000 150,000 150,000 150.000 150,000 150,000 4,264,781 Mlscellaneous Revenue 14 RDA 0 15 Other Mtscenart>ous Revemm 104,153 14,156 1,000 241,105 171.263 531,697 Revenue Is Tonal Miscellaneousvenue 1 0 14,156 1,000 241,105 171,283 0 0 0 O 0 0 0 0 0 0 0 531,697 Transfers In GRneral Fund Transfers In 17 Property Tax 611.114 1,267.056 1,267,284 1,312,329 1,356,270 1,388,933 1.423,656 1,459.248 1,495,729 1,533.122 1.571,450 1,610,736 1,651,005 1,692,280 1,734,587 1,777,952 23.152.751 18 Investment 1-- 0 19 Sufficiency Transfer for Debt Service 339,040 1,319,317 1281,427 f,243,865 1,201,355 1,158,618 1,110,448 1,071,416 0,725.486 20 Other _._ 0 31,878,237 21 Srr6b1a1 General Fwd Translers In 611,114 1,267,056 1267,284 1,312,329 1,356.270 1,388,933 1,423,656 1,459,248 1,834,769 2,862,439 2,852,877 2,854,602 2,852,360 2,850,898 2,845,035 2.849.368 22 Public Benefits Fund 0 23 Elecdc Fund 350,000 350.000 350,000 300.000 250.000 200.000 150.000 100,000 50.000 2,100,000 24 Other 4,101!62 2,534,074 4,659,277 10,917,728 16,168,809 3,908,429 42,289,779 25 Total 7ransfets In 4,101,461 3.145.188 5,926,333 12,185,012 17,481,138 5,264,699 1,738,933 1,773.656 1,009,248 2,134,769 3,102,439 3,052,877 3,004,602 2,952.360 2.900,898 2,845.035 2.849.368 76.268,016 Financing Sources Series 1995 Sedes 1996 Series 2001 26 Bad Proceeds NA NA 4,719.177 9,917.600 NA NA NA 17,703.000 NA NA NA NA NA NA NA NA NA 32,3.99,777 27 Interest on Bond Proceeds NIA 28 Proceeds of Special Assessment 2,420,582 ,420.582 29 Total Finanelo0 Sowees 0 0 4.719,177 12.338,182 a 0 0 17,70,000 0 0 0 0 0 0 0 0 0 34 760,359 30 Total Capital Fund Revernle 5,823,857 4,561,300 11,769,656 25,677,757 19,453,648 6,903,629 2,108.933 21.346.656 3.660.373 11,059,769 4.278.339 4,254.424 4.232,438 4.207,142 4,183.299 4,155,747 4,189,097 142.366.065 1 I Includes ale-erna transfer In 2001 from me evekMwt lee fund balance PREPARED BY PUBLIC FMA NCIAL MANAGEMENT, ING 2/20011:39 AM General Fund (ScenoriollSert9tivil".xis r General Fund (ScenarloB-SensitMty2).xds r CITY OFLODI Scenario Sensitivity General Fund Financial Plan Assumptions Expenditure: Capital Projects Base Projections with Level Public Safety Complex Financing Fiscal Year Ending: 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 TotalFY2000-2010 GENERAL FUND CAPITAL REQUIREMENTS 1 Information Systems telephone system 90,000 90,000 180,000 2 Beckman Annex building 3 Downtown Parking Structure Public Safety Building Improvements 4 Misc Fire equiplprojects 16,800 33,000 49,800 5 Root Replacement Fire Station N3 24,100 24,100 6 Misc Police equip/projects 7 Building Renovation 2,455,000 15,218,000 17,673,000 Park & Recrealion Facilities 8 Indoor Sports Facility 300,000 8,775,000 9,075,000 9 P R R Administration 500,000 500,000 10 Park Corporation Yard 901,125 901,125 11 Lodi Lake Beach improv/parking lot 200,000 200,000 12 P & R Capital Misc 150,000 150,000 150,000 150,000 600,000 13 School Playgrounds 50,000 50,000 50,000 150,000 14 Information Systems 200,000 200,000 100,000 100,000 600,000 15 Redevelopment Agency 100,000 100,000 16 Records Mgmt software 55,000 30,000 85,000 17 Permit software 18 Subtotal 3,140,900 15,771,000 2,201,125 9,025,000 30,138,025 Additional Capital Protects 19 General Fund 20 Impact Fees 975,900 1,001,548 1,027,836 1,054,782 1,082,402 1,110,712 1,139,729 7,392,909 21 Subtotal Additional CapitalProjects 975,900 1,001,548 1,027,836 1,054,782 1,082,402 1,110,712 1,139,729 7,392,909 22 Total General Fund Capital Requirements 3,140,900 15,771,000 2,201,125 9,025,000 975,900 1,001,548 1,027,836 1,054,782 1,082,402 1,110,712 1,139,729 37,530,934 RDA CAPITAL REQUIREMENTS 23 Total RDA Capital Requirements 23 Cumulative Total, this period 3,140,900 15,771,000 2,201,125 9,025,000 975,900 1,001,548 1,027,836 1,054,782 1,082,402 1,110,712 1,139,729 30,138,025 24 Cumulative Total, to date from 2000 3,140,900 18,911,900 21,113,025 30,138,025 31,113,925 32,115,473 33,143,309 34,198,091 35,280,492 36,391,204 37,530,934 PREPARED BY PUBLIC FINANCIAL MANAGEMENT INC. 213/00 11:39 AM General Fund (ScenarloB-SensitMty2).xds r CITY OF LODI ScenarI. t_sens;wyYy�2 General Fund Financial Plan Assumptions Expenditures Projected at 3.50% Equipment & Replacement Fund Base Projections with Level Public Safety Complex Financing Historical Budget Budget Projected Flscel Year Fndln 1991 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 7006 2007 2008 2009 2010 Total 1 De Mnln Balance 295,026 351,911 190.213 364,781 533,815 522,068 522,068 422,658 316,923 334,847 353,784 373,792 394,932 417,268 440,866 465,800 492,143 6,612,696 SOURCES Revenue 2 Charges for Services 0 0 0 0 5,717 0 0 0 0 0 0 0 0 0 0 0 0 5.717 3 Imeslmenl and Rental Income 0 0 0 0 0 0 0 4 Misewlaneous revenue 0 0 0 0 63,855 O 63.855 5 Total Revenue 0 0 D 0 69,572 0 0 0 0 0 0 0 0 0 0 0 0 69,572 Transrers In 6 Operating Transfers in 189,160 244,185 731,839 646,787 0 0 1,811,971 7 Capital Fund Transfers M 455.443 400,1100 300,000 300,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 5,055,443 8 Total Transfers In 189,160 244,185 731,839 646,787 455,443 400,000 300,000 300,000 400,000 400,OOD 400.000 400,000 400,000 400,OD0 400,000 400,000 400,000 6,867,414 Financing Sources 9 Lease Proceeds 0 0 0 D 0 0 0 10 Total Financing Sources 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 Total Sources 189,160 244,185 731,839 646,787 525,015 400,000 300,000 300,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 6,936,986 USES Capital Requirements 12 General Government 1,858 0 0 0 0 0 1,856 13 Capital Requirements 190,419 397.641 537,271 464,083 536,762 400,000 399,410 405,735 400,000 460,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 6,871,321 14 Total Capital Requirements 132,275 307,641 537,271 464,083 536,762 400,000 399,410 405,735 400,000 400,000 400,000 400,000 400,000 400,f100 400,0W 400,000 400,000 6,673,177 Translers Out 15 Op-lig Insulters out 0 8,242 0 33,670 0 0 41,912 16 Transfer for Lease Payments 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17 Total Tranahra Out 0 8,242 0 33,670 0 0 41,912 IS Total Uses 132975 405,083 537,271 497,753 536,762 400,000 399,410 405,735 400,000 400,000 400,000 400,001 400.00 400.000 400,000 400,000 400,(X10 6,915,089 19 Additionally Required Revenues 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 FUND BALANCE 20 Begiuling Balance 295=5 351,911 190,213 384,781 533.815 522.068 522,068 422,666 316.923 334,647 353,784 373,792 394,932 417,268 440,866 465.800 A92,143 6,812.89i- 21 Eslimaled Investment Earnings 17,924 18,937 20,008 21,140 22,338 23.599 24,933 26.343 27,833 203.054 22 Residual equity transferiv(W) 0 23 Excess7(Derklency) of Sources over(under) Uses 56,885 (161,6981 194,568 149,034 (11,747) 0 (99,410) (105,735) 0 0 0 0 0 0 0 0 0 21,897 24 Restatements 0 26 Ending Balance 351,911 190.213 304,781 533,815 522,068 522,068 1 422.650 316,923 33A,B47 353,784 373,792 394,932 417,268 440.866 465,800 492,143 519,9771 7,037,646 27 % Ending Balance of Annual Expenditures 26604% 46.66% 71.62% 107.24% 9726% 130.52% 105.92% 78-11% 6371% 8845% 93.45% 96.7311 104.32% 110.22% 116.45% 123.04% 129.99% PREPARED BY PUBUC FINANCIAL MANAGEMEM, Mc, MAX)11:39 AM G. -al Fund (Scenod.B.Sensifivily2).ads r I 0 I a I Ad - q Z N nr. aN Nn O --e - n n me n nnn OIO �'��'eea8: N n n m o--— e e E 8888be gija� 8 e N N n m n mmmoo — n nnnnno V �e a�M;et tae •be`R� g a $clsc �� o � N a �e�a�ee��t •ex tp � .a E: � e e e�� x grvn.n Nv�in mo-ee m n- m moo nEE ne rtin ai oe `In e �4a �ee 3n�F, n R - g nnn . N N n m o--- b . n . b m m o e m o Q E Nnn�NNnmO--- m n �>m bR OOV m `rm0 Om�mn m T1 m n m O:h n - m b �'1NOm_'NO`DV ON�a N $•tv f� lV �`�'aI m- SSS �Om n Nn-mNO -gib N c om- � LL r X au oRR m 6 m z � N W > .yt x type x ,�pp C O m p O O N C O W W W u a m m ✓F�tt��l ti � C � m 8 � � y'Lcm m � a � 6 � � � a�'Tc � S �.R g�.LL fi .� � � � a u'• �gg O5 4 4 � 6 V � h b8 � yOj m 4 U C7 WN 7 N N W N1CR�P;p AP.AA, I 0 0 i 0 0 0 0 0 0 0 o e o 0 0 o c 0 0 0 .... 000000 0 i ............... 00000000000000 o o � o ...... 0000 0 00 S 0 0 0 0 0 0 0 0 0 o c o of a o e o 0 0 o e o I 0 0 0 0 0 0 0 e o 0 .......... 00oeo00o o .......... 0000000 g 0 0 0 0 0 0 0 0 0 0 0 0 oI o 0 o c o 0 0 0 0 oo I 0 0 0 0 0 0 0 00 e F i oo oo i 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o c o 0 0 0 0 0 0 .......... 000000 .. g ........ e e o 0 o ..... oo00 0 o ... 00 0000 o o ... 1 0 0 0 0 o 0 0 o ..... 0 .. m I 0000000000000 0 00oco 00000 - Nr�^.o ��q 4Q oN�a Y.,n dm-'-" 3Pyti=a aF m� an =� �?� = •8.o mem m �a It e14 d E o �� ffm- gMHW am^o IC�F��ryemm �� m mmlmR A 7GFSY.6 _'d c -m-�S R p' - 99 l N � C O y m I � g It-+� = T"gym `sa `s LL �• zMi UCS W 0 nn oo No` DD - Doc 8 ., o n 0 oe oe noe0 oe ry o p nQ � n � �e 8 n n G G N o 0 o N D o 0 0 _ m996 8 991 919999, sa 6 Sg 0 0 0 0 O O O O D O N O O O N O O p N p O m Obi P Oc,� N O l3 N O N O O O m FXFXi 0 0 8 O a�Qp!p�QpP 99K. O O n 6 6 6 O "" N W T D n C M in �` A lu bbyy ypy pt j9 �9 9 9yb( O n O9 �bF N LL n O S O G Op SO S. ap 00 O app O N e U s p j$ o 99 A M L O g 6 g E go 9 99 9 a` G H m £ i - u O_ W� m LL is �a� _ate o U C1 [7 W O �- � O r ►` o a o c