Revenue & Calc
Edit member households, dues mix, guest golf, cart riders, lessons, dining, events, retail sales, and seasonal activity. Calc translates those assumptions into monthly revenue streams.

The Country Club Financial Model is an Excel financial planning template for a leased, 18-hole country club with golf and social memberships, guest play, tennis instruction, clubhouse dining, private events, and pro shop sales. It converts member demand, service prices, staffing, and operating costs into monthly calculations and five-year financial projections.
The illustrated case covers an existing club in Baltimore County, Maryland, from 2026 through 2030, beginning January 31, 2026. The example reflects planning assumptions rather than actual club performance or independently established industry averages; buyers can revise the inputs for their own operation.
The workbook connects country club operating assumptions to monthly calculations, financial statements, funding schedules, and management reports.
Edit member households, dues mix, guest golf, cart riders, lessons, dining, events, retail sales, and seasonal activity. Calc translates those assumptions into monthly revenue streams.
Plan food and beverage costs, merchandise, operating contracts, grounds expenses, and employee FTE by role. Separate salary schedules prevent personnel costs from being counted twice.
Review projected earnings, cash movements, financial position, and combined reporting. These are workbook capabilities; the supplied country club case establishes operating results only through EBITDA.
Revenue is driven by member household demand, the selected dues tiers, paid service attachments, and the price of each service.
The 2026 case begins with 450 member households, increasing to 600 by 2030. Of these, 65% purchase full golf memberships at $750 per household per month, while the remaining 35% pay $350 for social membership. Each household belongs to one dues tier, with no initiation fees or dining minimums.
Beyond dues, the club prices guest golf rounds at $80, optional cart seats at $28, lessons at $90, dining checks at $35, private events at $6,000, and pro shop transactions at $45. Member green fees are already included in dues, avoiding a second green-fee charge.
The Revenue Forecast organizes membership counts, tier prices, guest rounds, cart attachments, lessons, dining visits, event bookings, and retail transactions. Those assumptions feed monthly revenue calculations and show how each income stream contributes to projected country club sales.
450 households × 65% × $750 plus 450 households × 35% × $350 = $274,500 in monthly dues.
Activity planning uses four member rounds and 0.4 guest rounds per golf household in a normal month, a 65% cart-rider attachment, and 0.15 lessons plus four dining checks per member household. Event demand is 0.005 bookings per household, while retail transactions equal 18% of player rounds.
Dues remain level within each year; non-dues streams use a repeating twelve-month seasonal pattern, from a 0.3 multiplier in January and February to 1.6 in June and July. The pattern averages 1.00 annually. The golf course, clubhouse, and event room define the setting, not additional revenue caps.
The operating forecast subtracts direct costs, revenue-linked variable expenses, fixed monthly outlays, and dedicated payroll from country club revenue.
COGS assumptions include 7.48% of revenue for food, beverages, and event ingredients, 1.56% for pro shop merchandise, and 0.4% for golf and lesson consumables. Variable expenses add 1.6% for payment processing, 0.8% for disposables, and 0.5% for member referral promotions.
Fixed expenses cover the operating lease, irrigation, agronomy supplies, maintenance, insurance, lease-related property taxes, software, licenses, security, and marketing. The facility lease alone is modeled at $35,000 monthly in 2026, with a separate annual input for each later forecast year.
The COGS and Operating Expenses report groups direct purchasing costs, percentage-of-revenue spending, and fixed club operating bills. It shows the expense drivers behind gross and contribution margins without treating salaries as direct costs or counting employee pay twice.
| Category | 2026 | 2030 |
|---|---|---|
| COGS | $453,371 | $604,495 |
| Variable expenses | $139,299 | $185,731 |
| Fixed expenses | $1,620,000 | $1,823,324 |
| Payroll | $2,094,000 | $2,551,000 |
All categories use the illustrative planning case and are rounded independently to whole dollars.
The Payroll Forecast estimates personnel costs from FTE plans, role salaries, and staffing dates. For example, the grounds crew starts at $46,000 annual base pay per FTE, and the model increases crew staffing from 12 FTE in 2026 to 14 in 2030.
Opening investments, transition expenses, owner funding, and working capital are modeled separately from the country club’s recurring operating earnings.
The startup plan identifies a $280,000 golf cart fleet, $600,000 grounds equipment fleet, $200,000 clubhouse renewal, and $120,000 commercial kitchen renewal. Other planned assets include pool and court improvements, irrigation, and member-system hardware. These purchases are not recurring COGS or payroll.
The Capital Expenditure Plan schedules equipment purchases, property improvements, and eligible depreciation based on their expenditure dates. It helps distinguish asset investment from ongoing clubhouse upkeep and links capital spending to supporting financial statements without reducing EBITDA by the full purchase price.
The example also identifies refundable lease deposits, permits, legal and transition costs, launch marketing, preopening training, and opening agronomy stock as separate cash needs. Working capital controls include four accounts-receivable days, 21 accounts-payable days, and 19 inventory days.
Initial owner funding is estimated at $2,896,570, using startup assets, one-time cash, opening net working capital, and a three-month recurring reserve, less confirmed funding. This is a planning estimate, not a verified peak cash requirement or evidence that financing has been secured.
The Sources and Uses of Funds report reconciles incoming equity or debt with operating, investing, and financing cash uses over a selected reporting window. It supports a funding review separate from EBITDA and can help examine the allocation of capital across the club.
The illustrative country club operating forecast shows revenue, total operating expenses, and EBITDA for every year from 2026 through 2030.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $4,803,397 | $4,306,670 | $496,727 |
| 2027 | $5,337,108 | $4,532,122 | $804,986 |
| 2028 | $5,870,819 | $4,791,532 | $1,079,286 |
| 2029 | $6,137,674 | $4,961,018 | $1,176,656 |
| 2030 | $6,404,530 | $5,164,551 | $1,239,979 |
Illustrative model projections, not observed results. Values are rounded independently; displayed subtraction may differ slightly.
The example grows revenue from $4,803,397 in 2026 to $6,404,530 in 2030 as member households expand and separately charged services scale with participation. EBITDA increases from $496,727 to $1,239,979, implying an EBITDA margin increase from approximately 10.3% to 19.4%.
The Cash Flow Forecast tracks operating receipts and payments, capital expenditures, debt activity, and equity contributions to show the movement from opening to closing cash. It is the appropriate report for examining liquidity and financing timing rather than treating positive EBITDA as available cash.
Returns and scenario reports help test whether changes in membership, pricing, expenses, and investment assumptions improve the club’s economic case.
Sales break-even compares projected revenue with the operating sales level needed to cover the applicable cost structure. Cash break-even instead considers cash timing. Investment payback tracks recovery of invested cash over time, while annual return on invested capital relates operating returns to invested capital.
The model provides these analyses, but the source case reports no verified payback month, annual ROIC, IRR, or valuation amount. None should be inferred from EBITDA alone.
The Break-Even, Payback and ROIC report examines sales break-even, cash break-even, cumulative investment payback, and return on invested capital as separate outputs. It helps compare operational viability with capital recovery without assuming the two occur at the same time.
Dashboard Scenario Controls provide Low, Base, and High multipliers for revenue, COGS, variable expenses, fixed expenses, and payroll. A club operator can evaluate weaker guest play or higher labor costs without changing the revenue model’s membership-tier logic.
The Financial Scenario Analysis compares Low, Base, and High revenue, gross margin, contribution margin, and EBITDA trends. It can highlight how changes to member demand, activity-linked sales, and operating spending affect the five-year profitability outlook.
These answers clarify the operating inputs, financial projections, and planning limits of this country club Excel template.
Yes. Edit annual member households, the golf-versus-social tier share, and dues prices to recalculate membership revenue and its downstream results.
Yes. Guest rounds and optional cart seats are paid attachments; member green fees are included in dues and are not billed twice.
Non-dues activity uses a repeating 12-month multiplier pattern averaging 1.00; membership dues are not seasonally adjusted in the illustrated case.
Yes. A la carte member dining and separate private-event bookings have different volume and pricing assumptions; banquet covers are excluded from regular dining checks.
Yes. Payroll is forecast by staff role and FTE, then included once in total operating expenses rather than duplicated in COGS or fixed operating costs.
No. EBITDA excludes investing, financing, and working-capital cash timing. Review the Cash Flow, Sources & Uses, and financing schedules separately.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
I had no idea where to start, and that was the hardest part. This template gave me a clear starting point in one afternoon, so I could stop staring at a blank spreadsheet and move straight into planning.
The profitability section made it much easier to see margins and break-even without digging through formulas. I walked into my meeting with clearer assumptions and a cleaner story for the numbers.
Building the financials by hand would have eaten up my whole week. With this template, I saved about 12 hours and had a polished model ready faster than I expected.