Calculate the monthly specific returns

Assignment Help Finance Basics
Reference no: EM131003296

Question 1:

(a) Check the Q1a tab in the Excel spreadsheet that provides the summary statistics of 84 regressions based on cross-sectional data for each month between January 2001 and December 2007. The following summary statistics are shown in the spreadsheet:
• multipleR
• R-square
• adjusted R-square
• standard errora
• significance of F.
Define each of the above terms and interpret each of the statistics in regards to the data over the time period from January 2001 to December 2007.

(b) (i) Consider the following notations:
Ri = return of stock i for a particular month
Xi1 = exposure of stock i to the constant unit of 1
Xi2 = exposure of stock i to the size
Xi3 = exposure of stock i to the momentum
Xi4 = exposure of stock i to the value
f1 = the intercept term
f2 = the regression coefficient of size
f3 = the regression coefficient of momentum
f4 = the regression coefficient of value.

Complete the formula for the specific returns (or residual term) of stock i for a particular month,Ui, given the information above and the linear regression model. What do the specific returns attempt to measure?

(ii) Calculate the monthly specific returns (i.e. the residuals of the regressions) for CBA, WES and BHP for the 84-month in-sample period. To do this calculation, use the formula derived from part (i), the data given in the notations in part (i), and the data in the ‘Q6b' tab of the Excel spreadsheet.

From your Excel results, paste a copy of the specific returns for CBA, WES and BHP forthe months of January 2001 and December 2007onlyin the Word document of your assignment (and in the format below).

Month

CBA

WES

BHP

Jan. 2001

 

 

 

Dec. 2007

 

 

 

(c) Calculate the historical variance of the monthly specific returns for CBA, WES and BHP for the 84 month in-sample period.
Note: The specific returns are assumed to be uncorrelated so that the off-diagonal elements of the covariance matrix are zero.
From your Excel results, paste a copy of the monthly specific returns covariance matrix for CBA, WES and BHP in the Word document of your assignment (and in the format below).

 

Monthly specific returns covariance matrix

 

CBA

WES

BHP

CBA

 

 

 

WES

 

 

 

BHP

 

 

 

See the ‘Q1c-d' tab of the Excel spreadsheet.

(d) From your Excel results, paste a copy of the annualised specific returns volatilities for CBA, WES and BHP in the Word document of your assignment (and in the format below). See the ‘Q1c-d' tab of the Excel spreadsheet.

 

Annualised specific returns volatility

 

CBA

WES

BHP

CBA

 

 

 

WES

 

 

 

BHP

 

 

 

Question 2:

Answer the questions below, providing reasons and valid arguments to demonstrate your understanding of regression limitations and how to manage them in practice.

(a) Describe the four (4) conditions that must be satisfied for a regression analysis to be valid.

(b) Describe two (2) ways of dealing with heteroscedasticity.

(c) Calculate the rolling 12-month volatility of price returns for each of the 10 stocks over the in sample period using data in the ‘Q7' tab in the Excel spreadsheet.

Note:The rolling 12-month volatility at any month is the annualised standard deviation using the monthly returns of the preceding 12 months.

Save your Excel workings for part (c) as a tab labelled ‘2c'.

(d) Draw a graph of the results in part (c).Based on the graph, describe the relationship between volatilities of stocks over time.
(e) Explain the Durbin-Watson test and how its results should be interpreted.
(f) Why would a transformation of the dependent variable be used?
Describe what sorts of transformations are commonly used.
(g) Explain four (4) steps in a backward elimination stepwise regression approach.

Question 3

Use Figure 1 to answer the questions below.

1208_Explain how volatility is measured.jpg

Figure 1

(a) (i) What does Figure 1 depict and what is the financial name or description given tothediagram?

(ii) Which portfolio (A or B) would be preferred and why?

(b) Explain how volatility is measured with respect to Figure 1.

(c) (i) A portfolio manager decides to allocate superannuation funds of their recent clients who are more risk averse than average. What would the portfolio manager need to do to achieve this outcome?

(ii) Briefly state where this portfolio of assets would be represented with respect to Figure 1.

Question 4:

Assume that we have estimated the following AR(1) model:

Xt = 0.0825 + 0.7654Xt - 1 + et

Furthermore, assume that the current level of X is 0.4968.

