Question: Please fill out the cell formulas out correctly. Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable


Please fill out the cell formulas out correctly.
Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected. Required: 1) Calculate the number of days unpaid, using the Excel DAYS function. Number of Days Unpaid Customer Fitness Mania Health for Life Holistic Health Options Image Reimaging Today's Gym World Whole Life Fitness Center Workouts Unlimited Total Amount $2,500 1,900 12,750 7,000 4,600 15,900 3,800 $48,450 Invoice Date 6/17/2022 12/21/2022 10/12/2022 12/5/2022 11/29/2022 11/20/2022 10/2/2022 Today's Date 12/31/2022 12/31/2022 12/31/2022 12/31/2022 12/31/2022 12/31/2022 12/31/2022 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 function to determine where each customer amount belongs. Calculate each "Total" cell by using the Excel SUM function and include all possible cells. Leave no cells blank. HINT: Use the =AND function to check for date ranges. For example, =IF(AND(E8>30, E8
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
