Loading...
HomeMy WebLinkAbout16, Attachment 1 Water Rate Study 2020Attachment 1 Truckee Donner PUD Water Utility Revenue Requirment Summary Scenario 1- Baseline (Values in $1,OOOs) Budget Projected FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 Revenue Rate Revenue at Current Rates $13,020 $13,128 $13,242 $13,357 $13,473 $13,590 $13,709 $13,829 $13,950 $14,071 $14,195 Miscellaneous Revenue 644 655 609 610 610 610 611 612 612 613 613 Total Revenue $13,664 $13,784 $13,851 $13,967 $14,083 $14,201 $14,320 $14,440 $14,562 $14,684 $14,809 Expenditures Board of Directors $276 $166 $171 $176 $182 $187 $193 $198 $204 $210 $217 General Manger 688 812 836 862 888 915 943 971 1,001 1,031 1,062 Adminsitrative Services 1,463 1,446 1,499 1,554 1,611 1,670 1,732 1,796 1,862 1,931 2,003 Conservation 103 107 110 113 117 120 124 128 131 135 139 Water Operations 5,809 6,543 6,713 6,888 7,067 7,252 7,442 7,637 7,838 8,044 8,257 IT/GIS 757 775 799 823 848 873 899 926 954 983 1,012 Interdepartmental Rent 507 537 568 585 603 621 639 658 678 699 719 Additional Expenditures 0 0 493 507 522 538 554 571 588 606 624 Total Expenditures $9,602 $10,386 $11,189 $11,508 $11,837 $12,176 $12,525 $12,885 $13,256 $13,639 $14,034 Rate Funded Capital $2,093 $2,224 $2,544 $2,779 $2,894 $3,109 $3,286 $3,461 $3,646 $3,840 $4,036 Debt Service $2,829 $2,659 $1,835 $1,835 $1,833 $1,836 $1,032 $1,033 $1,032 $1,031 $1,032 Transfers ($1,105) ($1,092) ($978) ($1,057) ($1,010) ($1,060) ($256) ($248) ($243) ($239) ($229) Total Revenue Requirement $13,419 $14,178 $14,590 $15,064 $15,554 $16,061 $16,587 $17,130 $17,692 $18,271 $18,874 Balance/(Deficiency) of Funds Rate Adj. as a % of Rate Rev $246 -1.9% ($394) 3.0% ($739) 5.6% ($1,098) 8.2% ($1,471) 10.9% ($1,861) 13.7% ($2,267) 16.5% ($2,690) 19.5% ($3,130) 22.4% ($3,587) 25.5% ($4,065) 28.6% Proposed Rate Adjustment 0.0% 3.0% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% Rate Revenue After Adjustment $13,020 $13,522 $13,980 $14,454 $14,944 $15,451 $15,976 $16,518 $17,079 $17,659 $18,260 Debt Service Coverage Ratio Before Rate Asjustment 1.44 1.28 1.45 1.34 1.22 1.10 1.74 1.51 1.26 1.01 0.75 After Rate Adjustment 1.44 1.43 1.85 1.94 2.03 2.12 3.94 4.11 4.30 4.49 4.69 Average Monthly Residential Bill $73.56 $75.77 $77.66 $79.60 $81.59 $83.63 $85.72 $87.87 $90.06 $92.31 $94.62 $ Change Per Month 0.00 2.21 1.89 1.94 1.99 2.04 2.09 2.14 2.20 2.25 2.31 Cumulative $ Change per Month 0.00 2.21 4.10 6.04 8.03 10.07 12.16 14.31 16.50 18.75 21.06 Ending Reserve Balance $6,375 $6,402 $6,422 $6,432 $6,493 $6,502 $6,533 $6,587 $6,669 $6,773 $6,903 8/27/2020 Draft Truckee Danner PUD Truckee Donner PUD Water Utility Revenue Requirment Summary Scenario 2 - $4m Cap Funding (Values in $1,OOOs) Budget Projected FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 Revenue Rate Revenue at Current Rates $13,020 $13,128 $13,242 $13,357 $13,473 $13,590 $13,709 $13,829 $13,950 $14,071 $14,195 Miscellaneous Revenue 644 655 603 608 621 633 649 664 675 684 690 Total Revenue $13,664 $13,784 $13,845 $13,965 $14,093 $14,223 $14,358 $14,492 $14,625 $14,755 $14,885 Expenditures Board of Directors $276 $166 $171 $176 $182 $187 $193 $198 $204 $210 $217 General Manger 688 812 836 862 888 915 943 971 1,001 1,031 1,062 Adminsitrative Services 1,463 1,446 1,499 1,554 1,611 1,670 1,732 1,796 1,862 1,931 2,003 Conservation 103 107 110 113 117 120 124 128 131 135 139 Water Operations 5,809 6,543 6,713 6,888 7,067 7,252 7,442 7,637 7,838 8,044 8,257 IT/GIS 757 775 799 823 848 873 899 926 954 983 1,012 Interdepartmental Rent 507 537 568 585 603 621 639 658 678 699 719 Additional Expenditures 0 0 493 507 522 538 554 571 588 606 624 Total Expenditures $9,602 $10,386 $11,189 $11,508 $11,837 $12,176 $12,525 $12,885 $13,256 $13,639 $14,034 Rate Funded Capital $2,093 $2,750 $2,850 $3,100 $3,600 $4,000 $4,300 $4,600 $4,900 $5,200 $5,500 Debt Service $2,829 $2,701 $1,902 $1,927 $1,983 $2,057 $1,334 $1,426 $1,526 $1,634 $1,032 Transfers ($1,105) ($1,092) ($978) ($1,057) ($1,010) ($1,060) ($256) ($248) ($243) ($239) ($229) Total Revenue Requirement $13,419 $14,746 $14,963 $15,478 $16,409 $17,173 $17,903 $18,663 $19,440 $20,234 $20,338 Balance/(Deficiency) of Funds Rate Adj. as a % of Rate Rev $246 -1.9% ($962) 7.3% ($1,117) 8.4% ($1,513) 11.3% ($2,316) 17.2% ($2,950) 21.7% ($3,544) 25.9% ($4,170) 30.2% ($4,815) 34.5% ($5,479) 38.9% ($5,452) 38.4% Proposed Rate Adjustment 0.0% 5.0% 5.0% 5.0% 5.0% 5.0% 2.5% 2.5% 2.5% 2.5% 2.5% Rate Revenue After Adjustment $13,020 $13,785 $14,600 $15,462 $16,376 $17,345 $17,934 $18,543 $19,173 $19,823 $20,498 Debt Service Coverage Ratio Before Rate Asjustment 1.44 1.26 1.40 1.28 1.14 1.00 1.37 1.13 0.90 0.68 0.82 After Rate Adjustment 1.44 1.50 2.11 2.37 2.60 2.82 4.54 4.43 4.32 4.20 6.93 Average Monthly Residential Bill $73.56 $77.24 $81.10 $85.15 $89.41 $93.88 $96.23 $98.64 $101.10 $103.63 $106.22 $ Change Per Month 0.00 3.68 3.86 4.05 4.26 4.47 2.35 2.41 2.47 2.53 2.59 Cumulative $ Change per Month 0.00 3.68 7.54 11.59 15.85 20.32 22.67 25.08 27.54 30.07 32.66 Ending Reserve Balance $6,375 $6,096 $6,357 $6,960 $7,608 $8,422 $9,133 $9,732 $10,222 $10,599 $11,579 8/27/2020 Draft Truckee Danner PUD Truckee Donner PUD Water Utility Revenue Requirment Summary Scenario 3 - $7m Cap Funding (Values in $1,OOOs) Budget Projected FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 Revenue Rate Revenue at Current Rates $13,020 $13,128 $13,242 $13,357 $13,473 $13,590 $13,709 $13,829 $13,950 $14,071 $14,195 Miscellaneous Revenue 644 655 551 516 514 523 545 568 601 640 686 Total Revenue $13,664 $13,784 $13,793 $13,873 $13,987 $14,113 $14,254 $14,397 $14,550 $14,711 $14,881 Expenditures Board of Directors $276 $166 $171 $176 $182 $187 $193 $198 $204 $210 $217 General Manger 688 812 836 862 888 915 943 971 1,001 1,031 1,062 Adminsitrative Services 1,463 1,446 1,499 1,554 1,611 1,670 1,732 1,796 1,862 1,931 2,003 Conservation 103 107 110 113 117 120 124 128 131 135 139 Water Operations 5,809 6,543 6,713 6,888 7,067 7,252 7,442 7,637 7,838 8,044 8,257 IT/GIS 757 775 799 823 848 873 899 926 954 983 1,012 Interdepartmental Rent 507 537 568 585 603 621 639 658 678 699 719 Additional Expenditures 0 0 493 507 522 538 554 571 588 606 624 Total Expenditures $9,602 $10,386 $11,189 $11,508 $11,837 $12,176 $12,525 $12,885 $13,256 $13,639 $14,034 Rate Funded Capital $2,093 $6,700 $6,800 $6,900 $7,000 $7,100 $7,200 $7,300 $7,400 $7,500 $7,600 Debt Service $2,829 $2,659 $1,835 $1,835 $1,833 $1,836 $1,032 $1,033 $1,032 $1,031 $1,032 Transfers ($1,105) ($1,092) ($978) ($1,057) ($1,010) ($1,060) ($256) ($248) ($243) ($239) ($229) Total Revenue Requirement $13,419 $18,654 $18,846 $19,185 $19,660 $20,052 $20,501 $20,969 $21,446 $21,931 $22,438 Balance/(Deficiency) of Funds Rate Adj. as a % of Rate Rev $246 -1.9% ($4,870) 37.1% ($5,053) 38.2% ($5,312) 39.8% ($5,673) 42.1% ($5,939) 43.7% ($6,247) 45.6% ($6,573) 47.5% ($6,895) 49.4% ($7,220) 51.3% ($7,556) 53.2% Proposed Rate Adjustment 0.0% 15.0% 15.0% 6.0% 4.0% 4.0% 2.5% 2.5% 2.5% 2.5% 2.5% Rate Revenue After Adjustment $13,020 $15,097 $17,513 $18,725 $19,642 $20,606 $21,306 $22,029 $22,777 $23,550 $24,352 Debt Service Coverage Ratio Before Rate Asjustment 1.44 1.28 1.42 1.29 1.17 1.06 1.68 1.46 1.25 1.04 0.82 After Rate Adjustment 1.44 2.02 3.75 4.21 4.54 4.88 9.04 9.41 9.81 10.23 10.66 Average Monthly Residential Bill $73.56 $84.59 $97.28 $103.12 $107.24 $111.53 $114.32 $117.18 $120.11 $123.11 $126.19 $ Change Per Month 0.00 11.03 12.69 5.84 4.12 4.29 2.79 2.86 2.93 3.00 3.08 Cumulative $ Change per Month 0.00 11.03 23.72 29.56 33.68 37.97 40.76 43.62 46.55 49.55 52.63 Ending Reserve Balance $6,375 $3,501 $1,750 $1,646 $2,112 $3,208 $4,348 $6,090 $8,445 $11,577 $15,403 8/27/2020 Draft Truckee Danner PUD