M&S advertising agency had the following adjusted account balances on Dec.31.2021: Cash 50,000; Account receivable 1,500; supplies 2,500; equipment 21,000 Accumulated depreciation - equipment 3,000; account payable 22,000; share capital ordinary 20,000; Retained earnings 30,000.

The following transactions occurred during the first 6 months of the year 2022

: Jan.2.2022. M & S received $30,000 from customers in advance for services to be provided until the end of the year.

Jan.5.2022. M & S purchased $10,000 supplies and paid the amount in cash

Feb.15.2022. M & S performed $7,000 of advertising services on account.

March.1. 2022. M & S purchased $70,200 building and signed a 12%, 18 months, 70,200 note

. Apr. 20.2022. M & S paid $15,000 in advance for insurance policy. This insurance policy will cover one year starting from Apr.1.2022.

May.25.2022. M & S paid its employees $45,000 for salaries and wages for the first five months of the year.

You also know the following information regarding M&S advertising agency:

- The company prepares its financial statements semi-annually.

- On June.30.2022, A count of supplies had shown $300 of supplies on hand

- On June. 30.2022, it was found that $40,100 services that were performed on account during the previous 6 months are not recorded.

On June.30.2022, employees worked for one month that were not recorded nor paid (salaries are the same each month).

Depreciation on equipment is $1,300 each month, Depreciation on building is $2,400 each month.

- Each month the company performs the same amount of its services obligation.

Required:

(1) Prepare the Trial balance on June.30.2022 for M&S advertising agency

(2) Prepare the adjusted trial balance on June.30.2022 for M&S advertising agency

(3) Prepare the income statement for the semi-annual period ending on June. 30.2022 for M&S advertising agency

(4) Prepare the Retained earnings statement for the semiannual period ending on June.30.2022 for M&S advertising agency

(5) Prepare the balance sheet at June.30.2022 for M&S Advertising agency

all answ Id be submitted through one excel file