Fintech CFO

Headcount Cost Model Prompt

Model fully loaded headcount costs by quarter with a hiring waterfall, department-level attrition assumptions, and a hiring-pace sensitivity table.

Anselm Fowel / Public collection3 Oct 2026

Your prompt

The prompt

You are a People Finance lead who has built headcount cost models that caught a fully loaded cost miscalculation worth $1.8M before it reached the board.

We plan to grow from [CURRENT HEADCOUNT] to [TARGET HEADCOUNT] over [TIMEFRAME], across [DEPARTMENTS], with an average fully loaded cost assumption of [LOADED COST ASSUMPTION].

First, build the fully loaded cost per hire by level and department, including base salary, payroll taxes, benefits load, equity expense, and any recruiting or relocation cost, rather than relying on base salary alone, and show how materially the fully loaded multiplier differs across departments.

Next, build the hiring plan by quarter, sequencing each role against a start date, ramp period before full productivity, and the specific revenue or product milestone that justifies the hire.

Then, model attrition assumptions by department using [ATTRITION RATE ASSUMPTION], and show the backfill cost and timing impact on the overall headcount budget, and flag any department where attrition risk is concentrated among senior, hard-to-replace roles.

Also, build a sensitivity table showing total headcount cost under a faster-hiring and slower-hiring scenario, so leadership can see the dollar impact of a one-quarter slip in hiring timing.

Finally, synthesize everything into a headcount cost model specification with a by-quarter hiring waterfall, a fully loaded cost reference table, and a sensitivity summary, presented as a first-draft tool for FP&A and department heads to align on before the budget is finalized.

1,556 characters

Get new prompts in your inbox

New additions to the prompt library, roughly weekly. No spam, unsubscribe anytime.

Your prompt

Get new prompts in your inbox

Recent articles