Variance and Trend Analysis

Variance and Trend Analysis (CIA Part 2: Information Gathering, Analysis and Evaluation)

Overview
Variance and trend analysis are analytical review procedures. Internal auditors use them during engagement planning, fieldwork and evaluation to find anomalies, unexpected relationships and areas of higher risk. In CIA Part 2 (Practice of Internal Auditing), this topic sits within Information Gathering, Analysis and Evaluation. It is closely tied to the IIA Standards on identifying, analyzing, evaluating and documenting sufficient, reliable, relevant and useful information.

Why Variance and Trend Analysis Is Important
1. Efficient risk identification. These procedures help auditors focus limited resources on areas where something looks unusual. They support a risk-based audit plan.
2. Flags errors, fraud and inefficiency. Unexpected fluctuations may point to misstatements, control breakdowns, fraud, or simply changes in operations that management should explain.
3. Low cost, broad coverage. Analytical procedures can cover whole populations or long periods quickly, often with data analytics tools.
4. Supports conclusions. They provide evidence that balances or performance are reasonable. They also help corroborate other evidence.
5. Adds value to management. Explaining variances against budget or trends gives management insight into performance, efficiency and effectiveness.

What It Is
Analytical procedures evaluate information by studying plausible relationships among financial and non-financial data. The auditor compares actual results with expectations and investigates significant differences.

Variance analysis compares actual results with a benchmark, such as a budget, standard, forecast or prior period. It then measures and explains the difference.

• Favorable variance: actual revenue is above expected, or actual cost is below expected.
• Unfavorable (adverse) variance: actual revenue is below expected, or actual cost is above expected.

Trend analysis examines changes in a data item over several periods to identify patterns, direction and unusual deviations. One common form is horizontal analysis, which shows year-over-year changes in amounts and percentages.

Related analytical techniques often tested alongside them:

• Ratio analysis: relationships between items, such as the current ratio, gross margin or inventory turnover.
• Vertical (common-size) analysis: each item as a percentage of a base, such as sales or total assets.
• Reasonableness tests: building an independent expectation from operational data. For example, payroll expense is roughly employees × average wage × periods.
• Regression analysis: a statistical method that predicts a value from one or more independent variables. It is the most sophisticated and precise way to form expectations.
• Benchmarking: comparison with industry data, competitors or best practice.

How It Works
Step 1: Develop an expectation. Use prior periods, budgets, industry data, non-financial data such as units, headcount or square footage, and known business changes. The more precise and reliable the expectation, the more persuasive the procedure.
Step 2: Define a threshold. Decide in advance what size of difference counts as significant. It may be a fixed amount, a percentage, or both, based on materiality and risk.
Step 3: Compare and compute the difference. Calculate each variance or trend change.
Step 4: Investigate significant differences. Ask management for explanations, then corroborate them with independent evidence such as documents, observation or third-party data. An explanation alone is not sufficient evidence.
Step 5: Evaluate and conclude. Decide whether the variance stems from a legitimate business reason, an error, a control weakness or possible fraud. Then decide whether more detailed testing is needed.
Step 6: Document. Record the expectation, data sources, threshold, results, explanations, corroboration and conclusions in the working papers.

Key Variance Formulas (Standard Costing)

• Direct materials price variance = (Actual price − Standard price) × Actual quantity purchased
• Direct materials quantity (usage) variance = (Actual quantity used − Standard quantity allowed for actual output) × Standard price
• Direct labor rate variance = (Actual rate − Standard rate) × Actual hours
• Direct labor efficiency variance = (Actual hours − Standard hours allowed) × Standard rate
• Sales price variance = (Actual price − Budgeted price) × Actual units sold
• Sales volume variance = (Actual units − Budgeted units) × Budgeted contribution margin per unit (or budgeted price, depending on the approach)

A flexible budget adjusts budgeted costs to the actual level of activity. This isolates efficiency and price effects from volume effects. A static budget comparison mixes these effects together.

