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 month

Jan.2022:

Jan.2.2022. M & S received $24,000 from customers in advance

for services to be provided until the end of the year.

Jan.5.2022. M & S purchased $11,000 supplies and paid the

amount in cash.

Jan. 10.2022. M & S performed $7,000 of advertising services on account. Jan. 1. 2022. M & S purchased $70,200 building and signed a

10%, 18 months, 70,200 note. Jan.25.2022. M & S paid $15,000 in advance for insurance policy. This insurance policy will cover one year starting from

feb. 1.2022.

Jan.28.2022. M & S paid its employees $28,000 for salaries and wages. You also know the following information regarding M&S

advertising agency: -The company prepares its financial statements monthly. - On Jan.31.2022, A count of supplies had shown $1,100 of

supplies on hand. - On Jan.31.2022, it was found that $30,300 services that were

performed on account during the previous month are not recorded.

- Jan.31.2022 is a Tuesday, employees are paid $7,000 each

Thursday on a 5 working days week. - Depreciation on equipment is 13,200 per year, Depreciation on building is $25,200 per year.

-Each month the company performs the same amount of its

services obligation.

Required:

(1) Prepare the Trial balance on Jan.31.2022 for M&S advertising agency (2) Prepare the adjusted trial balance on Jan.31.2022 for M&S

advertising agency (3) Prepare the income statement for the first month of 2022 for M&S advertising agency

(4) Prepare the Retained earnings statement for the first month of 2022 for M&S advertising agency (5) Prepare the balance sheet at Jan.31.2022 for M&S

Advertising agency Note: all answers should be submitted through one excel file.