Cities Index.
Attachment IV General Fund Long Range Financial Model

Hayward City Council
March 12, 2024

Document
Attachment IV General Fund Long Range Financial Model
Meeting
March 12, 2024
Body
Hayward City Council
Original file
594 KB
Text extracted from the city's file for reading and search. Open the original on hayward.legistar1.com. That file is the official record.

CURRENT FORECAST GENERAL FUND HISTORICAL SUMMARY
FY2017
Actuals
FY2018
Actuals
FY2019
Actuals
FY2020
Actuals
FY2021
Actuals
FY2022
Actuals
FY2023
Actuals
FY2024
Adopted
FY 2024
Mid-Year
FY 2024
Revised
FY2025
Forecast
FY2026
Forecast
FY2027
Forecast
FY2028
Forecast
FY2029
Forecast
FY2030
Forecast
FY2031
Forecast
FY2032
Forecast
FY2033
Forecast
FY2034
Forecast
FY2035
Forecast
FY2036
Forecast
FY2037
Forecast
FY2038
Forecast
FY2039
Forecast
FY2040
Forecast
FY2041
Forecast
FY2042
Forecast
Property Tax $47,196 $51,236 $54,468 $58,432 $61,196 $63,524 $68,458 $67,498 $2,200 $69,698 $72,959 $75,601 $78,353 $81,226 $84,023 $86,733 $90,211 $93,871 $97,733 $101,584 $105,680 $109,802 $113,983 $119,414 $125,452 $132,303 $139,960 $149,197 Sales Tax 34,839 33,389 36,011 39,680 40,075 44,028 44,051 46,439 $46,439 47,423 48,728 47,650 47,794 50,311 52,967 55,735 57,280 58,866 57,550 57,700 60,704 63,862 67,181 69,023 70,912 69,304 69,461 Utility Users Tax 20,754 17,488 16,935 16,066 17,268 17,308 25,945 18,000 3,000 $21,000 21,000 21,420 21,848 22,285 22,731 23,186 23,649 24,122 24,605 25,097 25,599 26,111 26,633 27,166 27,709 0 0 0 Transient Occupancy Tax 2,560 2,808 2,823 2,187 1,552 1,979 2,359 2,000 $2,000 2,060 2,122 2,079 2,090 2,204 2,324 2,450 2,524 2,600 2,548 2,560 2,700 2,847 3,002 3,092 3,185 3,121 3,137 Cannabis Tax 0 0 0 3 442 843 804 1,100 $1,100 1,122 1,144 1,167 1,191 1,214 1,239 1,264 1,289 1,315 1,341 1,368 1,395 1,423 1,451 1,480 1,510 1,540 1,571 Emerg Svcs Facilities Excise Tax 2,100 2,131 2,186 2,030 1,831 1,829 2,045 2,075 $2,075 2,096 2,117 2,138 2,159 2,181 2,203 2,225 2,247 2,269 2,292 2,315 2,338 2,362 2,385 2,409 2,433 2,457 2,482 Business License Tax 2,591 2,752 2,833 2,755 2,677 3,171 3,287 2,811 $2,811 2,839 2,868 2,896 2,780 2,739 2,833 2,931 3,032 3,062 3,093 2,969 2,925 3,026 3,130 3,238 3,270 3,303 3,171 Property Transfer Tax 8,350 9,168 12,256 12,150 17,120 21,226 12,357 17,600 $17,600 17,776 17,954 17,236 16,977 17,563 18,169 18,796 18,983 19,173 18,406 18,130 18,756 19,403 20,072 20,273 20,476 19,657 19,362 Franchises 9,646 9,648 9,730 10,582 10,624 10,516 11,907 12,179 $12,179 12,423 12,671 12,924 13,183 13,447 13,716 13,990 14,270 14,555 14,846 15,143 15,446 15,755 16,070 16,391 16,719 17,054 17,395 Permits & Fees 14,917 14,777 15,966 12,074 13,300 12,738 14,297 14,099 $14,099 14,381 14,668 14,746 14,936 15,337 15,750 16,177 16,500 16,830 16,919 17,138 17,598 18,072 18,561 18,932 19,311 19,414 19,665 Interest 253 57 488 460 (9) (735) 427 300 $300 530 437 295 102 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Revenue 11,319 10,902 10,751 9,725 14,597 8,629 7,663 11,591 436 $12,027 11,636 11,681 11,728 11,775 11,822 11,870 11,919 11,969 12,019 12,070 12,122 12,175 12,228 12,282 12,337 12,392 12,448 12,506 Transfers In 4,037 4,045 17,357 3,964 3,967 11,571 17,123 4,192 4,498 $8,690 4,256 4,320 4,386 4,454 4,522 4,592 4,664 4,737 4,811 4,887 4,964 5,043 5,124 5,206 5,290 5,375 5,462 5,551 Total Revenues 158,561 158,401 181,804 170,107 184,641 196,625 210,724 199,883 10,134 210,017 210,500 215,731 217,447 220,951 228,093 235,581 244,010 250,824 257,839 260,634 265,689 274,992 284,716 295,920 305,626 287,886 293,720 303,497 Salaries/Wages 67,624 69,065 72,803 73,459 73,817 77,837 81,762 98,419 1,689 100,108 102,144 105,845 108,212 110,631 113,104 115,633 118,218 120,861 123,568 126,336 129,166 132,059 135,017 138,041 141,133 144,294 147,526 150,831 Overtime 9,254 10,370 9,574 9,767 11,903 13,903 14,919 3,370 3,370 3,500 3,570 3,641 3,714 3,789 3,864 3,942 4,020 4,101 4,183 4,266 4,352 4,439 4,528 4,618 4,711 4,805 4,901 Retirement 23,021 23,366 26,951 30,183 33,051 36,742 40,016 42,846 42,846 46,944 49,399 51,648 53,639 57,479 58,780 60,031 58,410 58,532 56,751 56,337 55,394 53,258 52,267 51,187 50,506 52,246 48,281 Health 11,840 11,723 11,533 11,639 11,765 11,994 12,410 16,200 16,200 16,382 16,873 17,379 17,901 18,438 18,991 19,560 20,147 20,752 21,374 22,015 22,676 23,356 24,057 24,779 25,522 26,288 27,076 Retiree Medical 2,847 2,794 3,020 3,107 3,059 3,248 3,241 3,465 3,465 3,552 3,641 3,722 3,806 3,891 3,978 4,067 4,158 4,251 4,347 4,445 4,545 4,647 4,752 4,858 4,968 5,080 5,194 Workers Compensation 6,307 6,228 6,815 6,816 8,106 8,526 9,001 5,418 5,418 5,553 5,692 5,820 5,951 6,084 6,221 6,361 6,503 6,649 6,799 6,952 7,108 7,268 7,432 7,599 7,770 7,945 8,124 Other Benefits 3,007 3,270 1,831 2,065 2,347 2,299 2,492 1,233 1,233 1,280 1,328 1,357 1,388 1,419 1,451 1,484 1,517 1,551 1,586 1,622 1,658 1,695 1,734 1,773 1,812 1,853 1,895 Personnel Charge Out (4,069) (5,213) (3,803) (5,031) (3,500) (4,168) (5,336) (6,371) (6,371) (6,515) (6,661) (6,811) (6,964) (7,120) (7,280) (7,444) (7,611) (7,782) (7,957) (8,136) (8,319) (8,506) (8,698) (8,893) (9,094) (9,298) (9,507) Vacancy Savings - - - - - - - (5,881) (5,881) (4,076) (4,208) (4,291) (4,377) (4,464) (4,553) (4,644) (4,736) (4,830) (4,927) (5,025) (5,125) (5,227) (5,332) (5,438) (5,547) (5,677) (5,810) Subtotal Personnel 119,831 121,604 128,724 132,005 140,546 150,382 158,506 158,699 1,689 160,388 168,764 175,479 180,678 185,688 192,619 197,084 201,574 203,271 206,792 208,492 211,641 214,347 215,947 218,780 221,615 224,943 230,767 230,984 Maintenance & Utilities 787 715 797 920 804 1,210 1,092 1,687 1,687 1,738 1,790 1,843 1,899 1,956 2,014 2,075 2,137 2,201 2,267 2,335 2,405 2,477 2,552 2,628 2,707 2,788 2,872 Services & Supplies 9,326 10,335 11,441 12,105 11,880 10,069 12,593 10,901 778 11,679 11,173 11,453 11,739 12,033 12,333 12,642 12,958 13,282 13,614 13,954 14,303 14,661 15,027 15,403 15,788 16,183 16,587 17,002 Internal Service Charges 14,413 11,863 15,504 16,858 14,048 14,890 16,813 19,951 19,951 19,951 20,450 21,064 21,696 22,347 23,017 23,707 24,419 25,151 25,906 26,683 27,483 28,308 29,157 30,032 30,933 31,861 32,817 Capital Outlay 0 85 5,427 12 257 657 68 0 0 250 258 265 273 281 290 299 307 317 326 336 346 356 367 378 389 401 413 Transfers Out-Debt 3,640 3,348 2,857 2,015 2,993 2,544 2,742 2,708 2,708 2,715 2,715 2,715 734 734 508 281 281 281 281 281 281 281 281 281 281 281 281 Transfers Out-CIP 1,769 2,898 3,357 5,814 2,117 6,309 4,811 2,560 916 3,476 2,637 2,716 2,797 2,881 2,968 3,057 3,148 3,243 3,340 3,440 3,544 3,650 3,759 3,872 3,988 4,108 4,231 4,358 Transfers Out-Liability/Other 9,193 4,257 8,500 5,624 6,252 8,217 9,244 8,473 297 8,770 8,642 8,815 8,991 9,171 9,354 9,542 9,732 9,927 10,126 10,328 10,535 10,745 10,960 11,179 11,403 11,631 11,864 12,101 Budget Additions/Appropriations - - - - - - - - 4,629 4,629 - - - - - - - - - - 7,158 7,337 7,521 7,709 7,902 8,099 8,302 8,509 Budget Cuts - - - - - - - - 0 - - - - - - - - - - - - - - - - - - Total Expense 158,957 155,105 176,608 175,353 178,897 194,277 205,868 204,978 8,309 213,286 215,871 223,674 230,093 234,374 242,593 248,153 253,775 256,867 261,821 264,995 276,816 281,256 284,638 289,300 294,015 299,274 307,082 309,337 GF Reserves - Surplus/(Use) (396) 3,296 5,196 (5,246) 5,743 2,348 4,857 (5,095) (3,269) (5,371) (7,943) (12,646) (13,423) (14,500) (12,572) (9,764) (6,042) (3,983) (4,361) (11,127) (6,265) 78 6,620 11,611 (11,388) (13,362) (5,840) ACFR Adjustment (752) (592) (702) (785) (461) (612) - - - - - - - - - - - - - - - - - - - - Beginning Fund Balance 30,829 29,681 32,385 36,879 30,847 36,130 37,866 42,723 42,723 39,454 34,083 26,139 13,494 70 (14,430) (27,001) (36,766) (42,808) (46,791) (51,152) (62,279) (68,544) (68,465) (61,846) (50,235) (61,623) (74,985) Ending Fund Balance 29,681 32,385 36,879 30,847 36,130 37,866 42,723 37,628 39,454 34,083 26,139 13,494 70 (14,430) (27,001) (36,766) (42,808) (46,791) (51,152) (62,279) (68,544) (68,465) (61,846) (50,235) (61,623) (74,985) (80,825) Bal as % of Expenses 18.7% 20.9% 20.9% 17.6% 20.2% 19.5% 20.8% 18.4% 18.5% 15.8% 11.7% 5.9% 0.0% -5.9% -10.9% -14.5% -16.7% -17.9% -19.3% -22.5% -24.4% -24.1% -21.4% -17.1% -20.6% -24.4% -26.1% Employee Home Loan Program 1,000 1,000
ED Corp Loan / Repayment 8,600 8,600 (575) (575) (575) (575) (575) (575) (575) (575) (575) (575) (575) (575) (575) (575) (550) Net Ending Fund Balance 29,681 32,385 36,879 30,847 36,130 37,866 42,723 37,628 29,853 24,482 17,113 5,043 (7,806) (21,731) (33,727) (42,917) (48,384) (51,792) (55,578) (66,130) (71,820) (71,166) (63,972) (51,786) (62,624) (75,986) (81,826) Net Bal as % of Expenses 18.7% 20.9% 20.9% 17.6% 20.2% 19.5% 20.8% 18.4% 14.0% 11.3% 7.7% 2.2% -3.3% -9.0% -13.6% -16.9% -18.8% -19.8% -21.0% -23.9% -25.5% -25.0% -22.1% -17.6% -20.9% -24.7% -26.5% ($ in Thousands)

ATTACHMENT IV

← All documents from this meeting