Cenviral fatroduction Quick avereirw of 4 Cases with mare vpecifire an fullewing pegse Cian trutien 1 thesesh 4 Cathering data for Case Studies sulertiet o Cempas lation Eeafina Ceesposs Melerties Fintiedied Coenpanke if Tor the bo he sin Gathering data for Case Studies Selecting a Company Selet a US listed public contrpany the team is genuinely interested in as the case sluaties will be more meaningful. Next identify a significant contrany event and ceenpute 899 days of daily returns before the event and 100 days after. Seanning financial media sources sbonild give yoo a lot of Aleas. The company eveet should be a sigaificant event for the company, such as: - a major product anhouncensent - the announcemest of a sixeable aequisition - a significant change in management of control - significant change in operating results over these expected - significant copporate govemance failiegs - tightiening of tegulatory oversight - impending litigation against the compary Ideally the event should be one that has not been anticipated by the market and as such the eveat announcement is a surpeive. Confirm Company Selection Once the team has selected its company and event please send me a quick email listing the company, the cvent and also coefirm all team membets are engaged. If the companyievent has been selceled by another team I will ask fot another selection. You will quickly bear back frum me as you let me know. Excluded Companies There are 6 companies that are cecloded-Amanen, Apple, Bocing. Disacy. Tesla and Fannie Mae. These are so eften selected, of used in elass materials, that I want to awaired we have some interesting range on companies and subjects. Downloading the Stock and Index Price Data: We are going to use Yaheo to get the stock price data. The steps are as follows: a) Log inso the web and pell up the Yahoo finance wob site b) Type in the stock symbol for yenur company and hit go or if you don't know the stack symbol hit symbol lookup. c) On the left hand side of the neut screen there will be a link to "Historical Price". Choose the link, d) You will be presented with a date range and companien daily, weckly cto optices on the right hand side. Choose daily data and set op the date range wo that you have appoximatcly 899 trading days of trading days before the event day and too trading days after the evena day. To get this trading date range pick a start date that is 4 years before the event date and pick an ending date that is 6 moeeths after the event date. Afler you afe happy with your danes hit get prises, e) Scroll down to the bottem of the page and hit the link download to spreadshect. This process will aunomatically eall up Excel and place the data there. Clean up the dana by deleting all columns except the dane and the atjusted closing price. The adjusted closing price adjusts for splits and includes divideals. f) Save the spreadsheet by selecting "Save as". When the save scroen comes up fype in a diecetery and name for your refcrence but remember under file type chose Excel worksheet as the file type. The default showing will be a CSV Jormat. g) The last step is bo select data for the gencral market. The S\&P 500 will be used as the proxy for the market index. h) The saock symbol for the 5.2P500 is "GSPC. Type this symbel in at the tep of the sereen under "Quotes and Info" and his ge. Conplete steps b) through f above for the S\&P 500 . Obvicus to say you are selecting market data foe the ame dene range as your cuenpany. Cenviral fatroduction Quick avereirw of 4 Cases with mare vpecifire an fullewing pegse Cian trutien 1 thesesh 4 Cathering data for Case Studies sulertiet o Cempas lation Eeafina Ceesposs Melerties Fintiedied Coenpanke if Tor the bo he sin Gathering data for Case Studies Selecting a Company Selet a US listed public contrpany the team is genuinely interested in as the case sluaties will be more meaningful. Next identify a significant contrany event and ceenpute 899 days of daily returns before the event and 100 days after. Seanning financial media sources sbonild give yoo a lot of Aleas. The company eveet should be a sigaificant event for the company, such as: - a major product anhouncensent - the announcemest of a sixeable aequisition - a significant change in management of control - significant change in operating results over these expected - significant copporate govemance failiegs - tightiening of tegulatory oversight - impending litigation against the compary Ideally the event should be one that has not been anticipated by the market and as such the eveat announcement is a surpeive. Confirm Company Selection Once the team has selected its company and event please send me a quick email listing the company, the cvent and also coefirm all team membets are engaged. If the companyievent has been selceled by another team I will ask fot another selection. You will quickly bear back frum me as you let me know. Excluded Companies There are 6 companies that are cecloded-Amanen, Apple, Bocing. Disacy. Tesla and Fannie Mae. These are so eften selected, of used in elass materials, that I want to awaired we have some interesting range on companies and subjects. Downloading the Stock and Index Price Data: We are going to use Yaheo to get the stock price data. The steps are as follows: a) Log inso the web and pell up the Yahoo finance wob site b) Type in the stock symbol for yenur company and hit go or if you don't know the stack symbol hit symbol lookup. c) On the left hand side of the neut screen there will be a link to "Historical Price". Choose the link, d) You will be presented with a date range and companien daily, weckly cto optices on the right hand side. Choose daily data and set op the date range wo that you have appoximatcly 899 trading days of trading days before the event day and too trading days after the evena day. To get this trading date range pick a start date that is 4 years before the event date and pick an ending date that is 6 moeeths after the event date. Afler you afe happy with your danes hit get prises, e) Scroll down to the bottem of the page and hit the link download to spreadshect. This process will aunomatically eall up Excel and place the data there. Clean up the dana by deleting all columns except the dane and the atjusted closing price. The adjusted closing price adjusts for splits and includes divideals. f) Save the spreadsheet by selecting "Save as". When the save scroen comes up fype in a diecetery and name for your refcrence but remember under file type chose Excel worksheet as the file type. The default showing will be a CSV Jormat. g) The last step is bo select data for the gencral market. The S\&P 500 will be used as the proxy for the market index. h) The saock symbol for the 5.2P500 is "GSPC. Type this symbel in at the tep of the sereen under "Quotes and Info" and his ge. Conplete steps b) through f above for the S\&P 500 . Obvicus to say you are selecting market data foe the ame dene range as your cuenpany