Question: 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
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. Thus, you will need to 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. 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. Thus, you will need to 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
