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

Calculate the pay back period after tax cash flows, An investment alternati...

An investment alternative in a project requires a capital cost of $102 millions completed at time zero. The investment will produce a stream of revenue of $50 millions per year ove

Cost-plus pricing, Computation of mark up and Target selling price in cost-...

Computation of mark up and Target selling price in cost-minus pricin

Determine the interest expense is deductible, Assume the same facts as in 1...

Assume the same facts as in 1A above, except that the interest payment checks were placed on the shareholders' office on December 31, 2012. However, the shareholders are not in the

Assignment Choice #2: Accounting for Byproducts (Quantitativ, Pyramid Print...

Pyramid Printing Company is a printer of magazines and retail inserts. In addition, there are two joint products (food wrapping and book covers) and one byproduct (shipping-box ins

Cost accounting, raw an organization chart of any actual or hypothetical ma...

raw an organization chart of any actual or hypothetical manufacturing organization to show the position of management/cost accounting department within an organization and discuss

Accounting records - nature and purpose of cost accounting, Accounting Reco...

Accounting Records - Nature and Purpose of Cost Accounting The quantitative information employed in the management and cost accounting systems can be obtained from with two ac

Analysis of fund flow and cash flow statements, After you have studied this...

After you have studied this section, you should be capable to: know the idea of funds flowing by a business in a dynamic situation understand the role of working capital

cost behavior, Total fixed cost at different level of productio

Total fixed cost at different level of production

Find the breakeven discount rate, The government of a small South Pacific i...

The government of a small South Pacific island is considering whether to allow development of a small but valuable deposit of phosphate rock. Not having the resources to develop an

Calculate the approximate yield to maturity of the bonds, Netflix Inc wants...

Netflix Inc wants to issue discount bonds with a market value equal to 45% of their face value. The income tax rate of Netflix is 30%. The bonds will carry 3.5% coupon, paying inte

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