WSP Financial Statement Modeling Exam 2025 – 50 Questions with Complete Answers | 100% Verified | A+ Grade

WSP Financial Statement Modeling
Exam 2025 – 50 Questions with
Complete Answers | 100% Verified |
A+ Grade

3-Statement Modeling (15 Questions)
Question 1
In a 3-statement model, how is the cash balance on the balance sheet typically forecasted?
A) Directly from historical cash balances
B) From the ending cash balance on the cash flow statement
C) By averaging cash inflows and outflows
D) Using revenue growth assumptions
Correct Answer: B
Rationale:

 A: Incorrect. Historical cash balances are used as a starting point, but forecasting relies
on cash flow statement calculations.
 B: Correct. The cash balance is forecasted by linking the ending cash balance from the
cash flow statement, which accounts for cash from operations, investing, and financing ().
 C: Incorrect. Averaging inflows and outflows is not a standard method.
 D: Incorrect. Revenue growth informs income statement forecasts, not cash directly.

Question 2
What is the correct order for building a 3-statement model in Excel?
A) Balance sheet, income statement, cash flow statement
B) Income statement, balance sheet, cash flow statement
C) Cash flow statement, balance sheet, income statement
D) Income statement, cash flow statement, balance sheet
Correct Answer: B
Rationale:

 A: Incorrect. The balance sheet requires income statement inputs (e.g., net income).
 B: Correct. The income statement is built first to forecast revenue and expenses, followed
by the balance sheet (using net income and schedules), and the cash flow statement last to
calculate cash changes (,).
 C: Incorrect. The cash flow statement depends on income statement and balance sheet
data.

,  D: Incorrect. The balance sheet must be forecasted before finalizing cash flows.

Question 3
How is net income linked in a 3-statement model?
A) From income statement to balance sheet’s retained earnings
B) From cash flow statement to income statement
C) From balance sheet to cash flow statement
D) Directly to cash balance on balance sheet
Correct Answer: A
Rationale:

 A: Correct. Net income from the income statement flows to retained earnings on the
balance sheet, adjusted for dividends ().
 B: Incorrect. Net income originates in the income statement, not the cash flow statement.
 C: Incorrect. Net income does not flow from the balance sheet.
 D: Incorrect. Net income affects retained earnings, not cash directly.

Question 4
In a 3-statement model, how is the revolver balance typically forecasted?
A) Based on revenue growth rates
B) Using the MIN function to reflect negative cash balances
C) As a fixed percentage of long-term debt
D) By linking to accounts receivable
Correct Answer: B
Rationale:

 A: Incorrect. Revenue growth informs income statement items, not the revolver.
 B: Correct. The revolver balance is forecasted using the MIN function to reflect negative
cash balances as short-term borrowing, ensuring the balance sheet balances ().
 C: Incorrect. The revolver is not a fixed percentage of long-term debt.
 D: Incorrect. Accounts receivable affect working capital, not the revolver.

Question 5
What is the impact of an increase in accounts payable on the cash flow statement?
A) Increases cash from operations
B) Decreases cash from operations
C) Increases cash from financing
D) No impact on cash flow
Correct Answer: A
Rationale:

 A: Correct. An increase in accounts payable (a liability) means delayed cash payments,
increasing cash from operations ().
 B: Incorrect. A decrease in accounts payable reduces cash.
 C: Incorrect. Accounts payable is an operating activity, not financing.
 D: Incorrect. Changes in working capital affect cash flow.

, Question 6
In a 3-statement model, how is depreciation expense linked?
A) From income statement to cash flow statement as a non-cash add-back
B) From balance sheet to income statement directly
C) From cash flow statement to balance sheet
D) As a standalone input in the model
Correct Answer: A
Rationale:

 A: Correct. Depreciation, a non-cash expense on the income statement, is added back to
net income in the cash flow statement’s operating section ().
 B: Incorrect. Depreciation is calculated in a PP&E schedule and linked to the income
statement.
 C: Incorrect. Depreciation does not flow from cash flow to balance sheet.
 D: Incorrect. Depreciation is derived from PP&E schedules, not standalone.

Question 7
How is the change in working capital calculated in a 3-statement model?
A) Current assets minus current liabilities
B) Change in current assets minus change in current liabilities
C) Revenue minus expenses
D) Net income minus dividends
Correct Answer: B
Rationale:

 A: Incorrect. This calculates net working capital, not the change.
 B: Correct. Change in working capital is the difference in current assets (e.g., AR,
inventory) minus current liabilities (e.g., AP) from one period to the next, affecting cash
flow ().
 C: Incorrect. Revenue minus expenses is net income.
 D: Incorrect. Net income minus dividends affects retained earnings.

Question 8
What happens if the balance sheet does not balance in a 3-statement model?
A) The model is correct as long as income statement balances
B) There is an error in assumptions or calculations
C) Adjust revenue to force balance
D) Ignore the imbalance for forecasting
Correct Answer: B
Rationale:

 A: Incorrect. The balance sheet must balance (assets = liabilities + equity).
 B: Correct. An unbalanced balance sheet indicates errors in assumptions, calculations, or
linkages ().
 C: Incorrect. Adjusting revenue is not a valid fix.
 D: Incorrect. The imbalance must be resolved for model accuracy.