Question: Use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression. Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 Jul-09 Aug-09

Use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression. Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09

Use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression. Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09 Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Returns (%) S&P 500 Nike 2.3064 1.7529 1.5467 5.1536 - 1.0685 6.5802 -2.4230 - 7.6024 1.4127 - 1.1119 2.1563 6.7463 - 3.7681 -4.0132 0.2714 3.5758 2.0555 4.8998 1.7810 3.1853 4.8243 4.1200 3.5180 7.4179 - 2.6557 - 4.4768 2.2695 0.3694 -1.6937 - 3.8988 -2.5182 -7.8022 3.7916 7.0173 1.1531 5.6569 4.3331 -3.2333 -0.5943 - 5.8353 1.0609 3.8271 - 2.0784 2.9016 4.0406 1.4872 0.3476 2. 1102 4.0112 -6.7289 -0.1644 7.2020 1.9060 -1.5787 1.2968 -3.8308 - 3.1042 -1.8695 -0.0396 1.2452 -0.1902 -2.4691 2.5085 2.2279 1.9452 8.8782 3.7086 4.8619 2.3716 7.6948

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

You will calculate the beta of the Nike stock by using the function SLOPE. In cell D6, by using the function SLOPE and cell references, calculate the beta of the Nike stock (1 pt.). Do not use...

Let's practice time-series forecasting of new home sales. Click here (https://www.census.gov/constructionrs/historical_data/index.html) to see the newest data in thefirst table: Houses Sold (Excel...

Problem 1: Estimating Beta for Disney The monthly return data for Disney stock and S&P500 for the period of Sept 2008 ~ Sept 2013 are provided in Homework1_Problem1_Disney.xls. Estimate the beta of...

Use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression. The beta of Nike stock is (Round to four decimal places.) Returns (%) S&P 500 Nike 2.3064 1.7529...

Please see attached. I also need the excel formulas. Thank you. Problem 12-11 Use the data far below to estimate the beta of Nike and Dell stock based on their monthly returns from 2007-2011. Nike...

Stage 4: Developing Combined-Asset Portfolios You are going to develop two multi-asset portfolios from the stocks you chose. Place the information for these steps in the Portfolios worksheet. Step 1)...

Hello, Can I get some help figuring out the "solution" portion of this excel file. Thank you Ross, Westerfield, and Jordan's Spreadsheet Master Fundamentals of Corporate Finance, 10th edition by Brad...

I need to know how to do the sections under Master It! and Solution Ross, Westerfield, Jaffe, and Jordan's Spreadsheet Master Corporate Finance, 11th edition by Brad Jordan and Joe Smolira Version...

Hedge Fund Homework Be careful as all your Historical Performance data is in % already, e.g.10.50 is 10.50% 1.Visually examine your data, what are some of the issues with hedge fund historical...

1.A manager picks at the beginning of each month between Large Stocks and 30-Day U.S. Treasury Bills and remains invested (exclusively) into one of them for the rest of themonth. Suppose that the...

One way to clearly see the impact of shifting cultural values on consumption is to look at the increasing emphasis on the importance of health and wellness. In recent years, top-performing new...

Book, Inc. acquires all of the outstanding $25 par common stock of Cray, Inc., on June 30, 2014, in exchange for 40,000 shares of its $25 par common stock. On June 30, 2014, Book, Inc., common stock...

In calculating the WACC, adjustments for tax need to be made to the cost of preferred stock cost of common equity from new shares issued none of the component costs of capital cont of comamon equily...

https://media.cheggcdn.com/media/e59/e5900ba1-02b0-44ab-8246-fb980e24e7c1/phpDkQ6Ux

1. When discussing pure competition, the term long run refers to a period of time long enough to allow: LO11.1 a. Firms already in an industry to either expand or contract their capacities. b. New...

2. Suppose that the pen-making industry is perfectly competitive. Also suppose that each current firm and any potential firms that might enter the industry all have identical cost curves, with...

LO12.4 Explain how a pure monopoly sets its profitmaximizing output and price.