please show work and explanation in excel. i'm getting a little confused on the language and discounts of this problem.

BRAMBLE COMPANY BALANCE SHEET (PARTIAL) DECEMBER 31, 2020 Cash $ 46,100 Accounts payable $ 56,560 $ 95,900 Notes payable 67.760 Accounts receivable Less: Allowance for doubtful accounts Inventory Prepaid expenses 8,850 87,050 $ 124,320 163,710 9.840 $ 306,700 The following errors in the corporation's accounting have been discovered: 1. 2. January 2021 cash disbursements entered as of December 2020 included payments of accounts payable in the 39,900, on which a cash discount of 2% was taken. The inventory included $ 31.250 of merchandise that had been received at December 31 but for which no purcha had been received or entered. Of this amount. $ 12.200 had been received on consignment; the remainder was pu fo.b.destination, terms 2/10,n/30. Sales for the first four days in January 2021 in the amount of $ 28,630 were entered in the sales journal as of Dece 2020. Of these. $23,360 were sales on account and the remainder were cash sales, 3. ch OL Question 3 of 8