Question

In: Accounting

Drumpf suppy has the following accounts receivable aging schedule as at december 31,2015. Accounts receivable Age...

Drumpf suppy has the following accounts receivable aging schedule as at december 31,2015.

Accounts receivable Age Amount proportion expected to dedaulf allowance required
current $150,000 0.5%
1-30 days past due $65,000 1.0%
31-45 days past due $16,500 13.0%
46-90 days past due $4,500 20.0%
91-135 days past due $3,000 25.0%
over 135 days past due $1,500 60.0%

The balance in drumpf's allowance for doubtful accounts at the beginning of the year is $6,000(credit). During the year, accounts in the total amount of $4,500 were writeen off.

1.use formulas to calculate the allownace required for each line and the total allowance requied.

2.based on aging of receivables, the bad debit expense is___ (build the bad debt expense equation)

3. prepare the journal entry for bad debt expense

4.determine the bad debt expense using the percentafe of credit sales method at 1.5%. Credit sales for the year are $493,000. And prepare the journal entry for bad expense

5. Which method will result in the higher net income for the company?

Which method would a for-profit company probably prefer in these circumstance?

Please explain.

Solutions

Expert Solution

Accounst receivable Aging Amount % Expected of default Allowance required
Current 150000 0.50% 750
1-30 days 65000 1% 650
31-45 days 16500 13% 2145
46-90 days 4500 20% 900
91-135 days 3000 25% 750
Over 135 days 1500 60% 900
Allowance Ending balance 6095
Part-1
Allowance for Doubtful Debts 6000
Less: Bad debts written off 4500
Balance left 1500
Balance Ending to be maintained 6095
Bad debts expense based on Ageing of receivables 4595
Journal entry:
Bad debts expense Dr. 4595
      Allowance for doubtful debts 4595
Part-2
Bad debts expense: Net credt sales   * Percentage of bad debts expense
Bad debts expense: $ 493,000         * 1%       = $4,930
Bad debts expense based on Percent of sales method $4,930
Journal entry:
Bad debts expense Dr. 4930
      Allowance for doubtful debts 4930
Part-3
Allowance based on Aging of Accounts receivable methos results in higher income.
Method based on aging of accounts receivable is probably prefered over toher method due to the reason that it is based on more realistic assumption that the accounts receivable whose aging is higher is having more risk of realisable. Hence, need more provision.

Related Solutions

Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 227,010 _______ March 31–60 129,720 _______ February 61–90 194,580 _______ January 91–120 97,290 _______ Total receivables $ 648,600 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,692,000 in credit sales over the four-month period, compute...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 212,220 _______ March 31–60 94,320 _______ February 61–90 141,480 _______ January 91–120 23,580 _______ Total receivables $ 471,600 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,572,000 in credit sales over the four-month period, compute...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 201,390 _______ March 31–60 115,080 _______ February 61–90 172,620 _______ January 91–120 86,310 _______ Total receivables $ 575,400 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,644,000 in credit sales over the four-month period, compute...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 175,440 _______ March 31–60 87,720 _______ February 61–90 131,580 _______ January 91–120 43,860 _______ Total receivables $ 438,600 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,548,000 in credit sales over the four-month period, compute...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 189,000 _______ March 31–60 135,000 _______ February 61–90 162,000 _______ January 91–120 54,000 _______ Total receivables $ 540,000 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,620,000 in credit sales over the four-month period, compute...
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...
Oriole Co. uses an aging schedule at December 31. Number of Days Outstanding Accounts Receivable Estimated...
Oriole Co. uses an aging schedule at December 31. Number of Days Outstanding Accounts Receivable Estimated % Uncollectible Estimated Uncollectible Accounts 0–30 days $264,600 1% $2,646 31-60 days 71,300 5% 3,565 61-90 days 45,400 11% 4,994 Over 90 days 21,600 19% 4,104 Total $402,900 $15,309 A) Assuming the allowance for doubtful accounts has an unadjusted credit balance of $4,980 at December 31, what is the bad debt expense for the year? Bad debt expense $enter the Bad debt expense in...
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...
Glencoe Supply had the following accounts receivable aging schedule at the end of a recent year....
Glencoe Supply had the following accounts receivable aging schedule at the end of a recent year. Accounts Receivable Age Amount Proportion Expected to Default Allowance Required Current $310,500 0.005 $1,553 1–30 days past due 47,500 0.01 475 31–45 days past due 25,000 0.13 3,250 46–90 days past due 12,800 0.20 2,560 91–135 days past due 6,100 0.25 1,525 Over 135 days past due 4,200 0.60 2,520 $11,883 The balance in Glencoe's allowance for doubtful accounts at the beginning of the...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT