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 teams own. Direct questions to your professor, not classmates. Accounts Receivable Balance per Client $2,121,309.22 Performance Materiality $200,000.00 Status Defined Historical Collectibility per Client Good standing < 30 days outstanding 0.95 Overdue 30-90 days outstanding 0.90 Delinquent > 90 days outstanding 0.80 Status Balance Good Standing Overdue Delinquent Aging Categories Foot? (Yes/No) TOTAL Gross A/R No Client's recorded Allowance for Bad Debt $150,000.00 Auditor expectation of Allowance for Bad Debt Difference Based on the results of your testing herein, what should you do? Mark "Yes" or "No" 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 Customer AR Balance Age (days) Grainger 29,938.61 9 HDSupply 34,990.87 64 JoesSupply 77,480.45 56 SpeedySupply 30,602.34 19 BigTex 21,394.43 5 HomeDepot 11,319.70 119 Lowe's 0.00 17 TractorSupply 58,432.75 25 TurnerCo 52,577.58 84 XYZco 24,290.71 15 AltaMaraCo 15,569.81 10 Angelo State University 62,582.40 111 Lamar University 39,355.90 15 Midwestern State University 71,901.54 122 Prairie View A&M University 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 25,041.50 7 Texas State University System 84,499.42 59 Texas Tech University 88,461.46 17 University of North Texas 58,116.48 43 Texas Woman's University 52,388.77 117 The University of Texas at Arlington 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 58,412.05 66 The University of Texas at San Antonio 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 0.00 7 University of Houston System 66,043.62 12 University of Houston-Clear Lake 41,220.43 18 University of Houston-Downtown 65,168.18 132 University of Houston-Victoria 61,478.68 17 Grand Total Subledger Foots? (Yes/No) No