complete the T accounts table for each of the following dates in rhe pictures. ignore my current entries

15 16 125% Cash Accounts Receivable Note Receivable Zoom 17 Problem 18 A Inventory Supplies Prepaid Rent Equipment 19 Add Category General Journal B ACRS I On December 1, 2022, Divine Distributing Company had the following account balances Debit Credit T Accounts C 5 1 During December, the company completed the following transactions. 2 Dec 13 14 Uneamed Service Revenue 9.200.00 5,400.00 Accumulated Depreciation Equipment 6.000.00 Accounts Payable 10.700.00 1,500.00 Salaries and Wages Payable 9,600.00 Common Stock 21,000.00 Retained Earnings 63,400.00 4 Insert Table Chart Trial Balance 20 21 22 23 24 25 Adjustment data 20 1.Accrued salaries and wages payable were $850 at the end of the month 27 2 Depreciation was $460 per month D 4,200.00 7,100.00 2.100.00 1,200.00 18,000,00 30,800.00 63,400.00 Text Shape Media Comment 28 3. Supplies on hand were $1,300 20 4. One month of interest income should be recorded on the $6000 Note Receivable at an APR of 5% 30 5 Services were preformed to satisfy $1200 of the unearned revenue 6 December's prepaid rent has been used (annual amount was $9600 as recorded in Prepaid Rent). Adjusting Entries E F Financial Statements G H 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, r/30 15 Purchased supplies for cash $1,800 18 Sold merchandise on account $14,000, terms 3/10, n/30. The cost of the merchandise sold was $7.500. 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. 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 to Collabora (32) 33 54 Required as Complete each tab of this Excel Worksheet: General Journal (all transactions in December), map into T Accounts (add any if necessary), prepare Tral Balance 30 prepare the adjusting entries (1-6 above), Prepare Financial Statements in good form (multi-step income statement, statement of retained earings, balance sheet) 37 prepare the closing entries, prepare the required ratio computations 0 Ro He Wie 2 3 0 11 2 3 4 25 26 27 28 29 30 31 32 33 34 35 36 37 Before Adj 12/31/2021 38 39 40 41 42 43 After Adj. 12/31/2021 44 45 Before Adj 12/31/2021 After Adj. 12/31/2021 Before Adj 12/31/2021 Before Adj 12/31/2021 After Adj. 12/31/2021 Before Adj 12/31/2021 After Adj. 12/31/2021 Dec 1 $5,400 Dec 18 $14,000 OLICE Dec 1 $6,000 Dec 31 $25 A Dec 1 $1,500 Dec 15 $1,800 DIG00000 Accounts Receivable Dec 8 $1,800 Dec 27 $14,000 End Bal $3,600 Notes Receivable Supplies End Bal $6,000 Interest Receivable End Bal $25 Dec 31 $2,000 D End Bal $1,300 E 3 4 35 36 Before Adj 37 38 39 90 91 92 93 94 95 96 Before Adj 97 (98 99 100 101 103 103 104 108 107 108 100Before Adj 100 110 111 112 113 After Adj. 12/31/2021 114 115 117 118 After Adj. 12/31/2021 119 After Adj. 12/31/2021 Before Adj After Adj. 12/31/2021 Accumulated Depreciation-Equipment Dec 7 $300 Dec 23 $7,500 End Bal $10,000 Dec 1 $2,100 Dec 28 $500 End Bal $1,400 Dec 1 $1,200 Dec 6 $1,200 End Bal $850 12/31 Accounts Payable 12/31 12/31 Dec 1 $7,100 Unearned Service Revenue Dec 31 $1,200 Dec 13 $7,500 Dec 29 $3,200 12/31 Salaries and Wages Payable Dec 31 $850 * 34 Dec 1 $18,000 Before Adj End Bal $18,000 18 19 10 31 32 Before Adj 33 135 After Adj. 12/31/2021 136 137 138 130 140 Before Adj 141 142 143 144 After Adj. 12/31/2021 145 140 147 14 Before Adj 148 150 161 154 After Adj. 12/31/2021 156 Tie 167 358 After Adj. 12/31/2021 Before Adj 12/31/2021 After Adj. 12/21/2021 Text Dec 1 $30,800 End Bal $30,800 Dec 10 $9,100 Dec 18 $14,000 Dec 6 $2,200 Common Stock 12/31 Retained Earnings 12/31 Service Revenue 12/31 Sales Revenue 12/31 Dec 31 $1,200 End Bal $24,300 A Sales Returns and Allowances * 160 101 162 163 164 165 106 167 171 108 360 Before Adj 170 172 173 Before Adj 12/31/2021 174 125 176 177 After Adj. 12/31/2021 178 179 180 181 182 184 165 186 108 100 Before Adj 12/31/2021 140 102 After Adj. 12/31/2021 164 Before Adj 12/31/2021 After Adj. 12/31/2021 Dec 27 $420 Before Adj 12/31/2021 Text Dec 31 $25 End Ball $25 Dec 10 $5,000 Dec 18 $7,500 Dec 31 $460 Dec 31 $2,000 End Bal $2,000 Dec 6 $2,200 Sales Discounts End Bal $420 Interest Revenue 12/31 Cost of Goods Sold End Bal $12,500 Depreciation Expense End Bal $460 Supplies Expense F 90 99 200 201 202 203 204 205 200 207 208 200 210 211 212 213 A Before Adj 12/31/2021 214 After Adj. 12/31/2021 Before Adj 12/31/2021 After Adj. 12/31/2021 B Dec 6 $1,000 Dec 20 $2,400 Dec 31 $850 Dec 31 $460 End Bal $800 C Salaries and Wages Expense D End Bal $4,250 Rent Expense m 15 16 125% Cash Accounts Receivable Note Receivable Zoom 17 Problem 18 A Inventory Supplies Prepaid Rent Equipment 19 Add Category General Journal B ACRS I On December 1, 2022, Divine Distributing Company had the following account balances Debit Credit T Accounts C 5 1 During December, the company completed the following transactions. 2 Dec 13 14 Uneamed Service Revenue 9.200.00 5,400.00 Accumulated Depreciation Equipment 6.000.00 Accounts Payable 10.700.00 1,500.00 Salaries and Wages Payable 9,600.00 Common Stock 21,000.00 Retained Earnings 63,400.00 4 Insert Table Chart Trial Balance 20 21 22 23 24 25 Adjustment data 20 1.Accrued salaries and wages payable were $850 at the end of the month 27 2 Depreciation was $460 per month D 4,200.00 7,100.00 2.100.00 1,200.00 18,000,00 30,800.00 63,400.00 Text Shape Media Comment 28 3. Supplies on hand were $1,300 20 4. One month of interest income should be recorded on the $6000 Note Receivable at an APR of 5% 30 5 Services were preformed to satisfy $1200 of the unearned revenue 6 December's prepaid rent has been used (annual amount was $9600 as recorded in Prepaid Rent). Adjusting Entries E F Financial Statements G H 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, r/30 15 Purchased supplies for cash $1,800 18 Sold merchandise on account $14,000, terms 3/10, n/30. The cost of the merchandise sold was $7.500. 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. 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 to Collabora (32) 33 54 Required as Complete each tab of this Excel Worksheet: General Journal (all transactions in December), map into T Accounts (add any if necessary), prepare Tral Balance 30 prepare the adjusting entries (1-6 above), Prepare Financial Statements in good form (multi-step income statement, statement of retained earings, balance sheet) 37 prepare the closing entries, prepare the required ratio computations 0 Ro He Wie 2 3 0 11 2 3 4 25 26 27 28 29 30 31 32 33 34 35 36 37 Before Adj 12/31/2021 38 39 40 41 42 43 After Adj. 12/31/2021 44 45 Before Adj 12/31/2021 After Adj. 12/31/2021 Before Adj 12/31/2021 Before Adj 12/31/2021 After Adj. 12/31/2021 Before Adj 12/31/2021 After Adj. 12/31/2021 Dec 1 $5,400 Dec 18 $14,000 OLICE Dec 1 $6,000 Dec 31 $25 A Dec 1 $1,500 Dec 15 $1,800 DIG00000 Accounts Receivable Dec 8 $1,800 Dec 27 $14,000 End Bal $3,600 Notes Receivable Supplies End Bal $6,000 Interest Receivable End Bal $25 Dec 31 $2,000 D End Bal $1,300 E 3 4 35 36 Before Adj 37 38 39 90 91 92 93 94 95 96 Before Adj 97 (98 99 100 101 103 103 104 108 107 108 100Before Adj 100 110 111 112 113 After Adj. 12/31/2021 114 115 117 118 After Adj. 12/31/2021 119 After Adj. 12/31/2021 Before Adj After Adj. 12/31/2021 Accumulated Depreciation-Equipment Dec 7 $300 Dec 23 $7,500 End Bal $10,000 Dec 1 $2,100 Dec 28 $500 End Bal $1,400 Dec 1 $1,200 Dec 6 $1,200 End Bal $850 12/31 Accounts Payable 12/31 12/31 Dec 1 $7,100 Unearned Service Revenue Dec 31 $1,200 Dec 13 $7,500 Dec 29 $3,200 12/31 Salaries and Wages Payable Dec 31 $850 * 34 Dec 1 $18,000 Before Adj End Bal $18,000 18 19 10 31 32 Before Adj 33 135 After Adj. 12/31/2021 136 137 138 130 140 Before Adj 141 142 143 144 After Adj. 12/31/2021 145 140 147 14 Before Adj 148 150 161 154 After Adj. 12/31/2021 156 Tie 167 358 After Adj. 12/31/2021 Before Adj 12/31/2021 After Adj. 12/21/2021 Text Dec 1 $30,800 End Bal $30,800 Dec 10 $9,100 Dec 18 $14,000 Dec 6 $2,200 Common Stock 12/31 Retained Earnings 12/31 Service Revenue 12/31 Sales Revenue 12/31 Dec 31 $1,200 End Bal $24,300 A Sales Returns and Allowances * 160 101 162 163 164 165 106 167 171 108 360 Before Adj 170 172 173 Before Adj 12/31/2021 174 125 176 177 After Adj. 12/31/2021 178 179 180 181 182 184 165 186 108 100 Before Adj 12/31/2021 140 102 After Adj. 12/31/2021 164 Before Adj 12/31/2021 After Adj. 12/31/2021 Dec 27 $420 Before Adj 12/31/2021 Text Dec 31 $25 End Ball $25 Dec 10 $5,000 Dec 18 $7,500 Dec 31 $460 Dec 31 $2,000 End Bal $2,000 Dec 6 $2,200 Sales Discounts End Bal $420 Interest Revenue 12/31 Cost of Goods Sold End Bal $12,500 Depreciation Expense End Bal $460 Supplies Expense F 90 99 200 201 202 203 204 205 200 207 208 200 210 211 212 213 A Before Adj 12/31/2021 214 After Adj. 12/31/2021 Before Adj 12/31/2021 After Adj. 12/31/2021 B Dec 6 $1,000 Dec 20 $2,400 Dec 31 $850 Dec 31 $460 End Bal $800 C Salaries and Wages Expense D End Bal $4,250 Rent Expense m