Revenue and Calc
Edit court hours, utilization, six service shares and net fees. Monthly calculations allocate occupied court-hours once, then summarize revenue annually.

The Tennis Club Financial Model is an Excel template for a leased six-indoor-court facility in Charlotte, North Carolina. It translates court capacity, utilization, program mix and retained fees into monthly revenue and a 2026–2030 operating forecast.
The example has free registration, prepaid court bookings and coaching programs, but no membership dues, initiation fees, pro shop or food service. Instructional fees already include court access.
The workbook connects sport-specific court usage and club staffing to operating forecasts, funding schedules and financial reports.
Edit court hours, utilization, six service shares and net fees. Monthly calculations allocate occupied court-hours once, then summarize revenue annually.
Plan consumables, revenue-linked charges, recurring facility expenses and staff salaries in distinct schedules, including coach FTE and compensation.
Schedule court improvements and opening cash uses. CapTable records equity; Dashboard debt controls feed loan schedules, and Sources & Uses summarizes funding.
Income Statement, Cash Flow, Balance Sheet and Summary report projected performance and position. Checks identifies inconsistencies and invalid inputs.
Dashboard, Scenarios, Returns, Valuation and Benchmarks support operating case comparisons, break-even questions and financial sensitivity analysis.
One shared pool of occupied court-hours determines all booking and instruction revenue; individual services do not reuse the same court-hour.
Six courts × 14 hours × 30 days create 2,520 available court-hours monthly. At 40% utilization in 2026, the selected Base case uses 1,008 hours each month; the launch month is fully active.
Occupied hours go to member bookings (35%), guest bookings (10%), private lessons (15%), semi-private lessons (10%), adult clinics (15%) and junior programs (15%). The shares total 100%; free registrations add no dues revenue.
The Revenue Forecast connects available court-hours, annual utilization, service shares and retained hourly fees to six revenue lines. Monthly Calc formulas maintain one shared capacity pool, so coaching activity does not create an extra court rental.
1,008 occupied court-hours per month × $70.40 weighted retained fee ≈ $70,963 monthly revenue, or $851,558 across 12 months.
Retained fees are $34 for member play, $44 for guest play, $84 for private lessons, $100 for semi-private lessons, $120 for adult clinics and $90 for juniors per allocated court-hour. Lesson and clinic prices include court access.
Utilization increases to 48%, 54%, 59% and 63% during 2027–2030. These editable assumptions are not verified local occupancy or guaranteed future demand.
The model separates direct consumables, revenue-linked expenses, recurring facility overhead and salaried personnel to prevent double counting.
Balls and consumables equal 1.8% of revenue. Processing adds 3.2% and performance marketing 2.5%, making those charges sensitive to sales rather than separately forecast player counts.
Fixed expenses total $571,188 annually, including facility rent of $30,000 monthly. Other categories cover CAM, property tax, utilities, court and HVAC repairs, insurance, software, cleaning, security and compliance.
The COGS and Operating Expenses report separates direct consumables, revenue-based charges and fixed facility overhead. Its monthly schedules show the effect of more bookings on costs and the largely fixed burden of maintaining indoor courts.
The separate payroll plan includes a club manager at $65,000, 2.5 reception FTE at $38,000 each, maintenance at $40,000 and coaches at $48,000 per FTE. Coaching rises from four FTE in 2026 to 6.5 by 2030.
Base payroll increases from $392,000 in 2026 to $512,000 in 2030. Those salaries are not duplicated in other expense groups; the illustrated scope excludes employer taxes, benefits and personal taxes.
The Payroll Forecast turns staffing levels, employment dates and salary inputs into monthly personnel costs. Adjust coaching FTE or pay to evaluate the impact on EBITDA separately from rent and court consumables.
Initial improvements and preopening cash requirements are modeled separately from the club’s annual operating expenses and EBITDA.
Opening assets include court resurfacing ($60,000), LED lighting ($36,000), nets and equipment ($18,000), and reception and locker fit-out ($45,000). Booking and access hardware is also listed, without a disclosed amount.
Lease security, permits, preopening marketing, staff training and utility deposits are additional one-time cash uses, not recurring operating costs.
The Capital Expenditure Plan schedules asset purchases and related depreciation where applicable. It separates the initial court and facility improvements from recurring expenses, keeping capital investment distinct from operating EBITDA.
Owner funding is estimated at $537,024, reflecting opening assets, other startup cash, net working capital and a three-month operating reserve, less confirmed non-owner funding. The reserve is not a test of peak cash sufficiency.
Receivable and payable days are zero; inventory days are 30. Dashboard debt controls can test financing structures, but the example does not establish an actual borrowing commitment.
Sources and Uses of Funds tracks receipts from operations and financing alongside expenses, investment and repayment uses. Compare this with Cash Flow before deciding how much equity or borrowing the club needs; contributions are not operating earnings.
In the selected planning case, higher court utilization eventually offsets a large fixed facility and staffing cost base.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $851,558 | $1,027,055 | −$175,496 |
| 2027 | $1,021,870 | $1,087,828 | −$65,958 |
| 2028 | $1,149,604 | $1,121,408 | $28,196 |
| 2029 | $1,256,049 | $1,153,392 | $102,657 |
| 2030 | $1,341,204 | $1,183,778 | $157,426 |
Illustrative Base-case projections, rounded to whole dollars; rounding can affect displayed arithmetic.
EBITDA is negative in 2026–2027, turns positive in 2028 and reaches $157,426 in 2030. Higher occupied court-hours expand revenue, while additional coaching FTE increases payroll.
These disclosed numbers end at EBITDA, before depreciation, interest and taxes. Although financial statement reports are included, this case supplies no net profit, closing cash or balance sheet figures.
The Cash Flow Forecast reconciles monthly operating, investing and financing movements to closing cash. Review it for possible liquidity shortages caused by payroll, facility improvements or debt service even when EBITDA improves.
The Returns and scenario tools answer different questions about operating coverage, funding recovery and invested-capital performance.
Sales break-even measures operating cost coverage; cash break-even asks when cash flows reach the relevant threshold. Investment payback tracks recovery through cumulative project cash flow, while annual ROIC compares returns with invested capital.
The example supplies no verified break-even occupancy, payback time or ROIC result. Positive EBITDA in 2028 cannot establish those measures without the related investment and cash flow calculations.
The Break-Even, Payback and ROIC report compares revenue with operating requirements, tracks project cash flow and presents invested-capital returns. It helps distinguish operating improvement from actual recovery of the opening investment.
Dashboard scenario controls compare Low, Base and High multipliers for revenue, direct costs, variable spending, fixed expenses and payroll. Scenarios reports their EBITDA effects; Valuation adds DCF and sensitivity tools without an established value for this case.
The model is designed for planning a leased indoor tennis operation with mixed court rentals and instruction.
Prospective operators can test court occupancy, program allocation, coach coverage and facility expenses before committing to a plan. Investors and advisors can compare earnings, cash flow and opening funding needs.
Charlotte-area costs, salaries and utilization are estimated inputs, not independently verified benchmarks. Replace them with your lease terms, demand research and supplier quotes before making a decision.
The following answers clarify the workbook’s operating logic, editable assumptions and financial-report boundaries.
Available court-hours are multiplied by utilization, allocated across six exclusive activities and priced at net retained fees per court-hour.
No. Registration is free, with no annual dues or initiation fees in the modeled case.
Yes. Edit utilization by year, service shares, hourly fees, court count and bookable hours.
No. Instruction prices include court access, and each occupied court-hour is allocated once.
No. Salaried coaches sit in Payroll, separately from consumables, revenue-linked charges and fixed facility costs.
No. It is an estimated initial equity contribution for startup requirements and an operating reserve.
No. EBITDA differs from cash flow, investment payback and ROIC; the Returns report calculates them separately.
Yes. Income Statement, Cash Flow, Balance Sheet and Summary are included, although the disclosed case has numeric results only through EBITDA.
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.
One broken cell can throw off a whole forecast, and this template kept mine stable from the start. I caught assumptions faster and stopped worrying about hidden errors.
Building the model by hand would have eaten up my week, but this template got me to a full draft in a few hours. That saved me at least 12 hours of spreadsheet work.
I wasn't sure what investors would expect, but the layout made the outputs and assumptions obvious. I had a meeting booked the same day I finished the model.