Question

In: Accounting

Sheffield Corp. had record sales in 2020. It began 2020 with an Accounts Receivable balance of...

Sheffield Corp. had record sales in 2020. It began 2020 with an Accounts Receivable balance of $500,000 and an Allowance for Doubtful Accounts of $35,000. Sheffield recognized credit sales during the year of $6,705,000 and made monthly adjusting entries equal to 0.5% of each month’s credit sales to recognize bad debt expense. Also during the year, the company wrote off $35,300 of accounts that were deemed to be uncollectible, although one customer whose $4,700 account had been written off surprised management by paying the amount in full in late September. Including this surprise receipt, $6,538,000 cash was collected on account in 2020.

To assess the reasonableness of the allowance for doubtful accounts, the controller prepared the following aged listing of the receivables at December 31, 2020:
Days Account Outstanding Amount Probability of Collection
Less than 16 days $353,200 97%
Between 16 and 30 days 124,000 91%
Between 31 and 45 days 76,000 80%
Between 46 and 60 days 38,800 71%
Between 61 and 75 days 19,800 51%
Over 75 days 24,600 0%
$636,400
Your answer is correct.
Reconcile the 2020 opening balance in Accounts Receivable to the $636,400 ending balance on the controller’s aged listing.
Accounts Receivable Reconciliation

Cash collected on accountCredit sales in yearEnding balanceOpening balanceAccounts written offReinstatement of account collected

$

Cash collected on accountEnding balanceOpening balanceReinstatement of account collectedCredit sales in yearAccounts written off

Reinstatement of account collectedCash collected on accountOpening balanceAccounts written offEnding balanceCredit sales in year

Reinstatement of account collectedOpening balanceAccounts written offCash collected on accountEnding balanceCredit sales in year

Cash collected on accountCredit sales in yearEnding balanceAccounts written offOpening balanceReinstatement of account collected

Credit sales in yearOpening balanceCash collected on accountReinstatement of account collectedEnding balanceAccounts written off

$

SHOW LIST OF ACCOUNTS

LINK TO TEXT

Your answer is partially correct. Try again.
Prepare the adjusting entry to bring the Allowance for Doubtful Accounts to its proper balance at year end. (Credit account titles are automatically indented when 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.)

Date

Account Titles and Explanation

Debit

Credit

Dec. 31

SHOW LIST OF ACCOUNTS

LINK TO TEXT

Your answer is incorrect. Try again.
Show how accounts receivable would be presented on the December 31, 2020 statement of financial position.
Sheffield Corp.
Statement of financial position (Partial)
$

AddLess

:
(net) $

SHOW LIST OF ACCOUNTS

LINK TO TEXT

Your answer is incorrect. Try again.
What is the dollar effect of the year-end bad debt adjustment on the before-tax income?
The year-end bad debt adjustment would

increasedecrease

before-tax income $ .

Solutions

Expert Solution

Accounts Receivable Reconciliation
Opening balance 500000
Credit sales in year 6705000
Accounts written off -35300
Reinstatement of account collected 4700
Cash collected on account -6538000
Ending balance 636400

Working:

Days Account Outstanding Amount Probability of Uncollectibility Uncollectible Amount
Less than 16 days 353200 3% 10596
Between 16 and 30 days 124000 9% 11160
Between 31 and 45 days 76000 20% 15200
Between 46 and 60 days 38800 29% 11252
Between 61 and 75 days 19800 49% 9702
Over 75 days 24600 100% 24600
Total 636400 82510
Allowance for Doubtful Accounts
Beginning balance 1/1/2020 35000
Write-off    35300 Monthly adj. (0.5% x $6705000) 33525
Re-instatement 4700
Bad debts expense (adj.) 44585
Ending balance 12/31/2020 82510

Adjusting entry:

Date Account Titles and Explanation Debit Credit
Dec. 31 Bad debts expense 44585
Allowance for doubtful accounts 44585
(To record the adjusting entry)
Sheffield Corporation
Statement of Financial Position (Partial)
Accounts receivable 636400
Less: Allowance for doubtful accounts 82510
Accounts receivable (net) 553890

The year-end bad debt adjustment would decrease before-tax income $44585.


Related Solutions

