FILE 1. Prepare an aging of accounts receivable and compute bad debt expense. HOME INSERT x Calibri BIU Paste Clipboard B24 - Font Aging of accounts receivable method - Excel ? REVIEW VIEW Sign In PAGE LAYOUT FORMULAS DATA 11 ' ' % Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Styles fx =IF(E9 =, A B D E F 17 2) Use the information above to complete the Aging of Accounts Receivable Schedule below. 18 Create a formula for each age category, using the Excel IF and AND FUNCTIONS (fx) to determine where each customer amount belongs. 19 The IF statement may include the following arguments: ,>=, A 29 Workouts Unlimited 30 Total Accounts Receivable 31 Estimated Uncollectible( %) 32 Estimated Uncollectible ($) 33 B C D E F 2% 10% 20% 40% 34 3) Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts 35 had the following unadjusted balance: 36 Allowance for Doubtful Accounts 37 38 Bad Debt Expense 39 Allowance for Doubtful Accounts 40 $250 credit balance 41 4) Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts 42 had the following unadjusted balance: 43 Allowance for Doubtful Accounts 44 45 Bad Debt Expense 46 Allowance for Doubtful Accounts 47 48 49 50 $100 debit balance www READY Attempt(s) 0/3 Sheet1 B Hint 100% Show Me