Question

Your solution must include all supporting calculations and these supporting calculations must be performed with appropriate Excel formulas. Failure to do so will result in a reduction in points. For each case, you must submit one printed copy of the Excel spreadsheet which contains your case solution and a second printed copy displaying the formulas contained in each cell of the spreadsheet. Be sure to format your spreadsheet so that your work is clearly presented and easy to review.

Wright Products Company

Wright Products Company was founded in early 2010. Wright offers credit terms (net 30 days) to all of its customers. As Wright has been required to write-off several customer accounts, Wright uses the allowance method to provide for uncollectible receivables. During 2018, Wright provided for uncollectible accounts receivable with a monthly provision of 1% of credit sales. However, at year-end, an aging of accounts receivable is prepared and the allowance for uncollectible accounts is adjusted based on an analysis of the aging. At December 31, 2017, the adjusted balance of the allowance for uncollectible accounts was $21,500, and the balance of accounts receivable was $156,500.

During 2018, Wright wrote-off $19,000 of customer accounts that were deemed to be uncollectible, due to customers declaring bankruptcy or experiencing financial difficulties so severe that extensive collection efforts were not successful. One customer’s account with a $2,500 balance, which had been written-off in June 2016, was subsequently collected from the customer in April 2018. Wright maintained the same monthly provision of 1% of credit sales throughout 2018. Monthly sales for 2018 are as follows:

January $ 43,500

February 56,000

March 62,600

April 49,200

May 53,800

June 46,500

July 72,400

August 57,400

September 81,000

October 65,800

November 49,200

December 62,600

Total cash collections of accounts receivable during 2018 (not including the collection of the previously written-off account) were $667,500.

In preparation for its year-end closing process, Wright’s controller prepared the following aging of accounts receivable as of December 31, 2018, assigning probabilities of collection based on discussions with Wright’s credit manager:

Percentage of

Age of Account Receivable % of Accounts Receivable Probability of Collection

0-30 days past due 70% 95%

31-60 days past due 15% 80%

61-90 days past due 9% 60%

greater than 90 days past due 6% 10%

Requirements

a) Prepare an analysis computing the unadjusted balance in the allowance for uncollectible accounts as of 12/31/18.

b) Prepare the year-end adjusting journal entry to record bad debt expense based on the December 31, 2018 aging of accounts receivable.

Answer 1

a) Unadjusted balance in the "Allowance for Uncollectible Accounts" as of 12/31/18 are:
Total credit sales during 2018=
43500
56000
62600
49200
53800
46500
72400
57400
81000
65800
49200
62600
700000
Balance on Dec 31, 17	21500
Less: written off during 2018	-19000
Add: written off balance collected	2500
Add:Provision maintained	7000	700000*1%
Balance of Allow for Unc. Acc. on Dec 31, 18	12000
b) Unadjusted Balance in AR on dec 31, 18:
Balance on Dec 31 2017	156500
add: sales during 2018	700000
less: Cash collected 2018	-667500
Balance on dect 31 2018	189000
As per age, amount of AR uncollectible on Dec 31 2018:
	% of AR	Acc. Rec.	% of collectible	Collectible	Uncollectible
0-30	70%	132300	95%	125685	6615
31-60	15%	28350	80%	22680	5670
61-90	9%	17010	60%	10206	6804
> 90	6%	11340	10%	1134	10206
total	100%	189000			29295
Allowance adjustment required:
Total expected uncollectible AR	29295
Less:Balance on Dec 31, 18	-12000
Allowance adjustment required:	17295
Adjustment entry for Bad Debt as on Dec 31 2018:
	Debit$	Credit$
Bad Debt Account	17295
Allowance for Uncollectible accounts		17295