Instructions Fill in the yellow cells, using formulas/cell references wherever possible The terms are net 30 days. 55,415 debit $1.000 credit Idr balance 1360 Balance of AR on 12/31/2021 Balance of Allowance for Doubtful Accounts on 12/31/2021 BEFORE adjusting the books A) Net Realizable Value of Accounts Receivable BEFORE adjusting the books subsidiary ledger A. Abel Fierman dr cr balance 12/14/10 purchase 8450 8450 LOVSD purchase 12/27/19 pald 3750 4700 11/20/19 purchase 12/20/19 purchase B. Barber dr CT balance G. Gaylord 11/15/19 purchase 6250 6250 12/5/19 purchase 1575 7825 9/22/19 eurchase 11/22/19 purchase C. Curran Tar IP There Icr 1360 875 1940 4175 dr cr 1250 4975 balance 1250 6225 ACC 213 Ch 7 template & instructions.xlsx G Sheet C. Curran dr lor 5400 balance 5400 12/2/19 purchase H. Harris dr D. Dapper cr 49251 balance 4.925 12/2919 purchase dr 5/10/19 purchase Cr 3250 balance 3250 1. Ireland dr E. Elmore 11001 4425 balance 1100 5525 dr 8/15/19 CM 9/2/19 purchase 3. Jones Jor 7225 18751 11/22/19 purchase 12/3/19 purchase balance 7225 9100 Tor 10/11719 eurchase 11/28/19 purchase cr 1590 2700 balance 1590 4290 LGH Company Accounts Receivable Aging Schedule 12/31/21 Number of een Previous Next Dashboard SHIH Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx G Sheet Customer Total Balance Current Number of Days Past Due 31-60 61-90 1 - 30 Over 90 A. Abel B Barber C. Curran D. Dapper E. Elmore F. Ferman G. Gaylord H Harris L. Ireland 1. Jones Total Acts Receivable 4.700 7.825 5,400 3,250 9.100 4.175 6,225 4.925 5,525 4.290 55,415 Make sure that the total of the receivables on your aging schedule is equal to the total Accounts Receivable ByCalculate the Balance Required in the Allowance for Doubful Accounts . Previous Next Dashboard Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx G Sheet % Likely Uncollectible 19 Required Allowance Balance 39 LGH uses the Aging of Receivables Method Number of Days Past Due A/R Amount 0 1 - 30 31-60 61-90 Over 90 Total C) Adjusting Entry 8% 20 50% Accounts Debit Crede Prepare the required adjusting entry after completing Part A aboveUse formules/call references for the debt and credit amounts Previous Next Dashboard SRE Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx Sheet1 D) After recording the adjusting entry, determine the following using calculations in Excel: Balance of A/R on 12/31/2021 before adjusting the books Balance of Allowance for Doubtful Accounts on 12/31/2021 AFTER adjusting the books Net Realizable value of Accounts Receivable AFTER adjusting the books Amount Debitor Credit? Une drop-down menu that will appear when you click on cell K E) Write-off entry: D. Dapper will not be able to pay the overdue amount owed. Write off the D. Dapper receivable. Account Title) Debit Credit Prepare the required journal entry to write of the D. Dapper Account Receivable Use formulas/cellences for debit and credit amounts ) Anter recording the adjusting entry, determine the following using calculations in Excel Balance of AR immediately after the write-off of D. Dapper's Account Receivable Balance of Allowance for Doubtful Accounts immediately after the write-off of dapper's R. Amount Debitor Credit? Uw dropdown that will appear when you click on cell Previous Next Dashboard BH Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx G Sheet1 Net Realizable Value of Accounts Receivable AFTER adjusting the books E) Write-off entry: D. Dapper will not be able to pay the overdue amount owed. Write off the D. Dapper receivable. Account Title Debit Credit Prepare the required journal entry to write of the Dapper Account Receivable Use formulas/cell references for debit and credit F) After recording the adjusting entry, determine the following using calculations in Excel Balance of AR immediately after the write-off of D. Dapper's Account Receivable Balance of Allowance for Doubtfut Accounts immediately after the write-off of dapper's AR Net Realizable Value of Accounts Receivable AFTER adjusting the books Amount Debitor Credit? Use drop-down menu ut will appear when you dick on cell Previous Next Dashboard SRE Calendar To Do Notifications Inbox Instructions Fill in the yellow cells, using formulas/cell references wherever possible The terms are net 30 days. 55,415 debit $1.000 credit Idr balance 1360 Balance of AR on 12/31/2021 Balance of Allowance for Doubtful Accounts on 12/31/2021 BEFORE adjusting the books A) Net Realizable Value of Accounts Receivable BEFORE adjusting the books subsidiary ledger A. Abel Fierman dr cr balance 12/14/10 purchase 8450 8450 LOVSD purchase 12/27/19 pald 3750 4700 11/20/19 purchase 12/20/19 purchase B. Barber dr CT balance G. Gaylord 11/15/19 purchase 6250 6250 12/5/19 purchase 1575 7825 9/22/19 eurchase 11/22/19 purchase C. Curran Tar IP There Icr 1360 875 1940 4175 dr cr 1250 4975 balance 1250 6225 ACC 213 Ch 7 template & instructions.xlsx G Sheet C. Curran dr lor 5400 balance 5400 12/2/19 purchase H. Harris dr D. Dapper cr 49251 balance 4.925 12/2919 purchase dr 5/10/19 purchase Cr 3250 balance 3250 1. Ireland dr E. Elmore 11001 4425 balance 1100 5525 dr 8/15/19 CM 9/2/19 purchase 3. Jones Jor 7225 18751 11/22/19 purchase 12/3/19 purchase balance 7225 9100 Tor 10/11719 eurchase 11/28/19 purchase cr 1590 2700 balance 1590 4290 LGH Company Accounts Receivable Aging Schedule 12/31/21 Number of een Previous Next Dashboard SHIH Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx G Sheet Customer Total Balance Current Number of Days Past Due 31-60 61-90 1 - 30 Over 90 A. Abel B Barber C. Curran D. Dapper E. Elmore F. Ferman G. Gaylord H Harris L. Ireland 1. Jones Total Acts Receivable 4.700 7.825 5,400 3,250 9.100 4.175 6,225 4.925 5,525 4.290 55,415 Make sure that the total of the receivables on your aging schedule is equal to the total Accounts Receivable ByCalculate the Balance Required in the Allowance for Doubful Accounts . Previous Next Dashboard Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx G Sheet % Likely Uncollectible 19 Required Allowance Balance 39 LGH uses the Aging of Receivables Method Number of Days Past Due A/R Amount 0 1 - 30 31-60 61-90 Over 90 Total C) Adjusting Entry 8% 20 50% Accounts Debit Crede Prepare the required adjusting entry after completing Part A aboveUse formules/call references for the debt and credit amounts Previous Next Dashboard SRE Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx Sheet1 D) After recording the adjusting entry, determine the following using calculations in Excel: Balance of A/R on 12/31/2021 before adjusting the books Balance of Allowance for Doubtful Accounts on 12/31/2021 AFTER adjusting the books Net Realizable value of Accounts Receivable AFTER adjusting the books Amount Debitor Credit? Une drop-down menu that will appear when you click on cell K E) Write-off entry: D. Dapper will not be able to pay the overdue amount owed. Write off the D. Dapper receivable. Account Title) Debit Credit Prepare the required journal entry to write of the D. Dapper Account Receivable Use formulas/cellences for debit and credit amounts ) Anter recording the adjusting entry, determine the following using calculations in Excel Balance of AR immediately after the write-off of D. Dapper's Account Receivable Balance of Allowance for Doubtful Accounts immediately after the write-off of dapper's R. Amount Debitor Credit? Uw dropdown that will appear when you click on cell Previous Next Dashboard BH Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx G Sheet1 Net Realizable Value of Accounts Receivable AFTER adjusting the books E) Write-off entry: D. Dapper will not be able to pay the overdue amount owed. Write off the D. Dapper receivable. Account Title Debit Credit Prepare the required journal entry to write of the Dapper Account Receivable Use formulas/cell references for debit and credit F) After recording the adjusting entry, determine the following using calculations in Excel Balance of AR immediately after the write-off of D. Dapper's Account Receivable Balance of Allowance for Doubtfut Accounts immediately after the write-off of dapper's AR Net Realizable Value of Accounts Receivable AFTER adjusting the books Amount Debitor Credit? Use drop-down menu ut will appear when you dick on cell Previous Next Dashboard SRE Calendar To Do Notifications Inbox