Go to finance.yahoo.com. Choose any public stock that you want to analyze. Use data from Yahoo...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Go to finance.yahoo.com. Choose any public stock that you want to analyze. Use data from Yahoo Finance to calculate the beta of the stock. Start by downloading the monthly adjusted closing prices of the stock and the S&P 500 (^GSPC) in the Historical Prices section. Copy the data into Excel and calculate the monthly rates of return (based on adjusted closing prices) for each series. Using the entire period for which data are available for both the stock and S&P 500, estimate a regression with the stock's excess return as the dependent (Y) variable and the S&P 500 excess return as the independent (X) variable (Use LINEST function). To compute excess return, assume the risk-free rate to be 3.5%. Finally, compare your results to the beta listed in Yahoo Finance Stoc Report. Do any of your results match the Yahoo Finance Report beta? What might explain the differences? Go to finance.yahoo.com. Choose any public stock that you want to analyze. Use data from Yahoo Finance to calculate the beta of the stock. Start by downloading the monthly adjusted closing prices of the stock and the S&P 500 (^GSPC) in the Historical Prices section. Copy the data into Excel and calculate the monthly rates of return (based on adjusted closing prices) for each series. Using the entire period for which data are available for both the stock and S&P 500, estimate a regression with the stock's excess return as the dependent (Y) variable and the S&P 500 excess return as the independent (X) variable (Use LINEST function). To compute excess return, assume the risk-free rate to be 3.5%. Finally, compare your results to the beta listed in Yahoo Finance Stoc Report. Do any of your results match the Yahoo Finance Report beta? What might explain the differences?
Expert Answer:
Answer rating: 100% (QA)
Sure Lets take Apple Inc AAPL as our example stock First lets download the monthly adjusted closing prices of AAPL and the SP 500 GSPC from Yahoo Fina... View the full answer
Related Book For
Fundamentals Of Corporate Finance
ISBN: 9780135811603
5th Edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford
Posted Date:
Students also viewed these finance questions
-
Flowering Sensation manufactures flowerpots. The following data relate to the standards for direct labor: Standard direct labor hours per pot Standard direct labor rate per hour 0.75 $16.00 The...
-
Answer in units of degs. 011 (part 1 of 3) 10.0 points Three point charges, +6.3 C, +1.6 C, and -2.2 C, lie along the x-axis at 0 cm, 2.8 cm, and 5.3 cm, respectively. What is the force exerted on q...
-
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...
-
Sam's Furniture uses variance analysis to evaluate manufacturing overhead in its' factory. The information for the June overhead expenditures is as follows: Budgeted output units 22,000...
-
The Howell Corporation has the following account balances (in millions): Prepare an statement of comprehensive income and a supporting schedule of cost of goods manufactured for the year ended...
-
CMA Adapted A database is a. essential for storage of large data sets. b. a collection of related files. c. a real-time system. d. a network of computer terminals. e. a task-oriented file system.
-
Refer to the December 31, 2002, balance sheet Harley- of Harley-Davidson in Appendix A. What Davidson long-term assets discussed in this chapter are reported?
-
Wavecrest Inc. reported income from continuing operations before tax of $1,790,000 during 2017. Additional transactions occurring in 2017 but not included in the $1,790,000 are as follows: 1. The...
-
Exhibit 1 Allergan Earnings Release Year Year (unaudited; $ in millions, except per share amounts) Q4 '17 Q4 '17 2017 Q4 '17 Q4'16 Q3 '17 v v Ended December December Ended v Q4 '16 Q3 '17 2016 31,...
-
Lays Potato Chips is examining their Wavy Lays chip line. They began the year expecting to produce 500,000 bags of potato chips. They projected that each bag would require 3 pounds of potatoes and...
-
The Corata Appliance Manufacturing Corporation manufactures two vacuum cleaners, the Standard and the Super. The following information was gathered about the two products: Budgeted sales in units...
-
Create a mobile application using Java programming: A Spinner is needed to advertise 3 tourist tours that are on sale (Zoo, Beach, Pitch Lake). A zoo tour costs $500, a Maracas tour costs $600 and a...
-
Joseph Moore is an accounting major at a midwestern state university located approximately 60 miles from a major city. Many of the students attending the university are from the metropolitan area and...
-
Q.4(a) AB and AC are similar uniform rods, of length a, smoothly joined at A. BD is a weightless bar, of length b, smoothly joined at B, and fastened at D to a smooth ring sliding on AC. The system...
-
What is Marketing plan direction ? 2. What is marketing plan of G & E Automotive Solutions ? 3. What is Diversification of G & E Automotive Solutions? 4. What is the marketing development of G & E...
-
You have an apartment for rent. One potential tenant has promised to sign an annual lease for eight years, with each year's rent (paid at the end of the year) of $32,000. Rather than make yearly...
-
LabConnection Instructions What is the processor manufacturer given in the System summary? Skip This Step AMD Intel ASUS Gigabyte
-
On January 1, 2018, Khalid Ltd., which follows IAS 17, entered into an eight-year lease agreement for three dryers. Annual lease payments for the equipment are $28,500 at the beginning of each lease...
-
Consider the following potential events that might have occurred to Global on December30, 2019. For each one, indicate which line items in Globals balance sheet would be affected and by how much....
-
Suppose that on January 15, 2018, the U.S. Treasury issued a 10-year inflation-indexed note with a coupon of 6%. On the date of issue, the CPI was 200. If the CPI decreases to 150 by January 15,...
-
How is an exchange rate used?
-
Donna Inc Donna Inc operates a defined benefit pension scheme for staff. The pension scheme has been operating for a number of years but not following IAS 19. The finance director is unsure of which...
-
The following are extracts from the financial statements of Heidelberger Druckmaschinen AG showing the accounting policy and detailed notes regarding the provision of pensions according to IAS 19. As...
-
Kathryn Kathryn plc, a listed company, provides a defined benefit pension for its staff, the details of which are given below. Pension scheme As at the 30 April 2004, actuaries valued the companys...
Study smarter with the SolutionInn App