I do have a project going on and wanted to check if you can help me with any of my challenges.
Project: Comparative Analysis on stock returns around M&A announcements.
I need an expert / consultant in Data Analysis and Econometrics with access to professional databases and knowledge possibly in Python, R, Stata or similar tools to conduct an event study with multiple event windows done on a large dataset.
Vision:
I have identified a list of ~17k transactions (the sample) that fulfil the selection criteria. I intend to conduct an event study in order to find abnormal returns for acquirer, target and both combined. The results shall then be presented.
My challenges:
- Reducing the sample? Yes or No?
- Identifying the right indices or basket of comparable (industry, geography, liquid) stock as a proxy of the market portfolio to regress against.
- Sourcing the data for the large amount of transactions (acquirer, target, market portfolio.
- Cleaning the data and making sure that for each transaction there are an equal amount of observations.
- Estimate normal returns based on respective market portfolio chosen for the specific event
- Cumulative Abnormal returns for all Acquirers, Targets and both combined (Whole Sample)
- Testing for significance
- Dividing the data into two cohorts based on one simple selection criteria
- Cumulative Abnormal returns for all Acquirers, Targets and both combined (Cohort 1 & Cohort 2)
- Testing for significance
Requirements:
• The candidate must have proven knowledge and understanding of conducting event studies, data anlysis and econometrics.
• The candidate should have a good understanding of the academic literature surrounding event studies.
• The candidate must have access to professional databases like Bloomberg, Datastream, CapitalIQ or comparable.
Expectations:
- A solution that requires as little manual intervention as possible and can be reused with a different data set.
- Support in word and deed and act as a consultant.
- Model documentation and validation including relevant tables and graphs and descriptive statistics
- Source code, if any
Specifications:
Budget: 250 doller, Delivery time: 7 days (Jul. 16 2020)
Tool: Python
