Which approach correctly implements scenario analysis in a financial model?

• A. Define identical driver values for all scenarios and compare outputs.
• B. Recalculate only the income statement for each scenario.
• C. Use a single driver and assume others unchanged.
• D. Define distinct driver values for base, bear, and bull, recalc all statements, and compare results in a summary.

Answer: (D)

Scenario analysis looks at how different future conditions ripple through a model by varying key input drivers and tracing their impact across the entire set of financial statements. The best approach is to define distinct driver values for base, bear, and bull scenarios, recalculate all statements (income statement, balance sheet, and cash flow), and then summarize the results for comparison. This full recalculation is essential because changes in one driver affect many parts of the model everywhere—revenue shifts influence costs, working capital, assets, debt, equity, and cash flows. By comparing the complete outputs under each scenario, you can assess profitability, liquidity, and financing needs under different conditions.

Using identical driver values for all scenarios fails to show how outputs would differ under each case. Recalculating only the income statement ignores resulting changes on the balance sheet and cash flows, masking important interdependencies. Relying on a single driver with other inputs unchanged doesn't capture how alternative futures would unfold across the whole model.