Finance for Non-Finance Managers Financial Forecasting And Planning 4 — Questions and Answers
Question 1: A non-finance manager is asked to review a 'waterfall chart' in a forecast presentation. What does this chart typically show?
- Cumulative cash flows over the life of a project
- How individual factors contributed to the change between two values, such as last year's profit vs. this year's forecast (Correct answer)
- A comparison of multiple scenarios side by side
- The trend of a single metric over twelve months
Correct answer: How individual factors contributed to the change between two values, such as last year's profit vs. this year's forecast
A waterfall chart visualizes bridge analysis, showing how each driver (price, volume, cost changes) adds to or subtracts from a starting value to arrive at the ending value.
Question 2: Which of the following is a leading indicator useful in financial forecasting?
- Last quarter's net income
- Current backlog of signed customer contracts (Correct answer)
- Prior year accounts payable balance
- Year-to-date depreciation expense
Correct answer: Current backlog of signed customer contracts
A signed contract backlog is a leading indicator because it predicts future revenue before it is earned, unlike lagging indicators that reflect what already happened.
Question 3: A department manager forecasts hiring 10 new employees in Q3 but overlooks related costs. Which cost is most commonly omitted in headcount-based forecasts?
- Base salary
- Employer payroll taxes and benefits burden (Correct answer)
- Job title allocation
- Office equipment depreciation
Correct answer: Employer payroll taxes and benefits burden
Managers often forecast salary only and forget that employer costs (FICA, health insurance, 401k match) typically add 20–35% on top of base pay.
Question 4: Which of the following statements about Monte Carlo simulation in financial planning is correct?
- It produces a single deterministic forecast based on average assumptions
- It runs thousands of random scenarios to generate a probability distribution of outcomes (Correct answer)
- It is used exclusively for stock market predictions
- It requires no historical data or input assumptions
Correct answer: It runs thousands of random scenarios to generate a probability distribution of outcomes
Monte Carlo simulation randomly samples from probability distributions for each input variable across thousands of iterations, showing the range and likelihood of financial outcomes.
Question 5: A company's Days Sales Outstanding (DSO) has increased from 30 to 45 days over the past year. How should this trend be reflected in the cash flow forecast?
- Higher revenue should be forecast since customers are more engaged
- Cash collections will be slower, requiring more working capital funding (Correct answer)
- Accounts payable should be increased to match the DSO rise
- The change has no impact on cash flow if revenue stays the same
Correct answer: Cash collections will be slower, requiring more working capital funding
Rising DSO means customers take longer to pay, delaying cash receipts and increasing the cash tied up in receivables regardless of revenue levels.
Question 6: In financial planning, 'contingency reserves' are best described as:
- Extra budget allocated to the highest-revenue departments
- Funds set aside to cover unforeseen costs or revenue shortfalls without revising the entire plan (Correct answer)
- The difference between the optimistic and pessimistic forecast scenarios
- Statutory reserves required by accounting standards
Correct answer: Funds set aside to cover unforeseen costs or revenue shortfalls without revising the entire plan
Contingency reserves provide a financial buffer for unexpected events, allowing managers to absorb surprises without triggering a full reforecast.
Question 7: A manager asks why the finance team uses 'constant currency' figures when reporting international revenue forecasts. The correct explanation is:
- Constant currency reporting is required by US GAAP for multinational companies
- It isolates operational performance by removing the effect of exchange rate fluctuations (Correct answer)
- It converts all foreign revenue to the lowest available exchange rate to be conservative
- Constant currency forecasts are only used when the dollar is weakening
Correct answer: It isolates operational performance by removing the effect of exchange rate fluctuations
Constant currency analysis applies the same exchange rate to both periods so that revenue changes reflect real business performance, not just currency movements.
Finance for Non-Finance Managers Financial Forecasting And Planning 4
A non-finance manager is asked to review a 'waterfall chart' in a forecast presentation.
What does this chart typically show?