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.

D F . Kercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected 2 3 Required: 4 L) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (fx). 5 S 6 7 Customer 8 Fitness Mania 9 Health for Life 10 holistic Health Options 11 mage Reimaging 12 Today's Gym World 13 Nhole Life Fitness Center 14 Norkouts Unlimited 15 Total 16 Amount 2,500 2,000 12,750 7,000 4,600 15,900 3,800 48,550 Invoice Date 6/17/2016 12/21/2016 10/12/2016 12/5/2016 11/29/2016 11/20/2016 10/2/2016 Today's Date 12/31/2016 12/31/2016 12/31/2016 12/31/2016 12/31/2016 12/31/2016 12/31/2016 Number of Days Unpaid 197 10 80 26 32 41 90 S A1 for Xercise Cycles Company sells exercise equipment to gyms on account. At year 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: ,