Test the price, capacity and costs behind your physical therapy clinic. Explore the online worksheet previews alongside calculations from the current illustrative business case.
4 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Five-year forecast and separate operating break-even sensitivity
Editable Excel product with assumptions and formulas
The online preview illustrates 4 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01RevenueThe matching product models therapist resources, maximum monthly treatment capacity, utilization and realized prices by service line. The online case translates that structure into completed clinic-wide visits.Explore layout ↓
02COGS & OPEXSeparate revenue-linked billing, payment and consumable expense from rent, practice systems, insurance, marketing and maintenance.Explore layout ↓
03PayrollPay the owner therapist, three employed therapists and administrative coverage before calculating the operating result.Explore layout ↓
04Scenarios and financial statementsThe product description provides low/base/high comparisons, a dashboard and linked income statement, cash-flow and balance-sheet reporting.Explore layout ↓
Explore the online worksheet illustrations
Open each online sheet presentation to read its specification and illustration. These web views are not screenshots or downloadable Excel files.
Physical Therapy ClinicPlanned XLSX
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$610,270
$813,694
$904,104
Supplies, billing and payment expense
$48,822
$65,095
$72,328
Therapists, paid owner and administration
$570,000
$570,000
$570,000
Premises and fixed practice overhead
$150,000
$150,000
$150,000
EBITDA
−$158,552
$28,599
$111,776
EBITDA margin
-26.0%
3.5%
12.4%
Planned presentation, not a completed file. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01RevenueWorksheet specification
Revenue
Planned purpose: The matching product models therapist resources, maximum monthly treatment capacity, utilization and realized prices by service line. The online case translates that structure into completed clinic-wide visits.
Inputs
Therapists and available appointment blocks
Maximum monthly visits per therapist
Completed utilization after gaps and closures
Net realized price per completed visit
Service opening dates and active months
Outputs
Completed visits
Service-line revenue
Total clinic revenue
Limits and completion needs
The public model is an independently authored national scenario; it is not a claim about figures embedded in the purchased workbook.
Do not count one visit again for each billed procedure code or count the same clinician in overlapping service lines.
Product images and descriptions establish structure; paid workbook formulas have not been independently audited.
02COGS & OPEXWorksheet specification
COGS & OPEX
Planned purpose: Separate revenue-linked billing, payment and consumable expense from rent, practice systems, insurance, marketing and maintenance.
Inputs
Billing and payment terms
Clinical consumables
Lease and recurring overhead
Start dates and expense timing
Outputs
Variable expense
Contribution
Fixed practice overhead
Limits and completion needs
The selected percentages and dollar costs need local quotations.
Employee therapist compensation remains in payroll and is not deducted a second time here.
03PayrollWorksheet specification
Payroll
Planned purpose: Pay the owner therapist, three employed therapists and administrative coverage before calculating the operating result.
Inputs
Role and paid schedule
Base compensation
Employer costs and relief provision
Hiring dates
Outputs
Monthly payroll commitment
Annual paid staffing cost
Limits and completion needs
National wage statistics do not include this employer benefit package or owner distributions.
A receptionist or aide does not create licensed therapist capacity.
04Scenarios and financial statementsWorksheet specification
Scenarios and financial statements
Planned purpose: The product description provides low/base/high comparisons, a dashboard and linked income statement, cash-flow and balance-sheet reporting.
Inputs
Capacity, price and cost changes
Collection timing and funding assumptions
Opening investment
Outputs
Scenario comparison
Operating result
Cash and financial-position projections
Limits and completion needs
Check actual workbook input behavior before relying on a payment-delay or financing calculation.
The website break-even calculator excludes debt, tax, receivables and investment recovery.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
These are the current inputs behind the business case and the intended starting points for the editable workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
16
$50,228
$65,217
Not reached
Base volume
24
$75,342
$65,217
Month 11
Higher volume
32
$100,456
$65,217
Month 6
Only completed visits per day across the clinic changes. Net realized revenue per completed visit: $145.00; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 24-month ramp. This sensitivity is separate from the annual forecast and does not measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They demonstrate intended workbook topics, not a tested Excel file.
01 / Annual forecast
Revenue across five years
$610.3k
Year 1
$813.7k
Year 2
$904.1k
Year 3
$974.3k
Year 4
$1.0m
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold work and clinical layout$150,000
Treatment tables and rehabilitation equipment$65,000
Furniture, computers and practice-system setup$30,000
Lease deposits and opening occupancy$25,000
Professional setup, credentials and launch$20,000
Working capital and contingency reserve$260,000
One-time budget: $550,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $904,104.
Supplies, billing and payment expense$72,328
Therapists, paid owner and administration$570,000
Premises and fixed practice overhead$150,000
EBITDA$111,776
EBITDA margin: 12.4%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
21
Break-even revenue / month
$65,217
Base revenue / month at maturity
$75,342
First operating break-even
Month 11
Units mean completed visits per day across the clinic. The ramp covers 24 months; operating break-even does not measure recovery of opening capital.
The annual forecast and fixed-cost sensitivity are separate planning views. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
The annual forecast and original calculator inputs agree within $5 on Year 1 revenue, Year 1 operating result and the mature annual operating result. These checks do not validate demand, assumptions or cash funding.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your physical therapy clinic together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
File format
XLSX
Editor
Microsoft Excel
Editing
Input cells, forecast assumptions and formulas; workbook behavior still needs verification.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Physical Therapy Clinic Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Revenue, COGS & OPEX, Payroll, Scenarios and financial statements using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review net realized revenue per completed visit, completed visits per day across the clinic, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
