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

Please provide a recommendation, Your client has asked you to evaluate an i...

Your client has asked you to evaluate an investment project for her using what you have learned in school regarding the net present value method. The project will run for eight yea

Explain break-even analysis, Q. Explain Break-even analysis? ...

Q. Explain Break-even analysis? Cost-volume-profit (CVP) analysistracks that how profit changes when there are changes insales price, variable costs, fixed c

Help, ) Ialani Corp. uses a job order costing system for the yachts it cons...

) Ialani Corp. uses a job order costing system for the yachts it constructs. On September 1, 2010, the company had the following account balance: Raw material inventory 332400 Wo

Compute the net cash used (provided) by financing activities, Martinez Corp...

Martinez Corporation engaged in the following cash transactions during 2012. Sale of land and building $186,710 Purchase of treasury stock 42,130 Purchase of land 39,130

Calculate the primary deficit, Assume B, G and T are in real terms (and in ...

Assume B, G and T are in real terms (and in billions of dollars). B t-1  = 1000      G t = 220           T t = 200            i t   = .15     π t   = . 10 a) Calculate th

Marginal cost curves, A firm operates two plants with the marginal cost cur...

A firm operates two plants with the marginal cost curves given by MC 1 = 50 + 2Q 1 , MC 2 = 90 + Q 2 . If the firm's total output must be 80 units, how much will it produce a

Determine how much to stock, Determine how much to stock 1. Employ The...

Determine how much to stock 1. Employ The Economic Order Quantity Model This is an easiest model which helps the manager to find out the optimum quantity of stock to order

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