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

Unit or output cost, explain one operation: unit or output cost explain one operation: unit or output cost

Determine the cost that changes in total proportionately, Presented below i... Presented below is a list of terms relating to cost behavior, followed by definitions of those terms: a. Rent on a factory building b. Engineering approach c. Fixed cost

Statements on tax standards, Compare the American Institute of CPAs' (AICPA... Compare the American Institute of CPAs' (AICPA) Statements on Tax Standards (SSTS) and the Treasury Department Circular 230 rules to practice before the Internal Revenue Service (I

Scope of cost accounting, short note short note

average number of callers waiting, Radovilsky's Department Store in Haywoo... Radovilsky's Department Store in Haywood, California, maintains a successful catalog sales department in which a clerk takes orders by telephone. If the clerk is occupied on one li

What does the cost principle, What does the cost principle mean for a compa... What does the cost principle mean for a company's income statement?

Principles of marginal costing, Principles of Marginal Costing The pri... Principles of Marginal Costing The principles of marginal costing are as given: 1. Period fixed costs are similar, for any volume of sales and production provided suc

Balance sheet and assuming monthly amortization of patents, Nieland Industr... Nieland Industries had one patent recorded on its books as of January 1, 2014. This patent had a book value of $288,000 and a remaining useful life of 8 years. During 2014, Nieland

Credit sales method, What are the journal entries to recognize each of the ... What are the journal entries to recognize each of the below events. a.   The firm records bad debt expense of 5% of credit sales, which were $300.  The firm uses the Percentage

Absorption costing and marginal costing, Absorption Costing and Marginal Co... Absorption Costing and Marginal Costing Product costs are costs identified along with goods produced or purchased for resale. That costs are initially identified like part of