2. Estimating Uncollectible Accounts and Reporting Accounts Receivable: Collins Company analyzes its accounts receivable at December 31 and arrives at the age categories below along with the percentages that are estimated as uncollectible. The balance of the allowance for uncollectible accounts is $1,100 on December 31, before any adjustments. Age Group Accounts Receivable 0-30 Days Past Due 31-60 Days Past Due 61-120 Days Past Due 121-180 Days Past Due Over 180 Days Past Due Total A/R $110,000 $40,000 $27,000 $14,000 $9,000 $200,000 Estimated Loss % 1% 2% 5% 10% 25% a. What amount of bad debt expense will Collins reports in its income statement for the year? Estimated bad debets = accoutns receivable Estimated loss under each group (110,000 1 %) + ($40,000 2 %) + ($27,000 5% ) + ($14,000 10 %) + ($9,000 25%) = $6,900 . . b. Use the financial statement effects template to record Collins' bad debt expense for the year. Bad debets expense = Estimated bad debets - balance in allowance account $6,900 $1,100 = $5,800 c. What is the balance of accounts receivable on its December 31 balance sheet? d. What is the amount (as a %) of estimated uncollectible receivables?

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 68E: Bad Debt Expense: Aging Method Glencoe Supply had the following accounts receivable aging schedule...
icon
Related questions
icon
Concept explainers
Question

am. 124..

2. Estimating Uncollectible Accounts and Reporting Accounts Receivable: Collins Company
analyzes its accounts receivable at December 31 and arrives at the age categories below along
with the percentages that are estimated as uncollectible. The balance of the allowance for
uncollectible accounts is $1,100 on December 31, before any adjustments.
Age Group
0-30 Days Past Due
Accounts Receivable
Estimated Loss %
1%
2%
5%
10%
25%
31-60 Days Past Due
61-120 Days Past Due
121-180 Days Past Due
Over 180 Days Past Due
Total A/R
=
$110,000
$40,000
$27,000
$14,000
$9,000
$200,000
a. What amount of bad debt expense will Collins reports in its income statement for the
year?
Estimated bad debets = accoutns receivable Estimated loss under each group
(110,000 1%) + ($40,000+2%) + ($27,000 + 5%) + ($14,000 10 %) + ($9,000 25%)
= $6,900
b. Use the financial statement effects template to record Collins' bad debt expense for the
year.
Bad debets expense = Estimated bad debets - balance in allowance account
C.
$6,900 $1,100
= $5,800
What is the balance of accounts receivable on its December 31 balance sheet?
d. What is the amount (as a %) of estimated uncollectible receivables?
Transcribed Image Text:2. Estimating Uncollectible Accounts and Reporting Accounts Receivable: Collins Company analyzes its accounts receivable at December 31 and arrives at the age categories below along with the percentages that are estimated as uncollectible. The balance of the allowance for uncollectible accounts is $1,100 on December 31, before any adjustments. Age Group 0-30 Days Past Due Accounts Receivable Estimated Loss % 1% 2% 5% 10% 25% 31-60 Days Past Due 61-120 Days Past Due 121-180 Days Past Due Over 180 Days Past Due Total A/R = $110,000 $40,000 $27,000 $14,000 $9,000 $200,000 a. What amount of bad debt expense will Collins reports in its income statement for the year? Estimated bad debets = accoutns receivable Estimated loss under each group (110,000 1%) + ($40,000+2%) + ($27,000 + 5%) + ($14,000 10 %) + ($9,000 25%) = $6,900 b. Use the financial statement effects template to record Collins' bad debt expense for the year. Bad debets expense = Estimated bad debets - balance in allowance account C. $6,900 $1,100 = $5,800 What is the balance of accounts receivable on its December 31 balance sheet? d. What is the amount (as a %) of estimated uncollectible receivables?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 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
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT