Online assignment 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 quarter of the year 2022: Feb.2.2022. M \& S received $39,000 from customers in advance for services to be provided until Jan.31.2022. March.5.2022. M \& S purchased \$8,000 supplies and paid the amount in cash. may.15.2022. M \& S performed S5,000 of advertising services on account. June.20. 2022. M \& S purchased $50,000 building and signed a 12%,18 months, 50,000 note. Sep.20.2022. M \& S paid S12,000 in advance for insurance policy. This insurance policy will cover one year starting from sep, 1.2022. Nov.25.2022. M \& S paid its employees $44,000 for salaries and wages for the first eleven months of the year. You also know the following information regarding M\&S advertising agency: - The company prepares its financial statements annually. - On Dec.31.2022, A count of supplies had shown $700 of supplies on hand. - On Dec.31.2022, it was found that \$43,000 services that were performed on account during the previous 12 months are not recorded. - On Dec.31.2022, employees worked for one month that were not recorded nor paid (salaries are the same each month). - Depreciation on equipment is $1,200 each month, Depreciation on building is $2,300 each month. - Each month the company performs the same amount of its services obligation. Required: (1) Prepare the Trial balance on Dec.31.2022 for M\&S advertising agency (2) Prepare the adjusted trial balance on Dec.31.2022 for M&S advertising agency (3) Prepare the income statement for the year ended on Dec.31.2022 for M\&S advertising agency (4) Prepare the Retained earnings statement for the year ended on Dec.31.2022 for M\&S advertising agency (5) Prepare the balance sheet at Dec.31.2022 for M\&S Advertising agency Note: all answers should be submitted through one excel file