(30 points) Use the data below with STATA or R to solve. It contains 240 monthly...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(30 points) Use the data below with STATA or R to solve. It contains 240 monthly observations for a set of stocks. AT&T, GE, GAP, HD (Home Depot), IBM, and GM as well as a proxy for the market portfolio returns (market), and a proxy for the risk-free rate given by the 30-day T-bill rate (rf). (a) For each stock in the worksheet and using the whole span of data construct what are called the excess returns for your stock (by subtracting the risk-free rate from each stock). Now estimate a measure of how each stock commoves with the market return. For stock i, estimate the alpha and beta from the following: Tit = ai +Birmt + Uit (*) where it is the excess return of asset i at time period t and rmt is the excess market return at time period t. In (*), a is the alpha and ; is the beta associated with the i-th stock. (b) The SML version of the CAPM model says that stocks with higher betas should demand higher average returns. Plot the sample average excess asset return against the estimated betas (i.e. the B's). You should have a scatter plot with 6 points. (c) The CAPM model implies that the average returns on an asset should be completely explained by the asset's beta. Specifically, we have T = Yo + Yi + Eit where is the average excess return of the ith asset. (**) Estimate (**) where you regress the mean return of the excess returns on the corresponding estimated betas. In other words, you are simply fitting a regression line through the scatter plot in part (b). In (**), Y tells us the price (in excess return) that the market requires for holding the market risk . This model (and generalizations of it) are frequently used to describe differences in average returns across different assets. What do you observe in terms of the point and confidence interval estimates of yo and y ? (30 points) Use the data below with STATA or R to solve. It contains 240 monthly observations for a set of stocks. AT&T, GE, GAP, HD (Home Depot), IBM, and GM as well as a proxy for the market portfolio returns (market), and a proxy for the risk-free rate given by the 30-day T-bill rate (rf). (a) For each stock in the worksheet and using the whole span of data construct what are called the excess returns for your stock (by subtracting the risk-free rate from each stock). Now estimate a measure of how each stock commoves with the market return. For stock i, estimate the alpha and beta from the following: Tit = ai +Birmt + Uit (*) where it is the excess return of asset i at time period t and rmt is the excess market return at time period t. In (*), a is the alpha and ; is the beta associated with the i-th stock. (b) The SML version of the CAPM model says that stocks with higher betas should demand higher average returns. Plot the sample average excess asset return against the estimated betas (i.e. the B's). You should have a scatter plot with 6 points. (c) The CAPM model implies that the average returns on an asset should be completely explained by the asset's beta. Specifically, we have T = Yo + Yi + Eit where is the average excess return of the ith asset. (**) Estimate (**) where you regress the mean return of the excess returns on the corresponding estimated betas. In other words, you are simply fitting a regression line through the scatter plot in part (b). In (**), Y tells us the price (in excess return) that the market requires for holding the market risk . This model (and generalizations of it) are frequently used to describe differences in average returns across different assets. What do you observe in terms of the point and confidence interval estimates of yo and y ?
Expert Answer:
Related Book For
Fundamentals of Investments, Valuation and Management
ISBN: 978-1259720697
8th edition
Authors: Bradford Jordan, Thomas Miller, Steve Dolvin
Posted Date:
Students also viewed these finance questions
-
re Regular Languages and Finite Automata (a) Let L be the set of all strings over the alphabet {a, b} that end in a and do not contain the substring bb. Describe a deterministic finite automaton...
-
Miller-Rabin test to check whether a number N is composite. This will involve computing a N1 mod N for some value of a. [10 marks] Carry out the steps for N = 65 and a = 1, 2, 8 and 12. on what each...
-
Changing preferences can also affect changes in land use. In the United States, the proportion of the population in the 65-and-older age bracket is growing. What effects might this have on the...
-
Claire Hunter manages Sunshine Manufacturing. Hunter fears that a trusted employee has been stealing from the company. This employee receives cash from clients and also prepares the monthly bank...
-
How do you write a class whose objects can easily be printed on the console?
-
On October 1, 2017, Gordon borrows \($150\),000 cash from a bank by signing a three-year installment note bearing 10% interest. The note requires equal payments of \($60\),316 each year on September...
-
Xinhong Company is considering replacing one of its manufacturing machines. The machine has a book value of $ 45,000 and a remaining useful life of 5 years, at which time its salvage value will be...
-
3. Katelyn's financial manager invested her savings in a portfolio of shares that comprised of investments of $2000, $1800, and $3100 in the infrastructure, high- tech, and garment industries,...
-
The switch in the circuit shown in Figure 2 has been closed for a long time. The switch opens at t = 0. 31.25 F + VC 100 2 www 20 100V 80 02 www 1=0 Figure 2 200 mH + Vo io 4.a. Sketch a...
-
Refer to the information in Problem 18-31. Required: Do Problem 18-31 using the FIFO method of process costing. Data From Problem 18-31: The Seafood Company is a food-processing firm based in Maine....
-
Sam Calaginoe launched Dogfish Head Brewery in 1995. Although the company is now one of the U.S.s premier microbreweries, that wasnt always the case. When the company started, it was built stepby-...
-
Zynga is a social network game developer that develops browser-based games that work both stand-alone and as application widgets on social networking sites like Facebook and MySpace. What are the...
-
Jessica Martin, a classmate of yours, just returned from an entrepreneurship boot camp, which was sponsored by her universitys technology incubator and consisted of three days of intense focus on how...
-
Review the You Be the VC features for Chapters 10 through 14. Which of the companies featured is most likely to own intellectual property that other companies will want to license? Explain your...
-
1. What are some of the most common issues with deployment of HIDS in an organization with 1000s of computers? 2.As far as viruses are concerned, are we fighting a losing battle? Are there too many...
-
If the joint cost function for two products is C(x, y) = xy2 + 1 dollars (a) Find the marginal cost (function) with respect to x. (b) Find the marginal cost with respect to y.
-
Mr. Spice asks Mr. Myers how a fixed-income manager would position his portfolio to capitalize on his expectations of increasing interest rates. Which of the following would be the most appropriate...
-
Using the stock prices in Problem 3, calculate the exponential three-month moving average for both stocks where two-thirds of the average weight is placed on the most recent price. Data From Problem...
-
Ms. Barlow notices that the stock in the table above does not pay dividends. If the stock begins to pay a dividend, how will the price of the call option be affected? a. It will decrease. b. It will...
-
Souvenir Sales. The file SouvenirSales.csv contains monthly sales for a souvenir shop at a beach resort town in Queensland, Australia, between 1995 and 2001. [Source: Hyndman and Yang (2018).] Back...
-
Analysis of Canadian Manufacturing Workers Workhours. The time plot in Figure 18 . 22 describes the average annual number of weekly hours spent by Canadian manufacturing workers...
-
Toys R US Revenues. Figure 18 . 23 is a time plot of the quarterly revenues of Toys R US between 1992 and 1995 (thanks to Chris Albright for suggesting the use of these data, which are available in...
Study smarter with the SolutionInn App