Calculate monthly excess returns, Cost Accounting

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?

Posted Date: 2/28/2013 6:02:53 AM | Location : United States







Related Discussions:- Calculate monthly excess returns, Assignment Help, Ask Question on Calculate monthly excess returns, Get Answer, Expert's Help, Calculate monthly excess returns Discussions

Write discussion on Calculate monthly excess returns
Your posts are moderated
Related Questions
Vintage Auto Company manufactures parts to order for antique cars. Vintage Auto makes everything from fenders to engine blocks. Each customer order is treated as a job. Vintage Aut

When implementing ABC, once a company has identified business activities and their costs, the company will probably: A) determine a simplified single cost allocation rate B)

The Gladys Corporation buys office equipment costing $426,000 on May 12, 2013. In 2015, new and improved models of the equipment make it obsolete, and Gladys sells the old equipme

Cost Element Stage 1. Cost Elements The raw data concern with Labour, Expenses, and Materials are gathered from Invoices, Payroll, and Requisitions and Goods Issued Notes

Your firm is the auditor of Easy Hire Pty Ltd (Easy Hire).the company hires out equipment to industries such as construction, engineering & event management. It has 76 branches nat

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

Incremental Costs as Relevant Costs An incremental cost is specifically incurred with the following a course of action and ignorable if such action is not implemented. It cont

Relationship among management accounting and cost accounting Referring to CIMA's definition for cost accounting, we can determine cost accounting is a part of management accou

An analysis of the fluctuations of current assets and current liabilities that is working capital describes that how the working capital has decreased or increased. We want to iden

Standard Costs Establish the Minimum Desirable Costs When actual costs incurred exceed or else are below the standard costs, we after that investigate the variances along with