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
Claude
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.
ChatGPT
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.
Microsoft Copilot
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.
Gemini
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.