Question

In: Accounting

Apollo Shoes, Inc. E-0 AUDIT PLAN—Preliminary Analytical Procedures FYE 12/31/2020 Audit Procedures W/P Ref. Mgmt Initials...

Apollo Shoes, Inc. E-0 AUDIT PLAN—Preliminary Analytical Procedures FYE 12/31/2020 Audit Procedures W/P Ref. Mgmt Initials Comments Assertions Agree current year amounts on Accounts Receivable lead schedule to trial balance. A-2,E-1 Acc WH Agreed without exception. Agree prior year amounts to prior year audited financial statements. E-2 Acc TC Agreed without exception. Foot Accounts Receivable lead schedule. E-1 Acc WH Agreed without exception. Obtain an aged trial balance of individual customer accounts. Recalculate the total and trace to the Trial Balance. E-2 Review the aging for large and unusual items. E-2 E, Acc, Net Val, Cutoff, Rts, TC No unusual items noted. Send confirmations to all accounts over $1,000,000 plus some randomly chosen accounts. E-3 E, Acc TC Confirmations (representing approximately 92% total AR coverage) mailed on 01/14, Second request on 01/30. Investigate exceptions reported by customers. Resolutions to any exceptions should be noted on the confirmation and any related proposed adjustments added to the lead schedule. Perform alternative procedures on accounts that do not respond to positive confirmation requests. Vouch cash receipts after the confirmation date for subsequent payment. Vouch sales invoices and shipping documents if no cash receipt is available. Evaluate the adequacy of the allowance for doubtful accounts. Vouch a sample of current amounts in the aged trial balance to sales invoices to determine whether amounts aged current should be aged past due. E-2 E, Cut, Net Val, TC No exceptions noted. Calculate and document an allowance estimate using prior collectibility history, any changing economic conditions, and specific accounts determined to be uncollectible that have not been previously addressed. Compare your estimate to the Allowance balance at year end. Note any proposed adjustment and add to the lead schedule.

Solutions

Expert Solution

Apollo Shoes, Inc. is an audit case designed to introduce you to the entire audit process, from planning the engagement to drafting the final report. You are asked to assume the role of a veteran of two-to-three “busy” seasons, “in-charging” for the first time.

While Apollo Shoes’ growth has been phenomenal (there has been a dramatic growth in unaudited net income over the past year), there are some concerns: the client doesn’t want your firm (Anderson, Olds, and Watershed (AOW)) to talk with the predecessor auditor, a labor strike is looming, and one of Apollo Shoes’ largest customers is suffering some financial difficulties.

Because of busy season, there is little help, other than from an untrained intern. While the intern can do “grunt work,” such as vouching and gathering information for you, he appears incapable of preparing workpapers, making adjusting entries, or even getting good coffee and doughnuts. Assistance does come in the form of an objective, competent internal audit staff. Communication between client personnel and other firm members takes the form of e-mail messages from the engagement partner (Arnold Anderson), the engagement manager (Darlene Wardlaw), the intern (Bradley Crumpler), and the director of Apollo’s internal audit department (Karina Ramirez). Required assignments and memos are in bold print. Page indexing suggestions are given, but feel free to adjust page numbering as you see fit.

