πŸ“Š Free Portfolio Tool

Margin variance is the
hidden EBITDA lever in every roll-up

Enter your portfolio companies. Get margin spread, weighted average, standard deviation β€” and the exact EBITDA uplift if your worst portcos hit the portfolio median. No spreadsheet required.

1
Enter your portfolio companies
3–10 rows Β· Use TTM revenue and last full-year gross margin %
Company Name Trade Revenue (TTM) Gross Margin % Locations
Margin Spread
β€”
best vs. worst
Wtd Avg Gross Margin
β€”
revenue-weighted
Std Deviation
β€”
margin consistency signal
EBITDA Uplift Potential
β€”
bottom quartile β†’ median
πŸ“ˆ Gross Margin % by Company β€” vs. Portfolio Median
🏒 Per-Company Breakdown
Company Trade Revenue Gross Margin Est. EBITDA EBITDA % Quartile EBITDA Gap
πŸ”’ Portfolio Summary
Total portfolio revenue β€”
Total portfolio EBITDA (est.) β€”
Best gross margin β€”
Worst gross margin β€”
Revenue-weighted avg gross margin β€”
Unweighted avg gross margin β€”
Standard deviation of gross margin β€”
EBITDA uplift if bottom-quartile portcos hit median β€”
Track portfolio margin automatically

Track margin variance automatically
across your entire portfolio

RollForge connects to each portco's accounting data and surfaces margin drift, EBITDA attribution, and outlier alerts β€” automatically, every week. No quarterly spreadsheet refresh.

Start Free Trial β€” See Live Numbers β†’

7-day free trial.

Why margin variance matters more than average margin in a roll-up

When PE operators run portfolio-level gross margin analysis, the average hides the story. A portfolio with four companies at 38% margin and two at 18% margin has an "average" of 32% β€” but the two outliers represent concentrated EBITDA risk and the highest-ROI value-creation opportunity in the portfolio.

8–14%
Typical gross margin spread in an early trade service roll-up
2–4Γ—
EBITDA improvement from moving one portco from bottom to median quartile
90 days
Typical time to close a 2–3 point margin gap with focused dispatch + pricing ops

What drives margin variance in trade service portfolios

In a mature HVAC, plumbing, or electrical roll-up, gross margin variance between portcos almost always traces back to four root causes: (1) pricing discipline β€” the best-margin portcos have flat-rate pricing books with fewer tech-discretion discounts; (2) callback rate β€” every callback is a zero-revenue slot occupying a billable tech; (3) parts markup consistency β€” some portcos buy retail and mark up 10–15%, others have negotiated distributor pricing at 50–60% markup; (4) labor efficiency β€” measured as revenue per tech-day, not just billable utilization.

The portfolio manager's job is to rank-order the variance drivers, build a standardization roadmap for the bottom-quartile portcos, and track progress on a short cadence (weekly, not quarterly). The tools that automate this tracking pay for themselves in the first deal.

What "weighted average" means and why it matters

Unweighted average gross margin treats a $3M portco and a $30M portco as equal contributors. Revenue-weighted average weights each portco by its share of consolidated revenue β€” so a 32% portco at $30M revenue moves the weighted average 10Γ— more than a 28% portco at $3M revenue. The weighted average is what gets defended in a valuation conversation. The standard deviation tells you how defensible it is.

EBITDA uplift methodology

This tool estimates EBITDA uplift by identifying companies in the bottom quartile of gross margin (below the revenue-weighted portfolio median) and calculating the incremental EBITDA if those companies achieved the portfolio's median gross margin on their current revenue base. EBITDA is estimated using a standard blended SG&A/overhead multiplier of 18–22% of revenue (configurable in the calculation). This is a planning-level estimate β€” actual uplift depends on execution against the operational plan.