Dashboard — Key Metrics Snapshot
$/procedure: primary ablation (36475 RFA · 36482 VenaSeal · 36465/36466 Varithena) + ultrasound allocation (93970/93971) + liquid sclero allocation (36470/36471).
Buffers: E&M revenue (99203/99204/99213/99214) excluded; final Gross / Net / EBITDA reflect a 10% conservatism haircut.
Scenario Selector← click to switch
Drives all KPIs, charts, P&L, and revenue numbers below.Conversion Rate Controls
Contact Rate53.0%
10%80%
Booking Rate60.0%
20%75%
Show Rate78.0%
40%92%
Treatment Conversion65.0%
30%78%
3-Year P&L · Excel-aligned · scenario-toggled
engine: calcAnnualPL · flag: V12_HARDENINGActive: Base — 75/25 New Braunfels market · realization 94%
Year 1ramp
Gross Revenue$1.71M$1,711,802
EBITDA$494.47K$494,467
margin31.4%
Year 2partial stabilization
Gross Revenue$2.48M$2,482,648
EBITDA$1.02M$1,017,032
margin44.5%
Year 3steady-state · near-capacity
Gross Revenue$2.97M$2,974,244
EBITDA$1.31M$1,309,549
margin47.9%
Year 3 reflects stabilized operations; Year 1 reflects the credentialing ramp. Three core scenarios isolate single-factor sensitivities — Downside models reimbursement pressure (net realization 83%, payer mix drift to 65% commercial); Base reflects the New Braunfels demographic baseline (75/25 mix, 94% realization); Upside models DTC under-65 commercial targeting at 85/15 mix. Hybrid Wound Care Referral Base models a vein clinic embedded inside a wound-care center where internal referrals fill Year 1 capacity from Month 1 (slider-controlled), ramping to full capacity by Year 2. Margins are modeled targets, not guarantees.
Y1 Procedures
791
5 mo AT CAPACITY
Blended Rate
$1,816
Mature (M5+) / proc
Revenue / Procedure
$2,405
Before 8% mgmt fee
Revenue / Patient
$7,409
Before 8% mgmt fee
Cost Per Acquisition
$370
Marketing / treated
Procs / Patient
3.1
Monthly Demand vs Capacity — Year 1
Excess demand detected — capacity-constrainedRaw funnel demand vs 86/mo capacity ceiling — excess demand = patients turned away, validating expansion thesis
Y1 Funnel Bridge
| Stage | Monthly Avg | Annual | Conv Rate |
|---|---|---|---|
| Leads | 195.9 | 2,351 | — |
| Contacts | 104.1 | 1,249 | 53.1% |
| Booked | 62.4 | 749 | 60.0% |
| Shows | 48.8 | 585 | 78.1% |
| Treated | 31.8 | 381 | 65.1% |
| Procedures | 65.9 | 791 | 207.6% |
| Gross Revenue | $142,650 | $1,711,802 | — |
3-Year Gross Revenue Trajectory
Revenue Summary
Y1 Gross Revenue$1,711,802
Y2 Gross Revenue$2,482,648
Y3 Gross Revenue$2,974,244
Y1 Mgmt Fee (8%)($152,158)
Y1 Net Revenue$1,574,860
Max Capacity86/mo
3-Year Summary
| Metric | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Annual Procedures | 791 | 1,162 | 1,404 |
| Avg Gross Rev / Proc | $2,405 | $2,374 | $2,354 |
| Gross Revenue | $1,711,802 | $2,482,648 | $2,974,244 |
| Mgmt Fee (8%) | ($152,158) | ($220,680) | ($264,372) |
| Net Revenue | $1,574,860 | $2,284,036 | $2,736,310 |