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
. Which of the following is a reason why traditional product costing techniques have become obsolete in a lean operating environment? a. More complex accounting is required in a le

what is the classification of cost & how it is done?

Kenner company produces two products: SR200 and TX500. Budged sales for four months are as follows; SR200 TX500 May 8,000 20,000 June 13,000 32,000 July 11,000 39,000 August 18,000

I would like to know the solution on this one.

Surplus Stores Ltd is a company which frequently buy goods in large quantities and makes alterations to the goods before selling. At 31 Dec 2000 the following items were included i

General Motors has to raise new capital in one of the following three ways. Using the income tax rate of 32%, find the after-tax cost of new capital in each case. (A) Sell commo

Amy earns $35,000 working part time. Consequently, she is not eligible to participate in her employer's retirement plan or health insurance program. Amy's expenses are summarized a

Marvin's Motors Company (MMC) manufactures outboard motors for use on small to medium sized boats. MMC produces three models: the Standard, the Deluxe and the Performance. The comp

Prepare Cash Budget of a Company The given information concerned to the proposed budget for a company for the months ending on 31 December 1996. Additional Information

what is the implication of applying accounting principle wrongly