 |
Find Pharmaceutical Sales and Revenue Forecasts?
TOPIC: INVESTEXT® PDF Fulltext (File 745) is an index to company, industry, and geographic research reports written by analysts at more than 600 leading investment banks, brokerage houses and consulting firms worldwide. Records containing citations to reports are put online as soon as the reports are received by Investext and are available in PDF format; the citation records are updated a few days later with the full Table of Contents.
Investext provides in-depth analysis and data on approximately 60,000 publicly traded companies, including sales and earnings forecasts, market share projections and research and development expenditures. Other Investext reports analyze specific industries/products and businesses in geographic regions. The reports are particularly useful for market research, strategic planning, competitive analysis, and financial forecasting.
TableBase database contains tabular information dealing with companies, products, industries, brands, markets, demographics, and countries from around the world. All records contain a table and the originating textual article when available. The table is the focus of this database. Every table is enhanced with an informative table title and indexing for easy retrieval. Indexing is drawn from File 9, Business & Industry.
In this exercise you will search for a pharmaceutical company in INVESTEXT and look for analysts’ reports covering sales and forecasts in therapeutic areas.
COMMAND SUMMARY
BEGIN 745
SELECT SALES AND (FORECAST? OR OUTLOOK OR PROJECTION?)
EXPAND CO=LILLY
SELECT “E” REFERENCE NUMBER(S)
EXPAND CO=ELI LILLY
SELECT “E” REFERENCE NUMBER(S)
SELECT S1 AND S2:S3
SELECT S4 AND (ANTIDEPRESS? OR DEPRESS?)
SELECT S5/2006:2007
TYPE S6/8/1-5
TYPE S6/9/1
Click page link
HOW TO...
1. BEGIN File 745 to search INVESTEX® PDF Fulltext
2. SELECT terms for sales AND concepts related to forecasts OR outlook OR projection.
Be sure to nest synonyms in parentheses when combining with other criteria.
This statement means that every record retrieved must have the term “sales” AND at least one of the terms “forecast” or “outlook” or “projection.” Use truncation with the question mark “?” where appropriate.
Note: In TableBase search for sales and forecasts as descriptors (/DE). |
?B 745
File 745:Investext(R) PDF Fltxt 1999--2007/Dec W2
(c)2007 Thomson Fin. Networks
Set Items Description
--- ----- -----------
Characters per line set to 80.
?S SALES AND (FORECAST? OR OUTLOOK OR PROJECTION?)
1311501 SALES
508430 FORECAST?
250365 OUTLOOK
42749 PROJECTION?
S1 151495 SALES AND (FORECAST? OR OUTLOOK OR PROJECTION?) |
3. EXPAND on the Company Name (CO=) field.
4. SELECT the appropriate “E” Reference number(s).
5. EXPAND on alternative company names. For companies it is always a good idea to try a variety of names.
6. SELECT the appropriate “E” Reference number(s). |
?E CO=LILLY
Ref Items Index-term
E1 35 CO=LILLIAN VERNON CORP.
E2 17 CO=LILLIBRIDGE TOOL MACHINE CO INC
E3 0 *CO=LILLY
E4 32 CO=LILLY (ELI) & CO.
E5 27 CO=LILLY INDUSTRIAL COATINGS INC
E6 37 CO=LILLY INDUSTRIES INC.
E7 20 CO=LILLY SOFTWARE ASSOCIATES, INC.
E8 3 CO=LILYCOLOR CO., LTD. (TOKYO)
. . . .
Enter P or PAGE for more
?S E4
S2 32 CO='LILLY (ELI) & CO.'
?E CO=ELI LILLY
Ref Items Index-term
E1 7 CO=ELGRANDE INTERNATIONAL INC
E2 3 CO=ELI ECO LOGIC INC.
E3 0 *CO=ELI LILLY
E4 1633 CO=ELI LILLY & CO
E5 43 CO=ELIA SYSTEM OPERATOR SA
E6 5 CO=ELIANCE CORP.
. . ..
Enter P or PAGE for more
?S E4
S3 1633 CO='ELI LILLY & CO' |
7. SELECT the results from Set 1 (S1) and the company names from Sets 2 and 3 ORed together. The colon acts as OR.
8. Combine the results of Set 4 (S4) with terms related to a major therapeutic area.
9. LIMIT the search to a specific range of Publication Years (PY=).
Note: In TableBase combine with the Product Code (PC=) number for pharmaceuticals (PC=2834) and Publication Year(s) (PY=). |
?S S1 AND S2:S3
151495 S1
1665 S2:S3
S4 97 S1 AND S2:S3
?S S4 AND (ANTIDEPRESS? OR DEPRESS?)
97 S4
1245 ANTIDEPRESS?
4084 DEPRESS?
S5 26 S4 AND (ANTIDEPRESS? OR DEPRESS?)
?S S5/2006:2007
26 S5
1451692 PY=2006 : PY=2007
S6 5 S5/2006:2007 |
10. TYPE records in Format 8, which gives Title, Report Number, Pagination, and Company Name and Investext Ticker Symbol.
Notice that the Record Type (RT=) is CONTENTS. This means the record contains a Table of Contents, which provides hyperlinks to specific pages of the report.
To select the appropriate record number, look at the range of records in the TYPE command (e.g., 6/8/2).
Note: Some records have been omitted from this display. |
?T S6/8/ALL
6/8/1
DIALOG(R)File 745: Investext(R) PDF Fltxt
(c)2007 Thomson Fin. Networks. All rights reserved.
08192941
ELI LILLY & CO
BEAR STEARNS AND CO INC
BORIS, J., ET AL
Date:April 17, 2007
Record Type: CONTENTS
INVESTEXT(tm) Report Number: 12177619 Pages: 13
Cost: $9.60 per page Full Report $124.80
This is a(n) Original PDF Company Report. To view PDF reports,
you will need Adobe Acrobat Reader 3.0 or higher (available
free from Adobe) installed on your computer.
Company: ELI LILLY & CO
Ticker Symbol: LLY
Investext(R) PDF Index (Dialog(R) File 745): (c)2004 Thomson Fin.
Networks. All rights reserved.
. . . . |
11. TYPE selected records in Format 9 to display the Table of Contents.
12. Click on the hyperlink to a specific page of interest. Alternatively, an option appears that allows you to hyperlink to the full report. Cost of the full report is determined by the number of pages in the report. |
?T S6/9/1
6/9/1
DIALOG(R)File 745: Investext(R) PDF Fltxt
(c)2007 Thomson Fin. Networks. All rights reserved.
08192941
ELI LILLY & CO
BEAR STEARNS AND CO INC
BORIS, J., ET AL
Date:April 17, 2007
Record Type: CONTENTS
INVESTEXT(tm) Report Number: 12177619 Pages: 13
Cost: $9.60 per page Full Report $124.80
This is a(n) Original PDF Company Report. To view PDF reports,
you will need Adobe Acrobat Reader 3.0 or higher (available
free from Adobe) installed on your computer.
Section/Table Headings |
Pages |
| TABLE OF CONTENTS Table/Chart: Rating Information |
1 |
| Table/Chart: Trading Data |
1 |
| Table/Chart: Fundamental Data |
1 |
| Graph - Price Performance Chart |
1 |
| Highlights |
1 |
| Sector View: |
1 |
Table/Chart: Adjusted EPS Estimates Post Option Expense
(dagger)(All values are in USD) |
1 |
| Disclaimer |
1 |
| Raising EPS Outlook; Reiterate Peer Perform |
2 |
| Table/Chart: Exhibit 1. LLY 2007 and Bear Stearns Estimates |
2 |
| Balanced Risk/Reward Ahead of Prasugrel Data (Exhibit 2 & 3) |
2 |
Table/Chart: Exhibit 2. Prasugrel 2011 U.S. Revenue
Scenarios and EPS Impact |
3 |
Table/Chart: Exhibit 3. LLY Stock Price as Function of
Prasugrel Scenarios |
3 |
| Balanced Risk/Reward Ahead of Prasugrel Data (Exhibit 2 & 3) (CONT) |
3 |
Pharmaceutical Sales Almost $200M Above Our Estimate;
+7% Volume Growth (see Exhibit 4) |
3 |
| Table/Chart: Exhibit 4. LLY Components of 1Q07 Revenue Growth |
3 |
| Table/Chart: Exhibit 5. LLY Product Revenue Variance Analysis |
4 |
Zyprexa-Continued Disconnect Between Reported Sales & TRx +
Price (Exhibits 6, 7, 8, 9& 10) |
4 |
Table/Chart: Exhibit 6. Estimated Components of U.S. Zyprexa
Revenue Growth in 4Q06 and 1Q07 |
5 |
Graph - Exhibit 7. Weekly Zyprexa Total Prescriptions (TRx)
and New Prescriptions (NRx) in the U.S. |
5 |
Zyprexa-Continued Disconnect Between Reported Sales & TRx +
Price (Exhibits 6, 7, 8, 9& 10) (CONT) |
5 |
Table/Chart: Exhibit 8. Estimated Components of Ex-U.S.
Zyprexa Revenue Growth in 4Q06 and FY2006 |
6 |
| Graph - Exhibit 9. Reported Zyprexa International Sales |
6 |
| Table/Chart: Exhibit 10. U.S. Antipsychotic Market Model |
7 |
Cymbalta Reacceleration Continues-Initiatives for
Depression and DPNP (Exhibit 11 & 12) |
8 |
Graph - Exhibit 11. Antidepressant Monthly Total Prescription
(TRx) Market Share |
8 |
| Table/Chart: Exhibit 12. U.S. Antidepressant Market Model |
9 |
| Other In-Line Products |
10 |
Graph - Exhibit 13. Fast Acting Insulin NRx Share In The
US Market |
10 |
Pipeline Update |
11 |
| Income Statement Analysis |
11 |
| Table/Chart: Exhibit 14. LLY 1Q07 Income Statement and Margin Analysis |
11 |
| Table/Chart: Eli Lilly Quarterly Income Statement |
12 |
| Disclaimer |
12 |
| Analyst Certification |
12 |
| Companies Analyzed |
13 |
| Graph - Stock Price Chart Eli Lilly |
13 |
| Report Key |
13 |
| Disclosure (No charge for this page) |
14 |
Company: ELI LILLY & CO
Ticker Symbol: LLY
Investext(R) PDF Index (Dialog® File 745):
(c)2004 Thomson Fin. Networks. All rights reserved. |
RELATED HOW DO I...? SOLUTIONS
NEED HELP?
Contact the Dialog Knowledge Center
Within North America +1 800 3 DIALOG (334 2564)
Outside North America 00 800 33 DIALOG (33 34 2564)
Web Form www.dialog.com/contacts/webform
|
You are viewing the
Click below to view the
 |
