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 year 2022: Feb.2.2022. M \& S received $36,000 from customers in advance for services to be provided until Jan.31.2023. March.5.2022. M \& S purchased $9,000 supplies and paid the amount in cash. May.15.2022. M \& S performed $6,000 of advertising services on account. June.20. 2022, M \& S purchased $60,000 building and signed a 9%,18 months, 60,000 note. sep.20.2022. M \& S paid $9,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 $22,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 $600 of supplies on hand. - On Dec.31.2022, it was found that $32,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,000 each month, Depreciation on building is $2,500 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