WRDS data website: https://wrds-www.wharton.upenn.edu/

use http://www.crsp.org/

and compustat

Be prepared to type in your final answers to the questions below:

1. Using DAILY data provided through CRSP (CRSP -> Stock/Security Files -> Daily Stock File), find Medical Properties Trust Inc's (ticker: MPW) market cap on March 23rd, 2017. Market capitalization is defined as share price x shares outstanding. retrieve "Price" and "Number of Shares Outstanding" for Medical Properties Trust.NOTE: While CRSP provides shares outstanding in thousands (e.g., 3,784 thousand shares outstanding implies 3,784,000), be sure to enter your market cap in (single) dollars.

2. Using data provided through Compustat (Compustat - Capital IQ ->North America - Daily -> Fundamentals Annual), retrieve total assets ("AT") for the Coca-Cola Company (ticker KO) at the end of 2010 and at the end of 2011. Calculate Coke's CHANGE in total assets from 2010 to 2011. This time, express your answer in $millions (e.g., if you calculate a difference of $2,500 from the raw Compustat data, type "2500" in directly, since the data is already in millions).

3. Using DAILY CRSP (CRSP -> Stock/Security Files -> Daily Stock File), find GoPro's (ticker: GPRO) closing bid-ask spread on July 29, 2016. You will need to retrieve GPRO's "Closing Bid" and "Closing Ask" prices.

4. Using DAILY CRSP (CRSP -> Stock/Security Files -> Daily Stock File), retrieve daily volume results for the SPDR S&P 500 ETF (ticker: SPY) during the month of August 2015. Find the standard deviation of daily volume during the month of August 2015 using the Excel formula =stdev.p(cell range) to find your answer. Round your final answer to one decimal place.

5. Using the MONTHLY STOCK FILE from CRSP (CRSP -> Stock/Security Files -> Monthly Stock File), download Facebook's (ticker: FB) "Holding Period Return" as well as the "Return on S&P Composite Index," from the beginning of 2015 through the end of 2019. Calculate FB's beta using all of the monthly return date from 2015 through 2019. Use a version of the Excel formula below. (Obviously, you will need to change the part inside parentheses.)

=covariance.P(facebookRETURNcellrange,s&pRETURNcellrange)/var.p(s&pRETURNcellrange)/var.p(s&pRETURNcellrange)

Round your beta to three decimal places. (Compare your answer to FB's current beta found on its Yahoo! Finance page.)