Question

I need an adjusted trial balance for this question. Here are the instructions, the journal, and the unadjusted trial balance.

Palisade Creek Co. is a merchandising business that uses the perpetual inventory system. The account balances for Palisade Creek Co. as of May 1, 2019 (unless otherwise indicated), are as follows:

110	Cash	$ 83,600
112	Accounts Receivable	233,900
115	Merchandise Inventory	624,400
116	Estimated Returns Inventory	28,000
117	Prepaid Insurance	16,800
118	Store Supplies	11,400
123	Store Equipment	569,500
124	Accumulated Depreciation-Store Equipment	56,700
210	Accounts Payable	96,600
211	Customers Refunds Payable	50,000
212	Salaries Payable	—
310	Lynn Tolley, Capital, June 1, 2018	685,300
311	Lynn Tolley, Drawing	135,000
410	Sales	5,069,000
510	Cost of Merchandise Sold	2,823,000
520	Sales Salaries Expense	664,800
521	Advertising Expense	281,000
522	Depreciation Expense	—
523	Store Supplies Expense	—
529	Miscellaneous Selling Expense	12,600
530	Office Salaries Expense	382,100
531	Rent Expense	83,700
532	Insurance Expense	—
539	Miscellaneous Administrative Expense	7,800

During May, the last month of the fiscal year, the following transactions were completed:

Record the following transactions on page 20 of the journal. Refer to the Chart of Accounts for exact wording of account titles.

May	1	Paid rent for May, $5,000.
	3	Purchased merchandise on account from Martin Co., terms 2/10, n/30, FOB shipping point, $36,000.
	4	Paid freight on purchase of May 3, $600.
	6	Sold merchandise on account to Korman Co., terms 2/10, n/30, FOB shipping point, $68,500. The cost of the merchandise sold was $41,000.
	7	Received $22,300 cash from Halstad Co. on account.
	10	Sold merchandise for cash, $54,000. The cost of the merchandise sold was $32,000.
	13	Paid for merchandise purchased on May 3.
	15	Paid advertising expense for last half of May, $11,000.
	16	Received cash from sale of May 6.
	19	Purchased merchandise for cash, $18,700.
	19	Paid $33,450 to Buttons Co. on account.
	20	Paid Korman Co. a cash refund of $13,230 for returned merchandise from sale of May 6. The invoice amount of the returned merchandise was $13,500, and the cost of the returned merchandise was $8,000.

Record the following transactions on page 21 of the journal. Refer to the Chart of Accounts for exact wording of account titles.

May	20	Sold merchandise on account to Crescent Co., terms 1/10, n/30, FOB shipping point, $110,000. The cost of the merchandise sold was $70,000.
	21	For the convenience of Crescent Co., paid freight on sale of May 20, $2,300.
	21	Received $42,900 cash from Gee Co. on account.
	21	Purchased merchandise on account from Osterman Co., terms 1/10, n/30, FOB destination, $88,000.
	24	Returned damaged merchandise purchased on May 21, receiving a credit memo from the seller for $5,000.
	26	Refunded cash on sales made for cash, $7,500. The cost of the merchandise returned was $4,800.
	28	Paid sales salaries of $56,000 and office salaries of $29,000.
	29	Purchased store supplies for cash, $2,400.
	30	Sold merchandise on account to Turner Co., terms 2/10, n/30, FOB shipping point, $78,750. The cost of the merchandise sold was $47,000.
	30	Received cash from sale of May 20 plus freight paid on May 21.
	31	Paid for purchase of May 21, less return of May 24

Date	Accounts	debit	Credit
May-01	Rent expense	5000
	cash		5000
May-03	Inventory	35280
	Accounts Payable-Martin Co.		35280
May-04	Inventory	600
	Cash		600
May-06	Accounts receivable	67130
	Sales		67130
	Cost of goods sold	41000
	Inventory		41000
May-07	Cash	22300
	Accounts Receivable-Halstad co.		22300
May-10	Cash	54000
	sales		54000
	Cost of goods sold	32000
	inventory		32000
May-13	Accounts payable-Martin Co.	35280
	cash		35280
