Question

In: Accounting

Using the Accounts Receivable Aging Schedule below, answer the following questions related to Christina’s Cookie Company:...

Using the Accounts Receivable Aging Schedule below, answer the following questions related to Christina’s Cookie Company:

Customer

Current Balance

1-30 days past due

31-60 days past due

61-90 past due

+90 days past due

Total

Smith

$100

$200

$300

Jones

$300

$800

$1,100

Brown

$800

$100

$800

$1,700

Edwards

$5,000

$5,000

Totals

$900

$400

$800

$1,000

$5,000

$8,100

Estimation of the allowance for doubtful accounts is based on the following rules:

Aging Category Probability AR will not be collected

Current 2%

1-30 days past due 4%

31-60 days past due 6%

61-90 days past due 10%

Over 90 days past due 25%

**Note, before any adjustments, the allowance for doubtful accounts has a current credit balance of $300.

Prepare the necessary journal entry to record bad debt expense for the current period.

_____________________________________

   ________________________________________

  

What is the final balance in the Allowance for Doubtful Accounts at the end of the period? $__________________________________

What is the Net Realizable Value of the accounts receivable for Christina’s Cookie Company at the end of the period?

$___________________________________

Solutions

Expert Solution

Age of account Amount Est.% Uncollectible Estimated uncollectibles
1 to 30 days 400 4% 16
31 to 60 days 800 6% 48
61 to 90 days 1,000 10% 100
Over 90 days 5,000 25% 1250
Total 7,200 1,414

Allowance for doubtful accounts ending = $1,414

Allowance for doubtful accounts beginning = $300

Bad debt expense = Allowance for doubtful accounts ending - Allowance for doubtful accounts beginning

= 1,414-300

= $1,114

General Journal Debit Credit
Bad debt expense $1,114
Allowance for doubtful accounts $1,114
(to record bad debt expense for the current period)

The final balance in the Allowance for Doubtful Accounts at the end of the period = $1,414

Net realizable value of accounts receivable = Accounts receivable - Allowance for doubtful accounts ending

= 8,100-1,414

= $6,686

Please give a positive rating if you are satisfied with this solution and if you have any query kindly ask.

Thanks!!!


Related Solutions

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...
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...
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...
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...
Aging of Receivables Schedule The accounts receivable clerk for Kirchhoff Industries prepared the following partially completed...
Aging of Receivables Schedule The accounts receivable clerk for Kirchhoff Industries prepared the following partially completed aging of receivables schedule as of the end of business on November 30: Not Days Past Due Past Over Customer Balance Due 1-30 31-60 61-90 90 Academy Industries Inc. 3,800 3,800 Ascent Company 5,400 5,400 Zoot Company 7,000 7,000 Subtotals 667,600 403,200 146,900 64,100 33,400 20,000 The following accounts were unintentionally omitted from the aging schedule and not included in the subtotals above: Customer...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT