### Computing Bad Debt Expense Using Aging Analysis **Scenario: Lin’s Dairy** Lin’s Dairy uses the aging approach to estimate bad debt expense. The aging approach categorizes account receivables based on their age and applies different estimated loss percentages to these categories to determine potential uncollectible amounts. **Account Aging Categories:** 1. **Not yet due:** $16,800 2. **Up to 120 days past due:** $6,700 3. **More than 120 days past due:** $4,200 **Estimated Loss Percentages by Category:** - Not yet due: 2% - Up to 120 days past due: 15% - More than 120 days past due: 36% **Current Financial Considerations:** - At the end of the current year, the Allowance for Doubtful Accounts balance is $900 (credit) before adjusting entries. **Required Calculation:** - Determine the amount to be recorded as Bad Debt Expense for the year. **Explanation of the Table:** A table is used to calculate the estimated uncollectible amount for each category of aged accounts receivable: | Aged Accounts Receivable | Estimated Percentage Uncollectible | Estimated Amount Uncollectible | |--------------------------|--------------------------------------|-------------------------------| | Not yet due | 2% | | | Up to 120 days past due | 15% | | | Over 120 days past due | 36% | | **Note:** Enter percentages as whole numbers (e.g., enter 12% as 12). This table helps in calculating the total potential bad debt, taking into account the different risks associated with each category based on how overdue the receivables are.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%
### Computing Bad Debt Expense Using Aging Analysis

**Scenario: Lin’s Dairy**

Lin’s Dairy uses the aging approach to estimate bad debt expense. The aging approach categorizes account receivables based on their age and applies different estimated loss percentages to these categories to determine potential uncollectible amounts.

**Account Aging Categories:**
1. **Not yet due:** $16,800
2. **Up to 120 days past due:** $6,700
3. **More than 120 days past due:** $4,200

**Estimated Loss Percentages by Category:**
- Not yet due: 2%
- Up to 120 days past due: 15%
- More than 120 days past due: 36%

**Current Financial Considerations:**
- At the end of the current year, the Allowance for Doubtful Accounts balance is $900 (credit) before adjusting entries.

**Required Calculation:**
- Determine the amount to be recorded as Bad Debt Expense for the year.

**Explanation of the Table:**

A table is used to calculate the estimated uncollectible amount for each category of aged accounts receivable:

| Aged Accounts Receivable | Estimated Percentage Uncollectible | Estimated Amount Uncollectible |
|--------------------------|--------------------------------------|-------------------------------|
| Not yet due              | 2%                                  |                               |
| Up to 120 days past due  | 15%                                 |                               |
| Over 120 days past due   | 36%                                 |                               |

**Note:** Enter percentages as whole numbers (e.g., enter 12% as 12).

This table helps in calculating the total potential bad debt, taking into account the different risks associated with each category based on how overdue the receivables are.
Transcribed Image Text:### Computing Bad Debt Expense Using Aging Analysis **Scenario: Lin’s Dairy** Lin’s Dairy uses the aging approach to estimate bad debt expense. The aging approach categorizes account receivables based on their age and applies different estimated loss percentages to these categories to determine potential uncollectible amounts. **Account Aging Categories:** 1. **Not yet due:** $16,800 2. **Up to 120 days past due:** $6,700 3. **More than 120 days past due:** $4,200 **Estimated Loss Percentages by Category:** - Not yet due: 2% - Up to 120 days past due: 15% - More than 120 days past due: 36% **Current Financial Considerations:** - At the end of the current year, the Allowance for Doubtful Accounts balance is $900 (credit) before adjusting entries. **Required Calculation:** - Determine the amount to be recorded as Bad Debt Expense for the year. **Explanation of the Table:** A table is used to calculate the estimated uncollectible amount for each category of aged accounts receivable: | Aged Accounts Receivable | Estimated Percentage Uncollectible | Estimated Amount Uncollectible | |--------------------------|--------------------------------------|-------------------------------| | Not yet due | 2% | | | Up to 120 days past due | 15% | | | Over 120 days past due | 36% | | **Note:** Enter percentages as whole numbers (e.g., enter 12% as 12). This table helps in calculating the total potential bad debt, taking into account the different risks associated with each category based on how overdue the receivables are.
Expert Solution
Step 1 Introduction

Bad debts: It is a receivable that is now irrecoverable from that person who was supposed to pay the same. The reason for nonpayment by the debtors is that either they go bankrupt, have financial problems, or collection by the creditors due to various reasons is not possible.

Step 2 Computation of bad debt expenses for the year

Aged account receivable

Working note

Amount  ($)

Estimated percentage uncollectable

Estimated amount

Uncollectible

Amount  ($)

Not yet due

1

16,800

2%

336

Up to 120 days past due

2

6,700

15%

1,005

Over 120 days past due

3

4,200

36%

1,512

Estimated balance in the allowance for doubtful accounts

2,853

Less: Current balance in the allowance for doubtful accounts

(900)

Bad debt expenses for the current year

1,953

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
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