Please Help!!

Q6 V : XV fx A B C D E F G H J K L M N O These emails are NOT workpapers. Rather they are Date: 02 NOV 2020 14:37:42 +0000 useful communications for From: "Darlene Wardlaw" completing your case. They do OOO VO UI A WN - Subject: More planning stuff for Apollo not get a workpaper reference. We received the engagement letter from Apollo. So, we need to go ahead and wrap up the planning stuff. You already got started, so this should seem familiar. I have completed most of the audit resource documents (budget, etc.). But we need to check the client's trial balances (you'd be surprised how often ON they don't balance) and work up the materiality memo. When you populate it, use formulas from the TB instead of hardcoding in the numbers; that way, I can double-check it before I send it on to Arnold to review. If you could take care of that and look at any of the other items from the program that need attention, that would be great. 17 18 DW 19 When you tie out the prior year balances to the 10-K, you'll have to combine some trial balance lines to 20 get the summated numbers on the 10K. But you already knew that. 21 22 23 24 25 26 27 Windows Ink WorkB C D E F Apollo Shoes, Inc. AUDIT PLANPLANNIN G FYE 128139020 Complete client engagement acceptance form. AO You are responsible for completing all steps highlighted in green. Workpaper Related Assertion Reference {s} Review correspondence files, prior year audit workpapers, permanent files, nancial statements and auditor's reports. Obtain 2019 audited trial balance and 2020 unaudited trial balance. Obtain and review a copy of the prior year 10K. Foot balances and ensure mathematical accuracy of PEG trial balances. Performed b The PY 10K is included in the workpapers at AS, the FY workpapers are not available per Apollo. See board of director meeting minutes for more information AS. Trial balance obtained on 012'012'2021 from Samual Carboy, Apollo Controller. Obtained by DW on 12J24f2020. Trace prior period balances to the ciosing balance in the prior period's nancial statements (lo-K). Note: some amounts on thenamial statements are the sum efmultmle TB accounts. Determine the extent of involvement, if any, of consultants, specialists, or internal auditors. If the work of another is being used in the engagement, determine that it is used in accordance with professional standards. Review the minutes of the board of directors and committee meetings for the year and any new agreements, leases, contracts, or other important documents. Obtain copies of the minutes or agreements for the current or permanent workpaper files. Highlight matters relevant to the related audit area or for which disclosure will be required in the financial statement or notes. Obtain an engagement letter from the client. Complete Materiality Memo. Complete a time budget by audit area. Determine staffing assignments based on consideration of audit risks, and discuss the preliminary audit plan and key dates, i.e. inventory observation, mailing of conrmations, etc. with the audit staff. 1 b ...| Emails A-O Plannino Audit Proaram | Complete independence forms for all firm employees. |_r I P O h | Some reliance on internal audit will be necessary. Apollo Director of Internal Audit Karina Ramirez will be assisting on the audit, per my (DW) review of her qualifications and the organizational structure of Apollo I have concluded that she is both objective and competent. Notes on AS. Signed copy of engagement letter received from the client on November 20, 2020. Rough draft completed, new senior to track and expand time tracking. Staff determined as of 12/01/2020 Electronically signed by all firm employees and led on firm intranet as ofDecember 31, 2020. A1I." 6h ' Abgil 2128 PM 5/14/2022 I- B C D E F G H K L M N O P Q Apollo Shoes, Inc Prepared by: DW/TC 2019 10-K and assorted documents 10 -K Reviewed by: AA 31-Dec-20 SOONOUAWN This WP includes several documents considered critical to the audit planning process. Apollo 2019 10-K See additional materials The following items could be noted by the student to be of significance to the audit: Information Relevant to 2020 Audit 11 Audit Action Recommended 12 January 06, 2020 Larry Lancaster, Chairman, President, and CEO is a new hire. - Investigate Larry's background? Apollo CEO Letter to Sales expected to increase 10% - Note for analytic review of expenses Shareholders See additional materials COGS and exp. to remain constant - Note for analytic review of expenses 17 Authorized purchase of $1.3 million in equipment. - Vouch to supporting documentation, trace to PP&E workpapers. 18 ST credit refinanced, rolled into LT N/P - Note for liabilities work; ensure proper accounting and disclosure. 19 Officers' salary increase 10% - Note for payroll analytic procedures 20 Cost of Superbowl ad rose 10% ($1 million). - Note for review of expenses June 30, 2020 Apollo Organization Chart See additional materials 24 Damages from "Nor'easter" cost $50,000. - Should be treated as repair, rather than capital addition 25 Company raised prices 10% to meet expectations - Examine reasons for not meeting goals 26 Stopped R&D on Phoneshoe. - Implications for intangible assets? 27 Postage and telephone expense saved through e-mails - Note for analytic procedures involving expenses. 28 Write-off A/R for $23,810.13. - Was that the only write-off? 29 Advanced $1.25 million to Larry Lancaster's secretary (personal) - Related party transaction should be disclosed in footnotes. 1% interest Authorized $1 million for purchase of computer systems. - Verify purchase. Board of Directors and Audit Authorized $44,403,000 draw on LOC. - Verify the accounting for the liability. Committee Meeting Minutes See additional materials 33 January 6, 2021 34 Anderson, Olds, and Watershed hired (fee $750,000)X-1 - Fee should be included in Professional Expenses 35 Approved cash dividend ($860,000) (disbursed 03/01/21 for SH of record 12/31/20) - Dividend should be accrued. 36 Reported a $12 million negligence suit - Contact client attorneys, possible contingent liability. 37 Machinery purchased in early 2017 not operational - Check on status. 38 Approved bonuses for 12/31/20 - $450,000 bonuses should be accrued at 12/31/20 39 Email from CAE and info See additional materials Company approved $3,300,000 contribution to EBP - Note for footnotes. 40 about new computer system No Superbowl ad this year - Note for analytic proceduresA B C E Preclosing Trial Balance A- 2 31-Dec-20 5 Account ID Account Description Debit Amt Credit Amt Single Column format 10100 Cash on Hand $2,275.23 $2,275.23 10200 Regular Checking Account $557,125.92 $557,125.92 10300 Payroll Checking Account $0.00 10400 Savings Account $3,645,599.15 $3,645,599.15 11000 Accounts Receivable $51,515,259.98 $51,515,259.98 11400 Other Receivables $1,250,000.00 $1,250,000.00 11500 Allowance for Doubtful Accounts $1,239,009.75 ($1,239,009.75) 12000 Inventory $67,724,527.50 $67.724,527.50 14 12300 Reserve for Inventory Obsolescence $846,000.00 ($846,000.00) 15 14100 Prepaid Insurance $3,424,213.78 $3,424,213.78 16 14200 Prepaid Ren $0.00 17 14300 Office Supplies $8,540.00 $8,540.00 18 14400 Notes Receivable-Current $o 00 19 14700 Other Current Assets So.00 20 15000 Land $117,000.00 $117,000.00 15100 Buildings and Land Improvements $674,313.92 $674,313.92 15200 Machinery, Equipment, Office Fur $2,929,097.13 $2,929,097.13 17000 Accum. Depreciation $610,000.00 ($610,000.00) 19000 Investments $1,998,780.39 $1,998, 780.39 19900 Other Noncurrent Assets $53,840.59 $53,840.59 26 20000 Accounts Payable $1,922,095.91 ($1,922,095.91) 23100 Sales Tax Payable $0.00 23200 Wages Payable $0.00 23300 FICA Employee Withholding $8,439.65 ($8,439.65) 23350 Medicare Withholding $11,414.99 ($11,414.99) 23400 Federal Payroll Taxes Payable $118,086.12 ($118,086.12) 23500 FUTA Tax Payable $0.00 23600 State Payroll Taxes Payable $55,106.86 ($55,106.86 23700 SUTA Tax Payable $0.00 35 23800 FICA Employer Withholding $8,439.65 ($8,439.65) 36 23900 Medicare Employer Withholding $11,414.99 ($11,414.99) 24100 Line of Credit $44.403,000.00 ($44,403,000.00) 38 24200 Current Portion Long-Term Debt $0.00 H - 2 39 24700 Other Current Liabilities $0.00 40 27000 Notes Payable-Noncurrent $12,000,000.00 ($12,000,000.00) PBC 39003 Common Stock $8, 105,000.00 $8,105,000.00) 42 39004 Paid-in Capital $7,423,000.00 $7,423,000.00) 43 39005 Retained Earnings $6,590,483.64 ($6,590,483.64) 44 40000 Sales $242, 713,452.88 $242, 713,452.88) A-2 45 41000 Sales Returns $11,100,220.89 $11,100,220.89 46 42000 Warranty Expense $1,158,128.47 $1,158,128.47 47 45000 Income from Investments $1,426,089.31 $1,426,089.31) 48 46000 Interest Income $131 ,881.46 ($131 ,881.46) PPC 49 47000 Miscellaneous Income $2,166,000.00 ($2,166,000.00) 50 50010 Cost of Goods Sold $130,196,645.26 $130,196,645.26 57500 Freight $4,240,263.09 $4,240,263.09 52 60000 Advertising Expense $1.036,854.01 $1,036,854.01 61000 Auto Expenses $210,502.80 $210,502.80 62000 Research and Development $528,870.44 $528,870.44 64000 Depreciation Expense $446,000.00 $446,000.00 64500 Warehouse Salaries $4, 720,715.56 $4, 720, 715.56 65000 Property Tax Expense $99,332.45 $99.332.45 66000 Legal and Professional Expense $4,913,224.45 $4,913,224.45 67000 Bad Debt Expense $0.00 68000 Insurance Expense $36,106.92 $36,106.92 70000 Maintenance Expense $35,502.87 $35,502.87 70100 Utilities $137,332.18 $137,332.18 63 70110 Phone $52,599.02 $52,599.02 64 70120 Postal $77,803.61 $77,803.61 65 71000 Miscellaneous Office Expense $24,891.82 $24,891.82 66 72000 Payroll Tax Exp $1.577,811.85 $1,577,811.85 67 73000 Pension Profit-Sharing Plan Ex $3,630,375.80 $3,630,375.80 68 78600 Controllers' Clearning Account $330,375.80 ($330,375.80) 69 74000 Rent or Lease Expense $1,206,574.00 $1,206,574.00 70 77500 Administrative Wages Expense $16,197.225.43 $16,197,225.43 71 78000 Interest Expense $2,591, 736.50 $2,591, 736.50 72 78500 Income Tax Expense - Federal $8.900.000.00 $8,900,000.00 73 78510 Income Tax Expense - State $3,100,000.00 $3,100,000.00 $330,119,291.01 $330,119,291.01A B C D E F G H J K L Signed Engagement Letter A-4 Apollo Shoes, Inc. W N 12/31/2020 October 26, 2020 Mr. Larry Lancaster, Chairman Apollo Shoes, Inc. Shoetown, ME Dear Mr. Lancaster: 10 11 This will confirm our understanding of the arrangements for auditing Apollo Shoes, Inc. financial statements for 2020. We will audit the balance sheet at December 31, 2020, and the related statements of income, retained earnings, and cash 12 flows for the year ending that date. Our audit will be made in accordance with the Standards of the Public Company Accounting 13 Oversight Board and will include such tests of the accounting records and such other auditing procedures as we consider necessary. 14 Our audit will be based on samples of recorded transactions. We will plan the audit to detect material errors and frauds 15 that may affect your financial statements. Our work, however, is subject to the unavoidable risk that errors, frauds, and illegal acts, will 16 not be detected. We expect to obtain reasonable, but not absolute, assurance that major misstatements do not exist in the financial 17 statements. Our findings regarding your system of internal control, including information about significant deficiencies and material 18 weaknesses, will be reported to the audit committee of your board of directors in a separate letter at the close of the audit. At your request, but pending approval by your Board of Directors, we will prepare all required federal tax returns and the 19 state franchise tax returns. 20 We will provide your staff with a list of schedules needed by our staff during the audit. The delivery dates have been 21 discussed and mutually agreed upon. We understand that your staff will prepare all the schedules in the package, all the financial 22 statements and notes thereto, and the Form 10-K for our review. The scope of our services does not include preparation of any of these 23 financial statements. 24 Ms. Darlene Wardlaw will be the manager in charge of all work performed for you. She will inform you immediately if 25 we encounter any circumstances that could significantly affect our fee estimate of $750,000 discussed with you on October 17, 2020. She is aware of the due date for the audit report, March 15, 2021. You should feel free to call on her at any time. 26 If the specifications above are in accordance with your understand of the terms of our engagement, kindly sign below and 27 return the duplicate copy to us. We look forward to serving you as independent public accountants. 28 29 Accepted by /s/ Larry Lancaster Date 11/02/2020B C D E F G ENGAGEMENT MATERIALITY Prepared by (Required for all engagements) Reviewed by CLIENT Apollo Shoes PERIOD ENDED: December 31, 2020 This completed form must be provided to the engagement quality control reviewer in the planning stage of every audit. Please complete all the cells highlighted in yellow. 10 PLANNING MATERIALITY CALCULATION 11 Only if the current year net income (loss) (or other measure) is significantly different from the entity's historical results would 2-year averaging to obtain normalized net income (loss) (or other measure) be 12 appropriate. 13 PROFIT ORIENTED ENTITIES Current Year Prior Year 14 Net income (loss Plus (minus) unusual, non-recuming revenues and 15 expenses, and extraordinary items. 16 ADJUSTED NET INCOME (LOSS) 17 18 Adjusted net income (loss) multiplied by: 19 5% 0 20 21 22 Current Year 23 TOTAL ASSETS 24 25 Total assets multiplied by: 26 1% 0 27 28 Current Year 29 TOTAL REVENUES 30 Plus (minus) unusual, non-recurring revenues 31 ADJUSTED REVENUES 32 33 Total adjusted revenues multiplied by: 34 1% 0 0 35 36 37 JUSTIFICATION OF PLANNING MATERIALITY 38 1. Financial data source (i.e. actual, budget, Year end trial balance, actual data obtained from client. 39 projection): 40 2. Basis (i.e. normalized net income, revenue, Adjusted net income 41 total assets, other): 42 Justification: USE THIS BOX TO DOCUMENT AND JUSTIFY WHICH BASIS YOU'VE 43 SELECTED 44 45 46 Standard 5% used. 47 3. Percentage of financial data source used: 48 49 50 4. Amount selected (planning materiality) 5 1 Being that Apollo is a new client and we were not provided with materiality amounts from the predecessor auditor, we assume that planning materiality is 5% of net income from 2019. 52 5. Prior year's final materiality 6. Performance materiality/Tolerable 54 misstatement (75% of planning materiality) 55 7. Listing scope (amount threshold for suggested adjustments) (using 5% to 10% of planning materiality based on expected level of adjustments is usually appropriate) 56 57 5%IS 1,637 23 Begin by reading the Email from Darlene. Then go to A- 0 The Planning Audit Program. Note the highlighted rows #4 a and b and 8. These are the three workpapers you need to complete. 4.a asks you to Foot balances and ensure mathematical accuracy of the PBC trial balance. This is worksheet A1. First total each column on A1 and next mark your work with a tick mark (F) next to the totals. Probably in red, so you coworkers know what work you have done on the worksheet. Remember to initial the upper right -hand corner. Then go back to A-) and fill in row 4.a -The workpaper reference (PYTB), What is the assertion, your initials, any comments did it foot? Any exceptions? If not, state Footed with no exceptions. 1. b. Trace the prior period balances( A1) to the closing balances of the 10K ( A-3 10K, you have this from last week in the additional les if the link in the worksheet A-3 is not working) Open the 10K, nd the closing balances for 2019 and compare each line item, some items may be combined or netted in the 10K) For each item on A1 in column G or F, note the A-3 (10-K). Then initial the top right corner. Go back to A0 and complete row 4b. Next read A4, A6 and A-7 These workpapers have all been completed by your coworkers. Then complete A-5 Materiality -You should be able to nd prior year net income on the 10K or you can calculate it. Calculate net revenue and subtract expenses to get net income, using the Trial balance for the current year and the prior year using a-1 and a-2. For 2019 the auditor notes a loss on legal settlement, this is a one-time loss and should be listed separately on line D15. ln row 19 you multiply net income by 5% as it states on the worksheet. Then calculate total assets for the current and prior year and enter that amount into row 23, for row 26 multiply total assets for each year by 1% Continue on to calculate total revenues for each year for row 29 and continue on to complete the worksheets. Filling in the justification section. Remember to initial your