Loading...
HomeMy WebLinkAbout10f BW3 attachment 6 FMPAttachment 6 ELECTRIC FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 Operating Cash Flow Operating revenue 31,654$33,919$35,273$36,681$38,145$39,481$40,669$41,894$43,156$44,455$ Operating expenses (26,903)(27,581)(28,616)(29,691)(30,806)(31,963)(33,163)(34,409)(35,702)(37,043) Other revenue/(expenses)(105)(214)(198)(179)(157)(130)(117)(104)(88)(73) Net Income 4,646$6,124$6,459$6,811$7,182$7,388$7,389$7,381$7,366$7,339$ Transfer from/(to) funds 6,649 917 1,873 (42)823 (325)(3,515)(764)(776)238 Debt Issuance Costs (185)--------- Debt principal payments (323)(201)(210)(218)(227)(236)(245)(255)(265)(276) Debt proceeds (new debt) - $6,000 6,000 --------- Capital projects (16,398)(6,619)(8,066)(6,161)(7,447)(6,495)(3,274)(5,798)(5,891)(6,219) Change in Operating Cash 389$221$57$391$331$332$355$565$434$1,083$ FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 OpGF+RR % of OpExp (Goal 50%)50%50%49%50%50%50%51%51%52%54% Capital Reserves % CapxGoal 100%84%74%46%53%42%45%89%97%104%100% Cash & Reserve Balances Operating Cash Balance (GenFd)6,593$6,815$6,872$7,262$7,593$7,926$8,280$8,844$9,278$10,361$ Rate Reserve Balance 6,774 7,011 7,291 7,582 7,885 8,200 8,527 8,867 9,221 9,589 Capital Reserve Balance 5,221 4,642 2,765 3,383 2,810 3,138 6,569 7,535 8,410 8,394 Capital Vehicle Reserve Balance 374 433 491 471 294 358 496 384 366 226 Deferred Liability 2,100 2,108 2,119 2,133 2,150 2,172 2,194 2,216 2,238 2,260 Facility Fee Reserve Balance 204 386 518 151 282 421 568 723 886 1,057 Cash & Reserve Balances 21,266$21,395$20,056$20,982$21,014$22,215$26,634$28,569$30,399$31,887$ Change to Proposed FY22 & FY23 0.0%0.0% Proposed rate change 8.5%6.5%3.0%3.0%3.0%2.5%2.0%2.0%2.0%2.0% Net Rate Increase in active FMP 8.5%6.5%3.0%3.0%3.0%2.5%2.0%2.0%2.0%2.0% FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 TDPUD Budget FY2022 and FY2023 (Draft 10/20/2021) Financial Master Plan Summary FY22 through FY31 (in thousands) 10/14/2021 9:37 AM I:\BUDGET\CYB\Central\Financial Master Plan Electric View1 Attachment F/6 - FMP - Page 1 of 4 Attachment 6TDPUD Budget FY2022 and FY2023 (Draft 10/20/2021) Financial Master Plan Summary FY22 through FY31 (in thousands) $- $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 $16,000 $18,000 $20,000 $22,000 $24,000 $26,000 $28,000 $30,000 $32,000 $34,000 FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 Electric Projected Cash & Reserve Balance Cash & Reserve Balances Goal 10/14/2021 9:37 AM I:\BUDGET\CYB\Central\Financial Master Plan Electric View1 Attachment F/6 - FMP - Page 2 of 4 Attachment 6 WATER FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 Operating Cash Flow Operating revenue 16,434$17,784$19,324$20,810$22,413$24,141$25,288$26,491$27,620$28,798$ Operating expenses (11,111)(11,576)(11,959)(12,383)(12,822)(13,268)(13,720)(14,189)(14,673)(15,173) Other revenue and expenses (693)(956)(908)(855)(801)(739)(690)(644)(595)(543) Net income 4,630$5,252$6,457$7,572$8,790$10,134$10,878$11,658$12,352$13,082$ Transfers from/(to) funds 963 2,326 (276)429 (1,023)608 (2,459)577 (2,202)(1,478) Debt Issuance Costs (285)--------- Debt principal payments (846)(1,015)(1,055)(1,100)(1,140)(1,186)(1,233)(1,276)(1,324)(1,373) Debt proceeds (new debt) - $14,755 5,789 8,966 -------- Capital expenditures (9,397)(15,277)(4,856)(6,707)(6,315)(9,358)(6,847)(10,747)(8,592)(9,929) Change in Operating Cash 854$252$270$194$312$198$339$212$234$302$ FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 OpGF Reserve% of OpExp Goal 50%50%50%51%51%51%51%52%52%52%52% Capital Reserves % CapxGoal 100%14%2%11%10%28%25%57%54%81%99% Cash & Reserve Balances Operating Cash Balance (GenFd)5,562$5,814$6,084$6,278$6,590$6,787$7,126$7,338$7,572$7,874$ Capital Reserve Balance 920 (37)573 477 1,856 1,675 4,591 4,537 7,168 9,239 Vehicle Reserve Balance 110 207 280 358 415 415 382 314 329 202 Deferred Liability 107 107 108 108 108 109 109 109 110 110 Facility Fee Balance 2,427 1,543 1,522 1,501 1,484 1,486 1,506 1,543 1,602 1,683 Cash & Reserve Balances 9,126$7,634$8,567$8,722$10,453$10,472$13,714$13,841$16,781$19,108$ Debt service coverage 4.49 3.43 3.95 4.49 5.08 5.74 6.10 6.49 6.82 7.16 (1.25 required until 2036) Change to Proposed FY22 & FY23 0.0%0.0% Proposed rate change 8.9%7.9%8.0%7.0%7.0%7.0%4.0%4.0%3.50%3.50% FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 TDPUD Budget FY2022 and FY2023 (Draft 10/20/2021) Financial Master Plan Summary FY22 through FY31 (in thousands) 10/14/2021 9:37 AM I:\BUDGET\CYB\Central\Financial Master Plan Water View1 Attachment F/6 - FMP - Page 3 of 4 Attachment 6TDPUD Budget FY2022 and FY2023 (Draft 10/20/2021) Financial Master Plan Summary FY22 through FY31 (in thousands) $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 $16,000 $18,000 $20,000 FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 Water Projected Cash & Reserve Balance Cash & Reserve Balances Goal 10/14/2021 9:37 AM I:\BUDGET\CYB\Central\Financial Master Plan Water View1 Attachment F/6 - FMP - Page 4 of 4