The general ledger account for Accounts Receivable shows a debit balance of $4

The
general ledger account for Accounts Receivable shows a debit balance of
$40000. The Allowance for Uncollectible Accounts has a credit balance
of $2000. Net sales for the year were $250000. In the past 3 percent
of net sales have proved uncollectible. An aging of accounts receivable
accounts results in an estimate of $9000 of uncollectible accounts
receivable.Calculate
(1) Uncollectible Accounts Expense and (2) the ending balance of the
Allowance for Uncollectible Accounts using (a) the percentage of net
sales method and (b) the accounts receivable aging method.Create an Excel spreadsheet to submit your assignment.