RESERVE/FUND BALANCE, JULY 1
CURRENT RESOURCES:
Water Sales and Water Service Fees
Development and Connection Fees
Miscellaneous Revenues
Interest Income
Transfer From Other Funds
TOTAL CURRENT RESOURCES
TOTAL AVAILABLE RESOURCES
CURRENT REQUIREMENTS:
OPERATING REQUIREMENTS:
Operations
Purchased Water
Special Projects
In-Lieu Charges
TOTAL OPERATING REQUIREMENTS
NON-OPERATING REQUIREMENTS:
Debt Service
Transfer To Employee Benefits Fund
Transfer To General Fund
TOTAL NON-OPERATING REQUIREMENTS
CAPITAL AND INFRASTRUCTURE REQ.:
Capital and Infrastructure Projects
TOTAL CAPITAL AND INFRASTRUCTURE REQ.
TOTAL CURRENT REQUIREMENTS
RESERVES:
Contingencies
Capital and Infrastructure Reserve
Rate Stabilization Reserve
TOTAL RESERVES
FUND BALANCE, JUNE 30
STATISTICS:
Recommended Water Rate Increase
Prior Year Water Rate Increase
FY 2023/2024
TO
ACTUAL CURRENT BUDGET PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2033/2034 2022/2023 2023/2024 2024/2025 2025/2026 2026/2027 2027/2028 2028/2029 2029/2030 2030/2031 2031/2032 2032/2033 2033/2034 TOTAL -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 98,983,533 101,468,104 89,371,489 84,425,140 70,443,584 64,029,345 62,509,170 56,655,154 48,324,953 46,690,875 38,766,249 38,951,349 101,468,104 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 52,325,670 57,110,959 60,524,290 63,646,969 67,935,841 72,515,195 77,766,888 83,400,616 89,444,281 95,927,827 102,883,395 109,831,625 880,987,887 5,240,781 3,313,615 3,338,024 3,363,165 3,389,060 3,415,731 3,443,203 3,471,499 3,500,644 3,530,664 3,561,584 3,593,431 37,920,620 265,774 280,000 300,650 313,590 329,901 347,169 366,509 387,079 408,966 432,257 457,051 481,959 4,105,130 1,860,780 3,437,365 3,247,121 2,709,369 2,462,667 1,820,655 1,650,150 1,407,523 1,359,928 1,129,114 1,134,505 943,422 21,301,819 000000000000 0
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 59,693,004 64,141,940 67,410,085 70,033,093 74,117,468 78,098,750 83,226,750 88,666,718 94,713,819 101,019,862 108,036,535 114,850,436 944,315,456 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 158,676,537 165,610,044 156,781,573 154,458,232 144,561,052 142,128,095 145,735,920 145,321,872 143,038,772 147,710,737 146,802,784 153,801,786 1,045,783,560 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 7,726,360 9,354,773 10,294,203 10,618,905 10,994,447 11,383,389 11,783,913 12,193,848 12,618,113 13,057,211 13,508,988 13,976,457 129,784,246 35,872,748 41,875,636 47,300,183 49,741,070 53,208,520 58,273,031 63,188,640 67,584,669 71,757,948 76,268,140 82,601,731 87,903,010 699,702,578 232,250 312,051 5,891 501,173 216,025 22,104 6,468 7,727 6,996 7,276 7,567 13,277 1,106,556 5,050,842 4,466,489 5,903,184 7,061,109 6,326,931 5,618,731 6,163,817 6,990,588 6,270,994 7,732,608 6,501,241 8,041,346 71,077,039 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 48,882,200 56,008,949 63,503,460 67,922,256 70,745,923 75,297,255 81,142,838 86,776,833 90,654,051 97,065,235 102,619,527 109,934,090 901,670,418 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 1,157,260 1,153,502 1,156,079 1,152,813 1,153,475 1,153,100 1,155,100 1,155,350 1,153,850 1,150,600 1,155,600 1,153,350 12,692,818 1,568,044 1,432,007 1,449,836 1,507,537 1,486,881 1,546,823 1,610,227 1,673,770 1,743,504 1,483,013 1,539,539 1,598,827 17,071,964 161,736 656,645 1,028,459 580,668 598,088 616,031 634,512 653,547 673,154 693,348 714,149 735,573 7,584,174 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 2,887,039 3,242,153 3,634,374 3,241,018 3,238,444 3,315,954 3,399,839 3,482,667 3,570,508 3,326,961 3,409,288 3,487,750 37,348,956 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 5,439,195 16,987,453 5,218,600 12,851,374 6,547,340 1,005,716 4,538,089 6,737,419 2,123,338 8,552,292 1,822,620 7,989,109 74,373,349 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 5,439,195 16,987,453 5,218,600 12,851,374 6,547,340 1,005,716 4,538,089 6,737,419 2,123,338 8,552,292 1,822,620 7,989,109 74,373,349 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 57,208,433 76,238,555 72,356,434 84,014,648 80,531,707 79,618,925 89,080,766 96,996,919 96,347,897 108,944,488 107,851,435 121,410,949 1,013,392,723 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 10,899,777 12,807,602 14,398,596 15,089,994 16,050,742 17,414,105 18,743,138 19,944,629 21,094,015 22,331,338 24,027,680 25,469,867 25,469,867 11,566,445 3,035,229 3,208,148 3,366,186 3,582,740 3,813,905 4,078,830 4,362,960 4,667,695 4,994,537 5,345,102 5,695,351 5,695,351 79,001,882 73,528,658 66,818,395 51,987,404 44,395,863 41,281,160 33,833,186 24,017,364 20,929,165 11,440,374 9,578,568 1,225,619 1,225,619 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 101,468,104 89,371,489 84,425,140 70,443,584 64,029,345 62,509,170 56,655,154 48,324,953 46,690,875 38,766,249 38,951,349 32,390,836 32,390,836 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 000000000000 0
=========== =========== =========== =========== =========== =========== =========== =========== =========== =========== =========== =========== ============
3.0% 4.0% 4.0% 4.5% 6.0% 6.0% 6.5% 6.5% 6.5% 6.5% 6.5% 6.0%
3.0% 4.0% 4.0% 4.0% 4.0% 5.0% 5.0% 5.0% 5.0% 4.0% 4.0% 4.0% JULY 1, 2023 TO JUNE 30, 2034
CITY OF SUNNYVALE
LONG TERM FINANCIAL PLAN
6040. WATER SUPPLY AND DISTRIBUTION FUND
Attachment 3
RESERVE/FUND BALANCE, JULY 1
CURRENT RESOURCES:
Water Sales and Water Service Fees
Development and Connection Fees
Miscellaneous Revenues
Interest Income
Transfer From Other Funds
TOTAL CURRENT RESOURCES
TOTAL AVAILABLE RESOURCES
CURRENT REQUIREMENTS:
OPERATING REQUIREMENTS:
Operations
Purchased Water
Special Projects
In-Lieu Charges
TOTAL OPERATING REQUIREMENTS
NON-OPERATING REQUIREMENTS:
Debt Service
Transfer To Employee Benefits Fund
Transfer To General Fund
TOTAL NON-OPERATING REQUIREMENTS
CAPITAL AND INFRASTRUCTURE REQ.:
Capital and Infrastructure Projects
TOTAL CAPITAL AND INFRASTRUCTURE REQ.
TOTAL CURRENT REQUIREMENTS
RESERVES:
Contingencies
Capital and Infrastructure Reserve
Rate Stabilization Reserve
TOTAL RESERVES
FUND BALANCE, JUNE 30
STATISTICS:
Recommended Water Rate Increase
Prior Year Water Rate Increase
FY 2034/2035 FY 2023/2024
TO TO
PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2043/2044 FY 2043/2044 2034/2035 2035/2036 2036/2037 2037/2038 2038/2039 2039/2040 2040/2041 2041/2042 2042/2043 2043/2044 TOTAL TOTAL -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 32,390,836 38,068,894 36,170,236 44,453,476 43,851,359 52,720,202 51,195,234 60,278,220 58,605,967 67,080,760 32,390,836 101,468,104 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 115,057,050 120,533,377 125,068,636 129,777,005 133,368,698 137,062,417 140,861,121 144,767,854 148,785,750 152,918,035 1,348,199,945 2,229,187,833 3,626,234 3,660,021 3,694,822 3,730,666 3,767,586 3,805,614 3,844,782 3,885,126 3,926,680 3,969,480 37,911,011 75,831,630 501,999 522,910 541,236 560,219 576,115 592,470 609,297 626,613 644,429 662,761 5,838,049 9,943,179 1,108,803 1,053,502 1,294,761 1,277,224 1,535,540 1,491,123 1,755,676 1,706,970 1,953,809 2,188,595 15,366,003 36,667,822 00000 143,6380000 143,638 143,638
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 120,294,086 125,769,810 130,599,455 135,345,114 139,247,939 143,095,262 147,070,877 150,986,563 155,310,668 159,738,871 1,407,458,646 2,351,774,101 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 152,684,922 163,838,704 166,769,691 179,798,590 183,099,298 195,815,464 198,266,111 211,264,783 213,916,635 226,819,632 1,439,849,482 2,453,242,205 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 14,507,314 15,058,514 15,630,841 16,225,111 16,842,172 17,482,903 18,148,219 18,839,071 19,556,444 20,301,364 172,591,953 302,376,198 87,773,628 90,749,556 93,828,986 97,015,203 100,329,921 103,759,254 107,286,690 110,945,990 114,730,475 118,644,167 1,025,063,869 1,724,766,447 8,185 25,365 20,606 9,207 9,575 10,958 10,356 10,770 11,201 11,537 127,760 1,234,316 6,891,018 8,365,547 7,269,265 9,487,049 7,684,257 9,745,421 8,172,280 10,179,920 8,686,541 8,895,388 85,376,687 156,453,726 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 109,180,144 114,198,982 116,749,698 122,736,569 124,865,924 130,998,536 133,617,546 139,975,751 142,984,662 147,852,457 1,283,160,269 2,184,830,687 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 1,152,950 1,161,150 1,152,200 1,147,800 1,152,000 1,154,4000000 6 ,920,500 19,613,318 1,601,164 1,592,673 1,567,031 1,438,167 1,295,598 1,194,718 1,120,759 724,930 542,348 487,753 11,565,142 28,637,106 757,640 780,370 803,781 827,894 852,731 878,313 904,662 931,802 959,756 988,549 8,685,499 16,269,673 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 3,511,754 3,534,193 3,523,012 3,413,861 3,300,329 3,227,431 2,025,421 1,656,732 1,502,104 1,476,302 27,171,140 64,520,096 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 1,924,131 9,935,292 2,043,506 9,796,801 2,212,843 10,394,263 2,344,924 11,026,333 2,349,109 2,349,109 54,376,310 128,749,659 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 1,924,131 9,935,292 2,043,506 9,796,801 2,212,843 10,394,263 2,344,924 11,026,333 2,349,109 2,349,109 54,376,310 128,749,659 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 114,616,029 127,668,467 122,316,215 135,947,232 130,379,096 144,620,229 137,987,891 152,658,816 146,835,875 151,677,868 1,364,707,719 2,378,100,443 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 25,570,235 26,452,018 27,364,957 28,310,078 29,293,023 30,310,539 31,358,727 32,446,265 33,571,730 34,736,383 34,736,383 34,736,383 5,959,264 6,235,815 6,465,235 6,703,395 6,885,620 7,073,025 7,265,760 7,463,980 7,667,843 7,877,514 7,877,514 7,877,514 6,539,394 3,482,403 10,623,285 8,837,886 16,541,559 13,811,670 21,653,733 18,695,723 25,841,188 32,527,867 32,527,867 32,527,867 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 38,068,894 36,170,236 44,453,476 43,851,359 52,720,202 51,195,234 60,278,220 58,605,967 67,080,760 75,141,764 75,141,764 75,141,764 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 0000000000 0 0
=========== =========== =========== =========== =========== =========== =========== =========== =========== =========== ============ ============
4.0% 4.0% 3.0% 3.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0%
4.0% 4.0% 3.0% 3.0% 3.0% 3.0% 2.0% 2.0% 2.0%
CITY OF SUNNYVALE
6040. WATER SUPPLY AND DISTRIBUTION FUND
JULY 1, 2034 TO JUNE 30, 2044
LONG TERM FINANCIAL PLAN
Attachment 3