Finance


[PDF]Finance - Rackcdn.comhttps://6d0abe2dbb57132ce294-e31931658c554c23e32ec524623afaf8.ssl.cf1.rackcd...

4 downloads 267 Views 874KB Size

6

74.94 73.54 1.90%

138.08 132.68 4.07%

103.47 97.57 6.05%

991,004 953,932 3.89%

742,652 701,512 5.86%

102,542,287

93,073,749

10.17%

73.39 73.14 0.35%

128.14 128.73 (0.46%)

94.04 94.15 (0.12%)

937,140 919,477 1.92%

687,749 672,463 2.27%

88,126,498 86,567,283

1.80%

MONTH CONSUMED Sep Oct

10.67%

80,916,209 73,117,433

640,905 615,589 4.11%

959,994 923,160 3.99%

84.29 79.20 6.42%

126.25 118.78 6.29%

66.76 66.68 0.12%

Nov

9.14%

59,478,188 54,494,747

539,444 512,632 5.23%

994,748 953,932 4.28%

59.79 57.13 4.67%

110.26 106.30 3.72%

54.23 53.74 0.91%

Dec

5.34%

87,879,324 83,426,161

656,978 642,203 2.30%

997,580 954,649 4.50%

88.09 87.39 0.80%

133.76 129.91 2.97%

65.86 67.27 (2.10%)

Jan

0.67%

45,944,797 45,638,792

361,178 359,477 0.47%

547,060 535,313 2.19%

83.98 85.26 (1.49%)

127.21 126.96 0.20%

66.02 67.15 (1.68%)

02/17 Feb

$ 1.28 B increase in hotel revenues in the

Dallas City Limits Occupancy (%) This Year Last Year % Change ADR ($) This Year Last Year % Change RevPAR ($) This Year Last Year % Change Supply This Year Last Year % Change Demand This Year Last Year % Change Revenue ($) This Year Last Year % Change -

-

-

-

-

-

May

Jun

-

-

-

-

-

-

Jul

-

-

-

-

-

-

Aug

-

-

-

-

-

-

67 months since the district was created

-

-

-

-

-

-

-

Apr

-

-

-

-

-

Mar

(monthly data to prior year)

Dallas City Limits

Hotel Lodging Performance

464,887,303 436,318,165 6.55%

3,628,906 3,503,876 3.57%

5,427,526 5,240,463 3.57%

85.65 83.26 2.88%

128.11 124.52 2.88%

66.86 66.86 (0.00%)

FYTD

1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 -

October

November

80,158 92,300

Variance (Cumulative) Hotel Occupancy Tax Public Improvement District

9.63%

8.47%

December

99,449 136,431

19,291 44,131

9.57%

1,799,595 1,664,207

1,799,595 1,664,207

8.43%

80,158 92,300

2,000,000 1,800,000

9.65%

November 1,780,304 1,620,077

1,586,384 1,462,966

Variance (Monthly) Hotel Occupancy Tax Public Improvement District

Forecast (based on YTD) ## Hotel Occupancy Tax ## Public Improvement District

1,586,384 1,462,966

Actual Hotel Occupancy Tax Public Improvement District

8.16%

October 1,506,227 1,370,666

###

Budget Hotel Occupancy Tax Public Improvement District

7

7.40%

January

6.08%

8.74%

8.45%

9.60%

April

May

243,667 328,821

34,841 47,017

9.69%

1,822,939 1,674,186

9.69%

-

May 1,788,098 1,627,169

9.69%

Actual/Forecast PID

208,826 281,804

34,524 46,590

9.60%

1,806,366 1,658,965

9.60%

-

April 1,771,841 1,612,376

Budget PID

174,301 235,214

30,371 40,985

8.45%

1,589,073 1,459,404

8.45%

-

March 1,558,702 1,418,419

March

143,930 194,229

31,434 42,419

8.74%

1,644,653 1,510,448

8.74%

-

February 1,613,219 1,468,030

Actual/Forecast HOT

February

112,496 151,810

(94,448) (89,792)

5.39%

1,027,373 931,065

5.46%

1,027,373 931,065

January 1,121,821 1,020,857

Budget HOT

206,944 241,602

107,495 105,171

7.80%

1,472,617 1,347,432

7.83%

1,472,617 1,347,432

December 1,365,122 1,242,261

Fiscal Year 2017-18 Revenue - Budget to Actual

Dallas Hotel Occupancy Tax Dallas Tourism Public Improvement District

June

274,540 370,483

30,873 41,662

8.59%

1,615,318 1,483,507

8.59%

-

June 1,584,445 1,441,845

8.59%

July

305,191 411,845

30,651 41,362

8.53%

1,603,691 1,472,829

8.53%

-

July 1,573,040 1,431,467

8.53%

7.64%

7.46%

359,487 485,116

26,824 36,198

359,487 485,116

359,487 485,116

18,808,865 17,274,050

5,885,970 5,405,671

18,449,378 16,788,934

100.00%

September

7.46%

1,403,472 1,288,947

7.46%

-

September 1,376,648 1,252,749

August

332,663 448,918

27,472 37,073

7.64%

1,437,383 1,320,092

7.64%

-

August 1,409,911 1,283,019

8

66.4 67.6 66.8 59.7 52.0 50.7 72.3 66.3 59.3 50.2 67.1 60.9 57.5 65.8 79.5 81.4 57.2 65.4 70.2 74.0 46.1 84.5 76.6 56.2 77.6 74.9 81.4 73.4 53.9 78.1 60.4

68.1 67.9 66.9 59.9 52.0 51.0 75.1 65.9 60.2 55.0 67.0 63.1 58.0 69.0 78.4 85.1 64.4 61.7 69.9 76.9 45.8 85.3 80.1 61.0 79.6 75.4 78.4 68.8 53.2 76.7 58.5 68.5

Top 25 Markets Average

67.6

58.8

59.2

Total United States Class Luxury Upper Upscale Upscale Upper Midscale Midscale Economy Top 25 Markets Anaheim/Santa Ana, CA Atlanta, GA Boston, MA Chicago, IL Dallas, TX Denver, CO Detroit, MI Houston, TX Los Angeles/Long Beach, CA Miami/Hialeah, FL Minneapolis/St Paul, MN-WI Nashville, TN New Orleans, LA New York, NY Norfolk/Virginia Beach, VA Oahu Island, HI Orlando, FL Philadelphia, PA-NJ Phoenix, AZ San Diego, CA San Francisco/San Mateo, CA Seattle, WA St Louis, MO-IL Tampa/St Petersburg, FL Washington, DC-MD-VA 147.42

156.72 114.18 144.93 113.83 113.22 121.68 98.99 110.93 179.06 250.76 165.50 134.77 167.42 185.12 79.55 230.38 140.56 120.13 161.57 156.67 216.32 141.32 96.79 144.07 141.03

279.61 178.63 137.71 110.80 90.46 69.50

125.31

143.23

144.43 111.00 146.98 108.02 110.41 117.56 96.69 140.09 170.69 225.47 108.52 131.48 169.26 182.46 78.58 232.87 131.95 115.45 156.69 151.25 232.37 139.19 96.45 139.52 143.36

272.09 175.43 135.01 108.30 87.19 66.55

121.65

2016

104.36

117.70 75.19 87.21 62.57 75.83 76.80 57.39 76.58 140.37 213.37 106.65 83.21 116.98 142.39 36.40 196.41 112.66 73.25 128.59 118.06 169.70 97.24 51.49 110.44 82.53

190.41 121.36 92.12 66.40 47.07 35.45

74.22

2017

100.27

104.46 73.56 87.22 54.19 74.06 71.61 55.60 92.21 135.61 183.54 62.08 85.98 118.86 134.97 36.24 196.85 101.01 64.91 121.53 113.32 189.23 102.13 52.01 108.97 86.64

180.80 118.59 90.13 64.62 45.36 33.72

71.55

2016

2017

2017

2016

Running 28 Days (ending 02/17/2018) ADR ($) RevPAR ($)

Occ (%)

1.5

3.8 -0.6 1.4 9.6 -0.1 3.6 0.8 4.9 -1.3 4.5 12.7 -5.6 -0.5 4.0 -0.8 0.9 4.7 8.4 2.6 0.6 -3.7 -6.2 -1.4 -1.9 -3.2

2.5 0.5 0.2 0.4 0.0 0.7

0.7

3.5

8.5 2.9 -1.4 5.4 2.5 3.5 2.4 -20.8 4.9 11.2 52.5 2.5 -1.1 1.5 1.2 -1.1 6.5 4.1 3.1 3.6 -6.9 1.5 0.4 3.3 -1.6

2.8 1.8 2.0 2.3 3.7 4.4

3.0

ADR

5.3

12.7 2.2 0.0 15.5 2.4 7.3 3.2 -17.0 3.5 16.3 71.8 -3.2 -1.6 5.5 0.4 -0.2 11.5 12.8 5.8 4.2 -10.3 -4.8 -1.0 1.3 -4.7

5.3 2.3 2.2 2.8 3.8 5.1

3.7

RevPAR

Percent Change (%) Occ

9 70.5% 65.9% 65.8% 61.9% 60.5% 61.0%

Dallas Dallas Dallas Dallas Dallas Dallas

City of Dallas+ Dallas Comp Set+ Atlanta Comp Set+ Chicago Large Comp Set+ Houston Large Comp Set+ New Orleans Large Comp Set+ San Antonio Large Comp Set+ San Diego Large Comp Set+

66.2% 69.2% 74.4% 51.9% 64.6% 70.7% 60.8% 73.8%

64.6% 54.5% 59.1%

Top 25 Markets United States Texas

MD Large Convention Hotels+ MD LuxUpUpsc wout Conv Hotels+ MD Upscale+ MD Upper Midscale+ MD Midscale+ MD Economy+

63.5% 61.0% 56.9% 63.9% 73.3% 81.3% 55.5% 55.7% 60.8% 75.1% 43.2% 83.1% 78.7% 57.9% 70.2% 67.4% 73.4% 62.3% 48.6% 68.7% 52.3%

Dallas, TX Denver, CO Detroit, MI Houston, TX Los Angeles/Long Beach, CA Miami/Hialeah, FL Minneapolis/St Paul, MN-WI Nashville, TN New Orleans, LA New York, NY Norfolk/Virginia Beach, VA Oahu Island, HI Orlando, FL Philadelphia, PA-NJ Phoenix, AZ San Diego, CA San Francisco/San Mateo, CA Seattle, WA St Louis, MO-IL Tampa/St Petersburg, FL Washington, DC-MD-VA

2017

Occ % $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

112.31 119.82 109.45 106.99 172.26 232.42 117.25 126.15 141.90 185.98 75.35 239.42 135.96 118.64 143.52 139.56 269.19 135.33 93.22 131.64 132.23

2017

66.6% 64.7% 74.8% 48.4% 60.7% 69.5% 67.2% 73.9%

66.1% 67.2% 67.2% 63.8% 62.5% 63.2% $ $ $ $ $ $ $ $

$ $ $ $ $ $ 132.66 172.19 193.98 148.80 159.22 193.15 172.99 193.59

178.18 170.33 123.40 97.60 77.61 49.36

63.5% $ 146.00 54.0% $ 123.33 55.7% $ 101.95

64.8% 59.8% 56.7% 55.8% 74.8% 76.7% 52.6% 57.6% 61.9% 72.0% 42.4% 82.9% 75.2% 52.8% 68.4% 66.9% 74.1% 63.2% 48.6% 71.6% 56.4%

2016

108.70 115.42 108.32 103.88 165.99 215.63 106.09 120.49 148.55 184.78 73.77 245.51 124.88 114.28 141.44 142.21 253.48 128.65 92.06 137.07 171.22

$ $ $ $ $ $ $ $

$ $ $ $ $ $ 127.13 168.37 181.97 140.26 161.16 206.43 160.80 207.43

172.21 165.48 121.15 96.39 76.99 48.79

$ 144.18 $ 120.93 $ 98.21

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

2016

71.35 73.08 62.30 68.40 126.32 189.01 65.09 70.30 86.32 139.74 32.55 199.05 107.07 68.70 100.69 94.01 197.49 84.34 45.30 90.39 69.17

$ $ $ $ $ $ $ $

$ $ $ $ $ $

87.87 119.21 144.34 77.28 102.85 136.52 105.19 142.83

125.56 112.23 81.19 60.40 46.98 30.10

$ 94.30 $ 67.17 $ 60.23

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

2017

70.41 68.97 61.37 57.97 124.21 165.31 55.85 69.45 91.98 133.05 31.27 203.61 93.86 60.38 96.69 95.10 187.80 81.30 44.74 98.15 96.58

$ $ $ $ $ $ $ $

$ $ $ $ $ $

84.69 108.95 136.09 67.92 97.84 143.37 108.03 153.24

113.83 111.25 81.45 61.51 48.15 30.84

$ 91.60 $ 65.29 $ 54.69

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

2016

RevPAR ADR

RevPAR

-0.6% 7.0% -0.5% 7.2% 6.4% 1.8% -9.5% -0.1%

6.6% -2.0% -2.1% -3.0% -3.2% -3.5%

1.7% 0.9% 6.1%

4.3% 2.3% 6.6% 6.1% -1.2% -6.4% 7.6% -6.7%

3.5% 2.9% 1.9% 1.3% 0.8% 1.2%

1.3% 2.0% 3.8%

3.8% 9.4% 6.1% 13.8% 5.1% -4.8% -2.6% -6.8%

10.3% 0.9% -0.3% -1.8% -2.4% -2.4%

3.0% 2.9% 10.1%

8.5% 9.4% 6.1% 20.7% 5.0% -4.8% -2.2% -3.9%

10.3% 9.0% 9.2% 9.9% 3.2% -0.7%

5.7% 5.0% 13.1%

4.6% 0.0% 0.1% 6.1% -0.1% 0.0% 0.4% 3.1%

0.0% 8.1% 9.5% 12.0% 5.8% 1.7%

2.6% 2.0% 2.7%

5.5% 5.4% 2.5% 2.8% 4.2% -0.1% 2.9% 4.7% 2.2% 4.1% 0.6% 1.1% 0.8% 2.4% 2.6% 1.2% 2.7% 3.9% 2.0% 3.8% 1.7%

4.0% 7.0% -0.4% 13.7% 6.3% 1.8% -9.1% 2.9%

6.6% 5.9% 7.2% 8.6% 2.4% -1.8%

4.3% 2.9% 8.9%

3.4% 7.5% 3.0% 17.7% 2.1% 6.0% 8.5% 1.2% 0.4% 8.6% 2.5% 1.4% 5.6% 12.3% 5.3% 1.9% 1.7% 2.5% 1.9% -0.5% -5.7%

Room Rev Room Avail Room Sold

-1.9% 3.3% 1.3% 6.9% 2.1% 3.8% 6.0% 11.6% 0.5% 1.0% 1.5% 4.0% 14.6% 3.0% 18.0% 21.3% -2.0% 3.8% 1.7% 6.0% 6.1% 7.8% 14.3% 14.2% 5.4% 10.5% 16.5% 19.9% -3.3% 4.7% 1.2% 6.0% -1.8% -4.5% -6.1% -4.1% 4.4% 0.6% 5.0% 9.3% 1.9% 2.2% 4.1% 4.7% 0.2% -2.5% -2.2% -1.1% 4.8% 8.9% 14.1% 15.0% 9.6% 3.8% 13.8% 16.5% 2.6% 1.5% 4.1% 6.9% 0.7% -1.9% -1.2% 0.0% -1.0% 6.2% 5.2% 8.1% -1.4% 5.2% 3.7% 7.8% 0.0% 1.3% 1.3% 3.2% -4.1% -4.0% -7.9% -4.4% -7.3% -22.8% -28.4% -27.2%

Occ

Percent Change from YTD 2015

Year to Date - December 2017 vs December 2016 ADR

207 16 23 49 25 17 16 18

4 50 117 132 75 145

495 53,794 5,199

686 339 396 886 1,024 428 345 354 293 654 334 93 498 400 474 485 397 359 332 466 722

Census

32,180 10,768 13,683 28,713 12,616 10,983 7,840 10,635

5,567 15,902 16,932 12,919 6,846 15,670

66,209 5,133,903 463,903

86,128 47,304 43,623 87,718 102,709 54,816 42,740 41,737 40,358 119,899 36,372 29,901 124,882 48,176 65,299 61,748 52,423 45,160 38,872 46,381 112,017

Census

Rooms

Participation Properties

10

49.49% 2.47% 1.58% 0.76% 45.03% 0.67% 100.00%

2018 Budget 18,449,378 922,500 589,375 281,875 16,788,934 250,000 37,282,062

35,462,875

1,024,657 204,931 250,000

2.79% 0.56% 0.68%

100.00%

5,548,545 2,167,799 1,246,615 4,461,753 2,338,695 3,251,814 16,197,654 -

15.12% 5.91% 3.40% 12.16% 6.37% 8.86% 44.14% -

6,232,817

-

360,403 199,345 99,996 428,432 286,019 378,958 2,311,818 2,167,846 -

(63,047) (174,900)

(111,853)

926,219 117,912 154,640 180,810 1,709,627 695,811 279,952 2,167,846 6,232,817

01/18 MTD Actual 961,806 73,064 47,130 4,164,202 874,762 6,120,964

987,893 156,483 930,003 226,059 927,208 390,388 150,799 533,839 4,302,672

13,683 51,201 827,432 (1,117) (178,713) 69,481 52,458 533,839 (20,833) 1,347,431

January, 2018 MTD MTD Actual Variance 1,048,340 (73,481) (76,875) 110,555 61,441 25,666 2,177 931,065 (89,792) 320,154 320,154 2,435,780 143,624

2,955,241

85,388 17,078 20,833

466,545 180,650 103,884 382,229 196,975 275,151 1,349,807 -

4,302,672

85,388 17,078 20,833

497,794 283,627 161,947 488,659 162,659 223,071 1,951,076 533,839 -

1,347,431

-

31,249 102,977 58,063 106,430 (34,316) (52,080) 601,269 533,839 -

(102,466) (102,466) (765,551) (1,969,358) (1,203,807)

(663,085) (1,866,892) (1,203,807)

974,210 105,282 102,571 227,176 1,105,921 320,907 98,341 20,833 2,955,241

MTD Budget 1,121,821 76,875 49,114 23,489 1,020,857 2,292,156

45.59%

Note: in NET row, positive numbers mean revenues in excess of expenditures and negative numbers reflect a shortfall.

-

6.70% 57.00% 55.89% 27.84% (17.42%) (18.93%) 44.54% -

13,715,801

-

1,412,188 845,210 336,000 1,387,533 742,856 1,093,221 4,109,174 3,789,619 -

(252,188) 945,320

1,197,508

1.40% 3,643,725 48.63% 376,163 806.69% 274,670 (0.49%) 516,723 (16.16%) 3,092,809 21.65% 1,330,053 53.34% 692,039 3,789,619 (100.00%) 45.59% 13,715,801

01/18 Percent YTD Variance Actual (6.55%) 5,466,099 (100.00%) 294,242 125.10% 66,155 9.27% 4,254,432 (8.80%) 4,832,381 6.27% 14,913,309

Note: in the MTD and YTD Variance columns, positive numbers mean over budgeted figures and negative number mean under budgeted figures.

Total

Executive Administrative Fixed Operating Costs Sales Experience Marketing Public Improvement District Event Trust Fund Future Obligations Special Funds: Cash Flow Future Obligations Capital Expenditures In-Kind

ALLOCATIONS/EXPENDITURES By Function

(1,229,588) 589,599

Use of Reserves Additions to Reserves Change in Cash

11,690,527 1,263,404 1,230,838 2,726,113 13,271,046 3,850,873 1,180,074 250,000 35,462,875 1,819,187

32.97% 3.56% 3.47% 7.69% 37.42% 10.86% 3.33% 0.70% 100.00%

NET (Revenues - Expenditures)

Payroll & Related Costs Fixed Operating Costs Other Operating Expenses Travel & Entertainment Media & Promotional Activities Advertising & PR Services Professional Services Event Trust Fund Future Obligations In-Kind Total

EXPENDITURES/INVESTMENTS By Type

Hotel Occupancy Tax Dues Sponsorships/Partnerships Other Miscellaneous Public Improvement District Event Trust Fund Futue Obligations In-Kind Total

REVENUES

Dallas Convention & Visitors Bureau Fiscal Year 2017-2018

11,820,956

341,552 68,310 83,333

1,866,182 722,599 415,538 1,528,918 787,898 1,100,605 5,399,216 -

(409,863) (605,568)

12,165,896

341,552 68,310 83,333

1,772,637 919,238 385,601 1,514,773 1,018,033 965,945 4,315,195 1,270,474 4,000

4,000 (409,863) 528,376

934,239

12,165,896

11,820,956

(195,705)

3,872,501 379,640 1,165,332 635,971 2,961,148 1,386,026 490,804 1,270,474 4,000 -

344,940

-

(93,545) 196,639 (29,937) (14,145) 230,135 (134,660) (1,084,021) 1,270,474 4,000

4,000 1,133,944

1,129,944

(24,340) (41,493) 755,053 (272,734) (1,462,534) 102,402 97,445 1,270,474 4,000 (83,333) 344,940

October - January YTD YTD Actual Variance 6,006,091 232,617 225,548 (81,952) 165,273 (31,186) 241,566 147,609 5,405,670 151,809 1,055,987 1,055,987 13,100,135 1,474,884

3,896,841 421,133 410,279 908,705 4,423,682 1,283,624 393,359 83,333

11,625,251

YTD Budget 5,773,474 307,500 196,459 93,957 5,253,861 -

2.92%

-

23,296,979

683,104 136,621 166,667

(5.01%) 3,775,908 27.21% 1,248,561 (7.20%) 861,014 (0.93%) 2,946,980 29.21% 1,320,662 (12.24%) 2,285,869 (20.08%) 11,882,459 (1,270,474) (4,000)

(4,000) (819,725) 61,223

884,948

4,000 (1,229,588) 1,640,212

2,865,800

(0.62%) 7,818,026 11,666,186 (9.85%) 883,764 1,221,909 184.03% 65,506 1,985,891 (30.01%) 2,090,142 2,453,380 (33.06%) 10,309,898 11,808,512 7.98% 2,464,847 3,953,275 24.77% 689,270 1,277,520 (1,270,474) (4,000) 4,000 (100.00%) 250,000 250,000 2.92% 23,296,979 35,891,146

Remaining Percent 2018 Projected Variance Budget Year-End 4.03% 12,443,287 18,681,995 (26.65%) 696,952 840,548 (15.87%) 424,102 558,190 157.10% 40,309 429,483 2.89% 11,383,264 16,940,743 (1,055,987) 1,055,987 250,000 250,000 12.69% 24,181,927 38,756,946

80

23 15 13

Budgeted Positions 19 10

Executive Summary

Hotel Occupancy Tax is $73k or 7% below budget for the month and $233k or 4% above budget YTD. Dues are $77k or 100% below budget for the month and $82k or 27% below budget YTD. Income from membership dues is deferred over a 12-month period and, as such, remains relatively constant. Hotel member dues will start being paid by DTPID next month. Sponsorships/Partnerships is $61k or 125% above budget for the month and $31k or 16% below budget YTD. The timing of actual receipts will result in dramatic swings in the MTD and YTD variances. These will also vary as the PID continues to cover certain costs previously born by the hotels. The larger sponsorship opportunities occur in the fourth quarter. Other Miscellaneous is $2k or 9% above budget for the month and $148k or 157% above budget YTD. Percentage variations seem high in this category due to the relatively small budget associated with the revenue streams. PID Assessment is $90k or 9% below budget for the month and $152k or 3% above budget YTD. Event Trust Fund is not initially budgeted. Funds are recognized as they become available through the program (currently at $1,056k).

Executive Summary

Generally, the shortages in HOT, PID and ETF will get readjusted as we close out the fiscal year and do not have a negative impact on this year’s overall VisitDallas budget. Some of the anticipated revenue this year was offset by the PID; additionally, there is approximately $0.5 million in inkind contributions that will also be included before yearend close.

• •





• •

Revenues: $144k or 6% above budget for the month; $1,475k or 13% above budget for the year

EXPLANATION OF VARIANCES

Dallas Convention & Visitors Bureau Fiscal Year 2017-2018

• • •



• •

• • •

Payroll & Related Costs are $14k or 1% under budget for the month and $24k or 1% under budget YTD. Fixed Operating Costs are $51k or 49% over budget for the month and $41k or 10% under budget YTD. Other Operating Expenses are $827k or 807% over budget for the month and $755k or 184% over budget YTD. Overages here relate to the timing of certain DTPID expenses to the KBHCCD and the state and local hotel associations. Travel & Entertainment is $1k or 0.5% under budget for the month and $273k or 30% under budget YTD. Media & Promotional Activities are $179k or 16% over budget for the month and $1,463k or 33% over budget YTD. The primary variance is related to the timing of incentives paid to citywide meetings; consumption will always vary from budget. Additional variances are due to the timing of paid advertising campaigns. Advertising & PR Services are $69k or 22% over budget for the month and $102k or 8% over budget YTD. This overage is due to the timing of certain advertising and PR contract expenses, as well as higher production for videos and other creative materials. Professional Services are $52k or 53% over budget for the month and $97k or 25% over budget YTD. Event Trust Fund – These funds are unbudgeted and only obligated as part of the state’s incremental tax program (currently at $1,270k). Future Obligations – These refer to expenses for large groups set aside in prior years. They do not come out of the current year’s budget, but rather from the reserves accumulated for that purpose.

Expenditures: $1,347k or 46% over budget for the month; $345k or 3% over budget for the year

11

12

(102,466) 1,580,624

Use of Reserves Additions to Reserves Change in Cash

Cash (end of period) CD's (Reserve)

Cash (beginning of period) Change in Net Deficit Purchases Depreciation Write-Down of Initial Estimates Prepaid Expenses Accounts Receivable Accounts Receivable - City Accounts Payable Deferred Support Deferred Support - Membership Accrued Liabilities Investing Activities Change in Cash/Equivalents

(604,499) -

231,766 1,683,090 9,016 (379,063) 401,913 (58,012) (32,375) (876,591) (1,584,243) (836,265)

1,683,090

NET

CASH FLOW

1,040,343 81,187 30,193 62,597 537,785 128,465 46,913 (396,219) 1,531,264

Actual October 1,618,759 77,695 10,575 44,359 1,462,966 3,214,354

Payroll & Related Costs Fixed Operating Costs Other Operating Expenses Travel & Entertainment Media & Promotional Activities Advertising & PR Services Professional Services Event Trust Fund Future Obligations In-Kind Total

EXPENDITURES

Hotel Occupancy Tax Dues Sponsorships/Partnerships Other Miscellaneous Public Improvement District Event Trust Fund Future Obligations In-Kind Total

REVENUES

Dallas Convention & Visitors Bureau Fiscal Year 2017-2018

Actual

(307,488) -

(604,499) 495,130 9,016 (466,227) (141,403) (213,234) (36,726) 261,802 (650) 389,303 297,011

4,000 (102,466) 396,664

495,130

914,547 95,808 81,179 137,481 813,096 587,205 191,246 562,000 4,000 3,386,562

1,836,321 74,675 26,443 15,060 1,664,207 264,986 3,881,692

November

(1,866,892)

987,893 156,483 930,003 226,059 927,208 390,388 150,799 533,839 4,302,672

Actual January 1,048,340 110,555 25,666 931,065 320,154 2,435,780

3,337,645 -

2,482,795 -

(307,488) 3,337,645 622,911 (1,866,892) 2,130,889 96,213 147,931 (99,358) 391,477 399,639 (30,053) (20,967) (223,186) 228,129 71,798 605,164 336,588 3,645,133 (854,850)

(102,466) (102,466) 520,445 (1,969,358)

622,911

929,718 46,162 123,957 209,834 683,059 279,968 101,846 570,854 2,945,398

Actual December 1,502,671 73,178 17,700 156,481 1,347,432 470,847 3,568,309

2,779,117 -

2,482,795 296,322 296,322

(102,466) 193,856

296,322

974,211 105,284 102,570 227,176 1,105,921 320,906 98,340 2,934,406

Projected February 1,613,219 76,875 49,115 23,490 1,468,030 3,230,728

2,971,310 -

2,779,117 192,193 192,193

(102,466) 89,728

192,193

974,211 105,284 102,570 227,176 1,105,921 320,906 98,340 2,934,406

Projected March 1,558,702 76,875 49,115 23,490 1,418,419 3,126,599

3,570,600 -

2,971,310 599,290 599,290

(102,466) 496,824

599,290

974,211 105,284 102,570 227,176 1,105,921 320,906 98,340 2,934,406

Projected April 1,771,841 76,875 49,115 23,490 1,612,376 3,533,696

4,200,940 -

3,570,600 630,340 630,340

(102,466) 527,875

630,340

974,211 105,284 102,570 227,176 1,105,921 320,906 98,340 2,934,406

Projected May 1,788,098 76,875 49,115 23,490 1,627,169 3,564,747

4,442,304 -

4,200,940 241,364 241,364

(102,466) 138,898

241,364

974,211 105,284 102,570 227,176 1,105,921 320,906 98,340 2,934,406

Projected June 1,584,445 76,875 49,115 23,490 1,441,845 3,175,770

4,661,884 -

4,442,304 219,580 219,580

(102,466) 117,114

219,580

974,211 105,284 102,570 227,176 1,105,921 320,906 98,340 2,934,406

Projected July 1,573,040 76,875 49,115 23,490 1,431,467 3,153,986

4,569,886 -

4,661,884 (91,998) (91,998)

(102,466) (194,463)

(91,998)

974,211 105,284 102,570 227,176 1,105,921 320,906 98,340 2,934,406

Projected August 1,409,911 76,875 49,115 23,490 1,283,019 2,842,409

Projected

4,414,356 -

4,569,886 (155,530) (155,530)

(102,466) (257,996)

(155,530)

974,211 105,284 102,570 227,176 1,105,921 320,906 98,340 250,000 3,184,406

1,376,648 76,875 49,115 23,490 1,252,749 250,000 3,028,876

September

4,414,356 -

231,766 2,865,800 18,032 1,381,812 309,083 519,870 (120,121) (609,846) 71,148 (253,188) 4,182,590

4,000 (1,229,588) 1,640,212

2,865,800

11,666,186 1,221,909 1,985,891 2,453,380 11,808,512 3,953,275 1,277,520 1,270,474 4,000 250,000 35,891,146

Projected Year-End 18,681,995 840,548 558,190 429,483 16,940,743 1,055,987 250,000 38,756,946

100,000 (1,229,588) 689,599

1,819,187

11,690,527 1,263,404 1,230,838 2,726,113 13,271,046 3,850,873 1,180,074 250,000 35,462,875

2018 Budget 18,449,378 922,500 589,375 281,875 16,788,934 250,000 37,282,062

(96,000) 950,613

1,046,613

(24,341) (41,495) 755,053 (272,733) (1,462,534) 102,402 97,446 1,270,474 4,000 428,271

Variance 232,617 (81,952) (31,185) 147,608 151,809 1,055,987 1,474,884

Cash Flow

Notes: While expenses are budgeted evenly across the fiscal year; the timing of the actual expenses can cause dramatic swings in MTD and YTD variances. It is expected that the amounts shown currently under budget will be fully expended by year’s end.









The NET line in the center of the page represents the surplus of revenues for that month over the expenditures for that month. Negative numbers indicate a deficit. The Change in Cash line reflects the NET number above with Reserves being used as the source for current year portions of Future Obligations. It also reflects additions to Reserves for Future Obligations beyond the current year. The bottom half of the page shows Cash and Cash Equivalents at the beginning of the month, the adjusting transactions for the month, and the Cash and Cash Equivalents at the end of the month. This bottom line indicates how much available cash we anticipate having at the end of each month. This statement is simplified by only showing actual monthly transactions and assuming no major changes for the remaining months.

Explanations:



Revenues – This projection shows revenues actually collected to date and assumes future collections at budget levels. The monthly spread is based on historical information and any known special circumstances in the current fiscal year. Expenditures – This report shows expenditures actually spent to date and projects future expenses within budget. Managers are monitoring their available budget monthly and adjusting spending patterns to avoid any deficits. Most expenses are spread evenly over the 12-month period.

Assumptions:



Executive Summary

Special Funds – While not actual expenses, these are funds set aside for Future Obligations and not available in the current year.

EXPLANATION OF CASH FLOW AND ASSUMPTIONS



Dallas Convention & Visitors Bureau Fiscal Year 2017-2018

13

VisitDallas Statement of Activities As of Wednesday, January 31, 2018 Audited FY 2017 Actual

MTD 1/31/2018 Budget

FY 2018 Budget

MTD 1/31/2018 Actual

YTD 1/31/2018 Budget

YTD 1/31/2018 Actual

SUPPORT & REVENUE Hotel-Motel Tax PID Recovery Fee Membership Sponsorships Partnerships Government Funding Rebates Registration Advertising/Royalties Merchandise Sales Ticket Sales Interest Other Income In-Kind Donations TOTAL SUPPORT & REVENUE

$16,675,447 14,890,959 888,967 103,340 171,107 7,341,765 10,451 29,715 125,503 1,643 668,048 0 (8,838) 651,964 $41,550,071

$18,449,378 16,788,934 922,500 256,250 333,125 0 20,500 5,125 76,875 0 153,750 5,125 20,500 250,000 $37,282,062

$1,121,821 1,020,857 76,875 21,354 27,760 0 1,708 427 6,406 0 12,813 427 1,708 0 $2,292,156

$1,048,340 931,065 0 14,000 96,555 320,154 0 3,017 10,359 0 12,290 0 0 0 $2,435,780

$5,773,474 5,253,861 307,500 85,417 111,042 0 6,833 1,708 25,625 0 51,250 1,708 6,833 0 $11,625,251

$6,006,092 5,405,671 225,548 21,500 143,773 1,055,987 133,110 37,312 39,700 0 31,444 0 0 0 $13,100,137

EXPENSES PROGRAM SERVICES: Executive Diversity & Inclusion Sports Marketing Tourism Film Commission Sales Management Sales Experience Management Partner Experience Visitor Experience Client Experience Marketing Public Relations Special Events & Activities Event Trust Fund Public Improvement District TOTAL PROGRAM SERVICES

1,089,004 560,280 1,085,027 1,782,637 169,158 1,544,613 3,047,493 881,285 535,664 167,980 946,479 1,787,244 866,289 178,999 7,289,818 11,786,238 33,718,208

1,327,413 501,070 1,457,872 2,112,191 200,000 1,154,233 3,432,520 485,458 553,287 306,024 1,018,926 2,143,130 1,158,684 0 0 16,788,934 32,639,742

110,618 41,756 121,489 176,016 16,667 96,186 286,043 40,455 46,107 25,502 84,911 178,594 96,557 0 0 1,399,078 2,719,979

129,668 53,718 112,472 191,893 10,037 189,825 298,834 61,644 39,636 10,183 51,197 181,853 41,217 0 533,839 1,951,076 3,857,092

442,471 167,023 485,957 704,064 66,667 384,744 1,144,173 161,819 184,429 102,008 339,642 714,377 386,228 0 0 5,596,311 10,879,913

566,937 183,826 415,892 537,031 68,940 448,719 1,066,054 294,644 187,977 61,104 474,309 798,801 167,144 4,000 1,730,089 4,315,195 11,320,662

NON-PROGRAM EXPENSES: Finance & Administration Contracted Services Fixed Operating Costs Depreciation & Amortization TOTAL NON-PROGRAM EXPENSES TOTAL EXPENSES

2,260,390 582,725 1,147,255 342,892 4,333,262 38,051,470

1,842,798 325,000 927,373 319,242 3,414,413 36,054,155

153,567 27,083 77,281 26,603 284,534 3,004,513

208,918 74,709 161,947 0 445,574 4,302,666

614,266 108,333 309,124 106,414 1,138,137 12,018,050

727,293 191,944 346,456 39,145 1,304,838 12,625,500

Change in Net Assets Net Assets at beginning of year Net Assets at end of year

3,498,603 23,697,188 27,195,789

1,227,906 0 1,227,907

14

(712,356) 0 (712,357)

(1,866,885) 0 (1,866,886)

(392,801) 0 (392,799)

474,640 27,655,405 28,130,042

VisitDallas Balance Sheet As of Wednesday, January 31, 2018

Audited Year to Date 9/30/2014

Audited Year to Date 9/30/2015

Audited Year to Date 9/30/2016

Audited Year to Date 9/30/2017

Year to Date 1/31/2018

$395,394 10,985,897 657,071 1,963 $12,040,325

$1,714,668 14,063,732 0 4,136 $15,782,536

$1,728,049 18,123,139 0 6,010 $19,857,198

$1,308,111 19,618,457 0 7,516 $20,934,084

$3,917,028 19,368,457 0 7,516 $23,293,001

2,013,664 0 2,169,306 0 7,056 57,320 (1,000) 1,000

2,151,671 0 4,917,690 (116,961) 8,767 74,511 (1,000) 0

2,670,533 0 2,241,527 (116,961) 8,538 71,093 (1,000) 0

1,656,770 1,083,903 4,703,313 (251,182) 8,338 83,516 (1,000) 0

1,617,691 931,065 3,474,339 (251,182) 7,823 199,118 (1,000) 250

35,000 108,246 3,789 129,891 100,000 $4,624,272

116,443 21,299 0 24,728 100,000 $7,297,148

135,000 27,641 0 137,767 100,000 $5,274,138

225,000 641,056 0 141,895 100,000 $8,391,609

225,000 165,048 0 141,895 100,000 $6,610,047

NOTES RECEIVABLE: Notes Receivable - Long Term Premium on Notes Receivable TOTAL NOTES RECEIVABLE

1,396,654 712,105 2,108,759

1,392,778 691,253 2,084,031

1,170,700 666,525 1,837,225

1,057,533 637,797 1,695,330

957,533 637,797 1,595,330

PREPAID EXPENSES: Prepaid Rent Prepaid Rent - AAC Other Prepaid Expenses TOTAL PREPAID EXPENSES

51,466 187,500 79,213 $318,179

51,466 187,500 814,076 $1,053,042

51,466 187,500 570,468 $809,434

51,466 206,250 458,406 $716,122

