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

Bird house, Develop costing for the production units to explain the manufac...

Develop costing for the production units to explain the manufacturing expenses that the proposed product will require for the first year of production. This portion requires the fo

Activity Based Costing, How do I figure the estimated activity and estimate...

How do I figure the estimated activity and estimated allocation base?

Break-even chart, Break-Even Chart This is a diagrammatic presentation...

Break-Even Chart This is a diagrammatic presentation of the relationship among costs, prices, expenses and the sales volume. A break-even chart expresses revenue and expens

Realized gain or loss on the exchange, Pauline's Pastry Shop decides to rem...

Pauline's Pastry Shop decides to remodel its offices this year. As part of the remodeling, Pauline's trades furniture with a cost of $12,000 that had been expensed in the year of p

Jobwork, elements for jobwork COST SHEET

elements for jobwork COST SHEET

Presentation & Essay, Why are the main contribution teams can make to an or...

Why are the main contribution teams can make to an organisation? What are the conditions necessary in organisations if people are to work effectively in teams? * Describe what tea

Applications of marginal costing, what is the importance and assumptions of...

what is the importance and assumptions of application of marginal costing

Semi variable costs, Semi Variable Costs Are costs along with both a f...

Semi Variable Costs Are costs along with both a fixed and variable cost component? The fixed component is such portion that is constant irrespective of the level of activity.

Bases of cost classification, Bases of Cost Classification These vario...

Bases of Cost Classification These various bases of cost classification are summarized in the diagram underneath as: Here, we will usually refer to either of these ter

Alternative cost, Mission Foods produces two flavors of tacos, chicken and ...

Mission Foods produces two flavors of tacos, chicken and fish, with the following characteristics: Chicken Fish Selling price per taco $3.00 $4.50 Variable cost p

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