Hours Back in My Week
Building the clinic model from scratch would have eaten up days. This template cut that down fast, and I had a working forecast the same afternoon.
Building the clinic model from scratch would have eaten up days. This template cut that down fast, and I had a working forecast the same afternoon.
I could finally see where the cash dips were coming and how long our runway really was. That made planning our next hire and funding timing much easier.
I’m not an Excel power user, so this was a relief. The inputs were clear, and I got through the model without needing outside help.
This editable five-year workbook models the revenue physiotherapy clinic with therapeutic capacity, use, treatment prices and active months and then combines the assumptions with the financial statements and control panels.
Use the workbook to plan how the availability of therapists and the ability to treat translates into the clinic' s revenue, operating expenses, cash flow and financial results.
Operational assumptions, which may be editable, are the source of the model calculations, which are included in the analysis of scenarios, financial statements, management charts and summary reports throughout forecast.
Revenue are calculated on the basis of available therapeutic capacity, maximum monthly treatments, utilization, realised treatment prices, active months and the sum of each service line.
Definition of the categories of practices or revenue resources, numbers, start-up dates and service lines.
Multiplication of available resources by maximum monthly treatment or resource services.
For the purposes of estimating service units, the percentage of utilization or ramp to maximum capacity shall be used.
Multiplication of expected service units by realised processing price and active months of operation.
The amount of revenue calculated for practices, resources or defined service lines.
The revenue article organizes the number of therapists, start time, monthly treatment capacity, use and average treatment prices that are the source of the clinic' s revenue calculations.
Revenue assumptions
COGS & OPEX separates direct operating costs, variable operating expenses and fixed overhead with time and percentage or expense assumptions.
COGS & OPEX
In view of the scenarios, the low, basic and high paths of revenue, gross margin, contribution margin and EBITDA under the five-year forecast are compared.
Scenarios
The Dashboard combines configuration controls, scenario outcomes, core finance, revenue mix, profitability, cash flow and return on investment in one management view.
Dashboard
A ready-made model is suitable for capacity-based clinical planning, whereas different revenue structural logics, operational schedules or reporting requirements may require on-demand modelling.
The indicator is the starting point for planning, not a guarantee of performance.
The Financial Models Lab can build or customize the model when you need a different revenue logic, operational schedule or financial reporting for your needs.
Order of the financial model for the orderUpon purchase, you will receive an editable five-year financial model of the physiotherapy clinic as an instant download with scenario analysis and key financial reports.
Download a fully editable model of Excel and Google Sheets for entering clinical planning data.
Work with detailed monthly and annual projections over the five years forecast.
Compare the Low, Base and High cases using the model scenario view.
An overview of profits and losses, cash flow, balance sheet, balance sheet and summary of results.
The basic answers are visible in their entirety, without the need to click on the accordion.
It calculates available treatment capacity from practitioner resources, uses utilization, price and active months, and then combines revenue across different service lines.
You can edit the categories and numbers of practitioners, opening dates, monthly treatment capacity, usage, treatment prices, service lines, months of activity and seasonality.
In view of the scenarios, the low, basic and high paths for revenue, gross margin, contribution margin and EBITDA are compared throughout forecast.
The product shall show gains and losses, cash flow, balance sheet, dashboard, summary, scenarios, charts and report from KPI.
Yes. the Financial Models Lab offers individual financial modelling when you need different revenue logic, operational timetable or reporting structures.
This is a forecast planning, not a guarantee of performance; the results depend on your assumptions and your actual operations.
You get a pre-built financial model for a physical therapy startup, complete with a dynamic dashboard, 5-year projections, and detailed breakdowns of all revenue and cost drivers.
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