For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 15 1. Calculate the estimated amount of uncollectible accounts within each age group and the allowance for uncollectible accounfs. 16 (Use celts AZ to C12 from the given information above to complete this question.) 12. 27 2. Prepare the year-end journal entry to adjust the allowance account, assuming that the balance of the Allowance for Uncollectible 28 Accounts before adjustment is the amount shown in cell B10. 27 2. Prepare the year-end journal entry to adjust the allowance account, assuming that the balance of the Allowance for Uncollectible 28 Accounts before adjustment is the amount shown in cell B10. 29 (Use cells A2 to C12 from the given information above to complete this question. 3s 36 3. Calculate net accounts receivable reported on the balance sheet at year-end. 37 (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. A company provides the following aging schedule for its accounts receivable on December 31,201. Allowance for Uncollectible Accounts (credit balance) 4,100 Requlred: 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 recelvable 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