Quick Answer
A what-if analysis is a technique that models the financial impact of changing specific assumptions or decisions in your plan. By asking "what if we increase prices by 10%?" or "what if we hire 20 more engineers?", you can see the cascading effect on revenue, costs, profit, and cash flow before committing to the decision. It turns your financial model into a decision-support tool rather than just a reporting exercise.
What-if analysis transforms your financial model from a static plan into an interactive decision tool. Instead of just reporting what you expect, you can explore what would happen under different choices.
Revenue decisions: What if we raise prices 15%? What if we launch in a new market? What if we acquire a competitor's customer base?
Cost decisions: What if we move office to reduce rent by 30%? What if we outsource customer support? What if we freeze hiring for 6 months?
Timing decisions: What if we delay the product launch by 3 months? What if we accelerate the hiring plan by a quarter? What if we renegotiate payment terms with our key supplier?
Strategic decisions: What if we pivot from services to product revenue? What if we enter the US market? What if we merge two departments?
1. Start with your base model. Your current forecast or budget serves as the baseline against which you measure the impact of changes.
2. Identify the variables to change. Be specific: which line items, which assumptions, and by how much?
3. Make the changes. Adjust the relevant assumptions in your model. With driver-based models, changing one assumption cascades through the entire P&L.
4. Compare results. Show the base case and what-if case side by side. Highlight the key differences in revenue, costs, profit, cash flow, and any relevant KPIs.
5. Assess feasibility and risk. The financial impact is only part of the picture. Consider operational feasibility, competitive response, and execution risk.
What-if analysis typically focuses on a single decision or change. Scenario planning models a comprehensive alternative future with multiple coordinated changes. What-if is surgical; scenario planning is holistic. Both are useful at different stages of decision-making.
The value of what-if analysis depends on how quickly you can explore options. In spreadsheets, each change requires manual updates and takes hours. With FP&A software like Grove FP, the formula engine recalculates the entire model in milliseconds, enabling real-time exploration during meetings.
Related Questions
Sensitivity analysis is a technique that tests how changes in individual input variables affect your financial model's o...
Scenario planning in FP&A is the practice of creating multiple versions of your financial plan based on different assump...
Model three to five scenarios for most planning purposes. The standard set is base case (most likely), upside (optimisti...
To model growth scenarios, identify the 5-7 key growth drivers for your business — new customer acquisition, expansion r...
Driver-based budgeting links financial outcomes to operational drivers — the measurable activities that generate revenue...
FAQ
What-if analysis models a specific proposed change (e.g., "what if we hire 10 more salespeople?"). Sensitivity analysis systematically varies an assumption across a range to see its impact. What-if is decision-focused; sensitivity is risk-focused.
Yes, but it is slow and error-prone. Excel's Goal Seek and Data Tables provide basic what-if functionality. For complex models, FP&A software is significantly faster and avoids the risk of accidentally overwriting your base model.
Show a clear before-and-after comparison: base case P&L vs what-if P&L, highlighting the key differences. Include the cash flow impact and any non-financial considerations. Keep the presentation focused on the decision at hand.
Save the significant ones as named scenarios in your model. This creates a record of options considered and provides a ready reference if you want to revisit the analysis later.
Yes. Grove FP's Rust-powered formula engine recalculates your entire model in under 50 milliseconds. Change any assumption and see the full P&L, cash flow, and KPI impact instantly — even during live meetings.
Grove FP gives UK finance teams a modern platform for budgeting, forecasting, and reporting — so you can focus on the decisions that matter.
Budgeting, forecasting, and workforce planning in one platform. No credit card required.