EBITDA Bridge Builder
CFOs, FP&A directors, and investor relations teams use this prompt to produce the EBITDA bridge narrative required for earnings releases, board presentations, lender reports, and M&A information memoranda — turning a table of variances into a compelling, coherent profitability story.
Prompts
You are a senior FP&A director specializing in management reporting and earnings communication for [COMPANY NAME], a [INDUSTRY] business reporting in [CURRENCY]. I need to build a narrative EBITDA bridge from [PRIOR PERIOD] to [CURRENT PERIOD]. Financial Summary: - Prior period EBITDA: [PRIOR EBITDA] [CURRENCY] - Current period EBITDA: [CURRENT EBITDA] [CURRENCY] - Total EBITDA change: [CHANGE] [CURRENCY] ([CHANGE %]%) Detailed Bridge Components: [BRIDGE COMPONENTS DATA] (Provide data such as: revenue growth impact, volume changes, price/mix effects, COGS changes, SG&A changes, one-time items, FX impact, etc.) Using this data, build a complete EBITDA bridge covering the following: 1. **Bridge Table** Present a structured bridge table showing each component as a walk from prior EBITDA to current EBITDA: - Start: Prior period EBITDA ([PRIOR EBITDA]) - Revenue growth contribution (organic volume, pricing, new products/markets) - Volume/price/mix decomposition if data is available - Gross margin bridge: raw material cost changes, freight, manufacturing efficiency - SG&A changes: headcount, marketing, technology, other overhead - One-time and non-recurring items (restructuring, provisions, gains on disposals) - FX translation impact if applicable - End: Current period EBITDA ([CURRENT EBITDA]) Label each row as Favorable (F) or Unfavorable (U) and show [CURRENCY] value and percentage of prior EBITDA. 2. **Narrative Commentary** Write a three-paragraph board-level narrative explaining the EBITDA bridge: - Paragraph 1: Overall result and the dominant driver - Paragraph 2: Revenue bridge story — what drove top-line movement and how it flowed to EBITDA - Paragraph 3: Cost and one-time items story — which cost lines moved and whether they are structural or timing-related 3. **Quality of Earnings Assessment** Separate recurring from non-recurring EBITDA components. Calculate adjusted (recurring) EBITDA and assess whether underlying profitability is improving, stable, or declining when one-time items are stripped out. 4. **Forward Implications** Based on the bridge components, identify which drivers are expected to persist into the next period and which are likely to reverse. Provide a directional outlook statement for EBITDA in the next period. 5. **Visualization Description** Describe the waterfall chart that would visualize this bridge — listing each bar label, direction (up/down), and approximate height relative to the total bridge magnitude.
Prompt Variables
Replace each placeholder with your specific information:
[COMPANY NAME][INDUSTRY][CURRENCY][PRIOR PERIOD][CURRENT PERIOD][PRIOR EBITDA][CURRENT EBITDA][CHANGE][CHANGE %][BRIDGE COMPONENTS DATA]What You'll Get
A structured bridge table walking from prior to current EBITDA with each component labeled favorable/unfavorable; a three-paragraph board-level narrative; a quality of earnings analysis separating recurring from one-time items; a forward-looking EBITDA outlook statement; and a waterfall chart description for visualization.
💡 Pro Tip
Provide the volume and price/mix split of revenue separately if available — the AI will build a richer bridge that distinguishes between market-driven volume growth (a leading indicator) and pricing-driven margin (a management decision), which investors and lenders weigh very differently.
Compatible AI Tools
Best for the full narrative bridge including board-level commentary and quality of earnings assessment. Provide bridge components as a labeled list. Claude maintains coherence across all bridge sections.
Effective for the structured bridge table. Use Code Interpreter to input components as a CSV and let ChatGPT compute the running totals and favorable/unfavorable classification automatically.
Ideal when your P&L data is in Excel. Copilot can read actual vs. prior period line items and build the bridge table in-context, then generate the narrative commentary into an adjacent sheet.
Useful for Google Workspace teams with P&L data in Google Sheets. Gemini can read the financial data directly and generate the narrative bridge without manual data entry.
Run financial models and sensitivity analysis scripts directly from terminal with full calculation support
Build and iterate financial models in an AI-powered code editor with Python finance library support
Execute financial calculations and data analysis workflows from terminal with 1M token context for large datasets