Wall Street Prep Exam Files – PACKAGE DEAL –
Complete Financial Modeling Exam Set –
Questions and Correct Answers – 2025/2026
Edition
Section 1: General Financial Modeling Principles (Q1–Q20)
1. What is the primary purpose of financial statement modeling?
A. To predict future stock prices
B. To analyze a company's historical financial performance only
C. To estimate future financial performance and support valuation
D. To comply with SEC reporting regulations
Answer: C
Rationale: The primary purpose of financial statement modeling is to
estimate a company's future financial performance and support
valuation decisions. While analyzing historical performance is part of
the process, the end goal is projecting forward for valuation, M&A
analysis, or financing decisions.
2. In a three-statement financial model, which statement is typically
completed first?
A. Balance Sheet
B. Income Statement
C. Cash Flow Statement
D. All statements are completed simultaneously
Answer: B
Rationale: The Income Statement is typically completed first because it
provides Net Income, which serves as the starting point for the Cash
Flow Statement and flows into Retained Earnings on the Balance Sheet.
,3. Which color text should be used for hard-coded inputs
(assumptions, historical data) in a professional financial model?
A. Black
B. Blue
C. Green
D. Red
Answer: B
Rationale: Industry best practices dictate that hard-coded inputs and
assumptions should be formatted in blue text. Formulas are typically in
black, links to other worksheets in green, and links to external files in
red.
4. Is it best practice to merge cells in a financial model?
A. Yes, it improves formatting and readability
B. Yes, but only for header rows
C. No, using "Center Across Selection" is preferred
D. Only for final presentation-ready models
Answer: C
Rationale: Merged cells interfere with navigation and cell selection.
"Center Across Selection" achieves the same visual effect without
disrupting the underlying grid structure.
5. What does the keyboard shortcut "Alt + =" do in Excel?
A. Opens the formatting menu
B. Inserts the SUM function automatically
C. Creates a new chart
D. Saves the file
Answer: B
Rationale: Alt + = is the keyboard shortcut for the SUM function in
,Excel. It automatically inputs the sum formula and intelligently selects
the adjacent range of numbers.
6. Which of the following are considered hard-coded inputs in a
financial model? (Select all that apply)
A. Historical revenue figures
B. Assumed revenue growth rate
C. A cell containing =B5*1.07
D. A cell containing 1000
Answer: A, B, D
Rationale: Hard-coded inputs are values entered directly into cells (not
calculated by formulas). Historical data, assumed growth rates, and
constant values like 1000 are hard-coded.
7. What is a financial model?
A. A company's annual report
B. A forecast of a company's financial statements
C. A company's tax return
D. An auditor's opinion letter
Answer: B
Rationale: A financial model is fundamentally a forecast of a company's
financial statements that projects future performance based on
assumptions, historical data, and business drivers.
8. Which Excel function is most appropriate for performing a vertical
lookup when the lookup value is in the LEFT column?
A. HLOOKUP
B. INDEX/MATCH
C. VLOOKUP
D. OFFSET
, Answer: C
Rationale: VLOOKUP is specifically designed for vertical lookups where
the lookup value is in the leftmost column of the table array and the
return value is in a column to the right.
9. In a three-statement model, what is the correct order of statement
construction?
A. Balance Sheet → Income Statement → Cash Flow Statement
B. Income Statement → Cash Flow Statement → Balance Sheet
C. Cash Flow Statement → Income Statement → Balance Sheet
D. Balance Sheet → Cash Flow Statement → Income Statement
Answer: B
Rationale: The correct model flow is Income Statement first, then Cash
Flow Statement (starting with net income), then Balance Sheet (using
ending cash from the CFS).
10. What is the primary issue with using merged cells in a financial
model?
A. They slow down calculations
B. They interfere with navigation and cell selection
C. They cause circular references
D. They are not compatible with Excel formulas
Answer: B
Rationale: Merged cells interfere with navigation (e.g., Ctrl+Arrow keys,
copy-pasting) and make the model less functional and auditable.
11. What color font is used for formulas in a professional financial
model?
A. Blue
B. Green
Complete Financial Modeling Exam Set –
Questions and Correct Answers – 2025/2026
Edition
Section 1: General Financial Modeling Principles (Q1–Q20)
1. What is the primary purpose of financial statement modeling?
A. To predict future stock prices
B. To analyze a company's historical financial performance only
C. To estimate future financial performance and support valuation
D. To comply with SEC reporting regulations
Answer: C
Rationale: The primary purpose of financial statement modeling is to
estimate a company's future financial performance and support
valuation decisions. While analyzing historical performance is part of
the process, the end goal is projecting forward for valuation, M&A
analysis, or financing decisions.
2. In a three-statement financial model, which statement is typically
completed first?
A. Balance Sheet
B. Income Statement
C. Cash Flow Statement
D. All statements are completed simultaneously
Answer: B
Rationale: The Income Statement is typically completed first because it
provides Net Income, which serves as the starting point for the Cash
Flow Statement and flows into Retained Earnings on the Balance Sheet.
,3. Which color text should be used for hard-coded inputs
(assumptions, historical data) in a professional financial model?
A. Black
B. Blue
C. Green
D. Red
Answer: B
Rationale: Industry best practices dictate that hard-coded inputs and
assumptions should be formatted in blue text. Formulas are typically in
black, links to other worksheets in green, and links to external files in
red.
4. Is it best practice to merge cells in a financial model?
A. Yes, it improves formatting and readability
B. Yes, but only for header rows
C. No, using "Center Across Selection" is preferred
D. Only for final presentation-ready models
Answer: C
Rationale: Merged cells interfere with navigation and cell selection.
"Center Across Selection" achieves the same visual effect without
disrupting the underlying grid structure.
5. What does the keyboard shortcut "Alt + =" do in Excel?
A. Opens the formatting menu
B. Inserts the SUM function automatically
C. Creates a new chart
D. Saves the file
Answer: B
Rationale: Alt + = is the keyboard shortcut for the SUM function in
,Excel. It automatically inputs the sum formula and intelligently selects
the adjacent range of numbers.
6. Which of the following are considered hard-coded inputs in a
financial model? (Select all that apply)
A. Historical revenue figures
B. Assumed revenue growth rate
C. A cell containing =B5*1.07
D. A cell containing 1000
Answer: A, B, D
Rationale: Hard-coded inputs are values entered directly into cells (not
calculated by formulas). Historical data, assumed growth rates, and
constant values like 1000 are hard-coded.
7. What is a financial model?
A. A company's annual report
B. A forecast of a company's financial statements
C. A company's tax return
D. An auditor's opinion letter
Answer: B
Rationale: A financial model is fundamentally a forecast of a company's
financial statements that projects future performance based on
assumptions, historical data, and business drivers.
8. Which Excel function is most appropriate for performing a vertical
lookup when the lookup value is in the LEFT column?
A. HLOOKUP
B. INDEX/MATCH
C. VLOOKUP
D. OFFSET
, Answer: C
Rationale: VLOOKUP is specifically designed for vertical lookups where
the lookup value is in the leftmost column of the table array and the
return value is in a column to the right.
9. In a three-statement model, what is the correct order of statement
construction?
A. Balance Sheet → Income Statement → Cash Flow Statement
B. Income Statement → Cash Flow Statement → Balance Sheet
C. Cash Flow Statement → Income Statement → Balance Sheet
D. Balance Sheet → Cash Flow Statement → Income Statement
Answer: B
Rationale: The correct model flow is Income Statement first, then Cash
Flow Statement (starting with net income), then Balance Sheet (using
ending cash from the CFS).
10. What is the primary issue with using merged cells in a financial
model?
A. They slow down calculations
B. They interfere with navigation and cell selection
C. They cause circular references
D. They are not compatible with Excel formulas
Answer: B
Rationale: Merged cells interfere with navigation (e.g., Ctrl+Arrow keys,
copy-pasting) and make the model less functional and auditable.
11. What color font is used for formulas in a professional financial
model?
A. Blue
B. Green
