The FINANCIAL MODELLING assignment
(1) Collect monthly UK price data for two equities, each from a different industry, and one market index from UK Yahoo Finance (http://uk.finance.yahoo.com/). You should select stocks that have at least 10 years of recent data and the most recent observation should be January 2018. Note that any two submissions should not
consider precisely the same set of data. Also, you should not choose stocks that were used in the lectures/classes (in particular, Barclays and Tesco)
(2)Download the sterling end-of-month 3-month UK Treasury bill data (code IUMAJNB) for the same sample period
from the Bank of England website.
(3)Convert each (adjusted closing) price data series into log returns. Convert the raw 3-month Treasury bill rates into monthly figures and lag the data by one month.
Construct a table providing relevant descriptive statistics for these data and provide a brief description.
(4)Estimate the CAPM regression for each stock. Report your regression results. (Decide what you think is most relevant and do not copy and paste Excel output
Briefly comment on the output.
(5)Comment on whether there is support for the CAPM in each case.
(6)Determine the type (whether aggressive, defensive, or neutral) for each of your stocks. Use statistical hypothesis tests to support your classification.
(7)Calculate the expected return, systematic risk, non-systematic risk and total risk for each stock implied by the market model. Briefly comment on the results.
(8)Suppose you want to test the possibility that the returns of your chosen stocks behave differently in January compared to other months of the year. Create a dummy variable that would distinguish between the month of January and other months. Re-estimate
the CAPM regression for each stock, but this time including the (intercept) dummy as an additional regressor. Report your results and comment on your findings by focusing on the results for the intercept dummy in each case.
We can write this or a similar paper for you! Simply fill the order form!
