Margins Made Clear
This template made break-even and margin questions easy to see, so I could spot where the clinic needed to improve. I saved about 4 hours of spreadsheet cleanup before my lender call.
This template made break-even and margin questions easy to see, so I could spot where the clinic needed to improve. I saved about 4 hours of spreadsheet cleanup before my lender call.
I had pricing, staffing, and supply costs all over the place, and this model pulled them into one clean setup. It cut my planning time by half and made the numbers much easier to review.
Starting from a blank sheet felt overwhelming, but this template gave me a practical place to begin. I booked a planning meeting the same day because the forecast was already laid out.
The financial model of the Colon Hydrotherapy Clinic is a five-year workbook that combines the ability of the practitioner, use, valuation of treatment, costs, scenarios and financial statements.
Use the workbook to plan how the resources of practitioners, monthly treatment capacity, use and prices translate into clinic income, operating costs, cash flow and profitability.
The Editorial assumptions provide monthly operational calculations that fall into low, base and high scenarios, financial statements, dashboards and management reports.
The model converts available resources of practitioners into treatment capacity, uses usage, prices and active months, and then sums up revenue in different possible service lines.
Set categories of practitioners or resources, number, availability date and definitions of service lines by period.
Available resources are multiplied with maximum monthly treatment or services per resource.
Use of capacity assumptions or ramps to estimate expected service units.
Multiplying expected service units through the prices realised and active months for each stream.
Total of calculated revenue between practices, resources or service lines for forecast.
The income sheet sets out the number of doctors, the time of commencement, the maximum monthly treatments, capacity utilisation and average treatment prices throughout the forecast.
REVENUE
The COGS & OPEX card separates the operating costs associated with treatment of COGS, variable expenditure and fixed operating expenditure during monthly and annual forecast periods.
COGS & OPEX
The Scenarios compared low, base and high incomes, gross margin, premium premium and EBITDA in the five-year forecast.
SCENARIOS
The navigation desk combines model settings, scenario control, key metrics, basic finances, revenue mix, profitability, cash flow and return prospects.
DASHBOARD
The model is designed to fit the services of capacity-based clinics, while significant differences in revenue logic, operational schedules or reporting structures may require custom modelling.
The template is the starting point of planning, not a guarantee of performance.
The Financial Models Laboratory can build or adapt a model when requirements require different revenue logic, operational schedules or reporting structures.
ORDER A CUSTOM FINANCIAL MODELAfter booking, you will receive a five-year-old financial model for immediate collection, with revenue contributions, scenarios, statements and management views.
A change trainee, treatment ability, use, pricing, cost and planning assumptions for your operational case.
Review of monthly and annual forecasts over the five-year forecast period.
Compare low, base and high revenue, margin and EBITDA.
Overview of the income account, cash flow, balance sheet, summary, Dashboard and related reports.
The basic answers are visible in their entirety, without clicking on the accordion.
It calculates available service opportunities from the practitioners' resources, uses the use and then multiplys the expected service units through the prices realized and active months before total income.
You can edit the practitioner or categories of resources, count, opening dates, maximum monthly treatments, usage, prices, active months, service lines and seasonality when they are present.
You can compare low, base and high cases in different revenues, gross margin, premium premium and EBITDA in the scenario view.
The workbook contains a statement of income, a statement of cash flows, a balance sheet, a navigational desk, a summary, a break-even, ROIC, graphs, KPIs, valuation and additional management reports.
Yes. The Financial Models Laboratory can build or adapt the financial model depending on the different revenue logic, operational schedules or reporting requirements.
This is a forecast based on assumptions for editing, not a guarantee of business results.
This downloadable financial plan for a hydrotherapy business provides a complete suite of tools to plan, launch, and grow your clinic.
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