Atherton City Council
May 1, 2024

A B C D E F G H H
FY 2021/22 (Actual) FY 2022/23 Actual FY 2023/24 Budget FY 2024/25 Proj. FY 2025/26 Proj. FY 2026/27 Proj. FY 2027/28 Proj. FY 2028/29 Proj. Average General Fund Revenue Projections
1 5% Basic Property Tax $ 11,968,447 $ 12,368,980 $ 13,781,171 $ 14,371,360 $ 15,018,071 $ 15,693,884 $ 16,400,109 $ 17,138,114 $ 14,592,517 2 2% Sales Taxes $ 305,010 $ 300,138 $ 435,000 $ 442,400 $ 451,248 $ 460,273 $ 469,478 $ 478,868 $ 417,802 3 2% Franchise Fees $ 969,422 $ 1,063,409 $ 1,035,000 $ 1,076,000 $ 1,097,520 $ 1,119,470 $ 1,141,860 $ 1,164,697 $ 1,083,422 4 2% Business License $ 253,779 $ 269,739 $ 283,600 $ 290,000 $ 295,800 $ 301,716 $ 307,750 $ 313,905 $ 289,536 5 3% Planning $ 289,279 $ 321,042 $ 405,300 $ 850,300 $ 875,809 $ 902,083 $ 929,146 $ 957,020 $ 691,247 6 3% Building $ 1,680,961 $ 1,506,988 $ 1,781,291 $ 2,203,280 $ 2,269,378 $ 2,337,460 $ 2,407,584 $ 2,479,811 $ 2,083,344 7 2% Police $ 131,111 $ 162,541 $ 517,715 $ 368,861 $ 376,238 $ 383,763 $ 391,438 $ 399,267 $ 341,367 8 3% Public Works $ 626,910 $ 457,981 $ 535,700 $ 659,700 $ 679,491 $ 699,876 $ 720,872 $ 742,498 $ 640,378 9 2% Park $ 164,392 $ 176,322 $ 52,700 $ 115,000 $ 117,300 $ 119,646 $ 122,039 $ 124,480 $ 123,985 10 2% Other/Misc $ 573,859 $ 1,597,984 $ 1,872,514 $ 1,190,896 $ 1,214,714 $ 1,239,008 $ 1,263,788 $ 1,289,064 $ 1,280,228 11 Hypothetical GF Revenue Stream $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
12 4% Excess ERAF $ 2,488,713 $ 2,339,064 $ 2,633,605 $ 2,500,000 $ 2,600,000 $ 2,704,000 $ 2,812,160 $ 2,924,646 $ 2,625,274 13 4% VLF In Lieu $ 1,264,027 $ 1,873,858 $ 1,000,507 $ 1,433,225 $ 1,490,554 $ 1,550,176 $ 1,612,183 $ 1,676,671 $ 1,487,650 14 Bayfront Canal $ 1,350,000 $ - $ - $ - $ - $ - $ - $ - $ 168,750 15 America Rescue Plan $ 1,707,322 $ - $ - $ - $ - $ - $ - $ 243,903 16 $ 23,773,232 $ 22,438,046 $ 24,334,103 $ 25,501,022 $ 26,486,124 $ 27,511,356 $ 28,578,408 $ 29,689,042 $ 26,038,916 General Fund Expenditure Projections
17 5% Operational Expenditures $ (14,070,510) $ (15,572,591) $ (18,000,999) $ (19,212,336) $ (20,172,953) $ (21,181,600) $ (22,240,680) $ (23,352,714) $ (18,635,953) 18 CIP - GF Allocations $ (4,990,557) $ (4,529,037) $ (5,890,000) $ - $ - $ - $ - $ - $ (2,201,371) 19 COP Debt Service $ (861,871) $ (861,871) $ (861,871) $ (861,871) $ (861,871) $ (861,871) $ (861,871) $ (861,871) $ (861,871) 20 ARC - OPEB $ (182,419) $ - $ - $ - $ - $ - $ - $ (30,403) 21 UAL - CalPERS Pension $ (6,400,819) $ (1,268,243) $ (1,223,001) $ (1,570,384) $ (1,715,600) $ (1,856,200) $ (1,971,000) $ (2,223,000) $ (2,286,464) 22 $ (26,506,176) $ (22,231,743) $ (25,975,871) $ (21,644,591) $ (22,750,424) $ (23,899,671) $ (25,073,551) $ (26,437,585) $ (24,011,718) 23 $ (2,732,944) $ 206,303 $ (1,641,768) $ 3,856,431 $ 3,735,700 $ 3,611,684 $ 3,504,856 $ 3,251,456 $ 1,505,752 24 $ 16,318,279 $ 13,585,335 $ 13,791,638 $ 12,149,870 $ 6,551,301 $ 7,887,001 $ 7,708,685 $ 5,373,541 $ 11,141,730 25 $ 13,585,335 $ 13,791,638 $ 12,149,870 $ 16,006,301 $ 10,287,001 $ 11,498,685 $ 11,213,541 $ 8,624,998 $ 12,647,482 26 $ (3,098,062) $ (2,526,125) $ (2,883,600) $ (3,117,408) $ (3,283,283) $ (3,455,670) $ (3,631,752) $ (3,836,357) $ (3,142,271) 27 $ (3,098,062) $ (2,526,125) $ (2,883,600) $ (3,117,408) $ (3,283,283) $ (3,455,670) $ (3,631,752) $ (3,836,357) $ (3,142,271) 28 $ 7,389,211 $ 8,739,387 $ 6,382,670 $ 9,771,485 $ 3,720,435 $ 4,587,345 $ 3,950,037 $ 952,283 $ 6,362,939 Proj. # Proj. # Proj. # Proj. # Proj. # Totals
29 Bike/Ped Master Plan $ 25,000 $ 650,000 $ 1,250,000 1-A,B $ 500,000 8-A,B,C $ 500,000 13-A,B $ 1,750,000 19-A,B $ 1,500,000 25 $ 1,000,000 $ 5,250,025 30 Drainage Master Plan $ 1,350,000 $ 550,000 $ 2,825,000 2-A,B,C $ 3,485,000 $ - 14 $ 250,000 20 $ 2,500,000 26 $ 2,500,000 $ 8,735,060 31 Park Master Plan $ - $ 1,700,000 $ 200,000 3-A,B,C $ 1,950,000 9-A,B $ 350,000 15 $ 250,000 21 $ 250,000 27 $ 250,000 $ 3,050,063 32 Federal Funding (Eschoo) Grant $ - $ 600,000 $ 75,000 4 $ 1,380,000 $ - $ - $ - $ 1,380,000 33 Road Improvement Plan $ 1,125,000 $ 1,500,000 $ 840,000 5 $ 840,000 10 $ 840,000 16 $ 840,000 22 $ 840,000 28 $ 840,000 $ 4,200,076 34 Long Term Liabilities (Pension UAL) $ 5,000,000 $ - $ - $ - $ - $ - $ - $ - 35 Long Term Liabilities (OPEB UAL) $ - $ - $ - $ - $ - $ - $ - $ - $ - 36 COP/Debt Service $ - $ - $ - $ - $ - $ - $ - $ - $ - 37 Green Infrastructure Plan $ 140,000 $ 300,000 $ 200,000 2-D $ 350,000 11-A,B $ 210,000 17 $ 200,000 23 $ 250,000 29 $ 250,000 $ 1,260,069 38 Traffic Safety Improvement 6 $ 450,000
39 Affordable Housing Allocation $ -
40 Facility Replacement/Improvements $ - $ - $ 500,000 7-A,B,C $ 500,000 12-A,B,C $ 500,000 18-A,B,C $ 500,000 24-A,B $ 500,000 30-A,B $ 500,000 $ 2,500,000 41 Totals $ 7,640,000 $ 5,300,000 $ 5,890,000 $ 9,455,000 $ 2,400,000 $ 3,790,000 $ 5,840,000 $ 5,340,000 $ 26,825,000 42 $ 7,389,211 $ 8,739,387 $ 6,382,670 $ 316,485 $ 1,320,435 $ 797,345 $ (1,889,963) $ (4,387,717) 43 $ 1,032,687 $ 842,042 $ 961,200 $ 1,039,136 $ 1,094,428 $ 1,151,890 $ 1,210,584 $ 1,278,786 44 PERS UAL $ 19,585,904 $ 18,317,661 $ 17,094,660 $ 15,524,276 $ 13,808,676 $ 11,952,476 $ 9,981,476 $ 7,758,476 45 OPEB UAL $ (426,932) $ - $ - $ - $ - $ - $ - $ - $ - 46 COP $ 7,756,842 $ 6,894,971 $ 6,033,099 $ 5,171,228 $ 4,309,357 $ 3,447,486 $ 2,585,615 $ 1,723,744 $ 861,873 15% Operational
Out Year Financial Planning Tool
Major Revenues
At Risk/One-Time Revenue
Total General Fund Revenues
Major Expenditures
Total General Fund Expenditures
Net
Beginning General Fund Balance
Net Beginning General Fund Balance
Annual Reserve Requirements
15% Emergency
Available Fund Balance
Set-Aside Buckets
Net Available Fund Balance (After Set-Asides)
Rec'd Minimum Unallocated Fund Balance (5%)
Long Term Liability