Question

In: Accounting

resented below is an aging schedule for Wildhorse Company on December 31, 2021. Wildhorse sells all...

resented below is an aging schedule for Wildhorse Company on December 31, 2021. Wildhorse sells all of its goods on account with terms n/30.

Number of Days Past Due
Customer Total Not yet Due 1–30 31–60 61–90 Over 90
Akers $18,800 $8,500 $10,300
Barrett 28,200 $28,200
Corner 47,000 14,100 4,700 $28,200
DeJong 35,700 $35,700
Other 118,400 86,500 14,100 12,200 5,600
$248,100 $128,800 $27,300 $22,500 $28,200 $41,300
Estimated percentage uncollectible 2% 5% 8% 27% 54%


At December 31, 2021, the unadjusted balance in Allowance for Doubtful Accounts is a credit of $9,400.

Using the above aging schedule, determine the total estimated uncollectible accounts at December 31, 2021.

Total estimated uncollectible accounts $

Prepare the adjusting journal entry to record bad debt expense. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

Account Titles and Explanation

Debit

Credit

(To record estimate of uncollectible accounts.)

Solutions

Expert Solution

Adjusting journal entry to record bad debt expense:

Date

General Ledger

Debit

Credit

31-Dec-21

Bad Debt

$      26,257

Allowance for Doubtful Accounts

$      26,257

Workings:

Bad debt calculation:

Customer Total Not yet due Due 1-30 days Due 31-60 days Due 61-90 days 90 Over
Akers $    18,800 $            8,500
Barrett $    28,200 $      28,200 $             10,300
Corner $    47,000 $      14,100 $            4,700 $             28,200
DeJong $    35,700 $ 35,700
Other $ 118,400 $      86,500 $          14,100 $             12,200 $    5,600
$ 248,100 $   128,800 $          27,300 $            22,500 $            28,200 $ 41,300
Estimated percentage uncollectible 2% 5% 8% 27% 54%
Bad debt $   35,657 $        2,576 $            1,365 $               1,800 $               7,614 $ 22,302
Calculation of adjusted Bad debt:
Bad debt $       35,657
Less: Beginning credit balance in Allowance for Doubtful Accounts $         9,400
Adjusted bad debt to be recorded $       26,257

Related Solutions

Presented below is an aging schedule for Pearl Industries at December 31, 2021. Customer Total Not...
Presented below is an aging schedule for Pearl Industries at December 31, 2021. Customer Total Not Yet Due Number of Days Past Due 1–30 31–60 61–90 Over 90 Aneesh $ 22,000 $ 8,200 $13,800 Bird 30,500 $ 30,500 Cope 46,000 5,300 4,500 $36,200 DeSpears 36,200 $36,200 Others 126,000 78,500 34,400 13,100    $260,700 $114,300 $47,100 $26,900 $36,200 $36,200 Estimated percentage uncollectible 3% 7% 13% 26% 62% Total estimated bad debts $ 42,079 $ 3,429 $3,297 $3,497 $ 9,412 $22,444 At...
A summary of Klugman Company's December 31, 2021, accounts receivable aging schedule is presented below along...
A summary of Klugman Company's December 31, 2021, accounts receivable aging schedule is presented below along with the estimated percent uncollectible for each age group: Age Group Amount % 0–60 days $ 68,000 0.5 61–90 days 26,000 1.0 91–120 days 3,800 10.0 Over 120 days 1,200 50.0 The allowance for uncollectible accounts had a balance of $1,480 on January 1, 2021. During the year, bad debts of $830 were written off. Required: Prepare all journal entries for 2021 with respect...
A summary of Klugman Company's December 31, 2021, accounts receivable aging schedule is presented below along...
A summary of Klugman Company's December 31, 2021, accounts receivable aging schedule is presented below along with the estimated percent uncollectible for each age group: Age Group Amount % 0–60 days $ 59,000 0.5 61–90 days 21,500 1.0 91–120 days 2,900 10.0 Over 120 days 1,200 50.0 The allowance for uncollectible accounts had a balance of $1,390 on January 1, 2021. During the year, bad debts of $740 were written off. Required: Prepare all journal entries for 2021 with respect...
A summary of Klugman Company's December 31, 2021, accounts receivable aging schedule is presented below along wit...
A summary of Klugman Company's December 31, 2021, accounts receivable aging schedule is presented below along with the estimated percent uncollectible for each age group:Age GroupAmount%0-60 days$58,0000.561-90 days21,0001.091-120 days2,88010.0Over 12 theta days1,00050.0The allowance for uncollectible accounts had a balance of $1,380 on January 1, 2021. During the year, bad debts of $730 were written off. Required: Prepare all journal entries for 2021 with respect to bad debts and the allowance for uncollectible accounts. (If no entry is required for a transaction/event, select...
Presented below is an aging schedule for the Ivan Company at December 31, 2020: Customer Balance...
Presented below is an aging schedule for the Ivan Company at December 31, 2020: Customer Balance Not Yet Due 1-30 past due 31-60 past due 61-90 past due Over 90 Culberson $24,000 $ 9,000 $15,000 Samsa 30,000 $30,000 Burks 50,000 5,000 5,000 $40,000 Greuel 38,000 $38,000 Others 120,000 72,000 35,000 13,000 $262,000 $107,000 $49,000 $28,000 $40,000 $38.000 % estimated uncollectible 3% 7% 12% 24% 60% Total estimated uncollectible $42,400 $3,210 $3,430 $3,360 $9,600 $22,800 At December 31 2020, the unadjusted...
3 (a). Following is the aging schedule of Zahir Company as of December 31, 2019.    (Marks...
3 (a). Following is the aging schedule of Zahir Company as of December 31, 2019.    (Marks 6)                                                                   Not Yet Due Days Past Due Name of Customers Total Balance 1-30 31-60 61-90 Over 90 Umer Sons 17,100 9,000 5,400 - 2,700 - Ishaq Brothers 25,200 14,400 - 7,200 - 3,600 YMC Company 3,600 - 3,600 - - - Muna Services 14,400 7,200 - 2,700 4,500 - Ali Company 23,400 18,000 - - - 5,400 The company has estimated 2%, 4%, 20%,...
The comparative balance sheets for Wildhorse Co. as of December 31 are presented below. Wildhorse Co....
The comparative balance sheets for Wildhorse Co. as of December 31 are presented below. Wildhorse Co. Comparative Balance Sheets December 31 Assets 2017 2016 Cash $ 93,364 $ 61,785 Accounts receivable 68,650 79,634 Inventory 207,941 194,966 Prepaid expenses 20,979 28,833 Land 199,085 178,490 Buildings 274,600 274,600 Accumulated depreciation—buildings (82,380 ) (54,920 ) Equipment 308,925 212,815 Accumulated depreciation—equipment (61,785 ) (48,055 ) Total $1,029,379 $928,148 Liabilities and Stockholders’ Equity Accounts payable $ 61,414 $ 49,428 Bonds payable 411,900 411,900 Common stock,...
Presented below is information related to equipment owned by Wildhorse Company at December 31, 2020. Cost...
Presented below is information related to equipment owned by Wildhorse Company at December 31, 2020. Cost $10,620,000 Accumulated depreciation to date 1,180,000 Expected future net cash flows 8,260,000 Fair value 5,664,000 Wildhorse intends to dispose of the equipment in the coming year. It is expected that the cost of disposal will be $23,600. As of December 31, 2020, the equipment has a remaining useful life of 5 years. Prepare the journal entry (if any) to record the impairment of the...
The following financial information is for Wildhorse Company. WILDHORSE COMPANY Balance Sheets December 31 Assets 2017...
The following financial information is for Wildhorse Company. WILDHORSE COMPANY Balance Sheets December 31 Assets 2017 2016 Cash $  70,000 $  68,000 Debt investments (short-term) 51,000 40,000 Accounts receivable 109,000 91,000 Inventory 231,000 167,000 Prepaid expenses 27,000 26,000 Land 134,000 134,000 Building and equipment (net) 264,000 186,000 Total assets $ 886,000 $ 712,000 Liabilities and Stockholders’ Equity Notes payable $ 171,000 $ 109,000 Accounts payable 67,000 53,000 Accrued liabilities 41,000 41,000 Bonds payable, due 2017 250,000 170,000 Common stock, $10 par 206,000...
The following financial information is for Wildhorse Company. WILDHORSE COMPANY Balance Sheets December 31 Assets 2017...
The following financial information is for Wildhorse Company. WILDHORSE COMPANY Balance Sheets December 31 Assets 2017 2016 Cash $ 70,000 $ 68,000 Debt investments (short-term) 51,000 40,000 Accounts receivable 109,000 91,000 Inventory 231,000 167,000 Prepaid expenses 27,000 26,000 Land 134,000 134,000 Building and equipment (net) 264,000 186,000 Total assets $886,000 $712,000 Liabilities and Stockholders’ Equity Notes payable $171,000 $109,000 Accounts payable 67,000 53,000 Accrued liabilities 41,000 41,000 Bonds payable, due 2017 250,000 170,000 Common stock, $10 par 206,000 206,000 Retained...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT