A company provides the following aging schedule for its accounts recelvable on December 31,20X. Allowance for Uncollectible Accounts (credit balance) 4,100 Required: 1. Calculate the estimated amount of uncoliectible 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 bolance of the Allowance for Uncoliect ble Accounts before adjustment is the amount shown in cell B10. 3. Calculate net accounts receivable reported on the balance sheet at year-end. Navigation: 1. Use the Open Excet in New Tab button to Inunch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Required: 1. Caiculate the estamated amount of uncollectoble actounts whin exch age group and the allowance for uncolectoble actounts (Use cells A2 to C12 trom the eiven information above to complete this question.) Graded Workshot 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. (Use cells A2 to Cl2 from the given information above to complete this question. 3. Calculate 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.) Students: The scratchpad area is for you to do any addirional work you need to solve this question or can be used to show your work. Nothing in this area will be graded, but it will be submitted with your assignment