Finance workstream / Planning Analytics
From monthly actuals to governed forecasts.
An illustrative Planning Analytics walkthrough for Phase 2 finance discovery and parallel validation. Hypothesis only; no live integration and no real Staghorn figures.
Actuals-to-forecast flow
01
Monthly actuals
Outsourced accounting delivers monthly Excel actuals (hypothesized format).
02
Ingest & map
Load into Planning Analytics cubes; map accounts and properties.
03
Excel interface (PAfE)
Finance keeps working in Excel, now connected to one governed model.
04
Forecast versions
Base / alternative versions stored centrally, not across workbooks.
05
Scenarios
Cash-flow and pricing scenarios; engineering assumptions possibly integrated.
Synthetic sample scenario controls
Forecast version
Monthly decline: 3%
Forecast revenue idx
496.9
Forecast cash-flow idx
298.1
Formula: forecast = last actual × (1 − decline)^n × (1 + price adj); cash flow = revenue × (1 − cost ratio).
Illustrative only. Actual file structures, planning dimensions and engineering-assumption integration to be confirmed in discovery.