hello can you please assist with this

QUESTION 1 The south African government had election during the last thirteen months. New administration came with new national department, Department of Air Travel. The purpose of the new department is to regulate airlines. It was separated from the National Department of Transport which has just been given a new responsibility to regulate the taxi industry. You were appointed as a Director within Financial Management Directorate of the established department. One of your responsibilities is preparation of financial statements. The following information is available to you to prepare the below required statement and notes as part of annual financial statements. 3.1. Design a template using Microsoft Excel to prepare the annual financial statements. Your Template should include: 3.1.1. Name of each sheet from your workbook 3.1.2. formulas and links. 3.1.3. Fill colour to indicate areas which are editable 3.2. Compile a statement of financial performance of Department of Air Travel for financial year ended 31 March 2022. 3.3. Notes to the statement of financial performance 3.3.1. Annual appropriation 3.3.2. Departmental revenue 3.3.2.1. Sales of goods and services other than capital assets 3.3.2.2. Fines, penalties, and forfeits 3.3.2.3. Interest and dividends 3.3.3. Compensation of employees 3.3.3.1. Salaries and wages 3.3.3.2. Social contribution 3.3.4. Goods and services 3.3.5. Transfers and subsidies Trial Ralanre of Monartment of ir Travol for the voar ondod 31 March 2023 B. Additional Information 1. All the appropriated funds to the department were received. 2. The remaining balance of voted funds/Annual appropriation to be surrendered was R109 154670. 3. The remaining aid assistance was R100 000. 4. There was no own revenue included in Annual appropriation. 5. The Department currently has four Programmes i.e. Administration, Operational, Aviation and Corporate services. The department's votel appropriation is allocated in the following ratio: - Administration 50% - Operational 20\% - Aviation 20% - Corporate services 10% QUESTION 1 The south African government had election during the last thirteen months. New administration came with new national department, Department of Air Travel. The purpose of the new department is to regulate airlines. It was separated from the National Department of Transport which has just been given a new responsibility to regulate the taxi industry. You were appointed as a Director within Financial Management Directorate of the established department. One of your responsibilities is preparation of financial statements. The following information is available to you to prepare the below required statement and notes as part of annual financial statements. 3.1. Design a template using Microsoft Excel to prepare the annual financial statements. Your Template should include: 3.1.1. Name of each sheet from your workbook 3.1.2. formulas and links. 3.1.3. Fill colour to indicate areas which are editable 3.2. Compile a statement of financial performance of Department of Air Travel for financial year ended 31 March 2022. 3.3. Notes to the statement of financial performance 3.3.1. Annual appropriation 3.3.2. Departmental revenue 3.3.2.1. Sales of goods and services other than capital assets 3.3.2.2. Fines, penalties, and forfeits 3.3.2.3. Interest and dividends 3.3.3. Compensation of employees 3.3.3.1. Salaries and wages 3.3.3.2. Social contribution 3.3.4. Goods and services 3.3.5. Transfers and subsidies Trial Ralanre of Monartment of ir Travol for the voar ondod 31 March 2023 B. Additional Information 1. All the appropriated funds to the department were received. 2. The remaining balance of voted funds/Annual appropriation to be surrendered was R109 154670. 3. The remaining aid assistance was R100 000. 4. There was no own revenue included in Annual appropriation. 5. The Department currently has four Programmes i.e. Administration, Operational, Aviation and Corporate services. The department's votel appropriation is allocated in the following ratio: - Administration 50% - Operational 20\% - Aviation 20% - Corporate services 10%