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

Construction: Retainage & Cash Flow

Manages the 'held back' portion of construction payments.

GPT-4oGemini 1.5 Pro

Management Accounting & FP&A

Intermediate

SaaS: Churn Analysis & Retention Bridge

Explains the walk from Opening ARR to Closing ARR.

GPT-4oClaude 3.5 Sonnet

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