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

Cost sheet, Marple Associates is a consulting firm that specializes in info...

Marple Associates is a consulting firm that specializes in information systems for construction and landscaping companies. The firm has two offices-one in Houston and one in Dallas

Calculate the loss in consumer surplus, (a) Calculate the number of US impo...

(a) Calculate the number of US imports with and without the tariff. (b) Calculate the dead weight loss of the tariff. (c) Calculate the loss in consumer surplus resulting fro

Standard costing and variance analysis using kaizen costing, Discuss how SD...

Discuss how SD can use standard costing and variance analysis to prepare meaningful reports when using Kaizen Costing. By the use of standard costing and variance analysis, fr

Cost accounting as a service activity, critically explain cost accounting a...

critically explain cost accounting as 1. a service activity 2. a descriptive/analytical discipline 3. an information system

Evaluation of discount rates, Does it make sense for PP's management to use...

Does it make sense for PP's management to use so many discount rates in its evaluation? Explain. What additional information would you like to have to make a more informed decis

Calculate development cost, Candler Inc a computer software development fir...

Candler Inc a computer software development firm has stock outstanding as follows: 40,000 shares of $2 nonparticipating, noncumulative preferred stock of $10 par, and 250,000 share

Determine the net present value of proposed project, A foreign company plan...

A foreign company plans to clear several dozen acres of ecologically valuable mangrove swamp in Vietnam for the creation of a shrimp aquaculture facility.  This decision will creat

Vorticella, Vorticella can first be seen by the naked eye, b.ut to study it...

Vorticella can first be seen by the naked eye, b.ut to study it place a prepared slide under the microscope. Focus it under low power, and observe it. You can see a large number of

Regression analysis, what is regression analysis and its applicability to t...

what is regression analysis and its applicability to the course of cost accounting

Prepare an amortization table, On January 1, 2012 Morgan's Motors issued $5...

On January 1, 2012 Morgan's Motors issued $500,000 of 3-year, 8% bonds when the market yield was 6%. The bond agreement stated that compounding was semi-annual with payments due on

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