The goal is to calculate beta for two stocks: Bank of America and Procter and Gamble. Download daily prices for both companies from Yahoo Finance from 1/4/2010 to 1/2/2014 onto two Excel tabs, labeled "BAC" and "PG". To download the historical prices, go to Yahoo Finance and search for "BAC". Click on "Historical Prices" in the left menu bar and set a date range from 1/4/2010 to 1/2/2014. Leave the "Daily" option checked and click on "Get prices." At the bottom of the table, click on "Download to Spreadsheet." Depending on your browser, one of two things will happen: Your browser downloads a file called "table.csv". Open the file in Excel; or A new tab opens, showing the data in a comma-separated format. Select all data (control/command + a) and copy it into memory (control/command + c), then paste it into a new Excel spreadsheet (control/command + v). Highlight all data, then choose Data -> Text to Columns from the menu. Choose "Delimited", click on "Next" and check "Comma" on the next pane. Click "Finish. Repeat the whole process for Procter and Gamble, whose ticker symbol is PG.

Part 1 How many observations are there for each company (excluding the header row)?

Part 2 Add another column labeled "Return" and calculate the daily return based on the change in the adjusted close price. What was Bank of America's return from 12/31/13 to 1/2/14?

Part 3 What was Procter and Gamble's return from 12/31/13 to 1/2/14?

Part 4 To find beta, we also need the return on the market portfolio. Download the data for the S&P 500 (^GSPC) for the same time period onto a new tab labeled "GSPC". What was the return on the index from 12/31/13 to 1/2/14?

Part 5 Create a new tab labeled 'beta' in Excel. Using Excel's SLOPE() function and the industry model, what is the beta for Bank of America?

Part 6 What is the beta for Procter and Gamble?

Question

The goal is to calculate beta for two stocks: Bank of America and Procter and Gamble. Download daily prices for both companies from Yahoo Finance from 1/4/2010 to 1/2/2014 onto two Excel tabs, labeled "BAC" and "PG". To download the historical prices, go to Yahoo Finance and search for "BAC". Click on "Historical Prices" in the left menu bar and set a date range from 1/4/2010 to 1/2/2014. Leave the "Daily" option checked and click on "Get prices." At the bottom of the table, click on "Download to Spreadsheet." Depending on your browser, one of two things will happen: Your browser downloads a file called "table.csv". Open the file in Excel; or A new tab opens, showing the data in a comma-separated format. Select all data (control/command + a) and copy it into memory (control/command + c), then paste it into a new Excel spreadsheet (control/command + v). Highlight all data, then choose Data -> Text to Columns from the menu. Choose "Delimited", click on "Next" and check "Comma" on the next pane. Click "Finish. Repeat the whole process for Procter and Gamble, whose ticker symbol is PG.

Part 1 How many observations are there for each company (excluding the header row)?

Part 2 Add another column labeled "Return" and calculate the daily return based on the change in the adjusted close price. What was Bank of America's return from 12/31/13 to 1/2/14?

Part 3 What was Procter and Gamble's return from 12/31/13 to 1/2/14?

Part 4 To find beta, we also need the return on the market portfolio. Download the data for the S&P 500 (^GSPC) for the same time period onto a new tab labeled "GSPC". What was the return on the index from 12/31/13 to 1/2/14?

Part 5 Create a new tab labeled 'beta' in Excel. Using Excel's SLOPE() function and the industry model, what is the beta for Bank of America?

Part 6 What is the beta for Procter and Gamble?