please show all work through excel. thanks in advance.

Patrick Company had the following information in 2021 (Click the icon to view the information.) If uncollectible accounts are determined by the aging-of-receivables method to be $1,280, the uncollectible account expense for 2021 would be $480. Using the aging-of-receivables method the balance of the Allowance account after the adjusting entry at year-end 2021 would be - X Data table $ O A. $800. B. $1,280. OC. $520 OD. $480 13,000 800 Accounts receivable 12/31/21 Allowance for uncollectible-accounts credit balance 12/31/21 (before adjustment) Credit service revenue during 2021 Cash service revenue during 2021 Collections from customers on account during 2021 43,000 13,000 42,000 Print Done