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

What profit is earned by each firm, Three oligopolists, A, B and C, produce...

Three oligopolists, A, B and C, produce an identical product, Q. Q is produced under conditions of constant costs, that is, AC = MC = $100. The market demand schedule for Q is:

Actual operating cost method, On May 9th, David paid $34,500 (including sal...

On May 9th, David paid $34,500 (including sales tax) to purchase a used Audi A8 that he uses 90% of the time for business. No trade-in was involved. David uses the actual operating

Disadvantages of using standard costs, Purposes of standard cost accounting...

Purposes of standard cost accounting connection - suppose you were a management consultant and the client asked you the advantages and disadvantages of using standard costs and cos

Cost variance and schedule variance, (i) In terms of cashflow, which month ...

(i) In terms of cashflow, which month will be the most costly for your project? (ii) If the 3rd and 4th months are more expensive by 25% each because the outsourced labour took

Accounts payable, Accounts Payable or sundry creditors are generally unsecu...

Accounts Payable or sundry creditors are generally unsecured debts owed through the firm. These are also considered to as payables on open accounts. They may not be evidenced throu

Commodities to stock, Commodities to Stock Employ Material Req...

Commodities to Stock Employ Material Requirement Planning From the Master Production Schedule the manager has determined such the products to be produced. A

Assessment item 2, rocess costing Prepare a spreadsheet to solve the follow...

rocess costing Prepare a spreadsheet to solve the following process costing problem. Review the four process costing videos provided in Interact Resources. Note that in the situati

Case study, what could it cost the fezas to launder?show your detailed culc...

what could it cost the fezas to launder?show your detailed culculation

How many pizzas must vince''s sell to break even, Vince's Pizza delivers pi...

Vince's Pizza delivers pizzas to dormitories and apartments near a major state university. The company's annual fixed costs are $48,000. The sales price averages $9, and it costs t

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