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
-
To the medication problem in the previous exercise, add a Jest action that has the conditional effect Culture Growth when Disease is true and in any case has the perceptual effect Know (Culture...
-
What are the four main ways of delegating responsibility for budget management?
-
The following is the adjusted trial balance of Flappy Health, Inc., for August 31,2010. Requirement 1. Journalize the closing entries at August 31. Happy Health, Inc. Adjusted Trial Balance August...
-
The following data pertain to Dakota Divisions most recent year of operations. Income ............. $ 4,000,000 Sates revenue ........... 50,000,000 Average invested capital ...... 20,000,000...
-
As an Operations Manager to implement TPM, state the objectives to be considered for the implementation of TPM in your company. (5 marks)
-
4. Assume a 60-day T-bill, P = $9,700, face value is $10,000, (a) Calculate the bond equivalent yield? (b) Calculate the yield on a bank discount basis? (c) Calculate the effective annual rate...
-
Read the case study on how Deloitte helped a large wireless telecommunications company implement platforms to collect, store, and analyze data from across millions of customers and billions of...
-
At what wavelength is a photon energetic enough to break a bond in a nucleic acid base? To what portion of the electromagnetic spectrum does this correspond? Find and calculate the answer for both...
-
Calculate the future value of an ordinary annuity consisting of monthly payments of $460 for five years. The rate of return was 9.0% compounded monthly for the first two years, and will be 6.9%...
-
Organizational Strategic Plan: Include appropriate APA citations and references to support your response. As a leader, understanding the importance of a strategic plan is vital. Develop an original...
-
1. Calculate the rate of self-injury per minute based on the following data: 9:00-9:05 9:05-9:10 9:10-9:15 9:15-9:20 9:20-9:25 9:25-9:30 7 4 8 2 10 6 SIB
-
Select from a "Medical Professionalism" article two to three outcomes that are important to you (or that you want to achieve in your professional career) and explain what you are doing (or are going...
-
Timetable Survey 2. Object Diagram 3. Basic Use Case Diagram Task 2 Draw a basic class diagram for a customer ordering then paying for item/s on an e-commerce website. Use your personal experience to...
-
Fahrad Inc. sells all of its product on account. Fahrad has the following accounts receivable payment experience: Percent paid in the month of sale .........10 Percent paid in the month after the...
-
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...
-
What is an account? What is a ledger?
-
Why are accounting systems called double entry?
-
Does debit always mean increase and credit always mean decrease?
Study smarter with the SolutionInn App