RESERVE/FUND BALANCE, JULY 1
CURRENT RESOURCES:
Service Fees
Connection and Development Fees
Other Revenues
Interest Income
Transfer From General Fund (Storm Sewer)
Transfer From Solid Waste Management Fund
State Revolving Fund Loan
WIFIA Loan
WIFIA Related Bonds
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
WIFIA Related Bonds 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 Solid Waste Management Fund
Transfer To Employee Benefits Fund
Budget Supplements
TOTAL NON-OPERATING REQUIREMENTS
CAPITAL AND INFRASTRUCTURE REQ.:
Projects - Revenue Funded
Replacement of WPCP
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 2021/2022
TO
ACTUAL CURRENT BUDGET PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2031/2032 2020/2021 2021/2022 2022/2023 2023/2024 2024/2025 2025/2026 2026/2027 2027/2028 2028/2029 2029/2030 2030/2031 2031/2032 TOTAL -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 62,956,825 76,589,386 59,668,234 75,595,577 61,167,483 61,906,869 78,379,187 83,191,489 82,112,545 82,838,440 68,197,979 56,384,835 76,589,386 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 44,654,833 45,831,419 47,228,819 48,668,826 50,152,738 51,681,895 53,257,676 54,881,503 56,554,840 58,844,745 61,227,369 63,706,465 592,036,297 5,562,116 15,000,000 4,000,000 4,120,000 4,243,600 4,370,908 4,502,035 4,637,096 4,776,209 4,919,495 5,067,080 5,168,422 60,804,846 66,174 1,183,143 3,720,607 3,770,195 212,630 219,319 226,240 233,404 240,819 249,738 259,018 268,671 10,583,783 1,157,988 1,593,072 1,326,537 1,541,855 1,215,309 1,277,129 1,459,495 1,734,572 1,713,300 1,529,071 1,311,055 1,423,948 16,125,343 62,960 0 0 0 0 0 0 0 0 0 0 0 0
404,745 243,614 0 0 0 0 0 0 0 0 0 0 243,614
23,879,876 13,528,590 4,970,000 0 0 0 0 0 0 0 0 0 18,498,590 127,353 10,740,974 46,463,764 110,652,366 49,674,590 2,979,947 0 0 0 0 0 0 220,511,642 0 14,331,618 2,051,904 5,057,870 47,861,822 46,757,275 26,086,740 1,262,486 0 0 0 0 143,409,715 0 0 4,879,004 8,083,245 0 0 0 0 0 0 0 0 12,962,249
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 75,916,044 102,452,431 114,640,635 181,894,357 153,360,690 107,286,473 85,532,186 62,749,061 63,285,168 65,543,050 67,864,522 70,567,507 1,075,176,080 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 138,872,869 179,041,817 174,308,868 257,489,934 214,528,173 169,193,341 163,911,373 145,940,550 145,397,713 148,381,490 136,062,501 126,952,342 1,151,765,466 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 18,738,943 18,989,800 20,886,732 21,510,025 21,604,782 22,306,193 23,036,269 23,806,323 24,591,482 25,404,825 26,256,114 27,114,033 255,506,578 3,793,711 4,121,951 3,890,518 4,558,736 4,659,546 3,823,540 4,605,671 4,138,647 4,088,506 4,838,773 4,611,395 4,487,819 47,825,101 0 24,631 28,743 24,858 28,975 25,155 29,339 25,530 29,725 25,927 30,135 26,349 299,367 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 22,532,655 23,136,383 24,805,992 26,093,619 26,293,303 26,154,888 27,671,279 27,970,499 28,709,713 30,269,524 30,897,644 31,628,202 303,631,045 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 949,615 949,615 949,615 949,615 949,615 949,615 949,615 517,046 0 0 0 0 6,214,736 2,006,480 1,992,054 2,006,916 2,004,916 2,005,595 2,009,520 2,010,250 1,163,500 1,165,500 1,160,750 1,164,500 1,166,250 17,849,751 0 0 0 0 0 0 0 0 0 1,887,440 3,774,880 3,774,880 9,437,200 0 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 57,980,274 0 0 2,508,583 2,582,946 4,589,390 8,884,682 10,991,716 11,443,963 12,248,453 13,618,226 13,622,786 13,627,561 94,118,307 497,204 0 1,093,208 1,406,963 1,929,970 2,489,315 2,490,085 2,574,172 3,361,348 4,728,247 4,729,797 4,731,423 29,534,528 810,163 826,366 842,894 859,751 885,544 912,110 939,474 967,658 996,688 1,026,588 1,057,386 1,604,283 10,918,741 0 0 0 0 0 0 0 0 0 106,925 0 0 106,925
191,546 477,207 464,900 577,773 514,411 638,465 358,768 574,108 793,935 1,184,528 541,899 687,841 6,813,835 0 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 11,985,295 0 72,455 0 0 0 0 0 0 0 73,603 128,846 0 274,904
984 0 0 0 0 0 0 0 0 0 0 0 0
893,768 3,588,214 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 37,694,429 0 0 80,000 0 0 0 0 0 0 0 0 0 80,000
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 5,349,759 13,176,844 16,778,541 17,803,159 20,436,273 25,588,254 27,628,050 27,304,469 28,757,104 34,151,185 35,602,791 35,782,256 283,008,925 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 6,944,338 22,880,723 6,706,281 11,165,062 8,281,436 2,579,377 8,091,044 939,907 552,617 5,978,163 2,698,280 1,160,021 71,032,912 27,456,731 60,179,633 50,422,477 141,260,611 97,610,294 36,491,635 17,329,512 7,613,131 4,539,839 9,784,638 10,478,951 12,125,317 447,836,038 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 34,401,069 83,060,356 57,128,759 152,425,673 105,891,730 39,071,013 25,420,556 8,553,037 5,092,456 15,762,801 13,177,231 13,285,338 518,868,950 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 62,283,483 119,373,583 98,713,292 196,322,451 152,621,305 90,814,155 80,719,884 63,828,005 62,559,273 80,183,511 79,677,666 80,695,796 1,105,508,920 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 4,684,736 4,747,450 5,221,683 5,377,506 5,401,195 5,576,548 5,759,067 5,951,581 6,147,870 6,351,206 6,564,029 6,778,508 6,778,508 4,465,483 4,583,142 4,722,882 4,866,883 5,015,274 5,168,190 5,325,768 2,744,075 2,827,742 2,942,237 3,061,368 3,185,323 3,185,323 62,168,233 45,066,708 60,380,078 45,652,160 46,219,465 62,363,515 66,835,720 68,145,955 68,591,893 53,633,602 41,488,504 31,021,780 31,021,780 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 76,589,386 59,668,234 75,595,577 61,167,483 61,906,869 78,379,187 83,191,489 82,112,545 82,838,440 68,197,979 56,384,835 46,256,546 46,256,546 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- 0 0 0 0 0 0 0 0 0 0 0 0 0
=========== =========== =========== =========== =========== =========== =========== =========== =========== =========== =========== =========== ============
4.0% 4.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 4.0% 4.0% 4.0%
4.0% 4.0% 3.0% 2.5% 2.5% 2.5% 3.0% 4.0% 4.0% 4.0% 4.0% 4.0% JULY 1, 2021 TO JUNE 30, 2032
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 General Fund (Storm Sewer)
Transfer From Solid Waste Management Fund
State Revolving Fund Loan
WIFIA Loan
WIFIA Related Bonds
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
WIFIA Related Bonds 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 Solid Waste Management Fund
Transfer To Employee Benefits Fund
Budget Supplements
TOTAL NON-OPERATING REQUIREMENTS
CAPITAL AND INFRASTRUCTURE REQ.:
Projects - Revenue Funded
Replacement of WPCP
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 2032/2033 FY 2021/2022
TO TO
PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2041/2042 FY 2041/2042 2032/2033 2033/2034 2034/2035 2035/2036 2036/2037 2037/2038 2038/2039 2039/2040 2040/2041 2041/2042 TOTAL TOTAL -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 46,256,546 55,296,039 39,126,409 43,496,501 51,999,947 51,834,871 34,771,438 35,978,343 49,946,944 66,471,427 46,256,546 76,589,386 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 66,285,940 68,969,858 71,762,447 74,668,109 76,944,740 79,290,785 81,708,361 84,199,649 86,766,896 89,412,419 780,009,202 1,372,045,499 5,323,475 5,483,179 5,647,674 5,817,104 5,991,618 6,171,366 6,356,507 6,547,202 6,743,618 6,945,927 61,027,670 121,832,517 278,744 289,225 300,132 311,483 321,654 332,192 343,110 354,424 366,149 378,302 3,275,414 13,859,197 1,273,885 1,747,136 1,355,772 1,388,771 1,518,253 1,595,621 1,073,743 1,285,098 1,684,966 2,234,391 15,157,636 31,282,979 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 243,614
0 0 0 0 0 0 0 0 0 0 0 18,498,590
0 0 0 0 0 0 0 0 0 0 0 220,511,642
0 0 0 0 0 0 0 0 0 0 0 143,409,715
80,781,685 80,781,685 0 0 0 0 0 0 0 0 161,563,370 174,525,619 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 153,943,729 157,271,082 79,066,025 82,185,467 84,776,264 87,389,963 89,481,721 92,386,373 95,561,630 98,971,039 1,021,033,292 2,096,209,372 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 200,200,274 212,567,122 118,192,434 125,681,968 136,776,211 139,224,835 124,253,159 128,364,716 145,508,574 165,442,466 1,067,289,838 2,172,798,758 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 17,128,299 17,708,709 18,309,063 18,930,051 19,572,385 20,236,802 20,924,066 21,634,964 22,370,316 23,130,965 199,945,621 455,452,198 6,351,747 4,838,874 5,128,917 5,756,221 5,028,074 5,030,684 7,013,414 5,497,014 5,425,038 5,556,180 55,626,163 103,451,264 30,570 26,797 31,031 27,271 31,520 27,775 32,040 555,303 0 0 762,307 1,061,674 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 23,510,616 22,574,380 23,469,012 24,713,543 24,631,979 25,295,261 27,969,520 27,687,281 27,795,354 28,687,145 256,334,091 559,965,136 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 0 0 0 0 0 0 0 0 0 0 0 6,214,736
1,161,000 1,159,000 1,163,800 1,162,000 1,163,800 129,000 129,000 129,000 129,000 129,000 6,454,600 24,304,351 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 47,186,002 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 52,709,340 110,689,614 13,632,560 13,637,796 13,643,278 14,270,416 18,717,844 18,725,521 18,733,558 18,741,972 18,750,782 18,750,782 167,604,508 261,722,815 4,733,126 4,734,910 4,736,780 5,360,138 9,803,608 9,807,143 9,810,844 9,814,720 9,818,778 9,818,778 78,438,826 107,973,354 1,680,755 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 31,455,083 42,373,824 0 0 0 0 0 0 0 143,638 143,638 143,638 430,913 537,838
773,705 509,943 492,791 439,711 830,417 1,862,666 529,526 535,793 583,537 0 6,558,089 13,371,924 1,468,129 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 16,830,450 28,815,745 0 0 0 0 0 0 0 0 0 0 0 274,904
0 0 0 0 0 0 0 0 0 0 0 0
3,532,447 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 28,767,407 66,461,836 0 0 0 0 0 0 0 0 0 0 0 80,000
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 36,027,536 36,043,786 36,324,853 39,072,153 48,201,277 47,610,142 46,198,346 46,411,856 46,526,044 44,582,025 426,998,018 710,006,943 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 7,651,146 1,534,676 2,811,923 4,956,644 1,694,585 898,978 6,061,832 1,576,548 2,103,579 563,285 29,853,196 100,886,108 77,714,937 113,287,870 12,090,145 4,939,681 10,413,498 30,649,016 8,045,118 2,742,087 2,612,170 2,690,535 265,185,056 713,021,094 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 85,366,083 114,822,546 14,902,069 9,896,325 12,108,083 31,547,993 14,106,950 4,318,635 4,715,748 3,253,820 295,038,252 813,907,202 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 144,904,235 173,440,712 74,695,933 73,682,021 84,941,340 104,453,397 88,274,816 78,417,772 79,037,146 76,522,989 978,370,361 2,083,879,281 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 5,270,934 4,282,075 4,427,177 4,577,266 4,732,513 4,893,096 5,059,201 5,231,016 5,408,741 5,592,579 5,782,741 5,782,741 5,782,741 3,314,297 3,448,493 3,588,122 3,733,405 3,847,237 7,929,078 8,170,836 8,419,965 8,676,690 8,941,242 8,941,242 8,941,242 42,428,733 25,979,805 30,060,179 38,263,095 37,823,604 16,512,225 17,305,557 30,847,304 46,931,225 68,924,560 68,924,560 68,924,560 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 55,296,039 39,126,409 43,496,501 51,999,947 51,834,871 34,771,438 35,978,343 49,946,944 66,471,427 88,919,477 88,919,477 88,919,477 -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------- --------------------- 0 0 0 0 0 0 0 0 0 0 0 0
=========== =========== =========== =========== =========== =========== =========== =========== =========== =========== ============ ============
4.0% 4.0% 4.0% 4.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0%
4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 3.0% 3.0%
CITY OF SUNNYVALE
6080. WASTEWATER MANAGEMENT FUND
JULY 1, 2032 TO JUNE 30, 2042
LONG TERM FINANCIAL PLAN
Attachment 5