Assignment requirements: a. Discuss the role of financial technologies (FinTechs) in financial services. (This should be done 'Word' document more than 200 words). using 25% with no b. Open a new Excel spreadsheet and prepare a worksheet named 'Data' that displays the above given data and calculates the following for each quarter and for the whole year: e. 1- Cost of goods sold. 2- Gross profit. 3- Gross profit margin. 4- Net operating profit. 5- Net operating profit margin. 6- Opening balance (b/d) and closing balance (c/d) of capital account. 20% c. Relying on the data in 'Data Worksheet' and the use of named data range and look up table approach, create a new worksheet named 'Report' that will report the quarterly budgeted financial statements in the way that the budgeted financial statements of a certain quarter will be displayed by the worksheet when this quarter is selected (requested) by the user. Note: Budgeted financial statements are the income statement and statement of financial position. 25% d. Create a worksheet named 'Results' and create appropriate charts that will show quarterly sales, gross profits and net profits, dependent upon the financial report selected 15% Create a worksheet named 'Bank' and create an appropriate chart that will show quarterly closing bank balances (for each quarter) 15% Assignment Total = 100%

Fig: 1