FY2020 2nd Quarter Financial Review Executive Dashboard 2nd - - PowerPoint PPT Presentation

FY2020 2nd Quarter Financial Review

Executive Dashboard – 2nd Quarter, 2020 Fiscal Year Financial Indicators

Positive variance compared to historical trends Positive Negative variance of 3%-5% and more than $50,000 compared to historical trends Warning Negative variance of >5% and more than $50,000 compared to historical trends Negative

Key Revenue Sources FY2020 Budget Actual through 03/31/20 % Annual Budget

Ad Valorem Taxes - General Fund $ 18,752,174 $ 18,694,825 99.69% Non-Property Taxes - General Fund 14,840,000 8,186,493 55.17% Hotel Tax 5,540,000 2,185,756 39.45% Franchise Fees - General Fund 2,332,100 1,351,735 57.96% Service/Permitting/License Fees - General Fund 2,706,790 1,794,179 66.28% Rental Income - All Funds 5,223,600 2,537,255 48.57% Fines and Penalties - All Funds 427,000 191,780 44.91% Special Event Revenue - Hotel Fund 1,297,500 128,960 9.94% Fuel Flowage Fees - Airport Fund 916,000 493,237 53.85% Water and Sewer Charges - Utility Fund 12,927,738 5,094,785 39.41%

Key Expenditures FY2020 Budget Actual through 03/31/20 % Annual Budget

General Fund $ 43,119,096 $ 19,027,690 44.13% Hotel Fund 7,937,706 2,511,079 31.63% Economic Development 1,870,331 716,614 38.31% Airport Operations 5,635,675 2,839,673 50.39% Utility Operations 13,112,660 6,702,934 51.12%

Executive Dashboard – 2nd Quarter, 2020 Fiscal Year Financial & Staffing Indicators Personnel Information:

Economic Development Incentives:

Executed Agreements Amount Paid FY20 Total Incentives Committed 5 $0 $505,334

New Hires - Benefitted Positions 01/2020-03/2020 FY2020 Department Part-Time Positions Full-time positions Total, 4th Qtr YTD

City Manager Conference Centre

2 2 3

Development Services

1 1 1

Finance

2 2 2

Fire

1 1 4

General Services Human Resources Public Works

2 2 3

Municipal Court Parks

1 1 2

Police

1 1 3

Recreation

2 2 2

Special Events

1 Grand Total 2 11 13 23

0.00 5.00 10.00 15.00 Addison (10% decrease)* Carrollton (2% decrease) Farmers Branch (2% increase) Richardson (12% increase)

Millions

2nd Quarter Sales Tax Comparison

FY2019 FY2020 Separations – Benefitted Positions 01/2020-03/2020 FY2020 Department Part-Time Positions Full-time positions Total, 4th Qtr YTD

City Manager Conference Centre

1

Development Services Finance

2

Fire

1 1 1

General Services Human Resources Public Works

1 1 2

Municipal Court Parks

1

Police

2 2 3

Recreation

2

Special Events

1 Grand Total 4 4 13

*Decrease due to audit payment received in FY2019. If not for the audit payment, sales tax would be at an increase of 2.73% compared to Q2 of FY2019.

Source: STR Report (compares to prior year Q2)

Executive Dashboard – 2nd Quarter, 2020 Fiscal Year Economic Indicators

Hotel Indicators:

Hotel Occupancy 53.3% RevPAR $54.81

Occupancy Indicators:

Office Occupancy 78.8% Source: CoStar (compares to prior year Q2) Retail Occupancy 94.0%

17.1% 2.2% 5.6%

0.00% 1.00% 2.00% 3.00% 4.00% 5.00%

DFW Unemployment Rate Last 12 months

$40 $50 $60 $70 $80 $90 $100

Hotel Revenue Per Available Room

0.0% 10.0% 20.0% 30.0% 40.0% 50.0% 60.0% 70.0% 80.0% 90.0% $0 $20 $40 $60 $80 $100 $120

Addison Hotel Statistics

Room Rate (ADR) Rev Par Occupancy

11.3%

1,534 1,312 1,164 742 $0 $20 $40 $60 $80 $100 $120 $140 $160 $180 $200 200 400 600 800 1,000 1,200 1,400 1,600 1,800 FY17 FY18 FY19 FY20 YTD

Millions # of Permits Total Permits Issued and Valuation

Total Permits Issued Total Permit Valuation 141 69 72 93 210 53 70 95 242 132 103 172

• 100

200 300 400 500 600 FY17 2nd Qtr FY18 2nd Qtr FY19 2nd Qtr FY20 2nd Qtr # of Permits

Quarterly Permit Activity, Year over Year

Certificates of Occupancy Building Permits Other Permits

Executive Dashboard – 2nd Quarter, 2020 Fiscal Year Sales Tax Information

$400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 $1,800,000 $2,000,000 $2,200,000 $2,400,000 $2,600,000 $2,800,000

Monthly Sales Tax Collections

FY2018 FY2019 FY2020