1. Download 10 years worth of end-of-month prices from Yahoo Finance* for the following tickers: MSFT,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Download 10 years worth of end-of-month prices from Yahoo Finance* for the following tickers: MSFT, C, F, XOM, DUK For MSFT, you can use the link https://finance.yahoo.com/quote/MSFT/history. Do the same for the S&P 500 Index, using the link https://finance.yahoo.com/quote/%5ESP500TR/history. Use the link https://fred.stlouisfed.org/series/TB3MS to download the three-month Treasury bill secondary market rate. 2. Extract the Adjusted Close price from the data you downloaded in 1. and create a table with a column for each of the tickers and the index. The rows should contain the prices for each of the dates in the dataset. Add another column for the three-month Treasury bill. Note that the rate given for the three-month Treasury bill is an annualized rate, so you may need to convert it to a monthly rate. 3. Compute the monthly Percentage Returns for the index and stocks. 4. What are the average returns and standard deviation for the last year, 3 years, 5 years, and 10 years? 5. Use the formula Rt-Rft = a +B[RMt-Rft] + Et to estimate the value of 3 using a regression. Here R is the return on the stock and R is the risk-free rate for the same period. RMt is the return on t a stock market index (in this case the S&P 500 index). ; is the regression intercept, and B is the slope (and the stock's estimated beta). E represents the residuals for the regression. t The intercept, X, is often called simply "the alpha". What does it measure? If an asset has a positive alpha, where would it plot with respect to the SML? What is the financial interpretation of the residuals in the regression? 6. Compute the beta for each of the stocks using 12, 36, and 60 months. Are there any differences? If so, why? Compare the results you obtained for 36 months with those available online. Are there any differences? If so, why? * One of the reasons to use Yahoo Finance is that the prices given in the Adjusted Close column are adjusted for dividends and stock splits. This is not the case with many other online services, so one must be careful to manually adjust prices when working with other data sources. 1. Download 10 years worth of end-of-month prices from Yahoo Finance* for the following tickers: MSFT, C, F, XOM, DUK For MSFT, you can use the link https://finance.yahoo.com/quote/MSFT/history. Do the same for the S&P 500 Index, using the link https://finance.yahoo.com/quote/%5ESP500TR/history. Use the link https://fred.stlouisfed.org/series/TB3MS to download the three-month Treasury bill secondary market rate. 2. Extract the Adjusted Close price from the data you downloaded in 1. and create a table with a column for each of the tickers and the index. The rows should contain the prices for each of the dates in the dataset. Add another column for the three-month Treasury bill. Note that the rate given for the three-month Treasury bill is an annualized rate, so you may need to convert it to a monthly rate. 3. Compute the monthly Percentage Returns for the index and stocks. 4. What are the average returns and standard deviation for the last year, 3 years, 5 years, and 10 years? 5. Use the formula Rt-Rft = a +B[RMt-Rft] + Et to estimate the value of 3 using a regression. Here R is the return on the stock and R is the risk-free rate for the same period. RMt is the return on t a stock market index (in this case the S&P 500 index). ; is the regression intercept, and B is the slope (and the stock's estimated beta). E represents the residuals for the regression. t The intercept, X, is often called simply "the alpha". What does it measure? If an asset has a positive alpha, where would it plot with respect to the SML? What is the financial interpretation of the residuals in the regression? 6. Compute the beta for each of the stocks using 12, 36, and 60 months. Are there any differences? If so, why? Compare the results you obtained for 36 months with those available online. Are there any differences? If so, why? * One of the reasons to use Yahoo Finance is that the prices given in the Adjusted Close column are adjusted for dividends and stock splits. This is not the case with many other online services, so one must be careful to manually adjust prices when working with other data sources.
Expert Answer:
Answer rating: 100% (QA)
To solve the problem we will follow the steps outlined in the question Since I cannot actually download or access data directly I will describe the pr... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
You have just started working for a financial planning firm and have been asked to analyze the performance and risk of the following 10 stocks to decide on the optimal portfolio for your client: The...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Download the daily closing share price of Meta and S&P500 index (Ticker FB and SPY) from Yahoo Finance for the period 19-Feb 2021 to 22-Feb 2022. Using historical data, calculate the expected...
-
7. Arrange the following nitrogen containing compounds in decreasing order of basicity NH NH -H (P) (a) S>R>Q> P NO (R) (2) (b) P>Q>S>R -H (S) (c) P>Q>R>S (d) R>Q> P > S
-
TPo1 Company borrowed $300,000 on January 1, 2010, by issuing a $300,000, 8% mortgage note payable. The terms call for semiannual installment payments of $20,000 on June 30 and December 31....
-
5. For the three charges shown below, calculate the force on charge 2 (magnitude and direction) due to the other two charges. Q1 Q Q3 -3.0 5.0 -3.0 b) What is the magnitude of the electric field at...
-
According to Boyle's law for gases (a) \(V \propto T\) while \(P=\) constant (b) \(V \propto 1 / P\) while \(T=\) constant (c) \(V \propto 1 / T\) while \(P=\) constant (d) \(V \propto P\) while...
-
MTI makes three types of lawn tractors: M3100, M4100, and M6100. In the past, it allocated overhead to products using machine-hours. Last year, the company produced 10,000 units of M3100, 17,500...
-
Determine the future value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of...
-
Mercier Manufacturing produces a plastic part in three sequential departments: Extruding, Fabricating, and Packaging. Mercier uses the weighted-average process costing method to account for costs of...
-
1-State the cost of the investment projects under consideration.2-Calculate the payback period for both projects and comment on your findings.3-1.Calculate the average rate of return on both...
-
What is meant by encoding? Who is responsible for encoding sports marketing messages?
-
How many target markets should a sports marketer consider for a single product?
-
Define price, perceived value, and perceived benefits. What is the relationship among price, value, and benefits?
-
Define the source of a sports marketing message and provide some examples of effective sources. What is source credibility? What are the two components of source credibility?
-
Describe positioning and discuss how perceptual mapping techniques are used by sports marketers. What is repositioning?
-
The product structure for product X is illustrated below. The lead time for manufacturing any number units for an item and the required number of units for the lower level part in the product...
-
a. What is meant by the term tax haven? b. What are the desired characteristics for a country if it expects to be used as a tax haven? c. What are the advantages leading an MNE to use a tax haven...
-
Bea Jones (age 32) moved from Texas to Florida in December 2011. She lives at 654 Ocean Way, Gulfport, FL 33707. Bea's Social Security number is 466-78-7359 and she is single. Her earnings and income...
-
Ken paid the following amounts for interest during 2012: Qualified interest on home mortgage...........................................$4,700 Auto loan...
-
In June of 2012, Maureen's house is vandalized during a long-term power failure after a hurricane hit the city. The president of the United States declares Maureen's city a disaster area as a result...
-
In Exercise 14.8 a significant difference might lead someone to suggest that poor parentchild relationships are the cause of schizophrenia. Why might this be a troublesome conclusion? Exercise 14.8...
-
What is the role of random sampling in the anorexia study?
-
In the example in this chapter about the treatment of anorexia, what basic assumption would we have to make if we compared the final weights of the two groups (rather than comparing the amount of...
Study smarter with the SolutionInn App