Margins are weighted
Portfolio EBITDA margin = total EBITDA ÷ total revenue for the selected companies and quarter. It is not the average of company percentages. EBITDA is reported, without discretionary add-backs.
Synthetic reference · Operations
Private equity portfolio dashboard demo
Six fictional companies. Eight quarters. Trace operating performance back to the inputs and the exceptions.
Review date: 2026-07-15Fixed historical review date for each quarter
6 of 6 fictional companies · 2026-Q2 · USD
- Revenue
- $57,900,000
- Weighted EBITDA margin
- 17.64%
- Closing operating working capital
- $7,839,400
- Revenue vs budget
- -$180,000 (-0.31%)
- Source freshness
- 1 stale source
- Source tie-out
- 1 reconciliation exception
Review required: this working view includes stale or unreconciled inputs. It is not an approved reporting pack.
| Company | Revenue | EBITDA margin | Working capital | Revenue variance | Source refreshed | Revenue tie-out Δ | Review status |
|---|---|---|---|---|---|---|---|
| Alder Components | $5,050,000 | 10.00% | $757,500 | $120,000 | 2026-07-05 | $0 | Checks passed: synthetic working view |
| Briar Field Services | $6,890,000 | 12.50% | $1,033,500 | -$180,000 | 2026-07-05 | $0 | Checks passed: synthetic working view |
| Cedar Supply | $8,730,000 | 15.00% | $1,309,500 | $120,000 | 2026-07-05 | $25,000 | Exception: review required |
| Dovetail Software | $10,570,000 | 17.50% | $739,900 | -$180,000 | 2026-07-05 | $0 | Checks passed: synthetic working view |
| Elm Packaging | $12,410,000 | 20.00% | $1,861,500 | $120,000 | 2026-06-10 | $0 | Exception: review required |
| Flint Logistics | $14,250,000 | 22.50% | $2,137,500 | -$180,000 | 2026-07-05 | $0 | Checks passed: synthetic working view |
Calculation record
What the numbers mean
Balances use one quarter end
Operating working capital = receivables + inventory − payables at the selected quarter end. Cash and debt are excluded in this demonstration. Closing balances are never summed across quarters.
Budget variance retains its basis
Revenue variance = actual revenue − budget revenue. Percentage variance divides by budget. An undefined denominator displays as unavailable; a positive variance means revenue exceeded budget.
Exceptions stay visible
A source older than 21 days at the fixed review date is flagged. Revenue tie-out Δ is modeled revenue minus submitted source revenue; differences greater than $1 are flagged. These thresholds are demo assumptions, not a production policy.
The source IDs and fictional controller owners are retained in the download. All records use USD, one calendar, and a constant six-company perimeter. This example does not model currency translation, acquisitions, intercompany eliminations, forecasts, or actual client results.
Prepared September 9, 2026 by Ryan Ussery. Read the Power BI implementation guide for model and access considerations.
Make your monthly portfolio pack reproducible.
Start with its sources, definitions, and the reconciliation work that repeats each cycle.