Xercise Cycles Company has provided its year ended accounts receivables that were uncollected. The Controller has asked you to help prepare the Aging of Accounts Receivable Schedule and the corresponding journal entries. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.
1) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (fx).
2) Use the information above to complete the Aging of Accounts Recievable Schedule Below.
Create a formula for each age category, using the Excel IF and AND FUNCTION (fx) to determine where each customer amount belongs.
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 unadjusted balance:

Answering just the first question, the DAYS function is used to calculate the difference between day timelines. The function accepts two parameters, the first date which is the current date we are subtracting from, and the second date which is the previous date.