Scenario Planning Made Simple
I stopped wasting time toggling between low, base, and high cases. The template let me compare all three in one place, so I cut scenario setup from hours to minutes.
I stopped wasting time toggling between low, base, and high cases. The template let me compare all three in one place, so I cut scenario setup from hours to minutes.
Pricing, staffing, and growth assumptions were all in one organized sheet, which made the model much easier to follow. I finished my first full forecast in under an hour and didn’t have to chase down hidden inputs.
Starting from scratch felt overwhelming, so this template gave me a clear place to begin. I had a full first draft ready the same afternoon, and it was easy to keep building from there.
The financial model Pole Dancing Studio is a five-year Excel workbook, built around study sites, coverings, monthly fees, additional income and related financial statements.
The workbook should plan the capacity of the studio, its use, its valuation, its launch time, costs, staff and funding by reviewing the resulting financial forecast in a single model.
Changes in business assumptions flow through the calculation mechanism into forecasted reports, scenario comparisons, navigational desk indicators and other related reports.
The revenue starts with available study places, applies the enrolment and monthly fees by group, adds the included additional revenue, then adds up the active months after start-up and seasonality.
Define available places by group of studios and plan any additions.
The space occupied shall be equal to the available space multiplied by the applicable occupancy rate.
Monthly base income is the seats taken multiplied by the monthly seat fee.
Taking into account the possibilities, the additional revenue shall be added to the additional monthly revenue for each occupied seat.
Monthly income is added up to all groups, and annual income is added up to active months after adjustments in time.
View The revenue assumptions organizes the launch time, the entourage, the capacity of the study group, the monthly fees and additional revenues that drive the forecast of occupied capacity.
GROUNDS FOR THE REVENUE
The worksheet COGS & Operational Expenses separates direct costs, variable expenditure and fixed expenditure, so that the operational assumptions can be consistent with the related forecast.
OPERATING EXPENDITURE COGS
The analysis of the scenario compared the low, base and high cases in relation to revenues, gross margin, premium margins and EBITDA in the five-year forecast.
ANALYSIS SCENARIO
The table includes control of scenarios, main finances, revenue mix, profitability, cash flow and prospects for return on investment to the management review.
DASHBOARD
The template fits with polar studies that sell completed classes or groups of places with monthly overlay-based income, while materially different operating logic may justify a non-standard structure.
The template is the starting point of planning, not a guarantee of performance.
The Financial Models Laboratory can build or adjust a model when your company needs different revenue logic, operating schedules or financial reporting.
ORDER A CUSTOM FINANCIAL MODELAfter the order you will receive a fully edited Excel financial model as an immediate download with five-year forecasts, scenarios, declarations and reports on the dashboard.
Open Excel file and replace pre-built assumptions with your own studio inputs.
Overview of the related projections in the five-year planning horizon of the model.
Compare low, base and high cases from the scenario analysis view.
Review of the Income Statement, Cash Flow Statement, Balance and Results Panels.
The basic answers are visible in their entirety, without clicking on the accordion.
It calculates the places occupied from the available places and their occupancy, multiplys them with monthly fees, adds additional income and sums up active months after the adjustments.
You can change the start date, the places by group, the cover or its ramps, monthly fees, additional revenue, bandwidth, group definitions, active months and seasonality when used.
The low, base and high revenue, gross margin, premium margin and EBITDA in the five-year forecast can be compared.
The workbook contains income statement, cash flow statement, balance sheet, navigation desk, summary, profitability analysis, charts, KPIs, indicators and other management reports.
Yes. The financial models Lab offers custom financial modelling for various revenue logic, operational schedules, or reporting requirements.
This is a planning forecast based on assumptions contained in the workbook, not a guarantee of business results.
This is a complete pole studio excel financial planning tool with everything you need to build a comprehensive financial plan and secure funding.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark