please help

Chapter 9 Graded Homework Assignment - Accounts Receivable Attached Files: Chapter 9 - Graded Homework A:R.jpeg (101.207 KB) Ch 9 Graded HW Problem Aging Template.xlsx (10.186 KB) General Journal Excel Template.xlsx (17.188 KB) Please find attached the Chapter 9 Graded Homework Assignment covering Accounts Receivable. Attached you will find the problem, the template for the Allowance T Account and Aging of Accounts Receivable (you must complet this based on info from the problem), and a general journal template for you journal entries (using proper journal entry format). doduotod for lateness Aging of Accounts Recievable Allowance for Doubtful Accounts Year 2 9000 1/1 Aging of Accounts Recievable Schedule 12/31/2 Days Past Due 1-30 31-60 Name Total A/R Current Over 60 B D Others Total % of Uncollectability Estimated Bad Debts = Part b - see the bottom of the graded homework problem Based on the completed Aging Schedule and a credit balance of 375 in the Allowance, determine the amount of the Adjusting ]/E Allow for Doubtful Accts 375 12/31/02 ADJ JE Desired Balance Allowance for Doubtful Accounts Receivable - Prepare Journal Entries Accounts 9,000 Transactions 311 Wlo AR Jones $5,000 5/1Wlo AR Smith & 3000 8/1 WO AR Baker $ 2500 Jul collect ,250 foom Baker 12/31 Provide adj. Tle for Bad Debts. Aging of AIR Current ouer 60 Name TOT AIR 1 - 30 31-60 A / 2,000 10, cop 2,000 B 8,000 4, doo 12 odo 8.000 15, 000 8, doo 4,000 2,000 1.000 D 5,000 3,000 2, dod others 100,ooo 190,000 6, bob 3, doo 1.000 740, DOD % of uncollectibility W2 X 10% X 20% x 40% + Est Bed Debts et, 2 What would the year-end adjusting journal entry be given the following Allow to DA 375 GENERAL JOURNAL Page 1 Date Account Titles & Explanation Ref. Debit Credit