Intermediate

Driver-based budget model template (revenue, headcount, opex)

Creates a driver-based budgeting framework and templates that link revenue drivers, headcount, and operating expenses. Useful for FP&A teams building a scalable budget process.

Build a driver-based budget model for {company_name} for FY {fiscal_year}.

Inputs:
- Revenue drivers by segment: {revenue_drivers}
- Headcount plan by department: {headcount_plan}
- Compensation assumptions: {comp_assumptions}
- Opex drivers (rent, cloud, marketing, etc.): {opex_drivers}
- Historical actuals (optional): {historical_actuals}
- Output granularity: {granularity} (monthly/quarterly)

Deliver:
1) Model structure (tabs/sections) and key formulas.
2) Budget templates by department with input cells vs calculated cells.
3) Consolidated P&L budget output table.
4) Assumptions register and change log format.
5) Validation checks (ties, reasonableness, version control).

Write it so it can be implemented in Excel/Sheets.

Related Prompts

Management Accounting & FP&A

Intermediate

Inventory Valuation: LIFO vs FIFO Impact

Analyzes the effect of inventory cost flow assumptions on COGS and taxes.

GPT-4oGemini 1.5 Pro

172

Management Accounting & FP&A

Advanced

Allocating Shared Service Costs (Corporate Overhead)

Determines how to charge back HR, IT, and Finance costs to operating business units.

Claude 3.5 Sonnet

169

Management Accounting & FP&A

Intermediate

Margin Bridge (EBITDA Bridge) Narrative

Explains the 'walk' from last year's EBITDA to this year's EBITDA.

GPT-4oClaude 3.5 Sonnet

160