60.1K

Verified Solution

Link Copied!

Required: Complete each tab of the excel worksheet.

- General Journal

- T Accounts in: Cash, Acc. Rec., Notes Rec., Interest Rec., Supplies, Inventory, Prepaid Insurance, Prepaid Rent.

(Accumulated Depreciation T Accounts): Equipment, Accounts Payable, Unearned Service Rev, Salaries and wages payable, common stock, retained earnings, income summary, service revenue, sales revenue, sales return and allowances, sales discounts, interest revenue, COGS, Depreciation expense, supplies expense, salaries and wages expense, rent expense, advertising expense.

- Trial Balances before & after adjustment

- General Journal with adjusted entries

- Financial Statements: Income statement (multi step format) for month ended December 31, 2022, retained earnings statement for month ended December 31, 2022, balance sheet for month of December 31

- General Journal: Post closing entries

- Post closing trial balance

thank you so much!

5,250 ACR5.1 On December 1, 2022, Divine Distributing Company had the following account balances. Debit Credit Cash 8,700.00 Accounts Receivable 4,600.00 Accumulated Depreciation Equipment 4,400 Note Receivable 5,000.00 Accounts Payable Inventory 12,250.00 Unearned Service Revenue 1500 Supplies 1,200.00 Salaries and Wages Payable 1,000 Prepaid Rent 7,200.00 Common Stock 17,000 Equipment 22,000.00 Retained Earnings 31,800 60,950.00 $ 60,950 During December, the company completed the following transactions. Dec. 6 Paid $1,800 for salaries and wages due employees, of which $800 is for December and $1,000 was accrued in November to salaries and wages payable. 7 $500 of merchandise was returned from a November 30, 2022 sale on account 8 Received $2,000 cash from customers in payment of account (no discount allowed). 10 Sold merchandise for cash $8,500. The cost of the merchandise sold was $4,300. 13 Purchased merchandise on account from Hecht Co. $9,000, terms 2/10, n/30. 15 Purchased supplies for cash $2,000. 18 Sold merchandise on account $15,000, terms 3/10, n/30. The cost of the merchandise sold was $8,000. 20 Paid salaries and wages $2,800. 21 Paid $1,800 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 $980 from customers for services to be preformed in the future 29 Purchase Equipment on account for $2500 Adjustment data: 1. Accrued salaries and wages payable were $700. 2. Depreciation was $400 per month. 3. Supplies on hand were $1,500 4. One month of interest income should be recorded on the $5000 Note Receivable at an APR of 6% 5. Services were preformed to satisfy $900 of the unearned revenue 6. December's prepaid rent has been used (annual amount was $7200 as recorded in Prepaid Rent). Required: Complete each tab of this Excel Worksheet: General Journal (all transactions in December), map into T Accounts (add any if necessary), prepare Trial Balance prepare the adjusting entries (1-6 above), Prepare Financial Statements in good form (multi-step income statement, statement of retained earnings, balance sheet) prepare the closing entries, prepare the closing trial balance

Answer & Explanation Solved by verified expert

See Answer