Ddd



FIN 647: Advanced Topics in Financial Management

Assignment: Corporate Governance

Corporate Governance on Bloomberg: 

1. Load an equity (e.g. IBM => F8 key (EQUITY) => (Enter)

2. For general Corporate Info: DES

3. For Management: MGMT To view specifics about the key managers click on their names.

4. For Insider Holdings PHDC => Click on the White #3 This will list, from highest to lowest, the insider holdings.

5. For Corporate Governance Ratings CGOV This lists a bunch of ratings. For an explanation of the ratings hit the GREEN Help button ONCE. The fifty pages of explanations come with very good and well thought out reasoning and rationale for their ratings.

Assignment: Reworking Financial Statements

Financial Statements on Bloomberg:

1. Load an equity (e.g. IBM => F8 key (EQUITY) =>

2. For Statements (Going back for many years) select the #4 Option (Fundamentals & Estimates…)

3. Select which ones that you wish to see. (5-7) Statements are un-exportable to excel => Mergent is better for this application. (see below)

Financial Statements on Mergent:

1. Go to Pace’s Library website.

2. Under Find Resources => Databases Link.

3. Select “Mergent Online”.

4. Select “Connect to Database”.

5. Select “Enter Mergent Online”.

6. Go to box 1 and enter name, ticker, or CUSIP.

7. Select proper company.

8. Select “Company Financials” tab.

9. Fill out requested information, and then you can DOWNLOAD the data to Excel. (remember to save as an Excel file, not CSV(default))

Assignment: Estimating Betas

Betas on Bloomberg:

1. Load an equity (e.g. IBM => F8 key (EQUITY) =>

2. For BETA: BETA (Gives you the screen depicted on page 13 of Professor Damodaran’s paper on betas). This will be helpful in comparing your results to the Bloomberg results for the company that you selected AND for industry comparisons.

3. For Historic Prices: HP

4. The prices are not labeled well (year is not with month/day) and are un-exportable to excel => Yahoo Finance is better for this application. (Enter ticker and go to historical prices.)

Assignment: Capital Structure

WACC on Bloomberg:

1. Load an equity (e.g. IBM => F8 key (EQUITY) =>

2. For WACC: WACC This will be helpful in comparing your results to the Bloomberg results for the company that you selected AND for industry comparisons.

3. For L-T and S-T Borrowing: ARD

a. S-T: Line # 61

b. L-T: Line # 68

4. For tax bracket information: WACC then click on #2 (debt). The effective tax rate is the third rate from the top (first orange colored cell).

5. The market cap indexed in the WACC calculations are indexed to the Quarter’s ending figures, so take this into consideration when you use this for comparisons. To access this historical market cap data: FA then go to #1 (overview) and look at line #14 for the figure that they use. Current market cap data is more accurate and you should adjust any industry comps that you look up in Bloomberg for current market cap figures to have an apples to apples comparison.

NOTE: At any time you may hit the GREEN Help key twice to Instant Message live help desk consultants at Bloomberg for assistance. There are over 20,000 commands and many ways to access the information that you seek. They are very knowledgeable and very helpful.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download