Build a time series model for the log earnings series

Reference no: EM131061212 , Length: 5

This pertains to Financial Econometric

Instructions: Read the questions carefully. For some questions, you will have to refer to the relevant chapter in the Tsay textbook. For your answers, create a word document that includes your explanations along with the relevant Rstudio output.

Question 1. The data set q msft.txt contains the quarterly earnings per share of Microsoft from the second quarter of 1986 to the third quarter of 2013. The earnings per share is in the third column.

(i) Build a time series model for the log earnings series. Perform model checking and write down the fitted model. [For simplicity, you may ignore the outliers, if any.]

(ii) Fit the following model to the log earnings series:

tmp<-arima(xt,order=c(0,1,1),seasonal=list(order=c(0,0,1),period=4))

where xt denotes the log earnings series. Write down the fitted model.

(iii) Compare the two time series models. Which model is preferred in terms of fitting? Why?

(iv) Use the backtest procedure to compare the two models via 1-step ahead fore- casts. You may use t = 81 as the starting forecast origin. Which model is preferred? Why?

Question 2. The data set d msft.txt contains daily simple returns of Microsoft (MSFT) stock from January 3, 2001 to December 31, 2013. Transform the simple returns (in the third column) to log returns.

(i) Is the expected log return zero? Why? Are there any serial correlations in the log returns? Why?

(ii) If there are serial correlations in the log return, build a mean equation for the log returns. Write down the fitted model. Is there ARCH effect in the log return series? Why?

(iii) Fit a Gaussian ARMA-GARCH model to the log return series. Obtain the nor- mal QQ-plot of the standardized residuals, and write down the fitted model. Is the model adequate? Why? garchFit( arma(p,q)+garch(m,n),data=data,trace=F)

(iv) Build an ARMA-GARCH model with Student-t innovations for the log return series. Perform model checking and write down the fitted model.

(v) Obtain 1-step to 5-step ahead mean and volatility forecasts using the fitted ARMA-GARCH model with Student-t innovations.

Question 3. Using the quantmod package download the adjusted closing prices of two stocks, namely Apple (AAPL) and Procter & Gamble (PG). The sample period is from January 3, 2002 to May 30, 2014. The data can be downloaded from Yahoo. Use the adjusted closing prices to compute the daily log returns.

For example,

dataset<-getSymbols("AAPL",from="2002-01-03",to="2014-05-30") tmp<-diff(log(zoo(GE?GE.Adjusted))) #install zoo package first

Assume that the tail probability of interest is 1% and that you hold a portfolio which consists of both stocks valued at $1 million each. Consider the Apple stock only.

(i) Calculate the VaR of your position for the next trading day using the RiskMetrics method on May 30, 2014. You must estimate the corresponding IGARCH(1,1) model. What is the associated expected shortfall? Also, what is the VaR for the next 10 trading days?

(ii) Build a GARCH(1,1) model for the log return series with Gaussian innovations. What is the VaR based on the fitted model for the next trading day? What is the corresponding expected shortfall?

(iii) Build a GARCH(1,1) model with Student-t innovations for the log return series. What is the VaR for the next trading day based on the fitted model? What is the corresponding expected shortfall?

Question 4. For a log return series r_t, let a_t = r_t-µ_t. Then,the GARCH(m, s) specification is

α_t= σ_t∈_t

σ_t²= α_o + ∑_{i =1}^mα_iα²_t-i + ∑_{j =1}^sβ_jσ²_t-j

where α₀ > 0, α_i ≥ 0, β_j ≥ 0, and ∑_{i =1}^max(m,s)(α_i + β_i) < 1. Show that the kurtosis of at is greater than 3 for m = s = 1.

Question 5. The data set csco.csv contains observations on simple returns for Cisco Systems (CSCO) stock. Consider the daily log returns of CSCO stock (calculate it from simpe returns). You will use out-of-sample forecasts to compute the annualized h-period volatility, i.e., volatility term structure for CSCO stock from December 29, 2008 to December 31, 2010.

(i) Estimate a GARCH(1,1) model using the entire sample. You can confirm your results from Table 5.1 on page 245.

(ii) Use the fitted model to calculate 1-step to 40-step ahead volatility forecasts for t from December 29, 2008 to December 31, 2010, i.e., σ²(l) for l = 1, . . . , 40.

(iii) Obtain conditional variance of the h-period log returns, i.e., σ²_t,h= ∑_l=1^hσ²(l) for h = 1, 5, 10, 15, 20, 25, 30, 35, 40 and for t from December 29, 2008 to December 31, 2010.

(iv) Calculate the annualized h-period volatility as σ_t,h,a = √(252/h)σ_t,h for h = 1, 5, 10, 15, 20, 25, 30, 35, 40.

(v) Plot annualized h-period volatilities that you obtained in the previous part. You can comfirm your results from Figure 5.3 on page 248.

Attachment:- datasets.zip

Reference no: EM131061212

Questions Cloud

Find the WACC-Common stock-Market and Debt : Find the WACC for ABC Corp using the information provided below. Common stock: 300,000 shares outstanding, selling for $30 a share. Beta is 0.85. Preferred Stock: 50,000 shares outstanding, selling for $65 a share. The stock pays a $5 annual dividend..

What is identity theft : 1. What is identity theft? Why is this a problem in society? 2. What is phishing? 3. What is the advertising technique of Glittering Generalities? Describe this technique.

Illustrate the arbitrage opportunities : And Referring to the result of above, illustrate the arbitrage opportunities that would exist if a portfolio called D with the following characteristics were observed:

Reported on an annualized basis : What is your capital gain/loss, which is defined as the dollar gain/loss relative to the price of the bond when you bought it? Recall that the compounding interval is 6 months and the YTM, like all interest rates, is reported on an annualized basi..

Build a time series model for the log earnings series : Build a time series model for the log earnings series. Perform model checking and write down the fitted model - Compare the two time series models. Which model is preferred in terms of fitting

Calculate the direct material price variance : Accelerator, Inc. manufactures a fuel additive called surge. Surge sells for $44 per container and the company produces and sells 80,000 containers per month. The company has established the following standards for each container of surge produced: C..

What are three lessons to be learned from this case study : Assume that you are the newly appointed city manager for the City of Sun-Ville. What overall action plan would your propose to the city council? What do you see as your three biggest challenges and why? What are your top three proposals?

Effective rent per square foot : The lease provides for two months of free rent at the end of the lease term. If the lease term is three years and the discount rate is 10%, what is the effective rent per square foot?

Fixed assets to support growth in sales : Fixed assets are $490,000 and sales are projected to grow to $900,000. Huo much in new fixed assets to support this growth in sales? Assume the company operates at full capacity.

User Account

All Pages