The URL can be used to link to this page

Home My WebLink About28. 19-640 DECEMBER 10, 2019 19-640 RESOLUTION (CARRIED__7-0_____LOST________LAID OVER________WITHDRAWN________) PURPOSE: ESTABLISH 2020 STORM WATER UTILITY RATE TO $196.92 / ERU INITIATED BY: DEPARTMENT OF PUBLIC WORKS WHEREAS, the City of Oshkosh has previously established a Storm Water Utility; and WHEREAS, Section 14-4 (B)(2) of the Oshkosh Municipal Code gives the Common Council authority to establish the Equivalent Runoff Unit (ERU) charge for the Utility. NOW, THEREFORE, BE IT RESOLVED by the Common Council of the City of Oshkosh that the Equivalent Runoff Unit (ERU) charge for 2020 shall be $196.92/ERU. BE IT FURTHER RESOLVED that the appropriate City officials are hereby authorized and directed to take those steps necessary to implement this charge to become effective for services provided on and after April 1, 2020. MEMORANDUM TO: Honorable Mayor and Members of the Com ncil FROM: James Rabe, Director of Public Works DATE: December 5, 2019 RE: Establish 2020 Storm Water Utility Rate to $ 196.92 / ERU BACKGROUND The City of Oshkosh (City) implemented a Storm Water Utility in 2003 to fund improvements to the City's storm water management facilities. Based on the initial Storm Water Utility study completed in September of 2002, the Common Council implemented a phased introduction of the rates. The rate was initially set at $19.10 per Equivalent Runoff Unit (ERU) per year for one half of 2003. There have been periodic subsequent rate increases, the most recent being to $184.08 per ERU per year in 2019. The Storm Water Utility has funded several major projects to date, including the Fair Acres Area Detention Basin, Anchorage Channel Construction, the Baldwin Avenue Area Dry Detention Basin, the Tipler School Area Dry Detention Basin, the North High School Area Wet Detention Basin, the Oakwood Road Wet Detention Basin, the Melvin Avenue Storm Water Pump Station, the Westhaven Clubhouse Area Wet Detention Basin, the James Road Area Detention Basin, the City Hall Underground Detention and parking lot project, the Armory Area Wet Detention Basin, the 9th & Washburn Area Wet Detention Basin, the Fernau Watershed North Main Street Area Wet Detention Basin, the South Park Lagoon Retrofit, and the Libbey / Nicolet Watershed North Main Street Area Detention Basin. In addition to these major projects, storm sewers are replaced/upgraded with each street reconstruction project. The City experienced significant flooding during rain storms in 1990, 1993, 1996, 1999, 2001, 2004, 2008, 2010, and 2012. Localized areas also flood during smaller storm events. In addition, the City is regulated under a Municipal Separate Storm Sewer System (MS4) permit from the Wisconsin Department of Natural Resources (WDNR), as mandated by the Federal Clean Water Act, for discharge of storm water to local water bodies. This permit requires the implementation of practices to reduce the amount of pollutants entering lakes and rivers. The largest expense item in the permit is reducing the Total Suspended Solids (TSS) generated by the City as a whole by 20% in 2008 and previous requirement for a reduction of 40% by 2013. The City of Oshkosh has met the 20% goal. The State Legislature has since removed the 40% TSS reduction requirement. The Federal Environmental Protection Agency (EPA), in conjunction with the WDNR, is currently developing targeted performance standards that are anticipated to require TSS reduction of 40% or more and phosphorus reduction of in excess of 80%. It is anticipated these targeted performance standards will be implemented in the next couple of years. 1:\Engineering\Tracy Taylor\Memos to Mayor&Common Council \2019\2020 SWU RateMemo_12-5- Page 1 of 2 19.docx AECOM was hired by the City to develop a City-wide plan for pollution reduction. The City has also completed several flood studies and is currently studying several watersheds to develop plans to reduce flooding in combination with pollution control. City staff, based on information from all studies, developed a schedule of work needed to reduce flooding and implement pollution control measures. The schedule calls for one (1) to two (2) major projects to be constructed per year, with an emphasis on flood control. Wherever possible, pollution control measures will be implemented with flood control measures. ANALYSIS The City has worked with Ehlers (Financial Consultant) to perform a rate analysis to provide funding to implement the projects outlined in the schedule, to implement other Capital Improvement Projects, and to fund operational costs. In order to support these activities, a rate of $196.92 per ERU per year ($16.41 per ERU per month) is recommended. This rate will allow the City to complete all of the projects listed in the 2020 Capital Improvement Program (CIP) — Storm Sewer Section, and also maintain daily operations. The rate is proposed to be in effect on April 1, 2020. The Utility must retain adequate reserves to maintain favorable bond ratings and meet the operating needs of the Utility. In the event grants or other monies are secured at more favorable rates than anticipated in the study, the rate increases for future years can be offset. The intent is to review the rate annually to incorporate actual construction costs from the previous year and incorporate other funds that become available to the Utility. FISCAL IMPACT The rate of $196.92 per ERU per year is required to implement all of the projects and operations in the 2020 budgets. Reduction of the rate would result in the delay of other proposed projects within the CIP. Pushing projects to future years will result in less reduction of flooding during significant rain events prior to project completion and will delay implementation of water quality improvements. RECOMMENDATIONS The Department of Public Works and Finance Department staff recommend a rate increase to $196.92 per ERU per year ($16.41 per ERU per month) to fund all activities in the approved 2020 budgets. It is recommended the rate go into effect on April 1, 2020. The effect of the increase in April equates to a total cost of $193.71 per ERU for 2020. Approved: Mark A. Rohloff City Manager JER/tlt 1:\ Engineering\ Tracy Taylor\Memos to Mayor&Common Council\ 2019 \2020 SWU RateMemo_12-5- Page 2 of 2 19.docx FINANCIAL MANAGEMENT PLANNING I � It; Stormwater Utility Long Range Cash Flow Analysis Update For The City of Oshkosh Oshkosh October; 2019 Prepared by Jon Cameron Senior Municipal Advisor g%"EHLERS BUILDING COMMUNITIES IT'S WHAT WE DO mforaehlers inc com , 1 (800) 5529171 www ehlers me com ICity of Oshkosh Storm Water Utility Capital Improvement Implementation Pro ram Note All Costs Reported In 2019 Dollars Descnption 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Comprehensive Streets/Uhlty Improvements $1,918,000 $3,176,000 $2,768,000 $3,856,000 $3,634,000 $3,500,000 $3,500,000 $3,500,000 $3,500,000 $3,500,000 Com rehensiee Streets - New Development 00 $0 $0 $0 $0 $0 $0 $0 $0 $0 Public Infrastructure lm revements-Other Streets $683,000 $240,000 $1,822,000 $225,000 $225,000 $225,000 $225,0001 $225,000 $225,0001 $225,000 Public Infrastructure hu euvements-Other Utdihes $110,000 $50,000 $0 $0 $0 $11 $0 $o $0 $0 Public lnham... tore lm rovements-Stormwater Uhhty $4,574,000 $3,810,000 $6,885,000 $6,775,000 $4,579,000 $7,069,000 $4,950,000 $4,000,000 $6,200,000 $4,100,000 Public Property hnprovements-UhhtV $225,000 $1,000,000 $0 $0 $0 $0 $0 $0 $0 $0 Major Equipment 10 $0 $0 $0 $0 $0 $0 $0 $0 $D Major Equipment - Vehicles $290,000 $0 $0 $319,000 $0 $0 $01 $0 Sol $0 Tax Increment Finanaug (1'0) Distract Improvements $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Capital Budget $7,790,000 $8,276,000 $11,475,000 $11,175,000 $8,438,000 $10,794,000 $8,675,000 $7,725,000 $9,925,000 $7,825,000 Previously Burr.wed Ponds -$1,450,000 Total Opi,.hng Budget $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Yearly Budget $6,340,0001 $8,276,0001 $11,475,0001 $11,175,0001 $8,438,0001 $10,794,000 $8,675,000 $7,725,0001 $9,925,000 $7,825,000 Total Yearly Budget Inflated to Future Yeats Dollars(2%annually) 1 $6,466,800 $8,610,3501 $22,177,3621 $22,096,1791 $9,316,2MI $12,15S,7971 $9,964,8481 $9,051,0691 $11,861,2941 $9,538,631 41 City of Oshkosh, WI Oshkosh Revenue Bond Sizing Worksheet Summands, Stormwoter st-.w , Stomworer srormwate. Stomrwnler 51 -nearer, Stoserrmle. sroamwarer Sm.mwme. FOR DISCUSSION ONLY uamy Revenue Ut0lty Revenue udlh,Revenue UUMORevenue utndy Revenue Dt]Btyxmznue utility Revenue uNBry Revenue a80By Revenue uNOry Revenue Bane.. Bonds Bones Bands Bonds Boras BOND Bone, Bands Bonds 2020 2021 2022 2023 2024 2025 2026 2027 202B 2029 Capital projects Tax-Eaemist Tax-Ecompt Tax -Exempt TanFvempt Tan-Erempt Tax -Exempt T-Enempt Tax -Exempt T-Eaemlrt Taa-Exempt Construction 6,466,800 81610,350 12,1]],362 12,096,179 9,316,234 12,155,]9] 9,964,848 9,051,069 11861,294 9,538,631 Less funds on Hand/Grants Applied (300000) 0.500.000) (7 rM,M) (2,00g000j (2,000,"00) (200000(s) IS a0UM01 (2.000,1100) 12,000,0001 0,1) 1111 st suemul Capital Projects 5,AdE;Aw 6.11oj50 10,1]],362 10,096,179 7,316,234 10,155,]9] 7,9"4 7,051,069 9,161,194 7,53&631 Reserve Fund Adjustments New Reserve Fund Requirement 7,138,155 ],62] 0]1 8.402,946 9,195,229 9,]6],681 10,454,309 11,082,065 11,636,529 12,410,603 12,542,142 Less Current Reser Requirement (6,769,481) (7,168,855) (7627 0]1) (8.402.946) 19.195,229) (9,]0].681) (10 454,309) 111 082,065) (11,636,529) (12,410,603) NO Deposes to Reserve Fund Required 393,374 458,216 775,175 792,283 572,453 686.628 62],]56 554(764 774,075 1311538 Estimated Bauana Eapelues 141,813 152,750 229.600 228,688 174,200 227,963 185,038 169,838 224,138 1]0,]50 Ehlers& Associates (Financial Ad oodual 34140 36,400 47.00 46,90 40,100 46,10 42,00 39,300 46,60 39,40 Chapman & Cutler (Bond Counsel) 14,00 14,00 12,00 17,000 15,00 12.00 15,00 15,00 16,00 15100 paying Agent US Bank it terms 850 850 850 850 850 850 850 850 850 850 Underwriter's Discount@ 1.25% 75,03 84,000 139,750 138,938 10,750 130,313 10,688 97,188 135,688 98,00 Moody's Investors ServlrelRating Fee) 17,50 17 50 25,00 25,00 17,50 25100 17,50 17,50 25,00 17,50 TOTAL TO BE FINANCED 6,0].986 6,]31316 11,182,07 11,11].250 8,02.886 11.070,387 8.]77,642 ],]]5,3]0 10,959.506 aaaaaaaa 7.840.920 Estimated Interest Earrimpi 3 4]]1 ].919) (6.361) (6,310) (4,573) (6,3411 (4,9781 (4 40]) (6,163) 14,]12) Rounding 431 2,503 3,524 4,160 1,06 960 2,336 4,037 1,650 3,792 NET BOND SIZE 6,05.00 6,]30,00 11.180,000 11315,00 8,060,00 ]1(765(700 8,]]5,000 7,))5,000 10,855,00 >,840,000 xmEs: m�ware.e.e m oadmraum,emaximue .wl oar Sandal O. Nrmmmmpveyimenmenr .IrvaM040raee4a br M4aV+a1001i% Prepared by Ehlers 10/10/2019 Leaden in Public Finance File Oshkosh SW Utility Cash Flow Analysis 9-5-19/Storm CIP Sizing ` Schedule of Storm Water Utility Revenue Debt Outstanding Plus Estimated New Issues O.o Y.wuMe �ominnm.xu3ao.Ymnu3n55umm Y....ew.rinimge Vwly Mt&oYrvtlnunNaly Wy W ntlNYO\/Rb MRMn[wo. Prepared by Ehlers 10/10/3019 Leaders in Public Finance File. Oshkosh SW Utility Cash Flow Analysis 9 5 19/51orm CIP Stmdum s�....a5—� u.m.........w s...wv�m..w4.....�....n ortsaeesism.wm.s.+A.......Yw 5[AasxO u.1M— nva— ss«4os znul iswam 41µoA L9®!m 4A9.]IS a1.sAss s.nx. 4Muv x. 1 . m,lA .M4Ass axau3 l.sass . 33uw zA.oso z ass- vm4ux 1x5..61 .s. s I.sx sn.m x iv.�xw] mm Ins. vau ansa is. .s— xxAx 1}]S.ns 4x+m� i .nm nuts .u.s .ms� x11}61 ..ux- 1.M43?s %50,17S 1K ns r e z al eA,s xam A.97111.161IDauv. )M155 2022 Z 41851[ 6[Egel[ esm 1 .s 11 =1 ;]14WY. 4W159 SA.Ptl 1 04)11 ]1440 l.sni RR11. Yb.WI ]14M1 MIO.DY S.1MW usx 1 A41A 1M.Wl 1 us,sn 4x;- In 4m.n1 sly——.i- ]Msse nes 4+55.— nyl1f5 gu 21,16 11y1.5 )}14DM3.N1.13 31;PY 3 M16 355.W1 A6..li 3,IX495 535Jm 1 15H5 365.Pro s 9L195 155A15 I.]]].NS Y4- 1 SSm� -m Klu I.. A45Y ,in,Lu;- 1.5[4- Mlls 4f414 355.tW 1 Na.6i6 3W4W ) .1}H 1.4W 1. 34.]5 LALSY Ys.- 5).us _ ]A]M in,%SAA SAA15 Itl.IW 3 11[15 .104W I . yeJ Ssswv .q. .e. 5 1. .y%s 7.— iIL ]A/51 O.o Y.wuMe �ominnm.xu3ao.Ymnu3n55umm Y....ew.rinimge Vwly Mt&oYrvtlnunNaly Wy W ntlNYO\/Rb MRMn[wo. Prepared by Ehlers 10/10/3019 Leaders in Public Finance File. Oshkosh SW Utility Cash Flow Analysis 9 5 19/51orm CIP Stmdum Schedule of Storm Water Utility Revenue Debt Outstanding Plus Estimated New issues Prepared by Ehlers 10/10/3019 Lenders in Public Finance File Oshkosh SW Utility Cash Flow Analysis 9-5-19/5torm OF Structure 6rgw.efu.,wm. unwsoaneyw nmw65rn wmr uiws 6...... 6..f 6,wwOwm.wwn wM nw... uwnx..ervsuw wuRwo Se.omw f11p65.W ns.m] $)ns.Sm sla.asbva Slid- Y.Nomt 5415Fm ]s m.ov Y,Im.On SblmVwa 1#ntW .]SW ASAM Rune 1. 6n. I3X.N6 . ins. 3Mov YS/w win us. g4MU 36LY xS0,6W 6w.MW ]n{N n;ua us. Sm,s1] nsYw 121— )1401 3)1}w 111. ]M911 N4)5x IIIp55 WJEa Y40Y .65.m1 A3. s .. llL916 assml .. 5149. 61;44 ASPM A4ws vo.m" nAX nien soul . 513/X . )e{u 6R us. ni oua, ]up IT vs. IAM] Al FSS 555�H wuY Mini sisn' 5M4�n wbm 51x� Ini os,W ]Y/61 Ii 3.. n34d iw,w) on- o' . Ss4IXn . IeL611 s�.611 u. .. 15691 111. 111.11)S41Y ]a;¢v w),Ai "In an. nypM 6)5.65 M,SN .M.(M 3m.%6 A4A6 5940E )61.43 n0.w0 161.A6 sl]]os Sas(m IYSm m. wsmi Msmf .6Rw wsm 1u,m. SApF I. 565,m' I. IY,Y] .R.,m] u;v int. ..I. ast. swpn 1116N s)i)n ]6{m )194 ])]RA L4VA Im.YI YSN) I". 156.M1 )LLl 195.151 SW11 u. Mp9Y .6. Iinu 6is.1 A40M Is. 41AY sn. n4M6 w4N] )®fel W.mI .",1 W4m 1XY1 .w,m] Ml}l6 so. ni A5.f0) Sn.OM Ibsn n. SDLwa M151 5]4131 bom 1NM6 6Mw1 .140E un— 5)sni IA11�9 ).sw6 nun AS.uI 66pw 1MJM 514m] 1wH1 6Ma6 usmo 11L]m in. )Ay6 "i. 4111 us Mill .WOq n;41 565 OIm6 1 SMsw N"n" KW 16614 36Y.6W 0S.N1 YLRB 45.fM 1SM1 N;XI )Ron 41. ". n.u. Sp[m nPa Smm] n;m] 6w,w 11.553 In 61s.W .IbM E. ). Sm,Wa ILWSI AL61) ]mpp Iio11 11411 4spb ..imw 141n S5s1A A4ws .ip16 A4016 m 4114 I'W 11 Prepared by Ehlers 10/10/3019 Lenders in Public Finance File Oshkosh SW Utility Cash Flow Analysis 9-5-19/5torm OF Structure L eFHLERS FOR DISCUSSION ONLY Prepared by Ehlers 10/10/3019 Leaders in Public Finanre File Oshkosh SW Utility Cash Flow Analysis 9-5-19/Storm CIP Structure ore, s a. FOR DISCUSSION ONLY Prepared by Ehlers 10/10/3019 Leaders in Public Finanre File Oshkosh SW Utility Cash Flow Analysis 9-5-19/Storm CIP Structure Storm Water Utility Cash Flow Analysis - Projected 2020-2029 City of Oshkosh " `FREERS Discussion Only Audit Estimate Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Revenues Total Revenues from User Rates $9.983,418 $10682257 $11,535,862 $12,343,372 $13,207409 $14131927 $15013410 $15799998 $16,589,998 $17293574 $17985,317 $18568530 Percent Increase to User Rates Required 7.50% 700% 7.00% 7.00% 7.00% 700% 6.00% 500% 5.00% 4.00% 4.00% 3.00% Dollar Amount Increase to Revenues Required $754,759 $698,839 $853,605 $807,510 $864,036 $924,519 $881,483 $786,588 $790,000 $703,576 $691,743 $583,213 Total Other Revenues $2,303,011 $232,300 $138,615 $140,926 $137,577 $138.451 $141048 $144,305 $268,024 $278,365 $288609 $299722 Total Revenues $12286,429 $10,914,557 $11674477 $12484298 $13346985 $14270379 $15154,458_. $15,94,303 $16,856,022 $17,571,939 $18,273,926 $18,868,252 Expenses $6,030,185 $642,973 $360,175 ($773,738) $68,727 $411,138 $640,902 $700,586 $976,662 $965,835 $1,051,526 $1,163,058 Unrestricted Cash Balance. Operating and Maintenance $2172,504 $2,550150 $2,669,300 $2735683 $2803719 $2 873 448 $2,944,914 $3,018,159 $3093,227 $3,170,164 $3249017 $3,329,833 Net Before Debt Service and Capital Expenditures $10,113,925 $8364408 $9,005,177 $9.748,615 $10541,266 $11396,930 $12,209545 $12926,144 $13,764,795 $14401775 $15024909 $15538,419 Debt Service $68,727 $411138 $540,902 $70D,586 $976662 $965,835 $1,051526 $1163058 Balance at end of year $16,480,708 $17,023,681 $17383,856 $16610,118 Existing GO Bond P&I $208,157 $907,397 $895,784 $858,528 $851,224 $579782 $473,599 $457877 11444,490 $431,128 $417466 $17,232 Existing Revenue Bond P&I $6,154,828 $6164038 $6749,218 $6,766,613 $6765,563 $6769,481 $6768822 $6769081 $6,548,175 $6 592 309 $6,580,431 $6620,816 New (2019-2028) Debt Serves P&I $0 $0 $0 $397213 $855752 $1636529 $2426222 $2998600 $3795468 $4412502 $4975486 $5737314 Total Debt Service $6,362,985 $7,071,434 $7,645,001 $6,022353 $8,472,539 $8985792 $9,668,643 $10,225,558 $10788,133 $11,435,939 $11973,383 $12375,362 Cash on Hand/Prior Issue Bond Proceeds/Grants $0 $750,000 $1,000,000 $2500000 $2000.000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2000000 $2000000 Net Annual Cash Flow $6,030,185 $642,973 $360,175 ($773,738) $68,727 $411,138 $640,902 $700,586 $976,662 $965,835 $1,051,526 $1,163,058 Unrestricted Cash Balance. Balance at that of year $16,480,708 $17,023,681 $17,383,856 $16,610,118 $16,678,846 $17,089,984 $17630,886 $18,331,473 $19,308135 $20,273,970 $21,325,496 Net Annual Cash Flax Addition/(subtmction) $642,973 $360,175 ($773738) $68,727 $411138 $540,902 $70D,586 $976662 $965,835 $1,051526 $1163058 Balance at end of year $16,480,708 $17,023,681 $17383,856 $16610,118 $16,678,846 $17.89,964 $17,630,886 $18,331,473 $19,308,135 $20,273,970 $21,325,496 $22.488,554 Prepared by Ehlers T'\Wisaccts\Oshkosh\Financial Planning\Rate Stu, ies\2019 Water Sewer & Storm Cash Flaw Analyins\DraO Workpapers\Oshkosh SW Utility Cash Flow Analysis 9-5-19 Cb YU.4 br4 or.....mr Uu'ElY owmlm. u.nra.m.h.l. 3&,l— •m e.vurNlW-mmraAe Nmm.w4 X-w.r«r«m S E.M+.{mem-Naxlenaw 0 BAMA re�Y ueWn rc W .m Nmmf me r3 gentry +s �*miaw�w n..•m.a 1l penlpf.wne. e CwrerA6malmmrve 30 o.p...mr-smrmwx« 3, .«pg.mry z3 n xx g«xw. mm,n Y.Mrc.Y A xH � Mean E.vlrue [.4xU fre MN I Nereu E. p. mix PevrBN Ceq w ronexrat Arerrnue Ie.M..p rcrnw p.n..aelNn.ww vop..aeA *r.r.Yrgpnl ss goY ggmNpn >] EN�ir« uel4 en `IurW e.mM X1r ErrMry e+M.lYw4 eo9mM«n vYn.w Fill -..a. e.4 ry X... 1 gp � 3 xtircx�nmenam E.i eqW p41 ] BadCreen.n mlOf Pw dq gX Wr.e so rm.e' n.•.m. mb oMeWl 5 mrcp n1 6 M em U'H ml mA Prc ml e— �iamM prca 9451 e u. Yl Y EMIR Cu x4 Yrce.h«rlm. YY Un PnellM c.N Y Y EMIR Pill nt.garruu.um.artiUvapvl4mx11 wrrl KKr1YA«vrlp nNx vEukm§ Y Xw 3 inperaapnalqu46nxalewrxry npenea.wW W 6pr.vYlan.pu IN1tMrcnyNaeaM vnwne MEw.e?NMauaWNnaqF.urcYIPYmryw.rc5ngravwlewNer se.erasr«mG.nhm emMak'd.n wwlyanenwwnrn sw lmMe..n mvauryanssia 10.1,02 Y Xw 3 inperaapnalqu46nxalewrxry npenea.wW W 6pr.vYlan.pu IN1tMrcnyNaeaM vnwne MEw.e?NMauaWNnaqF.urcYIPYmryw.rc5ngravwlewNer se.erasr«mG.nhm emMak'd.n wwlyanenwwnrn sw lmMe..n mvauryanssia City of Oshkosh Storm Water Utility Statement of Projected Coverage G EHLERS Year Operating Revenues Lew Operating Expenses Amount Available for Debt Service Total Existing Revenue Bond P81 Future Revenue Bond P81 Total Debt Service Coverage 2018 12,286429 (2172504) 10113925 5425,832 - 5,425,832 186 2019 10,914557 (2,550150) 8,364408 6,164,038 - 6,164038 136 2020 11 674477 (2 669 300) 9 005 177 6749,218 - 6,749,218 1 33 2021 12,484298 (2735683) 9748615 6766,613 397,213 7,163,825 136 2022 13,344,985 (2 803 719) 10,541 266 6765,563 855 752 7 621 315 1 38 2023 14270,379 (2873448) 11396930 6,769,481 1,636,529 8406010 136 2024 15,154,458 12944914) 12209545 6768,822 2426,222 9,195,044 133 2025 15 944,303 (3 016 159) 12 926144 6,769,081 2 998,600 9 767 681 1 32 2026 16858022 (3093.227) 13764795 6,54$175 3795,468 10,343,643 1.33 2027 17571939 (3170,164) 14401775 6,592,309 4,412,502 11,004,811 1.31 2028 18 273,926 (3249,017) 15 024 909 6,580,431 4 975 486 11 555 917 1.30 2029 18868,252 (3329833) 15538419 6620,816 5,737.314 12,358,130 1.26 Prepared by Ehlers T \Wisacros\Oshkosh\Financial Planning\Rate Studies@019 Water Sewer 8 Storm Cash Flow Analysis\Draft Workpapers\Oshkosh SW Utility Cash Flow Analysis 9-5-19