My Company name is FERREXPO PLC

Please provide me a complete fresh solve.

Task 2: Extracting the data of a listed company and analysing recent trends [40 marks] In this part, you need to extract some financial information of the firm from a financial database such as Yahoo.finance. A. Considering the recently released financial statements, how much has been the "total revenue", "total asset, "long-term debt, total liability, total shareholders' equity" of the company in the last 3 years? (10 marks] B. Do you see any changes in the capital structure (the ratio of total debt to equity) of the company in the last 3 years? [10 marks] C. Calculate the Total Shareholder Return (TSR) of the company in the last 3 years [10 marks] D. What are the main advantages of being listed in the stock exchange for a company? Do you see these advantages in the company that you are analysing? [10 marks] Valuation Fiscal Period: December 2017 2018 2019 2020 2021 2022 Capitalization 2 318 1 455 1 237 2 366 2 366 Entreprise Value (EV) 2 721 1 794 1 518 2421 2 142 2 118 P/E ratio 5,92% 4,38x 3,08x 4,64x 3,75x 7,72x Yield 4,17% 9,31% 6,26% 7,56% 8,97% 4,57% Capitalization / Revenue 1,94x 1,14x 0,82% 1,49x 1,40x 1,60% EV / Revenue 2,27x 1,41x 1,01% 1,53x 1,27x 1,44x 4,94x 3,57x 2,59x 3,38% 3,04x 5,37x EV / EBITDA Price to Book 3,89% 1,68X 0,91x 1,56% 1,21x 1,16x Nbr of stocks (in thousands) 585 708 586 288 586 922 587 699 587 699 Reference price (USD) 3,96 2,48 2,11 4,03 4,03 4,03 Last update 03/21/2018 04/23/2019 03/18/2020 01/28/2021 01/28/2021 01/28/2021 1 GBP in Million 2 USD in Million Estimates Annual Income Statement Data Average Dally Capital Traded 30,6% Fiscal Period: December 2017 2018 2019 2020 2021 2022 EPS & Dividend Net sales 1 197 1 274 1 507 1 583 1 691 1 475 EBITDA 1 551 503 586 715 706 395 1.20 50.0% Operating profit (EBIT) 496 428 497 586 603 244 1.00 40.0% Operating Margin 41,4% 33,6% 33,0% 37,0% 35,7% 16,5% 0.80 2017 2018 2019 2020 (e) 2021 (e) 2022 (e) Pre-Tax Profit (EBT) 1 450 392 460 630 675 246 g 0.60 with 30.0% Rate of Dividend 0.40 Net income 1 393 334 402 448 535 305 20.0% 0.20 Net margin 32,8% 26,2% 26,7% 28,3% 31,6% 20,7% 0.00 10.0% EPS 2 0,67 0,57 0,68 0,87 1,07 0,52 EPS Dividend -- Rate of Dividend Dividend per Share 2 0,17 0.23 0,13 0,30 0,36 0,18 Omarketscreener.com - S&P Global Market Intelligence Last update 03/21/2018 04/23/2019 03/18/2020 01/28/2021 01/28/2021 01/28/2021 1 USD in Million 2 USD Estimates Year-on-year evolution of the PER Help Balance Sheet Analysis 2010 2011 2012 2013 2014 2015 2016 2018 2019 2020 (e) 2021 (e) 2022 (e) 12.5 Fiscal Period: December 2017 2018 2019 2020 2021 2022 10 Net Debt 403 339 281 54,0 7.5- Net Cash position - - 224 249 P/E ratio 5.8 Leverage (Debt/EBITDA) 0,73x 0,67% 0,48x 0,08x -0,32% -0,63% 5 Free Cash Flow 250 157 226 422 480 255 1..... 12 2.5 5.6 5.2 6'S 4.3 tu ROE (Net Profit / Equities) 85,4% 45,1% 36,3% 35,7% 38,3% 5,80% 3.7 3.1 14.6 0 Shareholders' equity 460 740 1 109 1 257 1 396 5265 Annual Income Statement Data Average Daily Capital Traded 30,6% Fiscal Period: December 2017 2018 2019 2020 2021 2022 EPS & Dividend Net sales 1 197 1 274 1 507 1 583 1 691 1 475 2017 EBITDA 551 503 586 715 706 395 1.20 50.0% Operating profit (EBIT) 496 428 497 586 603 244 1.00 2018 2019 2020 (e) 2021 (e) 2022 (e) 40.0% Operating Margin 41,4% 33,6% 33,0% 37,0% 35,7% 16,5% 0.80 - 1 Pre-Tax Profit (EBT) 450 392 460 630 675 246 0.60 30.0% will Rate of Dividend 0.40 Net income 1 393 334 402 448 535 305 20.0% 0.20 Net margin 32,8% 26,2% 26,7% 28,3% 31,6% 20,7% 1 0.00 10.0% EPS2 0,67 0,57 0,68 0,87 1,07 0,52 EPS Dividend -- Rate of Dividend Dividend per Share 2 0,17 0,23 0,13 0,30 0,36 0,18 marketscreener.com - S&P Global Market Intelligence Last update 03/21/2018 04/23/2019 03/18/2020 01/28/2021 01/28/2021 01/28/2021 1 1 USD in Million 2 USD Estimates Year-on-year evolution of the PER Help ob Task 2: Extracting the data of a listed company and analysing recent trends [40 marks] In this part, you need to extract some financial information of the firm from a financial database such as Yahoo.finance. A. Considering the recently released financial statements, how much has been the "total revenue", "total asset, "long-term debt, total liability, total shareholders' equity" of the company in the last 3 years? (10 marks] B. Do you see any changes in the capital structure (the ratio of total debt to equity) of the company in the last 3 years? [10 marks] C. Calculate the Total Shareholder Return (TSR) of the company in the last 3 years [10 marks] D. What are the main advantages of being listed in the stock exchange for a company? Do you see these advantages in the company that you are analysing? [10 marks] Valuation Fiscal Period: December 2017 2018 2019 2020 2021 2022 Capitalization 2 318 1 455 1 237 2 366 2 366 Entreprise Value (EV) 2 721 1 794 1 518 2421 2 142 2 118 P/E ratio 5,92% 4,38x 3,08x 4,64x 3,75x 7,72x Yield 4,17% 9,31% 6,26% 7,56% 8,97% 4,57% Capitalization / Revenue 1,94x 1,14x 0,82% 1,49x 1,40x 1,60% EV / Revenue 2,27x 1,41x 1,01% 1,53x 1,27x 1,44x 4,94x 3,57x 2,59x 3,38% 3,04x 5,37x EV / EBITDA Price to Book 3,89% 1,68X 0,91x 1,56% 1,21x 1,16x Nbr of stocks (in thousands) 585 708 586 288 586 922 587 699 587 699 Reference price (USD) 3,96 2,48 2,11 4,03 4,03 4,03 Last update 03/21/2018 04/23/2019 03/18/2020 01/28/2021 01/28/2021 01/28/2021 1 GBP in Million 2 USD in Million Estimates Annual Income Statement Data Average Dally Capital Traded 30,6% Fiscal Period: December 2017 2018 2019 2020 2021 2022 EPS & Dividend Net sales 1 197 1 274 1 507 1 583 1 691 1 475 EBITDA 1 551 503 586 715 706 395 1.20 50.0% Operating profit (EBIT) 496 428 497 586 603 244 1.00 40.0% Operating Margin 41,4% 33,6% 33,0% 37,0% 35,7% 16,5% 0.80 2017 2018 2019 2020 (e) 2021 (e) 2022 (e) Pre-Tax Profit (EBT) 1 450 392 460 630 675 246 g 0.60 with 30.0% Rate of Dividend 0.40 Net income 1 393 334 402 448 535 305 20.0% 0.20 Net margin 32,8% 26,2% 26,7% 28,3% 31,6% 20,7% 0.00 10.0% EPS 2 0,67 0,57 0,68 0,87 1,07 0,52 EPS Dividend -- Rate of Dividend Dividend per Share 2 0,17 0.23 0,13 0,30 0,36 0,18 Omarketscreener.com - S&P Global Market Intelligence Last update 03/21/2018 04/23/2019 03/18/2020 01/28/2021 01/28/2021 01/28/2021 1 USD in Million 2 USD Estimates Year-on-year evolution of the PER Help Balance Sheet Analysis 2010 2011 2012 2013 2014 2015 2016 2018 2019 2020 (e) 2021 (e) 2022 (e) 12.5 Fiscal Period: December 2017 2018 2019 2020 2021 2022 10 Net Debt 403 339 281 54,0 7.5- Net Cash position - - 224 249 P/E ratio 5.8 Leverage (Debt/EBITDA) 0,73x 0,67% 0,48x 0,08x -0,32% -0,63% 5 Free Cash Flow 250 157 226 422 480 255 1..... 12 2.5 5.6 5.2 6'S 4.3 tu ROE (Net Profit / Equities) 85,4% 45,1% 36,3% 35,7% 38,3% 5,80% 3.7 3.1 14.6 0 Shareholders' equity 460 740 1 109 1 257 1 396 5265 Annual Income Statement Data Average Daily Capital Traded 30,6% Fiscal Period: December 2017 2018 2019 2020 2021 2022 EPS & Dividend Net sales 1 197 1 274 1 507 1 583 1 691 1 475 2017 EBITDA 551 503 586 715 706 395 1.20 50.0% Operating profit (EBIT) 496 428 497 586 603 244 1.00 2018 2019 2020 (e) 2021 (e) 2022 (e) 40.0% Operating Margin 41,4% 33,6% 33,0% 37,0% 35,7% 16,5% 0.80 - 1 Pre-Tax Profit (EBT) 450 392 460 630 675 246 0.60 30.0% will Rate of Dividend 0.40 Net income 1 393 334 402 448 535 305 20.0% 0.20 Net margin 32,8% 26,2% 26,7% 28,3% 31,6% 20,7% 1 0.00 10.0% EPS2 0,67 0,57 0,68 0,87 1,07 0,52 EPS Dividend -- Rate of Dividend Dividend per Share 2 0,17 0,23 0,13 0,30 0,36 0,18 marketscreener.com - S&P Global Market Intelligence Last update 03/21/2018 04/23/2019 03/18/2020 01/28/2021 01/28/2021 01/28/2021 1 1 USD in Million 2 USD Estimates Year-on-year evolution of the PER Help ob