WILMINGTON COUNTRY CLUB OPERATING DUES / CAPITAL DUES PROJECT
Scenario - New Capital Due Monthly
Scenario - Increase Sr. Memb/Assoc/2kids
OPERATING DUES DECREASE (MAINTAIN $300M EBITDA)
PROJECTED AVERAGE CAPITAL FUNDING NEED
Sr. Memb/Assoc/2kids
$
285.21
$ $
156.33
-3.40%
$
2,000,000.00
(plug figure)
$ 3,422.54
1,875.95
EXISTING FUNDING MODEL
REVISED FUNDING MODEL
BUDGETED ANNUAL OPER.
ANNUAL OPER.
TOTAL ANNUAL
MEMBERSHIP CLASSES
COUNT
DUES PER CLASS DUES PER CLASS OPER. DUES TOTAL DUES
REV. OPER. DUES PER REV. ANNUAL OPER CLASS 2024/BUDGET DUES 2024/BUDGET
NEW CAPITAL DUES CAPITAL DUES
CAPITAL DUES
COMBINED % INCREASE DUES 2024 OVER BUDGET
INCREASE VS INC VS BUDGET
2024
2023
2024/BUDGET 2024/BUDGET % BY CLASS
2024/BUDGET
PER CLASS
PER MONTH
BUDGET 2024
MONTHLY
SENIOR
725
8,898.00 4,494.00 3,720.00 1,464.00 4,494.00 2,271.00 1,887.00
9,336.00 4,716.00 3,903.00 1,536.00 4,716.00 2,382.00 1,980.00
6,768,600
59.43% 0.95% 2.16% 7.01% 1.53% 0.15% 0.42% 0.14% 0.00% 1.23% 0.04% 2.95% 0.16% 0.14% 0.14% 0.00% 20.45% 0.23% 0.03% 0.25% 0.00% 0.00% 0.63% 0.04% 1.24% 0.67% 0.02% 100.00%
8,595.47 4,341.20 3,593.52 1,414.22 4,341.20 2,193.79 1,822.84
6,231,714.30 99,847.69 226,391.76 735,396.48 160,624.55 15,356.50 43,748.21
1,188,537.27 19,046.52 43,177.06 140,251.82 30,640.05
1,639.36
136.61
10,234.83 5,169.31 4,278.87 1,683.94 5,169.31 2,612.06 2,170.52
10%
898.83 453.31 375.87 147.94 453.31 230.06 190.52
74.90 37.78 31.32 12.33 37.78 19.17 15.88
30 THROUGH 34 25 THROUGH 29 10 THROUGH 24
23 63
108,468 245,889 798,720 174,492 16,674 47,520 15,720
828.11 685.35 269.72 828.11 418.27 347.68 138.02
69.01 57.11 22.48 69.01 34.86 28.97 11.50
520
NON-RESIDENT SENIOR
37
NON-RESIDENT 30 THROUGH 34 NON-RESIDENT 25 THROUGH 29 NON-RESIDENT 10 THROUGH 24 NON-RESIDENT SENIOR TRANSFER
7
2,927.88 8,344.31 2,760.36
24 20
747.00
786.00
721.60
14,432.04
859.62
73.62
6.14
-
8,898.00 8,898.00 4,494.00 3,720.00 1,887.00 3,720.00 3,720.00 4,494.00 4,494.00 2,283.00 1,884.00 2,283.00 1,158.00
9,336.00 9,336.00 4,716.00 3,903.00 1,980.00 3,903.00 3,903.00 4,716.00 4,716.00 2,394.00 1,977.00 2,394.00 1,215.00 1,002.00 1,809.00
-
8,595.47 8,595.47 4,341.20 3,593.52 1,822.84 3,593.52 3,593.52 4,341.20 4,341.20 2,205.38 1,819.94 2,205.38 1,118.63
-
-
-
-
-
-
-
SENIOR SPECIAL
15
140,040
128,932.02
24,590.43
1,639.36
136.61
10,234.83 5,169.31 4,278.87 2,170.52 4,278.87 4,278.87
898.83 453.31 375.87 190.52 375.87 375.87
74.90 37.78 31.32 15.88 31.32 31.32
NON-RESIDENT SENIOR SPECIAL
1
4,716
4,341.20
828.11
828.11 685.35 347.68 685.35 685.35
69.01 57.11 28.97 57.11 57.11
SENIOR SOCIAL
86
335,658 17,820 15,612 15,612
309,042.72 16,405.58 14,374.08 14,374.08
58,940.11 3,129.12 2,741.40 2,741.40
NON-RESIDENT SENIOR SOCIAL
9 4 4
SENIOR SOCIAL SPECIAL
RETURNING DINING
CLERICAL ASSOCIATE
-
-
-
-
-
-
-
-
-
494
2,329,704
2,144,554.78
409,086.08
828.11 420.38 347.15 420.38
69.01 35.03 28.93 35.03
5,169.31 2,625.75 2,167.10 2,625.75
453.31 231.75 190.10 231.75
37.78 19.31 15.84 19.31
ASSOCIATE 30 THROUGH 34 ASSOCIATE 25 THROUGH 29 NON-RESIDENT ASSOCIATE
11
26,334
24,259.16 3,639.89 26,464.54
4,624.14
2
3,954
694.31
12
28,728
5,044.51
NON-RESIDENT ASSOCIATE 30 THROUGH 34 NON-RESIDENT ASSOCIATE 25 THROUGH 29
- -
- -
- -
- -
- -
- -
- -
- -
- -
954.00
921.56
ASSOCIATE SENIOR SOCIAL
40
1,725.00
71,456
1,666.35
65,820.83 4,433.94 130,236.12 69,986.70
12,547.28
317.65 169.10 828.11 317.65 317.65
26.47 14.09 69.01 26.47 26.47
1,984.00 1,055.89 5,169.31 1,984.00 1,984.00 87,354.86
175.00
14.58
NON-RESIDENT SENIOR SOCIAL ASSOCIATE
5
918.00
963.00
4,815
886.79
845.49
92.89
7.74
ASSOCIATE WIDOW
30 42
4,494.00 1,725.00 1,725.00 91,449.00
4,716.00 1,809.00 1,809.00 95,952.00
141,480 75,978
4,341.20 1,666.35 1,666.35 88,339.73
24,843.28 13,341.41
453.31 175.00 175.00
37.78 14.58 14.58
ASSOCIATE SENIOR SOCIAL WIDOW RETURNING DINING ASSOCIATE
1
1,809
1,666.35
317.65
2,175
11,389,798.50
10,486,043.51
2,000,000.00
13,991.99
1,166.00
7,671.86
639.32
-
FORECASTED OBLIGATORY FUNDING:
2024 2025 2026 2027 2028 2029
2,010,117 1,929,385 8,819,952 9,114,271 1,457,434 1,070,189 24,401,348
TOTAL NEED:
AVG ANNUAL NEED: Less Projected Stock:
4,066,891 $1,340,000
Proj. Annual Stock
$1,340,000
ANNUAL DUES SUPPORT
2,726,891
Made with FlippingBook interactive PDF creator