CPA Financial Modeling & Forecasting 2 — Questions and Answers
Question 1: In a three-statement financial model, which statement serves as the 'anchor' that the other two statements are built around?
- Balance Sheet
- Cash Flow Statement
- Income Statement (Correct answer)
- Statement of Retained Earnings
Correct answer: Income Statement
The Income Statement is the anchor because revenues and expenses flow into net income, which then drives the balance sheet (retained earnings) and cash flow statement.
Question 2: When building a revenue forecast using a bottoms-up approach, what is the primary input?
- Industry growth rates
- Historical revenue trends
- Unit volume and price assumptions (Correct answer)
- Macroeconomic GDP forecasts
Correct answer: Unit volume and price assumptions
A bottoms-up approach builds revenue from granular unit economics — number of units sold multiplied by average selling price — rather than top-down macro drivers.
Question 3: What does a 'circular reference' in a financial model typically involve?
- A formula that references a cell in a different worksheet
- Interest expense depending on debt, which depends on cash, which depends on net income including interest (Correct answer)
- A revenue line that references the prior year's revenue
- A depreciation schedule linked to the capital expenditure forecast
Correct answer: Interest expense depending on debt, which depends on cash, which depends on net income including interest
Circularity arises when interest expense affects net income, net income affects the cash balance, and the cash balance affects the debt level used to calculate interest expense.
Question 4: In scenario analysis for a financial model, what is the primary distinction between a 'base case' and a 'downside case'?
- The base case uses optimistic assumptions while the downside case uses realistic ones
- The downside case assumes adverse conditions such as lower revenue growth or higher costs (Correct answer)
- The base case excludes capital expenditures while the downside case includes them
- The downside case applies a higher discount rate to all cash flows
Correct answer: The downside case assumes adverse conditions such as lower revenue growth or higher costs
The downside case stress-tests the model under pessimistic assumptions (e.g., revenue decline, margin compression) to evaluate business resilience.
Question 5: Which financial modeling concept refers to projecting the minimum cash balance a company needs to operate without external financing?
- Working capital floor
- Minimum cash balance or operating cash buffer (Correct answer)
- Liquidity covenant threshold
- Net operating loss carryforward
Correct answer: Minimum cash balance or operating cash buffer
A minimum cash balance assumption ensures the model doesn't project the company running out of cash needed for day-to-day operations.
Question 6: When forecasting days sales outstanding (DSO), an increase in DSO relative to historical levels most likely indicates:
- Faster collection of receivables and improved cash flow
- Slower collection of receivables and potential credit quality deterioration (Correct answer)
- Higher revenue growth leading to more outstanding invoices
- A reduction in the company's accounts payable turnover
Correct answer: Slower collection of receivables and potential credit quality deterioration
Rising DSO means customers are taking longer to pay, which ties up cash in receivables and may signal collection problems or loosened credit standards.
Question 7: In an LBO (leveraged buyout) model, what is the primary metric used to assess whether the deal generates an acceptable return for the private equity sponsor?
- Net present value (NPV) of projected cash flows
- Internal rate of return (IRR) and multiple of invested capital (MOIC) (Correct answer)
- Earnings per share accretion over the holding period
- Price-to-earnings ratio at exit relative to entry
Correct answer: Internal rate of return (IRR) and multiple of invested capital (MOIC)
PE sponsors evaluate LBO returns primarily through IRR (time-weighted return) and MOIC (total cash returned relative to equity invested).
CPA Financial Modeling & Forecasting 2
In a three-statement financial model, which statement serves as the 'anchor' that the other two statements are built around?