Skip to main content
Sign in Create a free account
Varsity Tutors
Sign in

Prepare And Interpret Financial Forecasts - CPA Bar

  1. A 3-year financial forecast shows revenue growing at a 15% CAGR and net income growing at an 8% CAGR. Net profit margin declines from 14% to 10% over the period despite stable gross margins. Which interpretation is most analytically complete?
    Answer: Operating expenses are growing faster than revenue - the gap between the 15% revenue CAGR and 8% net income CAGR indicates that operating and non-operating costs are expanding faster than the top line, which should be explained by specific planned cost increases in the forecast Revenue growing at 15% while net income grows at only 8% mathematically requires that total costs grow faster than 15%. With gross margins stable, the excess cost growth lies in operating expenses (SGA, R&D) or non-operating items (interest expense from growing debt). The forecast should explain specifically what is driving these costs higher - planned investment in headcount, marketing spend, or increasing interest expense from borrowing. Unexplained margin compression in a forecast represents a planning assumption that needs validation. Options B and D dismiss a structurally important signal. Option C focuses only on the favorable metric.
  2. A pro forma financing section shows: new long-term debt $500,000, debt repaid $200,000, dividends paid $140,000, common stock issued $100,000. What is net cash from financing activities?
    Answer: $260,000 Net financing cash flow = New debt - Debt repaid - Dividends + Stock issued = $500,000 - $200,000 - $140,000 + $100,000 = $260,000. Debt issuances and equity issuances are inflows; debt repayments and dividends are outflows. Option A labels the sign incorrectly. Option B omits new debt from the calculation. Option D adds all items instead of netting inflows against outflows.
  3. A company begins the period with a cash balance of $240,000. Pro forma operating cash flow is $1,820,000, investing cash flow is -$370,000, and financing cash flow is $260,000. What is the projected ending cash balance?
    Answer: $1,950,000 Ending cash = Beginning cash + Operating CF + Investing CF + Financing CF = $240,000 + $1,820,000 - $370,000 + $260,000 = $1,950,000. All three sections of the cash flow statement are combined with the beginning balance to arrive at the ending cash position. Option B omits the financing cash flow. Option C adds rather than subtracts the investing outflow. Option D includes additional amounts not in the stated data.
  4. A pro forma balance sheet projects total assets of $6,200,000. Current liabilities are $850,000, long-term debt is $1,600,000, and equity (including forecasted retained earnings increase) is $3,180,000. What is the external financing needed (EFN)?
    Answer: $570,000 Total liabilities and equity before EFN = $850,000 + $1,600,000 + $3,180,000 = $5,630,000. EFN = Total assets - Total funded L&E = $6,200,000 - $5,630,000 = $570,000. The EFN is the plug figure that reconciles the asset side to the liability and equity side of the balance sheet. Option A incorrectly concludes the balance sheet already balances. Options B and C use incorrect arithmetic.
  5. The sustainable growth rate (SGR) measures which of the following?
    Answer: The maximum growth rate achievable while maintaining the current debt-to-equity ratio and issuing no new equity, with new debt allowed to grow in proportion to retained earnings as they expand the equity base The SGR formula is (ROE x b) / (1 - ROE x b), where b is the earnings retention ratio. It answers: how fast can a company grow while keeping its existing financial structure intact (same D/E ratio, no new equity issuance), with debt allowed to expand proportionally as retained earnings increase equity? Growing faster than the SGR requires issuing new equity or deliberately increasing leverage beyond the current ratio. This differs from the internal growth rate, which allows no new external financing at all - no new debt and no new equity. Option A describes operating leverage effects, not the SGR. Option C describes historical trend extrapolation. Option D describes a competitive positioning metric unrelated to SGR.
  6. A 3-year revenue forecast shows Year 3 revenue of $6,272,000, with COGS projected at 60% of revenue. What is the projected gross profit for Year 3?
    Answer: $2,508,800 Gross profit = Revenue x (1 - COGS ratio) = $6,272,000 x (1 - 0.60) = $6,272,000 x 0.40 = $2,508,800. Option A reports projected COGS ($6,272,000 x 0.60 = $3,763,200) rather than gross profit. Option B uses Year 2 revenue ($5,600,000 x 0.40). Option C uses Year 1 revenue ($5,000,000 x 0.40).
  7. A company's forecast projects 18% revenue growth and shows the debt-to-equity ratio declining from 2.1x to 1.4x over three years. The company has no planned equity issuances. Which explanation is most consistent with this forecast?
    Answer: Profitable growth is generating retained earnings that increase equity faster than debt grows, organically reducing the debt-to-equity ratio When a company grows profitably and retains earnings (rather than paying them as dividends), the equity base expands over time. If debt remains relatively stable or grows more slowly than equity, the debt-to-equity ratio declines. This is the most natural explanation for an improving leverage ratio during a profitable growth phase with no equity issuance. Option A would increase the debt-to-equity ratio, the opposite of the forecast. Option B would reduce equity and increase the ratio. Option D is mechanically incorrect; revenue growth does not automatically affect debt levels.
  8. A company forecasts COGS of $4,640,000 and targets a days payable outstanding of 50 days. What is the forecasted accounts payable balance?
    Answer: $635,616 Forecasted AP = COGS x (DPO / 365) = $4,640,000 x (50/365) = $4,640,000 x 0.13699 = $635,616. Option A uses a DPO of approximately 39 days. Option C uses a DPO of approximately 57 days. Option D uses a DPO of approximately 36 days.
  9. A pro forma cash flow statement (indirect method) shows: net income $1,470,000, depreciation $320,000, increase in accounts receivable $180,000, decrease in inventory $90,000, increase in accounts payable $120,000. What is projected operating cash flow?
    Answer: $1,820,000 OCF = Net income + Depreciation - Increase in AR + Decrease in inventory + Increase in AP = $1,470,000 + $320,000 - $180,000 + $90,000 + $120,000 = $1,820,000. Increases in current assets use cash (subtract); decreases in current assets provide cash (add). Increases in current liabilities provide cash (add). Option B omits the depreciation add-back. Option C adds rather than subtracts the AR increase. Option D omits several working capital adjustments.
  10. A company projects: revenue $8,000,000, COGS 58% of revenue, SGA $900,000, depreciation $320,000, interest expense $180,000, and a 25% tax rate. What is projected net income?
    Answer: $1,470,000 Revenue $8,000,000 - COGS $4,640,000 = Gross profit $3,360,000. EBIT = $3,360,000 - $900,000 - $320,000 = $2,140,000. EBT = $2,140,000 - $180,000 = $1,960,000. Net income = $1,960,000 x (1 - 0.25) = $1,470,000. Option A is EBIT. Option B is EBT. Option D omits depreciation from the calculation.
  11. A pro forma financial forecast is best described as which of the following?
    Answer: A set of projected financial statements built on stated assumptions about future revenues, expenses, and other drivers, used for planning and decision-making A pro forma forecast projects future financial statements - income statement, balance sheet, and cash flows - using explicit assumptions about growth rates, margins, and other drivers. These projections support planning, capital allocation, and strategic decision-making. Option B describes a restatement, which corrects historical figures rather than projecting future ones. Option C describes certain SEC disclosure obligations unrelated to pro forma forecasting. Option D is incorrect; pro forma forecasts are typically prepared internally by management and are not subject to external audit.
  12. A company uses the percentage-of-sales method. Current assets are 28% of revenue and net fixed assets are 35% of revenue. Forecasted revenue is $10,000,000. What are the forecasted current assets and net fixed assets?
    Answer: Current assets $2,800,000; net fixed assets $3,500,000 Current assets = $10,000,000 x 28% = $2,800,000. Net fixed assets = $10,000,000 x 35% = $3,500,000. Option B reverses the two percentages. Option C applies incorrect percentages of 24% and 32%. Option D applies incorrect percentages of 30% and 37.5%.
  13. A company has ROE of 18% and a dividend payout ratio of 35%. Using the approximate sustainable growth rate formula (ROE x retention ratio), what is the sustainable growth rate?
    Answer: 11.7% Retention ratio = 1 - Payout ratio = 1 - 0.35 = 0.65. SGR = ROE x retention ratio = 18% x 0.65 = 11.7%. This means the company can grow at up to 11.7% per year using only internally generated earnings without external financing. Option A is the ROE without applying the retention ratio. Option B uses the payout ratio (0.35) instead of the retention ratio (0.65). Option D applies an incorrect retention ratio.
  14. A 2-year financial forecast shows interest coverage declining from 6.2x to 2.8x while EBIT grows 8% per year. Which interpretation is most concerning?
    Answer: Interest expense must be growing substantially faster than EBIT; at 2.8x coverage the company has limited cushion before debt service becomes strained, and the declining trend signals increasing financial risk For interest coverage to fall from 6.2x to 2.8x while EBIT grows 8% per year, interest expense must be growing dramatically - approximately 2.5x over two years. This implies significant new debt. The resulting 2.8x coverage is thin: any unexpected EBIT shortfall or further debt increase could put debt service at risk. The trend direction is as important as the current level. Option A focuses on EBIT growth without considering the cost of the underlying debt expansion. Option B makes an unsupported universal claim about coverage adequacy. Option C reaches an optimistic conclusion based on a single favorable metric.
  15. In financial forecasting, the 'plug' figure in a pro forma balance sheet represents which of the following?
    Answer: The additional external financing needed (or surplus cash available) that makes the projected balance sheet balance after all other items have been independently forecasted In percentage-of-sales forecasting, assets and liabilities are projected based on revenue and operating assumptions. The equity side grows through retained earnings, but the total may not equal total assets. The difference - the plug - represents either the external financing the company must raise (debt or equity) to fund projected asset growth, or surplus cash if liabilities and equity exceed projected assets. Option B confuses a deliberate modeling technique with an error. Option C describes the retained earnings rollforward, which is an input to the balance sheet, not the plug. Option D describes a trivial rounding adjustment.
  16. A company's forecast assumes working capital remains stable at 12% of revenue. Revenue grows from $10,000,000 to $16,000,000 over three years. Which cash flow implication must be explicitly modeled in the pro forma cash flow statement?
    Answer: Working capital growing proportionally with revenue requires approximately $720,000 of additional cash investment ($6,000,000 x 12%) to fund the working capital expansion, which must appear as a cash outflow in the operating section A stable working capital ratio means the absolute amount of working capital grows in proportion to revenue. Working capital growing from $1,200,000 (12% x $10M) to $1,920,000 (12% x $16M) represents a $720,000 cash investment that must be funded. This appears as a use of cash in the operating section (increases in current assets and/or decreases in current liabilities). Option A incorrectly treats a stable ratio as implying zero cash impact. Option B dismisses a material cash flow implication. Option C describes an improvement scenario, not the forecasted scenario of a stable ratio with growing revenue.
  17. A financial forecast was prepared in January. By April, commodity input costs increased 18% and a customer representing 15% of revenue announced a supplier change. Which response is most analytically appropriate?
    Answer: Revise the forecast to reflect the changed assumptions; the original forecast is no longer a reliable basis for decision-making when two material assumptions have been invalidated A financial forecast is only useful as a decision-making tool when it reflects current best estimates. When material assumptions change - an 18% input cost increase and the loss of a 15% revenue customer are both clearly material - the forecast must be updated. Continuing to use an outdated forecast exposes management to making decisions based on information known to be wrong. Option A prioritizes consistency over accuracy, defeating the purpose of forecasting. Option C establishes an arbitrary materiality threshold for revision rather than responding to known changes in inputs. Option D defers a decision that should be clear given the materiality of the changes.
  18. A 5-year financial forecast shows revenue growing at 20% annually while operating income grows at 35% annually. The operating expense ratio (OpEx/Revenue) declines from 32% to 19% over the forecast horizon. Which concern is most relevant to this forecast?
    Answer: The improving operating leverage requires specific, identified cost reduction initiatives or documented scale economies; an unexplained decline in the OpEx ratio from 32% to 19% without explicit drivers is a common source of unwarranted optimism in financial forecasts A 13-percentage-point improvement in the OpEx ratio over 5 years is a substantial and specific claim. Without named cost reduction programs, documented economies of scale, or identified efficiency initiatives, this type of smooth improvement reflects a modeling assumption rather than a grounded projection. Forecasting errors frequently arise when analysts assume margins will improve without identifying the specific mechanisms. Option B makes an absolute claim about growth rates. Option C makes an unsupported generalization about operating leverage. Option D is an overstated rejection that fails to identify the specific analytical issue.
  19. A company projects net income of $480,000. Beginning total assets are $4,800,000 and ending total assets are projected at $5,400,000. What is forecasted ROA using average total assets?
    Answer: 9.4% Average total assets = ($4,800,000 + $5,400,000) / 2 = $5,100,000. ROA = $480,000 / $5,100,000 = 9.4%. Option A uses beginning assets only ($480,000 / $4,800,000). Option B uses a different denominator. Option D uses beginning assets ($480,000 / $3,840,000 - incorrect).
  20. A company's current retained earnings balance is $1,800,000. The income forecast projects net income of $420,000 and dividend payments of $140,000. What is the projected ending retained earnings balance?
    Answer: $2,080,000 Ending retained earnings = Beginning retained earnings + Net income - Dividends = $1,800,000 + $420,000 - $140,000 = $2,080,000. Retained earnings is the cumulative sum of net income less dividends paid; it serves as the link between the income statement and the balance sheet in a pro forma model. Option A omits the dividend deduction. Option C omits net income from the calculation. Option D adds dividends instead of subtracting them.

Start this quiz