Loading...
HomeMy WebLinkAboutAgenda Report - March 30, 2000 B-01 SMCITY OF LODI -14 COUNCIL COMMUNICATION AGENDA TITLE: Approve the revenue and expenditure assumptions as outlined in the General Fund Cashflow model created by Public Financial Management, and Authorize change of revenue estimates for the 1999-01 Financial Plan and Budget. MEETING DATE: March 30, 2000 SUBMITTED BY: Finance Director RECOMMENDED ACTION: Approve the revenue and expenditure assumptions as outlined in the General Fund Cashflow model created by Public Financial Management, and Authorize the change of revenue estimates for the 1999-01 Financial Plan and Budget. BACKGROUND INFORMATION: Creation of a long range financial funding model was one of the major City projects outlined in the 1999-2001 Financial Plan and Budget adopted by the City Council. To assist in the successful completion of this goal, the City hired Alex Burnett from Public Financial Management (PFM) as the City's financial advisor. PFM's scope of duties included the creation of a cashflow model of the City's General Fund, the assessment of the viability of the public safety building project on a pay-as- you-go basis, and the assessment of the impact on the General Fund balance of any structuring alternative for the public safety complex financing. Mr. Burnett presented his model to Council in shirtsleeve meetings on November 23, 1999, February 8, and February 29, 2000. In addition, PFM and City staff met with a committee consisting of members of Lodi's business community seeking their professional feedback on the model. Attached is a letter signed by committee members stating their agreement that the prepared assumptions and projections are reasonable and conservative and provide the City with the basis to proceed to project design. Staff is requesting Council approve the revenue and expenditure assumptions as outlined in the General Fund cashflow model created by PFM. These assumptions are conservative and they will be re-evaluated on an annual basis as part of the budget process. In addition, staff is requesting Council authorize the change of revenue estimates for the 1999-01 Financial Plan and Budget to reflect the revenue assumptions in the cashflow model. Mr. Burnett and staff will be present to answer any questions. FUNDING: Not Applicable Respectfully, o �y tA- o ,� Vicky McAthie Finance Director Attachments i APPROVED: H. Dixon Flynn -- ity Manager March 16, 2000 Lodi City Council 221 W. Pine Street Lodi, CA 95240 Dear Mayor and Council Members: On March 15, 2000 the following individuals met to review and discuss the City's proposed General Fund Long Term Financial Plan as prepared by Public Financial Management (PFM): Phil Lenser Bruce Sasaki Jeffrey Kirst Kent Steinwert Randy Snider Evie Olson Steve Reeves Joe Crane Roger Baffoni Wally Katnich Mamie Starr Dennis Bennett Frank Johnson Barbara McWilliams Ole Mettler After considerable review, we have determined that the City's proposed assumptions and projections are reasonable and conservative and that the City should proceed to the design phase of the Public Safety Complex project. In addition, suggestions were made that the City invite local business and community leaders to annually review the assumptions of the City's long-term financial plan should the City proceed to the financing phase of the project. Respectfully, Please see signature page cc: H. Dixon Flynn, City Manager Alex Burnett, PFM ' i i - mm- rmix _ Z1114 lro,4a Wally 01nich Z��: Phil Lenser Ole Mettler WON, St es ii-�.:��� _ Barbara McWilliams Evie Olson Bruce Sasaki mie Starr City of Lodi Public Safety Complex Financing March 30, 2000 Public Financial Management 505 Montgomery Street, Suite 800 San Francisco, CA 94111 415 982-5544 City Of Lodi 415 982-4513 fax What we have done... CIN of Lod; • Met with City Staff • Created a cashflow model of the City's General Fund, consisting of: • Five years of historical data • Revenue and expenditures projected on a year -by -year, line -by- line basis • Projections to 2010 • Assessed the viability of the public safety building project on a pay-as- you-go basis • Integrated structuring alternatives for the public safety complex financing to assess the impact on the General Fund balance • Evaluated the impact of the parking structure in terms of reduced debt service requirements • Met with City Council in shirt -sleeve meetings on November 23, 1999, February 8, 2000, and February 29, 2000 s- . ice• City of Lodi Revenue Assumptions • Refined further to produce conservative estimates. • Projected average annual growth equals 3.23%(1) vs. 3.60% from FY95-99. (1) Growth rate = 3.18% when expenditures are 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.000/6 2Historical Avernge from M'95-99. 3 Property tax transfer to Capital Fund escalates at the property tax projection rate. 4 One-time transfer in FY01. 1'1•\1 13 I'rcr er Tax 2.50% FY 96 = 3.59%,17Y 98 = 3.55%, FY 99 = 3.25% Sales and Use Tax 3.75° o The I Idl, Companies Forecast = 3.11% I listorical Average FY 95-99 = 4.87% San Joaquin COG assumption = 5.600/6 In -Lieu franchise Tax Assumes some growth in enterprise revenue Hlectric 1.00410 Consistent with hating Process, SSB recommendation I listorical Average = 5.84% Sewer 1.00% 1 listorical Average = 15.44% Water 1.00% I listorical Average FY 96-99= 1.43% Other Taxes Public Safety Sales Tax 'l'ransit Lodging Tax 3.75% 4.364 a 1 listorical Average = 12.95% I listorical Average = 4.36% Waste Rrmoval Franchise Tax 2.76% I listorical Average = 2.76% Industrial franchise 5.46% I listorical Average = 5A6% Gas Franchise 3.41% I listorical Average = 3.41% Cable'TV franchise 6.00% I listorical Average = 6.88% 1{Icctric franchise 0.99% 1 listorical Average = 0.99% Neal PropertyTransferTax 5.00°6 I listorical Average = 11.80% Intergovernmental Revenues Motor Vehicle I iccnse Fee 3.79% 1 listorical Average FY 95-99 = 3.79% 1 listorical Average FY 91-99 = 2.96% Assumes backfill for any legislative change Other 1.41% Other Revenues Licenses and Permits 6.00% I listorical Average = 20.12% Charges for Services 6.00% 1 listorical Average = 14.96% Fines, forfeits and Penalties 8.00% 1 listorical Average = 16.62% Rental Income 6.00% 1 listorical Average = 2.18% Assumes growth due to the performing Arts Center Investment Earnings $400,000 in FY 2000-2002, $350,000 in I•'Y 2003-2010 Miscellaneous Revenue I listorical Average = (4.88%) Approximately 570,000 per year Other Sources and Usti Varies Operating Transfers In Equal to expenditure projection rate Operating'l'tansfers Oury 0.000/6 Other Sources 1.00% from 2003 onward Impact Fees", $2,000,000 Assumes Capital Fund reimbursed for past expenditures (1) Growth rate = 3.18% when expenditures are 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.000/6 2Historical Avernge from M'95-99. 3 Property tax transfer to Capital Fund escalates at the property tax projection rate. 4 One-time transfer in FY01. 1'1•\1 13 City of Lodi Public Safety Complex Project Cost Fiscal Year 1998/1999 1999/2000 2000/2001 2001/2002 2002/2003 Total Construction Phase 1 $924,000 Fire/PSB Improvements $224,000 $70.0,000 Phase 2 $10,024,000 New PSB Design $800,000 Construction $2,310,000 $4,612,000 $2,302,000 Phase 3 $6,050,000 Renovate Old PSB Design $250,000 Construction $1,450,000 Parking Structure Design $350,000 Construction $4.000.000 Total $327,000 $1,659,000 $4,000,000 $4,612,000 $7,752,000 $18,350,000 • Phase 1 includes Fire Station 1, Fire Station 2, and Public Safety Building Improvements • Phase 2 includes the new Public Safety Building • Phase 3 includes the remodel of the existing Public Safety Building, and the Parking Structure 14 L4E cn V Q m A Co N OL °, m c QA > °x m a co A O C G O m V N X '] m O A A 3 y m N � w c c ° 'S m O O O m a c m o N co a � � L m E N U 2AZ7 m E -. = cn m N � m o O a C C m E m Y A E O V O ; mo N y C A L y Co ID co a O C N N U L m C U A O c o LL m O O A m z E o — LL E e i CL N C i C' 3 m LL — co ---- E cq m 3 N O ` _ LL O _ N O Ch N O - -- m LL , C a 3 0 O _ E _ O O a — N ¢ a 0 o d C Q N C¢ 'O _ r Co y' C � C a °+ >_ CM O 3 m U co C: d ._ i ° ° E: ° a' v rn m ¢ C a c: v a '� o' o = 3 3 E: E Y: a w a• o u.. to z z s¢ a V Q m A Co N OL °, m c QA > °x m a co A O C G O m V N X '] m O A A 3 y m N � w c c ° 'S m O O O m a c m o N co a � � L m E N U 2AZ7 m E -. = cn m N � m o O a C C m E m Y A E O V O ; mo N y C A L y Co ID co a O C N N U L m C U A O c o LL m O O A m z E O .v C ca O E w '— cc as j r -O � cc _ Ir v c 0) V d m LL O 4) cc a x Preliminary Results: General Fund Balance with Debt Structures O o N City of Lodi 9,000 Co 8,000 O O v O O %,000 O O m 6,000 O r O O O 5,000 ti O Lim 4,000 O O O N N 3,000 N N O r N M Co 0) O O O O O O O O O O O r O O O O O O O O O O O N N N N N N N N N N N Fiscal Year —Scenario A: Level — Scenario B: Wrap —Scenario C: Wrap with Defeasance cenario A: Level 13,630.367 5,079,269 16,208,151 16,990,935 16.818,203 16,706,417 16,665,147 16,710,323 6,854,3477,116,008 7,500,823 cenarlo B: Wrap 3,630,367 5,079,269 6,208,151 6,592,041 6,667,514 6,807,044 7,018,799 7,317,171 7,712,868 8,222,924 8,860,828 cenarlo C: W rap with Uefensancc 13.630.367 15.079,269 16,208,151 6,570,638 16.625,185 16,744,278 16.936,096 17.210,170 17,582,348 18,074,541 18,690,248 Conclusion and Suggested Council Actions CONCLUSION City of Lodi • With aggregate expenditures increasing at 3.50% or less, it appears that the Public Safety Complex can be financed in accordance with projections SUGGESTED COUNCIL ACTIONS • Approve current revenue and expenditure assumptions with the understanding that they are conservative and that they will be re- evaluated on an annual basis • Authorize change of revenue assumptions in current budget • Authorize impact fee transfer to General Fund • Appropriate $2 million for design & acquisition of the Public Safety Complex The above actions by Council is just the first phase of the project; It does not commit the City to: Accept the design, Approve any financing commitments, Restrict looking for alternative funding sources, Breaking out individual components of the project: i.e. Parking Structure. Per City policy, each phase will come back to Council for discussion and direction on further action. IV 8 IM— ■x CL CL EO CITYOFLODI; dJp 9 i" ,.4•, !'. , !b , p93:�r� * f f irw.r. Y"'�` j�,4 �iia7q,� �°'"" :"� ' 1 I e . . 1+j " .�I; Aasum6tlns dlturssPl EBenGeneral ola9led�iwr69R� 4. in - tmo. �x ' �i� OM1 Y I 4 ) f,t ° i1 5afiWAI.- , fF a �;• F 7._.....r ae�.8FlnaneFlndCasFfDw Bus Prol9ellon3 wllh LiwM Public 9GeneralFund ll� ng, .'� 1I' 7 , i •+ - rnro7 ' ' `..,^:,. I 7 • �,� 5•,x ? +I�+,•' IIIa1Mu1 Pr Mtd Ffaeal Year End/np7 1991 1995 I996 1997 1998 1989 1000 1001 1002 IOW 2001 2005 2006 1007 2098 2009 2010[3..0401.330 tal 16eQlnnlnq 6414nce 2,117465 4.039,567 3,9!72.441 3.371.957 2,510,296 2261.476 2,710,676 3,630,367 5,019,269 6,206,151 6,990.935 6.818,203 0706,417 6.665,147 6,710,323 6.854,347 7,116,00809.237 SOURCES OF FT)NOS Revenuta Ta.m _ - 2 Prteweny law 4,949,911 4,077007 4,223,516 4.224,805 4.374,489 1,516,855 4,629,777 4,745.521 4,664.159 4,985.763 5,110,407 5.236.167 5,389.122 5.503.350 5.640.933 5.761•%7 5,926,50662.016 3 Sales a Use Taw 5,220,919 5.215.767 5,762.763 5350.307 6.204.988 6.623.512 6,811.694 7.129.500 7.396.949 7.674,335 7.962,122 0260,702 8,370,478 8.891.871 9.225.317 9,571.266 9930,19963.007 4 Public Selaly S" Ta. (Prop 172) 97,913 148.541 153.6% 151.333 179,848 180.053 188.805 193,810 201,078 208.619 216,442 224,558 232.979 24t.716 250.760 2110.185 269.942 5 1..., Ldgm T. 246,646 248.429 277.793 249.072 277,627 305.313 318,650 332.547 347,050 362,186 377,982 394,466 411.670 429.624 448,381 467,915 488,322 0%3.677 6 Waste Ren-.- Farw"w Ta. 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 1Mwilial FfW Nm 24,743 22.135 23.028 25,358 26,442 32.261 34.045 35,905 37,866 30335 42.116 44!17 401144 49,403 52.102 54,948 57.950 651,518 6 Gas Fra "N" 106,516 109,042 108,067 104.137 121,490 128,334 132.705 137.225 141.899 148,733 151.730 150699 162.243 167.769 173,483 179.392 185.502 2,415,218 9 Cade TV Franchise 118.010 113668 120.542 126.271 148,786 144.602 174,478 184,947 198.044 207,007 220.275 233492 247.501 262.351 276.092 294,778 312.464 3,400100 t0 Etxlric F-dise 10,989 10.716 10,961 11,230 11,697 11,542 11.658 11.771 11,887 12.004 12.123 12.242 12.367 12,465 12.608 12,733 12.656 201.818 11 1n4.teu Fra J--Elenno• 3.218.690 4,160,000 4.174.800 4,005.800 4.292.067 1,275,041 4.317,797 4,360,975 4.401.505 4.448.631 4.493.117 4.536.019 4.583,429 4.629.263 4,675.556 4.772.312 4,786.535 74.149,653 12 In -Lieu Fq Nse•6mw6P 385.000 609,000 690.686 719.300 686.920 7119.212 797.104 605.075 eI0126 821.257 929470 617764 Mill 854,604 683.150 671,781 980,499 13,102,204 13 In -lieu Frafr,N9a • Waley 750.000 531,400 547.100 U7,400 581.562 562,440 566.084 S73.745 579,462 555.277 591.13D 597,041 60,012 609,042 616.132 621284 627.497 10.068.609 14 Real PrOpelly Trander Taw 80145 67,782 74.9% 65.601 77,344 119.007 124 958 131.205 137 766 144.654 151.687 159,481 187.455 175,828 164,619 193 850 _ 286.543 2248.011 15 Twat Tam -- 115.445 074 15.563, 838 16.406.023 16.515.3% 17.246.430 17,986,569 f6A57.050 16.939.418 19.097.194 t9.950.931 20.481.196 21.028.604 21.593.677 22.177.144 22.779.631 23.401.822 24.044.427 331.469,397 rs Liters, am pere9ls 5D6 S30 1133.%1 842.295 1,012.418 1.182,610 1,286.630 1,312.828 1,423,185 1,508,577 1.50,091 1,6%,037 1.7%,779 1.901.513 2MISAI6 2.139.945 2.2,.341 2.404.442 25.545.268 IrnerypYaw'.. id rmbnue5 17 Moles VoWle ticensa Fee 1,885,{80 2,023.190 2.143,507 2.270.423 2.220.516 2.270,423 2.356.446 2.445.729 2.538.396 2.634.571 2.734.392 2.837.904 2.945.522 $057.124 3,172•%5 3.293.171 3.417,916 44.247,490 18 0#- 413,916 728•%1 387.066 796.857 552,722 443.933 450.193 456,541 462.976 469.686 476,127 882,641 489619 49059 6D$SSS 510.856 517.858 0638,930 52.887.420 ._- 19 rota kwollo7enan.sal. m7um 2289.0% 2,752.171 2.530,573 3,067,290 2.773.240 2.714.356 _ 2.806.639 2.902.270 3001.373 3104.078 3.210.519 3.320.835 3.486.171 3553.677 3,676.510 3.803,629 3,935,804 20 Charges ler SBrv10K 651,024 421 745 %1.184 1.039913 129.326 1.307.370 1,385.822 1.466.971 1,557.109 1.89.535 1. 749,5513 1,651.512 1.965,815 2.083.764 2,200789 2.311.317 2,461.7% 26.381.999 21 Fk1m. IIMels and puldfim 407.168 405816 420.983 452.717 1161.783 670245 948.505 1.024,385 1.105,336 1.194.843 1.290.430 1.393.884 1.505•I58 1,625,570 1.755.616 1.890065 2.047.750 19.015.035 Rental 22 if- 127,725 41,775 101.922 39.647 80307 142.297 150.635 159.8861$9.470 179,617 190428 201,851 213362 226,: 240.406 254.833 270.122 2,797.696 23 EsBmabd lmmNanl Eanurlps 313.146 351,343 332145 lea sm 245.330 602.235 400.000 400.000 350.000 350.000 350.000 350.000 350.000 350,000 350000 350.000 350.000 5,858.704 24 usca6Ntauus revenue 91.566 130,710 120,347 78.102 112.924 71.301 71,301 71,307 11,301 71.901 11,901 71.901 71.301 71.301 71.301 71901 71.301 1.389,263 25 Omer SOurcm 0 0 0 0 0 0 976.000 Be 000 697,910 704.889 711,930 719.057 720248 733.510 740.646 748.251 755737 6.375.389 26 7ra191enin 4.561.329 3.779.891 3760.391 4.519910 4.663.490 4,245,037 4.024.920 4.050.960 4.102.744 4,339.490 4.491.372 1.646.570 4.811.270 4.979,664 319.952 5.334.341 5.521,063 77.067.772 27 SudOIL Roverko a 24.402,660 24,081,252 25.467 763 26.888,662 28,225.516 29.117 049 30.493.699 31.401.373 32 082.021 33144,605 34.241.783 35.385 132 36 577 145 37,820.247 39.11 997 40.470,103 11.852.422 550.778.648 USES OF FUNDS Ewxndlluna B R P ed Cur. 28 Oerterel 0owetnrnenl 4,690941 4.922.689 5.216.8% 5.881.889 7,068.021 7.230903 7.8%•500 8028.635 8,309.844 0800.689 6.901.7113 9.213273 9.615.737 9,869,489 10214.920 10,572.442 10.942.478 137,215.041 29 Publicgiclion 9.938.553 10.274.500 10142.446 10.962.365 10,741.11% 11.098,702 11,649.235 11.812,315 12,225,746 12.653.647 11096.525 13554.903 14.029.325 14.520.351 15.028,583 15.554.563 16,098,973 213,301.637 30 Pudic 9wks 3.908,240 3.628, 448 4,327.322 4.976,882 4,462.128 4.544.160 1.067.435 4.218.050 4.396,732 4.550.617 4.708.339 4874.735 5845.351 6.221.939 5,404.706 0!93.871 5,789,656 19.770.580 31 library 631.274 956.120 99,667 1,012. too 965.606 1,029,669 1.073785 1.0%,285 1,124,305 1.107,655 7201,384 1.246.537 1.290.168 1.336.322 1.382.056 1.430.430 f,460.495 19.616.086 32 Parks and rSCrGafw1 2,307.357 2299.181 2.197,614 2.312.379 2.173.645 2.230,233 2.5%.635 2.601.945 2.777,780 2.875.002 2.975,627 3079.774 3.587,586 3299.131 3.414,606 3534.111 3.657,805 47,602,405 33 On - UM 0 0 0 0 0 0 200.000 0 0 O 0 0 0 0 0 0 0 200,000 T..d- Out 29.544205 29.952.471 30,983 139 32 362 020 3411/316 35.496.917 618 495 37 77 36872 973 40.206 442 41.497 606 540439/126 37 S bW& E 23.48t.455 24.12a.376 26121 572 27 750 354 20.474 327 28677 962 38 NET fNCoA#E . MW E 921 206 (0.426) 653 111151,6111 (248.910) 439,067 91111.491 1.446.902 1 128 782.784 (t72.732) t11 788 (41.2701 45.176 t44.024 261.661 384,015 4.336 822 39 Addidorrally Required Rawness 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 HIND aAUNCE e � 7.w4r.r(' I _ _ 40 Re0lnntnp Bal- 2.143465 4.039.567 3.992,441 3,371,957 2.510,286 2261,478 2.710.878 3.630,367 5.078,269 8.200151 6,910.935 6,816.203 6766.417 6,665,147 6.716,329 6,054,347 7,116,006 83,809,237 41 n."woomyhar wi. 33.325 10.313 43,638 41 Net 1rlt;pntp 621,205 (47.126) (6530179) (661.671) (248.810) 439.087 919,491 1.448,902 1.128.882 782,784 (172.732) (111.788) (41.2701 45°178 144.024 261.461 384.615 4,336,822 12 Re6lalemen4- 974,697 O 0 0 0 O 974,899 43 Ent911p Baletc9 4.039,587 3,992,411 7.371357 2,510,286 2,261,478 2.710,678 3,830,387 3,079,269 8.209,151 6.990,935 3.818.203 6,706.417 6,665.147 6.710.323 6.651947 7,110ood 7;.30,923 89,786.5% 44 %Endep Balance of Arww EwpanOilur.6 17.209E 16.55% 12.917. 9.05% 7.94% 9.45% 12.29% 15.96% 2005% 21.609. 19.81% 16.89% 18.2094. 17.76% 17.59% 1770"3 16.011° CITYOFLODI_'- :: p.' I t ryq Scenardo C A� FI tlk'6 n JI General FundFlrlanCla/Plan +r s AsalLmotlon6l 1 - ,.; ., 'j General fund,Transters In7(OUt) p'y, Bsse Prolaetio"ps with liwl r'- 1�' r :y,.,�n "yIl sfinsnronyl la' lry�?� 1 r e Jr M f. ndilurasPr4tCom at850%4,1, Public `r �r" �"' '� Safa�ly Complex Flnetteltq 1 ...) �r,� 4 • `� k _ .,, ,1 j " t "k a �i I ��A^! I a11Nislrsdeal Met, ~Total Fl -I Year EnCInO� 1994 1995 1996 1997 1998 1999 2000 2001 2002 2007 2004 2005.2008 2007 2006 2000 2010 TRANSFERS IN - Ope..I Transfers In 1 CMI a S.Mces Transacoons 1.455.668 2,666,303 2666,303 3,020,920 3,0461 13,856,154 2 Sheat Fundus U. to oll- snare main 640,000 933,800 937 SW 960,576 982,563 982,563 1,001,000 1,004,000 7,441,302 3 OIIx4r 3,921,329 2.346,091 2.916,591 1.103,066 1.014,624 598,171 0 0 4,192,744 4,339490 4,491,372 4,648,570 4,811,270 4,979,664 5,153,952 5.330,341 5,521,043 55,770,316 4 Total Op..I Transfers In 4,561.329 3,779,891 3,750,391 x,519,310 4,863,490 4,245,037 4,024,920 4,g50,9rA 4,192,744 4,339,490 4,491,372 4,648.570 4,811,270 4,979,664 5,153952 6,334,341 5,521,043 77,067,772 5 Twat Transfers In 4,561,329 3.779,891 3,750.391 4.5t9,310 4,663490 4.245,037 4024,920 6050,964 4,192.744 4,339,490 4,491,312 4,619.570 4,811,270 4,979,664 5153,952 5.334,341 5521,043 77,067,772 TRANSFERS OUT Operating Transient Out 6 Opamling Transfers Oul 0 7 Berwlil. Fund 269,485 269.485 538.970 a Insue, Funds 400,000 40O.WD 500000 9 Outer 1546,065 1,536,326 2,016,347 1.337,848 1,730,100 1,182,005 0 0 669,485 669,495 669,485 669,465 669,485 669,485 669,485 669,405 669,485 15,374,074 10 Taal OPeralM9 Tanslera Oul 1516.085 1,536,326 2,016,307 1.337,&6 1,730,100 I,IB2,OD5 669,485 669.485 669,485 669,485 669,485 669,485 669.485 669.485 669.485 669.485 669.485 16,713.044 Transfers 0.1 to Capllal Polack Fund Il propany Tax 0 611,114 1.267,056 1.267,264 1,312,329 1,358270 1,386,933 1,423656 1,459,248 1495,729 1,533.122 1,571,450 1,610,736 1,651.005 1.692.280 1,734,517 1,177.952 23.152,751 t2 1-stmard I"- - O 13 SuBim-yTm I.tor D.WS.- 0 0 0 353196 1.323,771 1,236,780 11250,009 1,208.351 7,166,360 1,118,952 1,080,763 8,786,202 t4 01-4aneral Fund Capllal 0a 15 TOW Tranafare Out Io Capital Projects Fund 0 611,114 1,267.056 1.267,284 1,312.329 1.356,270 1,388,933 1,423,656 1.459.248 1,848,924 2,81 2,858,210 2880755 2,859.355 2.858.640 2,111 2.8541.714 31,940,953 TraMtars Out 10 Llbntry Fund 16 Property Ta. 0 17 Tout Transfers Out to Library Fund 0 0 0 D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 Total Transfers 0.1 1546,085 2.147440 3.283.403 2.605.130 3.042429 2,538,275 2,056,418 2,093,141 2.128,733 2,518,408 3,528,378 3,627,696 3.530,270 3,528.840 3,528.125 9,523,124 3.528,199 46.653.9971 1 19 TOTALTRANSFERS RI 3,015,244 1.632.451 486.981 1,914,180 1,621,061 1706,762 1964502 1,967619 2.04,041 1,1 964,993 1,120,974 1,290999 1450.824 1,625,627 1,111,317 1,992.843 28.413776 OTHER SOURCES SES 20 Other Source. 0 0 0 0 0 0 578,000 961,000 687,910 704,1199 711,938 719,067 726,248 733510 740.846 748,254 755,737 8,375,389 21 Omer Uses 22 "Ma-%weNSurvey 200.000 200.000 23 Total Other Uses 0 0 0 0 0 0 200,000 0 0 0 0 0 0 0 0 0 0 200,003 24 TOTAL OTHER SOURCES USES O 0 0 0 0 0 676.000 961.000 697.910 704889 711,938 71S,057 728,248 733510 740.9913 748250 765,737 1 8176389 PREPARECBFPUBUC FWANIL MANAGEMENTINC:-. 1. M`.. 's_p ::. - ,:',.:•. .,..-.. .. 2721007:03 PM .` Genera' II (ScorwrbA-SmxWI Nis2).ds GeneralF(i IaT'Pfin' AiwlnDuone r. i; t::� aEG 1�, 7; - •� p`Y:a;y,'F �:� ,.� 3*4 �I C"�c e ° YY; ry. •1(J'iu'� t. - •',IIS :)I �3 YI {':i..h Gross Debi S-0- 'rvi:.:d�t I.rY :r. �, '..>.,� T Se;'.: 4.w I,,xr,1 F .tt'A'11y ''N4 A+,•A�„,.f. 6,091,916 ,. A ik' fM ::.Oebt;Summaly� r.:f. sseProJecUon9wNhLevePPIi611cS6f6gfx�Pln9�R0,,:r.,�i 00 Compb WA 131,064 fff pkl ,",:-.hkti ,l.rr �. s ,�r I' ':J':��'I.'r�clf• (A ..., •�p.rJ,,,P� ,d .. WA Nl.wdcm 850.475 $47,945 I'Senss2001 P ailed WA WA WA WA Fins)Yea/EM 1994 1995 low 1997 rose 1999 20eCl 2001 2002 2003 2004 2005 2006 2007 2009 1 275.626 2009 2010 Intel BOND SOURCES AND LIGML LII '.: -19 2.6t6.234 2.606.918 Sed. 2001 Sedesl995 WA WA WA WA ti Band Source4 Seri. 1995 $ad" MA 1 Par Am ,M WA WA 5.D00,OOD 10,120,000 WA WA WA 22,620.000 WA WA WA WA WA WA WA WA WA 37,940,000 2 Sr 11 Bale Saaces WA WA 5.000.000 10,120,000 WA WA WA 22.020,000 WA WA WA WA WA WA WA WA wA 37.940.000 Band Uses Sad. 1995 Series 1996 1.2919% 5eriee2001 WA 50.998 101,995 101^995 19 Seder 1995 WA 3 Project Fuld WA WA 4,719.177 9.917.600 WA WA WA 19.023.000 WA WA WA WA WA WA WA WA WA 32.669.777 4 Date Sendce Reserve Fund WA WA WA WA WA WA WA 1.6112,261 WA WA WA WA WA WA WA WA WA I^682.281 5 CalieaSrad intents% Fund WA WA WA WA WA WA WA 2.490,490 WA WA WA WA WA WA WA WA WA 2.490.490 6 CM or l.usnae WA WA 188,000 202.400 WA WA WA 204000 WA WA WA WA WA WA WA WA WA 590,400 7 Unde,wdlafs On WA WA WA WA WA WA WA 171,1511 WA WA WA WA WA WA WA WA WA 171,%50 6 Bond Ineusncs WA WA WA WA WA WA WA 251,936 WA WA WA WA WA WA WA WA WA 251,936 9 AddiliaW Proceed% WA WA 100,000 WA WA WA WA 1.143 WA WA WA WA WA WA WA WA WA 101,143 IO Subtdal9ord17a. WA WA 5,007.177 10,120,000 _WA WA WA 22,820,000 WA WA WA WA WA WA WA WA WA 37.947,177 4,490 2,948 29 Sedu200% WA WA WAWA 642,333 WA Wi 30 S."",s scal Cluq. wA LBOND DEST SERVICE - -- - - Gross Debi S-0- 425,906 421,214 425.396 6,091,916 425,341 427,201 11 Seder 1995 WA WA 131,064 426.231 429.871 427,681 12 Seder 1996 WA WA WA 346,411 850.475 $47,945 I'Senss2001 WA WA WA WA WA WA 14 SuWalal DBW Sunk. WA wA 131.OBA 712.262 1.280.346 1 275.626 Debt Service Reserve Fund ('DSRF') Intl Earnings15 1274.276 1.946.230 2.6t6.234 2.606.918 2,946,374 Sedesl995 WA WA WA WA WA WA IB 1996 WA WA WA WA WA W/ S-2001Sense I7 S2001 WA WA WA WA WA wl 118 SUWOMIDSAFand Eam9lgs NIA WA WA WA WA wi CapWlasd wers:% 1.2919% WI WA 50.998 101,995 101^995 19 Seder 1995 WA WA WA WA WA NO M Sade: /696 WA WA WA WA WA WI N Series 2001 WA WA WA WA WA WI ?2 SIIW WCapd W9d Interest wA 4,A WA WA WA WI Nsl Debi 51144" WA W/ WI WA WAWA 23 Series 1995 WA WA 131,084 426.231 429,671 427.981 ?4 $wise 1996 WA WA WA 348.031 850,475 647,945 25 Series 2007 WA WA WA WA WA WA 26 S'ubfoWAW Debi Servire WA WA 131.084 772282 12aO.346 1.275,826 Fiscal Charges WA WA .1 2.682.053 425.341 427^201 27 Seder 1995 WA WA 3,535 3.535 3,535 3,535 28 Sade. 1998 WA WA WA 4,490 4,490 2,948 29 Sedu200% WA WA WAWA 642,333 WA Wi 30 S."",s scal Cluq. wA WA 3,535 S. 02S S. 6.483 31 Oln. Dabl SOMee 405:160 345,496 365,584 150.500 11^466.610 1574.276 32 Total Debi S"m 405.160 345,490 500.203 038.667 1280.371 1.282.309 DEBT RATIOS'- 2.641.024 2.848.199 28,886.669 3.535 3,535 3,535 33 General Fund Revenue 3^535 3^514 25,467,763 26,855,682 20,225,516 29,117,049 34 0.1Aery a %el General nd Rue (Line 14Aine 33) A Service as Fueven 53,025 0.61% 267% 4.64% 4.387 . 35 Capnal F..d Revenu 4.490 4,490 11, TOO" 25.677,757 19.453,648 6.903.629 36 Deal Semite. a %d Capital Fund Revenue WA 4.490 425% 3'U% 6.62% 18.571 37 Dowl General Fund DMAAA e.^rOulSWldnq 0 0 5,000,000 15,120.000 14,970.000 14.500,ODC W M --,d Fug Cash Vak,CAV•r 2,471,754,000 2,471.754D 2.656,928800 2,393,000.000 2,693,000,000 2,503,000.000 .O 39 Ratio at OielDeMM1Auu b AV 12.515 12,5I5 0.1956% 0.6031% 0.5773% 0.559:Y, 40 PDgdaOonn 53,000 53.515 64.473 54.800 65.700 65.700 At OW per Cape (S) 91.79 275.91 266.76 260.3: (1) DOae nal include esupnenl leaserl2) 1.237.234 1,185.727 1,848.624 2.656.893 2.65(1.210 2.860.785 AV is pra)xle0 ro grow 1112% am"111,111,117 alry Iran 2002 onward 2.650.640 2.853.539 2,656,714 30,320.734 42)rapulal4vrknelnclan M�rew al l%an ,sxv Iran 2002 inward PREPARED aY PU84AC HNANL7AL MANAGEMENT 97C. _ 424,526 425,906 421,214 425.396 6,091,916 425,341 427,201 428,411 424,074 424,171 423,564 427,044 646,935 646,515 646.796 64x616 844.506 843,796 841.1148 842,685 642.333am-m 6.20% 840.516 11.326,142 WA 670.513 1,341,027 1,343,027 1,677,695 1.680^329 1,681,574 1.681,424 1,679,682 1^601,686 1,682,281 15,%17,617 1274.276 1.946.230 2.6t6.234 2.606.918 2,946,374 2.947.691 2.950566 2,948.536 2.918.121 2.943.019 2.948.194 32^537.675 NIA WA WA WA WA WA WA WA WA WA NO WI WAWA 28.925.000 WA WA wA WA wa WA WA WAW) 1.2919% WI WA 50.998 101,995 101^995 101^995 101^995 101,995 101^995 101^995 101.985 10119D5 864953 WA 50.996 101.995 101.995 101.995 101.995 IOt.995 IOt.995 101.995 101.995 10I.95 968.953 WA WA WA WA WA WA WA WA WA WA W/ WI WA WAWA WA WA WA WA WA WA WA WA WI WA 670,513 1.941^027 I.M.S13 WA WA WA WA WA WA NO 2,682,053 WA 670.S13 1.341.027 670.513 WA WA WA WA WA WA .1 2.682.053 425.341 427^201 420,4tl 424,074 424.171 423,564 427A" 424,528 425,906 421,214 426.396 6,091,916 648.35 640.515 016,7911 843.16 &4.508 &3.796 641,646 842,566 642,333 039,940 84O,Sle 11,328,142 WA (50.990) (101,995) 588.518 1,575,700 1,570.334 1,576,579 1,579,429 %,577.887%S79,870 1,580.2(15 11^466.610 1574.276 1.224.719 1^173,212 t,M.409 2,844,378 2,645,586 2.80.270 2.846.610 2.848.125 2.641.024 2.848.199 28,886.669 3.535 3,535 3,535 3,535 3^535 3^514 3,535 3,535 3,535 3,535 3,535 53,025 4.490 4.490 4.490 4.490 4.490 4.490 4,490 4.490 4.490 4,490 4,490 61,318 WA 4.490 4.490 4.490 4.490 4.490 4,490 4,490 4,490 4.490 4.490 44,900 8.025 12.515 %2.515 12.515 12.515 12,5I5 12.515 12.515 12.515 12.515 12.515 159,243 1.274^822 1,252.301 1.237.234 1,185.727 1,848.624 2.656.893 2.65(1.210 2.860.785 2.859.355 2.650.640 2.853.539 2,656,714 30,320.734 40,474103 41,982 422 35,385,132 30.463.699 31,401.373 32,092.021 33,144,805 31,241,7113 36,577,145 37.824247 39,116,997 412. 6.20% 615% 7.87% 860% 8.33% 6.07% 7.90% 7.54% 7.27% 7.041 2,108,933 9.602,658 6.272,373 1S,625.24 4,282,793 4,259,758 4,238.622 4,214,135 4.191,042 4,164551 4,199,444 60.80% 12.62% 14.33% 9.02% 66.71% 67.10% 67.49% 57.85% 66.21% 66.52% 66.099 14.015.000 34.700.000 34,170.000 33^615,000 71.010.000 32.090.000 3t.090.000 3D.035.ODO 28.925.000 27.755.000 26=5,00( 2,56:3,000,000 2.593.000.000 2.644,664000 2,687,757500 2,751,712,344 2.608,748.591 2,662,001,523 2^920,139,153 2.978,541,936 3,038,112,775 3,096,875,03( D.5405% 1.3382% 1.2919% 1.2460% 1.2007% 1.1433% 1.0560% 1.0285% 0.9711% 0.9135% 0.86609. 55.700 65^700 65^703 56,257 56,820 57,388 57,962 58,541 59,121 59,718 60,31:. 25182 62296 BIS. an 597.53 561.49 55916 536.39 513.06 489.20 16477 439.71 CITYOFLODI yu''�.ir' Scerallo A 9.� 7:31';I,rf � �w�>dG;?n.4..7:L --I ..JW Y V 1.'._Il r., li P9 , •j�. I:l�i;F"N '�J'RMY General Fund Flnanala/ AesllmB ons tau af9 5 bl nM 1� Pfan .1 .... I P�oJeMed a 1 �� r *� , slit 1 j J(; " yl ..' 1 .,. Capital lm roveirne CFund .r8aliePMr�oecl swil P p n ;p�l E ; :..,. !., . IA.M ubilcSerela'Coml'le Ffnen,,n L ..., .s., .y w. P .x,.F ng j 1 PI Interest :...;.. Rate (Non-Debt ebt Proceeds): 5.50%,.i Historical- Pro Fiscal Year Ending., 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2008 2007 2008 2009 2010 Total I Beginning Balance 5.099,679 3765,222 3,933588 6,570,152 12,075,629 2,473 2,812,550 1101,929 4,801,651 5,133,333 5,217,994 4,870,426 4,451,707 3,9511,057 3,384,991 2,728,101 1,982,647 74540,935 SOURCES Capital Fund Re- uo 2 Capdat Fund Ravenuo 5,823,8.57 4581,300 11,769,656 25,677,757 19,453,640 6,903,1129 2,108,933 9,802,858 8272,373 10.825,924 4,282,793 4,259,758 4,238,622 4,214,130 4,191,042 4,164,251 4.198,444 142,748,780 3 Total Capital Fund Revenue 5.823,a57 4,561,300 11,769,656 25.677,757 19,453,648 6,903,629 2,106,911 9,002,658 8272,373 18,825,924 4,282,793 4,259,750 4,236,822 4,214,130 4,191,042 4,164,251 4,198,444 142,748,700 4 Total Sources 5,623,857 4,561,300 11.769.858 25,677.757 19.453,648 6,903,628 2;108,933 9,802,856 8.272,373 18,825,924 4282,793 4259,758 4238,622 4,214,130 4,191,042 4,1&1,251 4,198,444 142,748,760 USES Capital Requirements 5 General Govemment 8,007 8.007 6 Public Works 71,670 71,670 7 Geninal Fund Requirements 804,592 1,027,953 4,389,642 9,987,944 15,339,532 2,732,058 2,344,900 4,553,000 6.813.125 16,777,064 1,600,900 1,6211,540 1,852,8311 1,679,782 1,707.402 1,735,712 1,764,729 77,337,655 e RDA Requirements 0 9 Total Cap Bal Requirements 884.289 1,827,953 4,389,642 9,987,944 15.339,532 2,732,058 2,344,900 4,553,000 8,813,125 16,777,000 1A00,900 1,626,548 1,652,1138 1,079,782 1,707,402 1,735,712 1,764,729 77,417,332 Transfers Out Operating transfer$ out 10 Cost of Services Transactions 0 11 General Fund O 12 Equipment 8 Replacement 455.443 100.000 300,000 300,000 400,000 100,000 400.000 400.000 400.000 400.000 400,000 400.000 400.000 6,055143 13 Ottler 5,868,885 2,220,702 4243,245 9245,469 11,972,730 1,952,445 35,503,476 14 Taal Operating famsfars out 5,8611,885 2,220,702 4243,245 9245,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 Feas to General Fund 15 Fire 0 16 Police 0 17 Parka 6 Recreation 50,000 50,000 50,000 50.000 50,000 50,000 50,000 350,000 IB General City F8cif6ies 0 19 Subtotal Impact Fees to General Fund 0 0 0 0 0 0 50"M50-000 54000 50000 50'000 50 000 50 000 95000 0 15 Transfer to Pay Debi Service 405,160 345,498 500203 930,867 1280,371 1282,309 1,2112,301 1237,234 1,185,727 1,948,924 2,058,8932.M.210 2,864785 2,659,355 2,850,640 2,1153539 2,850,714 30,320,734 20 Total Transfers Out 6274,045 2,568200 4,743,448 10,184,336 13,716,544 3,634,754 1,582,301 1,537234 1585,727 2248,924 3,304893 3,308,210 3,310,785 3,309,355 3,308,640 3,303,639 3,308,714 71229,653 21 Total Uses 7,158,314 4,394J53 9,133,090 20,172280 29.056,076 8,356,012 3,927,201 6,090,234 8 ,052 19.025924 4AD7793 4,934,76a 4,963,622 4 138 5,016,042 6,034251 5,073,444 140,646,984 22 Additionally Required Revenues 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 FUND BALANCE 23 Begn.,g Balance 5,099,679 3,785,222 3,933,588 6,570,152 12A75,629 2,473200 2,812,550 1,101,929 4,981,851 5.133,333 5217,984 4,870,426 4,451,767 3,954057 3,364,991 2,726,101 1,982,647 24 Estimated Investment Earnings 107,648 187,298 278,162 284,881 277.432 258,381 231.271 2111,934 168,110 129,546 87,3116 2,189,009 25 Residual equity transfer "out) (197,488) (197.468) 26 Excess/(Dericiency) Of Sources over lurider) Uses (1,334,457) 167,147 2,638,588 5,505,477 (9.802,428) 538,817 (1.810.288) 3,712,423 (126,480) (200,000) (625A00) (675,000) (725A00) (775,000) (825,000) (875.000) (875,000) (5,894204) 27 Restatements 1217 1.217 20 Ending Balance 3,765,222 3,933,588 0,570,152 12.075.629 2,473,200 2,012,550 1,101,029 4,981,651 5,133,333 5217,994 4,870,426 4,451,787 3.958.057 3,3114,991 2,728,101 1,982,647 1,195,033 PREPARED 9Y PUBLIC FINANCIAL AfANAGEMENr ING - - 1r23/00 7:83 PM General Fund (Scencylo k-SerlsiNl\?) rt1 slx'(LAIM!tIwOS-YOIl0ue�5> p.1n91OLaIIeg 'DON 1N31Y3UVNVW IVIONVA9d 0116nd A903UVd3Nd f aauelegP.4set ewsdss- w11tow 4la1sue119w9.9uosapn15u1It) 460'09 %ZS'99 %I3'89 %59'49 %6►'L9 %Ot'L9 X11'99 %Ewe %CC'►1 %Z9ZL %09'09 %1919& %Z9'9 %99'0 %SZ"► anu9nau pund laUde0 to% s ss aalAAS 1900 ZC 9L0'OLS'GZ ►tL'990 6cwtselZ 009'BSV'Z SSE'6S9'Z 984'099'Z Olease'Z C69199a'Z ►Z6'9►8't 4Zt'S9l'l ►CSLEZ'l loclea'l emleZ'l I4C'90CL L99'9C6 COY009 931n1as 19x0 lC 09L'8►L'Z►t ►/5961'► l9Z'►91'11 zwlstt 6611,IZ'► awecZ'► Osees'► C6LZ9l► YZ8'9Z9Bt CLC'ZuS9 959ZOa'6 EEV901Z 8381 9 818'69►'69 LSLLL9'SZ 8S8'69CII we'l ► islo 8'5 antionji pond lall sO Rlol OC 65E'000'SE 0 D 0 0 0 0 0 000'ZSL'L 000'Z19'► 000'699'9 0 0 O Z91'9i:E'Zl 111'610/ 0 0 aaaanOS BulsueuIA Inol BZ aes'aWa Z95'OZ►'Z luawssessy IelaedS to spesdold 99 YN SPOM d PuOW uo 15910101 LZ t[L'659'ZE IN VN VN VN VN VN VN 000'ZSL'L 000'3199 0OW6S9'S VN VN VN 006'196'6 LLl'611'11 YN YN sPOwwd PuOB 9Z tOOl s"JOS IOOZ $"JOS 1003 a9POS 9661 Was See seues SOMOS Gulaueuy ZCCOCE'9L ►1L'9Sa'Z 6CS'CSB'Z 009'80613 SSE'696'L 594'0{0'0 OteRmc £68'90t'E 11ZB'9►l'a 9►Z'608'l "Welel EE6'OC4,t 66998Z'S 9El'lwlt ZIO'sel$l EEC'9Z6'S Sel's►CE ZW101'► ul slnsuul lnol SZ 6LL'69Z'Z► 62w906'C 6OW99t'91 9ZCLl6'Ol LLZ'8S9'► VLWKVZ Z90,101'0 Jam* bZ 0000011 OOO'09 000'001 0001051 00eOOZ OW092 000606 000'OS6 D00'09C 000,09E pund 5p15e13 CZ 0 pund Ripue0 o!lgnd ZZ CS6'GW%V. ►tL'898'Z 6ES'ES9'Z 0/9'949'3 9SC'698'Z Su'a98'Z Olresel E6a'9S9'Z ►Z6,ewt 9►Z'69Yl 969'CZ►'t ECB'99C'L OLZ'9SC't BZC'ZIC'9 PerigZ'1 990'[83'1 ►11119 Lry s»/sued puna laLeueolene00S I p- Ia410 OZ ZOZ'98L'8 E91.'090't ZS6'8L1't 09C'99L't t96'90Z't 6►0'Osvt 090993'1 Lleca'l 961'CSE eolnleS LQo01O1 lejeuvil ASue!5I9nS 61 0 ¢Mmol 10ewtse1Wl 9l ISCZSL'CZ 7.96'LLL'L LOS9CL'l O9Z'Z69't SWIS91 9CCOl9'L OS►'uslt ZZ%'EES't 631'96►'t arrest,I 899'CZ►'l EC6'89C'I DL6'996'l BZ6'ZIE'l b8ZMI 990'19Z'l ►ll'119 xel Auedaid Ll ul w"suell pund pueueO u! s/alsuaL 1691CS n 0 0 0 0 0 0 0 0 D O COVUl SOMI 000'1 99191 0 CSI'►OI eru vy snwuuova "10101 Dl M, MS Ead'ltl 90I'l►Z 000'4 981'►t CSl'10l anuaneU snoeueW5jr4191110 91 0 YOU bL onuanau snosueiladsl►t M1119Z'► DDO'051 DDO'091 000'OSI 000'OSL ODO'OSl 000'OSt ODO'OSl 000'091 000'OSL 0001051 000'091 MCSOZ ZOO'COS lC►'£SL ISZ'Z►E 099'941 6Z►'Lss eLeO:wl JVJUOU 1¢101 CL 000109WL 000'D9l 000'05L 000'051 000'091 000'091 000'09l 000'OSl 000'051 000'051 0001091 000'051 ugtepunOd=)I lumAed•IeL4lp EL aw0oul IB1u8Il ZE9'CZL'SZ Gtt'6at't ZLL'09l'L WEE l'1 ZaL90l't 9C9'4LO'1 9a93SO'l 006'SZO'I 000'SLL'9 931'I0L't OCWODO'Z 0 OW ELI'1 ZZL'95a 301'00► 6C019t ZSZ'C►Z't £le'090'l semues AN se&ev WWI t bC0'►►('ll 630601'1 UL'094't WEEVt ZSCtOt'l 9C8'LLO'l BVVIS0't 006'Sa0't 0 SZlloVI 0 0 0 0 0 0 0 saaj loudw/lel.MS OI 8bL'6►9'C Z90,101, ►Zl'L66 8c►'Lec 696'LLC 69L'99C 94L'69C 000'LSE _000'000'3 000'000'I _ 1.119"Maei ARO lemon 6 Ll t'LCS'9 ZtS'SC9 Z10'oZ9 668909 961'069 C►05t5 000195 000'865 9711WL 15f0'ODD't x,Uolleelaeu T Wed 8 9-0'359 061'001 651116 G9C'SG CbO'CI: ►LCOS 094'Oa OW90 05904 L tL9'SOE 996'96 9?9'S► ►OL'►► ►19'0► OSS'a► cWt/ ODS'iW 94d 9 Seed gadwi D00'S[0'6 0 0004teg 00a'00C D O IolaeS 01enPd saalnles JOA saB1e40 645'[!9 0 0 O 0 0 0 0 0 0 000'0ZZ 00063E C16'19 109'69Z 0 0 0 0 SWUenell lnuewwenOBrolul lelOL b 000'06 0 0 0 000'51, 000'S► AL!lan —eS c 000'06 0 0 0 0owst 0001St ARI9n IeteM Z OOO'D9Z 0 0 0 000'0CI 000'0CI Ai!sin oupel3 L sanueney lquawwan061a1W :". > 3NN3A3U ONlid lYlIdYD O{OZ 6009 BOOL LOOZ 9003 s00Z 000E 0003 WE t00Z 0003 666t a661t L669 not S66/ 0661 ulPu3 LaaA 162SU RPNI-d 103110151H I ...4 1N ti!.' I.Irt.ifM 11.-. :.:' ihL ai :M '�U! L ef,T ^'P. 9, .., ° 6ulauau� >I�abwj Rlalas �lgl�d'Ia 1.41IN1 stwlwe(oLd oseg 2nuanad Punj lejldao i,: �I,Ip{JLA 4 IW �` 1. ` J� ..��yp4�� �a1 I�.yy�� ylyy.��gpiqI, j1y,.,. I�;MM%`},'N4'(ilN 'i�!f1:fLlt:�'���A... F:i ° r'h a� .. M /, y' �' Il/+{��',�L.. v 7�"iy . :p_I'^I 'ai '�;F."µ. hF OSa}ediC�,iYa,'P IcLdsainilPuadx3 li ';. 1171 118$x!1 .. ue/d/e►aueutdP,undleJauraD h iYh�Fll nji., t.. •\. i-, I_i, .� :. liPr" SYN%��•'' �"iJ•I 1007 dO K1' 11: i'. : ':`'' VI KV,Y��'II!N"i ':'t';1�7'!A7 ,,.. A�;L4O�M .�y5 /• 1 r I,/;M._ , SIyP�1.Il �.:.- : e16.t F 6f �f n:'F: r .'.. '. 2:11;:1., .«. --': .,:• - r 4r�.: I-,..utF NCITY 05 LODI n,a :'� { R , :p ,:. e k E �:. tt ! 1.'..,-h,E•Ik• .';..:.: i, 14RCr E :..n , Scenatfo `a E lf;...^' . ...._„, a..,: r:"::•- A +.�'-- _I . .1 _ .. Sensitiyiry t{^2 L. .[ k. ¢ C <el ftx �,E:Rr« i drN f-.. I,.r�rf{ LV, F; «r _la t.: i ai E nt t r.r.r ,it Ik4 rS r j RnE .t. ..rrE _ , . -". - ?:... -•.q.. ... .. r.. :';. .. :rrr .,... .' r _.::::.. Gener l;Fund.;Flnanchd Plan �.. ne!r: 'rt. d.•., •, : :;.. ASS1lmbtiFPS ..E:.R..:. :: :::. -_._J �._ r r t,..., 1.:.: Prottected 50% ` { Ek =-, IC aE rl; �ilP'rl+e:.l'f Iry'. yr.r. u i i t! ,. :' ... i .Expenditures 1 a�'.3 " txn ; E 5 .. Capital'Prpj�Cts ;, ;- i l .. .. '.. :. -. ;.• _ ,. ... .... ._.. '- [ ^: ,,BasePloJtactionswith'L'eJelPublic,iSaleryCoInplax.Financing '! _t ^' i �F '.. :-:' n ',« [.^ •rE i...., k4.t ... :17i r r. Fiscal Year Ending: 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 TotalFY2000-2010 GENERAL FUND CAPITAL REOUIREMENTS 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 equip/projects 16,800 33,000 49,800 5 Roof Replacement Fire Station N3 24,100 24,100 6 Misc Police equip/projects 7 Building Renovation 1,659,000 4,000,000 4,612,000 7,752,000 18,023,000 Park & Recreation Facilities 8 Indoor Sports Facility 300.000 8,775,000 9,075,000 9 P & R Administration 500,000 5W.000 10 Park Corporation Yard 901,125 901,125 11 Lodi Lake Beach improviparking 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 60p000 15 Redevelopment Agency 100,000 100,000 16 Records Mgmt software 55,000 30,000 85,000 17 Permit software 18 Subtotal 2,344,900 4,553,000 6,813,125 16,777,000 30,488,025 Additional Capital Projects 19 General Fund 625,000 625,000 625,000 625,000 625,000 625,000 625,000 4,375,000 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 Capital Projects 1,600,900 1,626,548 1,652,836 1,679,782 1,707,402 1,735,712 1,764,729 11,767,909 22 Total General Fund Capital Requirements 2,344,900 4,553,000 6,813,125 16777,000 1,600,900 1,626,548 1,652.0-36 1,679,782 1,707,402 1,735,712 1.764.729_ 42,255,934 RDA CAPITAL REQUIREMENTS 23 Total RDA Capital Requirements 23 Cumulative Total, this period 2,344,900 4,553,000 6,813,125 16,777,000 1,600,900 1,626,548 1,652,836 1,679,782 1,707,402 1,735,712 1,764,729 30488,026 24 Cumulative Total, to date from 2000 2,344,900 6,897,900 13,711,025 30,488,025 32,068,925 33,715473 35,364309 37,048091 38,755,492 40.491,204 42,255,934 PREPARED 4YPUBLIC FINANCIAL MANAGEMENT INC -.03 PM f` (1) Numbers in bold reflect changes from Feb. 8 shirt -sleeve General Fund (ScenarioA-Sens1llv1ty2).xls ry III ry O General ks dflnanclal Plan,' A 3.5046 Assumotlo na r' Expenditures Projected at Equipment k Re plat ement Fund Base ProJediona wlth'Level Public Safety Complex Financing Historical Pr ed Fiscal Year Ending. 1994 1995 1996 1997 1998 1x99 2008 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Total 1 Beginning Balance 2950¢8 351,911 190,213 384,781 533,815 522,068 522068 422,658 318,923 334,947 353,704 373,792 394,932 417,288 440,866 465,800 492,143 6.812,6% 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 Investment ant Rental Income 0 0 00 0 0 0 4 Miscellaneous revenue 0 0 0 0 83,655 0 83 955 5 Total Revenue 0 0 0 D 69,572 O _ 0 0 0 0 0 0 0 0 0 0 0 69,572 Transfers In 6 Operating Transfers In 169,160 244,185 731,839 646,707 0 0 1,811,971 7 Capital Fund Transfers In 455, 443 400,000 300,0 00 300,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 5,055,443 6 Total Transfers In 169,160 244,185 731,639 646,787 455,443 400,000 300,000 300000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 6.807.414 Financing Sources 9 Lease Proceeds 0 0 0 0 0 0 0 10 Total Financing Sources 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 I1 Total Sources 189,160 244,185 731,839 646,787 525,015 400,000 30OA00 300000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 6,936,986 USES Caplial Requirements 12 General Government 1,858 0 0 0 0 O 1,656 13 Capha1 Requirements 130,419 397,641 537,271 464,053 538,762 400,000 399,410 405,735 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 6,871,321 14 Total Capital Requirements 132.275 397.641 537271 464083 538,762 400,OOD 399,410 405,735 400,000 400,000 400,000 40OA00 400000 400,000 400,000 400,000 400,000 6,673,177 Transfers Out IS Operating transfers out 0 8,242 0 33,670 0 0 41,912 16 Transfer for Lease Payments 0 0 0a 0 0 0 O O 0 0 0 O 0 0 0 0 0 17 Total Transfers Out 0 8,242 0 33,670 0 0 41,912 18 Total Uses 132,275 405,883 637,271 497,753 536,782 400,0001 398,410 405,735 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 400,000 6.915.0091 1 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 Begkwv Bolivia& 295,026 351,911 190213 384,781 533,915 522,088 622,068 422,658 316,923 334,847 353,764 373.792 394,932 417288 410,986 46SAW 492,143 0,812,896 21 Estimated Investment Eamings 17,924 18.37 20AN 21,140 22,336 23,598 24.33 26.343 27,833 203,054 22 Residual equity transfer W(out) 0 23 Excessf(Defglancy) of Sources orw(under) Uses 56.885 (181,698) 194,568 149,034 (11,747) 0 (99,410) (105.735) 0 0 0 0 O 0 0 0 0 21,897 24 Restalemems 0 26 Ending Balance 351,911 190.213 384,781 533,815 522,068 522,068 422,658 316,923 334,847 353,784 373,792 394,932 417X. 440,858 465.00 492,143 619.77 7.037,546 27 % Ending Balance of Annual Expenditures 268.04% 46.86% 71.82% 107.24% 97.26% 130.52% 105.62% 76.11% 83.71% 88.45% 93.45% 98.73% 104.32% 110.22% 116.45% 123.04% 129.99% PREPARED BY PUBLIC FINANCIAL MANAGEMENT, INC. 2!23/00 T:03 PM Gu,mud Fund (SCBnabA•Sensilivily2).ds CITY OF L061! Scenario SenaltivltyO2 General Fund FlaBRcla/ Plan Assumptions - Expend((uras Projected at 3 tiOX % Escalation Rates (1/6) Base Projections with Level Public Safely Complex Financing AW RINa1ca1 W rW F74e11 Year Ending: 19951899 1995 1996 1997 11,118 1199 2000 2001 2002 2003 2004 2035 1006 2007 2000 2009 2010 Te1al 1 Bpinnlrlg 11a1ance SOURCES OF FUNDS Neve wee Taxes 2 Prupony Tax (181%) (1763%) 3.59% 0.03% 3.55% 3,25% 2.50% 2.50% 2.W% 2.50% 2.W% 2.50% 250% 2.50% 250% 2.50% 2.50% 3 Sales B Uca Tax 4.117% (0 10%) 10.49% 3.25% 4.28% 6.74% 3.75% 3.75% 3.75% 3.75% 3.75% 3.75% 375% 3.75% 3.75% 375% 375% 4Pudic Safely Sales Tax(Prap 172) 1295% 5166% 347% 0.41% 1653% 0.11% 3.75% 3.75% 3.75% 3.75% 3.75% 3.75% 3.75% 375% 3,75% 3.75% 3,75% 5 Transit WlOing Tax 436% 072% 11.92% (10.34%) 11.55% 9.90'% 436% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4,36% 4.36% 4.36% 6 Waste R-al FrarryiiSO Tax 2.76% 196% (4,14%) 6.25% 6,23% 1.95% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 276% 2.76% 2.76% 2.76% 7 Induawial Fmnchse 546% (10.54%) 404% 10.12% 12.16% 13.60% 546% 5.46% 5.46% 5.46% 5.46% 546% 846% 546% 546% 546% 546% 8 Gas F-4N. 3.41% 046% (0 S8%) (3.65%) 16.66% 5.63% 3,41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 341% 3.41% 341% 9 Cade TV FrancNso 6.88% (368%) 605% 6,41% 15,99% 10.63% 6arx 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6009% 600% 6.00% 603% 10 E)W. FancNse 099% (2.48%) 2.50% 223% 4.16% (1.33%) 0.99% 0.99% 0.99% 0.99% 0.99% 0.99% 0.99% 0.99% 0.99% %99% 0.99% II InW FXcNsa-F3echic 584% 2925% 036% (2.13%) 5.05% (0.40%) 190% 1.00% 1.00% 1.00% 1.00% 1.OD% 1.00% 1.00% 1100% 1,DD% I.00% 12 ln-Lleu FI-this. -Sewer 15.44% 5818% 1343% 4.13% (4.22%) 14.56% I.00% 1.00% 1.00% 1.00% 1.00% 100% 100% 100% 1.00% 1.00% 100% 13 In-Li9u Ranch.-Wa1er (559%) (29.15%) 295% (0.96%) 4.09% (0.38%) I.00% 1.00% I.OD% 1,00% 1.00% 1.00% 1.OD% 1.00% 1.00% 1.00% 1.00% 14 Roal Prglany Tranzler Tar -_ --- 11.80% (056%) 1054% (12.42X) 17.90% 53.87%5_.00% 500% 5.00% 5.00% 5.00% 5.00% 5.00% 800%500% 5.00% 5.00% 15 Tota/T- 3.10% 077% 5.42% 0.65% 4.43% 431% - - - -- I6 ficanses wA parries 20 12% 25.16% 3286% 20.20% 16.61% 7.10% 6 00% 6D0% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6. Inlergwerrarenlalrev- 17 A4csa Vehi9e license Fao 3.79% 7.32% 895% 5,92% (220%) 2.25% 3.79% 3.79% 379% 3.79% 3.79% 3.79% 3.79% 3.79% 3,79% 379% 3. Ili Other 141% 7612% (46.90%) 105.87% (3064%) (19.68%) 1.41% 1.41% 1.41% 1,41% 1.41% 1.41% 141% 1.41% 1.41% 141% 1.41% _ 19 Trial Mhugo-w-lal revenues 3.38% 19.71% (8.05%) 21.21% (9.59%) (2.12%) 20 Charges la services 1496% (35.22%) 127.91% 9.13% 20.59% 431% 6.00% 6.00% 6.00% 6,00% 6.00% 6.OD% 600% COD% 6.OD% 600% 6.00% 21 Fines, fonelz&W penaWn 16.62% (0.33%) 3.74% 7.54% 4618% 32.71% 8.00% 800% 8.00% 8.00% 8.00% 6.00% 8.00% 8.00% 800% 8.00% 9.00% 22 Rental1m 2.18% (67.29%) 14374% (6106%) 117.80% 6473% 800% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 600% 600% ' 23 Estimatatl lrwet-1 E-g. 991% 1220% (5469L) (50.47%) 49.13% 104.72% (20.36%) 000% (12.5091 0.00% O.OD% 0.00% 0.00% 0.00% 000% 0.00% 0.00'1 24 MiscaAanopus revenra (468%) 42.75% (7.93%) (35.10%) 44.59% (36.66%) 000% 000% 0.00% 0.00% 0.00% D.OD% 0.00% 0.00% 0.00% 0.00% 0.00% 25 Oder Sources O.OD% 0.00% 0.00% 0.00% O.OD% 0.00% 0.00% 9.70% (2736%) 1,00% I.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00"% 26 Transfers In (143%) 07.13%) (0.78%) 20,50% 3.19% (897%) (5.19%) 0,65% 350% 3.50% 350% 3.5096 3.50% 3.50% 3.50% 3.50% 3.50% 27 SubQAal Revenues 360% 1.32% 6.76% 5.56% 4.97% 116% 462% 3011% 220% 3.26% 331% 3.34% 3.37% 3.40% 3.43% 346% 3.49% 323% USES OF FUNDS Exac"Itures Butl et Bud p Metl Currant 28 Gawal goverrvrem 11.12% (1.56%) 8.17% 12.74% 20.11% 242% 9.11% 1.65% 3.50% 3.50% 3.50% 3.50% 3.50% 3.5096 3.50% 350% 3.50% 29 Pudic protection 2.23% 3.37% (1.29%) 8.00% (2,01%) 33D% 4.96% 140% 3.50% 3,50% 3.50% 3.50% 360% 3.50% 3.50% 3.50% 350% 30 Pudic vmhs 3.06% 17.16%) 1926% 1801% (9.93%) 1.37% (1049%) 4.44% 3M 3.50% 3.50% 3.50% 3.50% 3.60% 3.50% 3.50% 3.50% 31 Lerary 3.16% 6.49% (023%) 6.10% (4.59X) 6.63% 4.26% 1.16% 3.50% 3.50% 350% 3.60% 3.50% 3.50% 3.50% 350% 3.W% 32 Paha and 1=8611. (068%) (0.35%) (442%) $22)6 (6.00%) 2.60% 16.44% 3.35% 3.50% 3,50% 3.5D% 3.50% 350% 3.50% 3.50% 3,50% 3.50% 33 Outer M" 000% 0.00% 0.00% 000% 0.00% 0.00% 000% (100.00%) 0.00% 0.00% 0.00% 000% O.OD% 0.00% 0.00% 0.00% O.OD% Tranalers Out 34 Public Satrrty Corrplex Finercng 0.00% 0.00% 0.01196 0.00% 0.00% 0.00% O.OD% O.OD% 109.65% (687.67%) 175.77% 0.17% 006% 10.01%) (010%) 0.13% 003% 35 Olhar 1042% 38.90% 52-90% 12D.66% 16.79% 1657% 18.90% 3.95% 4.05% 12.61% 0.04% 007% 0.07% (0.07%) 0.04% 0.76%) 0.25% 36 Tnlel Transfers Out 10.42% 38.90% 52.90% (20.66%) 1679% (16.57%) (18.90%) 1.69% 1.70% 18.31% 40,02% 0.04% 007% (0.04%) (0.02%) (0.14%) 0.15% 34 SLOWalE S 406% 2.76% 820% 6924% 2.61% 0.72% 3.02% 1.38% 3.37% 4.52% 6.34% 3.151% 3.16% 3.16% 3.17% 3.17% 3.21% 3.46% PREPARED BYPUBLIC F9VANCIAL NANAGEAIENT INC. 203MO 7.03 PN eourca* s=ay a - Gr of Fund (SCer10lI0A•San91a41Y2).A6 1 CITYOFLODI il'' 'll - GBRBTBI Fu nd FJnanclel Plan Eseala&l Ralai �---� 1 I Scarfed. �SensiUvlt I� : � 11Pendhgrei PFo egad et asox AssumptionsE Base Projections with Leval Public Sefet Complex Financia Y P 9l 1 d I�,I� I; dil'11 II�li1 UIiI1 1jl J( tp IlIi .ip)I A� il� 1 •ly1li�ilp�� ��, li i t ljl, Il �I I I II°1l IIS N 1 Ill Irl I ;IIS l iJ 1.,•r. l: ..liar. . .. - ,p A-9, Historical protected Fiscal year EOdkV: 1915.1999 1999 19 1997 1196 1999 2000 2001 2002 2a03 2004 2005 2006 2007 2008 2009 2010 Total 1 94O1Meng Balance96 ' SOURCES OF FUNDS Re.m22 Taxes 2 Prrpsdy Tax (86.611) (872,904) 146,909 1,089 149,685 t42566 0 0 0 0 0 0 0 0 0 0 0 3 Sales 8 Usa Tax 280,519 (5,132) 546,996 187.524 254,679 418,526 0 0 0 0 0 0 0 0 0 0 0 4 Public Safety Sales Tax (Pray 172) 16,422 50,598 5,157 635 25,515 205 0 0 0 0 0 0 0 0 0 0 0 5 7,.,Looting Tax 11,737 1,781 29.364 (26,722) 20,755 27,506 0 0 0 0 0 0 0 0 0 0 0 6 Waste Removal Franchise Tax 7,164 4,819 (10,365) 14,992 20,995 5.377 0 0 0 0 0 0 0 0 0 0 0 7 Ircirebial F.,.hse 1,508 (2,608) 894 21330 3,084 1939 O 0 0 0 0 0 0 0 0 0 0 6 Gas Franchise 3,958 496 (955) (3.950) 17,353 6,841 0 0 0 0 0 0 0 0 0 0 0 9 Cads TV Franchise 9.319 (4,342) 6,874 1.729 20.515 15,816 0 0 0 0 0 0 D 0 0 0 0 10 Electric: Franchise 111 (272) 268 245 467 (155) 0 0 0 0 0 0 0 0 0 0 0 11 In-Ueu Fra rd ism, - Foam. 23.009 941,310 14,800 (89,000) 206,267 (17,020) 0 0 0 0 0 0 0 0 0 O 0 12 In.Usu Franchise • S.-, 36,042 224,000 SIAM 26.500 (30,380) 100,292 0 0 0 0 0 0 0 0 0 0 0 13 to-Lleu Franchise• Water 6,208 (218,600) 15,700 (4,700) 22.162 (2,122) 0 0 0 0 0 0 0 0 0 0 0 14 Real property Transfer Tax 10,173 (3a2) 7,144 (91305) 11,743 41,667 0 0 0 0 0 0 0 0 O 0 0 _ 15 loW Taxes 506899 118.764 844,185 107,367 731,040 743.136 16 Lkerwas and perm t, 152.020 127,431 209.334 170.123 170,192 84,020 0 0 0 0 0 0 0 0 0 0 0 Inifigp wnrroNal menu 17 Moto, Vehicle License Fee 77.049 138,010 120,316 126.916 (49.905) Al 0 0 0 0 0 0 0 0 O 0 0 18 Other 6.003 315,065 (341.914 409.791 (244.135 (108,7641 0 0 0 0 0 0 0 0 0 0 0 19 Tolallnlerywermia revenues Ill 453,075 (221,598) 536.707 (294.040) (58.884) 0 0 0 0 0 0 0 0 O o 0 20 Chart es for services 131,271 (229,279) 539.439 78.129 214,013 54.053 0 0 0 0 0 0 0 0 0 O 0 21 Fines,Mdeasanopenaft- 94,215 (1,350) 15,165 31.734 209.- 216,462 0 0 0 0 0 0 0 0 O 0 0 22 Ramal ba:Onr 2,914 (85560) 60,047 162.1751 44736 55,914 0 0 0 0 D 0 0 0 O 0 0 23 Eau.md I-Sauh&. Earnings 37,618 36.197 (19,198) (167.640) 50,625 256905 0 0 0 0 0 0 0 0 O 0 0 24 I4isvalanachhs raveMb (9,059) 39142 (10,363) t42245) 34,BZ'2 141.623) D O 0 0 0 0 0 O O 0 0 25 Other S-- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O 0 26 Trarislam In (63,258) (7B1,t38) 12450D) 768.919 144,180 (414453) 0 0 0 0 0 0 0 0 0 0 0 27 ,S,&.1al Raverruas 942,678 (321.4061 1,386,511 1,420,919 1,336,834 091,532 USES OF FUNDS EaOyres Bdost BulaillW 6.59,597 130,335 0 0 0 0 0 0 O 0 0 28 Oerora1 OO+4..M 467,992 (76,2521 394-20 664.771 1.186,% 52 2 170,5 29 Fh49p pmlactim 231,429 334,942 (132,052) 519.937 (220,487) 354,004 552,533 1640800 0 0 0 0 0 O 0 O 30 Pubis: vx>nm 12"88 (279,792) 698,874 649.360 (493.954) 61,452 (476.745) 180,615 0 0 0 0 0 0 O O 0 31 Lrbnry 29,679 74,846 (2233) 54222 (46,503) 64,053 44,116 12,500 0 0 0 0 It 0 O 0 0 32 Parks and reaealion (15,425) (8.176) (101,557) 114,765 (138,734) 58,586 366,602 07,010 0 0 0 0 0 0 O a 0 33 Other Uses 0 0 0 0 0 0 2O0OOO (200,000)0 0 0 0 0 0 0 0 0 Therefore out 34 PuM Safety Casplex Financing 0 0 0 0 0 0 0 (44508) 0 0 0 0 0 0 0 0 0 the 35 Or 198,438 601.355 1,135,963 (678.273) 437299 (504,154 479,857 51231 0 0 0 0 0 0 0 0 0 36 Trial TAInst"Of$ 198,438 801,355 1,135,963 (678273) 437,299 (501,151) (179,057] 34,723 0 0 0 0 0 0 0 0 0 34 5'rdr#alE rhderaes 1039,301 644923 1. 194 1,628,782 723,973 203.635 886.246 405 PREPARED BY PUBLIC BNANCIAL MANAGEMENT M - 2/134107:87 that Source: "Y a tom Geared Fund ds CITY OF w6l 1Swnai/o A sensit/dry z General Fund Financial Plan Assumptions-Ezpendltures Projected at 3.50%-1:!!:;,.!" General Fund Transfers Ini(Gut) Base Projections with Lew Public Safety Complex Financing Escalation Rales (%) AvYa Mlalorkal Budged I Budgad I project" Fi-Naar E..V.g: 1995-1999 1995 1996 1997 1999 1999 2000 20111 2002 2007 2004 2805 am 200? 2006 2009 2010 Total TRANSFERSIN Ow.0.9 Translera In t Cost d Services Transacliuns 4.20% 0.00% 0.00% 0.00% 5.58% 0.00% 13.30% 0.86% 2 Stool Fwd-pas tax to .11-t strain main% 8.95% 45.91% 000% 2.87% 229% 0,00% 2.18% 0.00% 3 Omer (31.39%) (27.42%) (104%) (60.84%) (8.029) (41.24%) (100.00%) 0.00% 3.50% 3.50% 350% 3.50% 3.50% 3.50% 3.W% 350% 350% 4 Total OpmaUn9 Trulstas In (t.43%) (17.13%) (0.78%) 20.50% 3,19% (8.97%) (5.19%1 0.65% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 350% 3.50% 5 Total Translera In 1.43% 17.13% 0.78% 20.50% 3.19% 8.97% 5.19% 0.65% 350% 3.50% 3.50% 3.50% 1S0% 3.50% 3.50% 350% 3.50% TRANSFERS OUT Ol-0.9 Tmnsttta Out 6 Opmerinp Trartslors 0.1 c00% 0.00% 000'%. 0.00% 000% 000% 0.00% 000% 7 Bene6la Fund 000% 0.00°6. 000% 0.00% OOD% 0.00% ODD% 0.00% 9 Insu.-Fwds 000% 0.00% 0OD% 000% 000% 000% 0.00% 0.00% 9 Other (5.23%) (063%) 3124% (33.65%) 29.32% (3168%) 1100.00%) 0.00% 000% OW% 000% 0.00% 0.OD% 0.00% 0.00% 0.00% 000% 10 Total Operafin9 Translera Out (5.23%) (067%) 31 24% (3365%) 29.32% (31.68%) (43.36%) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.0096 0.00% 0.00% 0.00% Tranal4ts Out to Caplial Prolecls Fund 11 Propany Tax 229% 0.00% 107.34% 0.02% 3.5S% 3.35% 2.41% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 250% 2.50% 12 Invowned lnxxne O.OD% 0.00% 0.00% 000% 0.001% 0.00% 0.00% 0.00% 000% 0.00% 0.00% 0.00% 0.00% 000% 0.00% 0001%, 000% 13 Sullicienry Tiamler lot Dot4 Service 0.00% 0.00% 000% 0.00% OW% OOD% 000% 0.00% 0.00% 0.00% 274.60% (2.80%) (2.859) (334%) (3.47%) (4.06%) (341%) 14 Other-Genal Fund Capital 0.00%. 000% 0.00% 0.00% 0.00% 000% 000% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% DAO% 0.00% 15 Total Translera Out to Capital Prolecls Fund 2.29% 0.00% 107.34% 002% 3.55% 3.35% 2.41% 2.50% 2.50% 26.70% 64.52% 0.06% 0.09% (0.05%) (0.03%) (O.la%) 0.18% Translera Out to LWery Fond 16 Pr.perly Tax 0.00% 0.00% 000% 0.00% 0.00% 000% 0.00% 6.00% 000% 0.OD% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 17 Total Translera Out to LWary Fund 0.00% 0.00% 0.00% 0.00% 0.00% 0.DD% 0.00% 0.00% 0.00% 0.00% 0.00% 0.OD% 0.00% 0.00% 0.00% 0.00% 0.00% 18 Total Transitus Out 10.42% 36.90% 5290% 20.66% 15.79% 16.57% 18.90% 1.69% 1.70% 18.31% 40.02% 0.04% 0.07% 0.04% 0.02% (014%) 0.15% 19 TOTAL TRANSFERS IWOIIT 1076% 45.96% 7t.39% 309.90% 15.31% 5. ISM% 044% 5.42% 11,77% 47.01% 1615% 14.29% 1326% 12.06% 1111% 10.02% OTHER SOURCES USES 20 Other Sources 0.00% 0.03% 0.00% 0.00% 0.00% 0.00% 0.00% 9.70% (27.38%) 100% 100% 1.00% 1.00% 1.00% t00% 1.00% 1.00% 21 Omar Uses 22 Wd-Marupetnenl Survey 0.00% 0.00% 000% 0.00% 0.00% 0.00% 0.00% (100.00%) 0.00% 000% 0.00% 0.00% 000% 0.00% 0.0096 000% 000% 23 Total Other Uses 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% (100.110%) 0.00% 0.00% 000% 0.00% 000% 000% 0.00% 0.Oo% 0.00% 24 TOTALOTHER SOURCES USES 0.D0% 0.00% OOD% 0.00% 0.00% 0.00% 0.00% 42.16% 27.38% t.00% 1.00% 1.OD% I.OD% 1.00% 1.00% 1.00% 1.0096 PREPARED BY PUBL)C FMNCLIL MANAGEMENT, /NC. 2123M 7:07 Pal Source: City d Lod GOJ FunO (Scer0*A•SWwlMty2).ea RESOLUTION NO. 2000-43 A RESOLUTION OF THE LODI CITY COUNCIL APPROVING THE REVENUE AND EXPENDITURE ASSUMPTIONS AS OUTLINED IN THE GENERAL FUND CASHFLOW MODEL CREATED BY PUBLIC FINANCIAL MANAGEMENT, AND FURTHER AUTHORIZING THE CHANGE OF REVENUE ESTIMATES FOR THE 1999-01 FINANCIAL PLAN AND BUDGET -------------------------------------------------------------------- -------------------------------------------------------------------- WHEREAS, creation of a long range financial funding model was one of the major City projects outlined in the 1999-2001 Financial Plan and Budget adopted by the City Council; and WHEREAS, to assist in the completion of this goal, the City hired Alex Burnett from Public Financial Management (PFM) as the City's financial advisor; and WHEREAS, PFM's scope of duties included the creation of a cashfiow model of the City's General Fund, the assessment of the viability of the public safety building project on a pay-as-you-go basis, and the assessment of the impact on the General Fund balance of any structuring alternative for the public safety complex financing; and WHEREAS, staff is recommending that Council approve the revenue and expenditure assumptions as outlined in the General Fund Cashflow model created by PFM, and further recommends that the Council authorize the change of revenue estimates for the 1999-01 Financial Plan and Budget to reflect the revenue assumptions in the cashflow model. BE IT RESOLVED, that the Lodi City Council hereby approves the revenue and expenditure assumptions as outlined in the General Fund Cashflow model created by PFM, and further authorizes the change of revenue estimates for the 1999-01 Financial Plan and Budget to reflect the revenue assumptions in the cashflow model. Dated: March 30, 2000 ---------------------------------------- ---------------------------------------- I hereby certify that Resolution No. 2000-43 was passed and adopted by the City Council of the City of Lodi in a special meeting held March 30, 2000, by the following vote: AYES: COUNCIL MEMBERS — Land, Nakanishi, Pennino and Mann (Mayor) NOES: COUNCIL MEMBERS — Hitchcock ABSENT: COUNCIL MEMBERS — None ABSTAIN: COUNCIL MEMBERS — None #ity M. REI CH rk 2000-43