You are a trainee analyst for a well-known investment company. Your manager requires you to write a report about the predicted performance for a specific company (Ferguson plc), given its monthly return and a set of macroeconomic variables.
Econometric analysis: a systematic way
Data collection and structuring
Collect data, structure it and make all sample sizes for all variables consistent
Import data to Eviews Import the data from the Excel file and save the resulting work file
Describe time series properties for the set of variables using descriptive statistics and correlation
Perform stationarity tests
Do necessary transformation Calculate the following:
1- The log returns for share price (R_share) and for index (R_index). Check their stationarity. If they are not stationary, transform the variables.
2- Generate excess return series for the share and for the index.
ER_share = R_share – monthly average rate (3M TBill rate)
ER_index = R_index – monthly average rate (3M TBill rate)
3- Generate series for Inflation using CPI
inflation = 100*dlog(cpi)
4- Get first difference for each of the independent variables. If it does not work, try to get log() then get first-difference.