1. Select 2 listed companies from the Toronto Stock Exchange (https://www.tsx.com/listings/listing-with-us/listed-company-directory). At least one of the selected companies must come from be within the hospitality sector (e.g. hotel, airline, restaurant, and travel companies).The companies selected must be listed for at least 5 years. (1 mark)
2. Search and download the monthly stock price of your selected companies to Excel. The data must show a minimum period of 5 years. (1 mark)
3. Use the monthly 'Close' price to create an Excel forecast sheet from July 2023 to December 2023. for each of the selected listed companies using your selected forecasting model. (2 marks)
4. Assume you have CAD$1 million dollars and you would like to speculate on the stock of one of the companies you selected, which one will you choose? Disregard all transaction cost.(1 mark)
5. 
   
6. Explain to me the following (5 marks)

• The forecast model of each selected company
• What is the benefits of using your forecast model
• Reasons why you chose to speculate on that company
• Result of your speculation (i.e. how much will you likely to gain or lost by the end of this year)

Please submit your your excel file (as attachment) and any additional comments below!

Answer rating: 100% (QA)

I can guide you on how to approach the tasks youve outlined Task 1 Selecting Listed Companies 1 Visi... View the full answer