The URL can be used to link to this page

Home My WebLink About17 Attachment 1 - Proposed Water Rate Design Scenarios 4-5Attachment 1 Truckee Donner PUD Water Utility Revenue Requirment Summary Scenario 4 - Updated Mid Cap Funding (Values in $1,OOOs) I 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 616 632 652 678 699 719 734 757 Total Revenue $13,664 $13,784 $13,852 $13,973 $14,105 $14,242 $14,387 $14,528 $14,668 $14,805 $14,952 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 $3,000 $3,700 $4,200 $4,700 $5,200 $5,700 $6,200 $6,700 $6,800 $7,000 Debt Service $2,829 $2,659 $1,983 $1,982 $2,129 $2,132 $1,476 $1,476 $1,623 $1,623 $1,772 Transfers ($1,105) ($1,092) ($978) ($1,057) ($1,010) ($1,060) ($256) ($248) ($243) ($239) ($229) Total Revenue Requirement $13,419 $14,954 $15,894 $16,633 $17,656 $18,448 $19,444 $20,313 $21,337 $21,822 $22,577 Balance/(Deficiency) of Funds $246 ($1,170) ($2,042) ($2,660) ($3,550) ($4,206) ($5,057) ($5,785) ($6,669) ($7,017) ($7,624) Rate Adj. as a % of Rate Rev -1.9% 8.9% 15.4% 19.9% 26.4% 30.9% 36.9% 41.8% 47.8% 49.9% 53.7% Proposed Rate Adjustment 0.0% 9.0% 8.0% 7.0% 6.0% 5.0% 3.0% 3.0% 3.0% 3.0% 3.0% Rate Revenue After Adjustment $13,020 $14,310 $15,589 $16,825 $17,988 $19,052 $19,796 $20,568 $21,370 $22,203 $23,070 Debt Service Coverage Ratio Before Rate Asjustment 1.44 1.28 1.34 1.24 1.07 0.97 1.26 1.11 0.87 0.72 0.52 After Rate Adjustment 1.44 1.72 2.53 2.99 3.19 3.53 5.39 5.68 5.44 5.73 5.53 Average Monthly Residential Bill $73.56 $80.18 $86.59 $92.66 $98.22 $103.13 $106.22 $109.41 $112.69 $116.07 $119.55 $ Change Per Month 0.00 6.62 6.41 6.06 5.56 4.91 3.09 3.19 3.28 3.38 3.48 Cumulative $ Change per Month 0.00 6.62 13.03 19.10 24.66 29.57 32.66 35.85 39.13 42.51 45.99 Ending Reserve Balance $6,375 $6,413 $7,838 $7,556 $9,682 $9,848 $12,008 $11,917 $13,850 $13,969 $16,450 Low Interest Loan $0 $0 $2,200 $0 $2,200 $0 $2,200 $0 $2,200 $0 $2,200 Funding Available for Capital $2,253 $3,270 $5,000 $5,500 $6,000 $6,500 $7,000 $7,500 $8,000 $8,100 $8,300 10/2/2020 Draft - Updated Mid Cap Funding Truckee Donner PUD Page 1 Truckee Donner PUD Water Utility Revenue Requirment Summary Scenario 5 - Updated Mid Hi Cap Funding (Values in $1,OOOs) I 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 613 616 617 632 647 671 702 744 Total Revenue $13,664 $13,784 $13,852 $13,970 $14,088 $14,207 $14,341 $14,476 $14,621 $14,773 $14,939 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 $3,000 $4,000 $5,200 $6,300 $6,800 $7,100 $7,100 $7,100 $7,100 $7,100 Debt Service $2,829 $2,659 $1,983 $1,982 $2,129 $2,132 $1,476 $1,476 $1,623 $1,623 $1,772 Transfers ($1,105) ($1,092) ($978) ($1,057) ($1,010) ($1,060) ($256) ($248) ($243) ($239) ($229) Total Revenue Requirement $13,419 $14,954 $16,194 $17,633 $19,256 $20,048 $20,844 $21,213 $21,737 $22,122 $22,677 Balance/(Deficiency) of Funds $246 ($1,170) ($2,342) ($3,663) ($5,167) ($5,841) ($6,504) ($6,737) ($7,116) ($7,349) ($7,737) Rate Adj. as a % of Rate Rev -1.9% 8.9% 17.7% 27.4% 38.4% 43.0% 47.4% 48.7% 51.0% 52.2% 54.5% Proposed Rate Adjustment 0.0% 9.0% 9.0% 8.0% 8.0% 7.0% 3.0% 3.0% 3.0% 3.0% 3.0% Rate Revenue After Adjustment $13,020 $14,310 $15,733 $17,139 $18,670 $20,151 $20,938 $21,754 $22,603 $23,483 $24,401 Debt Service Coverage Ratio Before Rate Asjustment 1.44 1.28 1.34 1.24 1.06 0.95 1.23 1.08 0.84 0.70 0.51 After Rate Adjustment 1.44 1.72 2.60 3.15 3.50 4.03 6.13 6.45 6.17 6.50 6.27 Average Monthly Residential Bill $73.56 $80.18 $87.40 $94.39 $101.94 $109.08 $112.35 $115.72 $119.19 $122.77 $126.45 $ Change Per Month 0.00 6.62 7.22 6.99 7.55 7.14 3.27 3.37 3.47 3.58 3.68 Cumulative $ Change per Month 0.00 6.62 13.84 20.83 28.38 35.52 38.79 42.16 45.63 49.21 52.89 Ending Reserve Balance $6,375 $6,413 $7,683 $6,712 $7,903 $7,532 $9,388 $9,531 $12,249 $13,316 $17,015 Low Interest Loan $0 $0 $2,200 $0 $2,200 $0 $2,200 $0 $2,200 $0 $2,200 Funding Available for Capital $2,253 $3,270 $5,300 $6,500 $7,600 $8,100 $8,400 $8,400 $8,400 $8,400 $8,400 10/2/2020 Draft - Updated Mid Hi Cap Funding Truckee Donner PUD Page 2