Using Bloomberg to get the Data you need
Using Bloomberg to get the Data you need
1
Contents of Package
1.Getting information on your company
Pages 3-30
2.Getting information on comparable companies
Pages 31-34
3.Getting macro economic information
Pages 35-44
2
Using Bloomberg to get information on your company
To get all other information
To get ratings information
Equity
Corp Bond
1. Finding Securities
1. Finding Securities
Ticker Symbol Look Up
Enter the name of your company
1. Ticker Symbol Look Up
Enter the name of your company
Choose the listing for your company
that you are interested in
Choose the listing for your company
that you are interested in
Pick a long term bond for the company
Issue/Issuer Information
Description
2. Company Information
/Description
1. Description (DES)
Fundamentals and
Earnings Analysis
1. Financial
Analysis (FA)
25. Print
Complete
report
13. Earnings
Estimates (EE)
3) Zacks
Historical
Prices
Px Table w/ Avg
Vol (HP)
Risk and
Volatilitiy
Beta
Calculation
(BETA)
Historical
Volatility
(HVT)
Change defaults:
Period to M
Starting point: 5 years ago
Leave ending point as is
Shadow : Indicates menu choices on Bloomberg
Regular font: Indicates input that you have to provide or change
3
WHERE TO FIND THE DATA
This is a listing of all of the financial data that you will need to analyze your company and where exactly on the Bloomberg output you will find the data.
Once you have identified what you would like to look up, use the item number and go to the specified page number on Bloomberg to look it up.
Item
Input
In Bloomberg
Page Number
Used in this spreadsheet
1
Beta
Equity: Beta Calculation
29
Capstr, Dividend, Valuation
2
Current EPS
Equity: Description
8
Valuation
3
Payout Ratio
Equity: Description
10
Valuation
4
Total Debt
Equity: Description
16
Capstr, Dividend, Valuation
5
Book Value of Equity
Equity: Description
16
CapStr, Valuation
6
Number of Shares Outstanding
Equity: Description
8
CapStr, Valuation
7
Tax Rate
Equity: Description
10
CapStr, Valuation
8
Non-Cash Working Capital
Equity: Description
16
Valuation
9
Capital Expenditures
Equity: Description
17
CapStr, Valuation
10
Depreciation
Equity: Description
17
CapStr, Valuation
11
EPS - 5 years ago
Financial Analysis
12
Valuation
12
Analyst Projection for Growth
Equity: Earnings Estimates
26
Valuation
13
Interest Expenses
Equity: Description
15
CapStr, Valuation
14
Net Sales/ Revenues
Equity: Description
15
Valuation
15
Current Price
Equity: Description
8
Risk, CapStr, Valuation
4
16
EBIT/Operating Income
Equity: Description
15
CapStr
17
Bond Rating
Corp Bond: Description
30
CapStr
18
Past 10 years Net Income
Equity: Financial Analysis
25
Dividends
19
Past 10 years Depreciation
Equity: Financial Analysis
25
Dividends
20
Past 10 years Chg in non-cash Work. Cap.
Equity: Financial Analysis
25
Dividends
21
Past 10 years Dividends
Equity: Financial Analysis
25
Dividends
22
Past 10 years Equity Buybacks
Equity Financial Analysis
25
Dividends
23
Past 10 years Cap Ex
Equity: Financial Analysis
25
Dividends
24
Average Debt Ratio 10 years
Equity Financial Analysis
21
Dividends
25
Past 10 years BV of Equity
Equity Financial Analysis
24
Dividends
26
Return on Stock
Equity: Financial Analysis
18
Dividends
27
Operating Income past 10 years
Equity: Financial Analysis
22
DebtDesign
28
Stock Price: Last 60 months
Equity: Px Table
27
Risk
29
Value of Firm: Last 10 years
Equity:: Financial Analysis
21
Dividends
30
EBITDA for last 10 years
Equity: Financial Analysis
21
31
Alpha (Intercept)
Beta Calculation
29
32
R squared
Beta Calculation
29
33
Standard Error of Beta
Beta Calculation
29
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- fundamental sentiment technical
- how to create a spreadsheet with updating stock prices
- thomson reuters eikon user guide
- download ing data using the bloomberg excel addin
- using bloomberg to get the data you need
- 1 thinkmanual td
- database guide datastream stanford graduate school of
- reminiscences of a stock operator ning
- ticker symbol list mr cannon s page
- nasdaq fund network nfn
Related searches
- how to get the best car deal
- how to get the best lease deal
- how to get the pink eye
- how to get the percentage of numbers
- call to get the time
- how to get the diameter from circumference
- how to get the square root
- how to get the derivative
- how to get the mean
- how to get the mean of data
- how to get the density of water
- how to get the flu