Driver-Based 12-Month P&L Forecast Ranked by EBITDA Impact
Asked Jun 23, 2026Modified yesterdayViewed 4 timesWorks with: Claude 3.7 Sonnet, Claude 3.5 Sonnet
0
What this prompt does
Breaks down historical actuals into core business drivers and projects a full 12-month P&L in Excel, ranking each lever by its EBITDA contribution.
- Compatible models:
- Claude 3.7 Sonnet, Claude 3.5 Sonnet
- Category:
- Business
Breaks down historical actuals into core business drivers and projects a full 12-month P&L in Excel, ranking each lever by its EBITDA contribution. Use it when you need a clear, assumption-to-bottom-line forecast that shows exactly where to focus for maximum margin improvement.
I want to go from backward-looking analysis to forward-looking planning. Using the same data, build me a lever-based financial model: 1. Decompose each major revenue and cost line into its underlying driver (e.g., Subscription Revenue = Customers × ARPU; AWS Hosting = Customers × cost per customer; Engineering Salaries = Headcount × average CTC). 2. Create an Assumptions sheet with all the levers — derive each from the [MONTH] actuals and show your working. 3. Build a 12-month projected P&L where every line is driven by the levers. Include Revenue, COGS, Gross Profit, OpEx by department, EBITDA, and PBT with margins. 4. Tell me: which 3 levers have the highest impact on EBITDA? Output this as an Excel file I can use going forward.
Source: https://ai.elevationcapital.com/blogs/claude-cowork-for-finance
Prompt Curator
120rep · asked Jun 23, 2026
0 Responses
Want to respond? Log in.