Financial Statement Modeling Retake Exam:
Questions with Correct Answers | Wall Street Prep
(2026/2027 Edition)
SUBTITLE:
50 Exam Questions with Answers & Detailed Rationales
PREPARED FOR:
Wall Street Prep Financial Statement Modeling Retake Examination
DOCUMENT INCLUDES:
● Exam-style questions
● Correct answers
● Detailed rationales
● Key topics covered
TOPICS COVERED:
● Three Statement Modeling (Income Statement, Balance Sheet, Cash Flow
Statement)
● Revenue & Expense Forecasting
● Working Capital Modeling (AR, AP, Inventory, Deferred Revenue)
● PP&E & Intangible Asset Schedules
● Debt & Interest Schedules
● Equity & Shareholder Distributions
● Cash Flow Waterfall & Balance Sheet Balancing
● Model Flow & Circular References
● Operating Leases & Other Adjustments
● Sensitivity & Scenario Analysis
● Model Auditing & Error Checking
,SECTION 1: THREE STATEMENT MODELING FUNDAMENTALS
Question 1
In a properly linked three-statement model, which of the following is the correct
sequence for calculating the ending cash balance on the balance sheet?
A. Calculate Net Income on the Income Statement, then derive the Cash Flow
Statement, and finally link the ending cash balance from the Cash Flow Statement to the
Balance Sheet
B. Calculate the Balance Sheet first, then derive the Income Statement, and finally build
the Cash Flow Statement to reconcile the difference
C. Build the Cash Flow Statement independently using historical cash balances, then
link to the Income Statement and Balance Sheet
D. Calculate the Balance Sheet and Income Statement simultaneously, then use a plug
figure on the Cash Flow Statement to force the balance sheet to balance
Correct Answer: A
Rationale: In a three-statement model, the standard flow is: (1) Project the Income
Statement down to Net Income, (2) Use Net Income as the starting point for the Cash
Flow Statement (indirect method), adjusting for non-cash items and changes in working
capital, (3) Link the ending cash balance from the Cash Flow Statement to the cash line
item on the Balance Sheet. This creates a closed-loop system where the Balance Sheet
balances because the change in cash equals the sum of all other balance sheet
changes. Option B is incorrect because the Balance Sheet cannot be built before the
Income Statement and Cash Flow Statement are projected. Option C is incorrect
because the Cash Flow Statement is derived from the Income Statement and Balance
Sheet changes, not built independently. Option D describes a flawed modeling
approach; a plug figure is not used in a properly linked model.
,Question 2
A company has the following projected financials for Year 1: Revenue $500, COGS $300,
Operating Expenses $100, Depreciation $20, Interest Expense $10, Tax Rate 25%. What
is the projected Net Income?
A. $52.50
B. $70.00
C. $82.50
D. $75.00
Correct Answer: A
Rationale: To calculate Net Income: Gross Profit = Revenue - COGS = $500 - $300 =
$200. EBIT = Gross Profit - Operating Expenses - Depreciation = $200 - $100 - $20 = $80.
EBT (Earnings Before Tax) = EBIT - Interest Expense = $80 - $10 = $70. Net Income =
EBT × (1 - Tax Rate) = $70 × (1 - 0.25) = $70 × 0.75 = $52.50. Option B ($70.00) is EBT,
not Net Income. Option C ($82.50) incorrectly adds interest instead of subtracting it.
Option D ($75.00) incorrectly ignores depreciation or interest.
Question 3
In a three-statement model, if accounts receivable increases by $15 million during the
year, how does this affect the Cash Flow Statement using the indirect method?
A. It is added to Net Income in the operating activities section
B. It is subtracted from Net Income in the operating activities section
C. It is recorded as a cash inflow in the financing activities section
D. It has no impact on the Cash Flow Statement because it is a non-cash item
Correct Answer: B
, Rationale: Under the indirect method, an increase in accounts receivable represents
sales revenue recognized on the Income Statement for which cash has not yet been
collected. Therefore, the increase in AR must be subtracted from Net Income to
reconcile to cash flow from operations. Option A is incorrect because an increase in AR
reduces cash flow, not increases it. Option C is incorrect because changes in working
capital are operating activities, not financing activities. Option D is incorrect because AR
is a working capital item that directly impacts the operating cash flow reconciliation.
Question 4
Which of the following is the correct formula for linking the ending retained earnings
balance on the Balance Sheet to the Income Statement and Cash Flow Statement?
A. Ending Retained Earnings = Beginning Retained Earnings + Net Income - Dividends
B. Ending Retained Earnings = Beginning Retained Earnings + EBITDA - Dividends
C. Ending Retained Earnings = Beginning Retained Earnings + Net Income +
Stock-Based Compensation
D. Ending Retained Earnings = Beginning Retained Earnings + Cash Flow from
Operations - Dividends
Correct Answer: A
Rationale: Retained Earnings represents the cumulative net income of the company less
any distributions to shareholders (dividends). The correct linkage is: Ending Retained
Earnings = Beginning Retained Earnings + Net Income - Dividends. This is a
fundamental accounting identity. Option B is incorrect because EBITDA is not the
correct starting point; Net Income is the bottom-line profit available to shareholders.
Option C is incorrect because stock-based compensation is already included in Net
Income (as an expense) and adding it would double-count. Option D is incorrect
because Cash Flow from Operations is not the same as Net Income (it includes
non-cash adjustments and working capital changes).
Questions with Correct Answers | Wall Street Prep
(2026/2027 Edition)
SUBTITLE:
50 Exam Questions with Answers & Detailed Rationales
PREPARED FOR:
Wall Street Prep Financial Statement Modeling Retake Examination
DOCUMENT INCLUDES:
● Exam-style questions
● Correct answers
● Detailed rationales
● Key topics covered
TOPICS COVERED:
● Three Statement Modeling (Income Statement, Balance Sheet, Cash Flow
Statement)
● Revenue & Expense Forecasting
● Working Capital Modeling (AR, AP, Inventory, Deferred Revenue)
● PP&E & Intangible Asset Schedules
● Debt & Interest Schedules
● Equity & Shareholder Distributions
● Cash Flow Waterfall & Balance Sheet Balancing
● Model Flow & Circular References
● Operating Leases & Other Adjustments
● Sensitivity & Scenario Analysis
● Model Auditing & Error Checking
,SECTION 1: THREE STATEMENT MODELING FUNDAMENTALS
Question 1
In a properly linked three-statement model, which of the following is the correct
sequence for calculating the ending cash balance on the balance sheet?
A. Calculate Net Income on the Income Statement, then derive the Cash Flow
Statement, and finally link the ending cash balance from the Cash Flow Statement to the
Balance Sheet
B. Calculate the Balance Sheet first, then derive the Income Statement, and finally build
the Cash Flow Statement to reconcile the difference
C. Build the Cash Flow Statement independently using historical cash balances, then
link to the Income Statement and Balance Sheet
D. Calculate the Balance Sheet and Income Statement simultaneously, then use a plug
figure on the Cash Flow Statement to force the balance sheet to balance
Correct Answer: A
Rationale: In a three-statement model, the standard flow is: (1) Project the Income
Statement down to Net Income, (2) Use Net Income as the starting point for the Cash
Flow Statement (indirect method), adjusting for non-cash items and changes in working
capital, (3) Link the ending cash balance from the Cash Flow Statement to the cash line
item on the Balance Sheet. This creates a closed-loop system where the Balance Sheet
balances because the change in cash equals the sum of all other balance sheet
changes. Option B is incorrect because the Balance Sheet cannot be built before the
Income Statement and Cash Flow Statement are projected. Option C is incorrect
because the Cash Flow Statement is derived from the Income Statement and Balance
Sheet changes, not built independently. Option D describes a flawed modeling
approach; a plug figure is not used in a properly linked model.
,Question 2
A company has the following projected financials for Year 1: Revenue $500, COGS $300,
Operating Expenses $100, Depreciation $20, Interest Expense $10, Tax Rate 25%. What
is the projected Net Income?
A. $52.50
B. $70.00
C. $82.50
D. $75.00
Correct Answer: A
Rationale: To calculate Net Income: Gross Profit = Revenue - COGS = $500 - $300 =
$200. EBIT = Gross Profit - Operating Expenses - Depreciation = $200 - $100 - $20 = $80.
EBT (Earnings Before Tax) = EBIT - Interest Expense = $80 - $10 = $70. Net Income =
EBT × (1 - Tax Rate) = $70 × (1 - 0.25) = $70 × 0.75 = $52.50. Option B ($70.00) is EBT,
not Net Income. Option C ($82.50) incorrectly adds interest instead of subtracting it.
Option D ($75.00) incorrectly ignores depreciation or interest.
Question 3
In a three-statement model, if accounts receivable increases by $15 million during the
year, how does this affect the Cash Flow Statement using the indirect method?
A. It is added to Net Income in the operating activities section
B. It is subtracted from Net Income in the operating activities section
C. It is recorded as a cash inflow in the financing activities section
D. It has no impact on the Cash Flow Statement because it is a non-cash item
Correct Answer: B
, Rationale: Under the indirect method, an increase in accounts receivable represents
sales revenue recognized on the Income Statement for which cash has not yet been
collected. Therefore, the increase in AR must be subtracted from Net Income to
reconcile to cash flow from operations. Option A is incorrect because an increase in AR
reduces cash flow, not increases it. Option C is incorrect because changes in working
capital are operating activities, not financing activities. Option D is incorrect because AR
is a working capital item that directly impacts the operating cash flow reconciliation.
Question 4
Which of the following is the correct formula for linking the ending retained earnings
balance on the Balance Sheet to the Income Statement and Cash Flow Statement?
A. Ending Retained Earnings = Beginning Retained Earnings + Net Income - Dividends
B. Ending Retained Earnings = Beginning Retained Earnings + EBITDA - Dividends
C. Ending Retained Earnings = Beginning Retained Earnings + Net Income +
Stock-Based Compensation
D. Ending Retained Earnings = Beginning Retained Earnings + Cash Flow from
Operations - Dividends
Correct Answer: A
Rationale: Retained Earnings represents the cumulative net income of the company less
any distributions to shareholders (dividends). The correct linkage is: Ending Retained
Earnings = Beginning Retained Earnings + Net Income - Dividends. This is a
fundamental accounting identity. Option B is incorrect because EBITDA is not the
correct starting point; Net Income is the bottom-line profit available to shareholders.
Option C is incorrect because stock-based compensation is already included in Net
Income (as an expense) and adding it would double-count. Option D is incorrect
because Cash Flow from Operations is not the same as Net Income (it includes
non-cash adjustments and working capital changes).
