That’s because multiple versions— which good rolling forecasts need to create different scenarios—are extremely difficult to update and manage with spreadsheets. They’re prone to errors, with broken links and formulas, so finance spends more time stemming tiny leaks than stemming the tide.
Another problem is that spreadsheets are scattered like islands across marketing, sales, finance and other departments. They may all use different assumptions, standards, and even software, making it difficult to aggregate, combine and consolidate forecasts.
By automating rolling forecasts with Adaptive Insights you can easily and frequently roll up and integrate actuals from any system. You will be able to quickly create multiple versions that allow you to analyze performance and different what-if scenarios. Because Adaptive Insights is a cloud-based system you can take action quickly, from anywhere. Forecast accuracy will improve, and you’ll be able to batten the hatches faster in the face of performance storm warnings. You are able to model “what-if” scenarios in a way that disparate spreadsheets, linked together with formulas, just can’t. You can change a few key assumptions and drivers and instantly see their effect on the overall plan, such as the impact a price change has on headcounts and cash.