代写Commerce 3FD3: Financial Modelling

Commerce 3FD3: Financial Modelling

ASSIGNMENT 3

Assignment 3 is due Saturday 09-March,11:59pm. You will need to upload your Python work plus any supporting files, into the course ASSIGNMENT 3 DROPBOX.

You will be asked to do an analysis of 3 stock ticker symbols and compare their return to a Toronto Stock Exchange sub-index over the five-year period, from 31-Dec-2023 through 31-Dec-2018. You will need to do the following:

· Using section 5.6 of the Teaching Note_Python: for the four ticker symbols, and the dates given, import the monthly closing data from Yahoo.

· Using either MS Excel, or section 5.3.6 of the Teaching Note_Python, please determine the 2023, 2022, 2021, 2020, and 2019 annual returns for each of the four ticker symbols provided.

On a word document saved as a .pdf file; you will need to answer the below questions. Assume 1-2 explanatory paragraphs per answer:

1. State whether the monthly Toronto Stock Exchange sub-index performance was volatile over the 5-year period. State two reasons why you think this was the case.

2. Review each ticker symbol’s news announcements over the 5-year period. For each ticker symbol state two events over the five period, that in your opinion affected the share price performance. Please include a link to each of the news announcements that you are referring to.

3. Assume ticker symbol 1 and ticker symbol 2 each had a 25% weighting in the portfolio, and that ticker symbol 3 had a 50% weighting; state whether this portfolio would have outperformed the index, and why.

Between now and next week, you will need to ‘scaffold’ how you are going to do this; as next week, you will be picking your ticker symbols out of a hat.

If you are not at class next week, I will be assigning you your ticker symbols and e-mailing them to you by the end of the day.