Navigating the economic implications of COVID-19 ›

OnPlan scenario planning and what-if analysis capabilities enable CFOs to make data-driven decisions to screen for emerging opportunities and threats.

The Need

Today’s rapidly-evolving business environment places scenario planning front and center for organizations of all sizes and across all industries. The need for finance teams to produce rapid analysis, actionable insights and strategic roadmaps has never been greater.

OnPlan enables FP&A and executive teams with a flexible scenario planning platform to model what-if scenarios to make optimal decisions and take advantage of emerging opportunities and mitigate potential threats.

OnPlan’s Capabilities for Scenario Planning

OnPlan is a powerful platform that automates data integrations and equips FP&A teams with the tools necessary to produce scenario planning and what-if analysis.

What-if Analysis Scenario Forecasting: Responding to a slow down in sales

 

OnPlan is the fastest time-to-value scenario forecasting platform available. We get you up and running within 2-3 weeks at a fraction of the cost of other platforms. With OnPlan you build scenarios on the fly to screen emerging opportunities and threats in real time.  By creating multiple concurrent scenarios, you can easily test the impact of alternative assumptions and evaluate the financial impact of diverging tactical decisions and overall strategies. 

Driver-based forecasting:

OnPlan was built from the ground-up as a driver-based modeling platform.  OnPlan integrates with your key financial and operational data sources – from pipeline and stage to price and volume to ensure that you are setup to run scenario modeling on day-one.  With this ability to pull data easily you save time and decrease the gap between the time you made your assumptions and the seeing the actual performance in the market.

Building and Running Scenarios

Dynamic market conditions puts a further emphasis on scenario forecasting.  With OnPlan you can rapidly model baseline, best-case and worst-case scenarios. The foundation for this is established by allowing you to track your leading indicators (e.g. pipeline, conversion rates, churn) so that you are able to anticipate scenarios to create.

Multi Scenario charting

In Excel, it is very difficult to bring data together from multiple workbooks into a single chart.  In OnPlan this is a native capability.  You can easily chart your cash in base, high and low cases in the same charts.

Revert Changes

OnPlan uses Google Sheets as its calculation engine.  Because of this, everyone formula and input change that a user enters in OnPlan can be traced back and reverted to.

Compare Scenario View

OnPlan features a sheet comparison view that allows you to compare sheets against each other in any scenario.  You can see which inputs and outputs are the same and which are different in each scenario.

Scenario Planning Templates

Generally scenarios differ from each other with respect to 1) top line sales or demand variables, 2)  workforce assumptions whether headcount, hiring or capacity utilization, 3) operating expenses and discretionary expenses and finally 4) financing or funding conditions.  OnPlan has a suite of best-practice templates to allow you to model each of these critical scenario drivers.

In Summary

The reason, of course, is that scenario planning gives teams visibility into future scenarios and foreseeable outcomes.  Now more than ever forecasting teams are deploying modern finance software to integrate with their core data systems to allow them to forecast off of their operational and financial data sets.

The backbone of the modern FP&A process is the ability to forecast multiple scenarios that reflect both opportunities and threats.

Scenario planning is front and center for many FP&A teams these days.  Scenario planning traditionally has been done in conjunction with the annual budget planning. But increasingly, this is being incorporated into the monthly roll forward.