Mini Audit Project Your firm, ACTG 307 & Associates, is engaged to audit the financial statements of XYZ Corporation. It is a private manufacturing company that is considering going public in three to four years. Your firm has been preforming audit services to this client for the past five years. The client requires financial statements audits for monitoring purposes, but mainly to receive finance and loans from banks. The management team has high level of competence and integrity, and based on the other team's assessment of internal control, the control risk is low. Another team did most of the audit tests and completed most of the audit workpapers. Your team is assigned to complete the workpapers and audit tests of the engagement. Specifically, your team is required to do the following: 1. Write an engagement letter, dated 11/6/2020, by completing WP 2-1. 2. Perform the preliminary analytical procedure WP 3-1 and 3-2 and comment on: a. The client liquidity, profitability and solvency. b. The client ability to continue as a going concern. 3. Assess the preliminary materiality based on the policy provided (WP 1-13), and complete WP 3-5, assuming moderate risk and satisfactory results of the analytical procedures. 4. Complete the audit of the accounts receivables: a. Calculate the sample size for A/R confirmation by following steps in WP 25-2. b. Assume that you received answers for all of the confirmations and only one of them indicated that the balance is wrong. The balance recorded is $598,000, but the correct amount is $589,000. Prepare an adjusting entry on WP 25-5. c. Complete the A/R lead sheet WP 25-1, and complete the conclusions box by stating whether this account is fairly stated or not. (Ignore the allowance for doubtful accounts). d. Assuming that all other tests came to be satisfactory, prepare an audit report (dated 2/21/2021) assuming that: 1. The client made the suggest adjusting entry. 2. The client did not do the adjusting entry (only if different from the above one) 5. Complete the project by having all of the required workpapers with a cover page that has your group number and names of the group members, in one word document, and drop it in the drop box on D2L by the midnight of Tuesday 12/1/2020. No late assignment will be accepted Notes: 1. Comparative income statements and balance sheets are provided. 2. Make sure to initial every document. [If you are from the morning (evening) class group # 1, your initial will be MGI (EGI)). WP 1-13 ACTG 307 & ASSOCIATES, CPAs POLICY STATEMENT Professional judgment is to be used at all times in setting and applying materiality guidelines. As a general guideline, the following policies are to be applied: 1. The combined total of misstatements in the financial statements exceeding 10 percent is normally considered material, less than 5 percent is presumed to be immaterial in the absence of qualitative factors. Between 5 percent and 10 percent require the greatest amount of professional judgment to determine their materiality. a. 2. The 5 percent to 10 percent must be measured in relation to the appropriate base. Many times there is more than one base to which misstatements should be compared. The following guides are recommended in selecting the appropriate base: Income statement. Combined misstatements in the income statement should ordinarily be measured at 5 percent to 10 percent of operating income before taxes. A guideline of 5 percent to 10 percent may be inappropriate in a year in which income is unusually large or small. b. Balance sheet. Combined misstatements in the balance sheet should originally be evaluated for current assets, current liabilities, and total assets. For current assets and current liabilities, the guidelines should be between 5 percent and 10 percent. For total assets, the guidelines should be between 3 percent and 6 percent. 3. Qualitative factors should be carefully evaluated on all audits. WP 2-1 ACTG 307 & Associates Certified Public Accountant 2500 Michigan Ave. Chicago, IL 60000 Mr. John Smith, Chairman of the Board XYZ Corporation 36 Bryn Mawr. St. Chicago, IL 60625 Dear Mr. Smith, WP 3-1 XYZ Corp Ratio Analysis 12/31/2020 Liquidity Ratios: 2020 2019 Current ratio current assets/ current liabilities Quick ratio (current assets - inventory/current liabilities Number of days sales in A/R net ending receivables / (net sales/365) Inventory turnover cost of sales / average inventory Profitability Ratios: Gross profit margin % gross profitet sales Income before tax / owner's equity net income before taxes / owner's equity Income before tax/Total Assets net income before taxes / total assets Sales / Total Assets net sales/total assets Sales / Working Capital net sales/ (current assets - current liabilities) Solvency Ratios: Owner's equity / total assets Owner's equity/total assets Current liability / Owner's equity Current liability / Owner's equity Total liability / Owner's equity Total liability / Owner's equity WP 3-5 XYZ Corp. Preliminary materiality Judgment Measurement base Percentage Applied Preliminary materiality (e.g., income, revenue, assets) $ % $ (rounded) (put the name of the base here) I WP 25-1 XYZ Corp. Account name and Number Accounts Receivable Lead sheet Unadjusted Balance Adjustments 97 Adjusted Balance 77 100-101 Accounts receivable Conclusions: The accounts receivable account is ????? (fairly on NOT fairly stated) WP 25-2 XYZ Corp Calculation of Sample Size Risk of incorrect Acceptance 359 Son 2.52 1.39 1.49 161 1.21 1.29 0.70 0.75 1.05 1.12 120 1.28 0.82 0.87 Ratio of Expected te Tolerable Misstatement 10 154 20 0.00 3.00 2.31 1.90 1.61 0.05 3.31 2.06 1.74 0.10 3.6 2.77 2.25 1.89 0.15 3.07 2.47 2.06 0.20 3.41 2.73 2.26 0.25 5.24 3.85 3.04 2.49 0.30 6.00 3.41 2.77 0.35 6.92 4.95 3.86 3.12 0.40 8.09 5.72 3.54 0.45 9.59 6.71 5.15 0.50 11.54 7.99 6.04 475 0.55 14.18 9.70 7.26 5.64 0.60 17.85 12.07 8.93 6.86 Source: Data from AICPA Audit Sampling Audit Guide, March 2012 (www.pl 1.90 2.09 2.30 2.57 2.89 162 1.76 1.95 2.14 239 2.70 3.08 407 1.50 1.63 1.79 1.99 2.22 2.51 2.89 3.38 0.99 1.06 L14 L25 1.37 1.52 1.70 4.47 5.37 Book value of recorded population = $26,388,000 (150 accounts) Book value for individual material accounts - $ 17,462,207 (20 accounts) (test all of them) Book value for all remaining accounts =$8,925,793 I (test only a sample) Performance materiality = $393,000 Confidence factor =?? (From table above assuming ROIA of 10% and Ratio of expected to material misstatement of 5%) Sample size -7? accounts (round up) Total accounts to be confirmed 7? accounts ["Sample size = confidence factor / (Performance materiality / Population value)] Hint: population value in the equation above is the population value that you selected a sample from. WP 25-5 XYZ Corp Adjusting Entries Account Dr. Cr. I Mini Audit Project Your firm, ACTG 307 & Associates, is engaged to audit the financial statements of XYZ Corporation. It is a private manufacturing company that is considering going public in three to four years. Your firm has been preforming audit services to this client for the past five years. The client requires financial statements audits for monitoring purposes, but mainly to receive finance and loans from banks. The management team has high level of competence and integrity, and based on the other team's assessment of internal control, the control risk is low. Another team did most of the audit tests and completed most of the audit workpapers. Your team is assigned to complete the workpapers and audit tests of the engagement. Specifically, your team is required to do the following: 1. Write an engagement letter, dated 11/6/2020, by completing WP 2-1. 2. Perform the preliminary analytical procedure WP 3-1 and 3-2 and comment on: a. The client liquidity, profitability and solvency. b. The client ability to continue as a going concern. 3. Assess the preliminary materiality based on the policy provided (WP 1-13), and complete WP 3-5, assuming moderate risk and satisfactory results of the analytical procedures. 4. Complete the audit of the accounts receivables: a. Calculate the sample size for A/R confirmation by following steps in WP 25-2. b. Assume that you received answers for all of the confirmations and only one of them indicated that the balance is wrong. The balance recorded is $598,000, but the correct amount is $589,000. Prepare an adjusting entry on WP 25-5. c. Complete the A/R lead sheet WP 25-1, and complete the conclusions box by stating whether this account is fairly stated or not. (Ignore the allowance for doubtful accounts). d. Assuming that all other tests came to be satisfactory, prepare an audit report (dated 2/21/2021) assuming that: 1. The client made the suggest adjusting entry. 2. The client did not do the adjusting entry (only if different from the above one) 5. Complete the project by having all of the required workpapers with a cover page that has your group number and names of the group members, in one word document, and drop it in the drop box on D2L by the midnight of Tuesday 12/1/2020. No late assignment will be accepted Notes: 1. Comparative income statements and balance sheets are provided. 2. Make sure to initial every document. [If you are from the morning (evening) class group # 1, your initial will be MGI (EGI)). WP 1-13 ACTG 307 & ASSOCIATES, CPAs POLICY STATEMENT Professional judgment is to be used at all times in setting and applying materiality guidelines. As a general guideline, the following policies are to be applied: 1. The combined total of misstatements in the financial statements exceeding 10 percent is normally considered material, less than 5 percent is presumed to be immaterial in the absence of qualitative factors. Between 5 percent and 10 percent require the greatest amount of professional judgment to determine their materiality. a. 2. The 5 percent to 10 percent must be measured in relation to the appropriate base. Many times there is more than one base to which misstatements should be compared. The following guides are recommended in selecting the appropriate base: Income statement. Combined misstatements in the income statement should ordinarily be measured at 5 percent to 10 percent of operating income before taxes. A guideline of 5 percent to 10 percent may be inappropriate in a year in which income is unusually large or small. b. Balance sheet. Combined misstatements in the balance sheet should originally be evaluated for current assets, current liabilities, and total assets. For current assets and current liabilities, the guidelines should be between 5 percent and 10 percent. For total assets, the guidelines should be between 3 percent and 6 percent. 3. Qualitative factors should be carefully evaluated on all audits. WP 2-1 ACTG 307 & Associates Certified Public Accountant 2500 Michigan Ave. Chicago, IL 60000 Mr. John Smith, Chairman of the Board XYZ Corporation 36 Bryn Mawr. St. Chicago, IL 60625 Dear Mr. Smith, WP 3-1 XYZ Corp Ratio Analysis 12/31/2020 Liquidity Ratios: 2020 2019 Current ratio current assets/ current liabilities Quick ratio (current assets - inventory/current liabilities Number of days sales in A/R net ending receivables / (net sales/365) Inventory turnover cost of sales / average inventory Profitability Ratios: Gross profit margin % gross profitet sales Income before tax / owner's equity net income before taxes / owner's equity Income before tax/Total Assets net income before taxes / total assets Sales / Total Assets net sales/total assets Sales / Working Capital net sales/ (current assets - current liabilities) Solvency Ratios: Owner's equity / total assets Owner's equity/total assets Current liability / Owner's equity Current liability / Owner's equity Total liability / Owner's equity Total liability / Owner's equity WP 3-5 XYZ Corp. Preliminary materiality Judgment Measurement base Percentage Applied Preliminary materiality (e.g., income, revenue, assets) $ % $ (rounded) (put the name of the base here) I WP 25-1 XYZ Corp. Account name and Number Accounts Receivable Lead sheet Unadjusted Balance Adjustments 97 Adjusted Balance 77 100-101 Accounts receivable Conclusions: The accounts receivable account is ????? (fairly on NOT fairly stated) WP 25-2 XYZ Corp Calculation of Sample Size Risk of incorrect Acceptance 359 Son 2.52 1.39 1.49 161 1.21 1.29 0.70 0.75 1.05 1.12 120 1.28 0.82 0.87 Ratio of Expected te Tolerable Misstatement 10 154 20 0.00 3.00 2.31 1.90 1.61 0.05 3.31 2.06 1.74 0.10 3.6 2.77 2.25 1.89 0.15 3.07 2.47 2.06 0.20 3.41 2.73 2.26 0.25 5.24 3.85 3.04 2.49 0.30 6.00 3.41 2.77 0.35 6.92 4.95 3.86 3.12 0.40 8.09 5.72 3.54 0.45 9.59 6.71 5.15 0.50 11.54 7.99 6.04 475 0.55 14.18 9.70 7.26 5.64 0.60 17.85 12.07 8.93 6.86 Source: Data from AICPA Audit Sampling Audit Guide, March 2012 (www.pl 1.90 2.09 2.30 2.57 2.89 162 1.76 1.95 2.14 239 2.70 3.08 407 1.50 1.63 1.79 1.99 2.22 2.51 2.89 3.38 0.99 1.06 L14 L25 1.37 1.52 1.70 4.47 5.37 Book value of recorded population = $26,388,000 (150 accounts) Book value for individual material accounts - $ 17,462,207 (20 accounts) (test all of them) Book value for all remaining accounts =$8,925,793 I (test only a sample) Performance materiality = $393,000 Confidence factor =?? (From table above assuming ROIA of 10% and Ratio of expected to material misstatement of 5%) Sample size -7? accounts (round up) Total accounts to be confirmed 7? accounts ["Sample size = confidence factor / (Performance materiality / Population value)] Hint: population value in the equation above is the population value that you selected a sample from. WP 25-5 XYZ Corp Adjusting Entries Account Dr. Cr