Finance for Non-Finance Managers Financial Forecasting And Planning 3 — Questions and Answers
Question 1: A company's forecast shows net income of $500K but operating cash flow of -$200K for the same period. Which of the following could explain this discrepancy?
- Revenue recognition was delayed into next period
- Large increases in accounts receivable and inventory consumed cash despite profitable sales (Correct answer)
- Depreciation expense exceeded capital spending
- Operating expenses were understated in the forecast
Correct answer: Large increases in accounts receivable and inventory consumed cash despite profitable sales
Profitable companies can be cash-flow negative when working capital builds rapidly, as cash is tied up in receivables and inventory before it is collected.
Question 2: Sensitivity analysis in financial forecasting is used primarily to:
- Replace scenario planning with a single 'most likely' outcome
- Identify which input assumptions have the greatest impact on financial outcomes (Correct answer)
- Ensure the forecast complies with GAAP standards
- Eliminate uncertainty from the planning process
Correct answer: Identify which input assumptions have the greatest impact on financial outcomes
Sensitivity analysis tests how much the output (e.g., profit or cash flow) changes when one input variable is altered, highlighting the highest-risk assumptions.
Question 3: A three-statement financial model links the income statement, balance sheet, and cash flow statement. What ties these three together?
- Revenue is the linking variable across all three statements
- Net income flows to retained earnings; cash flow reconciles to the cash balance on the balance sheet (Correct answer)
- Gross profit is duplicated on all three statements for consistency
- The tax rate is the primary connector between all three documents
Correct answer: Net income flows to retained earnings; cash flow reconciles to the cash balance on the balance sheet
Net income increases retained earnings on the balance sheet, and the cash flow statement explains the change in the cash account, ensuring all three statements reconcile.
Question 4: Which forecasting technique is most appropriate when historical data is unavailable, such as for a brand-new product launch?
- Time-series regression
- Moving averages
- Market research and expert judgment (Correct answer)
- Exponential smoothing
Correct answer: Market research and expert judgment
Without historical data, qualitative methods like market research surveys and expert judgment are the only viable basis for initial demand forecasts.
Question 5: A company's fixed costs are $1M per year and variable costs are $40 per unit. If the selling price is $60 per unit, what is the break-even volume?
- 16,667 units
- 25,000 units
- 50,000 units (Correct answer)
- 40,000 units
Correct answer: 50,000 units
Break-even = Fixed Costs ÷ Contribution Margin per unit = $1,000,000 ÷ ($60 - $40) = 50,000 units.
Question 6: When preparing a forecast, a manager adjusts future revenue projections upward to match a target set by the CEO rather than using data-based assumptions. This practice is known as:
- Stretch budgeting
- Sandbagging
- Top-down override or 'hockey stick' forecasting (Correct answer)
- Conservative planning
Correct answer: Top-down override or 'hockey stick' forecasting
Forcing projections to match desired targets rather than analytical assumptions creates unrealistic 'hockey stick' forecasts that undermine planning credibility.
Question 7: In the context of financial planning, what does 'scenario planning' allow a manager to do?
- Guarantee one specific future outcome using advanced modeling
- Evaluate financial performance under multiple different sets of assumptions simultaneously (Correct answer)
- Replace the annual budget with a continuous monitoring process
- Identify the single most accurate revenue forecast
Correct answer: Evaluate financial performance under multiple different sets of assumptions simultaneously
Scenario planning creates distinct versions of the forecast (e.g., base, bull, bear) each built on a different coherent set of assumptions about the future.
Finance for Non-Finance Managers Financial Forecasting And Planning 3
A company's forecast shows net income of $500K but operating cash flow of -$200K for the same period.
Which of the following could explain this discrepancy?