Group 11: Analytical Procedures
30 original descriptive cases. Descriptive mix: 7 at 3 marks, 17 at 5 marks, 6 at 10 marks.
Original practice, not ICAI questions, official suggested answers or an official examiner scheme. Equivalent correct work is credited within the stated caps. Public practice availability is not full official question-bank completion.
Supplied numerical assumptions and limits are exercise facts, not statutory thresholds. Source boundary: module4 groups confirmation/reconciliation examples under analytical-purpose discussion; direct confirmation is not automatically analytics under SA520 paragraph4.
AUD-G11-D001 · 3 marks
A confirmation is not automatically an analytical procedure
The auditor receives a debtor balance confirmation and separately compares revenue to independently supported units sold and contract prices. The junior labels both analytical solely because each helps judge the accounts.
Required: Classify the two procedures and state the analytical investigation boundary. (3 marks)
Show answer and marking
Non-credit errors
- Do not convert every evidence procedure into analytics.
Official ICAI concept source, SA 520 paragraphs 4/7/A1-A3AUD-G11-D002 · 5 marks
Three uses, not one substitute
An audit file uses revenue trends while understanding the entity, a supported expense model at assertion level, and a near-end review of statement consistency. The trainee says the early trend means the near-end procedure is optional and SA520 governs every risk-assessment requirement.
Required: Explain the three purposes and two scope limits. (5 marks)
Show answer and marking
Non-credit errors
- No planning-trend exemption from near-end review.
Official ICAI concept source, SA 520 paragraphs 1/3/5-6/A17-A19AUD-G11-D003 · 5 marks
Sales changed, the old margin model did not
Last year the entity sold one stable product. This year it has new services, volatile prices and a large change in mix. The team applies last-year gross margin to all current revenue as its sole substantive evidence.
Required: Evaluate suitability, assertion/risk, model relationship, detail work and evidence limits. (5 marks)
Show answer and marking
Non-credit errors
- No historical ratio necessarily remains a precise current model.
Official ICAI concept source, SA 520 paragraphs 5(a)/A6/A8-A10AUD-G11-D004 · 5 marks
A target budget becomes the expectation
Management supplies a sales budget designed as an ambitious target. It was edited after year-end to match actual totals and has no reliable preparation controls. The auditor calls it independent expected-results evidence.
Required: Apply source, comparability, nature/relevance, controls and response. (5 marks)
Show answer and marking
Non-credit errors
- No edited-to-actual budget creates independent corroboration.
Official ICAI concept source, SA 520 paragraphs 5(b)/A5/A12-A14AUD-G11-D005 · 10 marks
Payroll expectation with two stable groups
For this exercise, reliable independently checked data show 24 employees at Rs 30,000 monthly throughout the year and 6 additional employees at Rs 25,000 monthly for exactly the final four months. No bonuses, overtime or other payroll elements apply. Recorded expense is Rs 95 lakh. The exercise supplies an acceptable difference of Rs 1 lakh, not a statutory threshold.
Required: Calculate each group and total expectation, compare actuals, apply the supplied limit, explain reliability/precision and design investigation without declaring fraud. (10 marks)
Show answer and marking
Non-credit errors
- No difference alone establishes fraud or a mandatory adjustment.
Official ICAI concept source, SA 520 paragraphs 5/7/A6-A7/A12/A15-A16/A20-A21AUD-G11-D006 · 5 marks
An exact sum, an imprecise expectation
A model produces a perfectly calculated estimate of discretionary advertising based only on last-year expense. Spending strategy changed and monthly information is available. The auditor says correct arithmetic proves precision.
Required: Explain predictability, detail, information, reliability and detection precision. (5 marks)
Show answer and marking
Non-credit errors
- No correct arithmetic equals adequate expectation precision.
Official ICAI concept source, SA 520 paragraphs 5(c)/A15AUD-G11-D007 · 3 marks
Higher risk, wider tolerance?
After new evidence increases assessed risk, the team widens the acceptable unexplained difference solely to avoid extra work. No changed materiality or better model supports the decision.
Required: Explain risk, materiality/aggregation and the workload argument. (3 marks)
Show answer and marking
Non-credit errors
- No convenience-based tolerance increase.
Official ICAI concept source, SA 520 paragraphs 5(d)/A16AUD-G11-D008 · 5 marks
Management explains a fall in margin
The analytical procedure finds a significant margin fall inconsistent with supported information. Management says a promotion caused it but gives no records. The auditor stops after the explanation.
Required: Explain investigation trigger, inquiry, corroboration, other work and conclusion limit. (5 marks)
Show answer and marking
Non-credit errors
- No inquiry-only closure or automatic fraud inference.
Official ICAI concept source, SA 520 paragraphs 7/A20-A21AUD-G11-D009 · 5 marks
Overall review reveals a new issue
Near the end, statement-level analytics reveal an unexpected receivable/revenue relationship not previously recognised. The team says the file is already final and overall review only confirms earlier conclusions.
Required: Explain review purpose, new risk, reassessment, further work and overall conclusion. (5 marks)
Show answer and marking
Non-credit errors
- No final-stage exemption from new risk response.
Official ICAI concept source, SA 520 paragraphs 6-7/A17-A19AUD-G11-D010 · 10 marks
Occupancy model with a significant unexplained gap
For this exercise, independently checked records show 10 rentable apartments, fixed rent Rs 20,000 per occupied apartment-month and 90 occupied apartment-months during the year. No concessions, variable charges or other rental elements apply. Recorded rental income is Rs 19.2 lakh. The supplied acceptable difference is Rs 0.5 lakh. Management attributes all of the gap to "normal vacancies" even though occupied months already reflect vacancies.
Required: Calculate capacity, vacancy and income expectation, assess the difference, explain model evidence and investigate the explanation. (10 marks)
Show answer and marking
Non-credit errors
- No double vacancy deduction or invented balancing charge.
Official ICAI concept source, SA 520 paragraphs 5/7/A8/A12/A15-A16/A20-A21AUD-G11-D011 · 5 marks
The industry average is for a different business
A specialised manufacturer is compared with a broad retail-industry margin. The external publication is reputable, but business models, products and accounting periods differ. The auditor treats independence of source as sufficient comparability.
Required: Explain source, comparability, relevance, supplementation and conclusion limits. (5 marks)
Show answer and marking
Non-credit errors
- No independent source automatically means comparable.
Official ICAI concept source, SA 520 paragraphs 5(b)/A12(a)-(c)AUD-G11-D012 · 5 marks
Branches offset in the group total
A diversified group shows an unchanged overall margin. One branch margin rises sharply and another falls. Reliable branch-level data are available. The auditor proposes ignoring the branch movements because the net movement is zero.
Required: Apply disaggregation, precision, relationships, investigation and the aggregation limit. (5 marks)
Show answer and marking
Non-credit errors
- No unchanged consolidated ratio proves all branches sound.
Official ICAI concept source, SA 520 paragraphs 5(c)/7/A15AUD-G11-D013 · 5 marks
Accurate invoices, doubtful units
A sales model uses unit counts from a system whose non-financial-data controls were never evaluated. Invoice amounts were tested, but the unit-count field includes cancelled orders. The team assumes audited money totals validate every non-financial input.
Required: Explain source-data reliability, controls, cancelled orders, alternative evidence and scope. (5 marks)
Show answer and marking
Non-credit errors
- No financial-total testing automatically validates all units.
Official ICAI concept source, SA 520 paragraphs 5(b)/A12(d)-A14AUD-G11-D014 · 3 marks
A good model with unavailable data
The auditor proposes a volume-price prediction, but reliable volume information is unavailable and no supported substitute is found. The spreadsheet contains a guessed quantity selected to match actual revenue.
Required: Explain availability, reliability and alternative response. (3 marks)
Show answer and marking
Non-credit errors
- No actual-fitted guess supplies independent volume evidence.
Official ICAI concept source, SA 520 paragraphs 5(b)-(c)/A15AUD-G11-D015 · 10 marks
Two product margins, one misleading total
Under this exercise supplied assumptions, reliable revenue is Rs 60 lakh for Product A and Rs 40 lakh for Product B. Supported expected gross margins are respectively 30% and 10%. Actual reported gross profit is Rs 21 lakh. A junior applies a simple unweighted 20% margin to all sales. The exercise supplied acceptable difference is Rs 1 lakh, and differences above it require investigation. No other products apply.
Required: Calculate expected profit by product, aggregate margin and the junior error; compare actuals, apply the supplied limit and explain evidence-backed investigation. (10 marks)
Show answer and marking
Non-credit errors
- No unweighted average for unequal sales weights; threshold not statutory.
Official ICAI concept source, SA 520 paragraphs 5(b)-(d)/7/A12/A15-A16AUD-G11-D016 · 5 marks
Interim data do not cover the final quarter
The auditor performed substantive analytics for nine months using reliable inputs. Production rates and prices change in the final quarter. The team rolls the nine-month ratio through the remaining period without new information.
Required: Explain period coverage, data reliability, changed relationship, updated expectation and response. (5 marks)
Show answer and marking
Non-credit errors
- No reliable interim model proves unexamined remaining period.
Official ICAI concept source, SA 520 paragraphs 5/A6/A14AUD-G11-D017 · 5 marks
A public service is not a retail business
A public-sector road programme has no direct sales/expenditure relationship and no comparable retail-industry ratios. Reliable road-length and cost information is available, but the team imports a retailer sales margin as its expectation.
Required: Explain relevance, alternative relationship, comparability, reliability and investigation limits. (5 marks)
Show answer and marking
Non-credit errors
- No unrelated retail benchmark or automatic corruption finding.
Official ICAI concept source, SA 520 paragraphs 5(a)-(b)/7/A11-A12AUD-G11-D018 · 3 marks
Simple is not automatically weak
A supported, stable recurring expense model is simple. A second model uses sophisticated statistics but unreliable inputs. The reviewer chooses the second only because the technique is more complex.
Required: Explain method, evidence and suitability. (3 marks)
Show answer and marking
Non-credit errors
- No advanced-method label guarantees better evidence.
Official ICAI concept source, SA 520 paragraphs 5/A3-A8AUD-G11-D019 · 5 marks
Collectability needs more than the ageing shape
The auditor uses a reliable receivable ageing analysis for valuation and also tests subsequent receipts. A manager asks the team to discard receipt tests because the ageing ratio appears normal.
Required: Explain combination, assertion, normality limit, reliability and response. (5 marks)
Show answer and marking
Non-credit errors
- No normal ageing ratio automatically replaces collectability detail evidence.
Official ICAI concept source, SA 520 paragraphs 5/7/A10/A12/A15AUD-G11-D020 · 10 marks
Production energy model with a rate change
For this exercise, verified production is 8,000 units in each half-year. Energy use is reliably established at 5 kWh per unit, with no idle/base charges or other components. Rates are Rs 6 per kWh for the first half and Rs 8 for the second. Actual recorded expense is Rs 5.9 lakh. The supplied acceptable unexplained difference is Rs 0.2 lakh. Management says the rate increase explains all difference from the model.
Required: Compute each half, full expectation and incorrect constant-rate expectation; assess the gap and evidence/investigation. (10 marks)
Show answer and marking
Non-credit errors
- No old-rate comparison or already-modelled rate effect closes residual difference.
Official ICAI concept source, SA 520 paragraphs 5/7/A6/A12/A15-A16/A20-A21AUD-G11-D021 · 5 marks
The expectation copies the recorded amount
A revenue expectation multiplies quantity and price fields derived by dividing the recorded revenue itself. No separate reliable quantity or price evidence is used. The model always agrees exactly with the ledger.
Required: Explain circularity, input evidence, apparent precision, alternative work and conclusion. (5 marks)
Show answer and marking
Non-credit errors
- No algebraic restatement creates independent evidence.
Official ICAI concept source, SA 520 paragraphs 5(a)-(c)/A6/A12/A15AUD-G11-D022 · 3 marks
No explanation, no closure
A significant inconsistent fluctuation is identified. Management cannot explain it. The auditor documents "unexplained" and treats that label as the completed investigation.
Required: Explain inquiry, further procedures and conclusion limit. (3 marks)
Show answer and marking
Non-credit errors
- No unexplained label closes a significant inconsistency.
Official ICAI concept source, SA 520 paragraphs 7/A20-A21AUD-G11-D023 · 3 marks
A ratio cannot prove ownership
A revenue analytics model has reliable data and a precise supported expectation. The team says its result also proves legal ownership of a property because the property earns that revenue.
Required: Explain assertion suitability and the necessary evidence boundary. (3 marks)
Show answer and marking
Non-credit errors
- No revenue-model success proves property ownership.
Official ICAI concept source, SA 520 paragraphs 5(a)/A9AUD-G11-D024 · 5 marks
A supplied limit is rewritten after the result
Before work, the auditor determines a supported acceptable difference. Actual results exceed it. The team raises the limit solely until the difference falls below it, with no new model, risk or materiality evidence.
Required: Explain criterion, hindsight, risk/materiality, investigation and revised judgment limits. (5 marks)
Show answer and marking
Non-credit errors
- No result-fitted acceptable difference.
Official ICAI concept source, SA 520 paragraphs 5(d)/7/A16AUD-G11-D025 · 5 marks
Two definitions of gross margin
The entity margin is calculated after a category of production overhead, while an otherwise comparable benchmark excludes it. The team compares the percentages without reconciling definitions and calls the gap a sales error.
Required: Explain definition comparability, relevance, reconciliation, precision and conclusion. (5 marks)
Show answer and marking
Non-credit errors
- No raw ratio gap automatically establishes sales error.
Official ICAI concept source, SA 520 paragraphs 5(b)-(c)/7/A12(b)-(c)/A15AUD-G11-D026 · 3 marks
Detail testing is not always mandatory after every model
A reliable, sufficiently precise predictable income model uses appropriately verified elements and meets the assertion/risk objective. The reviewer says analytics can never provide persuasive substantive evidence without identical duplicate detail testing.
Required: Explain possible strength, conditions and the no-guarantee limit. (3 marks)
Show answer and marking
Non-credit errors
- No never-sufficient or always-sufficient analytics rule.
Official ICAI concept source, SA 520 paragraphs 5/A4/A8-A9AUD-G11-D027 · 5 marks
Trend dates do not align
Current-year revenue covers twelve months, but the comparative dataset covers nine months and a different seasonal mix. The team calls the percentage movement a like-for-like annual trend.
Required: Explain period comparability, seasonality, evidence, expectation and investigation. (5 marks)
Show answer and marking
Non-credit errors
- No unequal-period comparison is automatically annual growth evidence.
Official ICAI concept source, SA 520 paragraphs 5(b)-(c)/7/A1/A12/A15AUD-G11-D028 · 5 marks
One unusual relationship, two purposes
A simple year-on-year comparison helped identify a possible risk at planning. Later the team reuses it unchanged as sole substantive evidence for a complex assertion, without defining precision or an acceptable difference.
Required: Explain purpose, suitability, reliability, precision and acceptable difference. (5 marks)
Show answer and marking
Non-credit errors
- No planning-useful means substantively sufficient.
Official ICAI concept source, SA 520 paragraphs 1/5/7/A4-A6AUD-G11-D029 · 10 marks
Sales ratio diluted by the wrong denominator
For this exercise, verified net sales are Rs 120 lakh and cost of sales Rs 90 lakh. A schedule adds an unrelated asset disposal receipt of Rs 30 lakh to the denominator and presents gross profit Rs 30 lakh as a "20% sales margin". A properly comparable supported expected gross margin is 25%. No other sales/cost components apply. The auditor treats apparent 20% versus 25% as proof of a sales misstatement.
Required: Calculate correct and erroneous ratios, diagnose the comparison, and explain evidence/design and conclusion limits. (10 marks)
Show answer and marking
Non-credit errors
- No contaminated denominator proves a sales misstatement.
Official ICAI concept source, SA 520 paragraphs 5/7/A1-A2/A12/A15-A16AUD-G11-D030 · 10 marks
Review memo closes every issue with a verbal explanation
Near-end analytics reveal different issues: component revenue patterns inconsistent with reliable operating information; a changed business model not reflected in the expectation; an apparent ratio gap caused by non-comparable definitions; and a disclosure inconsistent with the auditor understanding. The memo says "management explained everything", records no supporting evidence and declares all assertions fully verified.
Required: Correct five issue/evidence decisions and explain five overall-review limits/actions. (10 marks)
Show answer and marking
Non-credit errors
- No inquiry-only global closure or all-assertions guarantee.
Official ICAI concept source, SA 520 paragraphs 5-7/A6/A12/A17-A21