What-if analysis: change one thing, follow the effects
What-if analysis compares one specific change with the starting assumptions. The new answer matters, and so does the chain of effects that produces it and when each effect arrives.
What changes if hiring starts later?
This is a playable answer made in flatland desk. Move its measured settings to explore the result. The assumptions are fictional.
Goal · 2027-01 through 2027-12
Year-end cash reaches at least $230,000 and cash stays at or above $0
Starting result
$225,000
On a narrow screen, scroll the answer sideways to see its full width. Use Tab to reach its settings and the arrow keys to change them.
Open the answer in its own tab · Download the model for desk
These results were measured when the answer was made. The page does not run new simulations. To change formulas or ranges, open the model in desk.
Follow the effects period by period
In the hiring example, Months before hiring is a lever: zero means January, and three means April. A new hire costs money from the month they join and reaches full capacity over three months, so the cost arrives before the added capacity can pay for it.
Move that lever in the playable answer and compare year-end cash and the goal’s odds with the starting setting. Then read the cash path month by month in the example’s period table. A change can look the same at year end and still leave less room in the months between.
What-if analysis in Excel
Excel’s What-If Analysis menu has three tools. Scenario Manager stores named sets of input values and swaps them in. Goal Seek finds the one input value that produces a target result. Data Tables show a formula’s result across a list of input values.
Each of them returns the changed number. None shows how the change travels through the workbook, or in which period each effect lands. A model with visible structure and periods adds that: in flatland desk, Section shows what feeds each result, and Trace shows how it moves across periods.
What-if, scenario, sensitivity, or Monte Carlo
Four methods answer four questions. What-if analysis: what happens if this one thing changes? Scenario analysis: what happens under this named set of assumptions? Sensitivity analysis: which assumptions move the answer most? Monte Carlo simulation: across the ranges, how often is the goal reached?
A what-if shows one alternative, not its odds. This example’s assumptions and ranges are fictional. It teaches the method; it does not recommend when to hire.
Build your own model
flatland desk by Flatland Labs makes a quantitative model’s structure, behavior over time and possible futures visible.
Downloading and local use need no account. A plan includes the built-in agent and the handoff.
Why flatland exists, and where it’s going: Escape.