At the end of Year 5. your consulting firm has been hired by a local service firm to help forecast future uncollectible accounts. You ask the service firm to provide several years of data on the percentage of uncollectible accounts based on the age categories of accounts receivable at the beginning of the year. With these historical percentages, you estimate a trendline uashed line) to predict the percentage of uncollectible accounts for Year 6, the upcoming year. Graphs were provided to management from your analysis of each of the three age categories, as well as balances of accounts receivable by age category at the end of Year 5 as follows: Percentage of Uncollectible Accounts: Not Yet Past Due 1-30 Days Past Due Over 30 Days Past Due 18% 46% 16% 44% 6% 16 A 54 14% 15% 43% 14% 14% 42% 3% 2x 12% 41% A 09 10% 2 Year 1 3 4 Yearl 2 5 3 4 Year 1 2 4 3 3 Accounts Receivable by Age: End of Year $140,000 5128000 5120,000 5100.000 584 000 S80.000 535,000 S40,000 520.000 50 Hui Yel Pal D 190 ps De Own Required: 1. Which age categories predicts the lowest percentage of uncollectible accounts for Year 6? 2. Which age categories predicts the test percentage of uncollectible accounts for Year 6? 3. What is the dollar amount of accounts receivable that are 1-30 days past due at the end of year 5 bottom graphi? 4. Calculate the tatal amount of estimated uncollectible accounts for Year 6 (Hint: Use all three age categories 5. Assume the balance of Allowance for Uncollectible Accounts is $4,850 (credit) at the end of Year 5 (before any adjustment). Prepare the adjusting entry at the end of Year 5. 6. Determine the amount of net accounts receivable the company would report at the end of Year 5. Complete this question by entering your answers in the tabs below. Required 1 Required Required) Required 4 pored Required Assume the balance of Allowance for Uncollectible Accounts is $4,850 (credit) at the end of Year 5 (before any adjustment). Prepare the adjusting entry at the end of Year 5. (If no entry is required for a particular transaction/event, select "No lournal Entry Required in the first account field.) View transaction list View journal entry worksheet No Event General Joumal Debit Credit 1 1 No Transaction Readed