Simulated data · an independent leadership prototype← davidwilliscreative.com

.david willis
Business

Profitability, forecast and pricing

This is the unit's contribution: net revenue minus direct labor, freelance and tools. Group overhead isn't allocated, so it's a management view, not accounting profit.

Net revenue, YTDERP
$6.34M
Plan $6.31M · +0.5%
FY26 forecastFP&A
$8.63M
Plan $8.55M · +$80k
Department contribution margin, FY
40.8%
$3.52M · department target 42%
Q4 freelance
$200k
Budget $180k · $20k over

Margin exceptions

Accounts under their own account target, ranked by the contribution the gap costs a year

Other financial signals

What else moves the FY number

  • YTD revenue ahead of plan by $30kFY forecast $8.63M against a $8.55M plan
  • Q4 freelance $20k over budgetForecast $200k against $180k. Mostly holiday motion work.
  • 1 invoice over 60 days ($96k)Receivables detail is further down this page
  • FY margin 40.8% against 42%Closing the top exception gets the unit $212k of the way

Net revenue by month

Solid bars are closed months, pale bars are forecast, and the dashed line is plan.

ActualForecastPlan
$0k$250k$500k$750k$1000kJan: $640kJanFeb: $655kFebMar: $690kMarApr: $702kAprMay: $718kMayJun: $735kJunJul: $698kJulAug: $742kAugSep: $760kSepOct: $772k (forecast)OctNov: $806k (forecast)NovDec: $712k (forecast)Dec

Margin by account

FY26 account contribution margin; the mark is each account’s own target

Receivables

Open invoices on Performance Creative accounts

InvoiceAccountAmountDays
PC-2291Kinfolk Pet$96k74Over 60 days
PC-2340Fernway Foods$54k38Past due
PC-2352Pulse Games$121k12Current
PC-2361Lumora Beauty$118k9Current

Monthly P&L

$k · Oct–Dec are forecast

JanFebMarAprMayJunJulAugSepOctNovDecFY
Net revenue6406556907027187356987427607728067128630
Plan6506606807007107207107307507607807008550
Direct labor3403423453483503523553583603623653654242
Freelance383542404452485561728840615
Tools & AI181819192021212222232323249
Contribution2442602842953043102743073173153302843524
Margin38%40%41%42%42%42%39%41%42%41%41%40%41%