2 TTM Financials (Auto-Populated)
Trailing 12-month figures for the selected practice, pulled from the June 2026 TTM report. Edit any field to override with your own assumption.
Gross Production
—
TTM annualized
Net Collections
—
TTM annualized
Net Practice Revenue
—
TTM annualized
Adjusted EBITDA
—
— of net revenue
Promotional Spend
—
— of net revenue
3 Your Inputs
Change any value to model a scenario. Yellow rows indicate a user override; blue rows are auto-calculated.
Variable Cost %: the portion of every incremental production dollar that gets consumed by variable costs (doctor comp, supplies, lab, portion of clinical staff). Typical Gen4 GP practice ≈ 50%. Higher variable ratio = more production growth needed to fund the same promo increase.
4 Analysis
Current Promo % of Revenue
—
— /month
Target Promo Budget
—
— /month
Additional Promo $ (Δ)
—
— /month
Production Growth Required to Hold EBITDA Flat
Growth %
—
at selected variable-cost ratio
Required New Production
—
— additional annual
EBITDA Impact if No Growth
—
EBITDA change at current production, new promo
| Variable cost % (ex-promo) |
Growth required |
New production |
Additional production |
5 Method & Assumptions
- EBITDA-neutral growth is calculated as: New Production ÷ Current Production = (1 − VC% − Current Promo%) ÷ (1 − VC% − Target Promo%). Fixed costs (occupancy, non-doc staff, G&A) cancel because they don't change with production.
- TTM values come from the June 2026 Gen4 TTM Reporting workbook (Total Promotional Expense, Net Practice Revenue, Net Collections, Gross Production, Total Adjusted Practice EBITDA rows) joined to the SGA Master Crosswalk by Paylocity Code / Sage ID / name.
- SGA East practices are not in the Gen4 TTM report and appear here only when we have Power BI data seeded manually (currently: Smile Gulf Coast). For other SGA East practices, use the calculator with manual inputs.
- The math holds EBITDA flat. It doesn't grow it. If the goal is to spend more AND grow EBITDA, production growth must exceed the calculated %.
- Assumes the growth actually happens. This model tells you the growth needed; it doesn't tell you whether the added promo will produce that growth. Stress-test against new-patient CPA and clinical capacity.