Blue Skies Equipment Company uses the aging approach to estimate bad debt expense at the end of each accounting year. Credit sales occur frequently on terms n/60. The balance of each account receivable is aged on the basis of three time periods as follows: (1) not yet due, (2) up to one year past due, and (3) more than one year past due. Experience has shown that for each age group, the average loss rate on the amount of the receivable at year-end due to uncollectibility is (a) 3 percent, (b) 9 percent, and (c) 28 percent, respectively. At December 31, 2022 (end of the current accounting year), the Accounts Receivable balance was $48,700 and the Allowance for Doubtful Accounts balance was $920 (credit). In determining which accounts have been paid, the company applies collections to the oldest sales first. To simplify, only five customer accounts are used; the details of each on December 31, 2022, follow: Date 03/11/2021 06/30/2021 01/31/2022 Date 02/28/2022 04/15/2022 11/30/2022 Date 11/30/2022 12/15/2022 Date 03/02/2020 04/15/2020 09/01/2021 10/15/2021 02/01/2022 03/01/2022 12/31/2022 Date 12/30/2022 B. Brown-Account Receivable Explanation Sale Collection Collection Explanation Sale Collection Collection Sale Explanation Collection Sale Explanation Sale D. Donalds-Account Receivable Collection Sale Collection Sale Collection Sale Debit 13,000 N. Napier-Account Receivable Debit 21,000 Explanation Debit 8,000 S. Strothers-Account Receivable Debit 4,000 9,000 Credit 21,000 3,000 3,800 4,000 Credit Debit 4,000 8,000 6,000 Credit 1,000 Credit 4,000 4,500 T. Thomas-Account Receivable 5,000 Credit Balance 13,000 10,000 6,200 Balance 21,000 13,000 7,000 Balance 8,000 7,000 Balance 4,000 0 9,000 4,500 25,500 20,500 24,500 Balance 4,000

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Problem is in the first attachment and the question that needs to be answered is in the second screenshot/

Required:
1. Compute the total accounts receivable in each age category.
2. Compute the estimated uncollectible amount for each age category and in total.
Complete this question by entering your answers in the tabs below.
Required 1 Required 2
Compute the total accounts receivable in each age category.
Age
Not yet due
Up to one year past due
More than one year past due
Total accounts receivable
Amount
Transcribed Image Text:Required: 1. Compute the total accounts receivable in each age category. 2. Compute the estimated uncollectible amount for each age category and in total. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the total accounts receivable in each age category. Age Not yet due Up to one year past due More than one year past due Total accounts receivable Amount
Blue Skies Equipment Company uses the aging approach to estimate bad debt expense at the end of each accounting
year. Credit sales occur frequently on terms n/60. The balance of each account receivable is aged on the basis of three
time periods as follows: (1) not yet due, (2) up to one year past due, and (3) more than one year past due. Experience has
shown that for each age group, the average loss rate on the amount of the receivable at year-end due to uncollectibility is
(a) 3 percent, (b) 9 percent, and (c) 28 percent, respectively.
At December 31, 2022 (end of the current accounting year), the Accounts Receivable balance was $48,700 and the
Allowance for Doubtful Accounts balance was $920 (credit). In determining which accounts have been paid, the company
applies collections to the oldest sales first. To simplify, only five customer accounts are used; the details of each on
December 31, 2022, follow:
Date
03/11/2021
06/30/2021
01/31/2022
Date
02/28/2022
04/15/2022
11/30/2022
Date
11/30/2022
12/15/2022
Date
03/02/2020
04/15/2020
09/01/2021
10/15/2021
02/01/2022
03/01/2022
12/31/2022
Date
12/30/2022
B. Brown-Account Receivable
Explanation
Sale
Collection
Collection
Explanation
Sale
Collection
Collection
Sale
Explanation
Collection
Sale
Explanation
Sale
D. Donalds-Account Receivable
Collection
Sale
Collection
Sale
Collection
Sale
Debit
13,000
N. Napier-Account Receivable
Debit
21,000
Explanation
Debit
8,000
S. Strothers-Account Receivable
Debit
4,000
9,000
21,000
Credit
4,000
3,000
3,800
Debit
Credit
4,000
8,000
6,000
Credit
1,000
Credit
4,000
T. Thomas-Account Receivable
4,500
5,000
Credit
Balance
13,000
10,000
6,200
Balance
21,000
13,000
7,000
Balance
8,000
7,000
Balance
4,000
0
9,000
4,500
25,500
20,500
24,500
Balance
4,000
Transcribed Image Text:Blue Skies Equipment Company uses the aging approach to estimate bad debt expense at the end of each accounting year. Credit sales occur frequently on terms n/60. The balance of each account receivable is aged on the basis of three time periods as follows: (1) not yet due, (2) up to one year past due, and (3) more than one year past due. Experience has shown that for each age group, the average loss rate on the amount of the receivable at year-end due to uncollectibility is (a) 3 percent, (b) 9 percent, and (c) 28 percent, respectively. At December 31, 2022 (end of the current accounting year), the Accounts Receivable balance was $48,700 and the Allowance for Doubtful Accounts balance was $920 (credit). In determining which accounts have been paid, the company applies collections to the oldest sales first. To simplify, only five customer accounts are used; the details of each on December 31, 2022, follow: Date 03/11/2021 06/30/2021 01/31/2022 Date 02/28/2022 04/15/2022 11/30/2022 Date 11/30/2022 12/15/2022 Date 03/02/2020 04/15/2020 09/01/2021 10/15/2021 02/01/2022 03/01/2022 12/31/2022 Date 12/30/2022 B. Brown-Account Receivable Explanation Sale Collection Collection Explanation Sale Collection Collection Sale Explanation Collection Sale Explanation Sale D. Donalds-Account Receivable Collection Sale Collection Sale Collection Sale Debit 13,000 N. Napier-Account Receivable Debit 21,000 Explanation Debit 8,000 S. Strothers-Account Receivable Debit 4,000 9,000 21,000 Credit 4,000 3,000 3,800 Debit Credit 4,000 8,000 6,000 Credit 1,000 Credit 4,000 T. Thomas-Account Receivable 4,500 5,000 Credit Balance 13,000 10,000 6,200 Balance 21,000 13,000 7,000 Balance 8,000 7,000 Balance 4,000 0 9,000 4,500 25,500 20,500 24,500 Balance 4,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Receivables Management
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education