Module VI· Sensitivity & Scenario AnalysisBasic
Question
What is a 1D versus 2D data table in Excel?
Answer
A 1D data table flexes one input and shows the impact on one or more outputs. A 2D data table flexes two inputs, one across rows and one across columns, and shows one output. In valuation, 2D tables are common for WACC versus terminal growth or exit multiple versus EBITDA growth.