I am workimg in Excel and its giving me red for wrong answers. please help. i do not want the same thing that has been posted to simlar work already and need someone new to help me please. chegg if your reading this people are posting old work for new answers

E F D G A B On December 1 of the current year, the general ledger of Mossland Company, which was 1 Incoporated this year, includes the following account balances: 2 mna 13 13 Debit Credit Cash 22,600 Accounts Receivable 6,000 Supplies 3,900 Land 58,000 Accounts Payable 4,000 88,500 Common Stock 9 10 Dividends 2,000 11 Totals 92,500 92,500 12 1) During December, the following transactions occur, analyze each on the analysis tab. 14 December 1 Purchased equipment for $20,000 by signing a five year note payable. 15 December 2 Purchase rental space for one year in advance, $8,400 ($700/month). 16 December 9 Purchase additional supplies on account, $4,300. 17 December Provide services to customers on account, $26,300. December 17 Receive cash in advance from customers for services to be provided in the 18 future, $4,500 19 December 20 Pay cash for salarios, $12,300. December 22 Receive cash on accounts receivable, $24,900. 21 December 29 Pay cash on accounts payable, $4,800. 2) At the end of December, the following information was supplied to you. Analyze the 23 transactions on the analysis tab. 24 25 December 31 Rent for the month of December has expired. 26 December 31 Supplies remaining on hand at the end of the month totaled $2,400. 27 December 31 By the end of December, 15% of the deferred revenue has been earned. 28 December Salaries earned but not yet paid as of the end of the month totalled $1,030. 29 December 31 Annual depreciation on the equipment is $1,200. December 31 The interest rate on the December 1 note is 12%. The annual interest totals 30 $2,400. 31 323) Post all transactions to the ledger on the ledger tab. 334) Created an adjusted trial balance. 34 5) Create the financial statements. 356) Record the closing entries on the closing entries tab (do not post to the ledger) 36 37 20 22 31 38 39 40 H43 M N C D E F H G Income Statement Journal XV Jx B C Balance Sheet L 12/1/21 20.000 20,000 Cash Flow CF CA SE NI Account Equipment Notes Payable DR 20,000 20,000 8,400 12223 Prepaid Rent Cash 18.400) 8.400 8,400 4,300 12/921 4,300 Supplies Accounts Payable 4,300 4,300 26,300 12/13/21 26,300 Accounts Receivable Service Revenue 26.300 26,300 26,300 26,300 12/1723 4.500 4,500 Cash Unearned revenue 4,500 4,500 19/20/23 12.100 (12,300) (12,300 12,300 Salaries Exspense Cash (12,3001 12.300 24,900 1 2 Date 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 13 19 20 201 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 12/22/21 24.900 24.900 Cash Accounts recievable 24,900 12/29/21 4,800 (6,800) Accounts Payable Cash (4.800) 1 4.800 12/31/21 1700) 700 700) 700 Rent Expense Prepaid Rent 7000 700 12/31/21 11.900) 1,900 (1.900 5,800 11.300) Supplies Carpense Supplies 5,800 12/31/21 16757 675 Unearned Revenue Service Revenue 675 675 675 675 12/0123 11,0301 1.030 01.030 1.030 1030 1.030 Sairies pense Salaries payable Depreciation a pense Accumulated Depreciation 12/33/21 (100) 100 11001 100 1100) 100 17/31/21 200 200 1200 Interest expense Interest payable 200 200 200 44 45 Total 46 47 35,300 24.555 10,745 16,230 10.745 114,005 114,005 4 Instructions A Analysis Ledger Trial Balance Financial Statements Closing Entries + Ready C D A Supplies Cash Accounts Receivable Prepaid Rent 2 5 6 7 7400 7.700 2.400 26.500 Accounts Payable Accumulated Depreciation Land Equipment 20.000 ment 1,500 100 58000 20.000 Salaries Payable Delemeden Interest Payable Notes Payable A25 200 20.000 1.030 Service Revenge Common Stock Dividends Retained Camine 9 10 11 12 13 14 15 16 17 13 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 35 37 30 39 40 41 42 41 44 45 38.500 2000 2975 Rent Expense Depreciation Depan Interesten 13.110 7200 5.800 Supplies Open 47 200 50 51 Instructions Analysis Ledger Trial Balance Financial Statements Clo Ready