Please do as much as possible! Do not worry about excel formulas. I put up the T - Ledger template so you can see what categories I need accounted for. Thank you!

Instructions: 1. 2. 3 4. Prepare adjusting entries and POST to t-accounts. Use the balance in the trial balance as the ledger balances. Prepare an adjusted trial balance. Prepare closing entries and POST to ledger (you may use the ledger from #1). Prepare a post-closing trial balance. Credit BLUE Company Adjusting and Closing Entries BLUE Company Trial Balance June 30, 2021 Debit Cash $7,500 Accounts receivable 4.300 Supplies 1,500 Prepaid Insurance 1,260 Equipment 15,000 Accounts payable Unearned service revenue Common stock Service revenue Salaries & wages expense 6,300 Rent expense 2.400 $38,260 Additional requirements: Add accounts to the trial balancelledgers as needed. Use FORMULAS to calculate totals. 2.510 4,250 21,000 10,500 $38,260 Other accounts: Accumulated Depreciation - Equipment Salaries and Wages Payable Depreciation Expense Insurance Expense Utilities Expense Supplies Expense Retained Earnings Income Summary BLUE Company began operations on June 1, 2021. Use the following data to prepare adjusting entries: 1. A utility bill for $175 has not been recorded and will not be paid until July. 2. The insurance policy is for one year 3. Supplies on hand June 30 total $840. 4. $2,700 of the unearned service revenue was performed by the end of the month. 5. Salaries of $875 were accrued at the end of the month. 6. The equipment has a 5-year life; depreciation expense should be recorded for the month of June. Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation Equipment Accounts Payable Unearned Service Revenue Salaries and Wages Payable Common Stock Retained Earnings Income Summary Service Revenue Salaries & Wages Expense Rent Expense Depreciation Expense Insurance Expense Utilities Expense Supplies Expense