if you can not read it, just skip, please dont comment on the post. thank you.

ACC 213 Ch 7 template & instructions.xlsx 55,415 debit $1.000 credit dr ACC 213 Assignment: Lab #6 for Chapter 7 Name Instructions Fil in the yellow cells, using formulas/cell references wherever possible The terms are not 30 days. Balance of A/R 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 F. Fierman Idr Cr balance 12/14/19 purchase 8450 8450 LOVS/19 purchase 12/27/19 paid 3750 4700 11/20/10 purchase 12/20/19 purchase 3. Barber dr ICT balance G. Gaylord 1117 purchase 6250 12/5/19 purchase 1575 7825 9220 Chase 11/22/19 purchase C. Curran Idr lor Ibalance or 2360 875 19401 balance 1360 2235 4175 dr CY 12501 4975 balance 1250 6225 Previous Next Dashboard SRE Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx Idr Cr 5400 balance 5400 12/2/19 purchase M. Harris Idr D. Dapper 12/29/9 purchase CT 4925 balance 4,925 Idr ICT 3250 balance 3250 5/10/19 purchase 1. Ireland dr 1. Elmore lar 11001 4425 balance 1100 5525 Idr 8/15/10 Burchase 9/2/10 purchase 1. Jones ICF balance 7225 11/22/19 purchase 12/3/19 purchase 235 1875 9100 Idr 10/11/19 purchase 11/28/19 purchase Cr 1590 27001 balance 1590 4290 LGH Company Accounts Receivable Aging Schedule 12/31/21 Number of Days. Past Due Total Balance Current 21.60 Customer Over 90 Previous Next Dashboard BH Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx 700 A. Abel B Barber c. Ourran D. Dapper E. Elmore Ferman G. Gaylord H. Harris 1.treland Jones Total Acts Receivable 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 Turto balneori Atlete Calculate the Balance Required in the Allowance for Doubful Accounts LGH uses the Aging of Receivables Method Ukely Number of Days Post Oue MR Amount Uncollectible 19 Required Allowance Balance Previous Next Dashboard SHIH Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx 0 1 - 30 31-60 61-90 Over 3 89 20% 50% Total Account TILO Debit Credit C) Adjusting Entry Prepare the required adjusting entry after completing Partsbove. Use formulas/cell references for the debt and credit amounts Amount D) After recording the adjusting entry, determine the following using calculations in Excel Balance of NR on 12/30/2021 before adjusting the books Balance of Allowance for Doubtful AS on 12/30/2021 AFTER adjusting the books Net Realizable value of Accounts Receivable AFTER adjusting the books Debitor Credit Une drop-down menu that will appear when you click on cell Previous Next Dashboard Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx 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 of the D. Dapper receivable. Account Title Debit Credit Prepare their journal entry to write of the D. 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 A/Rimmediately after the write-off of D. Dapper's Account Receivable Balance of Allowance for Doubtful Accounts immediately after the write-off of D. dapper's A/R. Net Realizable Value of Accounts Receivable AFTER adjusting the books Amount Debitor Credit? Usa drop-down menu that will appear when you click on tell Previous Next Dashboard BH Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx 55,415 debit $1.000 credit dr ACC 213 Assignment: Lab #6 for Chapter 7 Name Instructions Fil in the yellow cells, using formulas/cell references wherever possible The terms are not 30 days. Balance of A/R 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 F. Fierman Idr Cr balance 12/14/19 purchase 8450 8450 LOVS/19 purchase 12/27/19 paid 3750 4700 11/20/10 purchase 12/20/19 purchase 3. Barber dr ICT balance G. Gaylord 1117 purchase 6250 12/5/19 purchase 1575 7825 9220 Chase 11/22/19 purchase C. Curran Idr lor Ibalance or 2360 875 19401 balance 1360 2235 4175 dr CY 12501 4975 balance 1250 6225 Previous Next Dashboard SRE Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx Idr Cr 5400 balance 5400 12/2/19 purchase M. Harris Idr D. Dapper 12/29/9 purchase CT 4925 balance 4,925 Idr ICT 3250 balance 3250 5/10/19 purchase 1. Ireland dr 1. Elmore lar 11001 4425 balance 1100 5525 Idr 8/15/10 Burchase 9/2/10 purchase 1. Jones ICF balance 7225 11/22/19 purchase 12/3/19 purchase 235 1875 9100 Idr 10/11/19 purchase 11/28/19 purchase Cr 1590 27001 balance 1590 4290 LGH Company Accounts Receivable Aging Schedule 12/31/21 Number of Days. Past Due Total Balance Current 21.60 Customer Over 90 Previous Next Dashboard BH Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx 700 A. Abel B Barber c. Ourran D. Dapper E. Elmore Ferman G. Gaylord H. Harris 1.treland Jones Total Acts Receivable 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 Turto balneori Atlete Calculate the Balance Required in the Allowance for Doubful Accounts LGH uses the Aging of Receivables Method Ukely Number of Days Post Oue MR Amount Uncollectible 19 Required Allowance Balance Previous Next Dashboard SHIH Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx 0 1 - 30 31-60 61-90 Over 3 89 20% 50% Total Account TILO Debit Credit C) Adjusting Entry Prepare the required adjusting entry after completing Partsbove. Use formulas/cell references for the debt and credit amounts Amount D) After recording the adjusting entry, determine the following using calculations in Excel Balance of NR on 12/30/2021 before adjusting the books Balance of Allowance for Doubtful AS on 12/30/2021 AFTER adjusting the books Net Realizable value of Accounts Receivable AFTER adjusting the books Debitor Credit Une drop-down menu that will appear when you click on cell Previous Next Dashboard Calendar To Do Notifications Inbox ACC 213 Ch 7 template & instructions.xlsx 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 of the D. Dapper receivable. Account Title Debit Credit Prepare their journal entry to write of the D. 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 A/Rimmediately after the write-off of D. Dapper's Account Receivable Balance of Allowance for Doubtful Accounts immediately after the write-off of D. dapper's A/R. Net Realizable Value of Accounts Receivable AFTER adjusting the books Amount Debitor Credit? Usa drop-down menu that will appear when you click on tell Previous Next Dashboard BH Calendar To Do Notifications Inbox