Anne 01 Excel Problem Financial Accounting) Excd Search 11 Wyull ZP 1 al X Stare Page Layout P Calibri ncorants Formulas Data M 11AA 11 Review R View Help W Wrap Text Iege a Cala & Gerald Bad Good File Home Insert F TH N X CUI Puhe Copy Formater Clipboard 2. Auringum - - Normal Cardinal Format Neutral Formatting Table Insert Delale Format 27 0 0 B! $ - % 9233 Calculation Sanctivity Clear Sort & Find a Filter Select Editing Analyse Data Font Alynurent Number Sys Celli Anys Sensitivi H22 4 F H o P R S T U V x Y B c D F 1 M MN 1 ACR5.1 on December 1, 2002, Divine Distributing Company had the following account balances 2 Dobit Credit 3 Cash 8./00.00 4 Accounts Receivable 4.600.00 Accumulated Depreciation-Equipment 4.400 3 Note Receivable 5.000.00 Accounts Payable 5.230 6 Inventory 12,250.00 Pamed Service Revenue 1.500 7 Supplies 1000 1.200.00 Salaries and Wages Payable ch 1.000 & Prepaid Rent 7,200.00 Common Stock 12.000 9 Equipment 22.000,00 Retained Earnings 31.800 10 00,900.00 $50,950 11 Daring December, the company completed the following transactions 12 Dec. Graid $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. eve w 13 7 $600 of merchandise was returned from November 30, 2022 sale on www & & Received $2,000 cash from customers in payment of account (no discount allowed) 13 10 Sold merchandise for cash $9.500. The cost of the merchandise sold was $4,200. 16 1.2 Purchased merchandise on Amount from Hecht C. $9,000, terms 2/10, 1/30. 17 15 Purchased supplies for cash $2.000 18 18 Sold merchandise an account $15.00, terms 3/10, 1/30. The cost of the merchandise sold was $8,000 . 20 Pald salaries and wages $2,800. $2 20 21 Paid $1,900 in advance for next year's annual insurance 21 23 Paid Hecht Co. in full, les discount. 22 27 Received collections in full, less discounts, from customers billed on December 18. 21 28 Received SAR from customers for services to be preformed in the future 29 Purchase Equipment on account for $2500 25 Adjustment data 25 1. Accrued salaries and wages payable were $700. 27 2 Depreciation was $400 per month 78. Supplies anhand were $1.500 29 4. Onc month of interest income should be recorded on the $5000 Notc Rccelvable at an APR of G 30 5. Services were preformed to satisfy $200 of the unlearned revenue 31 6. December's prepaid rent has been used annual amount was $7200 as recorded in Prepaid Rent). 32 33 34 Required: 35 Complete each of this Excel Worksheet: General Journal (all tractions in December), map into accounts (adelany if necessary). prepare Trial Balance es prepare the adjusting entries (1 Gabovel, Prepare Financial Statements in good form multi-step income statement, statement of retained earnings, balance sheet , 37 prepare the closing entries, prepare the closing trial balance Problem General Journal T Accounts Trial Balance Adjusting Entries Financial Statements Post Closing Entries Cicaing Trial Balance Reach 100% Anne 01 Excel Problem Financial Accounting) Excd Search 11 Wyull ZP 1 al X Stare Page Layout P Calibri ncorants Formulas Data M 11AA 11 Review R View Help W Wrap Text Iege a Cala & Gerald Bad Good File Home Insert F TH N X CUI Puhe Copy Formater Clipboard 2. Auringum - - Normal Cardinal Format Neutral Formatting Table Insert Delale Format 27 0 0 B! $ - % 9233 Calculation Sanctivity Clear Sort & Find a Filter Select Editing Analyse Data Font Alynurent Number Sys Celli Anys Sensitivi H22 4 F H o P R S T U V x Y B c D F 1 M MN 1 ACR5.1 on December 1, 2002, Divine Distributing Company had the following account balances 2 Dobit Credit 3 Cash 8./00.00 4 Accounts Receivable 4.600.00 Accumulated Depreciation-Equipment 4.400 3 Note Receivable 5.000.00 Accounts Payable 5.230 6 Inventory 12,250.00 Pamed Service Revenue 1.500 7 Supplies 1000 1.200.00 Salaries and Wages Payable ch 1.000 & Prepaid Rent 7,200.00 Common Stock 12.000 9 Equipment 22.000,00 Retained Earnings 31.800 10 00,900.00 $50,950 11 Daring December, the company completed the following transactions 12 Dec. Graid $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. eve w 13 7 $600 of merchandise was returned from November 30, 2022 sale on www & & Received $2,000 cash from customers in payment of account (no discount allowed) 13 10 Sold merchandise for cash $9.500. The cost of the merchandise sold was $4,200. 16 1.2 Purchased merchandise on Amount from Hecht C. $9,000, terms 2/10, 1/30. 17 15 Purchased supplies for cash $2.000 18 18 Sold merchandise an account $15.00, terms 3/10, 1/30. The cost of the merchandise sold was $8,000 . 20 Pald salaries and wages $2,800. $2 20 21 Paid $1,900 in advance for next year's annual insurance 21 23 Paid Hecht Co. in full, les discount. 22 27 Received collections in full, less discounts, from customers billed on December 18. 21 28 Received SAR from customers for services to be preformed in the future 29 Purchase Equipment on account for $2500 25 Adjustment data 25 1. Accrued salaries and wages payable were $700. 27 2 Depreciation was $400 per month 78. Supplies anhand were $1.500 29 4. Onc month of interest income should be recorded on the $5000 Notc Rccelvable at an APR of G 30 5. Services were preformed to satisfy $200 of the unlearned revenue 31 6. December's prepaid rent has been used annual amount was $7200 as recorded in Prepaid Rent). 32 33 34 Required: 35 Complete each of this Excel Worksheet: General Journal (all tractions in December), map into accounts (adelany if necessary). prepare Trial Balance es prepare the adjusting entries (1 Gabovel, Prepare Financial Statements in good form multi-step income statement, statement of retained earnings, balance sheet , 37 prepare the closing entries, prepare the closing trial balance Problem General Journal T Accounts Trial Balance Adjusting Entries Financial Statements Post Closing Entries Cicaing Trial Balance Reach 100%