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

Beginner

KPI tree: link strategy to drivers and metrics

Creates a KPI tree that connects strategic objectives to operational drivers and metrics with definitions. Useful for leadership alignment and dashboard design.

GPT-5.2 Thinking; GPT-4.1; o3-mini

Management Accounting & FP&A

Beginner

Monthly variance analysis: budget vs actual with bridges

Automates variance analysis with price/volume/mix and spending bridges where applicable. Produces exec-ready narratives and follow-up questions.

GPT-5.2 Thinking; GPT-4.1; o3-mini

Management Accounting & FP&A

Intermediate

Cost allocation model: shared services and drivers

Designs a cost allocation approach for shared services using clear drivers and documentation. Useful for management reporting and chargeback models.

GPT-5.2 Thinking; GPT-4.1; o3-mini