Question

Can anyone help???

Workshop 3 Problems Student Q Search Sheet Σ AutoSum' ΑΡ. Wrap Text General ** Merge & Center $ % ) . Conditional Format Formatting as Table Cell Styles Insert Delete Home Insert Page Layout Formulas Data Review View Cut Calibri (Body) - 12 -A- A Copy Paste Format B I U . L A E G24 x fc Credit A B C D E F G 1 3.2 Calculation of Allowance for Uncollectibles using the aging of the Accounts Receivable 2 Directions: Complete the following chart and journal entries with the information below: Format Clear Sort & Filter L M N O P Q R S T U H I J K Points: 20 items @ 1 pt each = 20 points total 4 5 6 7 Background information: Goofy and Friends had the following balances at the various ages $1,200,000 less than 30 days old $700,000 31-60 Days old, $200,000 61-120 Days old and $25,000 over 120 days. Goofy is assuming he will collect 98% of balances less than 30 days old, 90% of balance 31-60 days old, 75% of balances 61-120 days old and 50% of balances over 120 days. Complete the following chart based on the aged balances and % of estimated collectibility. 9 a) Estimated Estimated % Amount uncollectible Uncollectible Balance: 10 Age: 11 0-30 Days 12 31 to 60 Days 13 61-120 Days 14 over 120 Days 16 17 Accounts Receivable 18 Less: Allowance for Uncollectible 19 Net Realizable Value 21 b) Assuming the allowance had a beginning credit balance of $15,000 22 prepare a journal entry for the adjustment for the new allowance amount 24 Date Credit ! Account Debit 31-Dec Uncollectible Accounts Expense Allowance for Uncollectible Accounts 30 Helpful Resources AR Video 1 AR Video 2 Problem 3.1 Problem 3.2 Problem 3.3 Problem 3.4 Problem 3.5 Problem 3.6 + Ready @ - - - + 100%

Answer 1

Ans:

Req:1

	Accounts receivables	x	Percent Uncollectable (%)	=	Estimated Uncollectable
1 to 30 days	$ 1,200,000.00	x	2.00%	=	$    24,000.00
31 to 60	$     700,000.00	x	10.00%	=	$    70,000.00
61 to 120	$     200,000.00	x	25.00%	=	$    50,000.00
Over 120	$        25,000.00	x	50.00%	=	$    12,500.00
	$ 2,125,000.00				$ 156,500.00
Estimated balance of allowance for doubtful accounts					$ 156,500.00
	Accounts Receivable				$ 2,125,000.00
	Less: Allowance for Uncollectible				$ 156,500.00
	Net Realisable value				$ 1,968,500.00

Req:2

Date	Accounts	Debit	Credit
Dec 31	Bad debts expense/Uncollectible Accounts Expense	$      141,500.00
	Allowance for doubtful accounts		$    141,500.00
	(To record bad debts expense)

Working

Estimated balance of allowance for uncollectable	$   156,500.00	Cr
Balance in Allowance for uncollectable account (Cr)	$      15,000.00	Cr
Total bad debts to be recorded	$   141,500.00	Cr

Note: Bad debts expense/Uncollectible Accounts Expense both are same type of accounts but different names are used for accounting Purpose