Question

Pattersons Commercial Metals, Inc Financial Data for 2019 Beginning Accounts Receivable Ending Accounts Receivable Sales (as

please help me out, thank you

0 0
Add a comment Improve this question Transcribed image text
Answer #1

A. Percentage of sales method

1. Bad Debt expense = $195000 x .5% = $975

Account Titles Debit Credit
Bad Debt Expense $              975
     Allowance for Uncollectible accounts $               975

2. Ending Balance of Allowance for uncollectible accounts = $223 + $975 = $1198

3. Net Realizable Value of accounts receivable = $68000- $1198 = $66802

4. Receivable turnover ratio = Net Sales / Average Accounts Receivable
= $195000 / $61289.50 = 3.18
Average Accounts Receivable = ($56000-223+68000-1198)/2 = $61289.50

Days sales to collect = Ending Account Receivables / Sales x 365
= $66802 / $195000 x 365 = 125.04 days

B. Aging of Receivables approach

2. Ending Balance of Allowance for Uncollectible accounts = $3508.50

1-30 days $         36,000 1.75% $      630.00
31-60 days $         22,000 4.80% $ 1,056.00
61-90 days $           7,500 11.30% $      847.50
91+ days $           2,500 39% $      975.00
$ 3,508.50

1. Bad Debt expense = $3508.50 - $223 = $3285.50

Account Titles Debit Credit
Bad Debt Expense $     3,285.50
     Allownace for Uncollectible accounts $      3,285.50

3. Net Realizable Value of accounts receivable = $68000- $3508.50 = $64491.50

4. Receivable turnover ratio = Net Sales / Average Accounts Receivable
= $195000 / $60134.25 = 3.24
Average Accounts Receivable = ($56000-223+68000-3508.50)/2 = $60134.25

Days sales to collect = Ending Account Receivables / Sales x 365
= $64491.50 / $195000 x 365 = 120.71 days

Add a comment
Know the answer?
Add Answer to:
please help me out, thank you Patterson's Commercial Metals, Inc Financial Data for 2019 Beginning Accounts...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • please help me solve requirements for this problem The September 30, 2019, records of First Data...

    please help me solve requirements for this problem The September 30, 2019, records of First Data Communications include these accounts: (Click the icon to view the September 30, 2019 account balances.) During the year. First Data Communications estimates Uncollectible-account expense at 1% of credit sales. At year-end (December 31), the company ages its receivables and adjusts the balance in the Allowance for Uncollectible Accounts to correspond to the following aging schedule. (Click the icon to view the Accounts Receivable balance...

  • Accounts Receivable and aging schedule to be used at December 31, 2019 Age of Accounts Accounts...

    Accounts Receivable and aging schedule to be used at December 31, 2019 Age of Accounts Accounts Receivable 1-30 Days 31-60 Days 61-90 Days Over 90 Days $ 233,000 $ 139,000 $ 53,000 $ 11,000 $ 30,000 Estimated percent uncollectible 0.2% 2% 15% 35% Print Done The September 30, 2019, records of Perfecto Communications include these accounts: (Click the icon to view the September 30, 2019 account balances.) During the last quarter of 2019, the company completed the following selected transactions:...

  • Please show your work, and thank you for your help. O'Tole Co. reports assigned accounts receivable...

    Please show your work, and thank you for your help. O'Tole Co. reports assigned accounts receivable of $190,000 that relate to an unpaid note payable of $75,000. Correct balance sheet disclosure is Current assets: Accounts receivable assigned $190,000 Less: Note payable (75,000). Net realizable receivable assigned $115,000 Current assets: Net realizable receivable assigned $115,000 Current liabilities: Note payable $75,000 Less: Accounts receivable assigned (75,000). $-0- Current assets: Equity in accounts receivable $115,000 assigned Current assets: Accounts receivable assigned $190,000 Current...

  • 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: Total credit sales for 2019 were $3,600,000. 2% of sales were estimated to be uncollectible. The company received cash payments on account during 2019 for $1,000,000 Accounts receivable identified to be uncollectible totaled $94,000. December 31, 2019, aging of receivables indicates that $75,000 of the receivables is uncollectible. Requirements: What was...

  • Beginning accounts receivable 164,000 Beginning allowance for doubtful accounts 5,400 Sales 2,000,000 Collections on account 1,720,000...

    Beginning accounts receivable 164,000 Beginning allowance for doubtful accounts 5,400 Sales 2,000,000 Collections on account 1,720,000 Accounts written off 11,800 Collections of accounts previously written off 1,100 Current balance of bad debt expense 0 Uncollectible accounts as a percentage of receivables 4.00% Using the balance sheet approach, what is the net realizable value of accounts receivable? EB A/R (EB Allowance for doubtful accounts) - calculated as EB A/R times the "Uncollectible Accounts as a Percentage of A/R" Net Realizable Value...

  • Question Help At the beginning of 2019, Gourmet Cupcakes, Inc. has the following ledger balances: $41,000...

    Question Help At the beginning of 2019, Gourmet Cupcakes, Inc. has the following ledger balances: $41,000 (Debit) $7,000 (Credit) Accounts Receivable Allowance for Bad Debts During the year, credit sales amounted to $810,000. Cash collected on credit sales amounted to $750,000, and $16,000 has been written off. Gourmet Cupcakes uses the aging - of - receivables method to record bad debts expense. The estimate of uncollectible accounts was $29,000. The ending balance in the Allowance for Bad Debts is O...

  • The September 30, 2019, records of Media Communications include these accounts: (Click the icon to view...

    The September 30, 2019, records of Media Communications include these accounts: (Click the icon to view the September 30, 2019 account balances.) During the year, Media Communications estimates Uncollectible-account expense at 1% of credit sales. At year-end (December 31), the company ages its receivables and adjusts the balance in the Allowance for Uncollectible Accounts to correspond to the following aging schedule. (Click the icon to view the Accounts Receivable balance and aging schedule to be used at December 31, 2019.)...

  • Lily Corporation began 2019 with a $14,000 balance in accounts receivable and a $400 balance in...

    Lily Corporation began 2019 with a $14,000 balance in accounts receivable and a $400 balance in the allowance for doubtful accounts. The company had credit sales (sales on account) of $46,000, collections on accounts receivable of $29,000, and wrote off uncollectible accounts of $250 during 2019.  The company uses the allowance method and estimates that 4% of its outstanding accounts receivable balance will be uncollectible. Assuming no other entries were recorded to uncollectible accounts expense during 2019, the amount of the...

  • The September 30, 2019, records of Media Communications include these accounts: (Click the icon to view...

    The September 30, 2019, records of Media Communications include these accounts: (Click the icon to view the September 30, 2019 account balances.) During the year, Media Communications estimates Uncollectible-account expense at 1% of credit sales. At year-end (December 31), the company ages its receivables and adjusts the balance in the Allowance for Uncollectible Accounts to correspond to the following aging schedule. (Click the icon to view the Accounts Receivable balance and aging schedule to be used at December 31, 2019.)...

  • Raintree Cosmetic Company sells its product to customers on a credit basis. An adjusting entry for...

    Raintree Cosmetic Company sells its product to customers on a credit basis. An adjusting entry for uncollectible accounts expense is recorded only at December 31, the company's fiscal year-end. The 2018 balance sheet disclosed the following: Current Assets: Accounts Receivable, net of allowance for uncollectible accounts of $30,000 $432,000 During 2019, credit sales were $1,750,000, cash collections from customers $1,830,000, and $35,000 in accounts receivable were written off. An aging of receivable at December 31, 2019, reveals the following: Age...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT