please do the financial statements tab
W 5 8 9 10 11 12 Inventory 7 Supplies 13 Cash Accounts Receivable Note Receivable 14 15 10 C ACRS.I On December 1.2022, Divine Distributing Company had the following account balances. Debit Credit 17 10 125% Zoom 19 20 Prepaid Rent Equipment 21 22 23 Probl 24 25 20 A During December, the company completed the following transactions Dec 30 31 Add Category General Journal 32 B T Accounts Insert Table Chart Trial Balance 9.200.00 5.400.00 Accumulated Depreciation Equipment 6,000.00 Accounts Payable 10.700.00 Uneamed Service Revenue 1,500.00 Salaries and Wages Payable 9,600.00 Common Stock 21,000.00 Retained Earnings 63.400.00 D Adjustment data Accrued salaries and wages payable were $850 at the end of the month 4,200.00 7,100.00 2.100.00 1.200.00 18,000.00 30,800.00 63,400.00 27 2 Depreciation was $460 per month 283 Supplies on hand were $1.300 29 4. One month of interest income should be recorded on the $6000 Note Receivable at an APR of 5% 5. Services were preformed to satisfy $1200 of the uneamed revenue 6 December's prepaid rent has been used (annual amount was $9600 as recorded in Prepaid Rent) 1234 Text Shape Media Comment Adjusting Entries E 27 Received collections in full, less discounts from customers billed on December 18 28 Received $500 from customers for services to be preformed in the future 29 Purchase Equipment on account for $3200 F Financial Statements 30.The cost of the merchandise sold was $7,500 6 Paid $2,200 for salaries and wages due employees, of which $1000 is for December and $1,200 was accrued in November to salaries a 7 $300 of merchandise was returned from a November 30, 2022 sale on account 8 Received $1,800 cash from customers in payment of account (no discount allowed) 10 Sold merchandise for cash $9,100 The cost of the merchandise sold was $5,000 13 Purchased merchandise on account from Hecht Co $7,500, terms 2/10, n/30 15 Purchased supplies for cash $1,800 18 Sold merchandise on account $14.000, terms 3/10 20 Paid salaries and wages $2.400. 21 Paid $2.400 in advance for next year's annual insurance 23 Paid Hecht Co. in full less discount H I 33 34 Required 35 Complete each tab of this Excel Worksheet: General Journal (all transactions in December), map into T Accounts (add any if necessary), prepare Tral Balance 36 prepare the adjusting entries (1-6 above), Prepare Financial Statements in good form (multi-step income statement, statement of retained earnings balance sheet) 37 prepare the closing entries prepare the required ratio computations Collaborate Table Headers & Foot O Table Name Rows Columns Table Font Size Table Outline C Outine table na Gridlines 11 Alternating How Row & Column Size Height Widh el Problem General Journal Divine Distribuing Company Income Statement (Multi-Step format) For the Month Ended December 31, 2022 Sales Operating Expenses Income From Operations Other Revenues/Gains T Accounts Net Sales Total Operating Expenses Gross Profit Current Assets Net Income/Loss Divine Distribuing ompany Retained Earnings Statement For the Month Ended December 31, 2022 Divine Distribuing Company Balance Sheet December 31, 2022 Retained Earnings as of December 31, 2022 Trial Balance TEAL Snape Media Adjusting Entries 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Comment Financial Statements V Co W 5 8 9 10 11 12 Inventory 7 Supplies 13 Cash Accounts Receivable Note Receivable 14 15 10 C ACRS.I On December 1.2022, Divine Distributing Company had the following account balances. Debit Credit 17 10 125% Zoom 19 20 Prepaid Rent Equipment 21 22 23 Probl 24 25 20 A During December, the company completed the following transactions Dec 30 31 Add Category General Journal 32 B T Accounts Insert Table Chart Trial Balance 9.200.00 5.400.00 Accumulated Depreciation Equipment 6,000.00 Accounts Payable 10.700.00 Uneamed Service Revenue 1,500.00 Salaries and Wages Payable 9,600.00 Common Stock 21,000.00 Retained Earnings 63.400.00 D Adjustment data Accrued salaries and wages payable were $850 at the end of the month 4,200.00 7,100.00 2.100.00 1.200.00 18,000.00 30,800.00 63,400.00 27 2 Depreciation was $460 per month 283 Supplies on hand were $1.300 29 4. One month of interest income should be recorded on the $6000 Note Receivable at an APR of 5% 5. Services were preformed to satisfy $1200 of the uneamed revenue 6 December's prepaid rent has been used (annual amount was $9600 as recorded in Prepaid Rent) 1234 Text Shape Media Comment Adjusting Entries E 27 Received collections in full, less discounts from customers billed on December 18 28 Received $500 from customers for services to be preformed in the future 29 Purchase Equipment on account for $3200 F Financial Statements 30.The cost of the merchandise sold was $7,500 6 Paid $2,200 for salaries and wages due employees, of which $1000 is for December and $1,200 was accrued in November to salaries a 7 $300 of merchandise was returned from a November 30, 2022 sale on account 8 Received $1,800 cash from customers in payment of account (no discount allowed) 10 Sold merchandise for cash $9,100 The cost of the merchandise sold was $5,000 13 Purchased merchandise on account from Hecht Co $7,500, terms 2/10, n/30 15 Purchased supplies for cash $1,800 18 Sold merchandise on account $14.000, terms 3/10 20 Paid salaries and wages $2.400. 21 Paid $2.400 in advance for next year's annual insurance 23 Paid Hecht Co. in full less discount H I 33 34 Required 35 Complete each tab of this Excel Worksheet: General Journal (all transactions in December), map into T Accounts (add any if necessary), prepare Tral Balance 36 prepare the adjusting entries (1-6 above), Prepare Financial Statements in good form (multi-step income statement, statement of retained earnings balance sheet) 37 prepare the closing entries prepare the required ratio computations Collaborate Table Headers & Foot O Table Name Rows Columns Table Font Size Table Outline C Outine table na Gridlines 11 Alternating How Row & Column Size Height Widh el Problem General Journal Divine Distribuing Company Income Statement (Multi-Step format) For the Month Ended December 31, 2022 Sales Operating Expenses Income From Operations Other Revenues/Gains T Accounts Net Sales Total Operating Expenses Gross Profit Current Assets Net Income/Loss Divine Distribuing ompany Retained Earnings Statement For the Month Ended December 31, 2022 Divine Distribuing Company Balance Sheet December 31, 2022 Retained Earnings as of December 31, 2022 Trial Balance TEAL Snape Media Adjusting Entries 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Comment Financial Statements V Co
