RESERVE/FUND BALANCE, JULY 1
CURRENT RESOURCES:
Service Fees
Connection and Development Fees
Other Revenues
Interest Income
SRF Loan Proceeds
WIFIA Loan
Bond Proceeds
TOTAL CURRENT RESOURCES
TOTAL AVAILABLE RESOURCES
CURRENT REQUIREMENTS:
OPERATING REQUIREMENTS:
Operations
In-Lieu Charges and Fund Transfers
Project Operating
TOTAL CURRENT OPERATING REQUIREMENT
NON-OPERATING REQUIREMENTS:
Interfund Loan Repayment
2017 Wastewater Revenue Bonds Debt Service
WIFIA Loan Debt Service
State Revolving Fund Loan Debt Service
Other Debt Service
Water Pollution Control Plant Rent
Wastewater Equipment Replacement
Transfer To General Fund - Civic Center Rent
Transfer To General Fund - Projects
Transfer To Employee Benefits Fund
TOTAL NON-OPERATING REQUIREMENTS
CAPITAL AND INFRASTRUCTURE REQ.:
Sunnyvale Cleanwater Program Loan Funded
Sunnyvale Cleanwater Program PAYGO
Projects - Revenue Funded
TOTAL CAPITAL AND INFRASTRUCTURE REQ.
TOTAL CURRENT REQUIREMENTS
RESERVES:
Debt Service
Contingencies
Capital and Infrastructure Reserve
Rate Stabilization Reserve
TOTAL RESERVES
FUND BALANCE, JUNE 30
STATISTICS:
Sewer Rate Increase
Prior Year Sewer Rate Increase
FY 2024/2025
TO
ACTUAL CURRENT BUDGET PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2034/2035 2023/2024 2024/2025 2025/2026 2026/2027 2027/2028 2028/2029 2029/2030 2030/2031 2031/2032 2032/2033 2033/ 2034 2034/2035 TOTAL -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 102,283,415 71,182,011 57,472,591 124,020,894 128,793,185 108,245,988 70,647,419 56,031,753 47,022,748 48,984,981 73,527,310 56,185,097 71,182,011 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 54,413,948 59,336,340 63,518,958 67,996,410 72,789,477 77,920,407 83,413,016 89,292,800 95,587,049 101,369,110 106,487,236 110,798,904 928,509,708 1,535,132 500,000 1,591,350 1,591,350 1,591,350 1,591,350 1,591,350 1,639,091 1,688,263 1,738,911 1,791,078 1,844,811 17,158,904 220,848 206,625 217,498 229,058 241,351 254,428 268,340 283,146 298,907 313,584 326,845 338,378 2,978,161 2,114,697 3,266,133 3,004,106 5,026,008 3,985,858 3,717,722 2,699,257 2,300,684 2,332,934 2,141,572 2,738,183 2,235,479 33,447,936 1,901,152 91,120,665 154,472,239 58,783,676 47,346,660 11,076,760 0 0 0 0 0 0 362,800,000 10,359,425 10,359,191 63,333,132 18,268,121 79,409,321 25,311,674 701,552 0 0 0 0 0 197,382,990 0 0 0 0 0 0 0 0 0 106,736,418 149,404,958 0 256,141,376 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 70,545,202 164,788,954 286,137,284 151,894,622 205,364,017 119,872,340 88,673,515 93,515,721 99,907,153 212,299,595 260,748,301 115,217,573 1,798,419,075 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 172,828,617 235,970,965 343,609,875 275,915,517 334,157,201 228,118,328 159,320,934 149,547,473 146,929,901 261,284,576 334,275,611 171,402,670 1,869,601,086 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 22,536,878 26,368,732 27,643,918 28,421,221 29,456,086 30,527,782 31,617,207 32,747,337 33,919,883 35,135,137 36,391,876 37,698,888 349,928,066 4,081,252 6,024,779 5,079,322 6,190,649 6,907,575 5,380,270 6,057,159 6,542,901 5,709,522 6,514,001 6,754,020 5,920,967 67,081,166 0 24,858 28,975 25,155 1,729,339 1,825,530 2,109,725 2,205,927 2,210,135 2,306,349 2,410,570 2,406,797 17,283,360 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 26,618,130 32,418,370 32,752,215 34,637,025 38,093,000 37,733,581 39,784,091 41,496,165 41,839,540 43,955,487 45,556,466 46,026,651 434,292,592 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 949,615 949,615 949,615 949,615 517,047 0 0 0 0 0 0 0 3,365,892 2,007,266 2,011,095 2,015,020 2,015,750 1,169,000 1,171,000 1,166,250 1,170,000 1,171,750 1,166,500 1,164,500 1,164,500 15,385,365 0 0 0 0 0 0 1,887,440 3,774,880 3,774,880 3,774,880 3,774,880 3,774,880 20,761,841 5,251,439 5,297,857 5,297,385 5,296,905 20,200,741 20,200,245 20,199,740 20,199,226 20,198,704 20,198,173 20,197,633 20,197,633 177,484,244 0 0 0 0 0 0 0 0 0 858,912 8,109,365 16,055,009 25,023,286 859,752 885,544 912,110 939,474 967,658 996,688 1,026,588 1,057,386 1,089,108 1,121,781 1,155,434 1,225,800 11,377,571 115,299 514,411 570,877 441,212 432,304 393,887 288,839 255,980 737,823 322,412 196,785 191,849 4,346,379 1,125,198 1,009,788 1,024,935 1,055,683 1,087,354 1,119,974 1,153,574 1,188,181 1,223,826 1,260,541 1,298,357 1,337,308 12,759,522 0 0 0 0 0 0 73,603 128,846 0 0 0 0 202,449
3,248,292 3,359,454 3,194,940 3,166,589 3,284,075 3,406,090 3,532,790 3,664,177 3,800,578 3,676,416 3,700,419 3,724,594 38,510,122 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 13,556,861 14,027,765 13,964,883 13,865,228 27,658,179 27,287,884 29,328,824 31,438,676 31,996,669 32,379,615 39,597,374 47,671,574 309,216,671 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 43,129,397 104,388,834 147,622,842 77,051,796 126,755,981 36,388,434 701,552 0 0 106,736,418 149,404,958 0 749,050,814 10,660,960 17,813,067 17,543,561 12,147,537 19,635,367 48,027,928 27,676,314 23,000,982 22,146,000 0 37,825,856 33,342,503 259,159,115 7,681,259 9,850,338 7,705,480 9,420,745 13,768,687 8,033,082 5,798,401 6,588,902 1,962,712 4,685,746 5,705,859 953,005 74,472,956 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 61,471,616 132,052,238 172,871,883 98,620,079 160,160,035 92,449,444 34,176,266 29,589,884 24,108,711 111,422,164 192,936,673 34,295,508 1,082,682,885 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 101,646,606 178,498,373 219,588,981 147,122,332 225,911,214 157,470,909 103,289,181 102,524,725 97,944,921 187,757,266 278,090,513 127,993,733 1,826,192,149 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 5,251,439 20,200,741 20,200,741 20,200,741 20,200,741 20,200,245 20,199,740 20,199,226 20,198,704 20,198,173 20,197,633 20,197,633 20,197,633 5,634,219 6,592,183 6,910,979 7,105,305 7,364,021 7,631,945 7,904,302 8,186,834 8,479,971 8,783,784 9,097,969 9,424,722 9,424,722 5,441,395 5,933,634 6,351,896 6,799,641 7,278,948 7,792,041 8,341,302 8,929,280 9,558,705 10,136,911 10,648,724 11,079,890 11,079,890 54,854,957 24,746,033 90,557,278 94,687,497 73,402,277 35,023,188 19,586,409 9,707,407 10,747,601 34,408,441 16,240,772 2,706,692 2,706,692 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 71,182,011 57,472,591 124,020,894 128,793,185 108,245,988 70,647,419 56,031,753 47,022,748 48,984,981 73,527,310 56,185,097 43,408,937 43,408,937 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 0 0 0 0 0 0 0 0 0 0 0 0 0
=========== =========== =========== =========== =========== =========== =========== =========== =========== =========== =========== =========== ============
9.0% 9.0% 7.0% 7.0% 7.0% 7.0% 7.0% 7.0% 7.0% 6.0% 5.0% 4.0%
9.0% 9.0% 9.0% 9.0% 8.0% 6.0% 5.0% 5.0% 5.0% 9.0% 5.0% 2.0% JULY 1, 2024 TO JUNE 30, 2035
LONG TERM FINANCIAL PLAN
6080. WASTEWATER MANAGEMENT FUND
CITY OF SUNNYVALE
Attachment 5
RESERVE/FUND BALANCE, JULY 1
CURRENT RESOURCES:
Service Fees
Connection and Development Fees
Other Revenues
Interest Income
SRF Loan Proceeds
WIFIA Loan
Bond Proceeds
TOTAL CURRENT RESOURCES
TOTAL AVAILABLE RESOURCES
CURRENT REQUIREMENTS:
OPERATING REQUIREMENTS:
Operations
In-Lieu Charges and Fund Transfers
Project Operating
TOTAL CURRENT OPERATING REQUIREMENT
NON-OPERATING REQUIREMENTS:
Interfund Loan Repayment
2017 Wastewater Revenue Bonds Debt Service
WIFIA Loan Debt Service
State Revolving Fund Loan Debt Service
Other Debt Service
Water Pollution Control Plant Rent
Wastewater Equipment Replacement
Transfer To General Fund - Civic Center Rent
Transfer To General Fund - Projects
Transfer To Employee Benefits Fund
TOTAL NON-OPERATING REQUIREMENTS
CAPITAL AND INFRASTRUCTURE REQ.:
Sunnyvale Cleanwater Program Loan Funded
Sunnyvale Cleanwater Program PAYGO
Projects - Revenue Funded
TOTAL CAPITAL AND INFRASTRUCTURE REQ.
TOTAL CURRENT REQUIREMENTS
RESERVES:
Debt Service
Contingencies
Capital and Infrastructure Reserve
Rate Stabilization Reserve
TOTAL RESERVES
FUND BALANCE, JUNE 30
STATISTICS:
Sewer Rate Increase
Prior Year Sewer Rate Increase
FY 2035/2036 FY 2024/2025
TO TO
PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2044/2045 FY 2044/2045 2035/2036 2036/2037 2037/2038 2038/2039 2039/2040 2040/2041 2041/2042 2042/2043 2043/2044 2044/ 2045 TOTAL TOTAL -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 43,408,937 50,123,054 62,727,978 47,349,072 47,860,346 63,552,282 80,536,490 92,486,353 111,234,960 135,134,994 43,408,937 71,182,011 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 115,230,861 117,535,478 119,886,187 121,085,049 122,295,900 123,518,859 124,754,047 126,062,717 127,385,115 128,721,385 1,226,475,599 2,154,985,307 1,900,155 1,957,160 2,015,875 2,076,351 2,138,641 2,202,801 2,268,885 2,336,951 2,407,060 2,479,271 21,783,149 38,942,053 350,223 357,435 364,797 369,676 374,633 379,668 384,785 390,119 395,539 401,047 3,767,921 6,746,083 1,743,758 2,165,633 2,559,408 1,851,551 2,013,657 2,509,855 2,863,940 3,359,473 3,935,971 4,444,421 27,447,667 60,895,603 0 0 0 0 0 0 0 0 0 0 0 362,800,000
0 0 0 0 0 0 0 0 0 0 0 197,382,990
0 0 0 0 0 0 0 0 0 0 0 256,141,376
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 119,224,996 122,015,705 124,826,267 125,382,627 126,822,831 128,611,183 130,271,657 132,149,260 134,123,685 136,046,125 1,279,474,336 3,077,893,412 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 162,633,934 172,138,759 187,554,246 172,731,699 174,683,177 192,163,465 210,808,147 224,635,613 245,358,645 271,181,119 1,322,883,274 3,149,075,422 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 39,150,955 40,660,382 42,229,492 43,860,701 45,556,526 47,319,589 49,152,621 51,058,466 53,040,086 55,100,567 467,129,384 817,057,449 6,917,471 6,516,138 6,482,118 8,088,534 7,028,149 7,040,403 8,474,210 7,845,500 8,058,219 8,259,674 74,710,416 141,791,582 2,511,031 537,271 2,611,520 2,707,775 2,912,040 2,912,040 2,912,040 2,912,040 2,912,040 2,912,040 25,839,837 43,123,197 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 48,579,457 47,713,791 51,323,129 54,657,010 55,496,715 57,272,032 60,538,871 61,816,006 64,010,345 66,272,281 567,679,637 1,001,972,229 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 0 0 0 0 0 0 0 0 0 0 0 3,365,892
1,169,300 1,167,500 1,169,300 1,169,500 1,168,100 1,165,100 0 0 0 0 7,008,800 22,394,165 3,774,880 3,774,880 3,774,880 3,774,880 3,774,880 3,774,880 3,774,880 3,774,880 3,774,880 3,774,880 37,748,802 58,510,643 20,197,084 20,196,525 20,195,957 20,195,379 20,194,791 20,194,194 20,193,586 20,192,968 20,192,339 20,192,339 201,945,162 379,429,407 16,055,009 16,055,009 16,055,009 16,055,009 16,055,009 16,055,009 16,055,009 16,055,009 16,055,009 16,055,009 160,550,090 185,573,376 1,300,451 1,339,465 1,379,649 1,421,038 1,463,670 1,507,580 1,552,807 1,599,391 1,647,373 1,688,557 14,899,981 26,277,553 741,491 514,844 405,294 1,204,013 1,002,533 623,916 641,824 375,504 568,905 592,475 6,670,799 11,017,178 1,377,427 1,418,750 1,461,313 1,505,152 1,550,306 1,596,816 1,644,720 1,694,062 1,744,884 1,788,506 15,781,935 28,541,457 0 0 0 0 0 0 0 0 0 0 0 202,449
3,751,159 3,777,342 3,286,992 3,117,787 2,962,053 2,864,673 1,825,353 1,719,131 1,472,179 815,600 25,592,269 64,102,391 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 48,366,802 48,244,315 47,728,394 48,442,759 48,171,343 47,782,167 45,688,179 45,410,946 45,455,569 44,907,366 470,197,839 779,414,511 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 0 0 0 0 0 0 0 0 0 0 0 749,050,814
9,745,974 11,625,423 40,523,924 15,709,574 5,583,280 5,635,191 5,842,245 4,106,941 0 0 98,772,550 357,931,665 5,818,647 1,827,252 629,726 6,062,010 1,879,558 937,585 6,252,499 2,066,761 757,738 7,409,680 33,641,455 108,114,412 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 15,564,621 13,452,675 41,153,651 21,771,584 7,462,837 6,572,776 12,094,743 6,173,701 757,738 7,409,680 132,414,006 1,215,096,891 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 112,510,879 109,410,781 140,205,174 124,871,353 111,130,895 111,626,975 118,321,794 113,400,653 110,223,651 118,589,327 1,170,291,482 2,996,483,631 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 20,197,084 20,196,525 20,195,957 20,195,379 20,194,791 20,194,194 20,193,586 20,192,968 20,192,339 20,192,339 20,192,339 20,192,339 9,787,739 10,165,096 10,557,373 10,965,175 11,389,131 11,829,897 12,288,155 12,764,616 13,260,021 13,775,142 13,775,142 13,775,142 11,523,086 11,753,548 11,988,619 12,108,505 12,229,590 12,351,886 12,475,405 12,606,272 12,738,512 12,872,139 12,872,139 12,872,139 8,615,146 20,612,810 4,607,123 4,591,287 19,738,769 36,160,513 47,529,207 65,671,104 88,944,121 105,752,172 105,752,172 105,752,172 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 50,123,054 62,727,978 47,349,072 47,860,346 63,552,282 80,536,490 92,486,353 111,234,960 135,134,994 152,591,792 152,591,792 152,591,792 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 0 0 0 0 0 0 0 0 0 0 0 0
=========== =========== =========== =========== =========== =========== =========== =========== =========== =========== ============ ============
4.0% 2.0% 2.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0%
2.0% 2.0% 2.0% 2.0% 1.0% 1.0% 1.0% 1.0% 1.0%
CITY OF SUNNYVALE
6080. WASTEWATER MANAGEMENT FUND
JULY 1, 2035 TO JUNE 30, 2045
LONG TERM FINANCIAL PLAN
Attachment 5