Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

** Please Calculate Using Excel ** Refer to http://finance.yahoo.com. Quote Look Up, Home Depot, Go. Historical Prices. Enter Start and End Dates. Select weekly. Get

** Please Calculate Using Excel **

Refer to http://finance.yahoo.com. Quote Look Up, Home Depot, Go. Historical Prices. Enter Start and End Dates. Select weekly. Get Prices. Download to spreadsheet.

11. Find the weekly historical prices for Home Depot (use HD as the ticker symbol) for a two-year period, beginning with January 1, 2013 and ending with January 1, 2015. Download this to a spreadsheet (use the adjusted close values). Note: You can put this on a separate Excel worksheet.

12. Next, find the historical prices for the S&P 500 Index (use ^GSPC as the ticker symbol) for the same time period. Make sure the dates for Home Depot and S&P 500 Index line up on your spreadsheet. Note: You can put this on a separate Excel worksheet.

13. Now calculate returns. Recall r = (P1 P0)/P0 which is more easily calculated in Excel as r = (P1/P0) 1. Be sure you get the direction of time right! The most recent dates are at the top of your spreadsheet, so P0 will be in the row below P1. Do this for Home Depot and S&P 500 Index. Note: You can put this on a separate Excel worksheet.

14. Now run a regression with S&P 500 Indexs returns on the X-variable and Home Depot's returns on the Y-variable. You could use the regression tool to run this regression, but the easiest way is to use =SLOPE. For example, if the returns for Home Depot were in C2:C157 and the S&Ps returns are in F2:F157, the formula =SLOPE(C2:C157,F2:F157) would yield the beta.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Ratio Analysis

Authors: Andrew P.C.

1st Edition

1973493381, 978-1973493389

More Books

Students also viewed these Finance questions

Question

What is quality of work life ?

Answered: 1 week ago

Question

What is meant by Career Planning and development ?

Answered: 1 week ago

Question

What are Fringe Benefits ? List out some.

Answered: 1 week ago