On January 1, 2020, Novak Corp. had Accounts Receivable $140,800, Notes Receivable $24,000, and Allowance for...
On January 1, 2020, Novak Corp. had Accounts Receivable $140,800, Notes Receivable $24,000, and Allowance for Doubtful Accounts $12,300. The note receivable is from Willingham Company. It is a 4-month, 9% note dated December 31, 2019. Novak Corp. prepares financial statements annually at December 31. During the year, the following selected transactions occurred. Jan. 5 Sold $18,200 of merchandise to Sheldon Company, terms n/15. 20 Accepted Sheldon Company’s $18,200, 3-month, 8% note for balance due. Feb. 18 Sold $6,400 of...
4. Vitron Corp. has a current accounts receivable balance of $483,810. Credit sales for the year...
4. Vitron Corp. has a current accounts receivable balance of $483,810. Credit sales for the year ended were $5,700,000. What is the receivables turnover? The days’ sales in receivables? (10 Points) (Use Excel and Excel Formulas)
On 1 July 2020 Tran’s Hardware Pty Ltd had an accounts receivable ledger balance of $75,000...
On 1 July 2020 Tran’s Hardware Pty Ltd had an accounts receivable ledger balance of $75,000 debit and a credit balance in the allowance for doubtful debts ledger account of $15,000. On 3 July Tran’s was contacted by Nails and Hammers Pty Ltd to notify that the business had been declared bankrupt and that they would not be able to pay the $5,500 owing to Tran’s Hardware from a previous credit sale made to them in June 2020. The business...
Granger Corporation had $184,000 in sales on account last year. The beginning accounts receivable balance was...
Granger Corporation had $184,000 in sales on account last year. The beginning accounts receivable balance was $14,000 and the ending accounts receivable balance was $23,000. The corporation's average collection period was closest to: (Round your intermediate calculations to 2 decimal places.) Garrison 16e Rechecks 2017-10-04 Multiple Choice 27.8 days 45.6 days 9.9 days 36.7 days 2. Data from Fontecchio Corporation's most recent balance sheet appear below: Cash $ 40,000 Marketable securities $ 42,000 Accounts receivable $ 113,840 Short-term notes receivable...
Garham Company had $360,000 in sales on account last year. The beginning accounts receivable balance was...
Garham Company had $360,000 in sales on account last year. The beginning accounts receivable balance was $20,000 and the ending accounts receivable balance was $36,000. The company's average collection period (age of receivables) was closest to: 20.28 days. 28.39 days. 36.50 days. 56.78 days.
Donovan Carrier Corp has an Accounts Receivable Balance of $1,065,000 and an Allowance for Doubtful Accounts...
Donovan Carrier Corp has an Accounts Receivable Balance of $1,065,000 and an Allowance for Doubtful Accounts of $99,500 as of 12/31/18. In 2019, Donovan has credit sales of $2,900,000 and collections on account of $3,020,000. They write-off $103,000 in uncollectible accounts in 2019. Their financial manager estimates 14% of their accounts receivable will be uncollectible as of 12/31/19. REQUIRED : Provide the journal entry for Donovan for the account write-offs for 2019. REQUIRED : Provide the adjusting journal entry for...
Donovan Carrier Corp has an Accounts Receivable Balance of $1,065,000 and an Allowance for Doubtful Accounts...
Donovan Carrier Corp has an Accounts Receivable Balance of $1,065,000 and an Allowance for Doubtful Accounts of $99,500 as of 12/31/18. In 2019, Donovan has credit sales of $2,900,000 and collections on account of $3,020,000. They write-off $103,000 in uncollectible accounts in 2019. Their financial manager estimates 14% of their accounts receivable will be uncollectible as of 12/31/19. REQUIRED : Provide the journal entry for Donovan for the account write-offs for 2019. REQUIRED : Provide the adjusting journal entry for...
Sheffield Corp.’s balance sheet at December 31, 2021, is presented below. SHEFFIELD CORP. Balance Sheet December...
Sheffield Corp.’s balance sheet at December 31, 2021, is presented below. SHEFFIELD CORP. Balance Sheet December 31, 2021 Cash $51,660 Accounts payable $53,760 Accounts receivable 95,550 Common stock ($10 par) 168,000 Allowance for doubtful accounts (3,150 ) Retained earnings 267,540 Supplies 9,240 Land 84,000 Buildings 298,200 Accumulated depreciation—buildings (46,200 ) $489,300 $489,300 During 2022, the following transactions occurred. 1. On January 1, Sheffield issued 2,520 shares of $40 par, 7% preferred stock for $103,320. 2. On January 1, Sheffield also...
Sheffield Corp.’s balance sheet at December 31, 2021, is presented below. SHEFFIELD CORP. Balance Sheet December...
Sheffield Corp.’s balance sheet at December 31, 2021, is presented below. SHEFFIELD CORP. Balance Sheet December 31, 2021 Cash $51,660 Accounts payable $53,760 Accounts receivable 95,550 Common stock ($10 par) 168,000 Allowance for doubtful accounts (3,150 ) Retained earnings 267,540 Supplies 9,240 Land 84,000 Buildings 298,200 Accumulated depreciation—buildings (46,200 ) $489,300 $489,300 During 2022, the following transactions occurred. 1. On January 1, Sheffield issued 2,520 shares of $40 par, 7% preferred stock for $103,320. 2. On January 1, Sheffield also...
A company’s year-end balance in accounts receivable is $2,000,000. The allowance for uncollectible accounts had a...
A company’s year-end balance in accounts receivable is $2,000,000. The allowance for uncollectible accounts had a beginning-of-year credit balance of $30,000. An aging of accounts receivable at the end of the year indicates a required allowance of $38,000. If bad debt expense for the year was $40,000 and if credit sales for the year were $8,200,000 and $7,950,000 was collected from credit customers, what was the beginning-of-year balance in accounts receivable?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT