Hours Saved Right Away
I cut out the manual build and got my HIIT studio forecast done in a fraction of the time. What used to take me a full day was done in under two hours.
I cut out the manual build and got my HIIT studio forecast done in a fraction of the time. What used to take me a full day was done in under two hours.
I stopped worrying that one broken formula would throw off the whole model. The template kept the numbers clean, and I could review assumptions without second-guessing every cell.
I used to spend too long juggling low, base, and high cases by hand. This made the three scenarios easy to compare, and I booked a lender call with clear numbers the same afternoon.
The financial model of HIIT Studio is a five-year spreadsheet that combines capacity, occupancy, monthly fees, scenarios and financial statements for planning.
Use the workbook to plan how membership and class capacity, enrolment, monthly fees, additional income, operating costs, wages, capital expenditure and funding influence the study’s forecast.
The editable assumptions are consistent with the monthly calculation model which takes into account the results in annual forecasts, financial statements, scenario comparisons and management reports.
The revenue starts with the available seats by group, covers the establishment, the multiplication of places occupied by monthly fees, the addition of possible additional revenue and then the sum of active months.
Identification of available sites by group or category and time of capacity addition.
Calculation of seats from available locations and appropriate occupancy ratio.
Multiplying seats in each group by means of a monthly space fee.
Multiplied places occupied by additional monthly incomes per place where additional incomes can be obtained.
Total monthly group income within months of commissioning, land area and seasonality.
The revenue view organizes the launch of the schedule, occupancy, category capacity, monthly fees and additional revenue for the occupied seat within five years of forecast.
REVENUE
The view of COGS & OPEX separates direct costs, variable operating costs and fixed costs, so that the operational assumptions flow into the forecast.
COGS & OPEX
The Scenarios compared low, base and high results in terms of revenues, gross margin, premium margins and EBITDA in the five-year forecast.
SCENARIOS
The table contains configuration checks, scenario results, basic finance, revenue mix, profitability, cash flow and return on investment in one management view.
DASHBOARD
The workbook prepared fits into the HIIT studies using limited capacity, occupancy and monthly fees; generally, a different revenue logic or reporting may require a custom modeling.
The template is the starting point of planning, not a guarantee of performance.
The financial models of Lab can build or adjust the model when you need different revenue logic, operating schedules or reporting from the ready structure.
ORDER A CUSTOM FINANCIAL MODELAfter check-out you receive a five-year workbook for the Excel or Google Sheets with scenarios, financial statements and management reporting.
Open and edit your financial model in Excel or Google Sheets.
Work with five-year forecasts, which include monthly and annual data.
Compare low, base and high cases by reporting scenarios in the workbook.
Review of the Income Statement, Cash Flow Statement, Balance, Dashboard and Summary.
The basic answers are visible in their entirety, without clicking on the accordion.
Calculates the capacity and capacity spaces, applies monthly fees and additional income, and then adds up the active months after launch, ramp and seasonality.
You can change the start date, group definitions, group locations, betting, monthly fees, additional revenue per place, capacity allowances, active months and seasonality when used.
The five-year forecast compares low, base and high revenue, gross margin, premium margin and EBITDA.
In the Workbook Is a Statement of Incomes, Report on the Flow of Monetary Resources, Balance Sheet, Dashboard, Summary, Scenarios, Valuation, Break-even, ROIC, Graphs, KPIs, Ratios and Complementary Reports.
Yes. The Financial Models Laboratory can build or adjust a model when a different revenue logic, operational schedules or reporting structures are required.
This is a planning forecast based on assumptions to be edited, not a guarantee of business performance, profitability, financing or returns.
You get a downloadable financial template for gym owners that includes a 5-year forecast, dynamic dashboard, detailed cost analysis, and investor-ready reports, all in one easy-to-use spreadsheet.
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