RESERVE/FUND BALANCE, JULY 1
CURRENT RESOURCES:
Service Fees
Connection and Development Fees
Other Revenues
Interest Income
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
Transfer To Water Supply and Distribution Fund
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
Projects - Revenue Funded
Sunnyvale Cleanwater Program PAYGO
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 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 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 105,916,005 102,283,422 95,675,469 70,117,079 61,247,926 47,443,347 34,129,911 29,431,778 28,129,935 25,550,249 28,668,232 32,628,806 102,283,422 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 48,845,547 52,276,444 57,006,939 62,165,497 67,790,853 73,925,247 78,396,985 82,355,249 86,513,365 90,881,425 99,105,285 104,109,111 854,526,400 10,079,647 3,000,000 2,300,000 1,591,350 1,639,091 1,688,263 1,738,911 1,791,078 1,844,811 1,900,155 1,957,160 2,015,875 21,466,694 868,829 900,870 260,408 274,606 289,893 306,363 319,240 331,052 343,371 356,221 377,623 392,014 4,151,661 2,048,208 1,875,989 4,241,007 3,529,117 2,998,172 1,687,720 1,747,882 1,471,031 1,445,840 1,664,716 1,560,430 1,539,819 23,761,723 0 0 119,766,384 133,917,093 30,024,1170000000 283,707,594 15,077,93900000000000 0
0000000000 111,658,624 144,482,752 256,141,376
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 76,920,170 58,053,302 183,574,738 201,477,663 102,742,126 77,607,593 82,203,018 85,948,410 90,147,387 94,802,517 214,659,122 252,539,570 1,443,755,447 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 182,836,175 160,336,723 279,250,206 271,594,742 163,990,051 125,050,940 116,332,928 115,380,188 118,277,323 120,352,766 243,327,354 285,168,377 1,546,038,868 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 20,313,366 23,888,184 26,368,732 27,332,367 28,161,843 29,064,704 29,994,176 30,934,652 31,899,789 32,897,634 34,009,897 35,235,593 329,787,572 3,862,225 4,110,202 5,482,583 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 64,728,205 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 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 24,175,591 28,023,244 31,880,291 32,436,844 36,081,831 37,797,809 37,484,171 39,197,738 40,652,826 40,913,505 42,934,468 44,396,410 411,799,137 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 949,615 949,615 949,615 949,615 949,615 517,046000000 4 ,315,506 2,009,266 2,010,416 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 16,231,281 0000000 1 ,887,440 3,774,880 3,774,880 3,774,880 3,774,880 16,986,960 0 6,355,257 5,297,857 5,297,385 5,296,905 17,450,741 17,450,245 17,449,740 17,449,226 17,448,704 17,448,173 17,447,633 144,391,869 0000000000 858,912 8,109,365 8,968,277
842,894 859,752 885,544 912,111 939,474 967,658 996,688 1,026,589 1,057,386 1,604,283 1,680,755 1,760,882 12,691,123 0000000 106,925 0 0 0 0 106,925
384,701 577,773 514,411 638,465 358,768 574,108 793,935 1,184,528 541,899 687,841 773,705 509,943 7,155,376 277,143 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 12,547,412 0000000 7 3,603 128,846 0 0 0 202,449
3,216,560 3,248,292 3,359,454 3,496,089 3,443,770 3,585,335 3,734,966 3,885,635 4,050,244 3,426,435 3,560,281 3,700,683 39,491,185 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 7,680,179 15,126,304 14,027,766 14,333,621 14,059,966 25,351,242 25,266,808 27,934,283 29,360,663 29,337,719 30,523,747 37,766,244 263,088,362 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 0 0 119,766,384 133,917,093 30,024,11700000 111,658,624 144,482,852 539,849,070 6,666,662 21,511,707 10,034,421 5,874,958 12,596,489 12,923,259 2,537,766 6,709,193 7,589,752 1,912,712 4,635,746 5,655,859 91,981,862 42,030,322 0 33,424,265 23,784,302 23,784,302 14,848,719 21,612,405 13,409,039 15,123,833 19,520,598 20,945,963 0 186,453,426 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 48,696,984 21,511,707 163,225,071 163,576,352 66,404,908 27,771,978 24,150,171 20,118,232 22,713,585 21,433,310 137,240,333 150,138,711 818,284,358 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 80,552,754 64,661,255 209,133,127 210,346,817 116,546,705 90,921,029 86,901,151 87,250,253 92,727,074 91,684,534 210,698,548 232,301,365 1,493,171,857 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 5,270,934 6,355,257 5,297,857 5,297,385 5,296,905 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 5,078,342 5,972,046 6,592,183 6,833,092 7,040,461 7,266,176 7,498,544 7,733,663 7,974,947 8,224,409 8,502,474 8,808,898 8,808,898 4,884,555 5,227,6440000000000 0
87,049,591 78,120,521 58,227,039 49,117,448 35,105,980 9,412,993 4,482,492 2,945,531 124,560 2,993,082 6,675,591 26,607,372 26,607,372 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 102,283,422 95,675,469 70,117,079 61,247,926 47,443,347 34,129,911 29,431,778 28,129,935 25,550,249 28,668,232 32,628,806 52,867,011 52,867,011 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- 000000000000 0
=========== =========== =========== =========== =========== =========== =========== =========== =========== =========== =========== =========== ============
3.0% 9.0% 9.0% 9.0% 9.0% 9.0% 6.0% 5.0% 5.0% 5.0% 9.0% 5.0%
3.0% 9.0% 7.5% 7.3% 6.0% 5.0% 4.0% 3.0% 3.0% 3.0% 8.0% 3.0% JULY 1, 2023 TO JUNE 30, 2034
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
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
Transfer To Water Supply and Distribution Fund
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
Projects - Revenue Funded
Sunnyvale Cleanwater Program PAYGO
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 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 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 52,867,011 64,096,450 71,935,847 73,505,455 41,206,806 40,654,782 55,817,653 71,775,511 83,511,091 100,566,495 52,867,011 102,283,422 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 106,242,307 108,419,212 110,640,721 112,907,750 115,221,230 117,582,113 118,815,549 120,061,924 121,321,374 122,594,035 1,153,806,213 2,008,332,613 2,076,351 2,138,641 2,202,801 2,268,885 2,336,951 2,407,060 2,479,271 2,553,650 2,630,259 2,709,167 23,803,035 45,269,729 400,162 408,481 416,975 425,648 434,503 443,544 450,189 456,947 463,822 470,816 4,371,087 8,522,748 2,101,703 2,328,488 2,619,976 2,700,443 1,584,900 1,753,263 2,220,088 2,565,788 3,062,547 3,557,297 24,494,493 48,256,216 0000000000 0 283,707,594
0000000000 0 0
0000000000 0 256,141,376
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 110,820,523 113,294,822 115,880,473 118,302,725 119,577,584 122,185,979 123,965,097 125,638,309 127,478,002 129,331,314 1,206,474,828 2,650,230,275 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 163,687,534 177,391,273 187,816,320 191,808,180 160,784,389 162,840,761 179,782,750 197,413,820 210,989,093 229,897,809 1,259,341,840 2,752,513,697 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 36,508,181 37,829,543 39,201,639 40,626,510 42,106,282 43,643,172 45,239,486 46,897,631 48,620,111 50,409,536 431,082,092 760,869,664 5,920,966 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 72,371,708 137,099,914 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 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 44,940,179 45,284,286 48,329,297 49,816,402 53,106,857 53,583,361 55,191,929 58,283,881 59,377,651 61,379,795 529,293,638 941,092,775 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 0000000000 0 4 ,315,506
1,169,300 1,167,500 1,169,300 1,169,500 1,168,100 1,165,1000000 7 ,008,800 23,240,081 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,800 54,735,760 17,447,084 17,446,525 17,445,957 17,445,379 17,444,791 17,444,194 17,443,586 17,442,968 17,442,339 17,442,339 174,445,162 318,837,031 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 169,518,367 1,844,839 3,267,239 3,420,847 3,581,690 3,750,110 3,926,465 4,111,128 4,111,128 4,111,128 4,111,128 36,235,702 48,926,825 00000 143,638 143,638 143,638 143,638 143,638 718,189 825,114 492,791 439,711 830,417 1,862,666 529,526 535,793 583,537 0 0 0 5,274,441 12,429,817 1,337,308 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 15,330,737 27,878,149 0000000000 0 202,449
3,714,683 3,696,629 3,642,105 3,346,394 3,023,058 2,787,099 2,610,097 1,663,054 1,226,178 1,095,499 26,804,795 66,295,980 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 45,835,894 47,224,920 47,757,264 48,696,830 47,250,626 47,382,483 46,318,691 44,835,397 44,447,234 44,367,377 464,116,717 727,205,079 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 0000000000 0 539,849,070
753,005 4,937,329 1,777,252 579,726 6,012,010 1,679,558 2,049,092 6,202,499 2,016,761 2,016,761 28,023,992 120,005,854 8,062,006 8,008,891 16,447,053 51,508,416 13,760,114 4,377,706 4,447,527 4,580,952 4,580,952 4,580,952 120,354,569 306,807,995 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 8,815,011 12,946,220 18,224,304 52,088,142 19,772,125 6,057,264 6,496,619 10,783,451 6,597,713 6,597,713 148,378,561 966,662,919 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 99,591,083 105,455,426 114,310,866 150,601,374 120,129,608 107,023,108 108,007,239 113,902,729 110,422,598 112,344,885 1,141,788,915 2,634,960,772 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 17,450,741 9,127,045 9,457,386 9,800,410 10,156,627 10,526,571 10,910,793 11,309,872 11,724,408 12,155,028 12,602,384 12,602,384 12,602,384 0000000000 0 0
37,518,664 45,027,720 46,254,304 13,599,437 12,677,470 27,456,119 43,014,898 54,335,942 70,960,726 87,499,799 87,499,799 87,499,799 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 64,096,450 71,935,847 73,505,455 41,206,806 40,654,782 55,817,653 71,775,511 83,511,091 100,566,495 117,552,925 117,552,925 117,552,925 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 0000000000 0 0
=========== =========== =========== =========== =========== =========== =========== =========== =========== =========== ============ ============
2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 1.0% 1.0% 1.0% 1.0%
3.0% 2.5% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0%
CITY OF SUNNYVALE
6080. WASTEWATER MANAGEMENT FUND
JULY 1, 2034 TO JUNE 30, 2044
LONG TERM FINANCIAL PLAN
Attachment 5