using info from excel journal below complete a worksheet using the following information for accounting adjustments. complete the columns for adjusting entries, income statement, and balance sheet. also record required closing entries.

1. Expired insurance, $553

2. Ending store supplies inventory, $2632

3. Ending office supplies inventory, $504

4. Depreciation of store equipment, $567

5. Depreciation of office equipment, $329

D Credit Date Account Debit 1-May Rent expense-selling space Rent expense-office space Cash 2,968 742 3,710 6,100 2-May Accounts receivable-Cole cmpany Sales revenue 6,100 4,100 Cost of goods sold Merchandise inventory 4,100 175 2-May Sales return and allowance Accounts receivable-Mercer 175 798 3-May Accounts Payable-Preston Merchandise inventory 798 37,072 574 4-May Merchandise inventory Store supplies Office supplies Accounts payable-Davis supply co 83 mama 37,729 5-May Cash Sales Discount (4,550*2%) Accounts receivable-Mercer (4,725-175) 4,459 91 4,550 28 6300 8-May Accounts Payable-Preston (7,098-798) Merchandise Inventory Sheet1 126 6300 8-May Accounts Payable-Preston (7,098-798) Merchandise Inventory Cash 126 6,174 350 9-May Cash Sales Revenue 350 Nolaloo ooo 350 Cost of goods sold Store supplies 350 4,074 10-May Office equipment Accounts payable-Davis supply co 4,074 11-May Cash Sales discount (6,100*2%) Accounts receivable-Cole company 5,978 122 6,100 8,800 o ocow 11-May Merchandise inventory Accounts payable-Henley 8,800 854 12-May Accounts payable-Davis supply co Office equipment 854 1 15-May Sales saleries expense Office salaries expense Cash 5,320 3,150 8,470 59,220 15-May Cash Sales revenue 59,220 38,200 Cost of goods sold Merchandise inventory 38,200 3,990 16-May Accounts receivable-Cole company Sales revenue 3,990 1,890 Cost of goods sold Merchandise inventory 1,890 13,650 17-May Merchandise inventory Accounts payable-Summit corp 13,650 8,800 19-May Accounts payable-Henley Company Merchandise inventory (8,800*2%) Cash 176 8,624 6,850 22-May Accounts receivable-Crane service Sales revenue 6,850 4,990 Cost of good sold Merchandise inventory 4,990 80 13,650 23-May Accounts payable-Summit corp Merchandise inventory (13,650*2%) Cash Sheet1 273 13,377 IC ID 8,120 630 24-May Merchandise inventory Store supplies Office supplies Accounts payable-Davis supply co 280 9,030 3,080 25-May Merchandise inventory Accounts payable-preston 3,080 14,210 26-May Accounts receivable-Crank corp Sales revenue 14,210 8,230 Cost of goods sold Merchandise inventory 8,230 1,283 26-May Electricity expense Cash 1,283 O 7,000 29-May Jenny Spark, Withdrawal Cash 7,000 WN 4 30-May Cash Sales discount (6,850*2%) Accounts receivable 6,713 137 6,850 08 30-May Sales saleries expense Office saleries expense Cash 5,320 3,150 09 10 8,470 11 7,000 29-May Jenny Spark, Withdrawal Cash 7,000 30-May Cash Sales discount (6,850*2%) Accounts receivable 6,713 137 6,850 30-May Sales saleries expense Office saleries expense Cash 5,320 3,150 8,470 66,052 31-May Cash Sales revenue 66,052 42,500 Cost of goods sold Merchandise inventory 42,500 Northridge LLC Trial Balance April 30, 20XX Credit Debit $58,791 Cash ACCT205 --Portfolio Project Accounts receivable Merchandise inventory Store Supplies Office Supplies Prepaid Insurance Office equipment Accumulated depreciation Office Equipment Store equipment Accumulated depreciation Store Equipment Accounts Payable J. Spark, Capital 18,495 85 221 2250 885 1659 2500 $658 16580 2.268 50921 132.534 Totals $186.381 S186,381