Test the price, capacity and costs behind your mental health practice. Explore the online worksheet previews alongside calculations from the current illustrative business case.
5 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Five-year forecast and identified monthly operating sensitivity
Editable Excel product with assumptions and formulas
The online preview illustrates 5 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01RevenueThe matched product describes clinician/resource counts, monthly capacity, utilization, realized session prices and active months. This adaptation uses one psychologist and three counselor streams.Explore layout ↓
02COGS & OPEXThe product describes separate direct and variable costs and fixed overhead. Model billing and payment charges separately from office and secure-records spending.Explore layout ↓
03ScenariosThe verified product compares low, base and high revenue, margins and EBITDA over its five-year forecast.Explore layout ↓
05Income Statement / Cash Flow / Balance SheetThe product confirms linked financial statements. Use a separate collection schedule to bridge earned session fees to cash.Explore layout ↓
Explore the online worksheet illustrations
Open each section to read the operating assumptions and illustration. These web views are not screenshots or downloadable Excel files.
Mental Health PracticeHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$565,065
$779,400
$779,400
Variable billing, payment and session supplies
$28,253
$38,970
$38,970
Clinicians, paid owner, administration and relief
$480,000
$480,000
$480,000
Office, records systems, insurance and support
$120,000
$120,000
$120,000
EBITDA
−$63,188
$140,430
$140,430
EBITDA margin
-11.2%
18.0%
18.0%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01RevenueOperating assumptions
Revenue
Scenario purpose: The matched product describes clinician/resource counts, monthly capacity, utilization, realized session prices and active months. This adaptation uses one psychologist and three counselor streams.
Inputs
Licensed clinician availability
Monthly session capacity per clinician
Completed-session utilization
Realized fees by clinician and payer
Service launch and active months
Outputs
Completed sessions by clinician stream
Earned session revenue
Combined operating revenue
Scope and limitations
One appointment is assigned once; referral, documentation and room use are not extra sessions.
Posted self-pay fees do not verify payer allowances.
Current product description confirms architecture; no purchased workbook formula audit is claimed.
02COGS & OPEXOperating assumptions
COGS & OPEX
Scenario purpose: The product describes separate direct and variable costs and fixed overhead. Model billing and payment charges separately from office and secure-records spending.
Inputs
Variable billing and payment terms
Session supplies
Office occupancy
Records and communications systems
Outputs
Variable service expense
Fixed operating overhead
Operating contribution
Scope and limitations
The authored variable share must change if outsourced billing or payer mix changes.
Clinical payroll is retained separately in the national operating case.
03ScenariosOperating assumptions
Scenarios
Scenario purpose: The verified product compares low, base and high revenue, margins and EBITDA over its five-year forecast.
Inputs
Clinician count and capacity
Utilization and realized prices
Cost and timing assumptions
Outputs
Alternative revenue paths
Gross and contribution margins
EBITDA comparisons
Scope and limitations
Cases have no assigned probability.
A lower fee and fewer sessions can occur together; single-input cases do not measure the combined exposure.
04DashboardOperating assumptions
Dashboard
Scenario purpose: The product describes scenario controls, revenue mix, profitability, cash flow and return summaries.
Inputs
Selected operating case
Revenue mix and timing
Staffing, overhead and funding assumptions
Outputs
Management financial summaries
Revenue and profitability trends
Cash-flow and return summaries
Scope and limitations
A summarized return does not verify collections or a clinical operating advantage.
The online case does not adopt the merchant example’s return or growth claims.
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 inputs drive the website business case. The purchased workbook has its own assumptions and examples; adapt them to your operating scope. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Mental Health Practice input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Realized fee per completed psychotherapy session
$150.00
$110.00 – $190.00
Revenue per sold unit
Completed sessions per day across all four clinicians
20
12 – 24
Daily throughput in the stated operating scope
Operating days per week
5
4 – 5
Trading schedule
Fixed operating costs / month
$50,000
Held constant
Operating break-even threshold
Contribution margin
95.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
40.0%
Base ramp input
Opening month revenue
Mature volume added / month
6.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
18 months
Base ramp input
Period checked for operating break-even
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
12
$38,970
$52,632
Not reached
Base volume
20
$64,950
$52,632
Month 8
Higher volume
24
$77,940
$52,632
Month 6
Only completed sessions per day across all four clinicians changes. Realized fee per completed psychotherapy session: $150.00; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 18-month ramp. Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. Slider cases do not change the annual forecast or measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They illustrate planning calculations; they do not establish the purchased workbook’s formula behavior.
01 / Annual forecast
Revenue across five years
$565.1k
Year 1
$779.4k
Year 2
$779.4k
Year 3
$779.4k
Year 4
$779.4k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Lease deposits and preopening occupancy$12,000
Office adaptation and acoustic privacy$35,000
Consultation and reception furnishings$18,000
Secure IT, records and software setup$12,000
Entity, licensing, insurance and launch setup$13,000
Opening operating cash reserve$250,000
One-time budget: $340,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $779,400.
Variable billing, payment and session supplies$38,970
Clinicians, paid owner, administration and relief$480,000
Office, records systems, insurance and support$120,000
EBITDA$140,430
EBITDA margin: 18.0%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
17
Break-even revenue / month
$52,632
Base revenue / month at maturity
$64,950
First operating break-even
Month 8
Units mean completed sessions per day across all four clinicians. The ramp covers 18 months; operating break-even does not measure recovery of opening capital.
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. 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.
Annual forecast and monthly operating reconciliation
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions.
Original inputs · annual USD · whole-dollar rounding tolerance $5
Check
Annual forecast
Monthly calculator base
Year 1 revenue
$565,065
$565,065
Year 1 operating result
−$63,188
−$63,188
Year 2 revenue
$779,400
$779,400
Year 2 operating result
$140,430
$140,430
Year 3 revenue
$779,400
$779,400
Year 3 operating result
$140,430
$140,430
Year 3 / full-volume annual revenue
$779,400
$779,400
Year 3 / full-volume annual operating result
$140,430
$140,430
Year 1 uses months 1–12, Year 2 months 13–24 and Year 3 months 25–36. Full-volume rows use mature monthly sales and operating result × 12. The calculator holds price, days, contribution and fixed costs constant; an annual price, staffing or cost change can explain a separate path. Sliders do not change this comparison. Neither column measures cash flow, owner distributions or payback. Agreement tests arithmetic, not demand or cash funding. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your mental health practice 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 Mental Health Practice 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, Scenarios, Dashboard, Income Statement / Cash Flow / Balance Sheet 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 realized fee per completed psychotherapy session, completed sessions per day across all four clinicians, 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.
