3) Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts had the following unadjusted balance: 4) Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts had the following unadiusted balance: 7. 2) Use the information above to complete the Aging of Accounts Receivable Schedule below. Create a formula for each age category, using the Excel IF and AND FUNCTIONS (fx) to determine where each customer amount belongs. The IF statement may include the following arguments: