Digital depot company, which operates a chain of 40 electronics supply stores, has just completed its fourth year of operations. the direct write-off method of recording bad debt expense has been used during the entire period. because of substantial increases in sales volume and the amount of uncollectible accounts, the firm is considering changing to the allowance method. information is requested as to the effect that an annual provision of ¼% of sales would have had on the amount of bad debt expense reported for each of the past four years. it is also considered desirable to know what the balance of allowance for doubtful accounts would have been at the end of each year. the following data have been obtained from the accounts: year sales uncollectible accounts written off years of origin of accounts receivablewritten off as uncollectible(1st) (2nd) (3rd) (4th)1st $12,500,000 $18,000 $18,000 2nd 14,800,000 30,200 9,000 $21,200 3rd 18,000,000 39,900 3,600 9,300 $27,000 4th 24,000,000 52,600 5,100 12,500 $35,000required: 1. assemble the desired data to prepare a schedule of bad debt expense. enter decreases as negative numbers using a minus sign.2. experience during the first four years of operations indicated that the receivables were either collected within two years or had to be written off as uncollectible. does the estimate of ¼% of sales appear to be reasonably close to the actual experience with uncollectible accounts originating during the first two years? schedule of bad debt expenseassemble the desired data to prepare a schedule of bad debt expense. enter decreases as negative numbers using a minus sign. digital depot companyschedule of bad debt expense1yearexpense actually reportedexpense based on estimateincrease (decrease) in amount of expensebalance of allowance account, end of year21st? ? ? ? 32nd? ? ? ? 43rd? ? ? ? 54th? ? ? ?