SENSITIVITY ANALYSIS DCF EXCEL TEST - (90 QUESTIONS) UP-TO-DATE ACTUAL EXAM
QUESTIONS AND 100% ACCURATE SOLUTIONS | VERIFIED ANSWERS - INSTANT PDF
DOWNLOAD
Candidate Name: ____________________________
Candidate ID: ________________________________
Date: ______________________________________
Examination Centre: __________________________
Time Allowed: 120 Minutes
Total Questions: 90 (This section contains Questions 1–30)
Instructions to Candidates:
Read all questions carefully before answering. Each question is designed to assess your
ability to apply Discounted Cash Flow (DCF) modeling concepts and perform sensitivity
analysis using Excel. You are expected to demonstrate a strong understanding of
financial modeling, valuation assumptions, and Excel-based scenario testing. Choose the
,most appropriate answer for each question. Calculators and spreadsheet tools are
assumed to be available. There is no negative marking unless otherwise stated.
Disclaimer:
This examination is an original simulation inspired by the format and rigor of professional
financial modeling and valuation assessments. It is intended for educational and practice
purposes only.
Core Competency Areas Assessed:
Discounted Cash Flow (DCF) Modeling
Excel Sensitivity Analysis (Data Tables, Scenario Manager)
Financial Forecasting and Assumptions
Cost of Capital and Discount Rates
Terminal Value Calculation Methods
Risk Analysis and Scenario Interpretation
,This assessment evaluates your ability to build, interpret, and stress-test valuation
models under varying assumptions. Candidates are expected to apply both conceptual
understanding and technical Excel skills to real-world financial scenarios. Mastery of
these competencies is essential for roles in investment banking, corporate finance, and
equity research.
QUESTIONS
Q1. A financial analyst builds a DCF model where revenue growth and WACC are the two
key drivers. Which Excel tool is most efficient for simultaneously analyzing the impact of
both variables on enterprise value?
A. Goal Seek
B. One-variable Data Table
C. Two-variable Data Table
D. Scenario Manager
Correct Answer: 🔴 C. Two-variable Data Table
Explanation: 🟡 A two-variable data table allows simultaneous sensitivity testing of two
inputs (e.g., revenue growth and WACC) against a single output like enterprise value. Goal
, Seek is used for solving a single unknown input, one-variable tables test only one input, and
Scenario Manager is less efficient for continuous variable ranges.
Q2. In a DCF model, increasing the discount rate while holding all else constant will:
A. Increase enterprise value
B. Decrease enterprise value
C. Have no effect
D. Only affect terminal value
Correct Answer: 🔴 B. Decrease enterprise value
Explanation: 🟡 A higher discount rate reduces the present value of future cash flows,
lowering enterprise value. Option A is incorrect as value moves inversely. Option C ignores
time value of money. Option D is incorrect because all discounted cash flows—not just
terminal value—are affected.
Q3. Which of the following is most appropriate for testing downside risk in a DCF model?
A. Increasing revenue growth assumptions
B. Lowering WACC
C. Reducing EBITDA margins
D. Increasing terminal growth rate
QUESTIONS AND 100% ACCURATE SOLUTIONS | VERIFIED ANSWERS - INSTANT PDF
DOWNLOAD
Candidate Name: ____________________________
Candidate ID: ________________________________
Date: ______________________________________
Examination Centre: __________________________
Time Allowed: 120 Minutes
Total Questions: 90 (This section contains Questions 1–30)
Instructions to Candidates:
Read all questions carefully before answering. Each question is designed to assess your
ability to apply Discounted Cash Flow (DCF) modeling concepts and perform sensitivity
analysis using Excel. You are expected to demonstrate a strong understanding of
financial modeling, valuation assumptions, and Excel-based scenario testing. Choose the
,most appropriate answer for each question. Calculators and spreadsheet tools are
assumed to be available. There is no negative marking unless otherwise stated.
Disclaimer:
This examination is an original simulation inspired by the format and rigor of professional
financial modeling and valuation assessments. It is intended for educational and practice
purposes only.
Core Competency Areas Assessed:
Discounted Cash Flow (DCF) Modeling
Excel Sensitivity Analysis (Data Tables, Scenario Manager)
Financial Forecasting and Assumptions
Cost of Capital and Discount Rates
Terminal Value Calculation Methods
Risk Analysis and Scenario Interpretation
,This assessment evaluates your ability to build, interpret, and stress-test valuation
models under varying assumptions. Candidates are expected to apply both conceptual
understanding and technical Excel skills to real-world financial scenarios. Mastery of
these competencies is essential for roles in investment banking, corporate finance, and
equity research.
QUESTIONS
Q1. A financial analyst builds a DCF model where revenue growth and WACC are the two
key drivers. Which Excel tool is most efficient for simultaneously analyzing the impact of
both variables on enterprise value?
A. Goal Seek
B. One-variable Data Table
C. Two-variable Data Table
D. Scenario Manager
Correct Answer: 🔴 C. Two-variable Data Table
Explanation: 🟡 A two-variable data table allows simultaneous sensitivity testing of two
inputs (e.g., revenue growth and WACC) against a single output like enterprise value. Goal
, Seek is used for solving a single unknown input, one-variable tables test only one input, and
Scenario Manager is less efficient for continuous variable ranges.
Q2. In a DCF model, increasing the discount rate while holding all else constant will:
A. Increase enterprise value
B. Decrease enterprise value
C. Have no effect
D. Only affect terminal value
Correct Answer: 🔴 B. Decrease enterprise value
Explanation: 🟡 A higher discount rate reduces the present value of future cash flows,
lowering enterprise value. Option A is incorrect as value moves inversely. Option C ignores
time value of money. Option D is incorrect because all discounted cash flows—not just
terminal value—are affected.
Q3. Which of the following is most appropriate for testing downside risk in a DCF model?
A. Increasing revenue growth assumptions
B. Lowering WACC
C. Reducing EBITDA margins
D. Increasing terminal growth rate
