Calculate monthly excess returns, Cost Accounting

Assignment Help:

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?


Related Discussions:- Calculate monthly excess returns

Compute the second years tax amortization, Smith Corporation purchased an i...

Smith Corporation purchased an intangible asset for $110,000. Compute the second year's tax amortization. The second year would be a full year's amortization. The company estimates

Inventory systems, Find a journal article online about just-in-time invento...

Find a journal article online about just-in-time inventory systems. In the subject line of your post, include the title of the article that you read. Post a link to that article wi

debt service fund and special revenue fund, For your assignment, discuss w...

For your assignment, discuss when the government and nonprofit organizations would use each of the following funds: Capital projects fund Debt service fund Special r

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

Organize the accounting entries, JK is a motor dealership which organizes i...

JK is a motor dealership which organizes its financial statements to 30 November. In the year to 30 November 2009, transactions integrated the following: (a) JK had motor vehicl

Business process mapping, Using some variation of business process mapping,...

Using some variation of business process mapping, graph out the mango concentrate supply chain focusing on when cost is added to the supply chain. (i.e. Display/draw the process

Compute the estimated value of inventory stolen at kji, The following are t...

The following are three independent situations where the reporting entity for which financial statements are being prepared are underlined. Every company has a December 31, 2012 ye

Difference between balance sheet and income statement, (i) Describe the di...

(i) Describe the difference between the balance sheet and the income statement in financial statements of companies. (ii) Give two examples of intangible assets and two exampl

Purpose, what are the purposes of cost accounting

what are the purposes of cost accounting

Calculate the economic profit and relevent cost, A. Bolero Industries Ltd. ...

A. Bolero Industries Ltd. has been approached by a customer who would like a special job to be done for her, and is willing to pay $60,000 for it. The job would require the followi

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd