Long-range planning is one of the most important exercises a finance team runs, but it is also one of the hardest to scale.
At Snowflake, we needed to forecast out 10 years across a business that had become much more complex: more than 40 entities, each with more than 100 cost centers and hundreds of spend categories underneath that. We needed that level of detail because the long-range plan was not just a finance artifact. It had become a data set that other teams depended on.
Tax, for example, does not just need a high-level expense forecast. They may need to understand the split between goods and services, legal entities, jurisdictions, and other operating details that matter for planning. Treasury needs a view into cash. Workforce planning needs headcount assumptions. Executives need to understand the strategic tradeoffs across growth, margin, investment and free cash flow.
The planning model had to support all of that.
So, like many companies, we did what finance teams often do when the business outgrows the tooling: We built a gigantic Excel model.
