Selected Preliminary Analytical Procedures

Requirements

You will perform substantive audit procedures as you would during fieldwork of an audit engagement.  You will document your substantive audit procedures as well as identify and describe problem areas in the audit by collecting and examining information and evaluating evidence.  Complete the Fixed Assets Audit by performing the following:

Read: All audits require reading and research.  Do the following:

Review the Planning and Internal Controls sections of the Apollo Shoes Case Study (Client File). Note any policies and procedures, BOD activity, and other information relevant to the Fixed Assets section of the audit.

Read the Fixed Assets section of the Apollo file.

Electronic Work Papers Page1

Create a new Excel Spreadsheet: To begin the process of  performing the Fixed Assets Audit, you will need to create an Excel Spreadsheet using the Detailed Outline you created in Week 6 and adding the 2 spreadsheets in the Fixed Assets file attached (these come from the Client files on Fixed Assets). You should copy/paste the FA spreadsheets into your Detailed Outline.

Fixed Assets FA 1 & 2.xlsx

Read the following information about the tabs that should be included in the file:

Title/Cover Page:

a tab called “Cover Page” and include cover page information

Assignment

Section

All tabs from the Detailed Outline from Week 6: This would include the spreadsheets: Title, A-1, A-2, and TB(Rename B-1 Preliminary Analytical Procedures to TB).  The TB should include all of the account balances for the current year and the prior year as well as the horizontal analysis.  This should be a “revised” copy of the Comparative TB and should include revisions based on prior instructor feedback (Comparative TB and Detailed Outline assignments).

Tab FA-1/Roll-forward Lead: Utilize the 10K Roll-forward tab FA-1. Use the following information.

Utilize the proper three-line heading of an audit work paper.

Use the format illustrated provided in the spreadsheet.

Identify all of the balance sheet related fixed asset accounts from the Apollo Shoes Comparative Trial Balance (TB). Link the data from the TB into FA-1.

Create a line for each account you identify and include the following information from the TB

Account number.

Account name.

Beginning balance.

Ending balance.

There are no disposals so all of the activity throughout the year is attributed to additions.

Enter the difference between the Beginning and Ending balances in the Additions column.

Create a line to indicate the Gross Value of the Fixed Assets and use formulas to calculate a subtotal line.

Create a line to indicate the Net Book Value of the Fixed Assets and use formulas to calculate a total line.

Use formulas to calculate the horizontal analysis for the

Dollar difference.

Percent change.

Substantive Audit Procedures: To audit Fixed Assets, perform the following:

Prepare and analyze the 10K Roll-forward Schedule (Lead Schedule)

Reminder for PBC workpapers

You are auditing PBC’s, not fixing them.

Do not change numbers or “fix” anything on the PBC’s.

It is a PBC and must maintain its integrity with the following exceptions:

You may change the formatting for font, font size, number (comma) format, etc.

Recalculate all of the depreciation expense values for all years and all items present based on Apollo Shoe’s policies and procedures as well as the requirements of US GAAP.

Additions on the Lead.

Include

Material: Integrate knowledge from your financial accounting courses to fully analyze, discuss, and document the difference using both narrative discussion and computations through Excel formula calculations.  If the difference is a client error, create a tickmark.  Develop an approach to address it by documenting the requirements and rationale for the correction.  Prepare an accurate and complete two-column journal entry to dispose of (correct) the issue.