Test the price, capacity and costs behind your dental practice. Explore the online worksheet previews alongside calculations from the current illustrative business case.
6 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 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01RevenueThe observed workbook has separate general-dentist, hygienist, cosmetic-dentist, orthodontist and oral-surgeon rows. Practitioner count, launch date, maximum monthly treatments, utilization and realized fee create revenue; the StartFigures case keeps these five streams.Explore layout ↓
02COGS & OPEXThe product provides direct and operating-cost inputs. For this case, separate visiting-provider compensation, laboratory and supply use, payment expense and fixed occupancy costs.Explore layout ↓
03PayrollThe visible Payroll module supports staffing assumptions. This scenario pays the owner dentist and employed team; separately compensated visiting clinicians remain in direct cost.Explore layout ↓
04CAPEX and CapitalThe visible capital modules provide the place to replace the example with the actual clinical fit-out, equipment, funding and installation schedule.Explore layout ↓
05Statements and SummaryThe current product lists five-year income statement, cash flow and balance sheet outputs. Reconcile service revenue, provider costs and employment costs before using those outputs.Explore layout ↓
06Scenarios, BE and DashboardVisible scenario, break-even and dashboard tabs support comparison of selected operating inputs. Test utilization, fee realization and staffing without assuming more chairs automatically create more provider hours.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.
Dental PracticePlanned XLSX
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$2,117,370
$2,650,000
$3,117,600
Visiting-provider payouts, clinical supplies, laboratory work and payment costs
$571,690
$715,500
$841,752
Paid owner, employed dentist, hygiene, assistants, management and administration
$1,287,000
$1,287,000
$1,287,000
Occupancy, utilities, insurance, software, marketing, repairs and other overhead
$360,000
$360,000
$360,000
EBITDA
−$101,320
$287,500
$628,848
EBITDA margin
-4.8%
10.8%
20.2%
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 observed workbook has separate general-dentist, hygienist, cosmetic-dentist, orthodontist and oral-surgeon rows. Practitioner count, launch date, maximum monthly treatments, utilization and realized fee create revenue; the StartFigures case keeps these five streams.
Inputs
Provider headcount by stream
Available monthly appointments per provider
Utilization after gaps and closures
Realized fee by service line
Launch date and active months
Outputs
Completed appointments by provider stream
Service-line revenue
Total net operating revenue
Limits and completion needs
Provider headcount is not full-time-equivalent capacity. Visiting-session calendars constrain the entered maximum.
The readable product image establishes the E09 structure; the paid workbook formulas have not been independently audited.
One orthodontic case fee cannot be counted again at every follow-up; allocate the case revenue consistently across its appointments and timing.
02COGS & OPEXWorksheet specification
COGS & OPEX
Planned purpose: The product provides direct and operating-cost inputs. For this case, separate visiting-provider compensation, laboratory and supply use, payment expense and fixed occupancy costs.
Inputs
Service-linked provider payouts
Laboratory and clinical consumables
Payment expense
Rent, utilities and recurring overhead
Outputs
Direct cost
Contribution by service mix
Fixed operating expense
Limits and completion needs
The scenario percentages are authored, not quoted specialist contracts or laboratory prices.
Do not count a visiting provider in both percentage payouts and employed payroll.
03PayrollWorksheet specification
Payroll
Planned purpose: The visible Payroll module supports staffing assumptions. This scenario pays the owner dentist and employed team; separately compensated visiting clinicians remain in direct cost.
Inputs
Role and paid hours
Salary and hourly pay
Employer burden and relief allowance
Hiring dates
Outputs
Employee and owner labor budget
Monthly payroll commitment
Limits and completion needs
BLS wage data are national employee benchmarks, not local offers or owner earnings.
The owner has a funded clinical role; distributions are separate from compensation.
04CAPEX and CapitalWorksheet specification
CAPEX and Capital
Planned purpose: The visible capital modules provide the place to replace the example with the actual clinical fit-out, equipment, funding and installation schedule.
Inputs
Equipment and leasehold uses
Payment and launch dates
Opening reserve
Debt and equity
Outputs
Capital and funding schedule
Funding requirement
Limits and completion needs
The opening reserve is cash, not depreciable equipment.
Equipment quotes, debt terms, tax and replacement investment need separate verified inputs.
05Statements and SummaryWorksheet specification
Statements and Summary
Planned purpose: The current product lists five-year income statement, cash flow and balance sheet outputs. Reconcile service revenue, provider costs and employment costs before using those outputs.
Inputs
Operating schedules
Collection and payment timing
Opening balances
Funding and tax assumptions
Outputs
Income statement
Cash flow
Balance sheet
Financial summary
Limits and completion needs
Gross billed production, net revenue and cash receipts are distinct.
A positive operating result does not establish distributions, debt capacity or funding sufficiency.
06Scenarios, BE and DashboardWorksheet specification
Scenarios, BE and Dashboard
Planned purpose: Visible scenario, break-even and dashboard tabs support comparison of selected operating inputs. Test utilization, fee realization and staffing without assuming more chairs automatically create more provider hours.
Inputs
Low, base and high selections
Realized-fee and utilization changes
Direct-cost and fixed-cost changes
Outputs
Scenario comparison
Break-even view
Management dashboard
Limits and completion needs
No scenario probability or guaranteed result is implied.
A changed service mix needs a new weighted fee and contribution margin, not only a higher appointment count.
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.
Dental Practice input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Net realized fee per completed appointment
$400.00
$320.00 – $480.00
Revenue per sold unit
Completed appointments per day across the whole clinic
30
18 – 40
Daily throughput in the stated operating scope
Operating days per week
5
4 – 6
Trading schedule
Fixed operating costs / month
$137,250
Held constant
Operating break-even threshold
Contribution margin
73.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
35.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
18
$155,880
$188,014
Not reached
Base volume
30
$259,800
$188,014
Month 8
Higher volume
40
$346,400
$188,014
Month 5
Only completed appointments per day across the whole clinic changes. Net realized fee per completed appointment: $400.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. 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
$2.1m
Year 1
$2.7m
Year 2
$3.1m
Year 3
$3.4m
Year 4
$3.7m
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold, dental utilities, accessibility and clinical room fit-out$600,000
Six treatment-room packages and dental delivery equipment$300,000
Digital imaging, scanning and selected clinical technology$250,000
Sterilization, instruments, compressor, vacuum and waste systems$110,000
Reception, calm interior finishes, furniture, IT and security$140,000
Design, professional fees, licensing and pre-opening payroll$120,000
Deposits, initial clinical inventory and launch marketing$80,000
Working capital and contingency reserve$550,000
One-time budget: $2,150,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $3,117,600.
Visiting-provider payouts, clinical supplies, laboratory work and payment costs$841,752
Paid owner, employed dentist, hygiene, assistants, management and administration$1,287,000
Occupancy, utilities, insurance, software, marketing, repairs and other overhead$360,000
EBITDA$628,848
EBITDA margin: 20.2%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
22
Break-even revenue / month
$188,014
Base revenue / month at maturity
$259,800
First operating break-even
Month 8
Units mean completed appointments per day across the whole clinic. The ramp covers 18 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 dental 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 Dental 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, Payroll, CAPEX and Capital, Statements and Summary, Scenarios, BE and Dashboard 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 fee per completed appointment, completed appointments per day across the whole 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.
