The general ledger account for AccountsReceivable shows a debit balance of $4000

The general ledger account for AccountsReceivable shows a debit balance of $40000. The Allowance forUncollectible Accounts has a credit balance of $2000. Net salesfor the year were $250000. In the past 3 percent of net saleshave proved uncollectible. An aging of account receivableresults in an estimate of $9000 of uncollectible accountsreceivable.Calculate (1) Uncollectible Accounts Expense and(2) the ending balance of the Allowance for Uncollectible Accountsusing (a) the percentage of net sales method and (b) the accountsreceivable aging method.Create an Excel spreadsheet to submit yourassignment.