Calculate monthly excess returns, Cost Accounting

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







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
Related Questions
Limitations of Budgeting 1. Too mush reliance may reason resistance or inflexibility to change. 2. Difficult to set levels of attainment. It may result into too tight budg

An industrial drill costs $60.000 to purchase and $10,000 to install seven years ago. The market value now is $33.000 and this will decline by 12% of current value each year for th

CONTRIBUTION : It is the variation between the marginal cost of sales and sales and it contributes towards fixed profit and expenses.  It is differ from the profit which is the net

what are the factor for setting costing for a certain machining job

Tlie subphylum is called Uniramia because of the presence of unbranched appendages. These animals have non-jointed mandibles, uubranched appendages without any palps. They have

The follow data relates ot year 20XX for Plano Manufacturing Company: Units produced - 2,000 Units sold - 1,800 Selling price - $200 / per unit Direct material costs - $80,000 Dir

what is accounting treatment for material losses due to abnormal reasons

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

In an application of a hand-held clinical thermometer for the National Health Service it is required to use disposable temperature sensors and digital read out of temperature betwe

What are the reasons of preparing income statement?