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

Choice of Budget Flexing Basis The most suitable flexing basis must be considered where it assists in the comparison of alternative budget data at the planning stage and for

Standard Cost It is especially serious that you establish a link between standard budgets and costs. At this point, you require putting in your mind to standard costs one the

Describe the ways in which the needs of internal and external users of accounting information are the same and different.

Freshly Ground Investments have just made an investment of $550 000 in a new Toyota Hilux (with trailer) delivery vehicle. This vehicle will be used for deliveries and generate rev

Phelps Glass Inc. has reported the following financial data: net revenues of $10 million, variable costs of $5 million, controllable, fixed costs of $2 million, non-controllable fi

Accounting Treatment of Spoilage Costs 1) Normal Spoilage Costs: These costs are assigned to the good output utilizing two approaches as: (i) Omission Approach:  Under th

Direct material yield variance (MYV) :   It has been described by the ICMA, London, as 'the variation between the standard yield of the actual material input and the actual yi

An analysis of the fluctuations of current assets and current liabilities that is working capital describes that how the working capital has decreased or increased. We want to iden

Purpose of Cost Accounting Information Cost accounting is employed for a number of reasons, some of that are briefly described in the given points as: a) Accounting for co