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?

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

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.
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