Aging of accounts receivable method 1. Prepare an aging of accounts receivable schedule and compute bad debt expense. ? 6 X Aging of accounts receivable method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in FILE HOME INSERT M X Calibri 11 - A A Cells Editing Paste B TU CE . Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cipboard Font A1 Xercise Cycles Company sells exercise equipment to gyms on account. At year F D B 1 E Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected. NON 2 3 Required: 4 1) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (fx). 5 Number of Days Unpaid Amount Customer Invoice Date Today's Date REDIT EXCEL Aging of AR D 6 Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected 2 3 Required: 41) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (Ex). 5 Number of 7 Customer Amount Tovalce Date Today's Date Days Unpad 8 Fitness Mania $ 2,500 6/17/2016 12/31/2016 9 Health for Life 2,000 12/21/2016 12/31/2016 10 Holistic Health Options 12.750 10/12/2016 12/31/2016 11 Image Reimaging 7,000 12/5/2016 12/31/2016 12 Today's Gym World 4.600 11/29/2016 12/31/2016 13 Whole Life Fitness Center 15.900 11/20/2016 12/31/2016 14 Workouts Unlimited 3,800 10/2/2016 12/31/2015 $ 48.550 16 17 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(x) to determine where each customer amount belongs 19 The IF statement may include the following arguments: > Excel AND FUNCTION() 20 Number of Days Unpaid 22 Customer 0-30 31-60 61.90 Over 90 Total 15 Total Pre 1 of 1 e to search O E 2 3 5. 6 7 00 9 RT Yu P B D 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: , >,