Measure C
20-Year Financial Forecast Update
ATTACHMENT VI
Measure C 20-Year Financial Forecast
Year Ref. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Actual Actual Actual Actual Actual Actual Unaudited Actual Estimated Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Fiscal Year FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023* FY 2024* FY 2025* FY 2026* FY 2027* FY 2028* FY 2029* FY 2030* FY 2031* FY 2032* FY 2033* FY 2034* 2035* Revenues
Measure C 8,090,470 13,436,227 14,189,607 15,216,260 16,906,772 16,876,487 18,715,986 18,547,918 19,370,950 20,183,018 20,945,915 21,659,643 22,323,743 22,939,911 23,398,709 23,866,683 24,344,017 24,830,897 25,327,515 25,327,515 25,834,066 Bond Issuance 65,789,797
Chabot Commitment 1,837,150 6,127,662 12,035,189 Total Revenues 8,090,470 79,226,024 14,189,607 15,216,260 16,906,772 18,713,637 24,843,648 30,583,107 19,370,950 20,183,018 20,945,915 21,659,643 22,323,743 22,939,911 23,398,709 23,866,683 24,344,017 24,830,897 25,327,515 25,327,515 25,834,066 Expenditures
Capital Expenditures
Library/Learning Center 10,607,338 17,372,241 17,051,095 11,503,558 2,739,353 2,449,125 1,482,871 Fire Facilities Design 930,859 1,285,242 284,537 150,680 35,898 50,250 208,050 195,465 Fire Station 1 358,293 618,851 33,618 1,521
Fire Station 2 587,183 1,571,806 172,704 95,567 3,095 Fire Station 3 472,826 1,622,186 141,045 66,950 1,269 Fire Station 4 114,900 1,609,051 297,312 128,458 20,554 Fire Station 5 75,973 1,207,332 435,506 58,488 1,345 Fire Station 6 65,762 305,789 720,032 5,298,984 3,911,433 600,000 Fire Training Academy 681,043 2,025,836 752,152 877,108 12,719,734 36,244,127 6,700,000 Street Rehabilitation 490,845 10,554,232 652,521 32,113 - 2,000,000 2,000,000 EBRCS Radios 1,314,719 1,337,437 -
Tennyson Corridor Median Improvement 251,604 356,050 263,231 217,009 Subtotal - 12,029,043 31,501,932 26,708,977 15,390,800 6,416,863 20,807,587 42,063,490 7,495,465 2,000,000 - - - - - - - 2,000,000 - - - Operating Expenditures
Police Services 569,836 1,793,135 1,935,134 2,956,896 3,097,313 3,290,198 3,151,091 3,371,668 3,607,685 3,860,222 4,130,438 4,419,569 4,728,938 5,059,964 5,414,162 5,793,153 6,198,674 6,632,581 6,632,581 7,096,862 Maintenance Services 205,969 708,249 572,105 610,926 761,784 1,058,980 1,468,931 1,410,360 1,509,085 1,614,721 1,727,751 1,848,694 1,978,103 2,116,570 2,264,730 2,423,261 2,592,889 2,774,391 2,968,599 2,968,599 3,176,401 Other Department Services 73,240 66,116 106,542 223,969 Subtotal 205,969 1,278,084 2,365,240 2,546,060 3,791,920 4,222,408 4,865,672 4,785,420 4,880,753 5,222,405 5,587,974 5,979,132 6,397,671 6,845,508 7,324,694 7,837,422 8,386,042 8,973,065 9,601,179 9,601,179 10,273,262 Debt Service Expenditures 2,326,436 2,859,637 2,732,875 5,430,063 4,523,594 5,424,438 5,423,063 5,415,313 5,407,938 5,425,488 5,419,188 5,436,938 5,434,838 5,434,063 5,426,800 5,424,913 5,420,657 5,379,350 5,372,350 5,372,350 Total Expenditures 205,969 15,633,563 36,726,809 31,987,912 24,612,783 15,162,865 31,097,696 52,271,973 17,791,530 12,630,343 11,013,461 11,398,320 11,834,609 12,280,346 12,758,756 13,264,222 13,810,954 16,393,721 14,980,529 14,973,529 15,645,612 Annual Cash Flow 7,884,501 63,592,461 (22,537,202) (16,771,652) (7,706,011) 3,550,772 (6,254,048) (21,688,866) 1,579,420 7,552,675 9,932,454 10,261,323 10,489,134 10,659,565 10,639,953 10,602,461 10,533,063 8,437,176 10,346,986 10,353,986 10,188,454 Cumulative Fund Balance 7,884,501 71,476,962 48,939,761 32,168,108 24,462,097 28,012,868 21,758,821 69,955 1,649,374 9,202,049 19,134,503 29,395,826 39,884,961 50,544,526 61,184,479 71,786,940 82,320,002 90,757,178 101,104,164 101,111,164 111,292,618 *The amounts identified for capital projects in future fiscal years of this projection are conceptual only and have not been approved or appropriated. Appropriation and allocation of these funds will occur annually with adoption of the City's Operating and Capital budgets. 2/14/2022