FY 2022/2023
TO
ACTUAL CURRENT PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2032/2033 2021/2022 2022/2023 2023/2024 2024/2025 2025/2026 2026/2027 2027/2028 2028/2029 2029/2030 2030/2031 2031/2032 2032/2033 TOTAL -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- RESERVE/FUND BALANCE, JULY 1 76,835,656 105,916,005 67,733,362 110,919,630 88,583,081 114,654,933 74,679,341 47,959,644 57,789,643 54,891,119 46,851,486 46,456,889 105,916,005 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- CURRENT RESOURCES:
Service Fees 47,393,693 48,904,704 53,306,127 57,304,087 61,458,633 65,146,151 68,403,459 71,139,597 73,273,785 75,471,998 77,736,158 83 ,955,051 736,099,750 Connection and Development Fees 22,042,637 8,736,140 8,998,224 4,634,085 4,773,108 4,916,301 5,063,790 5,215,704 5,372,175 5,533,340 5, 644,007 5,813,327 64,700,203 Other Revenues 243,062 245,159 259,254 272,934 287,151 300,198 312,479 323,800 333,991 344,525 355,414 374,441 3,409,347 Interest Income 1,465,795 2,169,678 1,611,520 2,416,225 2,125,787 2,519,368 1,522,688 1,265,752 1,339,219 1,254,418 1,560,427 1,566,337 1 9,351,419 Transfer From Solid Waste Management Fund 243,61 600000000000 0 State Revolving Fund Loan 6,147,431 11,057,0990000000000 1 1,057,099 WIFIA Loan 2,058,331 8,826,442 27,193,924 59,214,944 123,218,00 20000000 218,453,312 SRF 2 0 158,358,978 43,686,482 59,331,332 40,723,20 80000000 302,100,000 Bond Proceeds 00000000000 111,658,624 111,658,624
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- TOTAL CURRENT RESOURCES 79,594,565 238,298,200 135,055,531 183,173,607 232,585,889 72,882,019 75,302,416 77,944,853 80,319,170 82,604,282 85,296,007 203,367,780 1,466,829,754 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- TOTAL AVAILABLE RESOURCES 156,430,221 344,214,204 202,788,894 294,093,238 321,168,970 187,536,952 149,981,757 125,904,497 138,108,814 137 ,495,401 132,147,493 249,824,669 1,572,745,759 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- CURRENT REQUIREMENTS:
OPERATING REQUIREMENTS:
Operations 18,013,023 20,827,169 23,887,327 23,797,344 24,560,028 25,352,486 26,187,302 27,039,058 27,920,951 28,843,189 29,773,184 3 0,853,117 289,041,155 In-Lieu Charges and Fund Transfers 4,101,976 3,890,518 4,050,535 4,459,430 4,106,293 5,193,157 5,916,943 4,332,504 4,983,566 5,443, 005 4,571,218 5,343,304 52,290,472 Project Operating 0 28,743 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 14,905,306 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- TOTAL CURRENT OPERATING REQUIREMENTS 22,114,999 24,746,429 27,962,720 28,285,749 28,691,476 32,274,982 33,929,776 33,481,287 35,110,4 43 36,496,329 36,650,751 38,606,992 356,236,934 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- NON-OPERATING REQUIREMENTS:
Interfund Loan Repayment 949,615 949,615 949,615 949,615 949,615 949,615 517,04 600000 5 ,265,121 2017 Wastewater Revenue Bonds Debt Service 2,005,933 2,012,416 2,010,416 2,011,095 2,015,020 2,015,750 1,169,000 1,171,000 1,166,2 50 1,170,000 1,171,750 1,166,500 17,079,197 WIFIA Loan Debt Service 00000000 1 ,887,440 3,774,880 3,774,880 3,774,880 13,212,080 State Revolving Fund Loan Debt Service 0 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,44 8,704 17,448,173 126,944,236 Other Debt Service 00000000000 858,912 858,912
Water Pollution Control Plant Rent 826,367 842,894 859,752 885,545 912,111 939,474 967,659 996,688 1,026,589 1,057,387 1,604,283 1,68 0,755 11,773,138 Transfer To Water Supply and Distribution Fund 00000000 106,925000 106,925 Wastewater Equipment Replacement 69,098 464,900 577,773 514,411 638,465 358,768 574,108 793,935 1,184,528 541,899 687,841 773,705 7,110,333 Transfer To General Fund - Civic Center Rent 0 554,285 1,125,198 1,158,954 1,193,723 1,229,535 1,266,421 1,304,413 1,343,546 1,383, 852 1,425,368 1,468,129 13,453,424 Transfer To General Fund - Projects 00000000 7 3,603 128,846 0 0 202,449 Transfer To Employee Benefits Fund 3,640,208 3,007,206 3,025,062 3,131,860 3,239,889 3,387,673 3,526,667 3,615,833 3,750,398 3,927, 910 3,493,717 3,532,447 37,638,662 Budget Supplements 0 80,00 00000000000 8 0,000
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- TOTAL NON-OPERATING REQUIREMENTS 7,491,221 7,911,317 14,903,073 13,949,337 14,246,209 14,177,721 25,471,642 25,332,114 27,989,019 29,434,000 29,606,543 30,703,501 233,724,476 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- CAPITAL AND INFRASTRUCTURE REQ.:
Projects - Revenue Funded 8,345,629 22,660,381 6,855,191 10,084,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 94,379,868
Sunnyvale Clean Water Program 12,562,368 221,162,715 42,148,279 153,190,649 157,701,394 53,808,419 29,697,437 6,763,687 13,409,039 17,123,833 17,520,598 132,604,587 845,130,637 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- TOTAL CAPITAL AND INFRASTRUCTURE REQ. 20,907,997 243,823,096 49,003,470 163,275,071 163,576,352 66,404,908 42,620,696 9,301,452 20,11 8,232 24,713,585 19,433,310 137,240,333 939,510,505 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- TOTAL CURRENT REQUIREMENTS 50,514,217 276,480,842 91,869,264 205,510,157 206,514,037 112,857,611 102,022,113 68,114,854 83,217,694 90,643 ,915 85,690,603 206,550,826 1,529,471,916 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- RESERVES:
Debt Service 5,270,934 5,270,934 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,4 25,258 17,425,258 Contingencies 4,503,256 5,206,792 5,971,832 5,949,336 6,140,007 6,338,122 6,546,826 6,759,764 6,980,238 7,210,797 7,443,296 7,713,279 7,7 13,279 Capital and Infrastructure Reserve 4,739,369 4,890,470 5,330,613 5,730,409 6,145,863 6,514,615 6,840,346 7,113,960 7,327,378 7,547,200 7,773,616 8,395,505 8,395,505 Rate Stabilization Reserve 91,402,446 52,365,166 82,191,928 59,478,078 84,943,805 44,401,347 17,147,215 26,490,661 23,158,245 14,668,231 13,814,719 9,739,801 9,739,801 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- TOTAL RESERVES 105,916,005 67,733,362 110,919,630 88,583,081 114,654,933 74,679,341 47,959,644 57,789,643 54,891,119 46,851,486 46,456,889 43,273,843 43,273,843 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- FUND BALANCE, JUNE 30 000000000000 0
============ ============ ============ ============ ============ ============ ============ ============ ============ ============ ============ ============ ============= STATISTICS:
Sewer Rate Increase 4.0% 3.0% 9.0% 7.5% 7.3% 6.0% 5.0% 4.0% 3.0% 3.0% 3.0% 8.0% Prior Year Sewer Rate Increase 4.0% 3.0% 2.5% 2.5% 2.5% 3.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% JULY 1, 2022 TO JUNE 30, 2033
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
Transfer From Solid Waste Management Fund
State Revolving Fund Loan
WIFIA Loan
SRF 2
Bond Proceeds
TOTAL CURRENT RESOURCES
TOTAL AVAILABLE RESOURCES
CURRENT REQUIREMENTS:
OPERATING REQUIREMENTS:
Operations
In-Lieu Charges and Fund Transfers
Project Operating
TOTAL CURRENT OPERATING REQUIREMENTS
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
Budget Supplements
TOTAL NON-OPERATING REQUIREMENTS
CAPITAL AND INFRASTRUCTURE REQ.:
Projects - Revenue Funded
Sunnyvale Clean Water Program
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 2033/2034 FY 2022/2023
TO TO
PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2042/2043 FY 2042/2043 2033/2034 2034/2035 2035/2036 2036/2037 2037/2038 2038/2039 2039/2040 2040/2041 2041/2042 2042/2043 TOTAL TOTAL -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 43,273,843 30,856,946 37,680,931 50,578,634 58,108,867 32,958,865 40,460,194 66,789,660 96,511,322 124,672,720 43,273,843 105,916,005 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 86,473,702 89,067,914 91,294,611 93,120,504 94,982,914 96,882,572 98,820,223 100,796,628 102,812,560 104,868,812 959,120,440 1,695,220,190 5,987,727 6,167,359 6,352,380 6,542,951 6,739,240 6,941,417 7,149,659 7,364,149 7,585,074 7,812,626 68,642,582 133,342,786 385,498 396,897 407,672 417,754 428,112 438,756 449,695 460,937 472,491 484,369 4,342,181 7,751,529 1,650,599 1,330,624 1,428,964 1,818,437 2,060,178 1,322,447 1,735,789 2,462,411 3,152,529 4,017,502 20,979,480 40,330,899 0000000000 0 0
0000000000 0 1 1,057,099
0000000000 0 218,453,312
0000000000 0 302,100,000
144,482,752000000000 144,482,752 256,141,376
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 238,980,278 96,962,794 99,483,627 101,899,646 104,210,444 105,585,192 108,155,367 111,084,125 114,022,655 117,183,309 1,197,567,436 2,664,397,190 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 282,254,122 127,819,740 137,164,558 152,478,280 162,319,311 138,544,058 148,615,560 177,873,784 210,533,977 241,856,029 1,240,841,279 2,770,313,195 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 18,516,902 19,144,427 19,793,506 20,464,885 21,159,333 21,877,646 22,620,648 23,389,193 24,184,162 25,006,468 216,157,170 505,198,325 5,554,589 4,674,252 5,631,227 5,153,347 5,057,763 6,600,143 5,473,154 5,416,007 6,777,637 5,942,375 56,280,494 108,570,966 2,406,797 2,511,031 537,271 2,611,520 2,707,775 2,912,040 555,30 3000 1 4,241,737 29,147,043 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 26,478,288 26,329,710 25,962,005 28,229,752 28,924,871 31,389,829 28,649,105 28,805,200 30,961,799 30,948,843 286,679,401 642,916,335 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 0000000000 0 5 ,265,121
1,164,500 1,169,300 1,167,500 1,169,300 1,169,500 1,168,100 1,165,100 5,500 5,500 5,500 8,189,800 25,268,997 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 50,960,880 17,447,633 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 174,450,456 301,394,692 8,109,365 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 152,604,446 153,463,358 1,760,882 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 33,885,456 45,658,594 000000 143,638 143,638 143,638 143,638 574,551 681,476
509,943 492,791 439,711 830,417 1,862,666 529,526 535,793 583,537 0 0 5,784,384 12,894,717 1,512,173 1,557,538 1,604,264 1,652,392 1,701,964 1,753,022 1,805,613 1,859,781 1,915,574 1,973,042 17,335,363 30,788,787 0000000000 0 202,449
3,683,268 3,840,012 3,922,571 3,566,555 2,756,345 2,446,472 2,268,841 2,083,585 667,310 667,310 25,902,269 63,540,931 0000000000 0 8 0,000
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 37,962,644 46,181,453 47,677,699 47,915,357 48,347,433 46,921,910 47,119,532 46,060,644 44,116,007 44,172,846 456,475,525 690,200,002 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 5,655,859 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 31,663,091 126,042,959 181,300,384 16,874,640 8,008,891 16,447,053 51,508,416 13,760,114 4,377,706 4,447,527 4,580,952 4,580,952 305,886,635 1,151,017,272 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 186,956,243 17,627,645 12,946,220 18,224,304 52,088,142 19,772,125 6,057,264 6,496,619 10,783,451 6,597,713 337,549,726 1,277,060,231 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 251,397,176 90,138,809 86,585,924 94,369,413 129,360,445 98,083,864 81,825,901 81,362,462 85,861,257 81,719,401 1,080,704,652 2,610,176,56 7 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 17,425,258 4,629,225 4,786,107 4,948,377 5,116,221 5,289,833 5,469,411 5,655,162 5,847,298 6,046,040 6,251,617 6,251,617 6,251,617 8,647,370 8,906,791 9,129,461 9,312,050 9,498,291 9,688,257 9,882,022 10,079,663 10,281,256 10,486,881 10,486,881 10,486,881 155,092 6,562,775 19,075,538 26,255,337 745,483 7,877,267 33,827,217 63,159,103 90,920,165 125,972,871 125,972,871 125,972,871 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 30,856,946 37,680,931 50,578,634 58,108,867 32,958,865 40,460,194 66,789,660 96,511,322 124,672,720 160,136,628 160,136,628 160,136,628 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- 0000000000 0 0
============ ============ ============ ============ ============ ============ ============ ============ ============ ============ ============= =============
3.0% 3.0% 2.5% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0%
4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 3.0% 3.0% 3.0%
CITY OF SUNNYVALE
6080. WASTEWATER MANAGEMENT FUND
JULY 1, 2033 TO JUNE 30, 2043
LONG TERM FINANCIAL PLAN
Attachment 5