You will be asked to analyze the accounts receivable of a company. The aging schedule is in this unit's template. Assume the following percentages in determining the total amount of uncollectable receivables. The percent likely to be uncollectable: 1% (Current), 5% (0-30 Days), 10% (31-60 Days), 20% (61-90 Days) and 50% (Over 90 Days) In addition, analyze each individual account to determine if the customer is current or past due. (Past due is defined as the total balance being more than the amount that is current) Use formulas and conditional formatting to determine the accounts that are current and the past due accounts. In addition, create a pivot table indicating the number of customers by their current and past due status, how many of the accounts are current and how many of the past due accounts fall under each receivable category (current, 0-30 days, etc.)