need 10 coulmn worksheet and the income statement and adjustments

Start with the following transactional data for the first month of operations for Crystal Clear Cleaning. Crystal Clear Cleaning Chart of Accounts November 1, 2020 Acc. # Cash 101 Accounts Receivable 110 Merchandise Inventory 112 Cleaning Supplies 124 Prepaid Insurance 126 Prepaid Rent 128 Equipment 150 Trucks 154 Accumulated Depreciation 155 Accounts Payable 201 Interest Payable 205 Unearned Revenue 233 Salaries Payable 235 Long-Term Note Payable 251 Common Stock 301 Dividends Paid 302 Retained Earnings 303 Service Revenue 401 Sales Revenue 405 Sales Returns and Allowances 405-1 Sales Discount 405-2 Cost of Goods Sold 500 Sales Commission Expense 505 Depreciation Expense 520 Salaries Expense 523 Interest Expense 533 Insurance Expense 537 Cleaning Supplies Expense 550 Advertising Expense 555 Rent Expense 560 Utilities Expense 569 Income Summary 901

The following transactions occurred during the month of November, 2020: Nov. 1 Andrew Habib contributed $35,000 and a truck, with a market value of $7,000, to the business in exchange for capital. (Common Stock). 2 The business paid $2,000 to Pleasant Properties for the term November 1, 2020 through February, 2021 rent. (Debit Prepaid Rent) 3 Paid $1,800 for a business insurance policy for the term November 1, 2020 through October 31, 2021. (Debit Prepaid Insurance) 4 Purchased cleaning supplies on account, $220. 5 Purchased on account an industrial vacuum cleaner costing $2,000. The invoice is payable November 25. 7 Paid $1,200 for a computer and printer. 9 Performed cleaning services on account in the amount of $3,800. 10 Received $300 for services rendered on November 9. 15 Paid employees, $350. 16 Received $12,000 for a 1-year contract beginning November 16 for cleaning services to be provided. Contract begins November 16, 2020, and ends November 15th, 2021. (Credit Unearned Revenue) 17 Provided cleaning services and received $1,000 cash. 18 Received a utility bill for $250 with a due date of December 4. (Use Accounts Payable) 20 Borrowed $96,000 from bank with interest rate of 9% per year. (LT Note Payable) 21 Received $900 on account for services performed on November 9. 25 Paid $1,000 on account for vacuum cleaner purchased on November 5. 29 Paid $500 for advertising. 30 Habib received dividends of $200 November Adjustments: a. Cleaning supplies on hand at the end of November were $30. b. One months combined depreciation on all depreciable assets was estimated to be $270. c. One months interest expense is $240. d. Calculate the adjustment for Prepaid Rent. e. Calculate the adjustment for Prepaid Insurance. f. Calculate the adjustment for Unearned Revenue.

Required: (Round all numbers to whole dollars)

-Prepare a 10-column worksheet, starting with the November 30, 2020 unadjusted balances (Trial Balance created in Step 3.) Make sure you complete all column totals. Complete each set of columns as needed.

-Journalize and post the Adjusting Journal entries for November, 2020. -Prepare the financial statements for November 30, 2020.

-Journal and post the Closing Journal entries for November, 2020. - Prepare the Post-Closing Trial Balance for November 30, 2020. Check Figures: November Unadjusted Trial Balance: 156,270 November Net Income: 2,850