Blank Start, Clear Direction
This template gave me a place to begin instead of staring at an empty file. I had a working private physiotherapy model in under an hour, which saved me a full day of setup.
This template gave me a place to begin instead of staring at an empty file. I had a working private physiotherapy model in under an hour, which saved me a full day of setup.
I stopped hunting through separate sheets for charts, statements, and assumptions. Now I can pull the full picture from one file, and it cut my monthly reporting prep by about 3 hours.
I’m not great with advanced Excel, but this model was straightforward to follow. I updated the inputs myself and had a clean forecast ready for a lender call the same afternoon.
This editable five-year workbook modeles the capacity of the practitioner, use, price of treatment, costs, scenarios and financial statements to plan the business practice.
Use the model to plan the therapist's capabilities, opening dates, use ramps, treatment prices, operating costs, employment and financial decisions in one forecast.
The Editable assumptions feed the revenue engine and operating schedules and then flow to financial statements, comparisons of scenarios and navigation desktops for the board.
The model calculates revenues from services from available therapists or resources, their monthly treatment capacity, use, price realized, months of activity and time of the line of service.
Definition of category of therapists or income resources, number, date of availability and structure of service lines.
Maximum treatments equal to available therapists or resources multiplied by monthly resource treatments.
The expected treatment is equal to the maximum machining power multiplied by the assumption of use.
Real treatment prices, months of activity, opening time and seasonality should be used if present.
Total calculated medical income for therapists, resources and service lines.
The calculation sheet of revenue assumptions organises the availability of the practitioner, the ability to operate, the price of treatment and the contribution of use, which drives the calculation of the revenues based on the capacity of the model.
Revenue assumptions
The COGS spreadsheet and operating expenditure separates the costs of direct processing, variable costs related to revenue and the general fixed costs with assumptions of time and period.
COGS & OPEX
The scenario analysis compares the Low, Base, and High levels for revenue, gross margin, contribution margin and EBITDA over the forecast period of five years.
Scenarios
You can use the dashboard to view model settings, scenario multipliers, basic finances, a mixture of revenue, profitability, cash flow and payback period investments all in one place.
Dashboard
The ready model fits based on available capacity practices with an editable practice, use, price, time, cost and scenarios; different operating logic may require a custom structure.
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, operating schedule, calculation or reporting for your needs.
Order of the financial model for the orderYou will receive an editable financial model of private physiotherapy for immediate download, with five-year projections, scenario analysis, desktop reporting and financial reports.
Update the therapist's assumptions, capabilities, use, prices, costs, staff and time.
Planning of practice within the five-year projection horizon with related financial calculations.
Compare Low, Base, and High cases in terms of revenue, margins and EBITDA.
Review statements, navigation desktop results, charts and other confirmed management reports.
The basic answers are visible in their entirety, without the need to click on the accordion.
It calculates the capacity from available practitioners or resources, uses the use, realized treatment prices, active months, opening times and then combines revenues in different service lines.
You can edit categories of therapists or resources, numbers, availability dates, monthly treatment capacity, use, treatment prices, active months, service lines and seasonality if present.
The review of the scenario analysis compares the outcome of the cases with respect to revenue, gross margin, contribution margin and EBITDA over the five-year period forecast.
The product shall contain an income statement, a cash flow report, a balance sheet, a dashboard, a summary, charts, KPIs and other related financial statements.
Yes. the Financial Models Lab offers individual financial modelling when you need different revenue logic, operational timetable, calculations or reporting.
This is a planning forecast based on edited assumptions and not a guarantee of business performance, profitability, financing or return.
This Excel financial model for a private physiotherapy clinic comes with a dynamic dashboard, 5-year financial projections (P&L, Cash Flow, Balance Sheet), a detailed breakdown of startup costs, revenue and expense modeling, and a break-even analysis.
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