Accounting on Excel Excel file link: https://mega.nz/file/EnEg3AaA#5-6cBCy9z2SR57eCcpHeoKoQJ-9fbNunV-xvDxEETLA

On December 1 of the current year, the general ledger of Mossland Company, which was incoporated this year, includes the following account balances: Debit Credit Cash 22,600 Accounts Receivable 6,000 Supplies 3,900 Land 58,000 Accounts Payable 4,000 Common Stock 88,500 Dividends 2,000 Totals 92,500 92,500 1) During December, the following transactions occur, analyze each on the analysis tab. December 1 Purchased equipment for $20,000 by signing a five year note payable. December 2 Purchase rental space for one year in advance, $8,400 ($700/month). December Purchase additional supplies on account, $4,300. December 13 Provide services to customers on account, $26,300. December 17 Receive cash in advance from customers for services to be provided in the future, $4,500. December 20 Pay cash for salaries, $12,300. December 22 Receive cash on accounts receivable, $24,900. December 29 Pay cash on accounts payable, $4,800. 2) At the end of December, the following information was supplied to you. Analyze the transactions on the analysis tab. December 31 Rent for the month of December has expired. December 31 Supplies remaining on hand at the end of the month totaled $2,400. December 31 By the end of December, 15% of the deferred revenue has been earned. December 31 Salaries earned but not yet paid as of the end of the month totalled $1,030. 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 $2,400. 3) Post all transactions to the ledger on the ledger tab. 4) Created an adjusted trial balance. 5) Create the financial statements. 6) Record the closing entries on the closing entries tab (do not post to the ledger)Balance Sheet Income Statement Cash Flow Journal Date A SE R NI CF Account DR CR 12/1/2021 12/2/2021 12/9/2021 12/13/2021 12/17/2021 12/20/2021 12/22/2021 12/29/2021 12/31/2021 12/31/2021 12/31/2021 12/31/2021 12/31/2021 12/31/2021 TotalCash Accounts Receivable Prepaid Rent Supplies Land Equipment Accumulated Depreciation Accounts Payable Deferred Revenue Salaries Payable Interest Payable Notes Payable Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Depreciation Expense Interest Expense Supplies ExpenseMossland Company Trial Balance December 31, 2021 Accounts Debit Credit Cash Accounts Receivable Prepaid Rent Supplies Land Equipment Accumulated Depreciation Accounts Payable Deferred Revenue Salaries Payable Interest Payable Notes Payable Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Depreciation Expense Interest Expense Supplies Expense TotalsMossland Company Mossland Company Income Statement Statement of Stockholders' Equity For the year ended December 31, 2021 For the year ended December 31, 2021 Common Stock Retained Earnings Total Balance, January 1 Plus: Issuance of Stock Plus: Net Income Less: Dividends Balance, December 31 Mossland Company Balance Sheet December 31, 2021 Assets: Liabilities: Net Income Current: Current: Total Current Assets: Total Current Liabilities: Property, Plant & Equipment: Long-term Liabilities: Total Liabilities: Stockholders' Equity: Net PP&E Total Assets Total Liabilities & SE:\f