Runway Became Easy To See
This template made monthly cash flow much easier to follow, so I could spot shortfalls before they became a problem. It saved me hours of guessing and helped me plan staffing and rent with a clearer runway.
This template made monthly cash flow much easier to follow, so I could spot shortfalls before they became a problem. It saved me hours of guessing and helped me plan staffing and rent with a clearer runway.
I was worried one broken formula would throw off the whole model, but the layout kept everything clean and traceable. I finished our first pass without fixing a single error cell, which saved me a full afternoon.
The low, base, and high cases were already set up in a way that made comparisons simple. I had all three forecasts ready for a lender meeting in one sitting instead of spending the whole day copying tabs.
This editable five-year workbook models the revenue occupational therapy clinic with therapeutic capacity, utilization, treatment prices and active months and then combines the assumptions with financial statements and control panels.
Use workbook to plan how the availability and treatment capacity of occupational therapists translates into the revenue clinic, operating expenses, cash flow and financial results.
Editable resources, use, prices, costs, personnel and capital assumptions are the source of the calculations, which consist of scenarios, financial statements, charts and summaries of reports.
Revenue are calculated on the basis of available therapeutic capacity, maximum monthly treatments, utilization, realised treatment prices, active months and sums in different lines of occupational therapy services.
Specify the categories of occupational therapy services, the number of therapists, start dates and when each revenue generating resource becomes available.
Multiplication of available therapeutic resources by maximum monthly treatments or resource services to determine capacity.
In order to estimate the expected monthly service units, utilization percentages or ramps to maximum capacity should be used.
Multiplication of expected service units by average realised processing price and active months of operation.
Amount of calculated revenue for therapists, resources and line of occupational therapy services.
The income assumptions article organizes the number of therapists, start time, monthly treatment capacity, use and average cost of treatment that are the source of the clinic' s revenue calculations.
Revenue assumptions
The COGS & OPEX article separates direct treatment costs, variable operating expenses and fixed overhead with time, interest and 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
The ready-made model is suitable for capacity-based occupational clinical therapy planning, whereas structurally different revenue logics, operational schedules or reporting requirements may require individual 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 orderAfter purchase, you'll receive an editable five-year financial model of the Occupational Therapy Clinic as an instant download with scenario analysis and major financial reports.
Download a fully editable Excel and Google Sheets model for the data entered for planning occupational therapy clinics.
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 treatment capacity from therapeutic resources, uses utilization, realised prices and active months, and then combines revenue in different lines of occupational therapy services.
You can edit the categories and numbers of therapists, 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 comprehensive, pre-built financial model template designed specifically for an occupational therapy clinic, complete with detailed financial statements, a dynamic dashboard, and fully editable assumptions.
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