i need this asap please

company provides the following aging schedule for its accounts receivable on December 31,201. Allowance for Uncollectible Accounts (credit balance) 4,100 Required: 1. Calculate the estimated amount of uncollectible accounts within each age group and the allowance for uncollectible accounts. 2. Prepare the year-end journal entry to adjust the allowance account, assuming that the balance of the Allowance for Uncollectible Accounts before adjustment is the amount shown in cell B10. 3. Calculate net accounts receivable reported on the balance sheet at year-end. 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. 1. Calculate the estimated amount of uncollectible accounts within each age group and the allowance for uncollectible accounts. (Use cells A2 to C12 from the given information above to complete this question.) 2. Prepare the year-end journal entry to adjust the allowance account, assuming that the balance of the Allowance for Uncollectible Accounts before adjustment is the amount shown in cell B10. 2. Prepare the vear-end journal entry to adjust the allowance account, assuming that the balance of the Allowance for Uncollectible Accounts before adjustment is the amount shown in cell B10. (Use cells A2 to C12 from the given information above to complete this question. 3. Caiculate net accounts receivable reported on the balance sheet at year-end. (Use cells A2 to C12 from the given information above to complete this question. A credit balance in the Allowance account should be shown as a negative value.)