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 Not yet due Up to one year past due More than one year past due Total accounts receivable Explanation D. Donalds-Account Receivable Sale Collection Collection Explanation N. Napier-Account Receivable Sale Collection Explanation Debit 13,000 Sale Collection Sale Collection Sale Collection Sale Debit 21,000 Explanation Sale Debit 8,000 S. Strothers-Account Receivable T. Thomas-Account Receivable Debit 4,000 9,000 21,000 4,000 $ Debit Credit 3,000 3,800 4,000 Required 1 Required 2 Compute the total accounts receivable in each age category. Age Amount Credit 8,000 6,000 Credit 1,000 Complete this question by entering your answers in the tabs below. Credit 4,000 4,500 5,000 Credit Balance 13,000 10,000 6,200 Balance 21,000 13,000 7,000 Required: 1. Compute the total accounts receivable in each age category. 2 Compute the estimated uncollectible amount for each age category and in total. Balance 8,000 7,000 Balance 4,000 0 9,000 4,500 25,500 20,500 24,500 Balance 4,000

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter5: Sales And Receivables
Section: Chapter Questions
Problem 85APSA: Determining Bad Debt Expense Using the Aging Method At the beginning of the year, Tennyson Auto...
icon
Related questions
icon
Concept explainers
Question

when providing the solution, can you explain how you get the values for "not yet due", "up to one year past due", "more than one year past due" because I do not know how to do that.

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
Not yet due
Up to one year past due
More than one year past due
Total accounts receivable
Explanation
D. Donalds-Account Receivable
Sale
Collection
Collection
Explanation
Sale
Collection
N. Napier-Account Receivable
Sale
Explanation
Sale
Collection
Sale
Collection
Sale
Collection
Sale
Debit
13,000
Debit
21,000
Debit
8,000
S. Strothers-Account Receivable
$
Debit
4,000
9,000
21,000
4,000
T. Thomas-Account Receivable
Explanation
Amount
Debit
4,000
Required 1 Required 2
Compute the total accounts receivable in each age category.
Age
Credit
3,000
3,800
Credit
8,000
6,000
0
Credit
1,000
Complete this question by entering your answers in the tabs below.
Credit
4,000
4,500
5,000
Credit
Balance
13,000
10,000
6,200
Balance
21,000
13,000
7,000
Required:
1. Compute the total accounts receivable in each age category.
2. Compute the estimated uncollectible amount for each age category and in total.
Balance
8,000
7,000
Balance
4,000
8
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 Not yet due Up to one year past due More than one year past due Total accounts receivable Explanation D. Donalds-Account Receivable Sale Collection Collection Explanation Sale Collection N. Napier-Account Receivable Sale Explanation Sale Collection Sale Collection Sale Collection Sale Debit 13,000 Debit 21,000 Debit 8,000 S. Strothers-Account Receivable $ Debit 4,000 9,000 21,000 4,000 T. Thomas-Account Receivable Explanation Amount Debit 4,000 Required 1 Required 2 Compute the total accounts receivable in each age category. Age Credit 3,000 3,800 Credit 8,000 6,000 0 Credit 1,000 Complete this question by entering your answers in the tabs below. Credit 4,000 4,500 5,000 Credit Balance 13,000 10,000 6,200 Balance 21,000 13,000 7,000 Required: 1. Compute the total accounts receivable in each age category. 2. Compute the estimated uncollectible amount for each age category and in total. Balance 8,000 7,000 Balance 4,000 8 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.
Similar questions
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,