In this exercise you will familiarize yourself with index models, beta and CAPM estimation. Download the spreadsheet data_question3.xlsx from Sakai and use the data contained therein to answer Question 3. Spreadsheet data_question3.xlsx contains monthly stock returns for AT&T, Ford, Google and Exxon Mobile. Additionally, it contains monthly returns on Treasury securities and a broad market index. Be careful to calculate monthly excess returns over Treasuries as this is what you will need for estimating single index models.

a)  In class we have discussed how index models can be  used to separate firm-specific risk and market risk inherent in a firm's expected returns. What is the analytical formula to separate a security's risk into market risk and firm specific risk?
 
b)  Using excess returns over Treasuries, estimate the beta coefficients for AT&T, Ford, Google and Exxon Mobile without running a regression model. Additionally, using your result from part (a) estimate the  standard deviation for each firm's expected return and estimate each  firm's market risk component and firm-specific risk component. (Again use excess returns over Treasuries) Use the Excel functions STDEV.S and COVARIANCE.S for this exercise. Tabulate your results in the write-up as follows:

c)  Describe and interpret your results in the single-index model sense. i.e. how each stock moves with the overall market and which stock is the riskiest for a diversified investor? How does beta relate to the market risk component and how does it relate to the firm specific component?
 
d)  Suppose you want to construct a portfolio consisting of AT&T, Ford, Google and Exxon that exhibits minimal movement with the overall market, i.e.  = 0. Using Microsoft Excel Solver calculate the weights such that  is minimized under the constraint

β = 0. (Use excess returns over Treasuries for your calculations). Break  up into market risk and firm-specific risk. Would you have eliminated all risk by only holding this portfolio of stocks?

Posted Date: 2/28/2013 6:02:53 AM | Location : United States

Ask an Expert

Related Discussions:- Calculate monthly excess returns, Assignment Help, Ask Question on Calculate monthly excess returns, Get Answer, Expert's Help, Calculate monthly excess returns Discussions

Write discussion on Calculate monthly excess returns
Your posts are moderated

Write your message here..

Related Questions

What is the marginal cost, Marginal Cost (MC): The marginal cost of an a... Marginal Cost (MC): The marginal cost of an additional unit of output is the cost of the additional inputs required to make that output. More formally, the marginal cost is the

Prepare a partial income statement, Timbatown Pty Ltd is a manufacturer of ... Timbatown Pty Ltd is a manufacturer of timber tables and chairs. The company mostly sells on a retail basis to household consumers, but occasionally receives large orders for table

Stores layout and location - material handling, Stores layout and location ... Stores layout and location - Material Handling The layout of stores must ensure as a) For movement of material, ease of access out and in of stores b) The issue of peris

Cost drivers and predictors, why is determining the cost to manufacture a p... why is determining the cost to manufacture a product quite a different activity from determining how to control such cost?

the plantwide variable manufacturing overhead rate , Automotive Products  ... Automotive Products  (AP)  designs, manufactures,  and  sells  automotive  parts.  It  has  3 main operating departments: design, engineering, and production.  1.Design  ñ  the

Marginal costing, MARGINAL COSTING As per the Chartered Institute of Ma... MARGINAL COSTING As per the Chartered Institute of Management Accountants, London, the phrase 'Marginal cost' means - 'the amount at every given volume of output through which

Motivation - behavioural aspects of standards, Motivation - Behavioural Asp... Motivation - Behavioural Aspects of Standards Variance analysis and standards setting requires to be carried out like it motivates managers and other employees. It should not

COST BUDGET ON ANNUAL DAY., SOLUTION FOR COST BUDGET ON ANNUAL DAY SOLUTION FOR COST BUDGET ON ANNUAL DAY

Draw the optimal expansion path of the firm, A firm uses capital and labor ... A firm uses capital and labor to produce a single output good. The production function is given by F(K, L) = K 2 L where K is the amount of capital and L is the amount of labor em

Standards on motivation, ADescribe the impact of different types of standar... ADescribe the impact of different types of standards on motivations, and specifically, the likely effect on motivation of adopting the labor standard recommended for Geeta & Compan