Page 60 - Trophy Club FY22 Budget

Assumption Yr #1 Assumption Yr #2 Assumption Yr #3 Assumption Yr #4 Assumption Yr #5
Property Tax 0.00% 2.00% 2.00% 2.00% 2.00%
Sales Tax 0.00% 5.00% 3.00% 3.00% 3.00%
Other Revenues 0.00% 1.00% 1.00% 1.00% 1.00%
Overall Expenditures (General Fund) 0.00% 2.00% 2.00% 2.00% 2.00%
Public Safety Salaries 0.00% 2.00% 2.00% 2.00% 2.00%
Police FTE 0.00 1.00 0.00 1.00 0.00
Fire/EMS FTE 0.00 1.00 1.00 1.00 0.00
Other Employee's Salaries 0.00% 2.00% 2.00% 2.00% 2.00%
Comp Study Adjustment $ -
Health Care Costs 0.00% 5.00% 5.00% 5.00% 5.00%
Capital Equipment Replacement Needs
Police $ 185,000.00 $ - $ - $ - $ -

EMS $ 30,500.00 $ 30,500.00 $ 30,500.00 $ 33,000.00 $ 33,000.00

Fire $ 321,540.00 $ 173,540.00 $ 184,131.00 $ 70,000.00 $ 55,711.00
Parks $ 44,000.00 $ 149,700.00 $ 142,500.00 $ 149,000.00 $ 146,900.00
Recreation $ 196,000.00 $ 148,185.00 $ 143,284.00 $ 276,108.00 $ 103,919.00
Community Development $ 50,000.00 $ 35,000.00 $ 35,000.00 $ - $ -

TOTAL $ 827,040.00 $ 536,925.00 $ 535,415.00 $ 528,108.00 $ 339,530.00

Budgeted Cap Equipment Replacement $ 827,040.00 $ 536,925.00 $ 535,415.00 $ 528,108.00 $ 339,530.00

IT Allocations $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00

TOTAL $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00
CCPD Capital Equipment $ 185,000.00 $ 185,000.00 $ 185,000.00 $ 185,000.00 $ 185,000.00

Police $ 225,000.00 $ 205,500.00 $ 137,500.00 $ 184,500.00 $ 207,000.00
FY22 Tax Rate 2017‐2018 2018‐2019 2019‐2020 FY21 Amended FY22 FY23 FY24 FY25 FY26
General Fund
$0.445000 Total Activity Total Activity Total Activity Budget
Beginning Fund Balance ‐ FY20 CAFR less
FY21 Exp $ 6,988,000 $ 6,702,518 $ 6,732,789 $ 6,919,626 $ 6,915,697 $ 6,706,966
Percent off Budgeted Number 1.00% 2.00% 2.00% 2.00% 2.00% 2.00%
Revenue
Property Tax $ 6,493,421.97 $ 6,746,578.95 $ 7,031,350.53 $7,220,000 $ 7,680,000.00 $ 7,833,200.00 $ 7,989,464.00 $ 8,148,853.28 $ 8,311,430.35
Licenses and Permits $ 614,931.29 $ 499,301.61 $ 479,513.17 $235,000 $ 165,000.00 $ 166,650.00 $ 168,316.50 $ 169,999.67 $ 171,699.66
Franchise Fees $ 867,445.87 $ 911,737.89 $ 850,543.10 $852,816 $ 820,000.00 $ 828,200.00 $ 836,482.00 $ 844,846.82 $ 853,295.29
Sales Tax $ 925,571.96 $ 1,023,119.84 $ 1,123,554.08 $1,110,000 $ 1,311,800.00 $ 1,377,390.00 $ 1,418,711.70 $ 1,461,273.05 $ 1,505,111.24
Fines and Fees $ 488,312.98 $ 307,977.19 $ 128,165.68 $282,600 $ 307,090.00 $ 310,160.90 $ 313,262.51 $ 316,395.13 $ 319,559.09
Intergovernmental (MUD) $ 608,910.00 $ 674,452.00 $ 718,656.96 $820,031 $ 898,700.00 $ 907,687.00 $ 916,763.87 $ 925,931.51 $ 935,190.82
Grants $ 16,338.67 $ 167,787.31 $ 743,065.83 $220,879 $ 85,000.00 $ 85,000.00
Charges for Service $ 803,477.12 $ 764,282.46 $ 806,108.79 $788,029 $ 814,818.00 $ 822,966.18 $ 831,195.84 $ 839,507.80 $ 847,902.88
Investment Income $ 109,662.42 $ 206,601.18 $ 75,136.89 $72,000 $ 24,000.00 $ 24,240.00 $ 24,482.40 $ 24,727.22 $ 24,974.50
Miscellaneous Income $ 103,790.20 $ 188,933.32 $ 162,194.16 $122,104 $ 186,000.00 $ 187,860.00 $ 189,738.60 $ 191,635.99 $ 193,552.35
Contributions $ 93,777.33 $ 35,040.81 $ 124,537.73 $25,000 $ - $ - $ -
Transfers In $ 829,299.02 $ 63,000.00 $ 91,500.00
Total Revenue $ 11,954,938.83 $ 11,588,812.56 $ 12,334,326.92 $11,748,459 $ 12,292,408 $ 12,543,354 $ 12,688,417 $ 12,923,170 $ 13,162,716
Expenditures
General Government
Manager's Office $ 508,330.79 $ 1,161,520.28 $ 682,231.03 872,190 $ 806,864.34 $ 824,359.97 $ 842,273.87 $ 860,617.84 $ 879,404.07
Legal $ 110,989.49 $ 127,898.44 $ 102,606.00 126,350 $ 126,350.00 $ 128,877.00 $ 131,454.54 $ 134,083.63 $ 136,765.30
Police $ 2,258,064.05 $ 2,483,870.98 $ 2,500,524.00 2,803,201 $ 3,050,230.16 $ 3,196,605.02 $ 3,266,182.02 $ 3,422,803.07 $ 3,495,016.55
Emergency Medical Services $ 1,047,028.99 $ 1,085,045.86 $ 1,189,691.50 1,365,650 $ 1,389,307.50 $ 1,419,500.33 $ 1,450,417.34 $ 1,482,079.05 $ 1,514,506.65
Fire $ 1,097,509.22 $ 1,303,324.35 $ 1,256,964.26 1,428,025 $ 1,449,196.55 $ 1,564,987.24 $ 1,683,454.08 $ 1,804,668.60 $ 1,844,304.58
Streets $ 340,910.07 $ 191,462.56 $ 192,607.65 227,010 $ 240,279.08 $ 245,084.66 $ 249,986.35 $ 254,986.08 $ 260,085.80
Parks $ 1,535,805.36 $ 1,486,965.36 $ 1,396,879.95 1,610,338 $ 1,547,203.34 $ 1,582,827.69 $ 1,619,559.19 $ 1,657,279.07 $ 1,696,019.78
Recreation $ 561,579.66 $ 588,666.47 $ 391,582.50 662,702 $ 758,119.31 $ 774,082.21 $ 790,404.40 $ 807,095.05 $ 824,163.65

