Introduction: Why "Guessing" Revenue Is the #1 Reason Padel Clubs Fail
Every year, promising Padel clubs open with genuine passion, quality courts, and enthusiastic members — only to hit a wall within twelve to eighteen months. The courts are busy. The café is doing reasonable trade. Yet the business bleeds cash. Why? Because the founding financial plan was built on optimistic guesswork rather than structured, driver-based forecasting.
The problem almost never starts on the cost side. Startup costs for a Padel facility are relatively predictable — construction, court surfaces, lighting, fencing, and fit-out follow known industry norms. The real danger lies in revenue. Founders routinely project a flat monthly revenue number based on gut feel (“we’ll do $40,000 a month”) without interrogating the underlying mechanics that determine whether that number is achievable at all.
Structured financial modelling disciplines you to think in input drivers — the variables that actually produce revenue. How many courts do you have? How many hours a day are they open? What is your realistic occupancy rate on a Tuesday morning versus a Saturday afternoon? What percentage of your court-booking members will also buy a coaching session, a coffee, or a racket from your pro-shop? Each of these variables is quantifiable, and when you combine them systematically, your revenue forecast stops being a wish and starts being a testable hypothesis.
This guide walks you through exactly that process, using a bottom-up forecasting methodology and the specific input drivers from a professional Padel Club Financial Model. We will build the Excel logic step by step, explain why each driver matters, and show you how to layer in seasonality so your twelve-month projection reflects reality rather than wishful thinking.
📌 What Is Bottom-Up Forecasting?Bottom-up forecasting starts with the smallest operational unit — a single court-hour — and builds revenue upward by applying realistic assumptions at each stage. It is the inverse of top-down forecasting, which starts with a target market size and applies a capture percentage. Bottom-up is far more reliable for operational planning because every number is grounded in physical capacity and real conversion rates.
Step 1: The Booking Engine: Building Court Revenue Logic in Excel
Court booking revenue is the core engine of any Padel business. Before a single cup of coffee is sold or a coaching session is booked, your financial model must correctly compute the maximum theoretical revenue from court time — and then apply realistic occupancy assumptions to arrive at the expected actual revenue. Getting this engine wrong invalidates everything else in the model.
The Master Formula
All court revenue flows from one master relationship. At its most fundamental, daily court revenue for a given session type (peak or off-peak) is:
This formula encodes a layered logic: the number of available slots (Courts × Hours ÷ Game Time) multiplied by the fraction actually filled (Occupancy %) multiplied by what each slot earns (Price × Players). Each factor is independently controllable — which is exactly what you need for scenario planning.
The Input Drivers From the Professional Model
The professional Padel Club Financial Model separates input drivers into discrete, clearly labelled cells. From the Revenue Forecasting section (Section 3.1), the key variables for court revenue are:
How to Split Peak vs. Off-Peak in Excel Rows
The single most important structural decision in your court revenue model is splitting weekday and weekend calculations into separate rows. This is not a cosmetic choice — it is a functional requirement. Blending a single average occupancy rate across weekday and weekend sessions will systematically overstate revenue in off-peak periods and understate it during peak periods, destroying the accuracy of any cash flow forecast.
January Indoor Court Revenue: ~$18,252
Using: 3 courts, 40% weekday / 60% weekend occupancy, $15 weekday / $18 weekend rate, 4 players, 2-hour games.
Notice that this structure allows the occupancy rates — the most uncertain and variable assumptions in the model — to be changed for each individual month without touching the underlying formula logic. This is critical for tracking KPIs like RevPAC (Revenue Per Available Padel Court) across different seasonal conditions.
Separate Indoor and Outdoor Courts
The professional model treats indoor and outdoor courts as completely independent revenue streams with their own occupancy profiles. This is structurally correct because outdoor courts are far more vulnerable to weather and seasonal variation — their utilisation in winter months may be 30–40% lower than in peak summer. A model that blends indoor and outdoor court revenue into a single pool will fail to capture this dynamic and will misrepresent both the revenue ceiling and the seasonal risk profile of the business.
💡 Pro Modelling TipIn the professional template, the occupancy rates for weekdays and weekends are entered as a month-by-month matrix (12 rows × 4 columns: Indoor Weekday, Outdoor Weekday, Indoor Weekend, Outdoor Weekend). This matrix is referenced by the booking engine formula via INDEX/MATCH, ensuring that as you scroll through each month’s column, the model automatically pulls the correct seasonal utilisation assumption for each court type and session type — with zero manual overrides.
Step 2: The Multiplier Effect: Forecasting Ancillary Revenue Streams
Court bookings are the heartbeat of a Padel club’s economics, but they are rarely the margin-maker. The ancillary revenue streams — café, pro-shop, coaching, facility rentals — are where operators build sustainable profit margins. The challenge is that most operators either ignore these streams entirely in their initial model, or simply pick an arbitrary round number (“we’ll do $3,000 a month in café sales”) without any logical connection to their actual footfall.
The professional model solves this with a set of three tightly linked input drivers that make ancillary revenue a genuine function of your court traffic — not a guess.
The Three Ancillary Revenue Drivers
Driver 1 — % of Members Who Buy / Purchase (Conversion Rate)
Rather than forecasting a dollar amount directly, the model starts with a conversion rate: what percentage of your active member base will purchase from each ancillary channel in a given month? This is fundamentally more reliable because it is anchored to a number you already know — your member count — and draws on observable behaviour that can be tracked, tested, and refined over time.
For example, the model defaults to a 50% conversion rate for coaching sessions. This means that in any given month, half of your active members are expected to book at least one coaching session. This assumption is independently editable — if your data shows actual conversion is running at 35%, you change one cell and the entire ancillary revenue cascade updates automatically.
Driver 2 — Average Order Value (Ticket Size)
The conversion rate tells you how many members engage. The Average Order Value tells you how much each engagement is worth. In the model, these are entered as explicit input cells rather than being buried in formulas — this is deliberate, because ticket sizes vary significantly by stream and need to be revisited regularly as pricing evolves.
Driver 3 — COGS % (Cost of Goods Sold)
Gross revenue without cost visibility is a dangerous number. The model applies a COGS percentage to each ancillary stream to immediately translate gross revenue into gross profit. Critically, not all COGS rates are equal — and the logic behind assigning them correctly is important.
⚠️ Why Some Streams Have 0% COGSThe professional model correctly assigns 0% COGS to Membership fees and Facility Rentals. This is because the primary cost of delivering these services — court maintenance, cleaning, staffing — is already captured in the operating expense section of the model (headcount, maintenance lines). Adding a COGS % on top would double-count these costs and artificially depress the gross margin for these streams. Merchandise and Café, by contrast, have real direct costs (inventory, consumables) that are not captured elsewhere — hence the 30% COGS applied there.
Why the “Starting Month” Driver Matters
One of the most commonly missed details in manual Padel forecasts is the assumption that all revenue streams start on Day 1. In reality, a café may not be fit out until Month 3, a merchandise contract may not be signed until Month 2, and organised coaching may not launch until you have sufficient membership depth to guarantee class sizes. The professional model accounts for this with a dedicated “Starting Month” input for each ancillary stream.
In Excel, this is implemented with a simple IF gate wrapped around every ancillary revenue formula. The formula checks whether the current column month is on or after the specified starting month. If not, the cell returns zero. This prevents the model from generating phantom revenue from services that do not yet exist — a critical discipline for investor-grade financial models.
📊 Active Members as the Anchor VariableNote that the conversion rate is applied to Active Members — not total registered members. The model separately computes active membership by applying a monthly churn rate (3% per month in the default settings) to the starting visitor capture base of 45,000 market size with a 30% capture rate. This means as members churn, ancillary revenue automatically declines proportionally — a critical reality that flat-line ancillary assumptions completely miss.
Step 3: Factor in Seasonality: Monthly Toggles and Tournament Scheduling
Revenue forecasting without seasonality is not forecasting — it is an average. A Padel club’s revenue profile is inherently seasonal: outdoor court utilisation spikes in spring and summer, tournament-driven income is event-specific, and new member acquisition tends to cluster around fitness-motivation seasons (January, post-summer). A flat monthly revenue assumption will consistently overstate cash in slow months and understate it in peak months, producing a misleading picture of both the revenue ceiling and the minimum cash buffer required.
Monthly Utilisation Rates: How the Model Handles Seasonal Variance
The professional model uses a month-by-month utilisation matrix rather than a single annual average. Each month has its own weekday and weekend occupancy rate for both indoor and outdoor courts — four independent rates per month, twenty-four cells in total. This is the correct approach because it allows the model to capture the full seasonal shape of the revenue curve rather than compressing it into a misleading annual average.
Looking at the occupancy assumptions from the model, the seasonal pattern is clear:
In Excel, each month’s revenue column references the appropriate row in this matrix using an INDEX/MATCH or OFFSET function. When you update a single utilisation assumption — say, revising April’s weekend occupancy from 90% to 85% — the corresponding month’s court revenue, ancillary revenue (since it is anchored to active members, which is partially driven by engagement levels), and gross profit all update automatically.
Tournament Revenue: The Yes/No Toggle System
Tournament income is the most episodic revenue stream in the Padel business model. Unlike court bookings, which produce daily revenue, tournament revenue arrives in a single lump associated with a specific event — with a defined entry revenue, sponsorship component, and a 50% COGS rate to cover prizes, logistics, and execution costs.
The professional model handles this with a brilliantly simple solution: a monthly Yes/No toggle. For each calendar month, the operator enters “Yes” or “No” to indicate whether a tournament is held. The model then conditionally includes the tournament revenue and costs for that month. Here is how the tournament schedule looks in the default model:
💡 Why the Toggle System Beats Fixed AmountsThe Yes/No toggle approach is superior to hardcoding monthly tournament revenue because it forces explicit decision-making. When you are building a five-year financial model, you do not want an assumed $4,000 tournament revenue quietly compounding in every month. The toggle makes the event-based nature of the income visible and auditable — any investor or banker reviewing the model can immediately see when tournaments are and are not scheduled, and can stress-test scenarios where events are cancelled or postponed.
Step 4: Manual Forecasting vs. Using a Professional Template
At this point, it is worth being direct about the practical difference between attempting to build this model yourself from scratch versus using a professionally engineered template. Both approaches are viable — the question is one of time, accuracy, and the cost of errors.
The conclusion is not that manual modelling is impossible — skilled financial analysts build models from scratch every day. The conclusion is that for a Padel club operator who needs a credible, investor-grade forecast to raise capital, secure a bank facility, or make a strategic business planning decision, a purpose-built professional template eliminates months of modelling risk and produces a structurally superior output.
Investor-Grade Accuracy: How This Logic Has Been Validated
The forecasting framework described in this guide — bottom-up court booking logic, conversion-rate-anchored ancillary revenue, stream-specific COGS, seasonal utilisation matrices, and event-based toggle scheduling — is not theoretical. It reflects the operational and financial mechanics that successful Padel club operators actually use to run their businesses, translated into a rigorous Excel architecture.
The professional model has been designed with a specific audience in mind: operators who are presenting to sophisticated investors or institutional lenders. These audiences are experienced in identifying financial models that have been reverse-engineered from a desired outcome rather than built from genuine operational assumptions. They look for internal consistency — does the ancillary revenue track logically with the member count? Does the churn assumption flow correctly into declining retention cohorts? Does the COGS treatment reflect actual cost accounting rather than a blended guess?
“The most common mistake I see in Padel club pitch decks is revenue that appears to have been reverse-engineered from a target valuation. The numbers are round, the growth is linear, and there is no visible connection between the occupancy assumptions and the revenue output. Investors who have seen a properly built model — one where you can trace every dollar of revenue back to a court, a time slot, and a player count — immediately recognise the difference.”
The forecasting logic in the professional template has been validated across several key stress tests that investors commonly apply:
Occupancy sensitivity: Reducing weekend occupancy from 90% to 70% in peak months should produce a clearly traceable revenue reduction that flows proportionally through the model — not a disproportionate collapse or a suspiciously small decline. The professional model passes this test because each occupancy rate is independently mapped to a specific revenue cell.
Churn impact: A 3% monthly churn rate on a base of 1,000 members produces approximately 970 active members in Month 2, 941 in Month 3, and so on. Because all ancillary revenue is anchored to active membership, this churn cascades correctly through every downstream revenue stream — not just the membership revenue line. This is a mathematical discipline that manual models almost never implement correctly.
Margin structure: A well-built Padel model should show clearly differentiated gross margins by stream — coaching at 70% gross margin, merchandise at 70%, court revenue approaching 75–80% gross margin after maintenance COGS, and tournaments at 50%. If all streams show the same margin, the COGS treatment is likely wrong. The professional model produces a correctly differentiated margin profile that holds up under investor scrutiny.
The professional template automatically computes a range of investor-grade KPIs that experienced operators and backers use to benchmark performance: RevPAC (Revenue Per Available Court), EBITDA margin progression, member acquisition cost vs lifetime value, and gross profit by revenue stream. These KPIs update dynamically as you change any input assumption — giving you a real-time view of how each decision affects the headline financial metrics.
