Page 129 - City of Westlake FY20 Budget

FIVE YEAR FINANCIAL FORECAST

ALL MUNICIPAL FUNDS

Revision 06
ADOPTED ESTIMATED ADOPTED Projected Projected Projected Projected
FY 18‐19 FY 18‐19 FY 19‐20 FY 20‐21 FY 21‐22 FY 22‐23 FY 23‐24
GENERAL OPERATING FUND

FUND 100 ‐ GENERAL FUND

1 Sales & Use Tax Revenues 2% $ 11,650,000 $ 7,050,000 $ 7,250,000 $ 7,395,000 $ 7,542,900 $ 7,693,758 $ 7,847,633
2 Commercial 1 one time vision 1,200,000 750,000 ‐ 250,000 250,000 250,000 250,000
3 Commercial 2 one time vision ‐ ‐ ‐ ‐ 50,000 100,000 100,000
4 BASE SALES & USE TAX 12,850,000 7,800,000 7,250,000 7,645,000 7,842,900 8,043,758 8,197,633
5 Allocation to 4B 25% of Base Sales Tax 2% (1,400,000) (1,950,000) (1,812,500) (1,848,750) (1,885,725) (1,923,440) (1,961,908)
6 Allocation to ED 25% of Schwab Sales Tax vision (198,000) (300,000) ‐ ‐ ‐ ‐ ‐
7 Allocation to ED Deloitte hard coded (102,000) ‐ ‐ ‐ ‐ ‐ ‐
8 ALLOCATIONS TO OTHER FUNDS (1,700,000) (2,250,000) (1,812,500) (1,848,750) (1,885,725) (1,923,440) (1,961,908)
9 Total General Sales Tax 11,150,000 5,550,000 5,437,500 5,796,250 5,957,175 6,120,318 6,235,725
#
# Property Tax 0% 1,733,356 1,733,356 1,634,916 1,634,916 1,634,916 1,634,916 1,634,916
# Addl Residential (cumulative) schedule ‐ ‐ ‐ 347,235 455,074 562,084 669,094
# Deloitte Abatement Ends 20/21 hard coded ‐ ‐ ‐ ‐ 75,000 75,000 75,000
# BASE PROPERTY TAX 1,733,356 1,733,356 1,634,916 1,982,151 2,164,990 2,272,000 2,379,010
# Additional Commercial schedule ‐ ‐ ‐ 308,100 308,100 308,100 308,100
# Schwab Abatement Starts 16/17 schedule ‐ ‐ ‐ (154,050) (123,240) (92,430)
# ADDITIONAL DEVELOPMENT ‐ ‐ ‐ 308,100 154,050 184,860 215,670
# Total Property Tax 1,733,356 1,733,356 1,634,916 2,290,251 2,319,040 2,456,860 2,594,680
#
# Building‐MEP‐Driveway Permits dept 12 schedule 2,365,380 2,603,579 1,514,365 1,124,122 1,017,811 945,361 930,361
# Inspection/Plan Review Fees dept 12 schedule 1,781,733 2,457,620 949,452 762,544 708,490 649,370 649,370
# Grading/Excavation Fees dept 12 schedule 37,599 22,707 28,741 34,290 31,290 28,200 28,200
# Erosion Control Fees dept 12 schedule 85,500 52,500 70,500 84,000 76,500 69,000 69,000
# Fire Inspection Permits dept 14 schedule 87,359 247,089 72,267 46,200 44,000 38,500 39,400
# Permits and Fees (Building Residential & Commercial) 4,357,571 5,383,495 2,635,325 2,051,156 1,878,091 1,730,431 1,716,331
#
# Liquor Permit Fees dept 10 1% 3,080 3,080 3,080 3,111 3,142 3,173 3,205
# Administrative Fees dept 10 1% 2,353 3,580 3,580 3,616 3,652 3,688 3,725
# Reforestation Tree Escrow dept 12 1% 12,265 12,000 25,000 25,250 25,503 25,758 26,015
# Re‐Inspection Fees dept 12 1% 100 50 50 51 51 52 52
# Gas Well Misc Fees dept 12 1% 10,500 10,000 ‐ ‐ ‐ ‐ ‐
# Insurance & Surety Review Fees dept 12 1% 1,000 500 ‐ ‐ ‐ ‐ ‐
# Renewal Fees dept 12 1% 500 250 ‐ ‐ ‐ ‐ ‐
# Engineer Review/Civil dept 12 1% 20,800 20,000 20,000 20,200 20,402 20,606 20,812
# Development Fees dept 12 1% 77,190 77,000 30,000 30,300 30,603 30,909 31,218
# Contractor Registration Fees dept 12 1% 24,015 24,000 15,000 15,150 15,302 15,455 15,609
# EMS Revenues dept 14 1% 100,000 100,000 100,000 101,000 102,010 103,030 104,060
# Firefighter Equipment Fees dept 14 1% 2,000 ‐ ‐ ‐ ‐ ‐ ‐
# Fire Code Inspections dept 14 1% 525 525 525 530 536 541 546
# Administrative Fees dept 15 1% 8,975 ‐ ‐ ‐ ‐ ‐ ‐
# Misc Permits and Fees (Other) 263,303 250,985 197,235 199,207 201,199 203,211 205,244
#
# Sales of Surplus/Scrap Items dept 10 1% 2,790 2,790 2,790 2,818 2,846 2,875 2,903
# Insurance Refund/Equity Return dept 10 1% 5,000 5,000 5,000 5,050 5,101 5,152 5,203
# Misc Revenue dept 10 1% 3,710 3,710 3,710 3,747 3,785 3,822 3,861
# Misc Revenue dept 12 1% ‐ 1,315 100 101 102 103 104
# Misc Revenue dept 15 1% 25 ‐ ‐ ‐ ‐ ‐ ‐
# Misc Revenue dept 16 1% 1,460 1,460 ‐ ‐ ‐ ‐ ‐
# Facility Rental dept 17 1% 21,800 21,800 15,000 15,150 15,302 15,455 15,609
# Misc Revenue dept 22 1% 5,000 5,000 ‐ ‐ ‐ ‐ ‐
# Misc Income 39,785 41,075 26,600 26,866 27,135 27,406 27,680
#
# AT&T/SBC reduced dept 10 1% 304,700 304,700 100,551 101,557 102,572 103,598 104,634
# Verizon by 66% dept 10 1% 23,665 23,665 7,810 7,888 7,967 8,047 8,127
# TXU/Atmos Gas per dept 10 1% 39,420 49,700 16,401 16,565 16,731 16,898 17,067
# Charter budget dept 10 1% 26,955 26,955 8,895 8,984 9,074 9,165 9,256
# One Source meeting dept 10 1% 3,670 3,670 1,211 1,223 1,235 1,248 1,260
# Tri‐County Electric with dept 10 1% 473,000 310,000 102,300 103,323 104,356 105,400 106,454
# Trinity Waste/AWIN Mgmt Amanda dept 10 1% 63,675 63,675 63,675 64,312 64,955 65,604 66,260
# Misc. Franchise Fees , Noah, dept 10 1% 48,730 48,730 16,081 16,242 16,404 16,568 16,734
# Franchise Fees 983,815 831,095 316,924 320,093 323,294 326,527 329,792

117