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

Contract accounts - contract costing, Contract Accounts It is a separa...

Contract Accounts It is a separate account such is maintained and opened for every contract undertaken for the reasons of accumulating cots.  Every contract is given a number

Making variance analysis more meaningful, Making Variance Analysis More Mea...

Making Variance Analysis More Meaningful To compose variance analysis as useful aid to management is the main objective of variance calculations.  However this can only be don

Allocation of service department costs, Allocation of Service Department Co...

Allocation of Service Department Costs Allocation of Service Department Costs to Production departments ,Service departments are those departments that provide support to prod

Which of the four types of costs would include direct labor, Which of the f...

Which of the four types of costs would include Direct Labor? A. Unit-Level B. Batch-Level C. Product Sustaining D. None of the above

Absoption costing, 2001 2002 sale 3200 units 3500 uni...

2001 2002 sale 3200 units 3500 units selling prise Rs.60 Rs.65 unit produced 3400 units 3600 units direct metrial Rs 23 25

prepare a simple balance sheet, Assume that Banc One receives a primary de...

Assume that Banc One receives a primary deposit of $1 million. The bank must keep reserves of 20 percent against its deposits. Prepare a simple balance sheet of assets and liabilit

Describe the costing system, Go the Hershey website to learn how to make He...

Go the Hershey website to learn how to make Hershey chocolate. (There is also a "print friendly" version of the chocolate making process at the end of the video.) Review the proces

Sanford charge to expense during 2013, In January, 2008, Sanford Corporatio...

In January, 2008, Sanford Corporation purchased a patent for a new product for $1,200,000. The patent was valid for fifteen years but it was estimated to have a useful life of ten

Variance, It is important to have performance measures to evaluate managers...

It is important to have performance measures to evaluate managers as they control resources and invest in assets for the company. Describe how you could use different variances (ac

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