Please read what the question is askinn and answer

Excel Inc. has provided the following information relating to its sales for the past year, which ended December 31, 20x1. Estimated % of accounts receivable that will be uncollectable 4% Opening Balances: Jan. 1, 20xi balance in the allowance for doubtful account $2,000 cr (this is before any adjusting entries) 1 2 Jan 1, 20x1 balance in the accounts receivable account $37,000 dr 3 4 During 20x1: 5 Credit sales (20x1) $450,000 16 Write offs of uncollectible accounts receivable (20x1) $6,200 17 Collections of previously written off amounts (20x1) $900 18 Cash received in payment of accounts receivable (20x1) $426,000 19 20 21 Required - 22 23 1) Calculate the balance in the Accounts Receivable account at December 31, 20x1. (1 mark) 24 25 2) Calculate the balance in the Allowance for Doubtful Accounts at December 31, 20x1. (2 marks) 26 27 3) Prepare any journal entries required at December 31, 20x1 to record bad debt expense for the year. (3 marks) 28 29 30 31 32