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.) 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. 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 additional 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