I ask this answer before and get answer but still confuse, can you upload video? https://twu.instructure.com/courses/2943434/files/173310937/download?download_frd=1 1.

I ask this answer before and get answer but still confuse, can you upload video?

https://twu.instructure.com/courses/2943434/files/173310937/download?download_frd=1

Transcribed Image Text:

1. Sumlf in AR Testing 2. VLookup in Revenue Testing 2. Shipping Detail 3. Piv Background: You are testing the accuracy and valuation management assertion of the allowance for bad debt account for your client, Oakley Turf, using its A/R subsidiary ledger in cells A18:A67. Instructions: (1) Use the SUMIF function in cells B15:B17 to compute the sum for each balance status as efficiently as possible using Excel formulas; (2) Foot the A/R subsidiary ledger provided to the client's recorded A/R balance from the trial balance to make sure the information they provided you was complete. Also foot the A/R total in B18 and agree the amount to the client's recorded A/R balance (ensure it says "Yes" in cell D18); (3) Calculate your expectation for the Allowance for Bad Debt account in cell C21 and compare it to the client's recorded amount by calculating a difference between recorded and expected amounts in cell C22, and describe in cell B25 what (if any) steps you will take next as the auditor. All work on this assignment must be your team's own. Direct questions to your professor, not classmates. Accounts Receivable Balance per Client Performance Materiality Status Good standing Overdue Delinquent Status Good Standing Overdue Delinquent TOTAL Gross A/R Client's recorded Allowance for Bad Debt Auditor expectation of Allowance for Bad Debt Difference Based on the results of your testing herein, what should you do? Ask the client to provide an explanation for the difference Notify your audit senior of the difference Assuming the auditors and client disagree, for now record the difference on the Summary of Adjustments Passed (SOAP)? Account Receivable Subsidiary Ledger - Oakley Turf $2,121,309.22 $200,000.00 Defined | < 30 days outstanding 30-90 days outstanding >90 days outstanding Historical Collectibility per Client 0.95 0.90 0.80 Balance Aging Categories Foot? (Yes/No) No $150,000.00 Mark "Yes" or "No" Customer AR Balance Age (days) Grainger HDSupply 29,938.61 9 34,990.87 64 JoesSupply SpeedySupply BigTex Home Depot Lowe's TractorSupply TurnerCo XYZco AltaMaraCo Angelo State University Lamar University Midwestern State University Prairie View A&M University 77,480.45 56 30.602.34 19 21,394.43 5 11,319.70 119 0.00 17 58,432.75 25 52,577.58 84 24,290.71 15 15,569.81 10 62,582.40 111 39,355.90 15 71.901.54 122 45,772.62 18 Sam Houston State University 43,010.03 22 Stephen F. Austin State University 28,579.59 24 Sul Ross State University 23,071.30 23 Sul Ross State University Rio Grande College 36,332.16 23 Tarleton State University 7,208.01 29 Texas A&M International University 18,815.68 14 Texas A&M University 76,068.65 3 Texas A&M University at Galveston 73,152.05 116 Texas A&M University System 4,770.08 3 Texas A&M University-Central Texas 27,113.28 13 Texas A&M University-Commerce 69,700.92 24 Texas A&M University-Corpus Christi 49,592.24 20 Texas A&M University-Kingsville 65,681.28 102 Texas A&M University-San Antonio 59,396.95 25 Texas A&M University-Texarkana 9,500.23 22 Texas Southern University 87,326.06 68 Texas State University Texas State University System Texas Tech University University of North Texas 25,041.50 7 84,499.42 59 88,461.46 17 58,116.48 43 Texas Woman's University The University of Texas at Arlington 52,388.77 117 34,192.10 18 The University of Texas at Austin 31,220.27 93 The University of Texas at Dallas 32,550.04 17 The University of Texas at El Paso The University of Texas at San Antonio 58,412.05 66 501.72 10 The University of Texas at Tyler 81,005.76 137 The University of Texas Permian Basin 54,220.64 24 The University of Texas Rio Grande Valley 16.210.44 22 The University of Texas System 15,049.44 11 University of Houston University of Houston System 0.00 66,043.62 7 12 University of Houston-Clear Lake 41,220.43 18 University of Houston-Downtown 65,168.18 132 University of Houston-Victoria Grand Total 61,478.68 17 Subledger Foots? (Yes/No) No 1. Sumlf in AR Testing 2. VLookup in Revenue Testing 2. Shipping Detail 3. Piv Background: You are testing the accuracy and valuation management assertion of the allowance for bad debt account for your client, Oakley Turf, using its A/R subsidiary ledger in cells A18:A67. Instructions: (1) Use the SUMIF function in cells B15:B17 to compute the sum for each balance status as efficiently as possible using Excel formulas; (2) Foot the A/R subsidiary ledger provided to the client's recorded A/R balance from the trial balance to make sure the information they provided you was complete. Also foot the A/R total in B18 and agree the amount to the client's recorded A/R balance (ensure it says "Yes" in cell D18); (3) Calculate your expectation for the Allowance for Bad Debt account in cell C21 and compare it to the client's recorded amount by calculating a difference between recorded and expected amounts in cell C22, and describe in cell B25 what (if any) steps you will take next as the auditor. All work on this assignment must be your team's own. Direct questions to your professor, not classmates. Accounts Receivable Balance per Client Performance Materiality Status Good standing Overdue Delinquent Status Good Standing Overdue Delinquent TOTAL Gross A/R Client's recorded Allowance for Bad Debt Auditor expectation of Allowance for Bad Debt Difference Based on the results of your testing herein, what should you do? Ask the client to provide an explanation for the difference Notify your audit senior of the difference Assuming the auditors and client disagree, for now record the difference on the Summary of Adjustments Passed (SOAP)? Account Receivable Subsidiary Ledger - Oakley Turf $2,121,309.22 $200,000.00 Defined | < 30 days outstanding 30-90 days outstanding >90 days outstanding Historical Collectibility per Client 0.95 0.90 0.80 Balance Aging Categories Foot? (Yes/No) No $150,000.00 Mark "Yes" or "No" Customer AR Balance Age (days) Grainger HDSupply 29,938.61 9 34,990.87 64 JoesSupply SpeedySupply BigTex Home Depot Lowe's TractorSupply TurnerCo XYZco AltaMaraCo Angelo State University Lamar University Midwestern State University Prairie View A&M University 77,480.45 56 30.602.34 19 21,394.43 5 11,319.70 119 0.00 17 58,432.75 25 52,577.58 84 24,290.71 15 15,569.81 10 62,582.40 111 39,355.90 15 71.901.54 122 45,772.62 18 Sam Houston State University 43,010.03 22 Stephen F. Austin State University 28,579.59 24 Sul Ross State University 23,071.30 23 Sul Ross State University Rio Grande College 36,332.16 23 Tarleton State University 7,208.01 29 Texas A&M International University 18,815.68 14 Texas A&M University 76,068.65 3 Texas A&M University at Galveston 73,152.05 116 Texas A&M University System 4,770.08 3 Texas A&M University-Central Texas 27,113.28 13 Texas A&M University-Commerce 69,700.92 24 Texas A&M University-Corpus Christi 49,592.24 20 Texas A&M University-Kingsville 65,681.28 102 Texas A&M University-San Antonio 59,396.95 25 Texas A&M University-Texarkana 9,500.23 22 Texas Southern University 87,326.06 68 Texas State University Texas State University System Texas Tech University University of North Texas 25,041.50 7 84,499.42 59 88,461.46 17 58,116.48 43 Texas Woman's University The University of Texas at Arlington 52,388.77 117 34,192.10 18 The University of Texas at Austin 31,220.27 93 The University of Texas at Dallas 32,550.04 17 The University of Texas at El Paso The University of Texas at San Antonio 58,412.05 66 501.72 10 The University of Texas at Tyler 81,005.76 137 The University of Texas Permian Basin 54,220.64 24 The University of Texas Rio Grande Valley 16.210.44 22 The University of Texas System 15,049.44 11 University of Houston University of Houston System 0.00 66,043.62 7 12 University of Houston-Clear Lake 41,220.43 18 University of Houston-Downtown 65,168.18 132 University of Houston-Victoria Grand Total 61,478.68 17 Subledger Foots? (Yes/No) No