Please format answers as formulas :)

Aging of accounts receivable method - Excel PAGE LAYOUT FORMULAS DATA REVIEW FILE HOME INSERT VIEW Sign In Calibri AA BIU- Cells Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font B23 A C D E Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected 2 3 Required: 1) calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (FX). 5 7 Customer 8 Fitness Mania 9 Health for Life 10 Holistic Health Options 11 Image Reimaging 12 Today's Gym World 13 Whole Life Fitness Center 14 Workouts Unlimited 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 261 321 41 90 15 Total $ 16 Total 17 Use the informanon above to complete the aging or Accounts receivable schedule below. 18 reate a formula for each age category, using the Excel IF and AND FUNCTIONS (fx) to determine where eh customer mount belongs. 19 he IF statement may include the following arguments: ,