Trend Analysis Example
Sales grew 3%, 4% and 5% over three years, but accounts receivable grew 25% in the latest year. That trend is inconsistent. Possible causes include fictitious sales, weakening collections, relaxed credit policies or cutoff errors. The auditor should investigate, for example by reviewing aging reports, testing subsequent cash receipts and confirming balances.

Factors Affecting Reliability

• Reliability of the source data. Data that is independent, audited or system-generated with good controls is more reliable.
• Level of disaggregation. Data by month, location or product gives a sharper picture than annual totals.
• Stability of the operating environment. Analytics are less effective when the business has changed significantly.
• Predictability of the relationship. Income statement items are often more predictable than balance sheet items.
• Availability of the information and the auditor's understanding of the business.

Limitations

• Analytics identify that something is unusual, not why.
• Offsetting errors can hide a problem, so an absence of variance does not prove accuracy.
• Results are only as good as the expectations and the data.
• Management explanations must be corroborated.

Exam Tips: Answering Questions on Variance and Trend Analysis
1. Know the purpose by phase. In planning, analytics identify risk areas and set the scope. In fieldwork, they provide substantive evidence. In wrap-up, they confirm overall reasonableness. Questions often ask which purpose fits a scenario.
2. The next step is usually to investigate and corroborate. When a significant unexpected variance appears, the best answer is typically to inquire of management and corroborate the explanation with evidence. Reject answers that accept management's explanation at face value. Also reject answers that jump straight to concluding fraud.
3. Absence of an expected change is also a red flag. If sales rose sharply but commissions stayed flat, or production rose but utilities did not, investigate.
4. Pick the most precise technique when asked. Regression analysis is the most sophisticated and precise way to form an expectation. Simple comparisons with the prior year are the least precise.
5. Use non-financial data. Answers that relate financial data to independent operational data, such as headcount, square footage or production volume, are usually stronger.
6. Watch the variance sign conventions. Higher costs or lower revenue than expected is unfavorable. Get the formula structure right: price or rate variances use actual quantity, and usage or efficiency variances use standard price.
7. Prefer flexible budgets for performance evaluation. If a question asks how to evaluate a manager's cost control, comparing against a flexible budget at actual activity is fairer than a static budget.
8. Think about causes of variances. A favorable materials price variance with an unfavorable usage variance may mean lower-quality materials were bought. An unfavorable labor efficiency variance may come from poor materials, inexperienced workers or machine downtime. Identify who is responsible: purchasing for price, production for usage.
9. Disaggregate for sensitivity. Questions may ask how to make analytics more effective. Use more detailed data, by month, location or product line, rather than aggregated annual totals.
10. Remember the limitations. Analytics alone rarely give sufficient evidence in high-risk areas. Combine them with tests of details.
11. Link to fraud indicators. Revenue growing faster than cash flow, receivables outpacing sales, rising inventory with falling turnover, and unusual gross margin changes are classic warning signs.
12. Calculation questions. Write out the formula, plug in carefully, and label each result favorable or unfavorable. Check whether the question uses quantity purchased or quantity used for the price variance.
13. Eliminate extreme answers. Options that say "always," "conclusive proof," or "no further work needed" are usually wrong.

Quick Practice Scenario
An internal auditor notices that repairs and maintenance expense rose 40% while fixed assets and production remained stable. What should the auditor do first?
Best answer: ask management for an explanation and corroborate it, for example by examining invoices and work orders to see whether capital items were expensed or costs were misclassified. Reporting fraud immediately or ignoring the variance would be inappropriate.

Summary
Variance and trend analysis compare actual data with well-founded expectations to find unusual items. The auditor then investigates significant differences, corroborates the explanations, and documents the conclusions. For the exam, master the steps, the variance formulas and their interpretation, how precise each technique is, and the principle that unexpected results, or the unexpected absence of change, require corroborated follow-up.