I ALREADY ASKED THIS QUESTION BUT SENT ME THE ANSWER OF ANOTHER EXERCISE. PLEASE HELP ME

John Neff owns and operates Waikiki Surf Shop. A year-end trial balance is provided is shown.

Waikiki Surf Shop

UNADJUSTED TRIAL BALANCE

December 31, 20--

	ACCOUNT TITLE	DEBIT	CREDIT
1	Cash	30,000.00
2	Accounts Receivable	22,500.00
3	Merchandise Inventory	56,200.00
4	Estimated Returns Inventory	800.00
5	Supplies	2,700.00
6	Prepaid Insurance	3,600.00
7	Land	115,000.00
8	Building	135,000.00
9	Accumulated Depreciation-Building		24,000.00
10	Store Equipment	75,000.00
11	Accumulated Depreciation-Store Equipment		22,500.00
12	Accounts Payable		15,000.00
13	Customer Refunds Payable		1,100.00
14	Wages Payable
15	Unearned Boat Rent Revenue		33,000.00
16	J. Neff, Capital		240,100.00
17	J. Neff, Drawing	40,875.00
18	Income Summary
19	Sales		404,950.00
20	Sales Returns and Allowances	6,000.00
21	Boat Rental Revenue
22	Purchases	157,500.00
23	Purchases Returns and Allowances		1,200.00
24	Purchases Discounts		1,500.00
25	Freight-In	675.00
26	Wages Expense	63,000.00
27	Advertising Expense	11,250.00
28	Supplies Expense
29	Phone Expense	5,250.00
30	Utilities Expense	18,000.00
31	Insurance Expense
32	Depreciation Expense-Building
33	Depreciation Expense-Store Equipment
34	Totals	743,350.00	743,350.00

Neff uses the periodic inventory system. Year-end adjustment data are as follows:

(a, b)	A physical count shows that merchandise inventory costing $51,800 is on hand as of December 31, 20--.
(c, d, e)	Neff estimates that customers will be granted $2,000 in refunds of this years sales next year and the merchandise expected to be returned will have a cost of $1,200.
(f)	Supplies remaining at the end of the year, $600.
(g)	Unexpired insurance on December 31, $2,600.
(h)	Depreciation expense on the building for 20--, $5,000.
(i)	Depreciation expense on the store equipment for 20--, $3,000.
(j)	Wages earned but not paid as of December 31, $1,800.
(k)	Neff also offers boat rentals which clients pay for in advance. Unearned boat rental revenue as of December 31 is $3,000.

Required:

1.	Prepare a year-end spreadsheet.
2.	Journalize the adjusting entries.
3.	Compute cost of goods sold using the spreadsheet prepared for part (1).

Indnachons Spreadshoot Cash Accounts Receivable Merchandise Inventory Estimated Returns Inventory 7 Supplies La Femaid Inputation Land Building ant Score 69.07% F ny ACCOUNT TITLE Wak Surf Shop End of Penod Spreadsheet For the Year Ended December 21, 20- TRIAL BALANCE TRIAL BALANCE CREDIT DEBIT 50,000.00 22.500.00 56,200.00 800.00 2,700.00 3,500.00 115,000.00 155,000.00 do 4+ ADJUSTMENTS DEBIT 51.800.00 1,200.00 R ADRUSTMENTS CREDIT * 56.200.00 2.100.00 1,000.00 Score: 246/311 ADHUSTED TRIAL ADESTED TRIAL BALANCE BALANCE DEBIT CREDIT 30.000.00 22.500.00 51,800.00 600.00 2.500.00 135,000.00 hapter 14 Mastery (Mastery) Mastery Problem Instructions Chartsit Accounts Amount Descriptions Spreadsheet General Journal Spreadsheet building 155.000.00 Acumulated Depreciation Building 24,000.00 Sve Exament 75.000.00 Accumulated Depression Equipment 22.500.00 Accounts Payabl 15.000.00 Ginter Refunds Payable 1.100.00 Wages Payable theamed Rent Revenue $3.000.00 Le Capital 240,100.00 40875.00 404.950.00 6.000.00 15750000 Net, Drawing Income Summary Sales Sales Returm and Allowanon 11 Bout Rental Revenue Pechases Check My Work ment Score: 69.07% 37 anny Cost of Goods Sold 30.000.00 5.000.00 1.800.00 155,000.00 75,000.00 40.875.00 79,000.00 25,500.00 15,000.00 1100.00 1,800.00 3,000.00 240.100.00 404.950.00 30.000.00 Email instructi Chapter 14 Mastery (Mastery) Mastery Problem Chart of A Art De Spreadsheet Go Cooroo tudos Spreadsheet Pachine Puthem and be Hadsets 157500 1.500.00 6000 Was bee Atising 11200 Phone T10000 TRO th 0.00 SH Direction 543350.00 516000 co Check signment for 607 5597 Spreadsheet 2. General Journal GENERAL JOURNAL Score: 239/276 POST. REF. DEBIT CREDIT DATE ACCOUNT TITLE Adjusting Entries Dec 31 Merchandise Inventory Income Summary 51,800.00 1.200.00 1,200.00 Purchases Discounts 1,500.00 Purchases 157.500.00 2 Dec 31 159,200.00 Income Summary Merchandise Inventory Sales Returns and Allowances 35 159.200.00 8 3 Dec. 31 2,000.00 39 Account receivable 2,000.00 10 1.200.00 11 Dec 31 Estimated Returns Inventory Income Summary Dec 31 Supplies Expense 1,200.00 37 12 2.100.00 38 ck My Work nt Score: 69.07% uctions adsheet General Journal Cost of Goods Sold Shared ceshavedback Waikik Surt Shop Shaded check Score: 14/131 Income Statement (Parta) For the Year Ended December 31, 20 1 Cost of goods solit 2 beginning inventory 556.200.00 157.500.00 1 Purchases Phi 5157.500.00 Uti less: purchase mums and allowance 5 Less: Purchases discounts $1.500.00 Ins Del 2 Del Net Income By Work core: 69.07%