CPA Bar Quiz: Forecast Revenues And Expenses

What this quiz covers

This quiz focuses on Forecast Revenues And Expenses, giving you a quick way to practice the rules, question types, and explanations that matter most for CPA Bar.

How to use this quiz

Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.

Question 1

1. 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 (correct answer)
2. All expenses remain constant in total as revenue changes, so only revenue needs to be forecasted
3. Future expenses are estimated by multiplying prior-year expenses by the expected revenue growth rate
4. CVP analysis separates fixed and variable components before any forecasting is performed

Explanation: 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.

Question 2

1. $5,500,000
2. $5,600,000 (correct answer)
3. $5,060,000
4. $5,800,000

Explanation: 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.

Question 3

1. COGS $3,100,000; SGA$1,080,000
2. COGS $3,360,000; SGA$900,000
3. COGS $3,472,000; SGA$1,008,000 (correct answer)
4. COGS $3,584,000; SGA$1,120,000

Explanation: 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.

Question 4

1. $5,082,000
2. $5,400,000
3. $5,500,000
4. $5,590,200 (correct answer)

Explanation: 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.

Question 5

1. $40,000,000
2. $32,000,000
3. $36,000,000 (correct answer)
4. $28,000,000

Explanation: 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.

Question 6

1. $5,280,000
2. $6,480,000
3. $5,680,000
4. $6,080,000 (correct answer)

Explanation: Total variable costs = (45% + 6%) x $8,000,000 = 51$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.

Question 7

1. $1,920,000 (correct answer)
2. $2,720,000
3. $1,120,000
4. $3,920,000

Explanation: 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.

Question 8

1. $1,398,000
2. $1,498,000 (correct answer)
3. $1,598,000
4. $1,698,000

Explanation: 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.

Question 9

1. $225,000
2. $1,200,000
3. $900,000
4. $986,301 (correct answer)

Explanation: 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.

Question 10

1. $3,000,000
2. $3,300,000
3. $2,550,000 (correct answer)
4. $2,400,000

Explanation: 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).

Question 11

1. $1,575,000 (correct answer)
2. $1,725,000
3. $2,100,000
4. $1,425,000

Explanation: EBIT = Gross profit - SGA - Depreciation = $4,500,000 -$1,800,000 - $400,000 =$2,300,000. EBT = $2,300,000 -$200,000 = $2,100,000. Net income =$2,100,000 x (1 - 0.25) = $1,575,000. Option B applies a 25% tax rate to an incorrect EBT. Option C is EBT before taxes. Option D applies a higher tax rate.

Question 12

1. Extrapolating historical trends is always the most accurate method for revenue forecasting
2. 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 (correct answer)
3. The company's forecast should be reduced to match the 4% market growth rate
4. Revenue forecasts should never be set above the industry market growth rate

Explanation: 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.

Question 13

1. Detailed estimates at the product, customer, region, or salesperson level that are aggregated to arrive at total revenue (correct answer)
2. An estimate of total market size from which a market share percentage is applied
3. Historical revenue trends extrapolated forward using a growth rate assumption
4. The minimum revenue required to achieve a specified profitability target

Explanation: 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.

Question 14

1. The percentage-of-sales method is always accurate regardless of the cost structure
2. 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 (correct answer)
3. Fixed costs should be excluded entirely from expense forecasts
4. Depreciation and lease obligations are non-cash and should not be included in expense forecasts

Explanation: 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.

Question 15

1. The 45-day target payables balance is higher than last year, so the company is extending payment terms favorably
2. Reducing DPO to 45 days will release working capital and always improves the cash position
3. 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 (correct answer)
4. DPO assumptions are irrelevant to the cash flow forecast because accounts payable is a non-cash balance sheet item

Explanation: 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.

Question 16

1. $3,000,000
2. $3,750,000 (correct answer)
3. $4,500,000
4. $2,550,000

Explanation: Base quarterly revenue = $12,000,000 / 4 =$3,000,000. Q3 forecast = $3,000,000 x 1.25 =$3,750,000. The seasonal index of 1.25 indicates Q3 historically runs 25% above the average quarter. Option A is the unadjusted base quarterly figure. Option C applies a 1.50 index. Option D is the Q1 forecast ($3,000,000 x 0.85).

Question 17

1. A 12-month moving average base is too short and should be extended to 24 months
2. The new product revenue should be excluded because it is non-recurring
3. 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 (correct answer)
4. Moving average methods are unsuitable for any company with new product launches

Explanation: 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.

Question 18

1. Price increases always generate proportional revenue growth regardless of competitive dynamics
2. A 15% price increase is modest and achievable in any industry
3. Revenue forecasts should never include price increase assumptions because they are too uncertain
4. In a commoditized competitive market, a 15% price increase risks significant volume loss to competitors; the forecast should model the volume response to the price change rather than assuming revenue rises proportionally (correct answer)

Explanation: In a commoditized market where customers can switch easily between suppliers, a 15% price increase is likely to trigger substantial volume loss. Price elasticity determines whether the revenue impact is positive or negative; in a highly competitive commodity environment, demand is typically elastic and large price increases result in lower total revenue. The forecast should model expected volume at the new price and test the combined revenue impact. Option A ignores price elasticity. Option B makes an unsupported claim that 15% is universally modest. Option C goes too far in prohibiting price assumptions entirely.

Question 19

1. Fixed costs never change by definition, so the assumption is always correct
2. Revenue growth always causes proportional increases in fixed costs
3. The assumption is reasonable as long as the company currently has sufficient excess capacity
4. Assuming flat fixed costs during 50% revenue growth may understate future costs if the growth requires additional capacity, infrastructure, or management headcount that steps up fixed expenses (correct answer)

Explanation: Fixed costs are fixed within a relevant range, but 50% revenue growth over three years will often push a company beyond its current relevant range. New production equipment, additional warehouse space, expanded IT systems, or a larger management team may be needed to support the higher revenue level. The forecast should identify specific capacity thresholds and model step-ups in fixed costs when those thresholds are crossed. Option A misapplies the accounting definition of fixed costs to a strategic planning context. Option B overstates the opposite extreme. Option C is partially valid but incomplete - whether excess capacity exists is precisely what needs to be confirmed.

Question 20

1. $420,000 (correct answer)
2. $450,000
3. $390,000
4. $430,000

Explanation: Simple moving average = ($420,000 +$450,000 + $390,000) / 3 =$1,260,000 / 3 = $420,000. The three-period average smooths out fluctuations by giving equal weight to each of the three most recent observations. Option B is the highest single-period value. Option C is the most recent period's actual sales. Option D applies unequal weights to the three periods.