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

Free

70.2K

Verified Solution

Question

Accounting

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

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

110Cash$ 83,600
112Accounts Receivable233,900
115Merchandise Inventory624,400
116Estimated Returns Inventory28,000
117Prepaid Insurance16,800
118Store Supplies11,400
123Store Equipment569,500
124Accumulated Depreciation-Store Equipment56,700
210Accounts Payable96,600
211Customers Refunds Payable50,000
212Salaries Payable
310Lynn Tolley, Capital, June 1, 2018685,300
311Lynn Tolley, Drawing135,000
410Sales5,069,000
510Cost of Merchandise Sold2,823,000
520Sales Salaries Expense664,800
521Advertising Expense281,000
522Depreciation Expense
523Store Supplies Expense
529Miscellaneous Selling Expense12,600
530Office Salaries Expense382,100
531Rent Expense83,700
532Insurance Expense
539Miscellaneous Administrative Expense7,800

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

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

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

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

May20Sold 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.
21For the convenience of Crescent Co., paid freight on sale ofMay 20, $2,300.
21Received $42,900 cash from Gee Co. on account.
21Purchased merchandise on account from Osterman Co., terms 1/10,n/30, FOB destination, $88,000.
24Returned damaged merchandise purchased on May 21, receiving acredit memo from the seller for $5,000.
26Refunded cash on sales made for cash, $7,500. The cost of themerchandise returned was $4,800.
28Paid sales salaries of $56,000 and office salaries of$29,000.
29Purchased store supplies for cash, $2,400.
30Sold 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.
30Received cash from sale of May 20 plus freight paid on May21.
31Paid for purchase of May 21, less return of May 24
DateAccountsdebitCredit
May-01Rent expense5000
cash5000
May-03Inventory35280
   Accounts Payable-Martin Co.35280
May-04Inventory600
Cash600
May-06Accounts receivable67130
Sales67130
Cost of goods sold41000
Inventory41000
May-07Cash22300
Accounts Receivable-Halstad co.22300
May-10Cash54000
sales54000
Cost of goods sold32000
inventory32000
May-13Accounts payable-Martin Co.35280
cash35280
May-15Advertising expense11000
cash11000
May-16Cash67130
Accounts receivable-Korman Co.67130
May-19Inventory18700
cash18700
May-19Accounts payable-Buttons Co.33450
cash33450
May-20Customers refunds payable13230
cash13230
Inventory8000
Estimated returns inventory8000
May-20Accounts receivable-Crescent Co.108900
sales108900
Cost of goods sold70000
inventory70000
May-21Accounts receivable-Crescent Co.2300
   cash2300
May-21Cash42900
Accounts receivable-gee Co.42900
May-21inventory87120
accounts payable-Osterman Co.87120
May-24Accounts payable-Osterman Co.4950
inventory4950
May-26Customers refunds payable7500
cash7500
Inventory4800
Estimated returns inventory4800
May-28Sales Salaries Expense56000
Office Salaries Expense29000
cash85000
May-29Store Supplies2400
cash2400
May-30Accounts receivable-Turner Co.77175
sales77175
Cost of goods sold47000
inventory47000
May-30Cash111200
   Accounts receivable-Crescent Co.111200
May-31Accounts payable-Osterman Co.82170
   Cash82170
Adjusting Entries
May 31
a.Cost of Merchandise Sold13,950
Merchandise Inventory13,950
b.Insurance Expense12,000
Prepaid Insurance12,000
c.Store Supplies Expense9,800
Store Supplies9,800
d.Depreciation Expense14,000
Accumulated Depreciation: Store Equipment14,000
e.Sales Salaries Expense7,000
Office Salaries Expense6,600
Salaries Payable13,600
f.Estimated Refunds Inventory35,000
Cost of Merchandise Sold35,000
g.Customer Returns and Allowances60,000
Customer Refunds Payable60,000

Create an adjusting trail balance.

Answer & Explanation Solved by verified expert
3.5 Ratings (364 Votes)

  • 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

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students