Question

In: Accounting

I need an unadjusted and adjusted trial balance for this problem please and thank you! Palisade...

I need an unadjusted and adjusted trial balance for this problem please and thank you!

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

Solutions

Expert Solution

Unadjusted Trial Balance
Cash 84500
Accounts Receivable 245,875
Merchandise Inventory 583,950
Estimated Returns Inventory 15,200
Prepaid Insurance 16,800
Store Supplies 13,800
Store Equipment 569,500
Accumulated Depreciation-Store Equipment 56700
Accounts Payable 63150
Customers Refunds Payable 29270
Salaries Payable
Lynn Tolley, Capital, June 1, 2018 685300
Lynn Tolley, Drawing 135,000
Sales 5376205
Cost of Merchandise Sold 3,013,000
Sales Salaries Expense 720,800
Advertising Expense 292000
Depreciation Expense
Store Supplies Expense
Miscellaneous Selling Expense 12,600
Office Salaries Expense 411,100
Rent Expense 88,700
Insurance Expense
Miscellaneous Administrative Expense 7,800
6210625 6210625

Working

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

Related Solutions

need to fill this out            Account Unadjusted Trial Balance Adjusting Entries Adjusted Trial Balance Income...
need to fill this out            Account Unadjusted Trial Balance Adjusting Entries Adjusted Trial Balance Income Statement Number Name Debit Credit Debit Credit Debit Credit Debit Credit 1110 Cash 100,612.00               -                 -                 -   100,612.00               -   1120 Accounts Receivable               -           325.00               -                 -                 -           325.00 1130 Prepaid Insurance      4,968.00               -                 -                 -        4,968.00               -   1140 Prepaid Rent      4,800.00               -                 -                 -  ...
Account Unadjusted trial balance(debit) Unadjusted trial balance(credit Adjusting entries(debit) adjusting entries(credit) adjusted trial balance(debit) Adjusted trial...
Account Unadjusted trial balance(debit) Unadjusted trial balance(credit Adjusting entries(debit) adjusting entries(credit) adjusted trial balance(debit) Adjusted trial balance(credit) Cash 32,236.75 32,236.75 baking supplies 18,500 18,500 merchandise inventory(fifo) 175.65 175.65 prepaid rent 1500 1500 prepaid insurance 2400 2400 baking equipment 6000 6000 accumulated depreciation 208.33 208.33 office supplies 600 600 accounts receivable 7700 7700 notes payable 10,000 10,000 wages payable 480 480 common stock 16,000 16,000 dividends 10,000 10,000 bakery sales 55,000 55,000 merchandise sales 221 221 baking supplies expense rent expense...
Describe the flow of accounting information from the unadjusted trial balance into the adjusted trial balance...
Describe the flow of accounting information from the unadjusted trial balance into the adjusted trial balance and financial statements.
I need an adjusted trial balance for this question. Here are the instructions, the journal, and...
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...
Q2. Both the unadjusted trial balance and adjusted trial balance for Smith Corporation on December 31,...
Q2. Both the unadjusted trial balance and adjusted trial balance for Smith Corporation on December 31, 2013, are listed below: Smith Corporation Trial Balance December 31, 2013 Unadjusted Adjusted Debit Credit Debit Credit Cash Accounts Receivables Supplies Prepaid Insurance Land Vehicles Accumulated Depreciation-Vehicles Notes Payable Wages Payable Common Stock Dividends Revenue Wages Expense Utilities Expense Insurance Expense Rent Expense Depreciation Expense Supplies Expense 8,000 19,000 6,000 10,000 13,000 20,000 4,000 12,000 4,000 0 4,000 0 0 4,000 13,000 0 46,000...
JC’s Company’s unadjusted and adjusted trial balances at December 31, 2017, follow. Unadjusted trial Balance DR...
JC’s Company’s unadjusted and adjusted trial balances at December 31, 2017, follow. Unadjusted trial Balance DR CR Cash 105,000 Prepaid Rent 60,000 Supplies 38,000 Office furniture 460,000 Accumulated dep office furniture 92,000 Accounts payable 102,500 Salaries payable Unearned service revenue 15,900 SWT, Capital 453,000 SWT, Drawing 15,400 Service revenue 205,000 Salaries expense 110,000 Depreciation expense Supplies Expense Rent Expense 80,000 868,400 868,400 Adjusted Trial Balance DR CR Cash 105,000 Prepaid Rent 20,000 Supplies 19,500 Office furniture 460,000 Accumulated dep office...
This first phase will take you to the UNadjusted trial balance. You will need to: Start...
This first phase will take you to the UNadjusted trial balance. You will need to: Start with the post-closing trial balance dated December 31, 2018 provided in the appropriate tab, and enter the ending balances from the post-closing trial balance into your general ledger accounts. These will be your beginning balances for 2019. Make the general journal entries in the general journal. There are 19 summary entries that you will need to record. No dates are provided so use the...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet included with the data below. Also, create a pivot table. Create a general ledger, worksheet, income statement, changes in retained earnings, and balance sheet with the data below. June 1: Hudson Bloom invested $105,273.00 cash and computer equipment with a fair market value of $32,970.00 in his new business, Byte of Accounting. June 1:   Check # 5000 was used to purchased office...
I need answer of Question 6? Below is the unadjusted trial balance for Walton Anvils as...
I need answer of Question 6? Below is the unadjusted trial balance for Walton Anvils as of December 31, 2016, and the data for the adjustments. Walton Anvils Unadjusted Trial Balance December 31, 2016 Balance Account Title Debt Credit Cash $    16,900.00 Accounts Receivable               17,500 Prepaid Rent                 2,500 Office Supplies                 1,900 Equipment               23,000 Accumulated Depreciation - Equipment $       7,000.00 Accounts Payable           6,200.00 Salaries Payable Unearned Revenue           5,600.00 Common Stock         28,000.00 Retained Earnings          ...
Cybertext. Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement,...
Cybertext. Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet included with the data below. Also, create a pivot table. Create a general ledger, worksheet, income statement, changes in retained earnings, and balance sheet with the data below. Byte of Accounting, Inc. June 1: Byte of Accounting, Inc. issued 2,620 shares of its common stock to Jeremy after $27,250 in cash and computer equipment with a fair market value of $38,250...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT