1
Wall Street Prep Financial Statement
Modeling Retake Exam Questions and
Answers with Rationales 2025/2026 |
WSP Modeling Certification | Pass
Guarantee
PART I: MULTIPLE CHOICE QUESTIONS (30 Questions)
Section A: Three-Statement Integration & Circular References (8 Questions)
1. Which of the following best describes the primary circular reference in a three-
statement model?
A. Net income → Retained earnings → Cash → Interest income → Net income
B. Debt balance → Interest expense → Net income → Cash → Debt repayment →
Debt balance
C. Revenue → Accounts receivable → Cash → Inventory → Revenue
D. PP&E → Depreciation → Net income → Cash → CapEx → PP&E
Answer: B
Rationale: The primary circular reference occurs when interest expense affects net
income, which affects cash flow, which affects debt repayment, which affects the
debt balance, which affects interest expense. This creates the classic circularity that
requires iterative calculations or circularity breakers.
2. When modeling interest expense using average debt balances, the circular
reference can be broken by:
A. Using ending debt balances only
B. Using beginning debt balances only
C. Creating a circularity breaker switch
D. All of the above
, 2
Answer: D
Rationale: All methods can resolve circularity. Using beginning or ending
balances eliminates the circular reference, while a circularity breaker switch
(ON/OFF) temporarily sets interest to zero during model debugging.
3. In a properly integrated three-statement model, which equation should always
hold true?
A. Assets = Liabilities + Equity
B. Net Income = Cash Flow from Operations
C. Total Debt = Cash + Retained Earnings
D. Revenue = COGS + Operating Expenses
Answer: A
Rationale: The fundamental accounting equation (Assets = Liabilities + Equity)
must always balance. This is the primary error check in financial models.
4. The most appropriate method for handling circular references in a presentation
model is:
A. Enable iterative calculations with 100 iterations
B. Use beginning debt balances for interest calculations
C. Create a complex circularity breaker formula
D. Use average debt balances with iterative calculations
Answer: B
Rationale: For presentation models, simplicity and stability are paramount. Using
beginning debt balances eliminates circularity while maintaining acceptable
accuracy for most analyses.
5. Which of the following would NOT create a circular reference in a financial
model?
A. Interest income calculated on average cash balances
B. Cash sweep provisions tied to excess cash flow
C. Depreciation expense calculated as % of revenue
D. Minimum cash balance requirements affecting debt repayment
Answer: C
Rationale: Depreciation as % of revenue flows from revenue → PP&E →
Depreciation → Net income, but doesn't create a circular reference since it doesn't
feed back to affect the original revenue input.
, 3
6. The "circularity breaker" switch in Excel models should be set to "ON" when:
A. Finalizing the model for distribution
B. Debugging errors and circular references
C. Running sensitivity analysis
D. Presenting results to clients
Answer: B
Rationale: The circularity breaker (setting interest to zero) helps identify and
resolve model errors by breaking calculation loops during debugging.
7. In modeling best practice, circular references should be:
A. Avoided entirely through formula design
B. Embraced as they increase accuracy
C. Handled with clear documentation and error checks
D. Only used in complex LBO models
Answer: C
Rationale: While circular references can increase accuracy, they must be handled
carefully with proper documentation, error checks, and user controls to maintain
model stability.
8. The primary risk of using iterative calculations in Excel is:
A. Reduced model accuracy
B. Model instability and potential crashes
C. Increased file size
D. Slower calculation only during startup
Answer: B
Rationale: Iterative calculations can cause model instability, infinite loops, or
crashes, especially in complex models or when errors are present.
Section B: Revenue & Expense Forecasting (7 Questions)
9. Which revenue forecasting method is most appropriate for a mature company
with stable historical growth?
A. Bottom-up unit analysis
B. Straight-line growth rate
C. Regression analysis
D. Market share analysis
Wall Street Prep Financial Statement
Modeling Retake Exam Questions and
Answers with Rationales 2025/2026 |
WSP Modeling Certification | Pass
Guarantee
PART I: MULTIPLE CHOICE QUESTIONS (30 Questions)
Section A: Three-Statement Integration & Circular References (8 Questions)
1. Which of the following best describes the primary circular reference in a three-
statement model?
A. Net income → Retained earnings → Cash → Interest income → Net income
B. Debt balance → Interest expense → Net income → Cash → Debt repayment →
Debt balance
C. Revenue → Accounts receivable → Cash → Inventory → Revenue
D. PP&E → Depreciation → Net income → Cash → CapEx → PP&E
Answer: B
Rationale: The primary circular reference occurs when interest expense affects net
income, which affects cash flow, which affects debt repayment, which affects the
debt balance, which affects interest expense. This creates the classic circularity that
requires iterative calculations or circularity breakers.
2. When modeling interest expense using average debt balances, the circular
reference can be broken by:
A. Using ending debt balances only
B. Using beginning debt balances only
C. Creating a circularity breaker switch
D. All of the above
, 2
Answer: D
Rationale: All methods can resolve circularity. Using beginning or ending
balances eliminates the circular reference, while a circularity breaker switch
(ON/OFF) temporarily sets interest to zero during model debugging.
3. In a properly integrated three-statement model, which equation should always
hold true?
A. Assets = Liabilities + Equity
B. Net Income = Cash Flow from Operations
C. Total Debt = Cash + Retained Earnings
D. Revenue = COGS + Operating Expenses
Answer: A
Rationale: The fundamental accounting equation (Assets = Liabilities + Equity)
must always balance. This is the primary error check in financial models.
4. The most appropriate method for handling circular references in a presentation
model is:
A. Enable iterative calculations with 100 iterations
B. Use beginning debt balances for interest calculations
C. Create a complex circularity breaker formula
D. Use average debt balances with iterative calculations
Answer: B
Rationale: For presentation models, simplicity and stability are paramount. Using
beginning debt balances eliminates circularity while maintaining acceptable
accuracy for most analyses.
5. Which of the following would NOT create a circular reference in a financial
model?
A. Interest income calculated on average cash balances
B. Cash sweep provisions tied to excess cash flow
C. Depreciation expense calculated as % of revenue
D. Minimum cash balance requirements affecting debt repayment
Answer: C
Rationale: Depreciation as % of revenue flows from revenue → PP&E →
Depreciation → Net income, but doesn't create a circular reference since it doesn't
feed back to affect the original revenue input.
, 3
6. The "circularity breaker" switch in Excel models should be set to "ON" when:
A. Finalizing the model for distribution
B. Debugging errors and circular references
C. Running sensitivity analysis
D. Presenting results to clients
Answer: B
Rationale: The circularity breaker (setting interest to zero) helps identify and
resolve model errors by breaking calculation loops during debugging.
7. In modeling best practice, circular references should be:
A. Avoided entirely through formula design
B. Embraced as they increase accuracy
C. Handled with clear documentation and error checks
D. Only used in complex LBO models
Answer: C
Rationale: While circular references can increase accuracy, they must be handled
carefully with proper documentation, error checks, and user controls to maintain
model stability.
8. The primary risk of using iterative calculations in Excel is:
A. Reduced model accuracy
B. Model instability and potential crashes
C. Increased file size
D. Slower calculation only during startup
Answer: B
Rationale: Iterative calculations can cause model instability, infinite loops, or
crashes, especially in complex models or when errors are present.
Section B: Revenue & Expense Forecasting (7 Questions)
9. Which revenue forecasting method is most appropriate for a mature company
with stable historical growth?
A. Bottom-up unit analysis
B. Straight-line growth rate
C. Regression analysis
D. Market share analysis
