Audit analytical procedures

5 PAGES RESEARCH

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Advances in Accounting Education: Teaching and
Curriculum Innovations

  • Analytical Procedures: An In-Class Exercise
  • Chris Bagwell, Linda A. Quick, Scott D. Vandervelde,

    Article information:
    To cite this document: Chris Bagwell, Linda A. Quick, Scott D. Vandervelde,
    “Analytical Procedures: An In-Class Exercise” In Advances in Accounting Education:
    Teaching and Curriculum Innovations. Published online: 06 Mar 2017; 51-78.
    Permanent link to this document:
    http://dx.doi.org/10.1108/S1085-462220170000020004

    Downloaded on: 04 April 2017, At: 06:08 (PT

    Save Time On Research and Writing
    Hire a Pro to Write You a 100% Plagiarism-Free Paper.
    Get My Paper

    )

    References: this document contains references to 0 other documents.
    To copy this document: permissions@emeraldinsight.com
    The fulltext of this document has been downloaded 8 times since 2017*

    Access to this document was granted through an Emerald subscription provided by
    emerald-srm:397875 []

    For Authors
    If you would like to write for this, or any other Emerald publication, then please
    use our Emerald for Authors service information about how to choose which
    publication to write for and submission guidelines are available for all. Please visit
    www.emeraldinsight.com/authors for more information.

    About Emerald www.emeraldinsight.com
    Emerald is a global publisher linking research and practice to the benefit of society.
    The company manages a portfolio of more than 290 journals and over 2,350 books
    and book series volumes, as well as providing an extensive range of online products
    and additional customer resources and services.

    Emerald is both COUNTER 4 and TRANSFER compliant. The organization is a partner
    of the Committee on Publication Ethics (COPE) and also works with Portico and the
    LOCKSS initiative for digital archive preservation.

    *Related content and download information correct at time of download.

    D
    ow

    nl
    oa

    de
    d

    by
    N

    at
    io

    na
    l U

    ni
    ve

    rs
    ity

    o
    f

    Si
    ng

    ap
    or

    e
    A

    t 0
    6:

    08
    0

    4
    A

    pr
    il

    20
    17

    (
    PT

    )

    http://dx.doi.org/10.1108/S1085-462220170000020004

    ANALYTICAL PROCEDURES:

    AN IN-CLASS EXERCISE

    Chris Bagwell, Linda A. Quick and

    Scott D. Vandervelde

    ABSTRACT

    We have designed this in-class exercise to benefit undergraduate or grad-
    uate students enrolled in courses in auditing. This in-class exercise
    involves six short independent analytical procedures scenarios, two each
    for three different accounts: Payroll Expense; Depreciation Expense;
    and Interest Expense. The scenarios require students to perform substan-
    tive analytical procedures for each of the financial statement accounts.
    Students must use their accounting knowledge, analytical thinking skills,
    and problem-solving ability in order to compute an estimated expectation
    for an account balance. Following computing an estimate of the expected
    balance, students must then compare the result to the client-recorded
    balance and determine if the difference is within tolerable limits

    Advances in Accounting Education: Teaching and Curriculum Innovations, Volume 20, 51�78
    Copyright r 2017 by Emerald Publishing Limited

    All rights of reproduction in any form reserved

    ISSN: 1085-4622/doi:10.1108/S1085-462220170000020004

    51

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    http://dx.doi.org/10.1108/S1085-462220170000020004

    established for the audit. The primary learning objectives for the in-class
    analytical procedures exercise involve the following:

    1. Understanding when it might be appropriate for the auditor to
    perform substantive analytical procedures,

    2. Understanding how to form an expectation of an account balance
    when performing analytical procedures, and

    3. Understanding how to evaluate the results of a substantive analytical
    procedure.

    In cooperation with KPMG, we believe that the analytical procedures
    exercise gives students a better understanding of performing substantive
    analytical procedures.1 As identified by Auditing Standard AU-C 520,
    PCAOB Standard AS 2305, and in the academic literature (e.g., Hirst
    & Koonce, 1996), analytical procedures are an important part of the
    audit process. Understanding when and how to perform substantive
    analytical procedures, combined with how to evaluate the results, will aid
    in student knowledge of the audit process.

    Keywords: Analytical procedures; substantive testing; undergraduate
    auditing

    While analytical procedures have been part of a financial statement audit
    for decades (e.g., PCAOB AS 2305, effective for audits of financial state-
    ments for periods beginning on or after January 1, 1989), Public Company
    Accounting Oversight Board inspections from 2004 to 2007 revealed that
    auditors need to improve the performance of analytical procedures
    (PCAOB, 2008). In the report, the board stated:

    Inspection teams have identified deficiencies in firms’ performance of analytical proce-

    dures that the firms intended to be substantive tests, including the failure to (a) develop

    appropriate expectations, including in some instances the failure to appropriately dis-

    aggregate data in order to obtain the necessary level of precision for the expectation,

    (b) establish a threshold for differences that the firm could accept without further inves-

    tigation, (c) establish a threshold for differences that was low enough to provide

    the level of assurance that the firm planned to achieve from the test, (d) test the data

    that the firm used in the analytical procedures, (e) investigate significant unexpected

    differences from the firm’s expectations, and (f) examine other evidence to obtain cor-

    roboration of management’s explanations regarding significant unexpected differences.

    (PCAOB, 2008, p. 15)

    52 CHRIS BAGWELL ET AL.

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    As indicated by the inspection report, auditors make errors when perform-
    ing analytical procedures, thus highlighting the need for continued learning
    at all levels.

    The importance of performing substantive analytical procedures is
    highlighted in the recent guidance in AU-C 520 (AICPA, 2012; effective for
    audits of financial statements for periods ending on or after December 15,
    2012). AU-C 520.05 provides steps the auditor is to take when performing
    analytical procedures either in conjunction with other substantive proce-
    dures or as substantive procedures.2 The analytical procedures the students
    perform during this in-class exercise are consistent with what is proscribed
    in the standard.

    A significant amount of accounting research has been performed related
    to analytical procedures.3 In a field study, Hirst and Koonce (1996) find
    that the techniques being used in practice to estimate balances when per-
    forming substantive analytical procedures are regularly used and they are
    used to decrease other substantive testing which is more time-consuming
    (Trompeter & Wright, 2010). Additionally, analytical procedures are fre-
    quently being performed by lower level staff auditors (Trompeter &
    Wright, 2010). Moreno, Bhattacharjee, and Brandon (2007) found that stu-
    dents who were trained in certain ways performed as well as practicing
    auditors on analytical procedure tasks. One of those training methods was
    using “worked-out examples.” Therefore, substantive analytical procedure
    techniques are important for students to learn, in order to increase the like-
    lihood of performing high quality audit

    procedures.

    This in-class exercise involves six short independent analytical proce-
    dures scenarios, two each for three different accounts: Payroll Expense;
    Depreciation Expense; and Interest Expense. The scenarios require students
    to perform substantive analytical procedures for each of these financial
    statement accounts. Students must use their accounting knowledge, analyti-
    cal thinking skills, and problem-solving ability in order to compute an esti-
    mated expectation for an account balance. After computing an estimate of
    the expected balance, students must then compare the result to the client-
    recorded balance and determine if the difference is within tolerable limits
    established for the audit. While these scenarios have been very effective for
    the authors as an in-class exercise, instructors could also assign any or all
    of them as out-of-class work; however, some of the benefit of the in-class
    exercise is having practicing auditors act as facilitators during the class
    period. The original scenarios were designed for KPMG firm-wide training,
    thus having KPMG personnel facilitating provides valuable insight for the
    students in addition to providing further opportunity for students to

    53Analytical Procedures: An In-Class Exercise

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    interact with professionals and continue to refine interpersonal communica-
    tion skills. The KPMG personnel also add credibility to the use of analyti-
    cal procedures that is not always achieved by just being covered by
    accounting faculty.

    LEARNING OBJECTIVES AND IMPLEMENTATION
    GUIDANCE

    While we have experienced great success in using these scenarios during
    class with a KPMG professional leading the discussion, instructors can use
    these scenarios without any assistance from a representative from the pro-
    fession. KPMG representatives (including one of the co-authors on this
    chapter) have been coming to our Audit 1 class for eight years to partici-
    pate in the in-class learning case scenarios presented in this chapter.
    Students have regularly responded very favorably to this exercise and
    greatly appreciate the involvement of representatives from the profession
    (typically alumni from the participating school) during the class period in
    leading the exercise discussion. Having accounting firm professionals
    involved increases the credibility of the procedures from the student’s per-
    spective. Although professional communication skills are not one of the ini-
    tial primary objectives, it also continues to help them develop these skills
    by interacting with professionals. Even without assistance from a represen-
    tative from the profession in class, the nature of the scenarios lends them-
    selves to active discussion, thus enhancing professional communication
    skills of the students. KPMG personnel originally created the case scenar-
    ios for in-house training related to

    analytical procedures.

    Learning Objectives

    The primary learning objectives for the in-class exercise involve the following:

    1. Understanding when it might be appropriate for the auditor to perform
    substantive analytical procedures,

    2. Understanding how to form an expectation of an account balance when
    performing analytical procedures, and

    3. Understanding how to evaluate the results of a substantive analytical
    procedure.

    54 CHRIS BAGWELL ET AL.

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Understanding When to Perform Substantive Analytical Procedures
    AU-C 520.05 identifies when to perform substantive analytical procedures
    and the general approach to performing such procedures:

    When designing and performing analytical procedures, either alone or in combination

    with tests of details, as substantive procedures in accordance with section 330, the audi-

    tor should (Ref: par. A7-.A9)

    a. Determine the suitability of particular substantive analytical procedures for given

    assertions, taking into account the assessed risks of material misstatement and tests

    of details, if any, for these assertions; (Ref: par. A10-.A16)

    b. Evaluate the reliability of data from which the auditor’s expectation of recorded

    amounts or ratios is developed, taking into account the source, comparability, and

    nature and relevance of information available and controls over preparation; (Ref:

    par. A17-.A20)

    As seen in the exercise, we incorporated some of this information into the
    exercise in the “required” section for the task and in telling the students the
    criteria that have been met which leads to the substantive analytical proce-
    dures being performed over the given accounts. Additionally, there are
    PowerPoint slides that the KPMG personnel used at the beginning of the
    class period to discuss when substantive analytical procedures might be
    appropriate to be performed in lieu of or in conjunction with test of details
    as a substantive procedure.4

    Understanding How to Form an Expectation of an Account Balance When
    Performing Analytical Procedures
    The authoritative guidance on “how” to form an expectation for an
    account balance starts with the definition of an analytical procedure in stat-
    ing the following (AU-C 520.04)5

    .04 For the purposes of generally accepted auditing standards, the following term has

    the meaning attributed as follows:

    Analytical procedures. Evaluations of financial information through analysis of plausi-

    ble relationships among both financial and nonfinancial data. Analytical procedures

    also encompass such investigation, as is necessary, of identified fluctuations or relation-

    ships that are inconsistent with other relevant information or that differ from expected

    values by a significant amount. (Ref: par. A2-. A6)

    Understanding How to Evaluate the Results of a Substantive
    Analytical Procedure

    a. Develop an expectation of recorded amounts or ratios and evaluate whether the

    expectation is sufficiently precise (taking into account whether substantive

    55Analytical Procedures: An In-Class Exercise

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    analytical procedures are to be performed alone or in combination with tests of

    details) to identify a misstatement that, individually or when aggregated with other

    misstatements, may cause the financial statements to be materially misstated; and

    (Ref: par. A21-.A23)

    b. Determine the amount of any difference of recorded amounts from expected values

    that is acceptable without further investigation as required by paragraph .07 and

    compare the recorded amounts, or ratios developed from recorded amounts, with

    the expectations. (Ref: par. A24)

    When evaluating the results of substantive analytical procedures, the audi-
    tor must complete the following decision process:

    .07 If analytical procedures performed in accordance with this section identify fluctua-

    tions or relationships that are inconsistent with other relevant information or that differ

    from expected values by a significant amount, the auditor should investigate such differ-

    ences by

    a. inquiring of management and obtaining appropriate audit evidence relevant to

    management’s responses and

    b. performing other audit procedures as necessary in the circumstances. (Ref: par.

    A28-.A29) (AU-C 520.07)

    Implementation

    In collaboration with KPMG, we have always had audit personnel from
    the local KPMG office lead the discussion of the analytical procedures in-
    class exercises with our Audit 1 class.6 Typically there is at least one audi-
    tor at the manager level or above supported by one or two senior or staff
    level auditors.7 The first part of class is designed for the KPMG
    representative(s) to utilize the PowerPoint presentation to guide a discus-
    sion in a predominantly lecture format about the use of analytical proce-
    dures, including the important role that they play, how to perform
    substantive analytical procedures, and the implications of the results.8

    Following the slides covering substantive analytical procedures, the
    remainder of the time is spent working on the exercise scenarios. The exer-
    cise includes background information and instructions along with six short
    scenarios that require students to conduct analytical procedures on one of
    three financial statement accounts. Table 1 includes the background infor-
    mation and instructions that we distribute to the students. The instructions
    note that the student is acting as the auditor for a US-based client; the
    accounts in question are considered low risk, and thus substantive analyti-
    cal procedures are considered sufficient evidence; and the precision level for

    56 CHRIS BAGWELL ET AL.

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 1. Background and Instructions.

    Background

    You are the auditor of a United States client. You are entering the preliminary testing

    phase of the audit work program which instructs you to perform substantive analytical

    procedures in order to perform substantive test work over some previously identified low

    risk financial statement accounts. The internal controls testing surrounding these accounts

    have not uncovered any deficiencies that would preclude a lower control risk being included

    in the auditor’s risk assessment for the accounts. The financial statement accounts for

    which you are going to perform substantive analytical procedures meet all of the following

    criteria:

    1. The transactions within the account are routine and the results are reasonably predictable,

    2. The transactions within the account do not involve complex accounting standards or

    complex judgments by management, and

    3. There are relationships among data that exist and continue in the absence of known

    conditions to the contrary.a

    Given the low levels of risk of material misstatement surrounding these accounts, it has

    been indicated to you that performing a substantive analytical procedure over the accounts

    will provide sufficient appropriate audit evidence in order to conclude on the account

    balances and respective assertions. For the purposes of this exercise, it is assumed that the

    data you have received that will be used to form your expectations of the account has been

    separately subjected to sufficient appropriate audit procedures and is therefore reliable for

    use in the substantive analytical procedure to be performed. Following the determination of

    your expectation for the account balance, you are to compare any difference between what

    you calculate and the client-recorded account balance. It has been determined that the level

    of precision to be used in this comparison is ±5% of the expected balance that you
    calculate. If any difference between the expected balance and the recorded balance is within

    the ±5% precision, then no further investigation will be necessary. If the difference is
    greater than the ±5% precision level, then additional investigation will be necessary for an
    audit team in practice. For this exercise, you should consider the types of additional

    testing, but you will not be asked to actually perform it as it is beyond the scope of this

    activity. You will need to determine how the expected balance was calculated, what might

    have led to the difference, and what (if any) additional substantive testing might be

    necessary.

    Instruction

    Use the information provided in the exercise scenarios for each of the accounts to determine

    an expectation for the current year balance for each of the following scenarios. Compare the

    expected balance you calculate to the client-recorded balance. Conclude on whether the

    difference is within the ±5% level of precision and think about the implications of your
    findings for the audit. You should consider each scenario as independent of the other

    scenarios.

    aThese criteria are consistent with AU-C 520.5 and 520.A8.

    57Analytical Procedures: An In-Class Exercise

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    the analytical procedures is ±5% of the expected balance. The KPMG
    representative(s) first goes through a very brief introduction of each sce-
    nario. While each of the scenarios could be completed individually or in
    groups, we have always used groups of 3�5 students. We assign each group
    one of the scenarios and give them time to compute an expected value of
    the assigned account balance using the facts provided in each scenario.
    During this time the KPMG personnel (and professor) walk around and
    help groups as needed. We provide the solutions for all of the scenarios to
    the students following class for them to be able to review each scenario
    that was not assigned to their group. However, another option is to include
    the rest of the scenarios as an out-of-class assignment and provide the solu-
    tions at some later date.

    The first two scenarios, shown in Table 2 and Table 3 (with
    corresponding solutions in Table 4 and Table 5, respectively), test payroll
    expense. We provide information regarding the number of workers per
    store, the number of new and existing stores, the average wage per hour,
    the regular and overtime hours worked, and the prior year’s payroll
    expense. Students can calculate the number of hours worked based on the
    number of employees per store, the number of stores existing at the begin-
    ning of the year, and the number of stores opened during the current year.
    In Scenario 1, the client opened all new stores on October 1. In Scenario 2,
    the client opened new stores evenly throughout the year.

    The third and fourth scenarios, shown in Table 6 and Table 7 (with cor-
    responding solutions in Table 8 and Table 9, respectively), test depreciation
    expense. We provide information regarding asset categories and the cost
    basis, accumulated depreciation, and expected life for each category, along
    with new assets purchased in the current year and service dates for all assets
    (new and old). The primary difference between Scenario 3 and Scenario 4,
    besides the acquisition date for new assets, is that in Scenario 4, we note
    that the company’s policy is to begin depreciating the assets at the begin-
    ning of the quarter after they are put in service. Because this is a non-
    GAAP policy, we expect students to ignore this policy when calculating
    their expected depreciation expense.

    The final two scenarios, shown in Table 10 and Table 11 (with corre-
    sponding solutions in Table 12 and Table 13, respectively), test interest
    expense. We provide information regarding balances and terms (including
    interest rates) for outstanding debt, as well as the amount outstanding at
    the beginning of the year and amounts paid on the debt throughout the
    year. Scenario 5 includes three bonds with various interest rates and terms.
    Scenario 6 includes three bonds with various interest rates and terms, as

    58 CHRIS BAGWELL ET AL.

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 2. Analytical Procedure Scenario 1.

    Payroll Testing 1

    ABC Restaurant Company

    Payroll Testing Fact Sheet

    December 31, 2016

    ABC Restaurant Company owned 133 stores in 2015. Each store employs 32 hourly

    employees on average and each employee worked approximately 8 hours of overtime per

    week. In 2015, we performed tests of details over hourly payroll expense. The procedures

    performed in 2015 included selecting a statistical sample of 134 employees. For each employee

    we recalculate five weekly paychecks. To accomplish this, we obtained five different weekly

    timecards for each employee, recalculated payroll expense for each employee, and traced that

    amount to the weekly payroll summary report. Then, each weekly payroll report was traced to

    the general ledger.

    In 2016, we would like to determine a more efficient method to test payroll expense for hourly

    employees. Below are a summary of facts that were obtained from the 2015 audit workpapers:

    1. Employees in 2015 = 4,250

    2. Average wage per hour = $14.50

    3. Average employee hours per week = 48

    4. 2015 regular hourly payroll expense = $128,180,000

    5. 2015 overtime hourly payroll expense = $38,454,000

    6. 2015 total payroll expense = $166,634,000

    Below are a summary of facts obtained from inquiries of the corporate controller and the

    payroll manager related to the 2016 audit of payroll expense:

    1. 43 new stores were obtained on October 1.

    2. Each store employs 32 hourly workers.

    3. Overtime pays time and a half.

    4. Management implemented a strategy that reduces overtime by 50% per employee compared

    to 2015.

    5. There were no raises for hourly employees.

    6. Assume each employee works 40 regular hours per week.

    7. Assume 52 weeks per year.

    8. 2016 client-recorded payroll expense = $161,253,989.

    59Analytical Procedures: An In-Class Exercise

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 3. Analytical Procedure Scenario 2.

    Payroll Testing 2

    DEF Restaurant Company

    Payroll Testing Fact Sheet
    December 31, 2016

    DEF Restaurant Company owned 133 stores in 2015. Each store employs 32 hourly

    employees on average and each employee worked approximately 8 hours of overtime per
    week. In 2015, we performed tests of details over hourly payroll expense. The procedures
    performed in 2015 included selecting a statistical sample of 134 employees. For each employee

    we recalculate 5 weekly paychecks. To accomplish this, we obtained five different weekly

    timecards for each employee, recalculated payroll expense for each employee, and traced that
    amount to the weekly payroll summary report. Then, each weekly payroll report was traced to
    the general ledger.
    In 2016, we would like to determine a more efficient method to test payroll expense for hourly

    employees. Below are a summary of facts that were obtained from the 2015 audit work papers:

    1. Employees in 2015 = 4,250
    2. Average wage per hour = $14.50
    3. Average employee hours per week = 48
    4. 2015 regular hourly payroll expense = $128,180,000
    5. 2015 overtime hourly payroll expense = $38,454,000
    6. 2015 total payroll expense = $166,634,000
    Below are a summary of facts obtained from inquiries of the corporate controller and the
    payroll manager related to the 2016 audit of payroll expense:

    1. 43 new stores were obtained evenly throughout the year.

    2. Each store employs 32 hourly workers.
    3. Overtime pays time and a half.
    4. Management implemented a strategy that reduces overtime by 50% per employee compared
    to 2015.
    5. There were no raises for hourly employees.
    6. Assume each employee works 40 regular hours per week.
    7. Assume 52 weeks per year.

    8. 2016 client-recorded payroll expense = $170,125,987.

    60 CHRIS BAGWELL ET AL.

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 4. Analytical Procedure Scenario 1 Suggested Solution.

    Payroll Testing 1

    ANSWER

    Average wage per hour 14.5 A

    Overtime hours per employee 4 B

    2015 employees 4,250 C

    Regular hours (existing employees) 8,840,000 D = C*40*52

    OT hours (existing employees) 884,000 E = C*B*52

    New employees 1,376 F = 43*32

    Regular hours (new employees) 715,520 G = F*40*52*.25

    OT hours (new employees) 71,552 H = F*B*52*.25

    2016 regular payroll � existing employees 128,180,000 = D*A
    2016 regular payroll � new employees 10,375,040 = G*A
    2016 OT payroll � existing employees 19,227,000 =E*A*1.5
    2016 OT payroll � new employees 1,556,256 =H*A*1.5
    Total expected payroll 159,338,296

    Actual payroll expense 161,253,989

    Difference (1,915,693)

    % difference �1.20%

    Test result PASS

    Table 5. Analytical Procedure Scenario 2 Suggested Solution.

    Payroll Testing 2
    ANSWER
    Average wage per hour 14.5 A
    Overtime hours per employee 4 B
    2015 employees 4,250 C
    Regular hours (existing employees) 8,840,000 D = C*40*52
    OT hours (existing employees) 884,000 E = C*B*52
    New employees 1,376 F = 43*32

    Regular hours (employees) 1,431,040 G = F*40*52*.5

    OT hours (existing employees) 143,104 H = F*B*52*.5

    2016 regular payroll � existing employees 128,180,000 = D*A
    2016 regular payroll � new employees 20,750,080 = G*A
    2016 OT payroll � existing employees 19,227,000 = E*A*1.5
    2016 OT payroll � new employees 3,112,512 = H*A*1.5
    Total expected payroll 171,269,592

    Actual payroll expense 170,125,987

    Difference 1,143,605

    % difference 0.67%

    Test result PASS

    61Analytical Procedures: An In-Class Exercise

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 6. Analytical Procedure Scenario 3.

    Depreciation Expense 1

    GHI Restaurant Company

    Depreciation Expense Fact Sheet

    December 31, 2016

    Below are a summary of facts obtained from inquiries of the corporate controller and the fixed asset manager related to the 2016 audit of

    depreciation expense:

    1. The Company opened all of its old restaurants on June 30, 2008.

    2. The Company’s accounting policy requires that assets begin to be depreciated using the straight-line method as soon as they are put into

    service.

    3. The Company opened three new stores on April 1, 2016.

    4. Total new store costs include $1,500,000 for land, $9,400,000 for buildings, $8,500,000 for equipment, and $3,200,000 for furniture and

    fixtures.

    5. 2016 client-recorded depreciation expense = $4,752,396.

    Below is the existing cost basis and accumulated depreciation information (not including the new assets).

    Existing Assets

    Asset Category Cost Basis Accumulated Depreciation Net Cost Basis Economic Expected Life

    Land $2,500,000 � $2,500,000
    Building 19,500,000 $5,362,500 14,137,500 20

    Equipment 15,242,003 11,975,860 3,266,143 7

    Furniture/fixtures 8,259,650 8,259,650 � 5
    Totals $45,501,653 $25,598,010 $19,903,643

    6
    2

    C
    H
    R
    IS

    B
    A
    G
    W
    E
    L
    L
    E
    T
    A
    L
    .

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 7. Analytical Procedure Scenario 4.

    Depreciation Expense 2

    JKL Restaurant Company

    Depreciation Expense Fact Sheet
    December 31, 2016
    Below are a summary of facts obtained from inquiries of the corporate controller and the fixed asset manager related to the 2016 audit of
    depreciation expense:
    1. The Company opened all of its old restaurants on June 30, 2008.

    2. The Company’s accounting policy requires that assets begin to be depreciated using the straight-line method at the beginning of the

    following quarter after they are placed into service.

    3. The Company opened three new stores on October 2, 2016.

    4. Total new store costs include $1,500,000 for land, $9,400,000 for buildings, $8,500,000 for equipment, and $3,200,000 for furniture and
    fixtures.

    5. 2016 client-recorded depreciation expense = $3,148,430.

    Below is the existing cost basis and accumulated depreciation information (not including the new assets).
    Existing Assets
    Asset Category Cost Basis Accumulated Depreciation Net Cost Basis Economic Expected Life
    Land $2,500,000 � $2,500,000
    Building 19,500,000 $5,362,500 14,137,500 20
    Equipment 15,242,003 11,975,860 3,266,143 7
    Furniture/fixtures 8,259,650 8,259,650 � 5
    Totals $45,501,653 $25,598,010 $19,903,643

    6
    3

    A
    n
    a
    ly
    tica

    l
    P
    ro
    ced

    u
    res:

    A
    n
    In
    -C

    la
    ss

    E
    x
    ercise

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 8. Analytical Procedure Scenario 3 Suggested Solution.

    Depreciation Expense 1
    Existing Assets

    Asset Category Cost Basis Accumulated Depreciation Net Cost Basis Expected Economic Life Depreciation

    Expense

    Land 2,500,000 � 2,500,000
    Building 19,500,000 5,362,500 14,137,500 20 975,000

    Equipment 15,242,003 11,975,860 3,266,144 7 2,177,427

    Fumiture/fixtures 8,259,650 8,259,650 � 5 �
    Totals 45,501,653 25,598,010 19,903,644

    Expected depreciation expense � Existing assets 3,152,429

    New Assets

    Asset Category Cost Basis Accumulated Depreciation Net Cost Basis Life Depreciation Expense

    Land 1,500,000 � 1,500,000
    Building 9,400,000 � 9,400,000 20 352,500
    Equipment 8,500,000 � 8,500,000 7 910,714
    Fumiture/fixtures 3,200,000 � 3,200,000 5 480,000
    Total 22,600,000 Expected depreciation expense � New assets 1,743,214

    Total expected depreciation expense 4,895,643

    Actual depreciation expense 4,752,396

    $ Difference 143,247

    % Difference 293%

    Result PASS

    6
    4

    C
    H
    R
    IS
    B
    A
    G
    W
    E
    L
    L
    E
    T
    A
    L
    .
    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 9. Analytical Procedure Scenario 4 Suggested Solution.

    Depreciation Expense 2
    Existing Assets
    Asset Category Cost Basis Accumulated Depreciation Net Cost Basis Expected Economic Life Depreciation Expense
    Land 2,500,000 � 2,500,000
    Building 19,500,000 5,362,500 14,137,500 20 975,000

    Equipment 15,242,003 11,975,860 3,266,144 7 2,177,429

    Furniture/fixtures 8,259,650 8,259,650 � 5 �
    Total 45,501,653 25,598,010 19,903,644

    Expected depreciation expense � Existing assets 3,152,429
    New Assets

    Asset Category Cost Basis Accumulated Depreciation Net Cost Basis Life Depreciation Expense (See Note)

    Land 1,500,000 � 1,500,000
    Building 9,400,000 � 9,400,000 20 117,500
    Equipment 8,500,000 � 8,500,000 7 303,571
    Furniture/fixtures 3,200,000 � 3,200,000 5 160,000
    Total 22,600,000 Expected depreciation expense � New assets 581,071

    Total expected depreciation

    expense

    3,733,500

    Actual depreciation expenses 3,148,430

    $ Difference 585,070

    % Difference 15.67%

    Result FAIL

    Note: The Company’s depreciation policy is a non-GAAP policy; the calculation is performed in accordance with GAAP.

    6
    5

    A
    n
    a
    ly
    tica
    l
    P
    ro
    ced
    u
    res:
    A
    n
    In
    -C
    la
    ss
    E
    x
    ercise
    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 10. Analytical Procedure Scenario 5.

    Interest Expense 1

    MNO Restaurant Company

    Interest Expense Fact Sheet

    December 31, 2016

    Below are a summary of facts obtained from inquiries of the CFO related to the 2016 audit of interest expense:

    1. The Company made scheduled, quarter-end principle payments of $2,000,000 on its Series A notes.

    2. The Company issued Series D, 7.25% subordinated debentures for $103,000,000 at par on July 1, 2016, due January 1, 2023.

    3. The Company made an unscheduled principle payment of $78,000,000 to retire the Series B notes on July 1, 2016, using the proceeds

    obtained from the sale of the Series D notes.

    4. 2016 client-recorded interest expense = $21,023,412.

    Below is the existing debt schedule from the beginning of the current year.

    Balance

    Issuance Terms Collateral January 1, 2016

    Series A 7.75% bonds, due in quarterly installments beginning June 30, 2016 Unsecured $125,000,000

    Series B 11.25% bonds, due in full on December 1, 2024 Unsecured 78,000,000

    Series C 6.0% bonds, due in full on January 31, 2026 All land and buildings 52,600,000

    Total outstanding debt $255,600,000

    6
    6

    C
    H
    R
    IS
    B
    A
    G
    W
    E
    L
    L
    E
    T
    A
    L
    .
    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 11. Analytical Procedure Scenario 6.

    Interest Expense 2

    PQR Restaurant Company

    Interest Expense Fact Sheet
    December 31, 2016
    Below are a summary of facts obtained from inquiries of the CFO related to the 2016 audit of interest expense:
    1. The Company made scheduled, quarter-end principle payments of $2,000,000 on its Series A notes.

    2. The Company issued Series D, 7.25% subordinated debentures for $103,000,000 at par on July 1, 2016, due on January 1, 2023.

    3. The Company made an unscheduled principle payment of $78,000,000 to retire the Series B notes on July 1, 2016, using the proceeds
    obtained from the sale of the Series D notes.

    4. The revolver balance remained steady during the year, but the actual (prime) rate fluctuated throughout the year from 5% to 11%.

    5. 2016 client-recorded interest expense = $23,723,412.

    Below is the existing debt schedule from the beginning of the current year.
    Balance

    Issuance Terms Collateral January1, 2016

    Series A 7.75% bonds, due in quarterly installments beginning June 30, 2016 Unsecured $125,000,000
    Series B 11.25% bonds, due in full on December 1, 2024 Unsecured 78,000,000
    Series C 6.0% bonds, due in full on January 31, 2026 All land and buildings 52,600,000

    Revolver Variable rate revolving line of credit, bearing interest at prime + 1.25% Unsecured 25,000,000

    Total outstanding debt $280,600,000

    6
    7

    A
    n
    a
    ly
    tica
    l
    P
    ro
    ced
    u
    res:
    A
    n
    In
    -C
    la
    ss
    E
    x
    ercise
    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 12. Analytical Procedure Scenario 5 Suggested Solution.

    Interest Expense 1

    Issuance Terms Collateral Balance Expected Interest

    Expense

    Series A 7.75% bonds, due in quarterly installments

    beginning

    June 30, 2016

    Unsecured 125,0000,000 4,843,750

    Series A 123,000,000 2,383,125

    Series A 121,000,000 2,344,375

    Series A 119,000,000 –

    Series B 11.25% bonds, due in full on December 1, 2024 Unsecured 78,000,000 4,387,500

    Series C 6.0% bonds, due in full on January 31, 2026 All land and buildings 52,600,000 3,156,000

    Series D 7.25% debentures, due on January 1, 2023 Subordinated 103,000,000 3,733,750

    Total outstanding debt at

    December 31, 2016

    274,600,000

    Total expected interest expense 20,848,500

    Actual interest expense 21,023,412

    $

    Difference

    (174,912)

    $ Difference �0.84%
    Result PASS

    6
    8

    C
    H
    R
    IS
    B
    A
    G
    W
    E
    L
    L
    E
    T
    A
    L
    .
    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    Table 13. Analytical Procedure Scenario 6 Suggested Solution.

    Interest Expense 2
    Issuance Terms Collateral Balance Expected Interest
    Expense

    Series A 7.75% bonds, due in quarterly installments beginning

    June 30, 2016

    Unsecured 125,000,000 4,843,750

    Series A 123,000,000 2,383,125
    Series A 121,000,000 2,344,375

    Series A 119,000,000 �
    Series B 11.25% bonds, due in full on December 1, 2024 Unsecured 78,000,000 4,387,500

    Series C 6.0% bonds, due in full on January 31, 2026 All land and buildings 52,600,000 3,156,000
    Series D 7.25% debentures, due on January 1, 2023 Subordinated 103,000,000 3,733,750

    Revolver Unsecured, variable rate revolving line of credit, bearing

    interest at prime +1.25%

    Unsecured 25,000,000 2,312,500

    Total outstanding debt at
    December 31, 2016

    299,600,000

    Total expected interest expense 23,161,000

    Actual interest expense 23,723,412

    $

    Difference

    (562,412)

    $
    Difference

    �2.43%

    Result PASS

    6
    9

    A
    n
    a
    ly
    tica
    l
    P
    ro
    ced
    u
    res:
    A
    n
    In
    -C
    la
    ss
    E
    x
    ercise
    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    well as one revolving line of credit with a variable interest rate based on the
    prime rate.

    The final 15�20 minutes of class is spent debriefing, including having
    groups present their assessment of the assigned scenario.9 This allows the
    students to practice presenting their work, while also providing the KPMG
    representatives the opportunity to discuss the process of how the students
    arrived at their assessment. This is followed by the KPMG representatives
    providing feedback on how it “should” be approached, using the suggested
    solutions available for each scenario as a guide, and discussing the next
    step in the process based on the results.

    Assessment of Effectiveness

    Three other faculty members (not co-authors on this chapter) have used
    the scenarios in class, with great success from an unsolicited student feed-
    back standpoint. While we have repeatedly received very positive feedback
    from students regarding the day in class when we have gone through the
    substantive analytical procedure scenarios, we have recently obtained for-
    mal feedback from two sections of Audit 1 students (n=41). We obtained
    the feedback during the next class period following when the KPMG repre-
    sentative was in class. Table 14 shows the questions asked and mean
    responses. Each response was given on a 5-point scale: 1= strongly dis-
    agree, 2=disagree, 3=neutral, 4=agree, 5= strongly agree. A simple
    t-test indicates that each of the mean responses is significantly greater than
    the mid-point of the scale (p-value < 0.01).

    While we do not have any before measures for understanding of sub-
    stantive analytical procedures (consistent with Nicholls & Mastrolia, 2015),
    in addition to the question response data reported here, we have both anec-
    dotal evidence and exam question results. Prior to the use of the substan-
    tive analytical procedure exercises presented in this manuscript the students
    complete a “simple” exercise from the text book in class in being intro-
    duced to substantive analytical procedures. The students regularly struggle
    with the exercise until the professor discusses how to complete the exercise.
    This indicates that their level of understanding prior to the exercises is lim-
    ited and is consistent with the responses to the question indicating that the
    exercises increased their overall understanding (mean = 4.10). From exam
    questions following the coverage of analytical procedures the students did
    very well (from a different semester than the question responses included

    70 CHRIS BAGWELL ET AL.

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    in the manuscript). For three questions involving calculations out of
    100 students 97, 85, and 98, performed the analytical procedures correctly,
    respectively. Also, 96 out of 100 students reached the proper conclusion
    based on the substantive analytical procedures performed. On a more com-
    plex exam problem on a comprehensive final exam, the same group of
    students performed three substantive analytical procedures, with 31, 65,
    and 79, calculating the estimate correctly, and 83 arriving at the proper
    conclusion based on the analytical procedures performed.10,11

    Based on the various forms of evidence gathered, we conclude that the
    in-class exercises are effective in teaching students how to perform substan-
    tive analytical procedures.

    NOTES

    1. This chapter is published with the full support of KPMG. If at any time in
    the future the AICPA and PCAOB determine that analytical procedures are no
    longer a valid procedure for obtaining audit evidence, then KPMG will no longer

    Table 14. Student Feedback.

    Question Mean

    Response

    1. The scenarios increased my understanding of how to perform substantive

    analytical procedures.

    4.26

    2. The scenarios increased my overall understanding of analytical procedures. 4.10

    3. The scenarios and presentation of the slides increased my understanding of

    when to perform

    substantive analytical procedures.

    3.98

    4. The scenarios and related discussion increased my understanding of how to

    evaluate the results of substantive analytical procedures.

    3.95

    5. The scenarios and related discussion increased my understanding of how to

    proceed with the audit based on the results of substantive analytical

    procedures.

    3.90

    6. The scenarios required me to use critical thinking skills in performing the

    substantive analytical procedures.

    4.34

    7. I found the scenarios to be challenging. 3.83

    8. I found the scenarios involving substantive analytical procedures to be

    interesting and enjoyable.

    3.76

    71Analytical Procedures: An In-Class Exercise

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    support these in-class exercises as acceptable ways to teach analytical procedures
    and request that they no longer be used for such a purpose.

    2. Similar importance placed on substantive analytical procedures can be seen
    in PCAOB AS 2305: Substantive Analytical Procedures.

    3. See Messier, Simon, and Smith (2013) for a synthesis of the research post-
    1996. See Hirst and Koonce (1996) for a synthesis of the research pre-1996.

    4. These PowerPoint slides are available in Appendix B.
    5. The PCAOB authoritative guidance is similar in AS No. 12.48, as is the

    IAASB guidance in ISA 520.5. This applies to the references in understanding how
    to form expectations and how to evaluate results.

    6. While we have experienced great success following this format, instructors
    can implement the scenarios without a representative from the profession in atten-
    dance. Through the remainder of the implementation guidance we present the infor-
    mation as if a representative(s) from the profession will be present; however, any of
    it can also be done without any outside assistance.

    7. The number of representatives from the profession could depend on how
    many students are in the class. In order for the auditors to provide guidance to the
    student groups while working on the exercise scenarios, the larger the class size the
    more helpful a larger number of auditors would be. The professor can also be
    involved in providing guidance either with or instead of using representatives from
    the profession.

    8. The slides used by KPMG are available in Appendix B, with KPMG brand-
    ing removed.

    9. Our class period is 75 minutes.
    10. There were 99 who completed the final exam questions, as one student did

    not take the final exam.
    11. The lower score on one of the exam questions was due to one question/calcu-

    lation being intentionally more challenging than the other questions/calculations.

    REFERENCES

    American Institute of Certified Public Accountants (AICPA). (2012). AICPA professional stan-

    dards. New York, NY: AICPA.

    Hirst, D. E., & Koonce, L. (1996). Audit analytical procedures: A field investigation.

    Contemporary Accounting Research, 13(2), 457�486.
    Messier, W. F., Simon, C. A., & Smith, J. L. (2013). Two decades of behavioral research on

    analytical procedures: What have we learned? Auditing: A Journal of Practice & Theory,

    32(1), 139�181.
    Moreno, K. K., Bhattacharjee, S., & Brandon, D. M. (2007). The effectiveness of alternative

    training techniques on analytical procedures performance. Contemporary Accounting

    Research, 24(3), 983�1014.
    Nicholls, C. M., & Mastrolia, S. A. (2015). Second chance homeless shelter: A fraud exercise

    for introductory and survey courses in accounting. Advances in Accounting, 17, 1�24.

    72 CHRIS BAGWELL ET AL.

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    http://www.emeraldinsight.com/action/showLinks?crossref=10.2308%2Fajpt-50327

    http://www.emeraldinsight.com/action/showLinks?crossref=10.1506%2Fcar.24.3.11

    http://www.emeraldinsight.com/action/showLinks?crossref=10.1506%2Fcar.24.3.11

    http://www.emeraldinsight.com/action/showLinks?crossref=10.1111%2Fj.1911-3846.1996.tb00511.x

    Public Company Accounting Oversight Board (PCAOB). (2008). Report on the PCAOB’s

    2004, 2005, 2006, and 2007 inspections of domestic annually inspected firms. Retrieved

    from http://pcaobus.org/Inspections/Documents/2008_12-05_Release_2008-008

    Public Company Accounting Oversight Board (PCAOB). AS 2305: Substantive analytical pro-

    cedures. Retrieved from http://pcaobus.org/Standards/Auditing/Pages/AS2305.aspx

    Trompeter, G., & Wright, A. (2010). The world has changed � Have analytical procedure
    practices? Contemporary Accounting Research, 27(2), 669�700.

    73Analytical Procedures: An In-Class Exercise

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    http://pcaobus.org/Inspections/Documents/2008_12-05_Release_2008-008

    http://pcaobus.org/Standards/Auditing/Pages/AS2305.aspx

    http://www.emeraldinsight.com/action/showLinks?crossref=10.1111%2Fj.1911-3846.2010.01021.x

    APPENDIX A: AUDITING STANDARD REFERENCES
    TO ANALYTICAL PROCEDURES

    PCAOB:

    1. Auditing Standard No. 12.5, 46-48, 57: Identifying and Assessing Risks
    of Material Misstatement

    2. Auditing Standard No. 14.4-9: Evaluating Audit Results

    3. Auditing Standard No. 15.13-14, 21: Audit Evidence

    4. AU section 316.10-.11, .53-56, .83: Consideration of Fraud in a
    Financial Statement Audit

    5. AU section 329.01-.05, .09-.22: Substantive Analytical Procedures

    6. AU section 332.21-22, .27: Auditing Derivative Instruments, Hedging
    Activities, and Investments in Securities

    7. AU section 339, Appendix A and Appendix B: Audit Documentation

    8. AU section 341.05: The Auditor’s Consideration of an Entity’s Ability
    to Continue as a Going Concern

    9. AU section 9312.03: Audit Risk and Materiality in Conducting an
    Audit: Auditing Interpretations of Section 312

    AICPA:

    1. AU-C section 240.22, .34,.A24-.A27,.A43,.A58, Appendix B, Appendix
    C.A77: Consideration of Fraud in a Financial Statement Audit

    2. AU-C section 300.A2: Planning an Audit

    3. AU section 314.03, .06, .09, .38, .50: Understanding the Entity and Its
    Environment and Assessing the Risks of Material Misstatement

    4. AU-C section 315.06,.A1,.A7�A.10,.A64: in Understanding the Entity
    and Its Environment and Assessing the Risks of Material Misstatement

    5. AU-C section 330.04,.A5,.A9,.A11,.A16,.A26,.A46�.A47,.A60,.A63,.
    A73: Performing Audit Procedures in Response to Assessed Risks and
    Evaluating the Audit Evidence Obtained

    74 CHRIS BAGWELL ET AL.

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    6. AU-C section 500.A2,.A10,.A20�.A22,.A31�.A33,.A52: Audit Evidence
    7. AU-C section 520.03�.08,.A1�.A30: Analytical Procedures

    IAASB:

    1. ISA 240.22, .34,.A22,.A37,.A50, Appendix C: The Auditor’s
    Responsibilities Relating to Fraud in an Audit of Financial Statements

    2. ISA 300.A2: Planning an Audit of Financial Statements

    3. ISA 315.5-.6,.A1,.A14-.17: Identifying and Assessing the Risks of
    Material Misstatement Through Understanding the Entity and Its
    Environment.

    4. ISA 330.A5,.A10,.A15,.A43-.A44,.A55,.A57,.A60: The Auditor’s
    Responses to Assessed Risks

    5. ISA 500.A2,.A10,.A21,.A30,.A51: Audit Evidence

    6. ISA 520.1-.7,.A1-.A21: Analytical Procedures

    APPENDIX B: KPMG SLIDES USED TO DISCUSS
    ANALYTICAL PROCEDURES

    Below are the slides used by the KPMG representatives to guide the discus-
    sion of analytical procedures prior to the exercise scenarios. As noted previ-
    ously, it is not necessary to have a representative from the profession to
    implement this exercise. While the slides were originally created by a
    KPMG professional, none of the information in the slides is proprietary,
    therefore, the slides below are generic and can be used with or without a
    KPMG professional presenting. Note that there is typically very little time
    spent on discussion of analytical procedures used in the audit planning and
    audit completion (“final”) phases as that is covered separately during class
    and is not the primary objective of the KPMG case scenarios. The primary
    objective of the scenarios is analytical procedures utilized during the sub-
    stantive phase of the audit.

    75Analytical Procedures: An In-Class Exercise

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    76 CHRIS BAGWELL ET AL.

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    http://www.emeraldinsight.com/action/showImage?doi=10.1108/S1085-462220170000020004&iName=master.img-000 &w=214&h=143

    http://www.emeraldinsight.com/action/showImage?doi=10.1108/S1085-462220170000020004&iName=master.img-001 &w=214&h=143

    http://www.emeraldinsight.com/action/showImage?doi=10.1108/S1085-462220170000020004&iName=master.img-002 &w=214&h=152

    77Analytical Procedures: An In-Class Exercise

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    http://www.emeraldinsight.com/action/showImage?doi=10.1108/S1085-462220170000020004&iName=master.img-003 &w=214&h=143

    http://www.emeraldinsight.com/action/showImage?doi=10.1108/S1085-462220170000020004&iName=master.img-004 &w=214&h=143

    http://www.emeraldinsight.com/action/showImage?doi=10.1108/S1085-462220170000020004&iName=master.img-005 &w=214&h=149

    78 CHRIS BAGWELL ET AL.

    D
    ow
    nl
    oa
    de
    d
    by
    N
    at
    io
    na
    l U
    ni
    ve
    rs
    ity
    o
    f
    Si
    ng
    ap
    or
    e
    A
    t 0
    6:
    08
    0
    4
    A
    pr
    il
    20
    17
    (
    PT
    )

    http://www.emeraldinsight.com/action/showImage?doi=10.1108/S1085-462220170000020004&iName=master.img-006 &w=214&h=147

    http://www.emeraldinsight.com/action/showImage?doi=10.1108/S1085-462220170000020004&iName=master.img-007 &w=214&h=143

    http://www.emeraldinsight.com/action/showImage?doi=10.1108/S1085-462220170000020004&iName=master.img-008 &w=214&h=143

      Analytical Procedures: An In-Class Exercise
      Learning Objectives and Implementation Guidance
      Learning Objectives
      Understanding When to Perform Substantive Analytical Procedures
      Understanding How to Form an Expectation of an Account Balance When Performing Analytical Procedures
      Understanding How to Evaluate the Results of a Substantive Analytical Procedure
      Implementation
      Assessment of Effectiveness
      Notes
      References
      bm_S1085-462220170000020004_nonid4
      AUDITING STANDARD REFERENCES TO ANALYTICAL PROCEDURES
      bm_S1085-462220170000020004_nonid6
      KPMG SLIDES USED TO DISCUSS ANALYTICAL PROCEDURES

    Calculate your order
    Pages (275 words)
    Standard price: $0.00
    Client Reviews
    4.9
    Sitejabber
    4.6
    Trustpilot
    4.8
    Our Guarantees
    100% Confidentiality
    Information about customers is confidential and never disclosed to third parties.
    Original Writing
    We complete all papers from scratch. You can get a plagiarism report.
    Timely Delivery
    No missed deadlines – 97% of assignments are completed in time.
    Money Back
    If you're confident that a writer didn't follow your order details, ask for a refund.

    Calculate the price of your order

    You will get a personal manager and a discount.
    We'll send you the first draft for approval by at
    Total price:
    $0.00
    Power up Your Academic Success with the
    Team of Professionals. We’ve Got Your Back.
    Power up Your Study Success with Experts We’ve Got Your Back.

    Order your essay today and save 30% with the discount code ESSAYHELP