1 1 Prepare an aging of accounts receivable and compute bad debt expense. OB 7 HE HOME DUSENT IMGE LAYOUT FORMULAS CA REVIEW VW AA TU % Alger Number Conditional formats Formatting Table Sy Styles Cells Eig Fon Xercise Cycles Company sells exercise equipment to gyms on cont. At year ces E 1 Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected 2 Required: 4 Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION(). 5 6 Nether 17 Invoice Date Today's Date Days Up # Fitness Man 2.500 6/17/2016 1231/2016 9 Health for Lee 2000 1221/2016 12/31/2016 10 Holistic Health Options 12.750 10/12/2016 1231/2016 11 mape Keimuring 7,000 12/5/2016 1231/2016 12 Today's Gymi World 45600 11/29/2016 12331/2016 13 Whole e Fitness Center 15900 11/20/2016 TUT2016 14 Workouts Unlimited 3.800 10/2/2016 12331/2015 15 Total S 48.550 36 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 (f) to determine where each customer amount belongs. 19 The IP statement may include the following argument: > Excel AND FUNCTION(). 20 21 Number of Days Unpaid Customer One Total Sheets 107 WY Allemes > Excel AND FUNCTION() 21 Number of Days Lap 23 Comer 0-30 31-40 61.90 Orer Tocal a Fitness Mania 3 Health for Life Holistic Health Options 26 Image Reimaging 27 Today Gym World 2 Whole Lille Fitness Center 29 Workouts Unlimited Total Accounts Receivable 31 Estimated Uncollectibles 29 101 2015 4041 22 Estimated Uncollectible (5) 23 3) Prepare the justing journal entry for recording had debit expense of the Allowance for Doubtful Account 35 had the following unadjusted balance 36 Mowane for thitful Accounts $150 credit balance Sheet1 READY 100% Attempt