Community Events $ 26,663.78 $ 35,624.96 $ 14,866.60 33,383 $ 38,510.92 $ 39,281.14 $ 40,066.76 $ 40,868.10 $ 41,685.46
Community Development $ 556,128.02 $ 568,238.66 $ 491,941.07 653,324 $ 419,111.56 $ 427,886.64 $ 436,856.87 $ 446,027.12 $ 455,402.44
Finance $ 533,986.50 $ 526,600.55 $ 601,248.95 548,293 $ 573,158.39 $ 585,431.72 $ 597,991.02 $ 610,844.04 $ 623,998.77

Municipal Court $ 89,899.13 $ 66,879.23 $ 77,456.48 76,639 $ 38,140.00 $ 38,902.80 $ 39,680.86 $ 40,474.47 $ 41,283.96
Human Resources $ 405,362.01 $ 428,739.11 $ 428,851.13 323,362 $ 318,613.06 $ 325,433.76 $ 332,413.30 $ 339,555.97 $ 346,866.21

Communications $ ‐ $ ‐ $ ‐ 173,182 $ 180,553.05 $ 184,190.42 $ 187,901.85 $ 191,688.90 $ 195,553.13
Information Services $ 556,055.46 $ 575,037.17 $ 584,792.52 655,957 $ 669,668.00 $ 679,773.36 $ 690,080.83 $ 700,594.44 $ 711,318.33

Facility Maintenance $ 256,589.46 $ 319,017.86 $ 336,161.48 345,452 $ 373,720.91 $ 360,795.33 $ 368,011.23 $ 395,371.46 $ 382,878.89

Debt Service $ - $ - $ - $ - $ -
Capital ‐ Projects $ - $ - $ - $ - $ -
Total Expenditures $ 9,884,902 $ 10,948,892 $ 10,248,405 $ 11,905,057 $ 11,979,026 $ 12,378,019 $ 12,726,735 $ 13,189,037 $ 13,449,254
Current Revenues to Expenditures $ 2,070,037 $ 639,921 $ 2,085,922 $ (156,598) $ 313,382 $ 165,335 $ (38,317) $ (265,866) $ (286,537)
Other Sources (Uses):
Debt Issuance ‐
Transfers In 91,500 $ 158,500.00 $ 160,000.00 $ 161,500.00 $ 163,000.00 $ 164,500.00
Transfers Out (1,673,000) $ (927,040.00) $ (636,925.00) $ (635,415.00) $ (628,108.00) $ (439,530.00)
Total Other Sources (Uses) $ (1,581,500) $ (768,540) $ (476,925) $ (473,915) $ (465,108) $ (275,030)
Net Increase (Decrease) $ (1,738,098) $ (455,158) $ (311,590) $ (512,232) $ (730,974) $ (561,567)
Ending Fund balance $ 5,249,901.95 $ 6,247,359.83 $ 6,421,198.30 $ 6,407,393.68 $ 6,184,722.29 $ 6,145,399.01
58 FY22 Approved Budget