ABC Financial Modeling & Forecasting 2 — Questions and Answers
Question 1: In a three-statement financial model, which statement serves as the primary driver that feeds into both the balance sheet and cash flow statement?
- Cash flow statement
- Income statement (Correct answer)
- Statement of retained earnings
- Statement of stockholders' equity
Correct answer: Income statement
The income statement drives net income, which flows into retained earnings on the balance sheet and is the starting point for the cash flow statement.
Question 2: A company's Days Sales Outstanding (DSO) is 45 days. If annual revenue is $3.6 million, what is the approximate accounts receivable balance?
- $162,000
- $444,000 (Correct answer)
- $540,000
- $800,000
Correct answer: $444,000
DSO = (AR / Revenue) × 365, so AR = (45 / 365) × $3,600,000 ≈ $443,836.
Question 3: Which forecasting method assigns different weights to historical data points, giving more importance to recent periods?
- Simple moving average
- Exponential smoothing (Correct answer)
- Linear regression
- Naive forecasting
Correct answer: Exponential smoothing
Exponential smoothing applies a smoothing factor that gives exponentially decreasing weight to older observations.
Question 4: When building a sensitivity analysis in a financial model, what is the primary purpose of a data table in Excel?
- To store raw input data from external sources
- To show how output changes across multiple input variable combinations (Correct answer)
- To automatically update formulas when source data changes
- To create visual charts from model outputs
Correct answer: To show how output changes across multiple input variable combinations
A data table simultaneously calculates results for a range of one or two input variables, showing their combined impact on a key output.
Question 5: In financial modeling, 'hardcoding' refers to:
- Using complex nested IF formulas
- Entering a fixed numeric value directly into a formula cell (Correct answer)
- Linking cells across multiple worksheets
- Applying password protection to model inputs
Correct answer: Entering a fixed numeric value directly into a formula cell
Hardcoding means embedding a literal number directly in a formula rather than referencing a designated input cell, making models harder to audit and update.
Question 6: A bottom-up revenue forecast differs from a top-down forecast in that it:
- Starts with macroeconomic data and narrows to company estimates
- Begins with individual product/customer-level data to build total revenue (Correct answer)
- Uses only historical growth rates to project future sales
- Relies exclusively on industry analyst reports
Correct answer: Begins with individual product/customer-level data to build total revenue
A bottom-up approach aggregates granular unit-level or customer-level projections to arrive at total revenue, while top-down starts from market size.
Question 7: Which metric best measures how efficiently a company converts net income into free cash flow?
- Return on equity
- Cash conversion ratio (Correct answer)
- Debt-to-equity ratio
- Gross margin percentage
Correct answer: Cash conversion ratio
The cash conversion ratio (FCF / Net Income) shows what fraction of reported earnings actually becomes spendable cash.
ABC Financial Modeling & Forecasting 2
In a three-statement financial model, which statement serves as the primary driver that feeds into both the balance sheet and cash flow statement?