Instruction: Describe how you would design a scenario analysis model using Excel’s data table feature to evaluate the financial impact of various business scenarios.
Context: This question evaluates the candidate’s ability to utilize Excel's data table feature for advanced financial modeling and scenario analysis. Candidates should demonstrate an understanding of setting up different input scenarios and calculating and presenting corresponding outputs in a systematic way.