Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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?
Labour Costs and Overhead costs Labour Costs Labour costs can be indirect or direct labour costs. Direct labour cost refers to wages paid to workers who such are directly
Labour Costs Definition of Labour Cost A labour cost refers to all the costs incurred in compensating the human resources used in the production process to provide a us
The use of standard costs can present a number of potential problems or disadvantages. Most of these problems result from improper use of standard costs and the management by excep
Waylander Coatings Company purchased waterproofing equipment on January 6, 2013, for $320,000.The equipment was expected to have a useful life of four years, or 20,000 operating ho
Critical Thinking about Cost Flow It is simple to overlook an important aspect of cost flow within a manufacturing operation. If you see that have taken note of an important co
Amy earns $35,000 working part time. Consequently, she is not eligible to participate in her employer's retirement plan or health insurance program. Amy's expenses are summarized a
what are the features of uniform costing
Material Costs - Cost Accumulation However 'Materials' refer to the tangible inputs into the procedure of producing useful output. They might be indirect materials or direct
A company produces three types of items. A single machine is used to produce the three items on a cyclical basis. The company has the policy that every item is produced once during
Wayne Company's beginning and ending inventories for the month of June were as follows: June 1 June 30 Work in progress $145,000 171,000 Finished Goods 85,000 78,000 Production
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd