Executive Committee Meeting 10-15-24

First page Table of contents Previous page 12-13 Next page Last page

Consent Agenda

Page 7 of 95

BOARD CONSOLIDATED CASH FLOWS DETROIT METRO CONVENTION & VISITORS BUREAU & DETROIT METRO SPORTS COMMISSION BUDGETED CASH FLOWS FOR 2024

ACTUAL/FORECASTS/BUDGETS Jan Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Actual

Budget

3 Beginning Cash Balance

13,205,440.83 12,716,576.81

12,295,643.70 12,324,293.12

12,238,329.13 12,061,368.71

11,684,767.12 14,281,829.39

13,268,302.87

14,974,749

16,332,892

16,405,676

4 5 CASH FROM: 6 ASSESSMENT 7 MEMBERSHIP

$1,258,538.46

1,219,637.08

1,581,273.24

1,605,600.03

1,915,085.34 13,167.19 3,300.00 116,831.19 2,048,383.72

1,826,269.46 14,860.32 107,116.10 258,703.12 2,206,949.00

1,945,845.52

2,126,563.03 16,563.80 19,550.00 110,642.95 2,273,319.78

1,984,114.24

1,852,473

1,661,936

1,312,604

8,363.47

10,166.85

11,582.56

8,260.94 2,300.00 7,203.60

15,357.88 8,745.75 72,254.65

25,812.55 71,772.00 59,657.67

22,363 70,530 35,675

26,622

30,567

8 EVENTS, PUBLICATIONS & SPONSORSHIPS

10,110.00 51,933.24

9 OTHER REVENUES

56,882.13

101,584.64 1,694,440.44

297,796

105,925

10 TOTAL CASH RECEIVED

1,328,945.17

1,286,686.06

1,623,364.57

2,042,203.80

2,141,356.46

1,981,042

1,986,354

1,449,096

11 12 NET CASH

14,534,386.00

14,003,262.87 13,990,084.14

13,947,657.69

14,286,712.85 14,268,317.71

13,726,970.92

16,555,149.17 15,409,659.33

16,955,791

18,319,246

17,854,772

13 14 DIRECT PROMOTIONAL EXPENSES: 15 FAMS, EVENTS & SPONSORSHIPS 16 TRADESHOWS & CONFERENCES

$828,442.34 157,359.01 245,407.94 252,898.38 434,055.74 285,329.01 127,877.70 2,331,370.12

14,697.35 11,883.04 263,012.50 251,409.13 200,345.78 300,315.77 78,512.78 1,120,176.35

83,556.56 5,991.51 392,403.87 395,263.77 335,269.12 493,586.32 153,503.46 1,859,574.61

71,907.17 7,321.74 334,101.07 389,504.28 240,154.81 510,500.53 152,738.30 1,706,227.90

22,446.08 15,728.61 457,654.59 337,356.05 305,870.09 535,411.90 286,087.21 1,960,554.53

356,344.82 136,620.75 308,901.54 297,197.82 215,061.75 578,403.51 211,660.06 2,104,190.25

14,460.78 15,650.25 415,592.78 420,142.44 228,498.72 230,319.04 134,116.48 1,458,780.49

27,812.55 282,519.82 249,900.15 388,216.75 544,194.54 349,219.15 147,353.87 1,989,216.83

54,693.62 24,127.85 282,335.47 313,534.59 129,924.99 281,665.92 102,499.39 1,188,781.83

19,605 147,564 247,536 402,388 261,392 434,350 112,525

13,580 41,053 260,924 516,924 189,472 799,539 98,109

(122,061) 25,872 659,655 199,967 547,491 518,463 226,492 2,055,880

17 SALES

18 DETROIT METRO SPORTS COMMISSION

19 BUREAU SERVICES

20 ADVERTISING & MARKETING

21 PUBLICATION / MKT. COMMUNICATION 22 TOTAL DIRECT PROMOTIONAL EXPENSES:

1,625,359

1,919,601

23 24 OTHER OPERATING EXPENSES: 25 EXECUTIVE & ADMINISTRATIVE 26 TOTAL OTHER EXPENSES:

$122,542.71

51,374.20 51,374.20

142,828.30 142,828.30

108,681.02 108,681.02

144,891.02 144,891.02

117,976.48 117,976.48

101,309.60 101,309.60

138,308.34 138,308.34

97,595.54 97,595.54

$ $

89,137 89,137

$ $

87,990 87,990

$ $

274,981 274,981

122,542.71

28 EXCESS (DEFICIENCY) OF REVENUES OVER EXPENSES (NET)

2,453,912.83

1,171,550.55

2,002,402.91

1,814,908.92

2,105,445.55

2,222,166.73

1,560,090.09

2,127,525.17

1,286,377.37

1,714,496

2,007,591

2,330,861

29 30 +/- RECEIVABLES

3,495.68

(274,488.74) (519,587.33) 494,487.49

(55,946.89) 302,821.54 118,098.46

41,235.24

62,845.20 137,931.68 (292,256.63)

(93,686.07) (850,404.25) 611,125.20

231,096.07 626,851.12 1,285,247.97

(69,994.00)

(8,300.00)

955,655 199,018 (40,651)

8,809

(167,439) 657,576

31 +/- PREPAID EXPENSES 32 +/- ACCRUALS & PAYABLES

(165,000.53) 683,176.95

(458,997.84) 553,317.65

688.84

(180,124.49) 858,248.61

(49,864) 165,348

(1,061,769.37)

3,796

33 +/- BANK LOAN

- - -

- -

0 0

34 +/- AA & OTHER RESERVES

35 +/- FIXED ASSETS

(22,425)

(30,272)

(22,252)

36 +/- FUTURE BUREAU COMMITMENTS 37 +/- DMOC 38 +/- DEPRECIATION/LOSSES FROM LAST YEAR

(662)

114,431.54 636,103.64

(236,480.04) (536,068.62)

(28,361.22) 336,611.89

(29,974.69) 105,580.36

(28,418.84) (119,898.59)

(28,418.74) (361,383.86)

(28,246.60)

181,642.76 851,466.88

39 TOTAL NET CHANGES

2,114,948.56

(1,159,321.13)

1,091,597

94,022

471,019

40 41 PROJECTED NET CASH - ALL SOURCES

12,716,576.81 12,295,643.70

12,324,293.12 12,238,329.13

12,061,368.71 11,684,767.12

14,281,829.39 13,268,302.87

14,974,748.84

16,332,892

16,405,676

15,994,930

M:\Monthly Financials\DMCVB\2024 Monthly FS\09 September 2024\September 2024 Financials\Cash Flow with 093024 Actual Budget Forecast dl 10/8/2024:2:55 PM

CF DMCVB DMSC v1

Made with FlippingBook flipbook maker