Learn
A guide to FP&A planning and modeling.
Planning and modeling is how finance builds the forward view of the business: the revenue it expects, the people it will hire, what it will spend, and how much cash it will have.
The work includes the annual budget, rolling forecasts, driver-based models, and scenarios that test what happens if assumptions change.
Revenue
Revenue planning
Bookings, renewals, expansion, and churn tied to the P&L.
People
Headcount planning
Hires, start dates, and compensation tied to budget.
Spend
Expense planning
Vendor commitments and department spend against plan.
Cash
Cash flow forecasting
Weekly and monthly cash in and out, and runway.
Why planning and modeling matters
Plans set targets, guide hiring and spend, and tell leadership how much room the business has. A plan built on stale data or disconnected spreadsheets breaks the moment conditions change. Plans tied to live actuals and shared drivers can be updated as fast as the business moves.
How to run planning and modeling in Cube
A typical planning cycle in Cube follows these steps.
-
1.
Start from actuals. Sync current results from your systems so every plan starts from real numbers.
-
2.
Set the drivers. Define the inputs that move the plan, such as pipeline, hires, and price.
-
3.
Collect owner input. Department owners update their plans in Excel, Sheets, or Cube Web.
-
4.
Run scenarios. Change assumptions and compare upside, base, and downside before you commit.
-
5.
Approve and publish. Review changes, approve, and share the plan across decks, dashboards, and chat.
Key planning and modeling terms
- Driver-based plan
- A plan built from the operational inputs that move results.
- Rolling forecast
- A forecast that always extends a set number of periods ahead.
- Scenario
- A version of the plan built on a different set of assumptions.
- Reforecast
- An update to the forecast based on new actuals or assumptions.
- Runway
- How long current cash lasts at the expected burn rate.
- Fully loaded cost
- Salary plus benefits, taxes, and other costs of an employee.
Static budgets vs. continuous planning in Cube
|
Static annual budget |
Continuous planning in Cube |
| Cadence |
Once a year |
Reforecast whenever actuals or assumptions change |
| Inputs |
Spreadsheets emailed between owners |
Owners update in their own tools, with permissions |
| Scenarios |
Separate files for each version |
Compare scenarios on one model |
| Link to actuals |
Manual updates |
Actuals sync from source systems |
| Approvals |
Tracked over email |
Workflows with review and sign-off |