Most people who try to build a financial model for a padel club business begin in the wrong place. They open excel, create a sheet called Revenue, and start typing numbers. After spending some time, they have a tangle of hard-coded figures, inconsistent assumptions, and a model giving #NA, #ref error or vague value when you change any input drivers.

This guide will teach you how to build padel club’s revenue budgeting model, the way a Certified Financial Modeler does. We will cover input assumptions, seasonal occupancy mechanics, ancillary revenue logic, and event-based toggles. Where relevant, I will reference the exact structure used in our battle-tested Financial Projection Model For Padel Club.

Padel Club Revenue Projection Excel Guide & Excel Formulas

Before setting up your Excel formulas, make sure to read our benchmark guide on Padel Club Revenue Drivers to understand how each revenue stream works and how to set realistic pricing assumptions.

How Financial Assumptions Translate into Excel Formulas

Before writing formulas in Excel, you must map out your core business drivers into structured inputs. In financial modeling, every revenue stream relies on two factors: capacity (what you can offer) and utilization (how much of it is sold).

The table below breaks down how key operational assumptions map directly into your Excel forecasting logic:

Model Input Category	Excel Cell / Assumption Type	Formula Logic	Impact on Revenue Model
Court Capacity	Total Courts x Hours Open	Hardcoded Integer	Establishes total available court inventory
Prime-Time Rental	Hourly Rate x Occupancy %	Dynamic Formula	Main driver of court booking revenue
Off-Peak Rental	Discounted Rate x Occupancy %	Dynamic Formula	Fills low-demand morning/afternoon slots
Recurring Memberships	Active Members x Monthly Fee	Dynamic Subscription	Generates predictable monthly cash flow (MRR)

Connecting Inputs to Your 5-Year Forecast

Once these input variables are set up in your assumptions tab, your Excel sheet can dynamically calculate monthly gross revenue.

For example, your Total Monthly Court Revenue will simply be the sum of your Prime-Time and Off-Peak formulas multiplied by operating days in the month. By keeping your assumptions (like Occupancy % or Hourly Rates) in separate input cells rather than hardcoding numbers inside formulas, you can easily run sensitivity analysis to see how a 5% drop in court utilization or a 10% increase in membership fees impacts your overall profitability.

Section 1: The Two Pillars of Professional Forecasting Revenue In Excel

Before writing a single formula, you must accept two non-negotiable principles:

Pillar 1: Structure: Inputs Drivers in One Place

In a professionally structured model, the Input Sheet is sacred. All assumptions, pricing, capacity, occupancy rates, churn, starting dates place in one dedicated tabs in excel, clearly labelled ‘Input Drivers’ Or ‘Driver Sheet’. Calculations can be elsewhere. Outputs formulation can be on other tabs in excel.

This is not a stylistic preference. It is what makes a model auditable, revisable, and stress-testable. When an investor asks, ‘What happens if weekday occupancy drops to 40%?’ you should be able to change one cell and watch every projection update instantly. If your assumptions are buried inside formulas across many sheets, that question becomes a debugging exercise.

💡The Light Yellow Cell Convention
You can notice in our Input Drivers sheet that every editable assumption is highlighted in a light cream cell, and the instruction ‘Please fill only yellow cells’ is displayed prominently at the top. This is deliberate. It tells any user i.e. a business partner, an accountant, an investor exactly where they are allowed to touch the model. Non-input cells are locked. This discipline prevents formula corruption and instils confidence.

Pillar 2: Dynamics: Nothing Is Hard-Coded

Hard-coding is the cardinal sin of financial modeling. A hard-coded number is a number typed directly into a formula. It looks harmless. It is lethal.

Example of hard-coding (wrong): = 3 * 15 * 12 * 0.65
Example of dynamic modeling (correct): = Courts* Price Per Hour * Hours Open * Occupancy Rate

Every figure in the second formula is a named driver sitting in the Input Sheet. Change one, and the entire five-year forecast adjusts. That is what dynamic modeling means and it is the only standard acceptable for investor-grade work.

The drivers you must include for a padel club forecasting are;

Number of courts (indoor vs. outdoor)
Starting month of operations
Number of players per game
Average hours played per member per month
Weekday and weekend pricing
Occupancy rates by month
Churn rate
Ancillary revenue assumptions & other assumption based on your revenue model, location & other dynamics.

If you are still determining your startup cost structure, below link has a deep-dive on cost to start a padel club business. Which provide a strong reference point for anchoring your CAPEX assumptions.

💡Further reading: Padel Court Startup Cost Guide

Section 2: Formatting of the Input Drivers Sheet

Let us examine what a professional input sheet looks like in practice. The screenshot below is taken directly from our Padel Club Financial Model template specifically the Revenue Forecasting block.

Several professional variable that are essential for forecasting revenue & decision making are visible:

2.1 Market Size and Capture Rate

The model begins at the market level not the court level. We input the Expected Market Size (local people who actively play padel) and the Expected Visitors to Capture. This top-down framing is essential when presenting to investors, who want to understand addressable demand before they will believe your occupancy assumptions.

A 3% Churn Rate is also parameterized here. This is the percentage of members who leave after one or two months. Ignoring churn is one of the most common and costly mistakes in subscription-based revenue models. A 3% monthly churn sounds modest; compounded over twelve months, it meaningfully erodes your membership base.

2.2 Court Configuration Inputs

The model has separate input assumptions for Indoor Courts and Outdoor Courts because they have different cost profiles, demand patterns, and pricing authority. Treating them as a single blended asset is imprecise. Each court type has its own starting month, number of courts, players per game, average hours per member per month, weekday and weekend opening hours, pricing per hour, and average game time.

Every one of these values sits in a light yellow colored input cell.

2.3 The Weighted Occupancy Matrix: The Most Important Table in the Model

Here is where amateur and professional models diverge most sharply. An amateur model uses a single occupancy percentage, say 65% and applies it uniformly across the entire year. A professional model recognizes that a padel club does not operate at a uniform rate. It operates in peaks and troughs, across weekdays and weekends, and across seasons.

Our model uses a 12-month Weighted Occupancy Matrix, split across four dimensions: Weekday Indoor, Weekday Outdoor, Weekend Indoor, and Weekend Outdoor. This gives twelve rows of monthly assumptions and four columns forty-eight individual data points that collectively paint an accurate picture of true utilization.

💡Why Weighted Occupancy Matters
Consider a club with 60% average annual occupancy. If that figure masks 40% weekday utilization in January and 95% weekend utilization in May, a blended average will understate your peak revenue capacity and overstate your off-peak baseline. A weighted matrix captures this reality and produces a revenue curve that is credible to any seasoned investor.

The corresponding Cost of Services section with separate COGS lines for Maintenance, and five customizable ‘Others’ categories is equally important. Tying COGS directly to court type ensures that your gross margin calculation reflects actual operational reality, not a uniform assumption.

For a broader view of how padel clubs generate and lose money at a unit level, see our guide: How Padel Clubs Actually Make Money.

Section 3: Forecast Ancillary Revenue: The Multiplier Effect

Court booking fees are the main revenue stream. But for a padel club to achieve strong unit economics, ancillary revenue streams must be modelled explicitly and dynamically. The screenshot below shows the Ancillary Revenue section of our input sheet:

The model captures five ancillary streams: Membership fees, Coaching Sessions, Merchandise Sales, Facility Rentals, and Cafe/Bar revenue. Each stream follows the same professional logic structure:

Starting Month: when does this stream begin generating revenue?
% of Members Buys / Purchased: what fraction of your active member base will purchase this service in a given month?
Order Value: what is the average transaction size for those who do purchase?
COGS %: what percentage of that revenue is consumed by direct costs?

Section 4: Modeling Event & Tournament Revenue

Tournament and event revenue is, by nature, lumpy and irregular. It does not fit a smooth monthly curve. Amateur models either ignore it entirely or average it across twelve months both of which produce distorted forecasts.

The professional approach is a binary toggle: a Yes/No input for each calendar month. In our model, you will see exactly this pattern in the Tournament Held (Yes/No) section of the input sheet:

January: No
February: No
March: Yes → Tournament logic activates; revenue recognized
June: Yes → Tournament logic activates
September: Yes → Tournament logic activates
December: Yes → Tournament logic activates

When a month is toggled to ‘Yes’, the model automatically computes tournament revenue from three drivers: Average Expected Revenue per Tournament (including all ticket and entry income), Sponsorship Revenue for Each Tournament (all sponsorship packages combined), and a 50% COGS assumption (covering prize money and execution costs).

When a month is toggled to ‘No’, all tournament revenue lines produce zero cleanly and automatically. No manual zeroing required, no risk of formula errors.

💡Why This Matters for Investors
A toggle-driven event model communicates two things to an investor:
(1) you understand that event revenue is episodic, not recurring.
(2) your model is flexible enough to test scenarios, ‘What if we run four tournaments instead of three?’ is answered by changing four cells, not rewriting formulas.

Section 5: From Inputs to Investor-Ready Outputs

A model that produces correct numbers but presents them poorly is only half-finished. The final professional step is translating your input logic into output dashboards that communicate value, risk, and opportunity to a non-technical audience.

Below is a representative view of how a structured revenue model translates into a Revenue Breakdown dashboard:

An investor-grade dashboard should surface, at minimum: monthly and annual court revenue by type, ancillary revenue by stream, tournament revenue by event month, total gross revenue, COGS by category, gross profit and gross margin percentage, and year-on-year growth trajectory.

The investors and lenders who will scrutinize your model are not looking for complexity but they are looking for clarity and defensibility. Every figure on the dashboard should trace back, via a clean formula chain, to a single input cell. If it cannot, it should not be on the dashboard.

For a clear picture of the KPIs your investors will priorities, review our guide: Top 10 Padel Court KPIs Investors Care About.

Apply Sensitivity Analysis

When forecasting revenue in Excel, never rely on a single static number. Always build a Sensitivity Table using Excel’s Data Table tool (Data > What-If Analysis > Data Table) to test how changes in Court Utilization Rate affect annual revenue.

Scenario	Average Occupancy Rate	Average Hourly Rate	Projected Annual Revenue (4 Courts)
Worst Case (Conservative)	35%	$40 / hr	$120,000
Base Case (Expected)	55%	$50 / hr	$235,000
Best Case (Optimistic)	75%	$65 / hr	$390,000

Who This Guide Is For
Padel club founders, investors, and operators who need a defensible, auditable revenue forecast — whether for internal planning, a bank loan, or an investor deck. No advanced Excel knowledge is assumed, but intellectual curiosity is required.
Learn: 10 Excel Hacks Every Startup Founder Needs for Killer Revenue Forecasting

Common Excel Modeling Mistakes to Avoid

Hardcoding Numbers Inside Formulas:

Rule #1 of financial modeling is, never enter hardcode values (e.g., =A1 * 50). Always put assumptions (like $50 hourly rate) in a dedicated Assumptions Input Sheet and reference the cell (e.g., =A1 * ‘Assumptions’!B5).

Ignoring Seasonality:

Padel court utilization summer aur winter me vary karti hai. Use monthly multiplier factors in Excel (e.g., 0.8x in off-peak months, 1.2x in high-demand months) rather than dividing annual projections equally by 12.

Forgetting Capacity Caps:

Always write a =MIN() formula to cap court utilization at 100% of open hours so your model doesn’t unrealistically over-forecast bookings.

💡 Download Ready-to-Use Excel Template
If you want to save 40+ hours of manual formula setup, download our pre-built Padel Club Financial Model Excel Template. It includes pre-linked revenue forecasting tabs, dynamic sensitivity tables, 5-year financial statements, and automated visual dashboards.

What Is Included in the Padel Club Financial Model

The template is a fully integrated, 5 financial projection model built to the professional standard described throughout this guide. Here is a summary of what you receive:

Module	What It Does
5-Year Monthly Projections	Full month-by-month P&L, Cash Flow & Balance Sheet for Years 1–5.
Dynamic Scenario Toggles	Switch between Base, Optimistic, and Pessimistic cases in one click.
CAPEX / OPEX Inputs	Itemized startup costs, asset depreciation, and operating expense drivers.
Debt & Equity Planning	Model your funding mix i.e. loans, investor equity, and repayment schedules.
Investor-Ready Dashboards	Visual KPI summary page built for board decks and due-diligence packages.

The model is delivered as an unlocked Excel file. Every formula is visible and auditable. All input cells are clearly labelled. Scenario toggles allow you to present Base, Optimistic, and Pessimistic cases from a single file.

Final Word: Build Right, or Build Twice

A realistic Padel Club revenue forecast balances physical court capacity with hour-by-hour utilization rates and high-margin ancillary streams. By keeping your operational assumptions in dynamic input cells rather than hardcoded formulas, you can easily run sensitivity models to stress-test your club’s 5-year financial runway.

Need to save time building these dynamic formulas? Download our pre-built, automated Financial Forecasting Model For Padel Club with ready-to-use revenue tabs, 3-statement financial models, and automated visual dashboards.