COMPANY: Tiffany&co

Enter your company name or ticker symbol in the search box at the top left side of the homepage. Click on your Ticker US Equity from the dropdown menu. For the remaining information search items, you may need your screen to be at this point, the company menu. You can either return to it by entering your Ticker US Equity or use the back arrow at the top of the screen.

Find the following information of your firm on Bloomberg:

1) Type DES and hit GO. The complete description of your firm (about five lines long), location of corporate headquarters and CEO name.

2) Type CN and hit GO. Note the title of the most recent top-ranked news story about your firm.

3) Type FA and hit GO. Obtain the reported figure of the followings: total assets, market capitalization, free cash flow, return on common equity, and total debt/equity ratio.

4) Type HP and hit GO. Get the trading volume in the second quarter of 2021.

5) Type RV and hit GO. List two competitors of your firm.

6) Type ANR and hit GO. You will see a list of financial analysts following the firm. Count the number of analysts and find percentages of buy, hold, and sell recommendations in the past 12- month consensus recommendations.

7) Type GP and hit GO. Get the recent five years price chart of your company. Use GRAB to take a screen shot.

2. Get the monthly returns of your company during 2019-2020.

1) Calculate the average monthly return and the standard deviation of returns over the 24 months.

Hint:

First, type HP and hit GO. Choose the time range from 1/31/2019 to 12/31/2020 and the period Monthly.

Second, click on the primary or secondary data field (Market). Select Find a field and enter Day to Day Total Return (Gross Dividends).

Third, click on Export. Copy and paste Date and return data to an Excel file on your local computer.

2) Use the CAPM model to estimate the beta of your company. Show the regression results (including the plot) and discuss your understanding of the results.

Hint:

First, get the monthly return of S&P 500 index (Ticker: SPX) and the monthly Mid Yield of 10-year Treasury bond (type USGG10YR). Follow the same steps as the above in getting the monthly returns of your company. The returns of SPX and the mid yield of USGG10YR will be used as the market return and risk-free return, respectively, in the following CAPM model regression analysis.

Second, click on Output to Excel. Copy and paste the monthly SPX return and USGG10YR mid yield to your existing local Excel file. Make sure that the dates of these two returns line up with the dates of your company returns.

Third, use the regression analysis in Excel to estimate beta based on the following regression equation (see Chapter 2-6 and Chapter 3-5 of your textbook):

, , = + (, ,) + ,