- A company's revenue for three consecutive years was $4,200,000, $4,620,000, and $5,082,000, growing at a consistent 10% annually. Using this trend, what is the Year 4 revenue forecast?
Answer: $5,590,200
Year 4 forecast = Year 3 revenue x (1 + trend growth rate) = $5,082,000 x 1.10 = $5,590,200. Option A repeats Year 3 revenue without applying growth. Option B applies approximately 6.3% growth. Option C applies approximately 8.2% growth, not the consistent 10% trend.
- A 12-month moving average revenue forecast includes two months of revenue from a new product line launched in Month 10, contributing $400,000 in those two months. The analyst uses all 12 months as the base. Which concern does this approach raise?
Answer: Including only 2 of the 12 months of new product revenue significantly understates the forward run rate; the forecast should be adjusted to reflect the full annualized contribution of the new product line
A moving average that includes a new product for only 2 of 12 months will embed only one-sixth of the product's run-rate contribution into the forecast. If the new product generated $400,000 in two months, its annualized run rate is approximately $2,400,000 - but the 12-month average smooths this into a far smaller contribution. The forecast should explicitly account for the full forward impact of the new product rather than relying on an averaging method that dilutes recent structural changes. Option B incorrectly labels recurring new product revenue as non-recurring. Option D overgeneralizes from one limitation.
- A company forecasts revenue by extrapolating a three-year historical growth rate of 20% per year. Industry analysts project the market will grow 4% next year. Which concern is most relevant to this revenue forecast?
Answer: Growing 20% in a 4%-growth market requires continuous market share capture; the forecast should be validated against specific competitive advantages and the realistic scope for further market share gains
A company growing at 20% in a 4% market must be capturing market share at approximately 16 percentage points annually. This is analytically unusual and unsustainable without specific, identifiable competitive advantages. The forecast should be stress-tested: what share gains are implied, are they achievable given competitive dynamics, and at what point does share capture become implausible? Option A treats trend extrapolation as automatically valid. Option C replaces the company-specific estimate with the market rate without analysis. Option D makes an absolute rule that ignores legitimate above-market growth cases.
- The total addressable market is estimated at $800,000,000. A company expects to maintain its current 4.5% market share. Using the top-down approach, what is forecasted revenue?
Answer: $36,000,000
Forecasted revenue = Total market x Market share = $800,000,000 x 4.5% = $36,000,000. Option A applies a 5.0% market share. Option B applies a 4.0% market share. Option D applies a 3.5% market share.
- A company uses the percentage-of-sales method for all expense line items, including fixed overhead (long-term leases and depreciation on recently purchased equipment). Which concern does this approach create?
Answer: Projecting fixed costs as variable incorrectly forecasts them as declining when revenue falls; the model will overstate profitability in downside revenue scenarios because the cost reductions it implies will not actually occur
Applying the percentage-of-sales method to fixed costs converts them into variable costs for forecasting purposes. If revenue declines 20%, the model will forecast a proportional reduction in lease and depreciation expenses - but these costs are contractually fixed and will not decline. This produces an overstated profit forecast in the downside scenario. Fixed costs should be modeled separately at their committed amounts, while variable costs use the percentage-of-sales method. Option A ignores the model error. Option C is incorrect; fixed costs must be included. Option D incorrectly suggests non-cash items be excluded from expense forecasts.
- Sales volume: 1,000 units (30% chance) or 1,500 units (70%). Unit price $20. Expected revenue?
Answer: $27,000
Expected volume is 0.3(1,000) + 0.7(1,500) = 1,350 units. At $20 per unit, 1,350 x 20 = $27,000. A tempting wrong answer is $25,000, which uses the simple average of 1,000 and 1,500 units and ignores the 30% and 70% probabilities.
- Revenue $500,000, variable costs $300,000, fixed costs $120,000. Sales up 10%, all costs up 8%. Forecast profit?
Answer: $96,400
Sales become 550,000. Variable costs become 324,000 and fixed costs become 129,600, so total costs are 453,600. Forecast profit is 550,000 - 453,600 = 96,400. The tempting $88,000 just grows the old $80,000 profit by 10% and ignores the 8% cost increase.
- A company had revenue of $5,000,000 last year. Management forecasts 12% revenue growth for the coming year. What is the forecasted revenue?
Answer: $5,600,000
Forecasted revenue = Prior revenue x (1 + growth rate) = $5,000,000 x 1.12 = $5,600,000. Option A applies a 10% growth rate. Option C applies a 1.2% growth rate. Option D applies a 16% growth rate.
- In bottom-up revenue forecasting, the starting point is which of the following?
Answer: Detailed estimates at the product, customer, region, or salesperson level that are aggregated to arrive at total revenue
Bottom-up forecasting builds from granular, operational-level estimates - individual products, customers, territories, or salespeople - aggregating them into a total. This approach leverages detailed knowledge of specific opportunities and constraints. Option B describes top-down forecasting. Option C describes trend extrapolation. Option D describes a target-based approach that works backward from a profitability goal rather than estimating from the ground up.
- Using the same annual forecast of $12,000,000 and a Q1 seasonal index of 0.85, what is the forecasted Q1 revenue?
Answer: $2,550,000
Q1 forecast = ($12,000,000 / 4) x 0.85 = $3,000,000 x 0.85 = $2,550,000. Q1 is a below-average quarter at 85% of the quarterly base. Option A is the unadjusted base quarterly amount. Option B applies a 1.10 index (Q2 index). Option D applies a 0.80 index (Q4 index).
- The percentage-of-sales method for forecasting financial statements is based on which assumption?
Answer: Many income statement and balance sheet items vary proportionally with revenue, so each is expressed as a fixed percentage of sales to project future values
The percentage-of-sales method assumes that items such as COGS, operating expenses, accounts receivable, inventory, and accounts payable maintain a stable relationship to revenue over time. By expressing each as a percentage of historical sales, the analyst can project future values simply by applying those percentages to forecasted revenue. Option B describes fixed cost behavior, the opposite of the variable relationship assumed. Option C describes applying a growth rate to expenses, which is different from expressing them as a revenue percentage. Option D describes a different analytical method used for cost structure analysis.
- Using the percentage-of-sales method with COGS historically at 62% of revenue and SGA at 18% of revenue, what are the forecasted COGS and SGA for projected revenue of $5,600,000?
Answer: COGS $3,472,000; SGA $1,008,000
COGS = $5,600,000 x 62% = $3,472,000. SGA = $5,600,000 x 18% = $1,008,000. Option A applies 62% and 19.3% respectively. Option B applies 60% and 16.1% respectively. Option D applies 64% and 20% respectively - the percentages from a prior period rather than the stated historical averages.
- A company uses exponential smoothing with a smoothing constant of 0.3. Last period's forecast was $500,000 and last period's actual sales were $560,000. What is the forecast for the current period?
Answer: $518,000
Exponential smoothing: New forecast = (alpha x Actual) + ((1 - alpha) x Prior forecast) = (0.3 x $560,000) + (0.7 x $500,000) = $168,000 + $350,000 = $518,000. A weight of 0.3 gives 30% weight to the most recent actual and 70% to the prior forecast, smoothing out fluctuations. Option B applies an incorrect formula. Option C uses only the actual value without any prior forecast weighting. Option D uses only the prior forecast without updating for the actual result.
- A company projects revenue of $9,000,000 and targets days sales outstanding (DSO) of 40 days. What is the forecasted accounts receivable balance?
Answer: $986,301
Forecasted AR = Revenue x (DSO / 365) = $9,000,000 x (40 / 365) = $9,000,000 x 0.10959 = $986,301. Option A uses an incorrect divisor. Option B uses a 48.7-day DSO. Option C uses a round 36.5-day DSO instead of 40 days.
- A sales team provides a bottom-up revenue estimate of $18,000,000. Management applies a 15% haircut, citing the sales team's history of over-forecasting, and uses $15,300,000 as the forecast. Which analytical approach is most sound?
Answer: The haircut should be based on a structured analysis of historical forecast accuracy - if the sales team has consistently over-forecasted by a quantifiable and stable bias, the adjustment should reflect that measured bias rather than an arbitrary round percentage
Acknowledging that sales team forecasts can be biased is analytically sound - sales teams often face incentives to provide optimistic projections. However, the adjustment should be data-driven: how much has the team historically over-forecasted on average? If the historical over-forecast has been 8%, applying a 15% haircut is itself inaccurate. A rigorous approach would quantify the bias from historical data and apply a calibrated, consistent adjustment. Option B ignores the documented bias. Option C eliminates a legitimate management judgment role. Option D treats a specific percentage as universal when no such standard exists.
- A company forecasts: 15% revenue growth from last year's $6,000,000; COGS remaining at 58% of revenue; SGA increasing by $200,000 from last year's $900,000; depreciation unchanged at $300,000. What is forecasted operating income?
Answer: $1,498,000
Forecasted revenue = $6,000,000 x 1.15 = $6,900,000. COGS = $6,900,000 x 58% = $4,002,000. Gross profit = $6,900,000 - $4,002,000 = $2,898,000. SGA = $900,000 + $200,000 = $1,100,000. Operating income = $2,898,000 - $1,100,000 - $300,000 = $1,498,000. Option A uses an incorrect COGS percentage. Option C omits the SGA increase. Option D applies SGA as a percentage of new revenue rather than adding the fixed increment.
- A company forecasts expenses as: variable manufacturing 45% of revenue, variable selling 6% of revenue, fixed overhead $800,000, fixed SGA $1,200,000. Forecasted revenue is $8,000,000. What are total forecasted expenses?
Answer: $6,080,000
Total variable costs = (45% + 6%) x $8,000,000 = 51% x $8,000,000 = $4,080,000. Total fixed costs = $800,000 + $1,200,000 = $2,000,000. Total expenses = $4,080,000 + $2,000,000 = $6,080,000. Option A omits fixed overhead. Option B applies a higher variable percentage. Option C uses only one fixed cost component.
- Flexible budget formula: $20,000 fixed plus $4 per unit. Static volume 8,000; actual 9,000. Budgeted expense?
Answer: $56,000
Start with the fixed $20,000, then add $4 per unit at the actual volume of 9,000 units: $36,000. Total budgeted expense is $56,000. The tempting error is using static volume of 8,000 units, which gives only $52,000, but a flexible budget adjusts to actual activity.
- A company's prior-year accounts payable was $900,000 (DPO of 55 days) based on COGS of $6,000,000. The forecast uses a target DPO of 45 days against the same projected COGS. Which concern is most relevant to this assumption?
Answer: Moving from 55-day to 45-day DPO implies paying suppliers faster, which uses more cash; the forecast should explicitly model the cash outflow impact, or explain why a faster payment assumption is appropriate
Forecasted AP at 45 days = $6,000,000 x (45/365) = approximately $740,000, compared to $900,000 currently. This $160,000 reduction in AP represents cash that flows out to suppliers faster than before. If the company is currently paying in 55 days but the forecast assumes 45 days, the model must either explain why the company plans to accelerate payments (a deliberate strategic choice) or acknowledge that this is an aspirational assumption that may not materialize. Option A is incorrect; 45 days is shorter (not longer) than 55 days. Option B mischaracterizes a payables reduction as releasing working capital - it actually consumes cash. Option D is incorrect; changes in AP directly affect cash flow.
- Using the expense forecast from the prior question (variable costs 51% of revenue, fixed costs $2,000,000) with revenue of $8,000,000, what is forecasted operating income?
Answer: $1,920,000
Contribution margin = $8,000,000 x (1 - 0.51) = $8,000,000 x 0.49 = $3,920,000. Operating income = $3,920,000 - $2,000,000 = $1,920,000. Option B omits variable selling expenses from the variable cost ratio. Option C uses an incorrect fixed cost total. Option D reports contribution margin before fixed costs rather than operating income.