51,466 206,250 149,324 $407,040

242,597 328,026 79,722 76,530 8,963 150,812 0 11,689

213,939 286,658 34,519 17,722 1 33,495 0 11,689

162,136 245,289 18,039 440,238 0 0 0 0

111,429 203,921 1,922 271,754 216,738 0 175,516 0

102,978 197,026 (764) 271,754 216,738 (21,113) 175,516 0

ASSETS CASH: Checking Accounts DTPID Account Certificate of Deposit Paypal Reserve TOTAL CASH ACCOUNTS RECEIVABLE: City of Dallas (HOT) City of Dallas (DTPID) Special Event Trust Funds ETF Reserve Business Travel Expense Advance Membership Allowance for Doubtful Accounts Membership Hotel Assessment A/R City of Dallas Employee A/R A/R Miscellaneous Interest Receivable - CDs Notes Receivable - Short Term Deferred Rent - Current TOTAL ACCOUNTS RECEIVABLE

FIXED ASSETS: Furniture & Fixtures (Net of Depreciation) Leasehold Improvements (Net of Amortization) Computer Systems (Net of Amortization/Depreciation) Web Page (Net of Amort/Depreciation) Marketing Video (Net of Depreciation) Brand Development (Net of Depreciation) Tourism Display (Net of Amortization/Depreciation) Telephone Equipment (Net of Amortization/Depreciation)

15

VisitDallas Balance Sheet As of Wednesday, January 31, 2018

Audited Year to Date 9/30/2014

Audited Year to Date 9/30/2015

Audited Year to Date 9/30/2016

Audited Year to Date 9/30/2017

Year to Date 1/31/2018

$0 $898,339

$276,700 $874,723

$0 $865,702

$60,750 $1,042,030

$60,750 $1,002,885

1,300,000 $21,289,874

1,200,000 $28,291,480

1,100,000 $29,743,697

1,000,000 $33,779,175

1,000,000 $33,908,303

LIABILITIES AND FUND BALANCE/NET ASSETS CURRENT LIABILITIES: Accounts Payable - Trade Accounts Payable - Purchase Cards Accounts Payable - Other Accrued Liabilities Accrued Liabilities - SETF Accrued Salaries & Incentives Accrued Vacation Deferred Compensation Deferred Membership Income Deferred Construction Allowance TOTAL CURRENT LIABILITIES

569,570 0 46,329 (9,838) 1,073,127 1,149,453 256,491 80,000 282,347 11,429 $3,458,908

758,509 (13,290) 53,642 (9,838) 3,054,065 1,325,317 311,905 160,000 334,102 11,429 $5,985,841

608,840 9,077 37,906 (249,838) 1,335,849 1,265,144 311,905 240,000 360,050 11,429 $3,930,362

801,811 8,235 150,948 (249,838) 1,489,553 1,442,337 371,551 240,000 368,268 11,429 $4,634,294

393,130 (145,558) 158,895 (249,838) 2,149,321 529,381 371,551 240,000 370,858 11,429 $3,829,169

Deferred Rent Deferred Construction Allowance Deferred Revenue - Suite Tickets TOTAL LIABILITIES:

111,971 72,381 2,312,800 $5,956,060

108,355 60,952 2,108,760 $8,263,908

91,628 49,523 1,974,992 $6,046,505

73,770 38,094 1,837,225 $6,583,383

73,770 38,094 1,837,225 $5,778,258

8,267,459 7,066,370 $15,333,829 $21,289,889

15,333,829 4,693,744 $20,027,573 $28,291,481

20,027,572 3,669,620 $23,697,192 $29,743,697

23,697,188 3,498,603 $27,195,791 $33,779,174

27,655,405 474,640 $28,130,045 $33,908,303

Fixed Asset Clearing Account TOTAL FIXED ASSETS Deferred Rent - Long Term TOTAL ASSETS

FUND BALANCE: Operating Reserve Prior Year Year-to-date change in Operating Reserve TOTAL FUND BALANCE TOTAL LIABILITIES & FUND BALANCE

16

17

Tourism 35%

Sports 15%

0

50,000

100,000

150,000

200,000

250,000

Self-Contained

YTD Goal

Citywide

Sports

YTD Actual

Room Night Production

Tourism

352,549 Room Nights at 60.6% of YTD goal 4 Citywides at 49.3% of YTD goal

Express

DALLAS CONVENTION & VISITORS BUREAU | COPYRIGHT 2017

SelfContained 18%

Citywide 22%

Express 10%

Goal Allocation

(data current as of 02/25)

Room Night/Citywide Details

FY2018 Metrics

18

2. Continue process to revamp traditional visitor center concept into the Dallas Experience Center (DXC) (an environment that exceeds visitor expectations, becomes an integral part of organization activities, provides a valuable resource to other stakeholders, and helps VisitDallas achieve additional strategic objectives). 3. Work with the City of Dallas, the hotel community, and other stakeholders to begin to develop a phased implementation plan of the Market & Future Strategy Study, including any additional research or analysis that may be required 4. Continue to meet with statewide and local elected officials, community leaders, and CEOs to increase the awareness and perception of VisitDallas. As part of local awareness and advocacy building efforts, identify a timeline and develop a campaign strategy to grow support and obtain approval for Metric 3 above

• Meet or exceed 2,200,000 room night bookings

1. Generate additional economic impact for the City of Dallas and DFW Region by maximizing visitors through Sales, Sports, Marketing, and Tourism (international and domestic) efforts utilizing Diversity & Inclusion best practices • Meet or exceed 15 citywide bookings

Metric



20%







Pace



352,549

4

YTD

10%

20%

35%

15%

Weight

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

Projected