AutoSave Insert Draw Home Page Layout Data Formulas Review net income sheet 2 hw NP (2)-2 View Tell me General Conditional Formatting Format as Table KE % 48-28 Call Styles Calibri (Body) = = ap 11 RT Paste I go A > 2015 17000 N20 ex A D E G H L M 1 01: The following is the Revenue of leading retail outlets in Riyadh in the last 4 YEARS Cost for each year increases by 5% of the previous yox a COST previous year cos (15) SALES REVENUE increases by 5 2017 2016 2014 2012 2016 2015 2014 HyperPanda 20000 18000 17000 16000 HyperPanda 2 ? 7 13000 Otham 19000 14000 11450 13000 ? Otham 7 ? 9000 Carre our 21000 19000 15500 Carrefour 2 2 ? 8000 11 Lulu 22000 19000 14500 13000 Lula 2 2 10500 12 Nesto 16000 13000 12000 10000 Neto ? 2 6500 13 Danube 21000 23000 20000 19000 Danube ? 14000 2 14 Nibras 15000 13000 11000 10000 Nibras ? 7 7000 15 Tamimi 15500 17000 2 Tamimi 14000 17 18000 11000 16 21000 20000 Njazeera 19000 18000 7 Aljazeera ? 11600 17 Almadina 22000 20000 19000 18000 ? Almadina 15000 18 TOTAL SALES 197000 374000 144950 158000 TOTAL COST 2 2 105600 19 20 instructions: CREATE FORMULAS TO COMPLETE THE GIVEN TASK 21 a. Complete the cost table and calculate the net income of the retail outlets in every month 12 2) 22 b. Compute the compounded annual growth of netincome of the retail outlets in Riyadh in the past 4 YEAR? USE GEOMEAN function. (1-1) 23 USE APPROPRIATE EXCEL FUNCTIONS TO COMPUTE THE GEOMEAN 24 HyperPanda Othaim Carrefour Lulu Nesto Danube Nabs Tamiri Alja Almadina STUDENT DETAILS Questions + Insert Home Draw Page Layout Formulas Data View Review Tell me Calibri (Body) 11 - A A General Intert [ , Conditional Formatting Formatas Table Call Styles 2 Date Paste B I y a.A- > % t Format AE20 A Xfx K L M O 5 T u V w 1 a car increases by 5% of the previous year 4 COST previous year cos (15) 5 increases by NETINCOME Revenue Cost of Net income for sach 2017 2016 2015 2014 2 HyperPanda Othai Carrefour Lulu 10500 2 2017 2016 2014 13000 9000 102 B000 112 7 7 12 6500 14000 142 7000 15 11000 162 11600 17.2 15000 18 105600 19 20 21 0.21 22 YEAR?USE GEOMEAN function (1+1) 23 HyperPand Othaim Carretour Lu > Neste 2 Danube 2 3 Tamimi 2 NP be 1 YEAR TO YEAR CHANGEinn 2015 2014 ? 7 2 2 > ? ? 2 7 2 7 7 2 7 2 2 2 2 Danube Nebras Tamimi Njara Almadina 28 STUDENT DETAILS Questions + RA 21 otv