Loading...
HomeMy WebLinkAbout2024.06.18 PPFD Meeting Handout from K Gardner!a4— �I IS 2-q (��=-►� Pasco Aquatics Operating Costs Current Program Estimated Construction Costs $37;440,000 Total Project Budget $46,840,000 Necessary Bond Amount $4,000,000 Annual Operational Costs $3,000,000 Annual Revenue $2,200,000 Cost Recovery % 73% Annual Sales Tax Proceeds (2026) $4,800,000 Annual Debt Service Cost-$3,313,500 Annual Budget Shortfall-$800,000 PPFD Annual Broadmoor Debt Service-$300,000 Annual Surplus Funds $386,500 c o o 0 0 O f� O M O 0 C 0 CO U.) M r F n '0 ODVM U) O r000" C) N ro OW OM m 1-N0 1,-N bONN ON MOD CO LO 1w f` } N LOco 1l O QLn00) Om r-r N 0) CO CO' O CCi CO O h !p? �100 �t 10 M U>b Ob co i N r � �D C �rO N r C M L0 N M LAM MMO r N M C M L o 0 0 0 0 o O 00 C0 CO i f�M0 r CO c) yr Cp F M10 CO O co COOCO tY OD N o m CO coOIt `C IQ m } 0 i0 OD 0) OD v O CO C0 0) i[) O 10 CO N O N N 0) O O 0 1` O M )0 O CO N 00 O tq lei ri M U9 r �rOR M P ri o ai M OIF 0i N �_ C- 0 rrM CO r l� N O M )0 M M C)) co b b CD CG NAcn M N r IciMr M M o 0 00�pp 0 OnMO v0� CO CN7 r � tp F LONP O 1- NOrh CD r 0)LLc)r Go 0 Oh ODD 0) Cb m a) m ONr O M O CO OD 4Onb q L0 Ob co O O OD r r- 0) O co C CO CO to N1 M CO O 'Q O W CO 1- N Or V M L0 C") O C") ODW) r M CO b CO C0 t0 CO CO N r ('M N I M C, M CM t00 M O CEO M �t (D F 00MCO O CO O OCO O O r o 0 cn OCti N N m MOQ O �_ 010v V O`er 00 �t I --CO CO 01 h � O O CV } M 00 r O O l0 r O v N r N m CO O CO C0 Ch CO W C ui (4r.: N M ti M LO O N v M N CO r CO M LO CO CO CO C0 CO )0 CV rM N COMA M M o 0 0 0 0 0 0) r O O C) 1, tl• CO CM O F, M CO co m m Ob (D 00 M C.m 00 F b co} 00 h r 1 O O 1 00q40 N O (0 r O 0 CO 0 O M r O M In m O m L0 N O CO r Lf) 4m O t O CO 01 O M C0NLOOO r M F OMO)OD rf� 00 MM MLA LO `'' ia+ qNON CM M N CO M M C6 0 0 0 0 0 O0p Co COcNOO M CC N Y I OeF NO6 F — N rL000 O CD CDOCO? O r o r 0) O CD O O 0) O O O 0) 0) O CO O O }GO I�MO O O 01n0 O`Cf O� M OD r m to CD Cn a Mtn ui O h t` O r �rOi �� F �9't N Obi O�iMO�iCOc ti h m O r N M N v v M M o c o 0 o a 0 D o c o ? M 3 r co N O M 1- O. � M I-- LO � M 0) C C C CO m CD r h N � � � 5NG J J J F { Jr O 0) O _ (A �^ O F M C`� O O Q Y 4 IO O O O 0) o b00N o o O O' 0 Im r m CM 0 CO O O 0) iCD 0000 OLr) 00 00 co co O OD et CO O O 0) MrN W) O rco M 0 O O O C } QO MMc)MM^r,NO O I� b NO0OO 0 M (AQ)N •N N O O M CN V M CM M Imr M N co M co CI. e 7 O LL 3 N N �'C~3 j C- '0 '�-' -C "y' jp �.. W di � T N N C m n N 8 (tL�n V {Np C,.) G O C.) m .0 $ $ m o _ Q (� m C m N m tD > 4; C C .0 C L ' L ' O vl o C O C7 C O O .0 CL C �yj, m N c Y) V Q v> o o(n fl io .0 c C CL m E e CL L H )C m trpp�� O m m $ c$ y 10 a�i 0) m m c o m f0 .0 a m a a0 m� _0 a m 3 �` LL. t CA e c O N o Om ro 2,�iyw m h E-0 $ mm 1 Q v Q omm$$L y a y(� E m E.�m16 m co N.0 J N Qi, O0) O� V 4) O m C ITO O p 0O J a cm Z' C¢ C C2 CyC7 N lO '0 a4 t} -CLL (n t� v, J w \ o ro d C :: y 0 O d m c n E o E U U U o an ic$$ m 3 L m t y O Oi—N -� Q CO na am vm 06 t 3 m Q L) ��NM v� QOOaOcn Qa0 a 03 v� m 0 O N � 00 ' Oi M 4 Ln CC O cm CV C'7 � Lq co � 0Ci . G r N M C O (O N O D 01 r �, a- r r r r F r r C V N N N N N N N N Key Take-Aways from 7-Year Cash Flow Model First year starting fund balance = $3,900,000.00 First Year ending fund balance = $3,777,000.00 Cash Decrease = $123,000.00 Annual cash deficit (subsidy) grows from year 1 to year 7 due to operating costs increasing faster than revenue growth Year 1 Deficit $813,699.00 Year 7 Deficit $1,351.028.':i'� 7 year increase = �537,329.00 *When $300k debt service related to road imps c: cements drops off it will help mitigate the operating deficit increase Recommended Risk Management Measures PFD accounting staff should monitor sales tax growth rate every 6 months * Determine if growth rate is falling below 3% * Notify PFD Board of potential cash flow challenges Ultimate Risk Does the current construction bonding capacity disguise a future cash flow challenge? Are we building based on borrowing instead of cashflow? Will construction of phase 2 be funded from cash accumulation and not by issuing new bonds?