May-15	Advertising expense	11000
	cash		11000
May-16	Cash	67130
	Accounts receivable-Korman Co.		67130
May-19	Inventory	18700
	cash		18700
May-19	Accounts payable-Buttons Co.	33450
	cash		33450
May-20	Customers refunds payable	13230
	cash		13230
	Inventory	8000
	Estimated returns inventory		8000
May-20	Accounts receivable-Crescent Co.	108900
	sales		108900
	Cost of goods sold	70000
	inventory		70000
May-21	Accounts receivable-Crescent Co.	2300
	cash		2300
May-21	Cash	42900
	Accounts receivable-gee Co.		42900
May-21	inventory	87120
	accounts payable-Osterman Co.		87120
May-24	Accounts payable-Osterman Co.	4950
	inventory		4950
May-26	Customers refunds payable	7500
	cash		7500
	Inventory	4800
	Estimated returns inventory		4800
May-28	Sales Salaries Expense	56000
	Office Salaries Expense	29000
	cash		85000
May-29	Store Supplies	2400
	cash		2400
May-30	Accounts receivable-Turner Co.	77175
	sales		77175
	Cost of goods sold	47000
	inventory		47000
May-30	Cash	111200
	Accounts receivable-Crescent Co.		111200
May-31	Accounts payable-Osterman Co.	82170
	Cash		82170

Adjusting Entries
May 31
a.	Cost of Merchandise Sold	13,950
	Merchandise Inventory		13,950
b.	Insurance Expense	12,000
	Prepaid Insurance		12,000
c.	Store Supplies Expense	9,800
	Store Supplies		9,800
d.	Depreciation Expense	14,000
	Accumulated Depreciation: Store Equipment		14,000
e.	Sales Salaries Expense	7,000
	Office Salaries Expense	6,600
	Salaries Payable		13,600
f.	Estimated Refunds Inventory	35,000
	Cost of Merchandise Sold		35,000
g.	Customer Returns and Allowances	60,000
	Customer Refunds Payable		60,000

Create an adjusting trail balance.

Answer 1

• Credit Balances are shown in negative.

Adjusted Trial Balances

A/c no	A/c name	Unadjsuted balance	Adjsutment entries		Adjusted balance
			Addition/ reduction based on jounral entries	Total changes
110	Cash	$83,600	-5000-600+22300+54000-35280-11000+67130- 18700-33450-13230+2300+42900-7500-85000-2400 +111200-82170	5500	$89,100
112	Accounts Receivable	233,900	67130-22300-67130+108900-2300-42900+ 77175-111200	7375	241,275
115	Merchandise Inventory	624,400	600+35280-41000-32000+18700+8000-70000+87120-4950+4800-47001	-40450	583,950
116	Estimated Returns Inventory	28,000	-8000-4800	-12800	15,200
117	Prepaid Insurance	16,800		0	16,800
118	Store Supplies	11,400	2400	2400	13,800
123	Store Equipment	569,500		0	569,500
124	Accumulated Depreciation-Store Equipment	-56,700		0	-56,700
210	Accounts Payable	-96,600	-35280+35280+33450-87120+4950+82170	33450	-63,150
211	Customers Refunds Payable	-50,000	13230+7500	20730	-29,270
212	Salaries Payable	—
310	Lynn Tolley, Capital, June 1, 2018	-685,300			-685,300
311	Lynn Tolley, Drawing	135,000			135,000
410	Sales	-5,069,000	-67130-54000-108900-77175	-307205	-5,376,205
510	Cost of Merchandise Sold	2,823,000	41000+32000+70000+47000	190000	3,013,000
520	Sales Salaries Expense	664,800	56000	56000	720,800
521	Advertising Expense	281,000	11000	11000	292,000
522	Depreciation Expense	—
523	Store Supplies Expense	—
529	Miscellaneous Selling Expense	12,600			12,600
530	Office Salaries Expense	382,100	29000	29000	411,100
531	Rent Expense	83,700	5000	5000	88,700
532	Insurance Expense	—
539	Miscellaneous Administrative Expense	7800			7,800
	TOTAL	$0		$0	$0