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

Rolling forecast update: variance bridge to new forecast

Updates a rolling forecast by bridging from prior forecast to actuals and new assumptions. Produces a clear bridge and narrative for leadership.

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

Management Accounting & FP&A

Beginner

Budget kickoff pack: timeline, owners, templates, instructions

Generates a budget kickoff pack with roles, deadlines, template instructions, and FAQs. Useful for FP&A leaders coordinating cross-functional budgeting.

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

Management Accounting & FP&A

Advanced

Scenario planning: base/upside/downside with triggers

Builds a scenario framework with quantified assumptions, trigger points, and recommended actions. Useful for uncertain environments and board discussions.

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