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
In-Lieu Charges
TOTAL OPERATING REQUIREMENTS
NON-OPERATING REQUIREMENTS:
Debt Service
Transfer To Employee Benefits Fund
Transfer To General Fund
Transfer To General Services Fund
Transfer To Infrastructure Fund
Transfer To Solid Waste Fund
TOTAL NON-OPERATING REQUIREMENTS
CAPITAL AND INFRASTRUCTURE REQ.:
Projects - Revenue Funded
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 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 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 69,758,151 82,226,058 84,169,046 83,043,789 79,841,992 76,877,983 71,978,337 73,739,919 66,647,055 63,639,021 58,792,646 60,494,597 82,226,058 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 57,379,901 52,633,221 54,236,788 57,173,117 60,196,938 63,386,972 67,274,371 71,412,392 75,817,754 80,508,317 85,503,159 90,822,660 758,965,688 4,013,766 8,847,615 2,981,942 3,010,649 3,094,647 3,181,038 3,269,892 3,361,281 3,455,276 3,551,955 3,651,394 3,753,675 42,159,365 39,513 80,000 231,594 240,618 250,071 259,975 271,391 283,443 296,174 309,623 323,839 338,871 2,885,600 1,385,594 1,650,373 2,025,458 1,947,366 1,507,411 1,411,340 1,445,881 1,306,805 1,247,824 1,152,797 1,186,169 1,057,318 15,938,742 0 0 0 0 0 0 0 0 0 106,924 0 0 106,924
--------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 62,818,774 63,211,209 59,475,782 62,371,750 65,049,067 68,239,325 72,261,535 76,363,921 80,817,028 85,629,617 90,664,561 95,972,524 820,056,319 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 132,576,926 145,437,267 143,644,829 145,415,540 144,891,059 145,117,308 144,239,872 150,103,840 147,464,084 149,268,638 149,457,208 156,467,121 902,282,378 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 6,946,931 7,409,554 8,420,157 8,645,538 8,912,021 9,187,007 9,464,755 9,751,070 10,046,221 10,350,488 10,664,159 10,987,530 103,838,499 35,397,728 31,534,273 35,848,516 41,155,079 44,488,414 47,354,961 51,013,267 55,863,594 59,664,128 62,249,367 66,769,186 71,112,941 567,053,725 4,405,981 5,362,433 5,110,207 5,371,125 5,391,879 5,878,979 4,877,914 6,372,658 6,048,688 6,286,582 5,582,366 7,129,051 63,411,882 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 46,750,639 44,306,259 49,378,880 55,171,742 58,792,314 62,420,947 65,355,936 71,987,322 75,759,037 78,886,438 83,015,711 89,229,522 734,304,106 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 1,877,843 1,148,493 1,148,560 1,147,152 1,149,729 1,146,463 1,153,476 1,153,100 1,155,100 1,155,350 1,153,850 1,150,600 12,661,871 581,539 1,553,477 1,350,408 1,357,552 1,403,475 1,449,850 1,515,541 1,577,413 1,617,523 1,676,367 1,753,932 1,563,987 16,819,525 0 45,284 323,471 656,645 676,345 696,635 717,534 739,060 761,232 784,069 875,599 950,620 7,226,494 0 0 117,800 0 0 0 0 0 0 0 0 0 117,800
611 4,915 5,063 5,215 483,010 5,532 194,638 21,754 6,045 6,227 6,414 6,606 745,418 2,223 66,247 68,235 70,282 72,390 74,562 76,799 79,103 83,920 86,438 89,031 91,702 858,709 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 2,462,216 2,818,415 3,013,536 3,236,845 3,784,949 3,373,042 3,657,988 3,570,430 3,623,820 3,708,451 3,878,826 3,763,515 38,429,817 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 1,138,012 14,143,546 8,208,623 7,164,961 5,435,813 7,344,983 1,486,029 7,899,033 4,442,206 7,881,103 2,068,074 9,550,851 75,625,223 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 1,138,012 14,143,546 8,208,623 7,164,961 5,435,813 7,344,983 1,486,029 7,899,033 4,442,206 7,881,103 2,068,074 9,550,851 75,625,223 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 50,350,867 61,268,221 60,601,039 65,573,548 68,013,076 73,138,972 70,499,953 83,456,784 83,825,063 90,475,991 88,962,611 102,543,888 848,359,145 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 10,586,165 9,735,957 11,067,168 12,450,154 13,350,109 14,135,492 15,119,506 16,403,666 17,427,587 18,149,964 19,358,336 20,525,118 20,525,118 15,358,295 16,929,230 14,362,581 15,106,096 12,708,331 13,365,597 10,622,348 11,258,567 7,956,920 8,436,990 8,947,839 9,491,521 9,491,521 56,281,599 57,503,860 57,614,040 52,285,742 50,819,544 44,477,248 47,998,065 38,984,822 38,254,513 32,205,693 32,188,422 23,906,594 23,906,594 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 82,226,058 84,169,046 83,043,789 79,841,992 76,877,983 71,978,337 73,739,919 66,647,055 63,639,021 58,792,646 60,494,597 53,923,233 53,923,233 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- 0 0 0 0 0 0 0 0 0 0 0 0 0
============ ============ ============ ============ ============ ============ ============ ============ ============ ============ ============ ============ ============
0.0% 1.5% 3.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0%
0.0% 4.0% 4.0% 4.0% 5.0% 5.0% 5.0% 4.5% 4.5% 4.5% 4.5% 4.5% 6040. WATER SUPPLY AND DISTRIBUTION FUND
JULY 1, 2021 TO JUNE 30, 2032
LONG TERM FINANCIAL PLAN
CITY OF SUNNYVALE
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
In-Lieu Charges
TOTAL OPERATING REQUIREMENTS
NON-OPERATING REQUIREMENTS:
Debt Service
Transfer To Employee Benefits Fund
Transfer To General Fund
Transfer To General Services Fund
Transfer To Infrastructure Fund
Transfer To Solid Waste Fund
TOTAL NON-OPERATING REQUIREMENTS
CAPITAL AND INFRASTRUCTURE REQ.:
Projects - Revenue Funded
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 2031/2032 FY 2021/2022
TO TO
PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN PLAN FY 2040/2041 FY 2040/2041 2032/2033 2033/2034 2034/2035 2035/2036 2036/2037 2037/2038 2038/2039 2039/2040 2040/2041 2041/2042 TOTAL TOTAL --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 53,923,233 57,772,392 53,232,308 59,822,594 57,010,761 65,019,819 64,309,885 72,416,191 67,995,011 72,078,974 53,923,233 82,226,058 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 95,161,831 99,710,190 104,477,897 109,475,611 114,714,510 120,206,320 123,560,015 127,009,609 130,557,895 134,207,750 1,159,081,629 1,918,047,317 3,866,285 3,982,273 4,101,742 4,224,794 4,351,538 4,482,084 4,616,546 4,755,043 4,897,694 5,044,625 44,322,624 86,481,989 352,871 367,480 382,722 398,628 415,228 432,551 444,893 457,594 470,662 484,111 4,206,740 7,092,339 1,409,083 1,298,349 1,459,088 1,390,506 1,585,849 1,568,534 1,766,249 1,658,415 1,758,024 1,817,177 15,711,274 31,650,016 0 0 0 0 0 0 0 143,638 0 0 143,638 250,562
--------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 100,790,071 105,358,293 110,421,449 115,489,539 121,067,124 126,689,489 130,387,703 134,024,298 137,684,275 141,553,662 1,223,465,904 2,043,522,223 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 154,713,303 163,130,684 163,653,757 175,312,133 178,077,886 191,709,308 194,697,589 206,440,489 205,679,286 213,632,636 1,277,389,136 2,125,748,282 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 11,341,486 11,707,028 12,084,539 12,474,417 12,877,072 13,292,928 13,722,424 14,166,013 14,624,164 15,097,360 131,387,433 235,225,931 74,489,295 78,067,199 80,158,082 84,124,050 88,283,306 92,656,564 97,243,078 102,084,756 107,273,167 112,737,258 917,116,756 1,484,170,482 5,665,884 7,643,313 5,854,187 7,866,687 6,120,479 9,274,419 6,828,739 9,294,101 7,195,352 7,378,422 73,121,584 136,533,466 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 91,496,665 97,417,540 98,096,809 104,465,154 107,280,857 115,223,912 117,794,241 125,544,871 129,092,684 135,213,039 1,121,625,773 1,855,929,878 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 1,155,600 1,153,350 1,152,950 1,161,150 1,152,200 127,800 127,800 127,800 127,800 127,800 6,414,250 19,076,121 1,581,972 1,648,981 1,718,593 1,755,783 1,596,863 1,224,443 1,089,141 1,011,627 930,746 311,605 12,869,754 29,689,278 856,773 882,476 908,951 936,219 964,306 993,235 1,023,032 1,048,608 1,074,823 1,101,694 9,790,116 17,016,610 0 0 0 0 0 0 0 0 0 0 0 117,800
6,804 11,415 7,219 24,288 7,658 7,888 8,125 8,368 8,368 8,368 98,502 843,921 94,453 97,286 100,205 103,211 106,307 109,497 112,781 112,781 112,781 112,781 1,062,083 1,920,792 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 3,695,602 3,793,508 3,887,918 3,980,651 3,827,334 2,462,863 2,360,879 2,309,184 2,254,518 1,662,247 30,234,705 68,664,522 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 1,748,645 8,687,328 1,846,435 9,855,566 1,949,876 9,712,647 2,126,278 10,591,423 2,253,111 2,253,111 51,024,421 126,649,644 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 1,748,645 8,687,328 1,846,435 9,855,566 1,949,876 9,712,647 2,126,278 10,591,423 2,253,111 2,253,111 51,024,421 126,649,644 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 96,940,912 109,898,377 103,831,163 118,301,372 113,058,067 127,399,423 122,281,398 138,445,477 133,600,313 139,128,398 1,202,884,900 2,051,244,045 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 21,457,695 22,443,557 23,060,655 24,149,617 25,290,095 26,487,373 27,741,376 29,062,692 30,474,333 31,958,654 31,958,654 31,958,654 9,938,099 10,405,994 10,896,236 11,409,903 11,948,128 12,512,096 12,862,145 13,222,225 13,592,625 13,973,649 13,973,649 13,973,649 26,376,597 20,382,756 25,865,702 21,451,241 27,781,597 25,310,417 31,812,670 25,710,094 28,012,016 28,571,935 28,571,935 28,571,935 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 57,772,392 53,232,308 59,822,594 57,010,761 65,019,819 64,309,885 72,416,191 67,995,011 72,078,974 74,504,238 74,504,238 74,504,238 --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- ---------------------- ---------------------- 0 0 0 0 0 0 0 0 0 0 (0) (0)
============ ============ ============ ============ ============ ============ ============ ============ ============ ============ ============ ============
4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 2.0% 2.0% 2.0% 2.0%
4.5% 4.5% 4.5% 4.5% 4.0% 4.0% 4.0% 4.0%
CITY OF SUNNYVALE
6040. WATER SUPPLY AND DISTRIBUTION FUND
JULY 1, 2032 TO JUNE 30, 2042
LONG TERM FINANCIAL PLAN
Attachment 3