Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Intro The goal is to calculate beta for two stocks: Bank of America and Procter and Gamble. Download daily prices for both companies from Yahoo
Intro 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: 1. Your browser downloads a file called "table.csv". Open the file in Excel; or 2. 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 Attempt 1/3 for 10 pts. How many observations are there for each company (excluding the header row)? 1006 Correct Part 2 | Attempt 2/3 for 8 pts. 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? 4+ decimals Submit Part 3 | Attempt 1/3 for 10 pts. What was Procter and Gamble's return from 12/31/13 to 1/2/14? 4+ decimals Submit Part 4 Attempt 1/3 for 10 pts. 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? 4+ decimals Submit Part 5 | Attempt 1/3 for 10 pts. 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? 2+ decimals Submit Part 6 |Attempt 1/3 for 10 pts. What is the beta for Procter and Gamble? 2+ decimals Submit Intro 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: 1. Your browser downloads a file called "table.csv". Open the file in Excel; or 2. 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 Attempt 1/3 for 10 pts. How many observations are there for each company (excluding the header row)? 1006 Correct Part 2 | Attempt 2/3 for 8 pts. 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? 4+ decimals Submit Part 3 | Attempt 1/3 for 10 pts. What was Procter and Gamble's return from 12/31/13 to 1/2/14? 4+ decimals Submit Part 4 Attempt 1/3 for 10 pts. 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? 4+ decimals Submit Part 5 | Attempt 1/3 for 10 pts. 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? 2+ decimals Submit Part 6 |Attempt 1/3 for 10 pts. What is the beta for Procter and Gamble? 2+ decimals Submit
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started