Collect data obtained from the Amadeus report that you have as a spreadsheet. Select the relevant information for your answer. Based on analysis and use of financial ratios look at how revenues and profits have changed through the years, consider the information provided by performance ratios such as ROE, ROCE, ROS and AUR and finally look at the dynamic of the market value of the company.

You should discuss the extent to which the company creates and captures value. Build your argument by offering an interpretation of the different measures of financial performance (this encourages you to avoid just listing numbers).

Key Financial employees Consolidated 27/04/2019 26/04/2014 20/04/2018 TUR 12th 29/04/2017 EUR 12 month 30/04/2016 EUR 21/04/2013 EUR 12 month 29/04/2012 EUR 25/04/2015 TU 12 IFRS - 137541 01/05/2011 EUR 12 12th w 12 m 02/05/2010 EUR 12 movie RS 1.SILS ut 1997 Exchane GRYTUR F 121451 11542 SOCET 1_12079 529,0417 WWV:02 HOSEN Geringue (Tur) PL to pred - Netcomes Cashow To Sharecen inds 1,023,512,133 1704.803,009 19.04.01 1,440 414,230,00 32.100,00 -70,237,020 110,13,331 503,347,00 362,3560 46414354 04365013 100406114 70.146.2 121,363.540 50 09 T75,45,023 7.000,22 12,990,00 19,664,400 607174,420 2.46,102 677.561.370 4105 47.272.97 100,1242939 542642 ) 33,453 60,917.00 44,511650 12.2013 474.122.030 61,500 43,101,423 14,714,303 372,257,271 26.261 300AL 5.252,209 444345 0.00022 336143 226.420334 53.013,555 32,735,090 42.590,171 366,412.521 101,318,50 3,850,00 11,067 7430 12,154,30 113,724, LARI STONE CESTO 23 7 2. 2.50 7.30 . 95 243 16.28 CHE 18 1691 2.82 39.82 ! 2.1 12.00 2016 11.10 3.1 14 HEB ! 1412 >3.14 27 1603 23 1933 HE Garret Mot mai (6) ROEI Wore) ROGEN Y beteret Sony () Number of employee LETE 6051 1001 -3301 50 15.00 70.76 17.30 RA 7032 64.89 LETE 3.2 1. 314 2, 2.32 2220 2,022 1.18 1.2 19 Evolution of a key variable: Operating revenue (Tumover) (2010 - 2019) 1,200,000,000 1,000,000,000 800,000,000 600,000,000 400,000,000 200,000,000 0 EUR 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Global and format Salance sheet Consolated 27/04/2019 EUR 12 IFRS 1 1999 21/04/2018 EUR 12 months EARS 1132 29/04/2017 EUR 12 IFRS 1.1940 30/04/2016 EUR 12 month IFRS 20150 25/04/2015 GUR 12 IFS 28/04/2014 EUR 12 months ES 28/04/2013 EUR 12 m IFRS 1.11743 29/04/2012 EUR 12 IFRS 1.21050 01/05/2011 EUR 12 IFRS 1107 02/05/2010 EUR 12 the IFRS 1.11110 Exchange rate GPYEUR Aneta 1 Intangible fred assets -Tangit Othered assets 155,218.00 59,729,096 01.10.325 30.541940 268,500.035 , 76,414 147,142,373 54,101,84 233.844,158 69,701,051 143.630,00 44.518,701 2:30,124.003 66,002,411 122,263,919 41,3083 213.273,705 71.662.500 99.447,193 40. 164012 279,383.526 56.717,3 35.000 37,265,546 165,289,333 49,2710 75,670,270 40,372,19 175,358.900 50.084,963 78,511.564 46,76.175 125.23.205 33.951,14) 7.3624448 49,519,094 35.295,757 1.25.4 26.021,414 5731,100 >6,067,98 114 104 181325 COEWOO Current - Stock -Debtors the current C & cash when 408,129,014 221,267,351 100,549, 77,241022 490,433,43 161,416,44 104,195,00 141,011,125 14,120, 403,680,165 186,130,23 2010652 119.479,275 7743503 177,100,016 144,107,310 52,166,313 1032494 129,456.359 166.152,77 148414,270 55,019,14 167,719,267 92.002430 165,128,133 94,405,000 31,471,65 131,167.123 10., 158,845,852 68,2974 2,836 61.529439 30,025,193 11,6 37.375,78 54.714,1 RSIVE 72.00 24,32445 107,435 41.785,62 32.799,583 51,220,285 16,080,166 902147016 698,134,99 1:54,534,14 60747420 5YA0443 444511.650 32,257,231 134,100 260412.521 162,164 TOTAL ASSETS Las & Equity Shareholders funds Capital Other startersunds 302,356.500 4.755.1 405,041 653 45,166,95 4,458,00 459.307.646 40,934483 4,854,543 4360541 429.446,109 5,254,524 124,591.57 616 317,229,716 4,858,05 312372.667 25.044,120 4.M 26.114450 VON 226478.330 4,433,155 231,505.979 169,035.732 4483,20 114.332357 115.72497 4.547,175 TILY,805 460,539.733 170,29,033 57.100 4871150 61.74019 58 ECOCOS SESUAI erre Longer Othe-current U U U 65,190,141 0 65,790,041 1,046,125 1711071 445443 1015017 237,435 17.997,352 14,58 10 24,76 19426753 20,219.933 72.30.710 44,471.250 49. 415 1.000,7 42,090,171 1922,70 42,209.195 492236 41,716459 3,412 43,740.299 31.500,00 3.2.184 IT LEVES oto 156109 OSE 85,700.000 121.451 65.467323 COVE 18.158.110 23485 47157.903 11' Carrantie -Loans Creditors Other current 133,157,455 0 72,534,133 o 0 74458331 96.262.330 0 60'S 0 VOITL6 CORE 0 70424.56 TUBE 44,547,314 78,016,43 1,553,546 14,337,500 11.210.27 GES 602 1966:25 CELOT' 27459453 20.79RASO 29.441,03 TOYO TOTAL, SHAREN, FUNDS A LIAB 593.34708 LEF59 NEFES'+99 209 577.426,442 444,511.650 TESTELE 28 260.412.521 CE 291 Mente lines Working cap Net Current Enterprise ZOUT 692 82,405413 01219.768 DE V 065626621 TE POSODE Stat SOTSI EES 238,508,207 BOGOR BET 9.3.278,629 CORSO VO TEST9 90 sast toets 20465, 494,150 31620.119 237 408 422 261,455,760 479.486.360 1.36,736,491 1.353.116.42 1.140,07,135 3,280 2,707 515.656.39 UN TE ELE PER BEZ 2012 wat Promo Costel STOLIVOST OZO 27/04/2019 TUR 12 TO/V/Z 28/04/2018 FUR 12 monte 29/04/2017 EUR 30/04/2016 EUR 01/05/2011 EUR w EUR TUR 29/01/2012 EUR 12 months w 26/04/2013 EUR 17 math IS TI TUR 12 month ins . WICI 4 . GE1 Exchange rate GEPEUR Operating wine STOP! COMIT KE tra's sott ACTIVE 't G'Oro 139.64.734 4. 2474214 161.360.00 Tu na Cists of goods will 449361527 NERET 99552 11,364 Sorcer 178.388.406 166.12.45 117.795448 7.12.30 Grosgrom SOLCHES 158 COLOSS it's 455.670,012 BE OSESSE 223,351,863 1494.25,907 It's Other 653 $11,543,019 47 DNA 402,161,030 332.866,135 3,161 KERE 160.223,65 TCE296 50 213.00 Operating PL-BIT WE 49 71,048,113 103.24741 CONCE 54,300,18 ITECTS PORTE NVIOS Itter Pancen SESOV or 2,0614 47.255 ce GOES 132979 1454 -2.86 697.256 356227 123.0 112079 764,055 128,159 ' - Financial revenue ancil Financial PL PL bore 16.401615 1.507223 19548.3 99.04.2019 -3.402.850 149,881 3,4, 74,195,440 2.841.650 100 406134 ES 825,201 962,836 81.341,01 67,256 14.09.14 356, 227 51.500.5 323,051 63.252.26 2.44 195,701 -192,24 25.555.900 71,000,22 33033855 15.193.211 14,589,14 18,670,454 1.560.97 21,132.11 10.405.064 18.828.000 19.272456 -57,216,100 Taxation Perta 114.239.030 ST 60,0 78.146.300 12,979,700 6272,073 33,763453 43103173 41424355 33.735.89 03.067015 na Estrand other -Er dhe pense ar and other Pred neone BOB ra U 114.239.00 57.600.00 T.16.181 17.923,755 01.172073 33.7633 63.103473 41424255 SSE 13.735.29 03.067,064 $12.450,12 164,144,10 re 13,75 147.15 ARS 12.10 6545, X33X250 R. TEVE 624,25,2 15200 11,722,035 Hay Memeli Export revet Materi Cais done De Amor Research & Development expenses Der Home terstad 19 12.11 93,13.10 36.862100 12.101,447 0,754,640 0.002.011 14:30 43.217.20 na 28,28 27,003433 AN 71411,100 16.43.777 TE 430364 na TU TU 1.56731 340, 3,1 2.30 TV TU 195,00 11.2.5 ' TE 14.01 BOX Cashow Alde EDITOA 1625700 1340337 1.0045 110,331,011 260,082,236 153,671,00 91,600 219,200,400 112,651,826 130,134,931 211.686,34 119.466,747 0,4706 . $1,172,351 22.500,00 . 61.755,741 7.497,43 43.263,111 30.873.575 146.AS. 12,763,419 79,372,96 Global Com 19/01/2015 27/04/2012 EUR 12 months MARS 1.19 20/04/2015 EUR 12 months 29/04/2017 EUR 12 m TUR 10/04/2016 EUR 12 month IFRS 26/04/2014 EUR 12 months IFRS 7102013 EUR 12 months ras 1843 29/04/2012 EUR 12 month 01/05/2011 EUR 12 month IAS 12 months 03/05/2016 EUR 12 month TERE 1.15110 Set the EUR 1 F 2010 1 12010 227) 20.16 1731 15.99 1407 23.18 2704 BEBE TU - 12.36 -23.00 -16. -178 16.6 31.3 na 2035 19:46 1534 1235 10.64 1653 15.00 11 12:31 111 8. 14 16:52 16.31 189 1962 22:34 1933 15.02 71. 61 TEXT 1241 10 Probility rate ROE in before ROCES (N) ROAST WL ROEN) ROCES No come NOR UN Net nome) (4) Gran RIDAM INT MIM Cashow/Operating Enterprise / EBITDA WS SER 10.30 SES 196 HER SITE 2. 1031 1 LIH NEWS 120 40 1624 10 16:02 10 BAY 19 SENS 51:15 1946 TET 0.13 16:14 TERE 1431 9.36 12.06 10.12 114 14) 9.24 153 1026 11.50 19.30 2018 18.20 . 7.19 23.00 39.7 13 14.78 TE 1446 10.00 1042 350 II 6.23 EVER 1722 182 . 141 143 145 1.00 22.67 S45 00195 TU 13. 1.51 100,33 65 20 5.60 5.04 4.56 Operational Naturve It Stock tumo Collection series Ce pod Export revenue / Operating revet () RAD/Opining) 199 2:42 52.46 463 19 20 64.53 430 31 22 NE EE 24 LE CE 3:36 24 14 4696 na LE 5.70 2 41 13.16 12 30.33 35 40.43 37 24.43 CE 03 1995 60.33 20.68 na TY 150 182 1.64 145 CFT SFT 1:20 00195 Dewi Nettsturo Interest one Star are ) Credito Export revenue / Operating reverse() RAD/Operating (9) 5.70 1.51 100.93 457 29 37 4093 RE 5.04 20 550 27 37 33 521 39 20 43 TA 30 36 56.65 24 14 450 13 17 24.48 13.00 6.54 20 33 20.60 SC 464) 3403 9516 ma BE 2.56 27 299 9 2,34 LOO 2.1 280 1.75 258 1.) 7. 28 15 TIT TOT 1.01 304 1. 6.95 714 3 06 49 NES VE 70.0 9.30 30.12 3 LE 5717 14 7127 2.18 1412 12.07 10.30 10.77 2.1 25.80 17.01 Structures Current ratio odyti thachokers uitky a Soyees by) Canno) Premere Proper) Open menpe (1) Catery / Operwing revenue Average cost of an poest.) Shares fonds per month Working proth) Toto per porth DE 33 SC SE SE -10 312 1. 26 CE 900 cett 30 215 20 23 16 DE ore LES 43 200 123 27 (4) . OVE! TET HE 154 202 10 22 14 26 39 193 57 142 TEE 92 70 15 18 10 141 60 212 1 40 4d 55 200 218 200 81 Key Financial employees Consolidated 27/04/2019 26/04/2014 20/04/2018 TUR 12th 29/04/2017 EUR 12 month 30/04/2016 EUR 21/04/2013 EUR 12 month 29/04/2012 EUR 25/04/2015 TU 12 IFRS - 137541 01/05/2011 EUR 12 12th w 12 m 02/05/2010 EUR 12 movie RS 1.SILS ut 1997 Exchane GRYTUR F 121451 11542 SOCET 1_12079 529,0417 WWV:02 HOSEN Geringue (Tur) PL to pred - Netcomes Cashow To Sharecen inds 1,023,512,133 1704.803,009 19.04.01 1,440 414,230,00 32.100,00 -70,237,020 110,13,331 503,347,00 362,3560 46414354 04365013 100406114 70.146.2 121,363.540 50 09 T75,45,023 7.000,22 12,990,00 19,664,400 607174,420 2.46,102 677.561.370 4105 47.272.97 100,1242939 542642 ) 33,453 60,917.00 44,511650 12.2013 474.122.030 61,500 43,101,423 14,714,303 372,257,271 26.261 300AL 5.252,209 444345 0.00022 336143 226.420334 53.013,555 32,735,090 42.590,171 366,412.521 101,318,50 3,850,00 11,067 7430 12,154,30 113,724, LARI STONE CESTO 23 7 2. 2.50 7.30 . 95 243 16.28 CHE 18 1691 2.82 39.82 ! 2.1 12.00 2016 11.10 3.1 14 HEB ! 1412 >3.14 27 1603 23 1933 HE Garret Mot mai (6) ROEI Wore) ROGEN Y beteret Sony () Number of employee LETE 6051 1001 -3301 50 15.00 70.76 17.30 RA 7032 64.89 LETE 3.2 1. 314 2, 2.32 2220 2,022 1.18 1.2 19 Evolution of a key variable: Operating revenue (Tumover) (2010 - 2019) 1,200,000,000 1,000,000,000 800,000,000 600,000,000 400,000,000 200,000,000 0 EUR 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Global and format Salance sheet Consolated 27/04/2019 EUR 12 IFRS 1 1999 21/04/2018 EUR 12 months EARS 1132 29/04/2017 EUR 12 IFRS 1.1940 30/04/2016 EUR 12 month IFRS 20150 25/04/2015 GUR 12 IFS 28/04/2014 EUR 12 months ES 28/04/2013 EUR 12 m IFRS 1.11743 29/04/2012 EUR 12 IFRS 1.21050 01/05/2011 EUR 12 IFRS 1107 02/05/2010 EUR 12 the IFRS 1.11110 Exchange rate GPYEUR Aneta 1 Intangible fred assets -Tangit Othered assets 155,218.00 59,729,096 01.10.325 30.541940 268,500.035 , 76,414 147,142,373 54,101,84 233.844,158 69,701,051 143.630,00 44.518,701 2:30,124.003 66,002,411 122,263,919 41,3083 213.273,705 71.662.500 99.447,193 40. 164012 279,383.526 56.717,3 35.000 37,265,546 165,289,333 49,2710 75,670,270 40,372,19 175,358.900 50.084,963 78,511.564 46,76.175 125.23.205 33.951,14) 7.3624448 49,519,094 35.295,757 1.25.4 26.021,414 5731,100 >6,067,98 114 104 181325 COEWOO Current - Stock -Debtors the current C & cash when 408,129,014 221,267,351 100,549, 77,241022 490,433,43 161,416,44 104,195,00 141,011,125 14,120, 403,680,165 186,130,23 2010652 119.479,275 7743503 177,100,016 144,107,310 52,166,313 1032494 129,456.359 166.152,77 148414,270 55,019,14 167,719,267 92.002430 165,128,133 94,405,000 31,471,65 131,167.123 10., 158,845,852 68,2974 2,836 61.529439 30,025,193 11,6 37.375,78 54.714,1 RSIVE 72.00 24,32445 107,435 41.785,62 32.799,583 51,220,285 16,080,166 902147016 698,134,99 1:54,534,14 60747420 5YA0443 444511.650 32,257,231 134,100 260412.521 162,164 TOTAL ASSETS Las & Equity Shareholders funds Capital Other startersunds 302,356.500 4.755.1 405,041 653 45,166,95 4,458,00 459.307.646 40,934483 4,854,543 4360541 429.446,109 5,254,524 124,591.57 616 317,229,716 4,858,05 312372.667 25.044,120 4.M 26.114450 VON 226478.330 4,433,155 231,505.979 169,035.732 4483,20 114.332357 115.72497 4.547,175 TILY,805 460,539.733 170,29,033 57.100 4871150 61.74019 58 ECOCOS SESUAI erre Longer Othe-current U U U 65,190,141 0 65,790,041 1,046,125 1711071 445443 1015017 237,435 17.997,352 14,58 10 24,76 19426753 20,219.933 72.30.710 44,471.250 49. 415 1.000,7 42,090,171 1922,70 42,209.195 492236 41,716459 3,412 43,740.299 31.500,00 3.2.184 IT LEVES oto 156109 OSE 85,700.000 121.451 65.467323 COVE 18.158.110 23485 47157.903 11' Carrantie -Loans Creditors Other current 133,157,455 0 72,534,133 o 0 74458331 96.262.330 0 60'S 0 VOITL6 CORE 0 70424.56 TUBE 44,547,314 78,016,43 1,553,546 14,337,500 11.210.27 GES 602 1966:25 CELOT' 27459453 20.79RASO 29.441,03 TOYO TOTAL, SHAREN, FUNDS A LIAB 593.34708 LEF59 NEFES'+99 209 577.426,442 444,511.650 TESTELE 28 260.412.521 CE 291 Mente lines Working cap Net Current Enterprise ZOUT 692 82,405413 01219.768 DE V 065626621 TE POSODE Stat SOTSI EES 238,508,207 BOGOR BET 9.3.278,629 CORSO VO TEST9 90 sast toets 20465, 494,150 31620.119 237 408 422 261,455,760 479.486.360 1.36,736,491 1.353.116.42 1.140,07,135 3,280 2,707 515.656.39 UN TE ELE PER BEZ 2012 wat Promo Costel STOLIVOST OZO 27/04/2019 TUR 12 TO/V/Z 28/04/2018 FUR 12 monte 29/04/2017 EUR 30/04/2016 EUR 01/05/2011 EUR w EUR TUR 29/01/2012 EUR 12 months w 26/04/2013 EUR 17 math IS TI TUR 12 month ins . WICI 4 . GE1 Exchange rate GEPEUR Operating wine STOP! COMIT KE tra's sott ACTIVE 't G'Oro 139.64.734 4. 2474214 161.360.00 Tu na Cists of goods will 449361527 NERET 99552 11,364 Sorcer 178.388.406 166.12.45 117.795448 7.12.30 Grosgrom SOLCHES 158 COLOSS it's 455.670,012 BE OSESSE 223,351,863 1494.25,907 It's Other 653 $11,543,019 47 DNA 402,161,030 332.866,135 3,161 KERE 160.223,65 TCE296 50 213.00 Operating PL-BIT WE 49 71,048,113 103.24741 CONCE 54,300,18 ITECTS PORTE NVIOS Itter Pancen SESOV or 2,0614 47.255 ce GOES 132979 1454 -2.86 697.256 356227 123.0 112079 764,055 128,159 ' - Financial revenue ancil Financial PL PL bore 16.401615 1.507223 19548.3 99.04.2019 -3.402.850 149,881 3,4, 74,195,440 2.841.650 100 406134 ES 825,201 962,836 81.341,01 67,256 14.09.14 356, 227 51.500.5 323,051 63.252.26 2.44 195,701 -192,24 25.555.900 71,000,22 33033855 15.193.211 14,589,14 18,670,454 1.560.97 21,132.11 10.405.064 18.828.000 19.272456 -57,216,100 Taxation Perta 114.239.030 ST 60,0 78.146.300 12,979,700 6272,073 33,763453 43103173 41424355 33.735.89 03.067015 na Estrand other -Er dhe pense ar and other Pred neone BOB ra U 114.239.00 57.600.00 T.16.181 17.923,755 01.172073 33.7633 63.103473 41424255 SSE 13.735.29 03.067,064 $12.450,12 164,144,10 re 13,75 147.15 ARS 12.10 6545, X33X250 R. TEVE 624,25,2 15200 11,722,035 Hay Memeli Export revet Materi Cais done De Amor Research & Development expenses Der Home terstad 19 12.11 93,13.10 36.862100 12.101,447 0,754,640 0.002.011 14:30 43.217.20 na 28,28 27,003433 AN 71411,100 16.43.777 TE 430364 na TU TU 1.56731 340, 3,1 2.30 TV TU 195,00 11.2.5 ' TE 14.01 BOX Cashow Alde EDITOA 1625700 1340337 1.0045 110,331,011 260,082,236 153,671,00 91,600 219,200,400 112,651,826 130,134,931 211.686,34 119.466,747 0,4706 . $1,172,351 22.500,00 . 61.755,741 7.497,43 43.263,111 30.873.575 146.AS. 12,763,419 79,372,96 Global Com 19/01/2015 27/04/2012 EUR 12 months MARS 1.19 20/04/2015 EUR 12 months 29/04/2017 EUR 12 m TUR 10/04/2016 EUR 12 month IFRS 26/04/2014 EUR 12 months IFRS 7102013 EUR 12 months ras 1843 29/04/2012 EUR 12 month 01/05/2011 EUR 12 month IAS 12 months 03/05/2016 EUR 12 month TERE 1.15110 Set the EUR 1 F 2010 1 12010 227) 20.16 1731 15.99 1407 23.18 2704 BEBE TU - 12.36 -23.00 -16. -178 16.6 31.3 na 2035 19:46 1534 1235 10.64 1653 15.00 11 12:31 111 8. 14 16:52 16.31 189 1962 22:34 1933 15.02 71. 61 TEXT 1241 10 Probility rate ROE in before ROCES (N) ROAST WL ROEN) ROCES No come NOR UN Net nome) (4) Gran RIDAM INT MIM Cashow/Operating Enterprise / EBITDA WS SER 10.30 SES 196 HER SITE 2. 1031 1 LIH NEWS 120 40 1624 10 16:02 10 BAY 19 SENS 51:15 1946 TET 0.13 16:14 TERE 1431 9.36 12.06 10.12 114 14) 9.24 153 1026 11.50 19.30 2018 18.20 . 7.19 23.00 39.7 13 14.78 TE 1446 10.00 1042 350 II 6.23 EVER 1722 182 . 141 143 145 1.00 22.67 S45 00195 TU 13. 1.51 100,33 65 20 5.60 5.04 4.56 Operational Naturve It Stock tumo Collection series Ce pod Export revenue / Operating revet () RAD/Opining) 199 2:42 52.46 463 19 20 64.53 430 31 22 NE EE 24 LE CE 3:36 24 14 4696 na LE 5.70 2 41 13.16 12 30.33 35 40.43 37 24.43 CE 03 1995 60.33 20.68 na TY 150 182 1.64 145 CFT SFT 1:20 00195 Dewi Nettsturo Interest one Star are ) Credito Export revenue / Operating reverse() RAD/Operating (9) 5.70 1.51 100.93 457 29 37 4093 RE 5.04 20 550 27 37 33 521 39 20 43 TA 30 36 56.65 24 14 450 13 17 24.48 13.00 6.54 20 33 20.60 SC 464) 3403 9516 ma BE 2.56 27 299 9 2,34 LOO 2.1 280 1.75 258 1.) 7. 28 15 TIT TOT 1.01 304 1. 6.95 714 3 06 49 NES VE 70.0 9.30 30.12 3 LE 5717 14 7127 2.18 1412 12.07 10.30 10.77 2.1 25.80 17.01 Structures Current ratio odyti thachokers uitky a Soyees by) Canno) Premere Proper) Open menpe (1) Catery / Operwing revenue Average cost of an poest.) Shares fonds per month Working proth) Toto per porth DE 33 SC SE SE -10 312 1. 26 CE 900 cett 30 215 20 23 16 DE ore LES 43 200 123 27 (4) . OVE! TET HE 154 202 10 22 14 26 39 193 57 142 TEE 92 70 15 18 10 141 60 212 1 40 4d 55 200 218 200 81