The AOW intranet website (http://www.mhhe.com/louwers6e/) has many useful resources such as a repository of electronic documents (so that you won’t need to input data or retype documents) and an archive of e-mail messages and their attachments, all filed by account group.

While we tried to make the case as realistic as possible, limitations remain. Since you are unable to follow up directly with client personnel, you may need to rely on some evidence with which you may be uncomfortable. In an actual audit, you would be able to inquire, observe, and otherwise follow-up on any questions that you have until you feel comfortable relying on the evidence. To make sure that the case can be completed in a reasonable amount of time, we cut some corners with respect to audit sampling. Understand that audit sampling plays a large role in actual audit practice.

The information is sequential in nature. In other words, pay close attention to information disclosed early in the audit (for example, in the Board of Director’s minutes) as it may play a role in subsequent audit work. Similarly, the bank cutoff statement in the cash workpapers and invoices used for valuing inventory may be useful later in the search for unrecorded liabilities and the bank confirmation contains information about long-term liabilities.

Lastly, while it is difficult for us to believe that not everyone enjoys auditing as much as we do, we have tried to make the case both interesting and enjoyable (in a perverse sort of way). You can think of the project as a puzzle, in which you have to fill in all the pieces. Alternatively, you could look at the project as a murder mystery that needs a solution. In either case, have fun!

Tim Louwers Loretta Manktelow J. Kenneth Reynolds

Harrisonburg, VA Harrisonburg, VA Bloomington, IN

Table of Contents

Introduction 3

Table of Contents 4

Planning 5

Internal Control Evaluation 51

Substantive Testing: Cash 64

Substantive Testing: Accounts Receivable 74

Substantive Testing: Inventory 85

Substantive Testing: Prepaids and Other Assets 109

Substantive Testing: Fixed Assets 115

Substantive Testing: Liabilities 119

Substantive Testing: Payroll 125

Audit Wrap-up 133

image2.png

Date: 21 OCT 2014 00:42:35 +0000 From: "Darlene Wardlaw" <[email protected]> Subject: Upcoming Apollo Shoes Engagement Attachment: <<AudComMins—101807.doc>>

Well, first let me congratulate you on your recent promotion. Although we have not worked on an engagement together before, I have heard many good things about you. I look forward to working with you on the new Apollo Shoes engagement.

I understand that this is your first engagement to in-charge. Arnold Anderson (aka “Uncle Arnie”) will be the engagement partner; he is pretty sharp so you’ll have to stay on your toes. As engagement manager, I’ll try to help out as much as I can. Understand, however, that I am managing four other busy season engagements, so my interaction time with you will be limited. For now, I want you to familiarize yourself with Apollo Shoes and help me out by doing the following:

1. SEC Filing : I have asked Larry Lancaster, President and chairman of the Apollo Shoes board of directors, to send you a copy of last year’s (2013) 10-K filing with the SEC. Review the information when you receive it, as it is one of the most important sources of information about a company.

2. Audit Committee Meeting : I have attached the minutes of an audit committee meeting that occurred last week. Please review the minutes of the meeting and draft an appropriate engagement letter (label it GA-1 , for General and Administrative, page 1) addressed to Mr. Lancaster. (Since this is our first year on the engagement, you might want to check one of your old auditing textbooks for an example.) I’ll review the letter before getting Arnold to sign it.

3. Audit Team: Based upon the information that you glean from 1 and 2 above, do you see any need for special business knowledge in regard to the basic type of business and products Apollo manages? Do you see any need for special audit or accounting expertise for any of the work that we have agreed to perform? In other words, since you’ll be in the trenches, what kind of expertise do you want on your audit team? Just write a brief (one-page) audit staffing memo (GA-2) telling me what expertise (e.g., tax specialist, IT specialist, etc.) you need to complete the audit and I’ll see if I can get them assigned to the audit team.

4. Scheduling: We are going to have to work around your other engagements, but we have you tentatively scheduled for one week in October (next week) for bringing you up to speed on Apollo and its industry, and five straight weeks beginning the last week in December for engagement planning, internal control evaluation, and substantive testing.

Finally, since most of our interaction will be by e-mail, please forgive me if I give you too much detail. Since we haven’t worked together before, I’d rather give you too much than too little until we get used to working together.

DW

Minutes of the Audit Committee, Apollo Shoes

October 17, 2014

Present at Meeting: Arnold Anderson, CPA (partner in charge of the audit); Darlene Wardlaw, CPA (engagement manager); Eric Unum (Apollo’s vice president of finance); Mary Costain (Apollo’s treasurer); Samuel Carboy (Apollo’s controller); and Karina Ramirez (Apollo’s director of internal audit). The three members of the audit committee of the board and the corporate secretary also were present, but they did not enter into the conversation.

Mr. Unum (VP finance): Well, I want to welcome the auditing firm of Anderson, Olds, and Watershed, CPAs, to what we call the “Apollo Shoes Experience.” After our old auditors, Smith & Smith, CPAs, unexpectedly withdrew from the engagement, we were very happy to have a firm of your quality to come aboard.

Mr. Anderson (partner on the audit): Well, we are always looking for high quality clients. By the way, why did your previous auditors resign?

Mr. Unum (VP finance): I’d rather not talk about it. Arnold, will Darlene be in charge?

Mr. Anderson (partner on the audit): Yes, and she will be assisted by several of our best staff, including a tax specialist and an information systems auditor. We need to keep up to date on your computer systems. Back to your previous auditors, with your permission, we would like to contact them.

Mr. Unum (VP finance): Well, we’d rather you didn’t. There may be some litigation since they withdrew from the engagement with so little notice. Is it necessary for you to speak with them to accept the engagement?

Mr. Anderson (partner on the audit): No, not really, but it does raise some concerns for our firm.

Ms. Costain (treasurer): In the past, we have never had any unpleasant discoveries of embezzlement or theft, but we always want to be vigilant. Will you plan enough in-depth auditing to give us assurances about errors and frauds in the accounts?

Ms. Wardlaw (manager on the audit): We will follow audit standards and base our audit work on samples of transactions. We plan the work to look for major errors and frauds in the accounts, but cleverly hidden schemes might not be discovered.

Ms. Ramirez (internal auditor): Darlene, I agree, it’s hard to uncover clever schemes. While I am new to Apollo, none of the projects that I have undertaken this year shows anything amiss, other than normal human error types of mistakes.

Ms. Costain (treasurer): This year, we want to add some work to the audit. I am short on staff time and need to have you prepare the state franchise tax return as well as the federal tax returns.

Ms. Wardlaw (manager on the audit): Our tax staffperson can do the state and federal returns, and I will have them reviewed by Maria Olds, our tax partner. In order to perform the tax work, Sarbanes-Oxley requires that we get prior approval from the audit committee to perform both the tax work as well as the audit.

Mr. Anderson (partner on the audit): I assume you also want us to review the 10-K filing material?

Mr. Unum (VP finance): Yes. Will you need any staff help from us?

Ms. Ramirez (internal auditor): Last year, Apollo was able to save on audit fees when my staff prepared a stack of schedules and analyses that our previous auditors needed.

Ms. Wardlaw (manager on the audit): Yes, Karina, I will give you a list of schedules for various accounts. I will appreciate your having them ready when we start fieldwork in mid January.

Mr. Carboy (controller): Speaking of being ready, we will be able to give you a trial balance the day after December 31.

Mr. Unum (VP finance): How much is this going to cost us?

Mr. Anderson (partner on the audit): It is difficult to give you a fixed fee deal, but my estimate, considering the additional work, is $750,000. Darlene will let you know immediately if problems arise to cause the work to be more extensive.

Mr. Unum (VP finance): Thank you. This has been a productive meeting of the minds. We look forward to your getting started.

Meeting ended 5:30 p.m. /s/ Jeff Chesnut, Secretary

Date: 22 OCT 2014 4:43:17 +0000 From: "Larry Lancaster" <[email protected]> Subject: Attached 10-K Filing

Attachments: <<Shareholder Letter.doc>>, <<10K.doc>>, <<ApolloShoesOrgChart.xls>>

I am sorry that you were unable to attend the audit meeting last week, but Darlene Wardlaw said that you were busy with another client. She asked that I forward a copy of our 10-K directly to you. I’ve attached one that we sent out to all shareholders with the Letter to Shareholders attached.

I’ve attached a copy of Apollo’s organizational table. Please let me know what my staff or I can do to help the audit go smoothly for you. I will have Karina Ramirez, our Director of Internal Audit, contact you to provide you with any other information that you need.

Larry

P.S. Do you play golf?

This Apollo message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

Letter to Fellow Shareholders

Dear Fellow Shareholders,

You may have noticed our competitor's focus on earth-bound activities and athletes. Our focus is in exactly the opposite direction. In actuality, the technological superiority of our products is at the point where our sales are limited only by the technological inferiority of other scientific fields (specifically, current transportation means). As space exploration continues, we intend to be among the first to market our products in new worlds. It is there that our technological advances in light and sound can combine with our rugged footwear to propel all galactic sports participants to their fullest potential.

Back here on earth, the past year has been one of the most dynamic and exciting years since I began my tenure at Apollo Shoes. From the beginning, Apollo Shoes, Inc. has adapted itself to meet the needs of all its galactic customers and to take advantage of all opportunities supplied by exploration of new frontiers. After a record year when most companies may have wanted to relax and play it safe, we have decided to use this excitement to reach out further in our continuing mission: to make a difference in this galaxy.

Our product lines, led by the flagship products SPOTLIGHT (for athletes who like to compete at night) and SIREN (designed specifically for police officers working the graveyard shifts in our nation's most dangerous cities) have met widespread acceptance. We have signed with some of this world's premier athletes as spokespersons for our products, including a recent winner of the grueling Alaska Iditarod who used his SPOTLIGHTs to guide his dogs to a late night finish line. We are currently negotiating with a soccer league to exclusively use our SIRENs ; the shoe's flashing lights are designed to go off after every team goal!

Our strategic management plans have allowed us to maintain a positive trend in income over the past several years, and this was no easy task, given the state of the galactic economy. Our net income for the year has been the best since we began operations four years ago. Next year appears even better!

The strength of our results for the past year should not be confused with the truth of the times. This was a uniformly difficult year for all businesses. Due to the conflicts in foreign countries, and uncertainty with the Federal Reserve's adjustments of interest rates, consumer confidence has been negatively affected; therefore, fewer earth consumers are buying our state-of-the-art athletic equipment. All of our operating divisions were severely tested. I am proud of their responses. Although sales were not as strong as we had anticipated, our marketing plans will allow us to bounce back next year.

With the advent of significant new breakthrough technology by Apollo Shoes, Inc.'s research and development team, Apollo Shoes, Inc. now has the possibility to take a leadership role in the galactic athletic footwear market. Apollo Shoes, Inc. has always been known for its leadership position in electronic shoe technology, but we are now committed to expanding our marketing focus. With new applied technologies, Apollo Shoes, Inc. can maintain its tradition of high tech electronic performance and style. We continue to work on and improve the SPEAKERSHOE , an athletic shoe with an amplified loudspeaker, originally designed for the international recording group "Mythic Meathook." We are hard at work on new ideas, such as the PHONESHOE , the sneaker with a cellular phone for those executives who like to simultaneously combine exercise with work. We anticipate that the PHONESHOE will capture a significant piece of this quickly expanding market.

At Apollo Shoes, Inc., we like to briefly acknowledge achievement and then proceed to new challenges. This year was great only because it provided us with resources to expand operations and further technological progress. As we continue into this century of "more, faster, better," it is critical to continue this tradition because production, speed, and quality are critical elements for future success. We look forward to the challenge


Related Solutions

I have a question about auditing. I am doing preliminary analytical procedures for Apollo Shoes. I...
I have a question about auditing. I am doing preliminary analytical procedures for Apollo Shoes. I have to choose three difference relationship(A, B,and C) from the trial balance and hypothesize at least two reasons we see the change we do, as well as you think RMM should increase, decrease, or remain netural. I found unusual percentage of increase of Machinery, Equipment and Office Furniture( 576%), but the sale decreased 1%. but I can't find on more relationship. Please help me....
Apollo Shoes, Inc. Cash Lead Schedule Prepared by For Year Ended 12/31/2017 Reviewed by PBC (Audited)...
Apollo Shoes, Inc. Cash Lead Schedule Prepared by For Year Ended 12/31/2017 Reviewed by PBC (Audited) Unaudited Balance Balance Acct # Account Title 12/31/16 12/31/17 10100 Cash on Hand $1,987.28 $2,275.23 10200 Regular Checking $198,116.52 $557,125.92 10300 Payroll Checking $0.00 $0.00 10400 Savings $3,044,958.13 $3,645,599.15 --------------- ---------------------------------- ---- -------------------------------- ---- ---------------------- $3,245,061.93 $4,205,000.30 Date: 28 JAN 2018 15:37:42 +0000 From: "Darlene Wardlaw" <[email protected]> Subject: Audit of Accounts Receivable We received a number of accounts receivable (and one pre-paid insurance) confirmations...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT