Question

In: Accounting

Estimating Uncollectible Accounts and Reporting Accounts Receivable Collins Company analyzes its accounts receivable at December 31,...

Estimating Uncollectible Accounts and Reporting Accounts Receivable
Collins Company analyzes its accounts receivable at December 31, and arrives at the aged categories below along with the percentages that are estimated as uncollectible.

Age Group

Accounts

Receivable

Estimated

Loss %
0-30 days past due $110,000 1%
31-60 days past due 40,000 2
61-120 days past due 27,000 5
121-180 days past due 14,000 10
Over 180 days past due 9,000 25
Total accounts receivable $200,000

The balance of the allowance for uncollectible accounts is $1,100 on December 31, before any adjustments.

(a) What amount of bad debts expense will Collins report in its income statement for the year?

(b) Use the financial statement effects template to record Collin's bad debts expense for the year.

Use negative signs with your answers, when appropriate.

(c) What is the balance of accounts receivable on it December 31 balance sheet?

Solutions

Expert Solution

(a) What amount of bad debts expense will Collins report in its income statement for the year?    [Refer working note 1]
$5,800

.

.

(b) Use the financial statement effects template to record Collin's bad debts expense for the year.
Balance Sheet
Transaction Cash Asset + Non-cash assets = Liabilities + Contributed Capital + Earned Capital
Record bad debts expense $0

($5,800)

(Allowance for Uncollectible Accounts))

 $0 $0

($5,800)

(Retained earnings decrease)

.

Income Statement
Revenue - Expenses = Net Income

$5,800

(Bad debt expense)

 ($5,800)

.

.

(c) What is the balance of accounts receivable on it December 31 balance sheet?    [Refer working note 3]
$193,100

.

.

Working note 1 - Calculation of bad debt expense
Adjusted balance of Allowance for Uncollectible Accounts        [Refer working note 2] $6,900
Less: Credit balance of Allowance for Uncollectible Accounts $1,100
Bad Debt Expense for the year $5,800
Working note 2 - Computation of adjusted balance of allowance for Uncollectible accounts
Accounts Age Balance

(a)		 Estimated Percent Uncollectible

(b)		 (a x b)
0-30 days past due $110,000 1% $1,100
31–60 days past due $40,000 2% $800
61-120 days past due $27,000 5% $1,350
121 - 180 days past due $14,000 10% $1,400
Over 180 days past due $9,000 25% $2,250
Adjusted balance $6,900
Working note 3 - Balance of accounts receivable on it December 31 balance sheet
Account receivables (Gross) $200,000
Less: Balance of Allowance for uncollectible Account at December 31   [Refer working note 2] $6,900
Account receivables (Net) $193,100

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

LaFond Company analyzes its accounts receivable at December 31, 2016, and arrives at the aged categories...
LaFond Company analyzes its accounts receivable at December 31, 2016, and arrives at the aged categories below along with the percentages that are estimated as uncollectible. Age Group Accounts Receivable Estimated Loss % Current (not past due) $250,000 0.20% 1-30 days past due 90,000 1.0 31-60 days past due 20,000 2.0 61-120 days past due 11,000 5.0 121-180 days past due 6,000 10.0 Over 180 days past due 4,000 25.0 Total accounts receivable $381,000 At the beginning of the fourth...
Estimating and Recording Bad Debt Estimates and Write-offs; Reporting of Accounts Receivable At December 31, 2020,...
Estimating and Recording Bad Debt Estimates and Write-offs; Reporting of Accounts Receivable At December 31, 2020, its annual year-end, the accounts of Sun Systems Inc. show the following. 1. Sales revenue for 2020, $468,000, of which one-sixth was on account. 2. Allowance for doubtful accounts, balance December 31, 2019, $2,340 credit. 3. Accounts receivable, balance December 31, 2020 (prior to any write-offs of uncollectible accounts during 2020), $46,930. 4. Uncollectible accounts to be written off, December 31, 2020, $2,730. 5....
Estimating and Recording Bad Debt Estimates and Write-offs; Reporting of Accounts Receivable At December 31, 2020,...
Estimating and Recording Bad Debt Estimates and Write-offs; Reporting of Accounts Receivable At December 31, 2020, its annual year-end, the accounts of Sun Systems Inc. show the following. 1. Sales revenue for 2020, $900,000, of which one-sixth was on account. 2. Allowance for doubtful accounts, balance December 31, 2019, $4,500 credit. 3. Accounts receivable, balance December 31, 2020 (prior to any write-offs of uncollectible accounts during 2020), $90,250. 4. Uncollectible accounts to be written off, December 31, 2020, $5,250. 5....
(Accounts receivable and uncollectible accounts—aging of receivables method) On December 31, 2019, Ajacks Company reported the...
(Accounts receivable and uncollectible accounts—aging of receivables method) On December 31, 2019, Ajacks Company reported the following information in its financial statements: Accounts receivable $1,193,400 Allowance for doubtful accounts 81,648 Bad debts expense 80,448 During 2020, the company had the following transactions related to receivables: a. Sales were $10,560,000, of which $8,448,000 were on account. b. Collections of accounts receivable were $7,284,000. c. Writeoffs of accounts receivable were $78,000. d. Recoveries of accounts previously written off as uncollectible were $8,100....
At December 31, Gill Co. reported accounts receivable of $274,000 and an allowance for uncollectible accounts...
At December 31, Gill Co. reported accounts receivable of $274,000 and an allowance for uncollectible accounts of $1,500 (credit) before any adjustments. An analysis of accounts receivable suggests that the allowance for uncollectible accounts should be 1% of accounts receivable. The amount of the adjustment for uncollectible accounts would be: $1,500. $1,240. $2,740. $950.
Dhaliwal Digital categorizes its accounts receivable into three age groups for purposes of estimating its allowance for uncollectible accounts
Dhaliwal Digital categorizes its accounts receivable into three age groups for purposes of estimating its allowance for uncollectible accounts. 1. Accounts not yet due = $180,000, estimated uncollectible = 15%. 2. Accounts 1-45 days past due $25,000, estimated uncollectible = 20%. 3. Accounts more than 45 days past due $10,000, estimated uncollectible = 25%. Before recording any adjustments, Dhaliwal has a debit balance of $45,100 in its allowance for uncollectible accounts Required: 1. Estimate the appropriate 12/31/2021 balance for Dhaliwal's allowance for uncollectible accounts 2. What journal...
Dhaliwal Digital categorizes its accounts receivable into three age groups for purposes of estimating its allowance for uncollectible accounts.
Exercise 7-13 (Algo) Calculate uncollectible accounts using the aging method; record adjustment (L07-5, 7-6) Dhaliwal Digital categorizes its accounts receivable into three age groups for purposes of estimating its allowance for uncollectible accounts. 1. Accounts not yet du 106,000; estimated uncollectible = 10% 2. Accounts 1-45 days due - $14,700; estimated uncollectible = 15% 3. Accounts more than 45 days past due $5,900; estimated uncollectible = 20%.Before recording any adjustments, Dhaliwal has a debit balance of $26,700 in its allowance for uncollectible accounts. Required: 1. Estimate...
Artis, Inc. uses the aging of accounts receivable method for estimating uncollectible accounts. As of October...
Artis, Inc. uses the aging of accounts receivable method for estimating uncollectible accounts. As of October 31, total Accounts Receivable was $17,800 of which $8,400 was 0 - 30 days old; $5,900 was 31 - 60 days old; and the remainder was over 60 days old. Artis estimates 1% of accounts 0 - 30 days old will be uncollectible; 5% of accounts 31 - 60 days old will be uncollectible; and 15% of accounts over 60 days old will be...
Mosaic’s Company balance sheet at December 31, 2018, reported the following: Accounts receivable...........................................$2,500,000 Allowance for uncollectible...
Mosaic’s Company balance sheet at December 31, 2018, reported the following: Accounts receivable...........................................$2,500,000 Allowance for uncollectible accounts...................$66,600 The following are the transactions to be taken into consideration for 2019: a. Total credit sales for 2019 were $3,600,000. b. 2% of sales were estimated to be uncollectible. c. The company received cash payments on account during 2019 for $1,000,000 d. Accounts receivable identified to be uncollectible totaled $94,000. e. December 31, 2019, aging of receivables indicates that $75,000 of the receivables...
Mosaic’s Company balance sheet at December 31, 2018, reported the following: Accounts receivable...........................................$2,500,000 Allowance for uncollectible...
Mosaic’s Company balance sheet at December 31, 2018, reported the following: Accounts receivable...........................................$2,500,000 Allowance for uncollectible accounts...................$66,600 The following are the transactions to be taken into consideration for 2019: a. Total credit sales for 2019 were $3,600,000. b. 2% of sales were estimated to be uncollectible. c. The company received cash payments on account during 2019 for $1,000,000 d. Accounts receivable identified to be uncollectible totaled $94,000. e. December 31, 2019, aging of receivables indicates that $75,000 of the receivables...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT