ABC Financial Modeling & Forecasting 3 — Questions and Answers
Question 1: In a leveraged buyout (LBO) model, which source of value creation is typically considered the most sustainable long-term?
- Financial leverage (debt paydown)
- Multiple expansion
- Operational improvements (EBITDA growth) (Correct answer)
- Tax shield from interest deductions
Correct answer: Operational improvements (EBITDA growth)
Operational improvements that grow EBITDA are considered the most durable value driver since they reflect genuine business performance rather than financial engineering.
Question 2: When modeling working capital, an INCREASE in accounts payable is treated as:
- A use of cash (negative cash flow)
- A source of cash (positive cash flow) (Correct answer)
- A non-cash charge on the income statement
- An investing activity on the cash flow statement
Correct answer: A source of cash (positive cash flow)
Increasing accounts payable means the company is delaying cash payments to suppliers, effectively conserving cash — a positive operating cash flow item.
Question 3: The term 'circular reference' in financial modeling most commonly arises from:
- Linking income statement to balance sheet
- Interest expense depending on debt, which depends on cash, which depends on interest (Correct answer)
- Depreciation schedules referencing capital expenditures
- Revenue growth rates referencing prior-year values
Correct answer: Interest expense depending on debt, which depends on cash, which depends on interest
Interest expense affects net income and cash, which affects ending debt balance, which in turn affects interest expense — creating a loop that requires iterative calculation.
Question 4: A company has EBIT of $500,000, depreciation of $80,000, capex of $120,000, and a working capital increase of $30,000 with a 25% tax rate. What is unlevered free cash flow?
- $305,000 (Correct answer)
- $295,000
- $430,000
- $375,000
Correct answer: $305,000
UFCF = EBIT(1-t) + D&A - Capex - ΔNWC = $375,000 + $80,000 - $120,000 - $30,000 = $305,000.
Question 5: Which regression statistic indicates the proportion of variance in the dependent variable explained by the independent variables?
- P-value
- Standard error
- R-squared (Correct answer)
- T-statistic
Correct answer: R-squared
R-squared (coefficient of determination) ranges from 0 to 1 and measures how well the regression model explains variability in the outcome.
Question 6: In scenario analysis for a financial model, which scenario is typically used as the basis for all other scenarios?
- Bull case
- Bear case
- Base case (Correct answer)
- Stress case
Correct answer: Base case
The base case represents management's most likely outcome and serves as the reference point from which upside (bull) and downside (bear) scenarios are constructed.
Question 7: A 'bridge' in financial modeling is used to:
- Connect two separate financial models via shared assumptions
- Explain the change between two values by breaking it into contributing factors (Correct answer)
- Reconcile GAAP and non-GAAP financial figures
- Link the model to live market data feeds
Correct answer: Explain the change between two values by breaking it into contributing factors
A bridge (or waterfall chart) decomposes the difference between a starting and ending value into individual line items that explain the movement.
ABC Financial Modeling & Forecasting 3
In a leveraged buyout (LBO) model, which source of value creation is typically considered the most sustainable long-term?