studying for my final exam please can anyone help with these questions and provideo thorough explinatipns where everything is coming from when solving
Case stady (12 points) WIZZ AIR HOLDING PLC. Wizz Air Holdings Plc is a low-cost airline company. Together with its subsidiaries, it provides passenger air transportation services on scheduled short-haul and medium-haul point-to-point routes across Europe and the Middle East. As of June 04, 2021, it operated a fleet of 137 aircraft that offered services for approximately 824 routes from 43 bases connecting 167 airports in 48 countries. The company provides its services under the Wizz Air brand. Wizz Air Holdings Ple was founded in 2003 and is based in Saint-Helier, Jersey. As a Junior analyst, your task is to perform a financial analysis and to value the company. To help you complete this assignment, answer the following questions: 1) Construct the financial balance sheet. 2) Compute the working capital, working capital requirement and the net cash position. 3) Compute the degree of leverage for 2019 and 2020 only. The amounts of fixed operating costs for the year 2019 and 2020 are: 1448,6 ( million) and 1722,5 ( C millions). 4) Compute the growth of the revenue, the margin ratios, the asset turnover ratio as well ratios related to the indebtedness of the company. 5) Compute the return on Capital Employed and compare it with the WACC (whose value is around 8% over the 3 years). 6) Write a structured but short comment on the financial situation (risk(s) \& return) of the company. 7) Assess the value of the company using the discounted cash flow method: The next three years will enable the company to return to pre-crisis levels and go beyond. After 2024 , the free cash flow will grow at a steady rate of 3%. The value of the WACC will remain unchanged. There are 85635016 shares outstanding. Appendix 1: Income statement (in millions of ) For tha Fiscal Pariod Endina Mar-31-2019 Mar-31-2020 Mar-31-2021 For the Fiscal Period Ending growth in % Appendix 2: Balance sheet (in millions of ) "The major expenses that affect companies in the airline industry are labor and fuel costs. Labor costs are largely fixed in the short-term, while fuel costs can swing wildly based on the price of oil. Historically, the airline industry continues to be brutally competitive, even though the business of flying people all over the world and country has become an integral part of human life. The cost of flying continues to trend lower. The Internet has also created greater price transparency, reducing margins." (source: Investopedia) Newswise (29-Oct-2020) - The COVID-19 pandemic has caused a dramatic reduction in travel [...]. Figures show that in the second quarter of this year, airlines suffered an 80% fall in income compared to 2019, as the passenger fleet was brought to a virtual standstill, according to data from the International Air Transport Association [...]. For 2020, there will be a 50% fall in seat numbers for the airline industry, representing almost 3 billion fewer passengers end 400 billion dollars in loss of income. Although these shocking figures affect the whole ifitustry, low-cost airlines have proven more adaptable to this uncertain outlook, as Suau-Sanchez reports in his research published in the Journal of Transport Geography, in conjunction with Edgar Jimenez, from Cranfield University (United Kingdom). According to the study, these airlines have shown greater resilience than traditional ones, due to their lower exposure to international long-haul traffic, which has been considerably disrupted by the health crisis. Indeed, the fall in seat numbers offered in March and April 2020 was much sharper in traditional airlines than low-cost ones, while the recovery is similar in both, as travel restrictions are gradually lifted. According to the UOC researcher, "Low-cost airlines operate in regional (intracontinental) markets and are therefore less exposed to the dynamics of long-haul (intercontinental) markets, which were the first to be grounded in early February and have remained inactive for longer Case stady (12 points) WIZZ AIR HOLDING PLC. Wizz Air Holdings Plc is a low-cost airline company. Together with its subsidiaries, it provides passenger air transportation services on scheduled short-haul and medium-haul point-to-point routes across Europe and the Middle East. As of June 04, 2021, it operated a fleet of 137 aircraft that offered services for approximately 824 routes from 43 bases connecting 167 airports in 48 countries. The company provides its services under the Wizz Air brand. Wizz Air Holdings Ple was founded in 2003 and is based in Saint-Helier, Jersey. As a Junior analyst, your task is to perform a financial analysis and to value the company. To help you complete this assignment, answer the following questions: 1) Construct the financial balance sheet. 2) Compute the working capital, working capital requirement and the net cash position. 3) Compute the degree of leverage for 2019 and 2020 only. The amounts of fixed operating costs for the year 2019 and 2020 are: 1448,6 ( million) and 1722,5 ( C millions). 4) Compute the growth of the revenue, the margin ratios, the asset turnover ratio as well ratios related to the indebtedness of the company. 5) Compute the return on Capital Employed and compare it with the WACC (whose value is around 8% over the 3 years). 6) Write a structured but short comment on the financial situation (risk(s) \& return) of the company. 7) Assess the value of the company using the discounted cash flow method: The next three years will enable the company to return to pre-crisis levels and go beyond. After 2024 , the free cash flow will grow at a steady rate of 3%. The value of the WACC will remain unchanged. There are 85635016 shares outstanding. Appendix 1: Income statement (in millions of ) For tha Fiscal Pariod Endina Mar-31-2019 Mar-31-2020 Mar-31-2021 For the Fiscal Period Ending growth in % Appendix 2: Balance sheet (in millions of ) "The major expenses that affect companies in the airline industry are labor and fuel costs. Labor costs are largely fixed in the short-term, while fuel costs can swing wildly based on the price of oil. Historically, the airline industry continues to be brutally competitive, even though the business of flying people all over the world and country has become an integral part of human life. The cost of flying continues to trend lower. The Internet has also created greater price transparency, reducing margins." (source: Investopedia) Newswise (29-Oct-2020) - The COVID-19 pandemic has caused a dramatic reduction in travel [...]. Figures show that in the second quarter of this year, airlines suffered an 80% fall in income compared to 2019, as the passenger fleet was brought to a virtual standstill, according to data from the International Air Transport Association [...]. For 2020, there will be a 50% fall in seat numbers for the airline industry, representing almost 3 billion fewer passengers end 400 billion dollars in loss of income. Although these shocking figures affect the whole ifitustry, low-cost airlines have proven more adaptable to this uncertain outlook, as Suau-Sanchez reports in his research published in the Journal of Transport Geography, in conjunction with Edgar Jimenez, from Cranfield University (United Kingdom). According to the study, these airlines have shown greater resilience than traditional ones, due to their lower exposure to international long-haul traffic, which has been considerably disrupted by the health crisis. Indeed, the fall in seat numbers offered in March and April 2020 was much sharper in traditional airlines than low-cost ones, while the recovery is similar in both, as travel restrictions are gradually lifted. According to the UOC researcher, "Low-cost airlines operate in regional (intracontinental) markets and are therefore less exposed to the dynamics of long-haul (intercontinental) markets, which were the first to be grounded in early February and have remained inactive for longer
