Normalized EBITDA reconciliation and monthly variance bridge for PE-backed platforms. The financial model your sponsor actually reads.
| Bridge Component | Amount | Impact |
|---|---|---|
| Reported EBITDA | $3.82M | — |
| One-time legal settlement | +$185K | Add back |
| Non-recurring consulting | +$125K | Add back |
| Owner compensation above market | +$70K | Add back |
| Normalized EBITDA | $4.20M | Clean |
Follow the tab sequence left to right. Blue cells are your inputs.
Six worksheets — each solving a specific financial reporting problem
This framework is designed for operators who report EBITDA to PE sponsors.
One workbook. Two license types.
| Without this framework | With this framework |
|---|---|
| EBITDA adjustments live in ad-hoc spreadsheets that change format monthly | Consistent normalization structure — same format every month |
| Sponsors question add-backs because the reconciliation trail is unclear | Clean reported → normalized walk with categorized adjustments |
| Variance commentary is a text-heavy email, not a structured bridge | Monthly and YTD bridges decompose variance by driver |
| Board-ready charts are rebuilt from scratch every quarter | Waterfall chart auto-generates — copy and paste into any deck |
No. The entire workbook uses standard Excel formulas. No macros, no VBA, no plugins. Works in Excel 2016+ and Google Sheets.
No. This is specifically an EBITDA normalization and bridge framework. It starts at reported EBITDA and walks to normalized EBITDA, then tracks monthly and YTD variance. If you need a full three-statement model, this complements it — the bridge output feeds into your LP reporting.
Yes. The standard categories (one-time, non-recurring, run-rate adjustments) are pre-built, but you can add, rename, or remove categories to match your specific normalization requirements.
Monthly. The framework is designed for monthly close cadence. Update actuals after each month-end close. The YTD bridge accumulates automatically.
A former Big-4 consultant and Managing Director who ran monthly LP reporting for a $500M+ industrial services platform under PE sponsor oversight. The framework reflects the exact reporting architecture used in real monthly investor updates.
6 worksheets. Normalized EBITDA. Monthly bridge. Waterfall chart. Sponsor-ready.