xercise cycles company sells exercise equipment to gyms on account. At year-end, the following accounts receivable were uncollected.  Require  A)calculate the number of days unpaid, using excel DAYS function

Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter8: Inventories: Special Valuation Issues
Section: Chapter Questions
Problem 18E: Errors During the course of your examination of the financial statements of Burnett Co., a new...
icon
Related questions
icon
Concept explainers
Question

xercise cycles company sells exercise equipment to gyms on account. At year-end, the following accounts receivable were uncollected. 

Require 

A)calculate the number of days unpaid, using excel DAYS function?

Number of
Today's Date
12/31/2022
12/31/2022
12/31/2022
12/31/2022
12/31/2022|
12/31/2022
12/31/2022
Customer
Amount
Invoice Date
Days Unpaid
$2,500
1,900|
12,750
7,000
4,600
15,900
3,800
$48,450
6/17/2022
12/21/2022
10/12/2022
12/5/2022
11/29/2022
11/20/2022
10/2/2022
Fitness Mania
Health for Life
Holistic Health Options
Image Reimaging
Today's Gym World
Whole Life Fitness Center
Workouts Unlimited
Total
Transcribed Image Text:Number of Today's Date 12/31/2022 12/31/2022 12/31/2022 12/31/2022 12/31/2022| 12/31/2022 12/31/2022 Customer Amount Invoice Date Days Unpaid $2,500 1,900| 12,750 7,000 4,600 15,900 3,800 $48,450 6/17/2022 12/21/2022 10/12/2022 12/5/2022 11/29/2022 11/20/2022 10/2/2022 Fitness Mania Health for Life Holistic Health Options Image Reimaging Today's Gym World Whole Life Fitness Center Workouts Unlimited Total
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning