Module VI· Sensitivity & Scenario AnalysisIntermediate
Question

How do you build a 2D data table for DCF sensitivity?

Answer

Link the top-left cell of the table to the valuation output, such as share price. Put one input range across the top, such as WACC, and another down the side, such as terminal growth. Use Data Table with row input and column input cells linked to the model assumptions. Format and check the center case against the model output.