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

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

Trypanosoma, Place a prepared slide of Trypunosoma under tlic microscope an... Place a prepared slide of Trypunosoma under tlic microscope and focus it under low power, You will observe large number of tiny spindle-shaped trypanosomes lying in the plasma alll

Cost Estimation, On a New product development process of making a new S3 ST... On a New product development process of making a new S3 STORAGE SIM card phone storage device for end users, forecast the following With full working and tabulations; a) With fu

Qualitative characteristic of understandability means, The enhancing qualit... The enhancing qualitative characteristic of understandability means that information should be understood by a those who are experts int eh interpretation of financial informat

Current funding availability, 1. The Initial Borrowings required are determ... 1. The Initial Borrowings required are determined by the amount required to start  the project less the Cash Invested by the Corporation.  The loans will always be principle & inte

Prepare a properly classified cash flow statement, Prepare a properly class... Prepare a properly classified Cash Flow Statement for Sports Enterprises Ltd for the year ended 31st December 2011. Note that the Closing Cash at Bank Balance at 31st December 2011

Amortization of bond premium for the year, on the first day of the current ... on the first day of the current fiscal year $2,000,000 of 10 year 7% bonds with interest payable annually, were sold for $2,125,000. Present enteries to record the following transa

Evaluate outstanding balance, Winston Duff is planning to borrow $225,000 ... Winston Duff is planning to borrow $225,000 to purchase a new home. Mr. Duff is considering two fixed-rate financing alternatives offered by Horsepen Creek State Bank. The first

Budgeted and actual fixed costs per month , Using  the  information below, ... Using  the  information below, list profit statements  for June and July using  (a) margin costing and (b) absorption costing. A company produces and sells 1 product only which

Physical measure and net realizable value, Physical Measure and Net Realiza... Physical Measure and Net Realizable Value Physical Measure/Unit Joint costs are assigned to the joint products according to the ratio of physical measurement of the outpu