MODELING EXAM |ACTUAL QS&AS
FROM WALL STREET PREP|A+GRADE
ASSURED
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) To estimate future financial performance and support
valuation
2. In a three-statement financial model, which statement is
typically completed first?
A) Balance Sheet
B) Income Statement
C) Cash Flow Statement
,D) Statement of Retained Earnings
Answer: B) Income Statement
3. Why do you never want to re-enter the same input more than
once in your model?
A) It increases file size
B) You want your model to be dynamic and error-free
C) It slows down Excel calculations
D) It makes the model harder to read
, Answer: B) You want your model to be dynamic and error-free
4. 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.05
D) A cell containing 1000