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

Required the research of the statement of cash flows, This question tested ...

This question tested their knowledge of intended reporting but more importantly requisite them to apply their knowledge and consider the impact from the investors' perspective.

Costing, costing in respect of mathematical accounting a research project.

costing in respect of mathematical accounting a research project.

Last in first out or lifo, Last in first out or LIFO LIFO is based upo...

Last in first out or LIFO LIFO is based upon the assumption such the stock purchased last is issued first. Stock valuation should here be based upon the prices ruling on acqui

Purpose of cost accounting information, Purpose of Cost Accounting Informat...

Purpose of Cost Accounting Information Cost accounting is employed for a number of reasons, some of that are briefly described in the given points as: a) Accounting for co

Calculate the ß, Calculate the β of Maine Corporation from the following da...

Calculate the β of Maine Corporation from the following data. The prices are at the beginning and at the end of each year     Normal 0 false false

Accounting for labour costs, Accounting for Labour costs We will conta...

Accounting for Labour costs We will contain an overview of accounting for labour costs as: a) Gross Earnings It is illustrated as item A that appears like a credit i

Straight line method, Assume that $140,000 of Denham Springs school dostric...

Assume that $140,000 of Denham Springs school dostrict 8% bonds are sold on the bond issue date for $128,598 interest is payable semiannually, and the bonds mature in 15 years. The

Identify the income statement and balance sheet, In January 2012, the manag...

In January 2012, the management of Stefan Company concludes that it has sufficient cash to permit some short-term investments in debt and stock securities. During the year, the fol

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