(a) Forecast the value of X at time 1 (X1) and time 4 (X4).

(b) Which of these two forecasts is likely to be more reliable? Why?

(c) What is serial correlation? How do we test for its presence in this model?

(d) What is the mean reverting level of this model? What does this mean?

Attachment:- FIN201.xlsx

Reference no: EM131003296

Questions Cloud

Why does the firms supply curve slope up in the short run : Why does the firm’s supply curve slope up in the short run (i.e. what assumption is employed to argue that the supply curve slopes up in the short run)?
Determining a model for career development : Your Task: The Human Resource Manager for your branch has noticed that the current branch Standard Operating Procedure (SOP) is outdated. You have been assigned the task of determining a model for both career development and career counseling at ..
Pick a health-related organization and study its website : There are many sites on the Internet that have information on healthcare and health information technology. Pick a health-related organization and study its website. Prepare a 1-2 paper describing the information and resources found on the site. E..
What the benefits of having a flexible budget : What the benefits of having a flexible budget? What are some of the downsides of having a flexible budget? Do you think the budget busters are accurate? Why or why not
Calculate the monthly specific returns : Calculate the monthly specific returns (i.e. the residuals of the regressions) for CBA, WES and BHP for the 84-month in-sample period -  Calculate the historical variance of the monthly specific returns for CBA, WES and BHP for the 84 month in-sampl..
Why is stock-based compensation added to net income : How is the undelivered portion of Microsoft's sales of Windows XP Professional recorded initially?
How many em iterations are needed for convergence : How many EM iterations are needed for convergence? Plot a contour plot of your final GMM pdf. Overlay the contour plot with a scatterplot of the data set.
Spring 2002 exam : Ten years ago, an advertising agency took a random sample of 20 personal computer owners who used brands such as Dell, Gateway, Hewlett-Packard, etc. At the time, the agency recorded a satisfaction score, with a maximum of 100 possible points.
Do you feel that the tools and technologies are appropriate : Then, review the tools and technologies posted by your classmates. Imagine that you were going to be tasked to assist them with their project. Based on their recommendations, do you feel that the tools and technologies are appropriate? Would you r..

Reviews

Write a Review

 

Finance Basics Questions & Answers

  If british pounds sell for 150 us per pound what should

if british pounds sell for 1.50 u.s. per pound what should dollars sell for in pounds per

  Determine significant benefit to an organization

Determine one significant benefit to an organization that decides to lease an asset that conventional lease analysis evaluation reveals has a negative Net Advantage to Leasing (NAL). Provide a real-life scenario that supports your answer.

  Te bonds mature in 11 years and have 1000 face value

bonds issued by stainless tubs bear an 8 coupon rate payable semiannually. the bonds mature in 11 years and have a

  Compute the future values of a an initial 2000 compounded

future value. compute the future values of a an initial 2000 compounded annually for 10 years at 8 percent b an

  Consider another all-equity firm

Consider another all-equity firm that does not pay taxes due to large tax loss carry-forwards from previous years. The personal tax rate on interest income is 15 percent, and there are no costs of financial distress.

  Finding the bond value

What was your average annual capital gains yield over the past three years on this bond ('07-'10)? Note: just find the capital gains yield, not the "total" yield.

  Sharpe products has 1 million outstanding shares and 7

sharpe products has 1 million outstanding shares and 7 directors to be elected. cumulonimbus holdings owns 200000

  How much money can be loaned now if 6000 is to be repaid at

1 you deposit 2000 in a savings account that earns 8 simple interest per year. how many years will it take to double

  How would this breech affect the valuation of the stock

When a company has a formal Ethics Policy and does something contrary to that policy, what impact might it have on the value of the stock, the employees, investors, regulators, and other stakeholders? How would this breech affect the valuation of the..

  What was the firm eat in 2009

Slattery Corp had year-end retained earnings balances of $670,000 in 2008 and $600,000 in 2009. In 2009 the firm paid $6,000 in preferred dividends and $10,000 in common dividends. What was the Firm's EAT IN 2009?

  The real rate of return carl foster a trainee at an

the real rate of return carl foster a trainee at an investment banking firm is trying to get an idea of what real rate

  Assume that a firm with a 35 percent tax rate receives

a firm that owns the stock of another corporation does not have to pay taxes on the entire amount of dividends

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd