40.1 BAR Ratio, Variance, and Government Drill

BAR workbook drill: ratios, variances, and governments

Business Analysis and Reporting (BAR) is one of the three discipline sections of the CPA Exam. It runs four hours and contains 50 multiple-choice questions (MCQs) across two testlets plus 7 task-based simulations (TBSs) across three testlets. MCQs and simulations each count 50 percent of the scaled score, and you need a 75 on the 0 to 99 scale to pass. Because half your points come from simulations, BAR practice must feel like a controlled simulation: do not stop at recalling the current ratio, the debt-to-equity ratio, or a flexible-budget variance label.

A BAR answer usually needs a calculation, a reason the number changed, and a conclusion tied to liquidity, profitability, covenant pressure, segment performance, forecasting, or governmental reporting.

Drill packet setup

Use one clean workbook page per drill. At the top, write the scenario type before you calculate: for-profit operating analysis, technical accounting support, or state and local government reporting. That first label prevents the most common BAR error, applying the right formula to the wrong reporting model.

Ratio drill workflow

1. Compute the ratio exactly as requested.
2. Recompute it for the comparison period or the covenant threshold.
3. Decide whether the movement is favorable, unfavorable, or mixed.
4. Tie the movement to an account-level cause, not a vague business statement.
5. Write one sentence naming the decision risk.

Example: a manufacturer has higher current assets, but inventory doubled while cash fell and accounts payable rose. The current ratio (current assets divided by current liabilities) may rise from 1.6 to 2.0, yet the quick ratio ((current assets minus inventory) divided by current liabilities) can fall. The stronger BAR conclusion is not that liquidity improved; it is that liquidity quality weakened because more resources are tied up in inventory and supplier financing, raising the risk of breaching a working-capital covenant.

Variance drill workflow

Variance questions reward structure. First decide whether the item asks for a static-budget variance, a flexible-budget variance (actual results versus a budget flexed to actual volume), a sales-volume variance, a direct-material price or quantity variance, a labor-rate or labor-efficiency variance, or an overhead variance. Write the formula before the numbers; one slow line prevents sign errors.

• Direct-material price variance = actual quantity x (actual price minus standard price).
• Direct-material quantity variance = standard price x (actual quantity used minus standard quantity allowed for actual output).
• Favorable (F) means actual cost is below standard for the measured input.
• Unfavorable (U) means actual cost is above standard.
• Interpretation must separate purchasing responsibility (price) from production responsibility (quantity) when the facts allow it.

Government accounting switch drill

When a BAR case names a city, county, school district, special revenue fund, debt service fund, capital projects fund, or governmental activities, stop and switch models. Governmental fund statements use the current financial resources measurement focus and modified accrual, emphasizing fiscal accountability. Government-wide statements use the economic resources measurement focus and full accrual, emphasizing operational accountability.

Given a governmental fund balance sheet, list the adjustments that reconcile fund balances to governmental activities net position. Common reconciling items: add capital assets, subtract accumulated depreciation, subtract long-term debt and accrued interest, fold in internal service fund balances, and adjust revenue recognized under modified accrual but deferred under accrual (the availability concept). State whether each adjustment increases or decreases net position.

Ten-minute mixed BAR drill

Set a ten-minute timer: compute two ratios, prepare one variance, and identify three government reconciliation adjustments. At minute eight, stop calculating and write conclusions. Candidates lose points by producing unsupported numbers. Log every miss as a calculation error (formula or arithmetic failed), a classification error (treated for-profit as governmental or vice versa), or an interpretation error (number right, conclusion incomplete). Retake only the failed drill type; do not restart all BAR content each time a narrow skill breaks.

Common BAR traps to rehearse

BAR exhibits are written to reward candidates who slow down for one extra step. Rehearse these recurring traps until your reaction is automatic:

• Sign and direction. A favorable variance lowers cost; a favorable revenue variance raises revenue. Write F or U next to every figure so a positive number never gets read as good news by default.
• Days outstanding ratios. Days sales outstanding equals 365 divided by receivables turnover, and receivables turnover uses net credit sales over average receivables. Mixing total sales with net credit sales is a classic miss.
• Average versus year-end balances. Activity ratios use average balances; many candidates plug year-end balances and produce a defensible but wrong number.
• Fund type identification. A capital projects fund accounts for construction, a debt service fund for principal and interest, and a special revenue fund for legally restricted revenue sources. Choosing the wrong fund derails the whole simulation.
• Modified accrual revenue timing. Property taxes are recognized in governmental funds only when measurable and available (collected within the period or soon enough after year-end, commonly 60 days), which differs from full-accrual recognition government-wide.
• Encumbrances are not expenditures. An encumbrance reserves budget for a purchase order; it becomes an expenditure only when the goods or services are received. Treating an open encumbrance as an expense overstates spending.

When a drill exposes one of these traps, copy the exact exhibit line that fooled you onto a flashcard and reread it before the next timed set. The goal is to make the trap visible the instant it reappears, because BAR rarely gives you a second exhibit to confirm your first read.