MIDES Tea Company began operations on January 1, 2022. During the first year of business, the company had the following transactions:

January 18: The owners invested $200,000 (the par value of the stock) into the business and acquired 40,000 shares of common stock in return.

February 1: MIDES bought factory equipment in the amount of $45,000. The company took out a long-term note from the bank to finance the purchase.

February 28: The company paid cash for rent to cover the 12-month period from March 1, 2022, through February 28, 2023, in the amount of $27,000.

March 1: MIDES purchased supplies in the amount of $28,000 on account.

March 22: MIDES recorded sales revenue in the amount of $120,000. Half of this amount was received in cash and half was paid on account. Ignore Cost of Goods Sold.

May 1: MIDES received cash payments to pay off all the customer accounts.

May 29: The company paid wages of $34,000 in cash.

July 12: MIDES recorded sales revenue in the amount of $180,000, all of which was paid in cash. Ignore Cost of Goods Sold.

July 31: MIDES paid $3,200 cash for interest on the note taken out on February 1.

August 8: MIDES paid off the balance owed to a supplier for the purchase made on March 1.

September 1: MIDES paid $6,000 cash for utilities.

October 14: MIDES paid wages of $24,000 in cash.

November 10: Tides recorded sales revenue in the amount of $218,000. One payment of $100,000 was received in cash; the remainder of this balance was sold on account. Ignore Cost of Goods Sold.

December 31: Tides declared and paid a $25,000 dividend.

Prepare an unadjusted trial balance as of December 31

perform the following steps for Tides Tea Company:

Journalize and post adjusting journal entries based on the following additional information (omit explanations)

At December 31, interest in the amount of $2,600 has accrued on the note payable but has not yet been recorded. This amount will be paid on January 31, 2023.

The rent payment made on February 28 was for a 12-month lease covering March 1, 2022, to February 28, 2023.

Straight-line depreciation for the full year should be recorded on the equipment purchased on February 1. The equipment has a 15-year life and no residual value.

A total of $6,000 of supplies remains on hand at the end of the year.

Wage payments in the amount of $62,000 must be accrued at year-end.

On December 14, MIDES received a utilities bill in the amount of $6,200 for the month of November that has not yet been recorded. The amount will be paid in January 2023.

Prepare an adjusted trial balance as of December 31.

Prepare an income statement, and a balance sheet.

Please use this excel format

Account	Unadjusted Trial Balance		Adjustments		Adjusted Trial Balance		Income Statement		Balance Sheet
	Dr.	Cr.	Dr.	Cr.	Dr.	Cr.	Dr.	Cr.	Dr.	Cr.

Cash

Accounts Receivable

Supplies

Prepaid Rent

Equipment

Accumulated Depreciation

Accounts Payable

Wages Payable

Interest Payable

Note Payable

Common Stock

Retained Earnings

Dividends

Sales Revenue

Wage Expense

Utilities Expense

Rent Expense

Supplies Expense

Depreciation Expense

Interest Expense

Subtotals

Net Income

Subtotals

Net Income

Totals