Home

User Guide - Department of Financial Management and Capital

1. 7 Contact aeaiia 7 Chapter 2 About I B E S Datastream 8 Whatis B E S v 8 l B E S on Datastream what is 8 Available sasa ansaanaqasssa asas sasa 8 PB E SWANS TONGS uuu C S 9 Regional summary consensus 24422442 9 l B E S Global Aggregales u m 9 5 Tear Sheet 9 10 Momentum LL p 10 LOCK Evaluatio ease sca Cre LEE sss 11 Xen cc EET 11 Analysi Agreement 12 Eee tio ete E 12 MICI Mp EC 13 Overview Of company pelrforfrialiee s a cocco niece erecti erae ser ecex ereaessegeceyaees 14 Update frequeriCy ute 16 Obtaining monthly
2. 28 Countries that display Non per Share PS items in billions 29 Adjusted Funds From Operations enne nennen entente 30 Book Value per SharesBPS u u u te od on edet E mi deat 32 Capital Expenditure te cuc curre o iae a ecu D eee eel 34 Gash Earnings per Share e att eia tacta se ate ete sot ate 36 Cash Flow per Share GPS sed rac e eet e te ey Lg ne on eid ed eaten 38 Dividends per Share DPS etus cn hea awama a ura soap eer ete 40 Earnings Before Goodwill s atico sopra restet ee aaah aad ade ettet 42 EBIT Earnings Before Interest and ott ooi 44 EBITDA Earnings Before Interest Taxes Depreciation and Amortization 46 EBITDA PER SHARE Earnings Before Interest Taxes Depreciation and Amortization 48 Enterprise Valte IE VT 50 Free Cash Flow aceite cc n u eo inu hisua us atau 52 From Operations 2 ta ant isha ss aa um unai des 54 GAAP Fully Rep rted GPS andi ened au a ee uqa 56 Gross Margin GRM 3t uynuy Qa b tad pies atakuwa
3. ON DATASTREAM User Guide Version 5 0 OPR2MN OPR3MN OPR4MN OPR5MN OPR2D OPR3D OPR4D OPR5D OPR2CV OPR3CV OPR4CV OPR5CV OPR2HI OPR3HI OPR4HI OPR5HI OPR2LO OPR3LO OPR4LO OPR5LO OPR2MD OPR3MD OPR4MD OPR5MD OPR2SD OPR3SD OPR4SD OPR5SD OPR2DN OPR3DN OPR4DN OPR5DN Page 68 of 142 OPR1DNW OPR1DN4W OPR1UP OPR1UPW OPR1UP4W OPR1NET OPR1XD OPR1XDW OPR1XD4W OPR1XU OPR1XUW OPR1XU4W OPR1NE Number of FY1 estimates down since last weekly values Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast OPR2DNW OPR3DNW OPR4DNW OPR5DNW OPR2D
4. ON DATASTREAM User Guide Version 5 0 Page 47 of 142 EBITDA PER SHARE Earnings Before Interest Taxes Depreciation and Amortization EBS1MN EBS1D FOEBS EBSOYR EBS1CV ROEBS EBS1HI EBS1LO EBS1MD EBS1SD EBS1FD12 A EBS EBS MN EBSE MN EBSE MD EBSE SD Mean EBITDA Per Share for FY1 Fiscal Year End for EBS1MN Last Reported EBITDA Per Share Fiscal Year End for FOEBS e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV EBS1SD Absolute value of EBS1MN 100 Restated reported EBITDA Per Share Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward EBITDA Per Share Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for EBITDA Per Share for year ending HP Forecast EBITDA Per Share mean for estimate with year ending Time Series EBITDA Per Share mean for estimate with year ending 4 Static EBITDA Per Share median for estimate with year ending HP Static EBITDA Per Share standard deviation with estimate for year ending Static Total Revision data types ON DATASTREAM User G
5. Project Request completed Equity Screening l B E 5 ON DATASTREAM User Guide Page 12 of 142 Version 5 0 The analyst sponsorship tear sheet shows how many analysts are following a stock and how that has changed in recent history Median Datastream Advance 151 xj T Eil Edit B Data Category Enter MKS Search Expert Time period Not Applicable Settings 5 5 ioe x 20v 45v 10 5Y C a Datatype DEFAU E rz Cv Gem 3M C Base Equity indices Datatype Currency Applicable Unit trusts Investment trusts Bonds amp convertibles Bond indices amp CDS Economics IE S on Datastream MARKS amp SPENCER GRO OP 7 12 01 07 09 44 gmks Industry Group BDRET Country Code Industry Code MERCHAN Currency BPN Exchange rates Interest rates Commodities 5 Ticker DS Mnemonic S Basic Forecast Data Derivatives Median High Low 1m 9 5Chg Est Down 0307 39 21 40 53 33 30 0 20 23 7 3 3 670 39 29 17 56 FY2 03408 43 30 46 50 37 60 0 14 23 5 5 5 089 43 39 15 76 0309 48 27 54 00 37 60 0 45 18 5 4 8 388 14 23 El Single Series Overview Overview of Company Performance Overview of any Series E I B E 5 Forecast Overview 15 00 29 36 0 90 0 00 3 o o Median E arnings Forecasts amp Price Reference Data
6. Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 NDT2MN NDT3MN NDT4MN NDT5MN NDT2D NDT3D NDT4D NDT5D NDT2CV NDT3CV NDT4CV NDT5CV NDT2HI NDT3HI NDT4HI NDT5HI NDT2LO NDT3LO NDT4LO NDT5LO NDT2MD NDT3MD NDT4MD NDT5MD NDT2SD NDT3SD NDT4SD NDT5SD NDT2DN NDT3DN NDT4DN NDT5DN NDT2DNW NDT3DNW NDT4DNW NDT5DNW Page 62 of 142 NDT1DN4W NDT1UP NDT1UPW NDT1UP4W NDT1NET NDT1XD NDT1XDW NDT1XD4W NDT1XU NDT1XUW NDT1XU4W NDT1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values
7. I1 SD Absolute value of 11MN 100 NAVI1DN Number of INT1 estimates down since last monthly values NAVI1D4W Number of INT1 estimates down since the weekly values four weeks ago NAVHDNW Number of INT1 estimates down since last weekly values NAVI1HI Highest value of all INT1 estimates for a particular company NAVI1LO Lowest value of all INT1 estimates for a particular company NAVHMD Median value of all INT1 estimates for a company NAVHMN Mean value of all INT1 estimates for a company NAVI1NE Total number of estimates associated with INT1 forecast NAVHSD Standard deNAVlation of all the INT1 estimates that make up the consensus NAVHUP Number of INT1 estimates up since last monthly values NAVHUAW Number of INT1 estimates up since the weekly values four weeks ago NAVHUPW Number of INT1 estimates up since last weekly values NAVH YR e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced l B E S ON DATASTREAM User Guide Version 5 0 NAVI2CV NAVISCV NAVIACV NAVI2DN NAVI3DN NAVIADN NAVI2D4W NAVISDAW NAVI4DAW NAVI2DNW NAVISDNW NAVIADNW NAVI2HI NAVISHI NAVI4HI NAVI2LO NAVISLO NAVIALO NAVI2MD NAVISMD NAVIAMD NAVI2MN NAVISMN NAVIAMN NAVI2NE NAVIANE NAVI2SD NAVISSD NAVIASD NAVI2UP NAVISUP NAVIAUP NAVI2UAW NAVISUAW NAVIAUAW NAVI2UPW NAVISUPW NAVIAUPW NAVI2YR NAVI3YR NAVI4YR Page
8. 109 Recommendations cipio ado eot db gei Del 110 Price Target died au u Rede 110 Je month forward growth trates 23 oor Rer enia ni Erie eye 111 Forecast long term soie eda cecidere Segue 112 5 112 Flash estimates P 113 Price related and capital change dilution factor data 119 Chapter 6 1088 e ca tito Gee cm es See ee 120 B E S ON DATASTREAM User Guide Page 5 of 142 Version 5 0 Ghapter 7 131 B E S ON DATASTREAM User Guide Page 6 of 142 Version 5 0 Chapter 1 About this document Intended readership The I B E S on Datastream manual is intended for use only by Thomson Reuters clients In this document The primary focus of this reference guide is to provide you with definitions of the data types available the different methods of accessing the data and a list of related data types The information is presented in tables like this Description Mnemonics for other quarterly periods Number of INT1 estimates down since last monthly values I2DN I3DN I4DN This section is ordered by type of data company related items price related data and so on Refer to the table of contents to find the page you need
9. oct Now DEC Volatility MAPKS Z SPENCEP GROUP Beta 0 643 Correlation 0 303 Next Decl MAY O oman Dstaztrear 7 A Project Equity Screening 1 B E S ON DATASTREAM User Guide Page 14 of 142 Version 5 0 Additional excel sheets are also available from the Datastream Support Extranet http extranet datastream com examples are given below THOMSON REUTERS Datastream I B E S Global Aggregates Country Aggregates Update 3 mth Change in the 12 Fwd Estimate 3 mth Change in the 12 Fwd Estimate NAME ADMIC l BIE S ESTONIA ARGENTINA i UB E S SWITZERLAND 8 119 11 661 WBIEIS ISRAEL UB E S POLAND 0 598 10 431 IBIEIS SOUTH AFRICA I 5 TAIWAN 1 433 9 988 Categor RUSSIA TBIEIS INDONESIA UB E S JAPAN 335 7 782 VBIEIS IRELAND 1 220 7 409 VBIEIS BRAZIL UB E S SWEDEN 7184 WBIEIS CZECH REPUBLIC V BIEIS INDIA H VBIE S EGYPT 0616 6 796 l BIE S HONG KONG UB E S PORTUGAL 1048 6 251 l BIEIS MOROCCO UB E S NEW ZEALAND 2113 6 076 l BIEIS TURKEY UB E S DENMARK 2316 6015 AUSTRALIA V BIEIS CHINA VB E S 2 032 5 768 WB EIS AUSTRIA THOMSON REUTERS EPS Momentum Analysis Enter List for analysis wo Use Datastream Navigatorto find an appropriate list Select Fiscal Year FYA Download Data BES ccy Fiscal Est up Est down Total Est Mean FY1 EPS Total Est up Est down
10. EBD1UP EBD1UPW EBD1UPAW EBD1NET EBD1XD EBD1XDW EBD1XD4W EBD1XU EBD1XUW EBD1XU4W EBD1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast EBD2DN4W EBD3DN4W EBD4DN4W EBD5DN4W EBD2UP EBD3UP EBD4UP EBD5UP EBD2UPW EBD3UPW EBD4UPW EBD5UPW T2UP4W T3UP4W T4UP4W T5UP4W EBD2NET EBD3NET EBDANET EBD5NET EBD2XD EBD3XD EBD4XD EBD5XD EBD2XDW EBD3XDW EBDAXDW EBD5XDW EBD2XD4W EBD3XD4W EBDAXDAW EBD5XDAW EBD2XU EBD3XU EBDAXU EBD5XU EBD2XUW EBD3XUW EBD4XUW EBD5XUW EBD2XUAW EBD3XU4W EBD4XU4W EBD5XUAW EBD2NE EBD4NE EBD5NE
11. EVTI2LO EVTI3LO EVTI4LO EVTI2MD EVTI3MD EVTI4MD EVTI2MN EVTISMN EVTIAMN EVTI2NE EVTISNE EVTIANE EVTI2SD EVTISSD EVTI4SD EVTI2UP EVTI3UP EVTI4UP EVTI2U4W EVTI3U4W EVTIAUAW EVTI2UPW EVTISUPW EVTIAUPW EVTI2YR EVTISYR EVTIAYR Page 94 of 142 Free Cash Flow Per Share FCFIiD4W FCFI1DNW FCFI1HI FCFHLO FCFHNE FCFHSD FCFHUP FCFI1U4W FCFHUPW FCFI1YR e Coefficient of variation of all the INT1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11 MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Rela
12. tay du be dened che 58 Net Asset Value aaa onde vie emet ier deter code ne tk ide eet epe edt 60 Net Debt NDA ae hee ee a 62 INetincormie ING ode etsi crm diccre out caa 64 Reported Net Income NER rire eerie erede S EAEN dd e RR LE e Ee 66 Operating Protit OBB zc oe NI EAD A ERU 68 Pretax ProtitS PRE tec tee t dedu d cer t t decir du 70 Reported Pre tax Profits ie discreti tette titer hot ra 72 Rieturn On Assets ROA jc iieri tet e Rude nr oe edel hh n 74 Ret rm OnmEgq itly ROE a U u u tiber 76 78 Tangibl Book Value per Share TBV citiin erect eet tos 80 Quarterly actuals for additional measures U tnnt nnne 82 5 ON DATASTREAM User Guide Page 4 of 142 Version 5 0 Actuals data types Rm 82 Quarterly estimate data 84 Adjusted 84 Book Value Per Share ee cet ereptam op 85 Capital Expenditure su ts cdi aa uay e Dese Saa ei e eta ain 86 CashiEannings Per Slate ose eot itte emet 87 CashiFlow Pe
13. CPS5DN CPS2DNW CPS3DNW CPS4DNW CPS5DNW CPS2DN4W CPS3DN4W CPS4DN4W CPS5DNAW Page 38 of 142 CPS1UP CPS1UPW CPS1UPAW CPS1NET CPS1XD CPS1XDW CPS1XD4W CPS1XU CPS1XUW CPS1XU4W CPS1NE Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 CPS2UP CPS3UP CPS4UP CPS5UP CPS2UPW CPS3UPW CPS4UPW CPSSUPW CPS2UP4W CPS3UP4W CPS4UP4W CPSSUPAW CPS2NET CPS3NET CPS4NET 55 CPS2XD CPS3XD CPS4XD CPS5XD CPS2XDW CPS3XDW CPS4XDW CPS5XDW CPS2XDAW CPS3XD4W CPS4XD4W CPS5XD4W CPS2XU CPS3XU CPS4XU CPS5XU CPS2XUW CPSSXUW CPS4XUW CPS5XUW CPS2XUAW CPS3XU4W CPS4
14. EPSZZMD Median estimate for year ending in e The same data as EPSnMD but accessed by year end date EPS MN Mean estimate for year ending in e The same data as EPSnMN but accessed by year end date and not data type EPS NE e Number of estimates for fiscal year ending in e The same data as EPSnNE but accessed by year end date EPS SD Standard deviation of estimates for year ending e The same data as EPSnSD but accessed by year end date and not data type EPSZZYR e Fiscal year end date of the company for the requested year e For example EPS93YR returns 31 12 93 for a company with a December year end 5 ON DATASTREAM User Guide Page 25 of 142 Version 5 0 Estimates and Actuals on a fiscal year basis Static Fiscal Year data types are available via static requests and retrieve the latest value for the fiscal year These are an addition to the times series of fiscal year data types extending to a larger set of measures for both estimates and actuals please see Additional Measures for list of these data types The estimates data types are for Mean Median and Standard Deviation values In the below table is replaced by an YY date for example the actual value for EPS for 2006 can be retrieved using AOGEPS For the forecast estimates data types that identifies the measure i e F for EPS and E for a constant to indicate an estimate for example the forecast Mean value for EPS for 2006 can be
15. Fiscal Year End for EPS1 e Price to earnings ratio for FY1 e Calculated as Datastream price EPS1 Mean value for all FY1 estimates for a company Same as EPS1 e Fiscal year end of the next period to be reported e Returned in either American MM DD YY or European DD MM YY format same as EPS1D e Coefficient of variation of all the FY1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV EPS1SD Absolute value of EPS1MN 100 Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus Calculated PE ratio using 5 price data and FY1 mean estimate e B E S price data may not be updated daily lf the earnings estimate is negative the PER is not calculated a value of N A is returned EPS1PER IBP EPS1MN 12 month forward earnings per share Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Earnings Per Share for year ending ERS2 EPS2D EPS2MN EPSF3MN EPS4MN EPS5MN 2 EPS4YR EPS5YR EPS2CV EPS3CV EPS4CV EPS5CV EPS2HI EPS3HI EPS4HI EPS5HI EPS2LO EPS3LO EPS4LO EPS5LO EPS2MD EPS3MD EPS4MD EPS5MD EPS2SD EPS3SD EPS4SD EPS5SD ERS
16. pem 22 June 2010 THOMSON REUTE RS Thomson Reuters 2010 All Rights Reserved Thomson Reuters by publishing this document does not guarantee that any information contained herein is and will remain accurate or that use of the information will ensure correct and faultless operation of the relevant Service or equipment Thomson Reuters its agents and employees shall not be held liable to or through any user for any loss or damage whatsoever resulting from reliance on the information contained herein This document contains information proprietary to Thomson Reuters and may not be reproduced disclosed or used in whole or part without the express written permission of Thomson Reuters Any Software including but not limited to the code screen structure sequence and organization thereof and Documentation are protected by national copyright laws and international treaty provisions This manual is subject to U S and other national export regulations Nothing in this document is intended nor does it alter the legal obligations responsibilities or relationship between yourself and Thomson Reuters as set out in the contract existing between us l B E S ON DATASTREAM User Guide Page 2 of 142 Version 5 0 Contents 52 D 3 Chapter 1 About this LOCC ENE e 7 intended readership 7 Iy this document 7 2044 40
17. 2v Gem C Base Datatype Currency Not Applicable P j Data Category Enter 2 Expert ipe MKS Search Iv Exp Zi Datastream series i Equities Equity indices Unit trusts Investment trusts Bonds amp convertibles Bond indices amp CDS Economics 12 01 07 5 on Datastream MARKS amp SPENCER GROUP BES Ticker meus Country Code EX DS Mnemonic KS Industry Code MERCHAN Currency BPN Exchange rates Interest rates Commodities IE S Analyst Sponsorship E Derivatives PS Flash Flash 1M Ago 3M Ago 6M Ago 1Y Ago WEsts Up Down Mean E sts Mean sts E sts E sts E sts 23 7 3 38 96 10 00 39 29 24 25 24 25 Analysis 23 6 5 43 39 11 00 43 39 24 24 22 25 18 5 4 48 08 17 15 10 20 E Single Series Overview 2 4 45 05 2 2 2 1 o Overview of Company Performance Overview of any Series E i Forecast Overview EPS Growth Data Total Number OfE stimates amp Price Momentum Data Stock Valuation Data Analyst Sponsorship Data Analyst Agreement Data Median Data Thomson ONE browser pages Multiple Series Flexible Chart ingle Series Chart Single Series Report Interim EP S T T T T T T T T T T T T T T T T T T 200 E N DJ F M M J 9 O N D FYI NO ESTIMATES Fy2 NO ESTIMATES PRICE IBESKP H SCALE
18. BPS1XUW BPS1XU4W BPS1NE Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 BPS2DN BPS3DN BPS4DN BPS5DN BPS2DNW BPS3DNW BPS4DNW BPSSDNW BPS2DN4W BPS3DN4W BPS4DN4W BPSSDN4W BPS2UP BPS3UP BPS4UP BPS5UP BPS2UPW BPS3UPW BPS4UPW BPSSUPW BPS2UP4W BPS3UP4W BPS4UP4W BPS5UP4W BPS2NET BPS3NET BPSANET 55 BPS2XD BPS3XD BPS4XD BPS5XD BPS2XDW BPS3XDW BPS4XDW BPS5XDW BPS2XD4W BPS3XD4W BPS4XD4W BPS5X
19. FCFAXUAW FCF5XUAW FCF2NE FCF3NE FCFANE FCF5NE Page 53 of 142 Funds From Operations FFO FFO1MN FFO1D FOFFO FFOOYR FFO1CV ROFFO FFO1HI FFO1LO FFO1MD FFO1SD FFO1FD12 A FFO FFO MN FFOE MN FFOE MD FFOE SD FFO1DN Mean Funds From Operations for FY1 Fiscal Year End for FFO1MN Last Reported Funds From Operations Fiscal Year End for FOFFO e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV FFO1SD Absolute value of FFO1MN 100 Restated reported Funds From Operations Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Funds From Operations Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Funds From Operations for year ending HE Forecast Funds From Operations mean for estimate with year ending Time Series Funds From Operations mean for estimate with year ending Static Funds From Operations median for estimate with year ending Static Funds From Operations standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estima
20. PRE1LO PRE1MD PRE1MN PRE1NE PRE1NET PRE1SD PRE1UP PRE1UPAW PRE1UPW PRE1XD PRE1XD4W PRE1XDW PRE1XU PRE1XUAW PRE1XUW PREE MD PREE MN PREE SD PREI1CV PREI1D4W PREI1DN PREI1DNW PREI1HI PREI1LO PREIHMD PREITMN PREHNE PREHSD PREI1UAW PREI1UP PREI1UPW PREI1YR PRR MN PRROYR PRR1CV PRR1D PRR1DN PRR1DNAW PRR1DNW PRR1FD12 PRR1FD12 117 117 70 70 70 70 71 71 70 71 71 71 71 71 71 71 71 71 70 70 70 104 104 104 104 104 104 104 104 104 104 104 104 104 104 72 111 PRR1FMN PRR1FNE PRR1FSD PRR1HI PRR1LO PRR1MD PRR1MN PRR1NE PRR1NET PRR1SD PRR1UP PRR1UPAW PRR1UPW PRR1XD PRR1XD4W PRR1XDW PRR1XU PRR1XUAW PRR1XUW PRRE MD PRRE MN PRRE SD PRRITCV PRRIiD4W PRRI1DN PRRI1DNW PRRI1HI PRRI1LO PRRITMD PRRITMN PRRITNE PRRI1SD PRRI1UAW PRRI UP PRRI1UPW PRRI1YR PTDN1M PTDNAW PTHI PTLO PTMD PTMN PTNE PTSD 117 117 117 105 105 105 105 105 105 105 105 105 105 105 105 105 105 110 110 110 110 110 110 110 110 Page 139 of 142 PTUP1M PTUPAW R ROAFO ROBPS ROCAP ROCPS ROCSH RODPS ROEBD ROEBG ROEBS ROEBT ROEPS ROEVT ROFCF ROFFO ROGPS ROGRM ROINC RONAV RONDT RONER ROOPR ROPRE ROPRR ROROA ROROE ROSAL ROTBV RECCON RECNO RECTXT RICAP RIEBD RIEBT RIEPS RIEVT RIGRM RIINC RIOPR RISAL ROA MN ROAOYR ON DATASTREAM User Guide Version 5 0 110 110 30 32 34 38 36 40 46 42 48 44 27 50 52
21. Return On Equity mean for estimate with year ending Time Series Return On Equity mean for estimate with year ending Static Return On Equity median for estimate with year ending Static Return On Equity standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 ROE2MN ROE3MN ROE4MN ROESMN ROE2D ROESD ROE4D ROES5D ROE2CV ROE4CV ROE5CV ROE2HI ROE3HI ROE4HI ROESHI ROE2LO ROESLO ROE4LO ROESLO ROE2MD ROESMD ROE4MD ROE5MD ROE2SD ROESSD ROE4SD ROE5SD ROE2DN ROESDN ROE4DN ROESDN ROE2DNW ROESDNW ROE4DNW ROESDNW Page 76 of 142 ROE1DNAW ROE1UP ROE1UPW ROE1UPAW ROE1NET ROE1XD ROE1XDW ROE1XD4W ROE1XU ROE1XUW ROE1XU4W ROE1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last
22. weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 ROE2DN4W ROESDN4W ROE4DN4W ROE4DN4W ROE2UP ROE3UP ROE4UP ROESUP ROE2UPW ROE3UPW ROE4UPW ROESUPW ROE2UP4W ROE3UP4W ROE4UP4W ROESUPAW ROE2NET ROESNET ROE4NET ROESNET ROE2XD ROE3XD ROE4XD ROE5XD ROE2XDW ROE3XDW ROE4XDW ROESXDW ROE2XD4W ROESXD4W ROE4XD4W ROE5XD4W ROE2XU ROE3XU ROE4XU ROE5XU ROE2XUW ROE3XUW ROE4XUW ROESXUW ROE2XUAW ROESXUAW ROE4XU4W ROES5XUAW ROE2NE ROESNE ROE4NE ROESNE Page 77 of 142 Sales SAL SAL1MN SAL1D FOSAL SALOYR SAL1CV ROSAL SAL1HI SAL1LO SAL1MD SAL1SD SAL1FD12 A SAL SAL MN SALE MN SALE MD SALE SD SAL1DN SAL1DNW Mean Sales for FY1 Fiscal Year End for SAL1MN Last Reported Sales Fiscal Year End for FOSAL e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV SAL1SD Absolute value of SAL1MN 100 Restated reported Sales Highest value of all FY
23. 99 of 142 Net Debt NDTI1CV NDTI1DN NDTI1D4W NDTHDNW NDTI1HI NDTHLO NDTI1MD NDTI1MN NDTHNE NDTHSD NDTHUP NDTHUAW NDTHUPW NDTI1YR e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation Calculated according to the equation CV I1 SD Absolute value of 11MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 NDTI2CV NDTI3CV NDTI4CV NDTI2DN NDTI3DN NDTI4DN NDTI2D4W NDTI3D4W NDTIADAW NDTI2DNW NDTISDNW NDTIADNW NDTI2HI NDTISHI NDTI4HI NDTI2LO NDTISLO NDTIALO NDTI2MD NDT
24. B E 5 i Forecast Overview EPS Growth Data Calculated P E Ratios amp Price Momentum Data Stock Valuation Data Analyst Sponsorship Data Analyst Agreement Data i Median Data Thomson ONE browser pages 19 Multiple Series Flexible Chart SEITE Single Series Chart LLL FY2 RATIO Single Series Report Pee Single Series Data gt omeen Thomzon Datarea gt Project Equity Screening Request completed The stock valuation tear sheet shows recent history for price earnings data based on 5 forecast earnings as the denominator EPS Growth Datastream Advance Pate Category Enter KS Search Expert Time Period Not Applicable i Series Datastroam series 20v 15 10Y sy Equiti E quies Datatype 27 rz No 2v Gem C Base Equity indices Datatype Unit trusts Investment trusts Currency Applicable zi Bonds amp convertibles Bond indices amp CDS Economics 25 on Datastream een 5 11 01 07 15 48 E MARKS amp SPENCER GROUP change rates S Ticker MKS Country Code EX Interest rates DS Mnemonic MKS Industry Code MERCHAN Currency PN Commodities WBE S Forecast Growth Rates amp Derivatives 1M Ago Actual E arnings 2 FY4 F Yo 92 d A 24 5 5 5 Growth Analysis 2 v4 a t 5Yr
25. DATASTREAM User Guide Version 5 0 ROA2MN ROA3MN ROA4MN ROASMN ROA2D ROA3D ROA4D ROA5D ROA2CV ROA4CV ROA5CV ROA2HI ROA3HI ROA4HI ROABHI ROA2LO ROA3LO ROA4LO ROASLO ROA2MD ROA3MD ROA4MD ROASMD ROA2SD ROASSD ROA4SD ROA5SD ROA2DN ROA3DN ROA4DN ROASDN ROA2DNW ROASDNW ROA4DNW ROASDNW Page 74 of 142 ROA1DNAW ROA1UP ROA1UPW ROA1UPAW ROA1NET ROA1XD ROA1XDW ROA1XD4W ROA1XU ROA1XUW ROA1XU4W ROA1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 ROA2DN4W ROA3DN4W ROA4
26. DATASTREAM User Guide Version 5 0 A company s total sales revenue minus cost of goods sold divided by the total sales revenue expressed as a percentage The rate of change in earnings per share over the five year period that ends on the Current fiscal year end date The Growth rate in EPS through the current fiscal year is derived by fitting a least squares growth line to the logarithms of 20 values of rolling annual earnings per share for each Company The largest Current EPS estimate for the specified fiscal time period The description of the homogenous group of companies with similar business lines to that of the Company l B E S maintains its own proprietary classification system which segregates companies at three different levels Sector Industry Group Sectors are subdivided into Industries which are in turn subdivided into Groups The U S Industries are loosely based on the S amp P 500 industry classifications and the classification system for non US companies is similar to the Morgan Stanley Capital Index In addition I B E S provides several reports that are based on specialty classification schemes such as the Toronto Stock Exchange 300 and the Dow Zones Equity Index The quarterly or semi annual earnings per share for the Company that was announced for the specified interim fiscal time periods Interim EPS is expressed in general on a primary basis excluding extraordinary items and discontinued operations and is adju
27. Flow Per Share FCF Reported Pre Tax Profit PRR l B E 5 ON DATASTREAM User Guide Version 5 0 Page 8 of 142 I B E S History l B E S s extensive historical forecast data dates back to 1976 for the US and 1987 for non US History is available globally for the full range of I B E S forecast measures For more information on how to gain access to 5 history please speak to your usual Thomson Reuters contact Regional summary consensus estimates Analysis by the following regional groupings is also available for the 5 summary consensus estimates product Pacific e Canada e Emerging markets e Europe e Japan Latin America e USA These are available updates only on a similar basis to the EPS1 EPS2 and associated data types listed above e As updates and history with history starting at the base date of each series As history only e Additional Measures history I B E S Global Aggregates IB E S aggregate their stock level forecasts into market and proprietary index level global aggregates This is a separate service described in the I B E S Global Aggregates on Datastream Reference Guide Please speak with your Thomson Reuters sales or support representative for more details I B E S Tear Sheet Reports Datastream provides a range of fixed format reports for customers who have access to summary consensus earnings from I B E S The reports are based on the main principles
28. I B E S values on the Datastream research 16 Requesting monthly data at different dates ieri itti iiti erii verdi 17 Dummy Mnemonics to display the latest daily weekly and monthly values 17 Chapter 3 Company related items J U 18 Chapter 4 Market Driven 19 IRIS related Change S oerte o Rz get cong 19 specific data types u u codes dices ou n eria ev area o ag od uc n dva x 20 ODIO expeliS 20 Chapter5 EPS dala Uy CS aac 22 I B E S ON DATASTREAM User Guide Page 3 of 142 Version 5 0 gt Sok ate tani noe ade n ULM MM 24 Historical long term 25 EPS forecasts by fiscal year Time ISerlestuu S oit iet rider Rura ater temer desee dpt eet eod apu eds 25 Estimates and Actuals on a fiscal year basis Static sss eene 26 Actual annual EPS rre rece tat au ere FU ga oe dni ete RE aaa iodide 26 Actualinterim Le a Es 27 Restated pet dto Sel HH ege Padi aba aa 27 Chapter 6 Additional 1 u
29. INT1 estimates measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 CSHI2CV JKISCV JKIACV CSHI2DN JKISDN JKIADN CSHI2D4W CSHISDAW CSHI4D4W CSHI2DNW CSHISDNW CSHIADNW CSHI2HI CSHI3HI CSHI4HI CSHI2LO CSHISLO CSHI4LO CSHI2MD CSHI3MD CSHI4MD CSHI2MN JKISMN CSHIAMN CSHI2NE CSHISNE CSHIANE CSHI2SD CSHISSD CSHIASD CSHI2UP CSHISUP CSHI4UP CSHI2UAW CSHISUAW CSHI4U4W KI2UPW KISUPW KI4UPW CSHI2YR CSHISYR CSHIA
30. INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 EBDI2CV EBDISCV EBDI4CV EBDI2DN EBDISDN EBDI4DN EBDI2D4W EBDI3D4W EBDI4D4W EBDI2DNW EBDISDNW EBDIADNW EBDI2HI EBDI4HI EBDI2LO EBDI3LO EBDI4LO EBDI2MD EBDI3MD EBDI4MD EBDI2MN EBDISMN EBDIAMN EBDI2NE EBDISNE EBDIANE EBDI2SD EBDISSD EBDI4SD EBDI2UP EBDI3UP EBDI4UP EBDI2U4W EBDI3U4W EBDIAUAW EBDI2UPW EBDISUPW EBDIAUPW EBDI2YR EBDIS3YR EBDIAYR Page 92 of 142 Earnings Before Interest Taxes Depreciation and Amortization Per Share EBSHCV Coefficient of variation of all the INT1 estimates e measure of the spread of the estimates in terms of the standar
31. Number of INT1 estimates down since last weekly values GRMI1HI Highest value of all INT1 estimates for a particular company GRMI1LO Lowest value of all INT1 estimates for a particular company GRMI1MD Median value of all INT1 estimates for a company GRMI1MN Mean value of all INT1 estimates for a company GRMHNE Total number of estimates associated with INT1 forecast GRMI1SD Standard deviation of all the INT1 estimates that make up the consensus GRMITUP Number of INT1 estimates up since last monthly values GRMHUAW Number of INT1 estimates up since the weekly values four weeks ago GRMHUPW Number of INT1 estimates up since last weekly values GRMI1YR e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced l B E S ON DATASTREAM User Guide Version 5 0 GRMI2CV GRMISCV GRMI4CV GRMI2DN GRMI3DN GRMI4DN GRMI2D4W GRMI3D4W GRMI4D4W GRMI2DNW GRMISDNW GRMI4DNW GRMI2HI GRMI3HI GRMI4HI GRMI2LO GRMI3LO GRMI4LO GRMI2MD GRMISMD GRMI4MD GRMI2MN GRMI3MN GRMI4MN GRMI2NE GRMISNE GRMI4NE GRMI2SD GRMISSD GRMI4SD GRMI2UP GRMISUP GRMI4UP GRMI2U4W GRMI3U4W GRMI4U4W GRMI2UPW GRMISUPW GRMI4UPW GRMI2YR GRMISYR GRMI4YR Page 98 of 142 Net Asset Value NAVHCV e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation Calculated according to the equation CV
32. PREI1FSD PREI2FSD PRR2FMN PRRI1FMN PRRI2FMN PRR2FNE PRRI1FNE PRRI2FNE PRR2FSD PRRI1FSD PRRI2FSD ROA2FMN ROAI1FMN ROAI2FMN ROA2FNE ROAI1FNE ROAI2FNE ROA2FSD ROAI1FSD ROAI2FSD ROE2FMN ROEI1FMN ROEI2FMN ROE2FNE ROEI1FNE ROEI2FNE ROE2FSD ROEI1FSD ROEI2FSD SAL2FMN SALI1FMN SALI2FMN SAL2FNE SALI1FNE SALI2FNE SAL2FSD SALHFSD SALI2FSD Page 117 of 142 TBV1FMN Mean of all FY1 estimates received in the last four weeks TBV2FMN TBVI1FMN TBVI2FMN TBV1FNE Total number of FY1 estimates received in the last four weeks TBV2FNE TBVHFNE TBVI2FNE TBV1FSD Standard deviation of all the FY1 estimates received the last TBV2FSD TBVI1FSD four weeks TBVI2FSD ON DATASTREAM User Guide Page 118 of 142 Version 5 0 Price related and capital change dilution factor data types IBDY e Dividend yield e A measure of the rate of return on annual cash dividend income e Calculated from annualized dividend rate and last price for company IBDY 100 ANDIV IBP IBNOSH e Number of shares outstanding in millions e A measure of the amount of stock that can be publicly traded e For US companies IBNOSH is the actual number of shares outstanding less treasury stock e For non US companies IBNOSH is the total number of shares outstanding IBP e The 5 price BP is not a Datastream sourced price e Itis updated weekly at the usual 5 weekly update time and is used in a
33. PRR1XDW PRR1XD4W PRR1XU PRR1XUW PRR1XU4W PRR1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 PRR2DN4W PRR3DN4W PRR4DN4W PRR5DN5W PRR2UP PRR3UP PRR4UP PRR5UP PRR2UPW PRR3UPW PRR4UPW PRRSUPW PRR2UP4W PRR3UP4W PRR4UP4W PRR5UP4W PRR2NET PRR4NET PRR5NET PRR2XD PRR3XD PRR4XD PRR5XD PRR2XDW PRR3XDW PRR4XDW PRR5XDW PRR2XD4W PRR3XD4W PRR4XD4W PRR5XD4W PRR2XU PRR4XU PRR5XU PRR2XUW PRR3XUW PRR4XUW PRR5XUW PRR2XU4W PRR3XU4W PRR5XUAW PRR2NE PRRSNE PRR4NE PRR5NE
34. PTUP1M PTDN1M PTMD PTSD Price target mean value Price target number of estimates Price target high value Price target low value Price targets up in the last four weeks Price targets down in the last four weeks Price target up In Last Month Price target down In Last Month Price target median value Price target standard deviation ON DATASTREAM User Guide Version 5 0 Strong Buy Buy Hold Under Perform Sell Page 110 of 142 12 month forward growth rate EPS1FD12 Also referred to as 12 month forward EPS Calculated on the fly from the mean values The 12 month forward EPS for FY1 is calculated as follows EPS1FD12 M x F1 12 M x F2 12 where M Number of month ends to end of current fiscal year Note that the current fiscal year will be FY1 if the date is before FY1 year end and FY2 if the date is after FY1 year end F1 Consensus earnings forecast for current fiscal year F2 Consensus earnings forecast for next fiscal year This data type is particularly useful for time series analysis of earnings forecasts over recent history especially where the period of measurement incorporates a fiscal year end AFO1FD12 12 month forward AFO Adjusted Funds for Operations BPS1FD12 12 month forward BPS Book Value per share CAP1FD12 12 month forward CAP Capital Expenditure CSH1FD12 12 month forward CSH Cash Earnings per share CPS1FD12 12 month forward CPS Cash Flow per share DPS1FD12 12
35. SAL1SD SAL1UP SAL1UP4W SAL1UPW SAL1XD SAL1XD4W SAL1XDW SAL1XU SAL1XUAW SAL1XUW SALE MD SALE MN SALE SD SALH CV SALI1DAW SALH DN ON DATASTREAM User Guide Version 5 0 78 78 78 78 78 78 78 112 117 117 117 78 78 78 78 79 79 78 79 79 79 79 79 79 79 79 79 78 78 78 108 108 108 SALH DNW SALHHI SALHLO SALHMD SALHMN SALHNE SALHSD SALI1U4W SALI1UP SALI1 UPW SALI1YR SPLDTE SPLFCT SUE SURDT SURMN SURPD SURPP SURSD T TBV MN TBVOYR TBV1CV TBV1D TBV1DN TBV1DNAW TBV1DNW TBV1FD12 TBV1FD12 TBV1FMN TBV1FNE TBV1FSD TBV1HI TBV1LO TBV1MD 108 108 108 108 108 108 108 108 108 108 108 119 119 112 112 112 113 113 113 80 80 80 80 80 81 81 80 112 118 118 118 80 80 80 TBV1MN TBV1NE TBV1NET TBV1SD TBV1UP TBV1UPAW TBV1UPW TBV1XD TBV1XD4W TBV1XDW TBV1XU TBV1XU4W TBV1XUW TBVE MD TBVE MN TBVE SD TBVI1CV TBVI1D4W TBVHDN TBVHDNW TBVI1HI TBVI1LO TBVHMD TBVHMN TBVHNE TBVI1SD TBVHUAW TBVHUP TBVHUPW TBVH YR Y YR5GTH YR5STB 80 81 81 80 81 81 81 81 81 81 81 81 81 80 80 80 109 109 109 109 109 109 109 109 109 109 109 109 109 109 25 25 Page 141 of 142 2009 Thomson Reuters All rights reserved For more information Republication or redistribution of Thomson Reuters content including by framing or similar means is Send us a sales enquiry at prohibited without the prior written consent
36. TBV3MD TBV4MD TBV5MD TBV2SD TBV3SD TBV4SD TBV5SD TBV2DN TBV3DN TBV4DN TBV5DN Page 80 of 142 TBV1DNW TBV1DN4W TBV1UP TBV1UPW TBV1UPAW TBV1NET TBV1XD TBV1XDW TBV1XD4W TBV1XU TBV1XUW TBV1XU4W TBV1NE Number of FY1 estimates down since last weekly values Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 TBV2DNW TBV3DNW TBV4DNW TBV5DNW TBV2DNAW TBV3DN4W TBV4DN4W TBV5DNAW TBV2UP TBV3UP TBV4UP TBV5UP TBV2UPW TBV3UPW TBV4UPW TBV5UPW TBV2UP4W TBV3UP4W TBV4UP4W TBV5UP4W TBV2NET TBV3NET TBV4
37. all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Dividends Per Share Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Earnings Before Goodwill Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks ON DATASTREAM User Guide Version 5 0 AFO2FSD AFOI1FSD AFOI2FSD BPS2FMN BPSI1FMN BPSI2FMN BPS2FNE BPSI1FNE BPSI2FNE BPS2FSD BPSI1FSD BPSI2FSD CAP2FMN CAPI1FMN CAPI2FMN CAP2FNE CAPHFNE CAPI2FNE CAP2FSD CAPHFSD CAPI2FSD CSHI2FMN CSHI1FMN CSHI2FMN CSHI2FNE CSHI1FNE CSHI2FNE CSHI2FSD CSHI1FSD CSHI2FSD CPS2FMN CPSI1FMN CPSI2FMN CPS2FNE CPSI1FNE CPSI2FNE CPS2FSD CPSI1FSD CPSI2FSD DPS2FMN DPSI1FMN DPSI2FMN DPS2FNE DPSI1FNE DPSI2FNE DPS2FSD DPSITFSD DPSI2FSD EBG2FMN EBGI1FMN EBGI2FMN EBG2FNE EBGI1FNE EBGI2FNE Page 114 of 142 EBG1FSD EBT1FMN EBT1FNE EBTHFSD EBD1FMN EBD1FNE EBD1FSD EBS1FMN EBS1FNE EBS1SD EVT1FMN EVT1FNE EVT1FSD FCF1FMN FCF1FNE FCF1FSD FFO1FMN FFO1FNE FFO1FSD Standard deviation of all the FY1 estimates received in the last
38. are listed on the following pages The mnemonics listed in the first column of each table are for fiscal year 1 data types For other fiscal years change the 1 to a 2 or 3 For example BPS2 is the mnemonic for the mean book value per share FY2 Available mnemonics for other fiscal years are listed in the Mnemonics for other fiscal years column Descriptions are consistent across all fiscal years for FY1 substitute FY2 or FY3 in the descriptions given below B E S ON DATASTREAM User Guide Page 29 of 142 Version 5 0 Adjusted Funds From Operations AFO AFO1MN AFO1D FOAFO AFOOYR AFO1CV ROAFO AFO1HI AFO1LO AFO1MD AFO1SD AFO1FD12 A AFO AFO MN AFOE MN AFOE MD AFOE SD AFO1DN AFO1DNW Mean Adjusted Funds From Operations for FY1 Fiscal Year End for AFO1MN Last Reported Adjusted Funds From Operations Fiscal Year End for FOAFO e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV AFO1SD Absolute value of AFO1MN 100 Restated reported Adjusted Funds From Operations Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Adjusted Funds From Operatio
39. date is expressed as day month Page 127 of 142 Price Range Price Earnings Ratio EPS1PER EPS2PER etc Primary Earnings Per Share DILFCT Production Cycles Recommendations Relative Surprise Return on Assets ROA Return on Equity ROE ON DATASTREAM User Guide Version 5 0 The absolute high and low price per share over the latest 52 week period A widely used stock evaluation measure The Price Earnings ratio is calculated by dividing the Last l B E S price by the Average EPS Estimate for the specified fiscal time period A measure of Company profitability that excludes all common stock equivalents whose conversion exercise or contingent issuance is potentially dilutive in the computation of earnings per share amounts A Current EPS estimate will be shown as a Primary earnings per share amount whenever there is a need to maintain its comparability with the others for the Company When the letter D does not follow the Dilution Factor or the Last Fiscal Year it indicates that Primary earnings per share amounts are being presented or enter into the calculations There are several ways to refer to the 5 monthly cycle dates all of which refer to the same date The most frequent definitions of the I B E S run date are The Thursday that falls between the 14th and 20th of each month The Thursday before the third Friday of the month The Thursday of the week in which options expire The r
40. debt minority interest and preferred shares minus total cash and cash equivalents Cash equivalents are defined as an item on the balance sheet that reports the value of a company s assets that can be converted into cash immediately Examples of cash and equivalents are bank accounts marketable securities and treasury bills An Enterprise Value actual is calculated using the closing price at the end of the fiscal period A measure of the variation in the set of Current EPS estimates The EPS estimate range is given by the highest Current EPS estimate and the lowest Current EPS estimate values A statistical measure of the scatter in the Current EPS estimate amounts for the specified fiscal time period Estimate Dispersion is based on deviations of Current EPS estimates and is therefore expressed in the same units It is the standard deviation of the variance in the Current EPS estimate for the specified fiscal time period A composite forecast of the anticipated annual growth rate in earnings per share over the longer term The Expected EPS long term growth rate is the median or middle Current EPS estimate or by convention the average of the two middle values 5 Inc requests that each Contributing firm focus on the five year time interval that begins on the first day of the Current Fiscal Year and make their calculations based on projections of EPS before extraordinary items The Average EPS Estimate for the specified fiscal tim
41. four weeks EBIT Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks EBITDA Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks EBITDA PER SHARE Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Enterprise Value Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Free Cash Flow Per Share Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Funds From Operations Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks ON DATASTREAM User Guide Version 5 0 EBG2FSD EBGI1FSD EBGI2FSD EBT2FMN EBTII1FMN EBTII2FMN EBT2FNE EBTII1FNE E
42. four weeks Standard deviation of all the FY1 estimates received in the last four weeks Net Income Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Reported Net Income Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Operating Profits ON DATASTREAM User Guide Version 5 0 GPS2FMN GPSHFMN GPSI2FMN GPS2FNE GPSI1FNE GPSI2FNE GPS2FSD GPSI1FSD GPSI2FSD GRM2FMN GRMI1FMN GRMI2FMN GRM2FNE GRMI1FNE GRMI2FNE GRM2FSD GRMI1FSD GRMI2FSD NAV2FMN NAVI1FMN 2 NAV2FNE NAVI1FNE NAVI2FNE NAV2FSD NAVI1FSD NAVI2FSD NDT2FMN NDTI1FMN NDTI2FMN NDT2FNE NDTI1FNE NDTI2FNE NDT2FSD NDTI1FSD NDTI2FSD INC2FMN INCI1FMN INCI2FMN INC2FNE INCI1FNE INCI2FNE INC2FSD INCI1FSD INCI2FSD NER2FMN NERI1FMN NERI2FMN NER2FNE NERI1FNE NERI2FNE NER2FSD NERI1FSD NERI2FSD Page 116 of 142 OPR1FMN OPR1FNE OPR1FSD PRE1FMN PRE1FNE PRE1FSD PRR1FMN PRR1FNE PRR1FSD ROA1FMN ROA1FNE ROA1FSD ROE1FMN ROE1FNE ROE1FSD SAL1FMN SAL1FNE SAL1FSD Mean of all FY1 estimates received in the last four weeks Total number of FY1 es
43. four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 NDT2DN4W NDT3DN4W NDT4DN4W NDT5DN4W NDT2UP NDT3UP NDT4UP NDT5UP NDT2UPW NDT3UPW NDT4UPW NDTSUPW Q2UP4W Q3UP4W Q4UP4W Q5UP4W NDT2NET NDT4NET 5 NDT2XD NDT3XD NDT4XD NDT5XD NDT2XDW NDT3XDW NDT4XDW NDT5XDW NDT2XD4W NDT3XD4W NDT4XD4W NDT5XD4W NDT2XU NDT3XU NDT4XU NDT5XU NDT2XUW NDT3XUW NDT4XUW NDT5XUW NDT2XU4W NDT3XU4W NDT4XU4W NDT5XUAW NDT2NE NDT4NE 5 Page 63 of 142 Net Income INC INC1MN INC1D FOINC INCOYR INC1CV ROINC INC1LO INC1MD INC1SD INC1FD12 A INC INC MN INCE MN INCE MD INCE SD INC1DN INC1DNW Mean Net Income for FY1 Fiscal Year End for INC1MN Last Reported Net Income Fiscal Year End FOINC e Coefficient of variation of all the FY1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV INC1SD Absolute value of INC1MN 100 Restated reported Net Income Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Net Income Estimates and A
44. last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 GRM2DN4W GRMSDNAW GRM4DN4W GRM5DN4W GRM2UP GRM3UP GRM4UP GRM5UP GRM2UPW GRM3UPW GRM4UPW GRM5UPW GRM2UP4W GRM3UP4W GRM4UP4W GRM5UP4W GRM2NET GRMSNET GRMANET GRM5NET GRM2XD GRMSXD GRM4XD GRM5XD GRM2XDW GRMSXDW GRM4XDW GRM5XDW GRM2XD4W GRM3XD4W GRM4XD4W GRM5XDAW GRM2XU GRMSXU GRM4XU GRM5XU GRM2XUW GRM3XUW GRM4XUW GRM5XUW GRM2XUAW GRM3XU4W GRM4XU4W GRM5XUAW GRM2NE GRMSNE GRMANE GRM5NE Page 59 of 142 Net Asset Value NAV NAV1MN NAV1D FONAV NAVOYR NAV1CV RONAV NAV1HI NAV1LO NAV1MD NAV1SD NAV1FD12 A NAV NAV MN NAVE MN NAVE MD NAVE SD NAV1DN NAV1DNW M
45. month forward DPS Dividends per share EBG1FD12 12 month forward EBG Earnings Before Goodwill EBT1FD12 12 month forward EBT EBIT EBD1FD12 12 month forward EBD EBITDA EBS1FD12 12 month forward EBS EBITDA per share EVT1FD12 12 month forward EVT Enterprise Value FCF1FD12 12 month forward FCF Free Cash Flow per share FFO1FD12 12 month forward FFO Funds for Operations per share GPS1FD12 12 month forward GPS GAAP per share GRM1FD12 12 month forward Gross Margin NAV1FD12 12 month forward NAV Net Asset Value NDT1FD12 12 month forward NDT Net Debt INC1FD12 12 month forward INC Net Income NER1FD12 12 month forward NER Reported Net Income OPR1FD12 12 month forward OPR Operating Profit PRE1FD12 12 month forward PRE Pre tax profit PRR1FD12 12 month forward PRR Reported Pre tax profit PEFD12 12 month forward PE Price Earnings ROA1FD12 12 month forward ROA Return on Assets 5 ON DATASTREAM User Guide Page 111 of 142 Version 5 0 ROE1FD12 12 month forward ROE Return on Equity SAL1FD12 12 month forward SAL Sales TBV1FD12 12 month forward TBV Tangible Book Value per Share Forecast long term growth LTDN Number of long term growth estimates down in the last month LTDNW Number of long term growth estimates down since last weekly values LTDN4W Number of long term growth estimates down since the weekly values four weeks ago LTHI Highest value of the long term growth estimates LTLO
46. of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 SAL2DN4W SAL3DN4W SAL4DN4W SAL5DNAW SAL2UP SAL3UP SAL4UP SAL5UP SAL2UPW SAL3UPW SALAUPW SALSUPW SAL2UPAW SAL3UP4W SALAUPAW SALSUPAW SAL2NET SAL3NET SALANET SALSNET SAL2XD SALS3XD SAL4XD SAL5XD SAL2XDW SAL3XDW SALAXDW SAL5XDW SAL2XD4W SAL3XD4W SAL4XD4W SAL5XD4W SAL2XU SAL3XU SAL4XU SAL5XU SAL2XUW SAL3XUW SAL4XUW SAL5XUW SAL2XU4W SAL3XU4W SAL4XU4W SAL5XU4W SAL2NE SAL3NE SAL4NE SAL5NE Page 79 of 142 Tangible Book Value per Share TBV TBV1MN TBV1D FOTBV TBVOYR TBV1CV ROTBV TBV1HI TBV1LO TBV1MD TBV1SD TBV1FD12 A TBV TBV MN TBVE MN TBVE MD TBVE SD TBV1DN Mean Tangible Book Value pe
47. of variation of all the FY1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV CPS1SD Absolute value of CPS1MN 100 Restated reported Cash Flow Per Share Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Cash Flow Per Share Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Cash Flow Per Share for year ending Forecast Cash Flow mean for estimate with year ending Time Series Cash Flow mean for estimate with year ending Static Cash Flow median for estimate with year ending Static Cash Flow standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values Number of FY1 estimates down since the weekly values four weeks ago ON DATASTREAM User Guide Version 5 0 CPS2MN CPS3MN CPS4MN CPS5MN CPS2D CPS3D CPS4D CPS5D CPS2CV CPS3CV CPS4CV CPS5CV CPS2HI CPS3HI CPS4HI CPS5HI CPS2LO CPS3LO CPS4LO CPS5LO CPS2MD CPS3MD CPS4MD CPS5MD CPS2SD CPS3SD CPS4SD CPS5SD CPS2DN CPS3DN CPS4DN
48. pre IFRS basis are available These data types have the same stem mnemonics as existing data types but with a G suffix For example SAL1 G will return mean sales for FYI based on estimates made on a pre IFRS basis e Asetof IFRS mean data types will start to be populated for a company as IFRS estimates become available and will continue to be available after the point at which the majority of contributor estimates become IFRS estimates These data types have the same stem mnemonics as existing data types but with a I suffix For example SAL1 1 will return mean sales for FYI based on estimates made on an IFRS basis e Asetof IFRS specific data types is available to return details about the transition from post goodwill to pre goodwill calculation and to enable you to identify those exceptional cases where EPS is in line with a fully reported definition Existing EBG data types will continue to be updated with the same pre goodwill data as EPS data types and after the transition these will be updated with IFRS data I B E S ON DATASTREAM User Guide Page 19 of 142 Version 5 0 IFRS specific data types Data types with a G suffix return mean values calculated from estimates on a pre IFRS basis Data types with 1 suffix return mean values calculated from estimates on an IFRS basis E EBGDT A static data type returning the date of the transition from post goodwill calculation of earnings per share
49. to pre goodwill calculation IFRSDT A static data type returning the date after which IFRS estimates are in the majority for a company EBASE A test time series data type returning e EPS for the period up to transition from pos goodwill calculation of earnings per share to pre goodwill calculation e n exceptional cases where EPS is in line with a fully reported definition EBASE returns EPS throughout the history of the data type until the transition to IFRS for the period after the transition from post goodwill calculation of earnings per share to pre goodwill calculation e IFRS after the transition to the IFRS basis for calculation of default mean estimates EBASEN e Anumeric time series data type returning 100 for the period up to the transition from post goodwill calculation of earnings per share to pre goodwill calculation and 0 for the period after the transition e This data type can be displayed graphically or manipulated with Datastream functions Option expense The Security and Exchange Commission s ruling on the expensing of stock options FAS123 R for US publicly traded companies was introduced on December 16 2004 This requires North American companies to calculate and amortize stock option expenses through the income statement for fiscal years beginning after June 15 2005 Stock option expenses are only included in the EPS mean when the majority of contributing analysts have
50. value for pre tax profits for year ending HE Forecast Pre tax Profits mean for estimate with year ending Time Series Pre tax Profits mean for estimate with year ending Static Pre tax Profits median for estimate with year ending Static Pre tax Profits standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 PRE2MN PRE3MN PRE4MN PRESMN PRE2D PRESD PRE4D PRESD PRE2CV PRESCV PRE4CV PRE5CV PRE2HI PRE3HI PRE4HI PRESHI PRE2LO PRE3LO PRE4LO PRE5LO PRE2MD PRESMD PRE4MD PRESMD PRE2SD PRESSD PRE4SD PRE5SD PRE2DN PRESDN PRE4DN PRESDN PRE2DNW PRESDNW PRE4DNW PREBDNW Page 70 of 142 PRE1DNAW PRE1UP PRE1UPW PRE1UPAW PRE1NET PRE1XD PRE1XDW PRE1XD4W PRE1XU PRE1XUW PRE1XU4W PRE1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Numbe
51. values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 AFO2DN4W AFO3DN4W AFO4DN4W AFOSDNAW AFO2UP AFO3UP AFO4UP AFOSUP AFO2UPW AFO3UPW AFO4UPW AFOSUPW AFO2UP4W AFO3UP4W AFO4UP4W AFO5UP4W AFO2NET AFO4NET AFOSNET AFO2XD AFO3XD AFO4XD AFO5XD AFO2XDW AFO3XDW AFO4XDW AFO5XDW AFO2XD4W AFO3XD4W AFO4XD4W AFO5XD4W AFO2XU AFO3XU AFO4XU AFO4XU AFO2XUW AFO3XUW AFO4XUW AFO5XUW AFO2XU4W AFO3XU4W AFO5XU4W AFO5XUAW AFO2NE AFO4NE AFOSNE ON DATASTREAM User Guide Version 5 0 Page 31 of 142 Book Value per Share BPS BPS1MN BPS1D FOBPS BPSOYR BPS1CV ROBPS BPS1HI BPS1LO BPS1MD BPS1SD BPS1FD12 A BPS BPS MN BPSE MN BPSE MD BPSE SD Mean Book Value Per Share for FY1 Fiscal Year End for BPS1MN Last Reporte
52. 1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Sales Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for sales for year ending HE Forecast Sales mean for estimate with year ending Time Series Sales mean for estimate with year ending Static Sales median for estimate with year ending Static Sales standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 SAL2MN SAL3MN SALAMN SAL5MN SAL2D SAL3D SAL4D SAL5D SAL2CV SAL3CV SAL4CV SAL5CV SAL2HI SAL3HI SAL4HI SAL5HI SAL2LO SAL3LO SAL4LO SAL5LO SAL2MD SAL3MD SAL4MD SAL5MD SAL2SD SAL3SD SAL4SD SAL5SD SAL2DN SAL3DN SAL4DN SAL5DN SAL2DNW SALSDNW SALADNW SAL5DNW Page 78 of 142 SAL1DNAW SAL1UP SAL1UPW SAL1UPAW SAL1NET SAL1XD SAL1XDW SAL1XDAW SAL1XU SAL1XUW SAL1XUAW SAL1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number
53. 1 estimates up since the weekly values four weeks ago EBGHUPW Number of INT1 estimates up since last weekly values EBGI1YR e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced l B E S ON DATASTREAM User Guide Version 5 0 EBGI2CV EBGI4CV EBGI2DN EBGI3DN EBGI4DN EBGI2D4W EBGI3D4W EBGIADAW EBGI2DNW EBGI3DNW EBGIADNW EBGI2HI EBGISHI EBGI4HI EBGI2LO EBGI3LO EBGI4LO EBGI2MD EBGI3MD EBGI4MD EBGI2MN EBGI3MN EBGI4MN EBGI2NE EBGI4NE EBGI2SD EBGI3SD EBGI4SD EBGI2UP EBGI3UP EBGI4UP EBGI2U4W EBGI3U4W EBGI4U4W EBGI2UPW EBGISUPW EBGIAUPW EBGI2YR EBGI3YR EBGI4YR Page 90 of 142 Earnings Before Interest and Taxes EBTI1CV e Coefficient of variation of all the INT1 estimates e Ameasure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11MN 100 EBTI1DN Number of INT1 estimates down since last monthly values EBTHD4W Number of INT1 estimates down since the weekly values four weeks ago EBTHDNW Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company EBTHLO Lowest value of all INT1 estimates for a particular company EBTHMD Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a com
54. 12 month forward Cash Earnings Per Share Estimates and Actuals on a Calendar year basis Where is replaced by an YY date Actuals Actual value for cash earnings per share for year ending Forecast Cash Earnings mean for estimate with year ending Time Series Cash Earnings mean for estimate with year ending Static Cash Earnings median for estimate with year ending Static Cash Earnings standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 CSH2MN CSH3MN CSHAMN CSH5MN CSH2D CSH3D CSH4D CSH5D CSH2CV CSHS3CV CSH4CV CSH5CV CSH2HI CSH3HI CSH4HI CSH5HI CSH2LO CSH3LO CSH4LO CSH5LO CSH2MD CSH3MD CSH4MD CSH5MD CSH2SD CSHSSD CSH4SD CSH5SD CSH2DN CSH3DN CSH4DN CSH5DN CSH2DNW CSH3DNW CSHADNW CSH5DNW Page 36 of 142 CSH1DNAW CSH1UP CSH1UPW CSH1UPAW CSH1NET CSH1XD CSH1XDW CSH1XD4W CSH1XU CSH1XUW CSH1XU4W CSH1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from th
55. 1DN4W BPS1DNW BPS1FD12 BPS1FD12 BPS1FMN BPS1FNE BPS1FSD BPS1HI BPS1LO BPS1MD BPS1MN BPS1NE BPS1NET BPS1SD BPS1UP BPS1UP4W BPS1UPW BPS1XD BPS1XD4W BPS1XDW BPS1XU BPS1XU4W BPS1XUW BPSE MD BPSE MN BPSE SD BPSI1CV BPSI1D4W BPSHDN BPSHDNW BPSI1HI BPSI1LO BPSHMD BPSI1MN BPSHNE BPSHSD BPSI1UAW BPSHUP 33 33 32 111 114 114 114 32 32 32 32 33 33 32 33 33 33 33 33 33 33 33 33 32 32 32 85 85 85 85 85 85 85 85 85 85 85 85 Page 131 of 142 CAP MN CAPOYR CAP1CV CAP1D CAP1DN CAP1DN4W CAP1DNW CAP1FD12 CAP1FD12 CAP1FMN CAP1FNE CAP1FSD CAP1HI CAP1LO CAP1MD CAP1MN CAP1NE CAP1NET CAP1SD CAP1UP CAP1UP4W CAP1UPW CAP1XD CAP1XD4W CAP1XDW CAP1XU CAP1XU4W CAP1XUW CAPE MD CAPE MN CAPE SD CAPI1CV CAPI1D4W CAPI1DN CAPI1DNW CAPI1HI CAPI1LO CAPI1MD CAPI1MN CAPI1NE CAPI1SD CAPI1U4W CAPI1UP ON DATASTREAM User Guide Version 5 0 34 34 34 34 34 35 34 34 111 114 114 114 34 34 34 34 35 35 34 35 35 35 35 35 35 35 35 35 34 34 34 86 86 86 86 86 86 86 86 86 86 86 86 CAPI1UPW CAPI1YR CPS MN CPSOYR CPS1CV CPS1D CPS1DN CPS1DN4W CPS1DNW CPS1FD12 CPS1FD12 CPS1FMN CPS1FNE CPS1FSD CPS1HI CPS1LO CPS1MD CPS1MN CPS1NE CPS1NET CPS1SD CPS1UP CPS1UP4W CPS1UPW CPS1XD CPS1XD4W CPS1XDW CPS1XU CPS1XU4W CPS1XUW CPSE MD CPSE MN CPSE SD CPSI1CV CPSI1D4W CPSI1DN CPSI1DNW CPSI1HI CPSI1LO CPSI1M
56. 2 52 53 53 52 111 115 115 115 52 52 52 52 53 53 52 53 Page 135 of 142 FCF1UPAW FCF1UPW FCF1XD FCF1XD4W FCF1XDW FCF1XU FCF1XU4W FCF1XUW FCFE MD FCFE MN FCFE SD FCFI1CV FCFI1D4W FCFHDN FCFI1DNW FCFI1HI FCFI1LO FCFHMD FCFHMN FCFHNE FCFHSD FCFI1UAW FCFHUP FCFHUPW FFO MN FFOOYR FFO1CV FFO1D FFO1DN FFO1DN4W FFO1DNW FFO1FD12 FFO1FD12 FFO1FMN FFO1FNE FFO1FSD FFO1HI FFO1LO FFO1MD FFO1MN FFO1NE FFO1NET FFO1SD ON DATASTREAM User Guide Version 5 0 53 53 53 53 53 53 53 53 52 52 52 95 95 95 95 95 95 95 95 95 95 95 95 95 95 54 54 54 54 54 55 55 54 111 115 115 115 54 54 54 54 55 55 54 FFO1UP FFO1UPAW FFO1UPW FFO1XD FFO1XD4W FFO1XDW FFO1XU FFO1XU4W FFO1XUW FFOE MD FFOE MN FFOE SD FFOI1CV FFOI1D4AW FFOI1DN FFOI1DNW FFOIHI FFOI1LO FFOI1MD FFOI1MN FFOI1NE FFOI1SD FFOI1UAW FFOI1UP FFOI1UPW FFOI1YR G GPS MN GPSOYR GPS1CV GPS1D GPS1DN GPS1DN4W GPS1DNW GPS1FD12 GPS1FD12 GPS1FMN GPS1FNE GPS1FSD GPS1HI GPS1LO GPS1MD GPS1MN GPS1NE 55 55 55 55 55 55 55 55 55 54 54 54 96 96 96 96 96 96 96 96 96 96 96 96 96 96 56 56 56 56 56 56 56 111 116 116 116 56 56 56 56 57 GPS1NET GPS1SD GPS1UP GPS1UP4W GPS1UPW GPS1XD GPS1XD4W GPS1XDW GPS1XU GPS1XUAW GPS1XUW GPSE MD GPSE MN GPSE SD GPSI1CV GPSI1D4W GPSHDN GPSHDNW GPSHHI GPSHLO GPSHMD GPSHMN GPSH
57. 2546 17 00 0 1 17 00 0 0 BLC BRITISH LAND BPN 31 03 2009 0 2 18 5328 11 00 1 2 6 00 0 0 BJD BRITISH SKY BCAST GROUP BPN 30 06 2009 4 2 25 2956 4 00 1 4 12 00 0 2 BTU BT GROUP BPN 31 03 2008 0 2 28 2133 7 00 1 4 11 00 0 1 BNZ BUNZL BPN 31 12 2008 0 0 14 4934 0 00 1 4 21 00 cww CABLE amp WIRELESS BPN 31 03 2008 2 0 17 1038 12 00 2 0 12 00 2 0 cBR CADBURY BPN 31 12 2008 2 2 27 2941 000 5 13 30 00 0 0 CAIRN ENERGY BPN 31 2 2008 1 0 18 1674 5 00 1 0 5 00 0 0 CAPITA GROUP BPN 31 12 2008 0 0 16 3305 0 00 1 0 5 00 0 0 CARNIVAL USD 30 11 2009 2 4 13 255 15 00 2 4 15 00 1 C8N CENTRICA BPN 3142 2008 4 1 14 2292 0 0096 1 1 0 0096 0 0 FGG COBHAM BPN 31 2 2008 0 1 19 1489 5 00 3 2 5 00 0 0 cas amp COMPASS GROUP BPN 30 09 2009 3 0 22 2480 14 00 5 1 18 00 1 0 Gul DIAGEO BPN 30 06 2009 1 0 26 66 52 4 0096 1 1 0 00 1 0 LYH DRAX GROUP BPN 31 12 2008 3 1 15 85 20 13 00 4 2 13 00 0 1 9xF EURASIAN NATRES CORP USD 3142 2008 0 0 9 218 0 0096 2 0 22 00 0 0 OXN EXPERIAN BPN 31 03 2009 1 12 3891 8 00 2 1 8 00 0 0 I B E S ON DATASTREAM User Guide Page 15 of 142 Version 5 0 Update frequency l B E S monthly values are updated at the latest by close of business EST on the Tuesday following the third Friday of the month The monthly update overwrites all previous monthly values and adds the latest month s values The monthly update is a snapshot take
58. 2PERVERSSPER EPS4PER EPS5PER I B E S ON DATASTREAM User Guide Version 5 0 Page 22 of 142 Description Mnemonics for other periods EPSEZZMN Mean for estimate with year ending Static EPSE MD Median for estimate with year ending Static EPSE SD Standard deviation with estimate for year ending Static Total Revision data types EPS1DN Number of FY1 estimates down since last monthly values EPS1DNW Number of FY1 estimates down since last week values EPS1DNAW Number of FY1 estimates down since the weekly values four weeks ago EPS1UP Number of FY1 estimates up since last monthly values EPS1UPW Number of FY1 estimates up since last week values EPS1UPAW Number of FY1 estimates up since the weekly values four weeks ago EPS1NET Total of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean EPS1XD Number of FY1 estimates in the Mean down since last monthly values EPS1XDW Number of FY1 estimates in the Mean down since last weekly values EPS1XD4W Number of FY1 estimates in the Mean down since the weekly values four weeks ago EPS1XU Number of FY1 estimates in the Mean up since last monthly values EPS1XUW Number of FY1 estimates in the Mean up since last weekly values EPS1XUAW Number of FY1 estimates in the Mean up since the weekly values four weeks ago EPS1NE Total Number of estimates in the mean associated with FY1 fo
59. 4Week rolling Revision Est Up Est down Ticker Year End since last since last Contributions EPS Revision Ratio since last since last Ratio since last since last monthly monthly rolling rolling weekly weekly update update 4weeks 4weeks values values 1 ADMIRAL GROUP 312 2008 0 I 1ZL ALLIANCE TRUST BPN ANIA ANIA ANIA ANIA ANIA NIA ANIA ANIA ANIA ANIA AMC AMEC BPN 3142 2008 0 0 14 40 90 0 0096 0 1 7 00 0 0 AUZ AMLIN BPN 31 2 2008 0 0 12 19 90 000 1 3 17 00 0 0 ANGLO AMERICAN USD 31 12 2008 1 5 24 553 417 0096 1 9 33 00 0 0 AYX ANTOFAGASTA USD 21 12 2008 0 5 25 147 20 00 0 5 24 00 0 1 ABF ASSOCIATED BRIT FOODS BPN 30 09 2009 0 3 16 5486 19 00 1 8 44 00 2 Zzic ASTRAZENECA USD 3142 2008 1 0 31 507 3 00 2 2 0 00 1 0 ZQA AUTONOMY CORP USD 31 2 2008 2 23 0 54 9 00 3 0 13 0096 3 0 cuA AVIVA BPN 31 2 2008 0 1 21 8159 5 00 2 3 5 00 0 1 5 5 5 31 12 2008 1 0 18 3724 5 00 5 0 25 00 0 0 BAR BARCLAYS BPN 31 12 2008 3 3 30 4228 0 00 3 5 10 00 1 3 BIA BG GROUP BPN 3142 2008 1 0 26 90 56 4 00 1 6 19 00 1 0 BL8 BHP BILLITON USD 30 06 2008 0 4 26 279 15 00 2 8 27 0096 1 0 USD 31 12 2008 0 2 29 145 7 0096 0 4 14 00 0 1 BHI BRITISH AIRWAYS BPN 31 03 2008 0 0 21 504 0 00 2 0 10 00 0 0 BRITISH AMERICAN TOBACCO BPN 31 12 2008 2 1 20 12623 5 00 4 1 15 00 1 1 NED BRITISH ENERGY GROUP BPN 31 03 2008 0 1 6
60. 5 115 48 48 48 48 49 49 48 115 49 49 49 49 49 49 49 49 49 48 48 48 93 EBSI1D4W EBSHDN EBSHDNW EBSI1HI EBSI1LO EBSI1MD EBSI1MN EBSHNE EBSHSD EBSHUP EBSHUPAW EBSI1UPW EBSI1YR EBT MN EBTOYR EBT1CV EBT1D EBT1DN EBT1DN4W EBT1DNW EBT1FD12 EBT1FD12 EBT1FMN EBT1FNE EBT1LO EBT1MD EBT1MN EBT1SD EBT1UP EBT1UPAW EBT1UPW EBT1XD EBT1XD4W EBT1XDW EBT1XU EBT1XU4W EBT1XUW EBTE MD EBTE MN EBTE SD EBTI1CV 93 93 93 93 93 93 93 93 93 93 93 93 93 44 44 44 44 44 44 44 44 111 115 115 44 44 44 44 45 45 44 45 45 45 45 45 45 45 45 45 44 44 44 91 EBTI1DAW EBTHFSD EBTI1HI EBTI1LO EBTHSD EBTI1UP EBTI1TUPAW EBTITUPW EBTI1YR EPS CV EPS FYI EPS HI EPS LO EPS MD EPS MN EPS NE EPS SD EPS YR EPSOYR EPS1 EPS1CV EPS1D EPS1DN EPS1DN4W EPS1DNW EPS1FD12 EPS1FD12 EPS1FMN EPS1FNE EPS1FSD EPS1HI EPS1LO EPS1MD EPS1MN EPS1MN EPS1MN E EPS1MN X EPS1NE EPS1NE E 91 91 91 115 91 91 91 91 91 91 91 91 91 91 25 25 25 25 25 25 25 25 25 26 22 22 22 23 23 23 22 111 113 113 113 22 22 22 20 22 20 20 23 21 Page 134 of 142 EPS1NE X EPS1NET EPS1PER EPS1SD EPS1UP EPS1UPAW EPS1UPW EPS1XD EPS1XD4W EPS1XDW EPS1XU EPS1XU4W EPS1XUW EPS1YR EPSE MD EPSE MD EPSE MN EPSE MN EPSE SD EPSE SD EPS
61. 5 also provides a special report for Canadian companies based on the sector breakdown of the Toronto Stock Exchange 300 which has 14 Sectors The statistical measure of dispersion of estimates for the fiscal period indicated The standard deviation is the average variance from the mean expressed in local currency The Standard Deviation is calculated as follows n l where x individual analysts estimate n number of estimates See Unanticipated EPS The Tangible Book Value per Share is the company s Shareholders Equity excluding Minority Interests adjusted for certain items and divided by the Shares in Issue at Year End While the Book Value per Share is provided on a reported or GAAP basis Tangible Book Value per Share estimates would include adjusted BVPS estimates The adjustments include revaluations of assets exclusion of Accumulated other comprehensive income AOCI Embedded Value inclusions and others Page 129 of 142 Timely Composite Differential Trend Line EPS Forecast Unanticipated EPS SURPD SURPP SUE Upward Revision Rate Yield 1 5 ON DATASTREAM User Guide Version 5 0 A measure of the amount of new information incorporated in more recent Current EPS estimate updates compared to older ones The Timely composite differential is the ratio of the Company s flash mean EPS estimate for the specified fiscal time period to the Average EPS Estimate It is expressed as a percentage A mecha
62. 54 56 58 64 60 62 66 68 70 72 74 76 78 80 110 110 110 82 82 82 27 82 82 83 83 83 74 74 ROA1CV ROA1D ROA1DN ROA1DN4W ROA1DNW ROA1FD12 ROA1FD12 ROA1FMN ROA1FNE ROA1FSD ROA1HI ROA1LO ROA1MD ROA1MN ROA1NE ROA1NET ROA1SD ROA1UP ROA1UP4W ROA1UPW ROA1XD ROA1XD4W ROA1XDW ROA1XU ROA1XUAW ROA1XUW ROAE MD ROAE MN ROAE SD ROAI1CV ROAI1 D4W ROAI1 DN ROAI1 DNW ROAI1HI ROAI1LO ROAI1MD ROAI1 MN ROAI1NE ROAI1SD ROAI1 U4W ROAI1UP ROAI1 ROAI1YR ROE MN 74 74 74 75 74 74 111 117 117 117 74 74 74 74 75 75 74 75 75 75 75 75 75 75 75 75 74 74 74 106 106 106 106 106 106 106 106 106 106 106 106 106 106 76 ROEOYR ROE1CV ROE1D ROE1DN ROE1DN4W ROE1DNW ROE1FD12 ROE1FD12 ROE1FMN ROE1FNE ROE1FSD ROE1HI ROE1LO ROE1MD ROE1MN ROE1NE ROE1NET ROE1SD ROE1UP ROE1UP4W ROE1UPW ROE1XD ROE1XD4W ROE1XDW ROE1XU ROE1XUAW ROE1XUW ROEE MD ROEE MN ROEE SD ROEI1CV ROEI1 D4W ROEI1DN ROEI1 DNW ROEI1HI ROEI1LO ROEI1MD ROEI MN ROEI1NE ROEI1SD U4W ROEI1UP ROEI1 UPW ROEI1YR 76 76 76 77 76 76 112 117 117 117 76 76 76 76 77 77 76 77 77 77 77 77 77 77 77 77 76 76 76 107 107 107 107 107 107 107 107 107 107 107 107 107 107 Page 140 of 142 S SAL MN SALOYR SAL1CV SAL1D SAL1DN SAL1DN4W SAL1DNW SAL1FD12 SAL1FD12 SAL1FMN SAL1FNE SAL1FSD SAL1HI SAL1LO SAL1MD SAL1MN SAL1NE SAL1NET
63. Actual E arnings 45 31 03 06 31 40 EPS Growth Data Last 4 09 0306 0305 06 04 Momentum Data ao IEP S F Y1 Forecast P E 17 56 Stock Valuation Data Analyst Sponsorship Data Analyst Agreement Data Median Data Thomson ONE browser pages Market Data N Multiple Series Flexible Chart UTR aaa ARANDI POEM ENTE ie Single Series Chart MEDIAN Chg 1 mth Single Series Report PRICE IBESKP H SCALE Shares millions gle Series Data 35 Growth Rates 95 FYO FY1 1 2 11 36 Historic 5yr IB E S Mkt Cap millions Project Equity Screening The median tear sheet is similar to the overview tear sheet except that it is based on median earnings forecasts rather than the mean 1 B E S ON DATASTREAM User Guide Page 13 of 142 Version 5 0 Overview of company performance In addition to the dedicated 5 tear sheet reports Datastream Advance s Overview of Company Performance make use of data and include earnings forecasts for fiscal years 1 and 2 as well as price earnings derived from I B E S earnings forecasts and Datastream prices Datastream Advance E zi 3i Fi Edit 1 B r Data Category Ente Search M Expert From 3M To Settings i Series N C 20 C A5Y C 10 C 5Y C pera EJ Datatype DEFAU E 888880 re Data
64. Assets Return on Equity is another profitability ratio which gauges return on investment by measuring how effectual stockholder money is being employed by the company ROE is calculated by dividing a company s net income by average total equity Unlike ROA ROE does consider the degree to which a company uses leveraging as interest expense paid to creditors is generally deducted from earnings to arrive at Net Income l B E S provides both expected and actual ROE data where available 1 ROE Return On Total Equity Ner income Average Total Equity Page 128 of 142 Sales SAL Sector IBSCT Standard Deviation Standardized Unanticipated Earnings SUE Score Tangible Book Value Per Share TBV l B E S ON DATASTREAM User Guide Version 5 0 The Sales measure is a corporation s net revenue generally derived from core business activities For non financial companies the calculation of net revenue or net turnover in most markets generally involves subtracting transportation and related operational costs from gross revenue sales Revenue recognition practices vary significantly from market to market though generally the recording of revenue is based upon sales invoices issued or anticipated for forecast purposes during the accounting period For banks revenue is generally defined as net interest income plus net non interest income Net interest income is defined as interest income minus interest expenses Net inter
65. BTII2FNE EBT2FSD EBTII1FSD EBTII2FSD EBD2FMN EBDI1FMN EBDI2FMN EBD2FNE EBDI1FNE EBDI2FNE EBD2FSD EBDITFSD EBDI2FSD EBS2FMN EBSI1FMN EBS2FNE EBSI2FNE EBS2SD EBSI1FSD EBSI2FSD EVT2FMN EVTI1FMN EVTI2FMN EVT2FNE EVTHFNE EVTI2FNE EVT2FSD EVTHFSD EVTI2FSD FCF2FMN FCFI1FMN FCFI2FMN FCF2FNE FCFI1FNE FCFI2FNE FCF2FSD FCFI1FSD FCFI2FSD FFO2FMN FFOI1FMN FFOI2FMN FFO2FNE FFOI1FNE FFOI2FNE FFO2FSD FFOI1FSD FFOI2FSD Page 115 of 142 GPS1FMN GPS1FNE GPS1FSD GRM1FMN GRM1FNE GRM1FSD NAV1FMN NAV1FNE NAV1FSD NDT1FMN NDT1FNE NDT1FSD INC1FMN INC1FNE INC1FSD NER1FMN NER1FNE NER1FSD GAAP Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Gross Margin Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Net Asset Value Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Net Debt Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last
66. CF1XUW FCF1XU4W FCF1NE Number of FY1 estimates down since last weekly values Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 FCF2DNW FCF3DNW FCFADNW FCF5DNW FCF2DN4W FCF3DNAW FCFADNAW FCF5DNAW FCF2UP FCF3UP FCF4UP FCF54UP FCF2UPW FCF3UPW FCFAUPW FCF5UPW FCF2UPAW FCF3UP4W FCFAUPAW FCF5UP4W FCF2NET FCF3NET FCFANET FCF5NET FCF2XD FCF3XD FCF4XD FCF5XD FCF2XDW FCF3XDW FCFAXDW FCF5XDW FCF2XD4W FCF3XDAW FCF4XD4W FCF5XDAW FCF2XU FCF3XU FCF4XU FCF5XU FCF2XUW FCFSXUW FCFAXUW FCF5XUW FCF2XUAW FCF3XUAW
67. D CPSI1MN CPSI1NE CPSI1SD CPSI1U4W 86 86 38 38 38 38 38 38 38 38 111 114 114 114 38 38 38 38 39 39 38 39 39 39 39 39 39 39 39 39 38 38 38 88 88 88 88 88 88 88 88 88 88 88 CPSI1UP CPSI1UPW CPSI1YR CSH MN CSHOYR CSH1CV CSH1D CSH1DN CSH1DN4W CSH1DNW CSH1FD12 CSH1FD12 CSH1FMN CSH1FNE CSH1FSD CSH1HI CSH1LO CSH1MD CSH1MN CSH1NE CSH1NET CSH1SD CSH1UP CSH1UP4W CSH1UPW CSH1XD CSH1XD4W CSH1XDW CSH1XU CSH1XUAW CSH1XUW CSHE MD CSHE MN CSHE SD CSHI1CV CSHI1D4W CSHI1DN CSHI1DNW CSHI1HI CSHI1LO CSHI1MD CSHI1MN CSHI1NE CSHI1SD 88 88 88 36 36 36 36 36 37 36 36 111 114 114 114 36 36 36 36 37 37 36 37 37 37 37 37 37 37 37 37 36 36 36 87 87 87 87 87 87 87 87 87 87 Page 132 of 142 CSHI1U4W CSHI1UP CSHI1UPW CSHI1YR D DPS MN DPSOYR DPS1CV DPS1D DPS1DN DPS1DN4W DPS1DNW DPS1FD12 DPS1FD12 DPS1FMN DPS1FNE DPS1FSD DPS1HI DPS1LO DPS1MD DPS1MN DPS1NE DPS1NET DPS1SD DPS1UP DPS1UPAW DPS1UPW DPS1XD DPS1XD4W DPS1XDW DPS1XU DPS1XU4W DPS1XUW DPSE MD DPSE MN DPSE SD DPSI1CV DPSI1D4W DPSI1DN DPSI1DNW DPSI1HI DPSI1LO DPSI1MD DPSI1MN ON DATASTREAM User Guide Version 5 0 87 87 87 87 40 40 40 40 40 41 41 40 111 114 114 114 40 40 40 40 41 41 40 41 41 41 41 41 41 41 41 41 40 40 40 89 89 89 89 89 89 89 89 DPSI1NE DPSI1SD DPSI1U4W DPSI1UP DPSI1UPW DPSI1Y
68. D4W BPS2XU BPS3XU BPS4XU BPS5XU BPS2XUW BPS3XUW BPS4XUW BPSSXUW BPS2XU4W BPS3XU4W BPS4XU4W BPS5XU4W BPS2NE BPS3NE BPS4NE BPS5NE Page 33 of 142 Capital Expenditure CAP CAP1MN CAP1D FOCAP CAPOYR CAP1CV ROCAP CAP1HI CAP1LO CAP1MD CAP1SD CAP1FD12 A CAP CAP MN CAPE MN CAPE MD CAPE SD CAP1DN CAP1DNW Mean Capital Expenditure for FY1 Fiscal Year End for CAP1MN Last Reported Capital Expenditure Fiscal Year End for FOCAP e Coefficient of variation of all the FY1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV CAP1SD Absolute value of CAP1MN 100 Restated reported Capital Expenditure Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Capital Expenditure Estimates and Aciuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Capital Expenditure for year ending Forecast Capital Expenditure mean for estimate with year ending Time Series Capital Expenditure mean for estimate with year ending Static Capital Expenditure median for estimate with year ending HP Static Capital Expenditure standard deviation with
69. DATASTREAM User Guide Version 5 0 INCI2CV INCISCV INCIACV INCI2DN INCISDN INCIADN INCI2DAW INCI3D4W INCI4D4W INCI2DNW INCISDNW INCIADNW INCI2HI INCISHI INCIAHI INCI2LO INCI3LO INCI4LO INCI2MD INCI3MD INCI4MD INCI2MN INCI3MN INCI4MN INCI2NE INCISNE INCI4NE INCI2SD INCISSD INCIASD INCI2UP INCISUP INCIAUP INCI2U4W INCISUAW INCI4U4W INCI2ZUPW INCISUPW INCI4UPW INCI2YR INCISYR INCIAYR Page 101 of 142 Reported Net Income NERHCV NERI1DN NERHDAW NERHDNW NERI1HI NERHLO NERHMD NERHMN NERHNE NERHSD NERHUP NERHUAW NERHUPW NERI1YR e Coefficient of variation of all the INT1 estimates A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV NERI1SD Absolute value of NERI1MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 esti
70. DAW ROEI2DNW ROEISDNW ROEI4DNW ROEI2HI ROEI3HI ROEI4HI ROEI2LO ROEI3LO ROEI4LO ROEI2MD ROEI3MD ROEI4MD ROEI2MN ROEI3MN ROEIAMN ROEI2NE ROEI3NE ROEIANE ROEI2SD ROEISSD ROEI4SD ROEI2UP ROEI3UP ROEI4UP ROEI2U4W ROEI3U4W ROEI4U4W ROEI2UPW ROEI3UPW ROEIAUPW ROEI2YR ROEI3YR ROEIAYR Page 107 of 142 Sales SALHCV SALHDN SALHDAW SALHDNW SALHHI SALHLO SALHMD SALHMN SALHNE SALHSD SALHUP SALHUAW SALHUPW SALH YR e Coefficient of variation of all the INT1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11 MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Rela
71. DN4W ROAS5DNAW ROA2UP ROA3UP ROA4UP ROA5UP ROA2UPW ROA3UPW ROA4UPW ROASUPW ROA2UP4W ROA3UP4W ROA4UP4W ROASUP4W ROA2NET ROASNET ROA4NET ROASNET ROA2XD ROAS3XD ROA4XD ROA5XD ROA2XDW ROA3XDW ROA4XDW ROASXDW ROA2XD4W ROA3XD4W ROA4XD4W ROA5XDAW ROA2XU ROA3XU ROA4XU ROA5XU ROA2XUW ROA3XUW ROA4XUW ROASXUW ROA2XU4W ROA3XU4W ROA4XU4W ROA5XUAW ROA2NE ROA4NE ROASNE Page 75 of 142 Return On Equity ROE ROE1MN ROE1D FOROE ROEOYR ROE1CV ROROE ROE1HI ROE1LO ROE1MD ROE1SD ROE1FD12 A ROE Forecast ROE MN ROEE MN ROEE MD ROEE SD ROE1DN ROE1DNW Mean Return On Equity for FY1 Fiscal Year End for ROE1MN Last Reported Return On Equity Fiscal Year End for FOROE e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV ROE1SD Absolute value of ROE1MN 100 Restated reported Return On Equity Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Return On Equity Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for return on equity for year ending
72. ER1MN NER1NE NER1NET NER1SD 63 63 63 63 63 63 63 63 62 62 62 100 100 100 100 100 100 100 100 100 100 100 100 100 100 66 66 66 66 66 67 66 66 111 116 116 116 66 66 66 66 67 67 66 NER1UP NER1UPAW NER1UPW NER1XD NER1XD4W NER1XDW NER1XU NER1XUAW NER1XUW NERE MD NERE MN NERE SD NERI1CV NERI1D4W NERI1DN NERI1DNW NERI1LO NERI1MD NERI1MN NERITNE NERI1SD NERI1U4W NERITUP NERI1UPW NERI1YR OBASE1 OBASEN1 OPR MN OPROYR OPR1CV OPR1D OPR1DN OPR1DNAW OPR1DNW OPR1FD12 OPR1FD12 OPR1FMN OPR1FNE OPR1FSD OPRI1HI OPR1LO OPR1MD 67 67 67 67 67 67 67 67 66 66 66 102 102 102 102 102 102 102 102 102 102 102 102 102 102 21 21 68 68 68 68 68 69 69 68 111 117 117 117 68 68 68 Page 138 of 142 OPR1MN OPR1NE OPR1NET OPR1SD OPR1UP OPR1UPAW OPR1UPW OPR1XD OPR1XD4W OPR1XDW OPR1XU OPR1XU4W OPR1XUW OPRE MD OPRE MN OPRE SD OPRI1CV OPRI1D4W OPRHDN OPRHDNW OPRHLO OPRI1MD OPRHMN OPRHNE OPRHSD OPRI1U4W OPRI1UP OPRHUPW OPRIH YR P PE1 PEFD12 PNTCON PRE MN PREOYR PRE1CV PRE1D PRE1DN PRE1DN4W PRE1DNW PRE1FD12 PRE1FD12 PRE1FMN ON DATASTREAM User Guide Version 5 0 68 69 69 68 69 69 69 69 69 69 69 69 69 68 68 68 103 103 103 103 103 103 103 103 103 103 103 103 103 103 22 111 18 70 70 70 70 70 71 70 70 111 117 PRE1FNE PRE1FSD PRE1HI
73. FFO2DNW FFOSDNW FFO4DNW FFOSDNW FFO2DNAW FFOSDNAW FFO4DNAW FFOS5DN4W FFO2UP FFO3UP FFO4UP FFOSUP FFO2UPW FFO3UPW FFO4UPW FFOSUPW FFO2UP4W FFO3UP4W FFO4UP4W FFOSUP4W FFO2NET FFOSNET FFO4NET FFOSNET FFO2XD FFO3XD FFO4XD FFO5XD FFO2XDW FFOSXDW FFO4XDW FFO5XDW FFO2XD4W FFO3XD4W FFO4XD4W FFO5XDAW FFO2XU FFO3XU FFO4XU FFO4XU FFO2XUW FFOSXUW FFO4XUW FFO5XUW FFO2XU4W FFO3XU4W FFO5XU4W FFOSXUAW FFO2NE FFO3NE FFO4NE FFOSNE ON DATASTREAM User Guide Version 5 0 Page 55 of 142 GAAP GPS1MN GPS1D FOGPS GPSOYR GPS1CV ROGPS GPS1HI GPS1LO GPS1MD GPS1SD GPS1FD12 A GPS GPS MN GPSE MN GPSE MD GPSE SD GPS1DN GPS1DNW GPS1DNAW Fully Reported GPS GAAP value for FY1 Fiscal Year End for GPS1MN Last Reported GAAP Fiscal Year End for FOGPS Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV GPS1SD Absolute value of GPS1MN 100 Restated reported GAAP Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward GAAP Estimates and Actuals on a calendar year basis Where is replaced by an YY date A
74. IBCTRY The unique identifier used by 5 for a company e The ticker is prefixed with to ensure that it is unique NAME e Company name IBTKR e A standard Datastream data type which retrieves the name for a company if there is no corresponding Datastream name PNTCON Indicator showing whether EPS figures are on a parent P or consolidated C basis IBUNIT e Unit for non per share data This is a numeric value of either 1 for non per share data in millions or 1 000 for billions This allows comparison of non per share measures across markets Please see page 23 for list of markets where non per share data is expressed in billions l B E 5 ON DATASTREAM User Guide Page 18 of 142 Version 5 0 Chapter 4 Market Driven Changes IFRS related changes European Union EU regulations require most listed European companies to comply with International Financial Reporting Standards IFRS 1 5 for their consolidated financial statements beginning with accounting periods starting on or after 1 January 2005 For companies with December year ends IFRS first applies to periods ending 31 December 2005 The EU regulations also require one year of history for financial years commencing in 2004 restated under the new rules when reporting 2005 annual results As part of the move to IFRS standards EPS data previously stated on a post goodwill basis must be restated on a pre goodwill basis This brings EPS data types into lin
75. INCI1UAW INCI1UP INCI1UPW INCI1YR L LTDN LTDNAW LTDNW LTHI LTLO LTMD LTMN LTNE LTSD LTUP LTUPAW LTUPW N NAME NAV MN NAVOYR NAV1CV NAV1D NAV1DN NAV1DN4W NAV1DNW NAV1FD12 NAV1FD12 NAV1FMN NAV1FNE NAV1FSD NAV1HI NAV1LO NAV1MD NAV1MN NAV1NE NAV1NET NAV1SD NAV1UP NAV1UPAW 101 101 101 101 101 101 101 101 112 112 112 112 112 112 112 112 112 112 112 112 18 60 60 60 60 60 61 60 60 111 116 116 116 60 60 60 60 61 61 60 61 61 Page 137 of 142 NAV1UPW NAV1XD NAV1XD4W NAV1XDW NAV1XU NAV1XUAW NAV1XUW NAVE MD NAVE MN NAVE SD NAVI1CV NAVI1D4W NAVI1DN NAVI1DNW NAVI1LO NAVI1MD NAVI1MN NAVITNE NAVHSD NAVI1UAW NAVI1UP NAVI1UPW NAVI1YR NDT MN NDTOYR NDT1CV NDT1D NDT1DN NDT1DN4W NDT1DNW NDT1FD12 NDT1FD12 NDT1FMN NDT1FNE NDT1FSD NDT1HI NDT1LO NDT1MD NDT1MN NDT1NE NDT1NET NDT1SD NDT1UP ON DATASTREAM User Guide Version 5 0 61 61 61 61 61 61 61 60 60 60 99 99 99 99 99 99 99 99 99 99 99 99 99 99 62 62 62 62 62 63 62 62 111 116 116 116 NDT1UPAW NDT1UPW NDT1XD NDT1XD4W NDT1XDW NDT1XU NDT1XU4W NDT1XUW NDTE MD NDTE MN NDTE SD NDTI1CV NDTI1D4W NDTI1DN NDTI1DNW NDTI1HI NDTHLO NDTI1MD NDTI1MN NDTI1NE NDTHSD NDTI1UAW NDTI1UP NDTI1TUPW NDTI1YR NERZZMN NEROYR NER1CV NER1D NER1DN NER1DN4W NER1DNW NER1FD12 NER1FD12 NER1FMN NER1FNE NER1FSD NER1HI NER1LO NER1MD N
76. IOYR EPSI1CV EPSHDN EPSI1DN4W EPSHDNW EPSI1HI EPSITLO EPSHMD EPSI1MN EPSHMN E EPSHMN X EPSHNE EPSI1NE E EPSHNE X EPSHSD EPSHUP EPSHUPAW EPSITUPW EPSI1YR EVT MN EVTOYR EVT1CV EVT1D EVT1DN ON DATASTREAM User Guide Version 5 0 21 23 22 22 23 23 23 23 23 23 23 23 23 22 23 26 23 26 23 26 27 24 24 24 24 24 24 24 24 21 21 24 21 21 24 24 24 24 24 50 50 50 50 50 EVT1DN4W EVT1DNW EVT1FD12 EVT1FD12 EVT1FMN EVT1FNE EVT1FSD EVT1HI EVT1LO EVT1MD EVT1MN EVT1SD EVT1UP EVT1UPAW EVT1UPW EVT1XD EVT1XD4W EVT1XDW EVT1XU EVT1XUAW EVT1XUW EVTE MD EVTE MN EVTE SD EVTI1CV EVTI1DAW EVTH DN EVTI1TDNW EVTI1HI EVTHLO EVTHSD EVTITUAW EVTHUP EVTHUPW EVTI1YR F FOAFO FOBPS FOCAP 51 50 50 111 115 115 115 50 50 50 50 51 51 50 51 51 51 51 51 51 51 51 51 50 50 50 94 94 94 94 94 94 94 94 94 94 94 94 94 94 30 32 34 FOCPS FOCSH FODPS FOEBD FOEBG FOEBS FOEBT FOEPS FOEVT FOFCF FOFFO FOGPS FOGRM FOINC FONAV FONDT FONER FOOPR FOPRE FOPRR FOROA FOROE FOSAL FOTBV FCF MN FCFOYR FCF1CV FCF1D FCF1DN FCF1DN4W FCF1DNW FCF1FD12 FCF1FD12 FCF1FMN FCF1FNE FCF1FSD FCF1LO FCF1MD FCF1MN FCF1NE FCF1NET FCF1SD FCF1UP 38 36 40 46 42 48 44 26 50 52 54 56 58 64 60 62 66 68 70 72 74 76 78 80 52 52 52 5
77. ISMD NDTIAMD NDTI2MN NDTISMN NDTIAMN NDTI2NE NDTI3NE NDTIANE NDTI2SD NDTI3SD NDTIASD NDTI2UP NDTI3UP NDTI4UP NDTI2U4W NDTISUAW NDTIAUAW NDTI2UPW NDTISUPW NDTIAUPW NDTI2YR NDTI3YR NDTI4YR Page 100 of 142 Net Income INCH CV INCHDN INCHDAW INCHDNW INCHHI INCHLO INCHMD INCHMN INCHNE INCHSD INCHUP INCHUAW INCHUPW INCH YR e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced ON
78. Lowest value of the long term growth estimates LTMD e Median long term growth estimate e Acomposite estimate of the anticipated annual growth rate in EPS over a five year period LTMN Mean long term growth estimate e The mean of all long term growth estimates expressed as a percentage Note I B E S place more importance on the median for long term growth LTNE Total number of long term growth estimates LTSD Standard deviation of the long term growth estimates LTUP Number of long term growth estimates up in the last month LTUP4W Number of long term growth estimates up since the weekly values four weeks ago LTUPW Number of long term growth estimates up since last weekly values Surprise earnings data types Surprise earnings data types are only available for companies that have quarterly data coverage Only the current values of these data types are held no history is maintained SUE e Standardized Unanticipated earnings Score e Ratio of the absolute surprise to estimate dispersion e Measure of the distance between the two values in terms of standard deviation of the estimates SURDT e Interim surprise date e The date on which the latest interim earnings were announced SURMN e Interim surprise mean EPS e The last 5 estimate for the quarter that has just been reported B E S DATASTREAM User Guide Page 112 of 142 Version 5 0 SURPD e Surprise Difference e The absolute difference between the latest interim EPS
79. M Restated quarterly period reported for gross margin Last quarterly period reported for net income l B E S ON DATASTREAM User Guide Version 5 0 IP1CAP IP2CAP IPSCAP IPACAP RH CAP RI2CAP RISCAP RI4CAP IP1EBT IP2EBT IPSEBT IPAEBT RH RI2EBT RISEBT RI4EBT IP1EBD IP2EBD IPSEBD IPAEBD RH EBD RI2EBD RISEBD RI4EBD IP1EVT IP2EVT IPSEVT IPAEVT RH EVT RI2EVT RISEVT RI4EVT IP1GRM IP2GRM IPSGRM IPAGRM RH GRM RI2GRM RISGRM RIAGRM IP1INC IP2INC IP4INC Page 82 of 142 RIINC Restated quarterly period reported for net income RI1TINC RI2INC RISINC RI4INC Last quarterly period reported for operating profits IP1OPR IP2OPR IPSOPR IPAOPR RIOPR Restated quarterly period reported for operating profits RI1OPR RIZOPR RISOPR RIAOPR IOSAL Last quarterly period reported for sales IP1SAL IP2SAL IP3SAL IPASAL RISAL Restated quarterly period reported for sales RI1SAL RI2SAL RISSAL RI4SAL 1 B E S ON DATASTREAM User Guide Page 83 of 142 Version 5 0 Quarterly estimate data types Adjusted Funds From Operations AFOHCV e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV AFOI1SD Absolute value of AFOI1MN 100 AFOHDN Number of INT1 estimates down since last monthly values AFOHD4W Number of INT1 estimates down since the weekly value
80. N4W OPR3DN4W OPR4DN4W OPR5DN4W OPR2UP OPR3UP OPR4UP OPR5UP OPR2UPW OPR3UPW OPR4UPW OPR5UPW OPR2UP4W OPR3UP4W OPR4UP4W OPR5UP4W OPR2NET OPR3NET OPRANET OPRSNET OPR2XD OPR3XD OPR4XD OPR5XD OPR2XDW OPR3XDW OPR4XDW OPR5XDW OPR2XD4W OPR3XD4W OPR4XD4W OPR5XDAW OPR2XU OPR3XU OPR4XU OPR5XU OPR2XUW OPRS3XUW OPR4XUW OPR5XUW OPR2XU4W OPR3XU4W OPR4XU4W OPR5XUAW OPR2NE OPR3NE OPRANE OPR5NE ON DATASTREAM User Guide Version 5 0 Page 69 of 142 Pre tax Profits PRE PRE1MN PRE1D FOPRE PREOYR ROPRE PRE1CV PRE1HI PRE1LO PRE1MD PRE1SD PRE1FD12 A PRE PRE MN PREE MN PREE MD PREE SD PRE1DN PRE1DNW Mean Pre tax Profits for FY1 Fiscal Year End for PRE1MN Last Reported Pre tax Profits Fiscal Year End for FOPRE Restated reported Pre tax Profits e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV PRE1SD Absolute value of PRE1MN 100 Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Pre tax Profits Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual
81. NE GPSHSD GPSI1U4W GPSHUP GPSHUPW GPSH YR GRM MN GRMOYR GRM1CV GRM1D GRM1DN GRM1DN4W GRM1DNW GRM1FD12 GRM1FD12 GRM1FMN GRM1FNE GRM1FSD GRM1LO GRM1MD GRM1MN 57 56 57 57 57 57 57 57 57 57 57 56 56 56 97 97 97 97 97 97 97 97 97 97 97 97 97 97 58 58 58 58 58 59 58 58 111 116 116 116 58 58 58 58 Page 136 of 142 GRM1NE GRM1NET GRM1SD GRM1UP GRM1UP4W GRM1UPW GRM1 XD GRM1XD4W GRM1XDW GRM1 XU GRM1XUAW GRM1XUW GRME MD GRME MN GRME SD GRMI1CV GRMI1D4W GRMI1DN GRMI1DNW GRMI1HI GRMI1LO GRMI1MD GRMI1MN GRMI1NE GRMI1SD GRMI1U4W GRMI1UP GRMI1UPW GRMI1YR 1 IOEBD IOEPS IOEVT IOGRM IOINC IOSAL IBCTRY IBCUR IBDY IBGRP IBIND ON DATASTREAM User Guide Version 5 0 82 82 82 27 82 82 82 83 83 18 18 119 18 18 IBNOSH IBP IBPDTE IBSCT IBTKR IBUNIT IFRSDT INC MN INCOYR INC1CV INC1D INC1DN INC1DN4W INC1DNW INC1FD12 INC1FD12 INC1FMN INC1FNE INC1FSD INC1HI INC1LO INC1MD INC1MN INC1NE INC1NET INC1SD INC1UP INC1UP4W INC1UPW INC1XD INC1XD4W INC1XDW INC1XU INC1XU4W INC1XUW INCE MD INCE MN INCE SD INCI1CV INCI1DAW INCI1DN INCI1DNW INCI1HI INCHLO 119 119 119 18 18 18 20 64 64 64 64 64 64 64 111 116 116 116 64 64 64 64 65 65 64 65 65 65 65 65 65 65 65 65 64 64 64 101 101 101 101 101 101 INCI1MD INCI1MN INCI1NE INCI1SD
82. NET TBVSNET TBV2XD TBV3XD TBV4XD TBV5XD TBV2XDW TBV3XDW TBV4XDW TBV5XDW TBV2XD4W TBV3XD4W TBV4XD4W TBV5XD4W TBV2XU TBV3XU TBV4XU TBV5XU TBV2XUW TBV3XUW TBV4XUW TBV5XUW TBV2XU4W TBV3XU4W TBV4XU4W TBV5XU4W TBV2NE TBV3NE TBV4NE TBV5NE Page 81 of 142 Quarterly actuals for additional measures Both the latest and restated interim periods can be retrieved for all measures by creating the quarterly actual data types Last quarterly 10 Three character suffix can be found on page 28 Restated RI Three character suffix can be found on page 28 Most commonly used quarterly estimates are listed below CAP Capital Expenditure Earnings before interest and taxes EBD Earnings before interest taxes depreciation and amortization EVT Enterprise Value GRM Gross Margin INC Net Income OPR Operating Profit SAL Sales Actuals data types Last reported quarterly period data types Last quarterly period reported for capital expenditure RICAP Restated quarterly period reported for capital expenditure IOEBT Last quarterly period reported for EBIT RIEBT Restated quarterly period reported for EBIT IOEBD Last quarterly period reported for EBITDA RIEBD Restated quarterly period reported for EBITDA IOEVT Last quarterly period reported for enterprise value RIEVT Restated quarterly period reported for enterprise value IOGRM Last quarterly period reported for gross margin RIGR
83. Page 73 of 142 Return On Assets ROA ROA1MN ROA1D FOROA ROAOYR ROA1CV ROROA ROAtHI ROA1LO ROA1MD ROA1SD ROA1FD12 A ROA ROA MN ROAE MN ROAE MD ROAE SD ROA1DN ROA1DNW Mean Return On Assets for FY1 Fiscal Year End for ROA1MN Last Reported Return On Assets Fiscal Year End for FOROA e Coefficient of variation of all the FY1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV ROA1SD Absolute value of ROA1MN 100 Restated reported Return On Assets Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Return On Assets Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Return On Assets for year ending HP Forecast Return On Assets mean for estimate with year ending 4 Time Series Return On Assets mean for estimate with year ending 4 Static Return On Assets median for estimate with year ending HP Static Return On Assets standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON
84. R E EBASE EBASEN EBD MN EBDOYR EBD1CV EBD1D EBD1DN EBD1DN4W EBD1DNW EBD1FD12 EBD1FD12 EBD1FMN EBD1FNE EBD1FSD EBD1HI EBD1LO EBD1MD EBD1MN EBD1NE EBD1NET EBD1SD EBD1UP EBD1UPAW EBD1UPW EBD1XD EBD1XD4W EBD1XDW EBD1XU EBD1XUAW EBD1XUW EBDE MD EBDE MN EBDE SD EBDI1CV EBDI1D4W EBDI1DN EBDI1DNW 89 89 89 89 89 89 20 20 46 46 46 46 46 47 46 46 111 115 115 115 46 46 46 46 47 47 46 47 47 47 47 47 47 47 47 47 46 46 46 92 92 92 92 EBDI1HI EBDI1LO EBDIiMD EBDIiMN EBDHSD EBDI1UPAW EBDI1UPW EBDI1YR EBG MN EBGOYR EBG1CV EBG1D EBG1DN EBG1DN4W EBG1DNW EBG1FD12 EBG1FD12 EBG1FMN EBG1FNE EBG1FSD EBG1LO EBG1MD EBG1MN EBG1NE EBG1NET EBG1SD EBG1UP EBG1UP4W EBG1UPW EBG1XD EBG1XD4W EBG1XDW EBG1XU EBG1XU4W EBG1XUW EBGDT EBGE MD EBGE MN EBGE SD EBGI1CV EBGI1D4W 111 114 114 115 Page 133 of 142 EBGHDN EBGI1DNW EBGI1HI EBGI1LO EBGHMD EBGI1MN EBGHNE EBGHSD EBGI1UAW EBGHUP EBGI1UPW EBGI1YR EBS MN EBSOYR EBS1CV EBS1D EBS1DN EBS1DN4W EBS1DNW EBS1FD12 EBS1FD12 EBS1FMN EBS1FNE EBS1HI EBS1LO EBS1MD EBS1MN EBS1NE EBS1NET EBS1SD EBS1SD EBS1UP EBS1UP4W EBS1UPW EBS1XD EBS1XD4W EBS1XDW EBS1XU EBS1XU4W EBS1XUW EBSE MD EBSE MN EBSE SD EBSI1CV ON DATASTREAM User Guide Version 5 0 90 90 90 90 90 90 90 90 90 90 90 90 48 48 48 48 49 49 49 48 111 11
85. ROAI4SD ROAI2UP ROAI3UP ROAI4UP ROAI2UAW ROAISUAW ROAI4U4W ROAI2UPW ROAISUPW ROAIAUPW ROAI2YR ROAISYR ROAIAYR Page 106 of 142 Return on Equity ROEHCV e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation Calculated according to the equation CV I1 SD Absolute value of 11MN 100 ROEI1DN Number of INT1 estimates down since last monthly values ROEHMDA4W Number of INT1 estimates down since the weekly values four weeks ago ROEHDNW Number of INT1 estimates down since last weekly values ROEIHHI Highest value of all INT1 estimates for a particular company ROEHLO Lowest value of all INT1 estimates for a particular company ROEHMD Median value of all INT1 estimates for a company ROEHMN Mean value of all INT1 estimates for a company ROEI1NE Total number of estimates associated with INT1 forecast ROEHSD Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values ROEHUAW Number of INT1 estimates up since the weekly values four weeks ago ROEHUPW Number of INT1 estimates up since last weekly values ROEI YR e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced l B E S ON DATASTREAM User Guide Version 5 0 ROEI2CV ROEISCV ROEI4CV ROEI2DN ROEISDN ROEI4DN ROEI2D4W ROEISDAW ROEIA
86. SISLO CPSI4LO CPSI2MD CPSISMD CPSIAMD CPSI2MN CPSISMN CPSIAMN CPSI2NE CPSISNE CPSIANE CPSI2SD CPSISSD CPSIASD CPSI2UP CPSISUP CPSIAUP CPSI2U4W CPSISUAW CPSIAUAW CPSI2UPW CPSISUPW CPSIAUPW CPSI2YR CPSISYR CPSIAYR Page 88 of 142 Dividends Per Share DPSI1CV DPSI1DN DPSI1D4W DPSHDNW DPSI1HI DPSHLO DPSH MD DPSH MN DPSHNE DPSHSD DPSHUP DPSI1U4W DPSHUPW DPSI1YR e Coefficient of variation of all the INT1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11 MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company MeDPSlan value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results
87. SPENCER GROUP FY1 MEAN EARN EST 39 25 25 1107 Low 37 73 26 10 06 Derivatives MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY Constituent lists User created Ex MKS 23006 3713 3733 301006 3713 3713 3713 3713 3733 61106 3713 3733 3733 3713 3733 13 1106 3713 3713 3713 3875 201106 38 75 3815 3835 3835 2 25 1006 38 75 38 75 3835 3815 Single Series Overview 4 12 06 2875 38 75 3875 3875 Multiple Series Flexible Chart 111206 2815 3815 2815 38 84 ingieiseries ener 18 1206 3834 3834 3834 3884 3884 El Single Series Report 251206 3834 3834 2834 3884 3884 Performance range amp average 1 107 3884 3884 3884 3884 3884 Actual Values 104 from stat date 8 107 3884 3884 3884 3884 3884 Dividends and Earnings Report 1501807 3884 3884 3884 Dividend Payment Report 20107 3899 3899 3899 Source Datastream amp Balance Sheet Report Profit and Loss Report Cash Flow Statement Key Accounts Ratio Report Capital Issues amp Changes Product and Geographical Analysis Performance over 1 3 and 12 months Fixed End Date Performance over 1 3 and 12 months Today Worldscope Emerging Markets Report 1 Worldscope Emerging Markets Report 2 Perf range amp average using Expression Single Series Data Codes and Information Favourites via Equity Screening In the above example you can see that the values change on the B E S
88. Stability FY3FY2 Single Series Overview af Fy2ryvo ft 5 J j Annual E P S ii LTG Overview of Company Performance INT1ANTO Overview of any Series INT24NT1 Interim EP S INT3SANT2 El 5 INTAANTS Forecast Overview EPS Growth Data so Momentum Data Stock Valuation Data Analyst Sponsorship Data Analyst Agreement Data k Median Data i Thomson ONE browser pages o Multiple Series Flexible Chart weve FH Single Series Chart GROWTH F Y1 F Y2 Single Series Report EUM EDAM Single Series Data Surce TRemson e Project Equity Screening Request completed The EPS growth tear sheet shows expectations for earnings growth l B E 5 ON DATASTREAM User Guide Page 11 of 142 Version 5 0 Analyst Agreement M Datastream advance File Edit vie ool Be m B p EB 4 5 EC lt gt Enter MKS Search Expert Time period Not Applicable Settings fie T N 20Y 15v G 10Y G sv o gt i Equity indices Datatype DEFAU z Datatype 2Y Gem G Base Unit trusts Investment trusts Name MKS MKS Currency No Applicable 71 Bonds amp convertibles Bond indices amp CDS Economics Exchange rates Interest rates Commodities Derivatives 12 01 07 09 34 S on Datastream MARKS amp SPENCER GROUP VBE 25 Ticker MKS Country Cod
89. The glossary at the end of the guide gives additional information about terms used by 5 complete glossary of I B E S terms is available for 5 customers directly from l B E S Feedback IBES data types and their definitions are also available online through Thomson Reuters Datastream Navigator Data type search You can access Navigator through Datastream Advance Online documentation including the latest news on l B E S products can be found on the Datastream Support Extranet http extranet datastream com If you have comments and suggestions on this guide please send them via the Helpdesk contacts listed on the Datastream Support Extranet http extranet datastream com About Us Contacts contacts htm Contact Details For further information or assistance please contact your regular Thomson Reuters contact or use the information below 1 888 888 1082 United States Toll Free US 1 646 822 2777 United Kingdom 44 0870 1910581 Hong Kong 852 2524 0077 I B E S ON DATASTREAM User Guide Page 7 of 142 Version 5 0 Chapter 2 About on Datastream What is l B E S The Institutional Brokers Estimate System I B E S provides investment professionals with a global database of analysts forecast earnings per share cash flow per share dividends per share and net profits per share plus additional measures such as sales EBIT EBITDA and recommendations for publicly traded corporations worldwide In
90. V5LO NAV2MD NAV3MD NAV4MD NAV5MD NAV2SD NAV3SD NAV4SD NAV5SD NAV2DN NAV3DN NAV4DN NAV5DN NAV2DNW NAV3DNW NAV4DNW NAVS5DNW Page 60 of 142 NAV1DNAW NAV1UP NAV1UPW NAV1UPAW NAV1NET NAV1XD NAV1XDW NAV1XD4W NAV1XU NAV1XUW NAV1XU4W NAV1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast NAV2DN4W NAV3DN4W NAV4DN4W NAVSDN4W NAV2UP NAV3UP NAV4UP NAV5UP NAV2UPW NAV3UPW NAV4UPW NAVSUPW NAV2UP4W NAV3UP4W NAV4UP4W NAV5UP4W NAV2NET NAV3NET NAVANET 5 NAV2XD NAV3XD NAVAXD NAV5XD NAV2XDW NAV3XDW NAV4XDW NAV5XDW NAV2XDA
91. W EBSI2YR EBSISYR EBSIAYR Page 93 of 142 Enterprise Value EVTH CV EVTHDN EVTHDAW EVTHDNW EVTHHI EVTHLO EVTHMD EVTHMN EVTHNE EVTHSD EVTHUP EVTHUAW EVTHUPW EVTH YR e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11 MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 EVTI2CV EVTI4CV EVTI2DN EVTISDN EVTI4DN EVTI2DAW EVTI3D4W EVTIADAW EVTI2DNW EVTISDNW EVTI4DNW EVTI2HI EVTISHI EVTI4HI
92. W NER1UPAW 1 NER1XD NER1XDW NER1XD4W NER1XU NER1XUW NER1XU4W NER1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 NER2DNER4W NER3DNER4W NER4DNER4W NERSDNER4W NER2UP NER3UP NER4UP NER5UP NER2UPW NER3UPW NER4UPW NERSUPW NER2UP4W NER3UP4W NER4UP4W NER5UP4W NER2NET NER4NET 5 NER2XD NERSXD NER4XD NER5XD NER2XDW NER3XDW NER4XDW NER5XDW NER2XD4W NER3XD4W NER4XD4W NER5XD4W NER2XU NERS3XU NER4XU NER5XU NER2XUW NER3XUW NER4XUW NERSXUW NER2XU4W NER3
93. W DPSSDNW DPS2DN4W DPS3DN4W DPS4DN4W DPS5DNAW DPS2UP DPS3UP DPS4UP DPS5UP DPS2UPW DPS3UPW DPS4UPW DPSSUPW DPS2UP4W DPS3UP4W DPS4UP4W DPS5UP4W DPS2NET DPS3NET DPSANET DPSSNET DPSD2XD DPS3XD DPS4XD DPS5XD DPS2XDW DPS3XDW DPS4XDW DPS5XDW DPS2XD4W DPS3XD4W DPS4XD4W DPS5XD4W DPS2XU DPS3XU DPS4XU DPS5XU DPS2XUW DPS3XUW DPS4XUW DPSSXUW DPS2XU4W DPS3XU4W DPS4XU4W DPS5XUSW DPS2NE DPS3NE DPS4NE DPS5NE ON DATASTREAM User Guide Version 5 0 Page 41 of 142 Earnings Before Goodwill EBG EBG1MN EBG1D FOEBG EBGOYR EBG1CV ROEBG EBG1LO EBG1MD EBG1SD EBG1FD12 A EBG EBG MN EBGE MN EBGE MD EBGE SD EBG1DN EBG1DNW EBG1DN4W Mean EBG for FY1 Fiscal year End for EBG1MN Last Reported EBG Fiscal year End for FOEBG e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV EBG1SD Absolute value of EBG1MN 100 Restated reported EBG Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward EBG Estimates and Actuals on a calendar year basis Where is replaced by YY date Actuals Actual value fo
94. W NAV3XD4W NAV4XD4W NAV5XD4W NAV2XU NAV3XU NAV4XU NAV5XU NAV2XUW NAV3XUW NAV4XUW NAV5XUW NAV2XU4W NAV3XU4W NAV4XU4W NAV5XU4W NAV2NE NAV3NE NAVANE NAV5NE ON DATASTREAM User Guide Version 5 0 Page 61 of 142 Net Debt NDT NDT1MN NDT1D FONDT NDTOYR NDT1CV RONDT NDT1HI NDT1LO NDT1MD NDT1SD NDT1FD12 A NDT NDT MN NDTE MN NDTE MD NDTE SD NDT1DN NDT1DNW Mean Net Debt for FY1 Fiscal Year End for NDT1MN Last Reported Net Debt Fiscal Year End for FONDT e Coefficient of variation of all the FY1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV NDT1SD Absolute value of NDT1MN 100 Restated reported Net Debt Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Net Debt Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for net debt for year ending EE Forecast Net Debt mean for estimate with year ending Time Series Net Debt mean for estimate with year ending Static Net Debt median for estimate with year ending Static Net Debt standard deviation with estimate for year ending
95. XU4W NER4XU4W NER5XUAW NER2NE NERSNE NER4NE NER5NE Page 67 of 142 Operating Profit OPR OPR1MN OPR1D FOOPR OPROYR OPR1CV ROOPR OPR1HI OPR1LO OPR1MD OPR1SD OPR1FD12 A OPR OPR MN OPRE MN OPRE MD OPRE SD OPR1DN Mean Operating Profit for FY1 Fiscal Year End for OPR1MN Last Reported Operating Profit Fiscal Year End for FOOPR e Coefficient of variation of all the FY1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV OPR1SD Absolute value of OPR1MN 100 Restated reported Operating Profit Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Operating Profit Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Operating Profit for year ending HP Forecast Operating Profit mean for estimate with year ending Time Series Operating Profit mean for estimate with year ending Static Operating Profit median for estimate with year ending Static Operating Profit standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values
96. XU4W CPS5XU5W CPS2NE CPS3NE CPS4NE CPS5NE Page 39 of 142 Dividends per Share DPS DPS1MN DPS1D FODPS DPSOYR DPS1CV RODPS DPS1HI DPS1LO DPS1MD DPS1SD DPS1FD12 A DPS DPS MN DPSE MN DPSE MD DPSE SD DPS1DN Mean Dividends Per Share for FY1 Fiscal Year End for DPS1MN Last Reported Dividends Per Share Fiscal Year End for FODPS Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV DPS1SD Absolute value of DPS1MN 100 Restated reported Dividends Per Share Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Dividends Per Share Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for dividends per share for year ending Forecast Dividends Per Share mean for estimate with year ending Time Series Dividends Per Share mean for estimate with year ending Static Dividends Per Share median for estimate with year ending HP Static Dividends Per Share standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since las
97. Y1 estimates for a company GRM1SD Standard deviation of all the FY1 estimates that make up the consensus GRM1FD12 12 month forward Gross Margin Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals A GRM Actual value for Gross Margin for year ending Forecast GRMZZMN Gross Margin mean for estimate with year ending 4 Time Series GRMEZZMN Gross Margin mean for estimate with year ending Static GRMEZZMD Gross Margin median for estimate with year ending Static GRME SD Gross Margin standard deviation with estimate for year ending Static Total Revision data types GRM1DN Number of FY1 estimates down since last monthly values GRM1DNW Number of FY1 estimates down since last weekly values l B E S ON DATASTREAM User Guide Version 5 0 GRM2MN GRM3MN GRM4MN GRM5MN GRM2D GRM3D GRM4D GRM5D GRM2CV GRMSCV GRM4CV GRM5CV GRM2HI GRM4HI GRM5HI GRM2LO GRM3LO GRMALO GRM5LO GRM2MD GRM3MD GRM4MD GRM5MD GRM2SD GRMSSD GRM4SD GRM5SD GRM2DN GRM3DN GRM4DN GRM5DN GRM2DNW GRM3DNW GRM4DNW GRMSDNW Page 58 of 142 GRM1DNAW GRM1UP GRM1UPW GRM1UPAW GRM1NET GRM1XD GRM1XDW GRM1XD4W GRM1XU GRM1XUW GRM1XU4W GRM1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since
98. YR Page 87 of 142 Cash Flow Per Share CPSI1CV CPSI1DN CPSI1DAW CPSI1DNW CPSI1HI CPSIiLO CPSHMD CPSIiMN CPSIiNE CPSI1SD CPSI1UP CPSI1U4W CPSI1UPW CPSI1YR e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11 MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 CPSI2CV CPSI3CV CPSI4CV CPSI2DN CPSI3DN CPSI4DN CPSI2D4W CPSISDAW CPSIADAW CPSI2DNW CKI3DNW CPSIADNW CPSI2HI CPSIAHI CPSI2LO CP
99. alue of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for wGPSIch results are due to be announced ON DATASTREAM User Guide Version 5 0 GPSI2CV GPSI4CV GPSI2DN GPSI3DN GPSI4DN GPSI2D4W GPSI3D4W GPSIAD4W GPSI2DNW GPSISDNW GPSI4DNW GPSI2HI GPSI3HI GPSI4HI GPSI2LO GPSI3LO GPSI4LO GPSI2MD GPSI3MD GPSI4MD GPSI2MN GPSI3MN GPSI4MN GPSI2NE GPSISNE GPSI4NE GPSI2SD GPSISSD GPSIASD GPSI2UP GPSISUP GPSIAUP GPSI2UAW GPSISUAW GPSIAUAW GPSI2UPW GPSI3UPW GPSIAUPW GPSI2YR GPSISYR GPSIAYR Page 97 of 142 Gross Margin GRMI1CV e Coefficient of variation of all the INT1 estimates e measure of the spread of the estimates in terms of the standard deviation Calculated according to the equation CV I1 SD Absolute value of 11MN 100 GRMI1DN Number of INT1 estimates down since last monthly values GRMI1D4W Number of INT1 estimates down since the weekly values four weeks ago GRMITDNW
100. and the last estimate EPS for the period SURPP e Percentage surprise e The percentage difference between the latest interim EPS and the last estimated EPS for the period SURSD e Interim surprise standard deviation e The standard deviation of all estimates that make up the interim surprise mean SURMN for the quarter just reported Flash estimates Flash estimates are based on the estimates received by 5 in the most recent weeks They give a more up to date picture reflecting the most recent views of analysts The mnemonics listed in the first column of this table are for fiscal year 1 F1 or interim period 1 I1 For other fiscal years change the 1 to a 2 For interim periods change the F to an 47 For example EPS2FNE is the mnemonic for the total number of FY2 EPS estimates received in the last four weeks EPSI1FMN is the mnemonic for the mean of all INT1 estimates received in the last four weeks Available mnemonics for other fiscal years and interim periods are listed in the Mnemonics for other fiscal years and interim periods column Descriptions are consistent across all periods for FY1 substitute FY2 INT1 or INT2 in the descriptions given below EPS F EPS1FMN Mean of all FY1 estimates received in the last four weeks EPS2FMN EPSI1FMN EPSI2FMN EPS1FNE Total number of FY1 estimates received in the last four EPS2FNE EPSI1FNE weeks EPSI2FNE EPS1FSD Standard deviation of al
101. arch community Neglect is the ratio of Market Capitalization to the Number of EPS estimates It is expressed in millions of dollars per estimate Net Asset Value is the total book value of a company s securities It is calculated in general form by taking the total assets of a company and subtracting the value of the company s intangible assets goodwill patents etc minus current and long term liabilities NAV is helpful in determining underpriced equities by indicating the ultimate value of a company s securities in the event of their liquidation I B E S provides both expected and actual NAV data where available Net Debt is calculated as short and long term interest bearing debt minus cash Net debt is used to give an overall picture of a company s debt situation by applying cash against debt 5 provides both expected and actual net debt data where available Net income is defined as a corporation s after tax income This item varies significantly from market to market as regards the inclusion or exclusion of non recurring items In most markets non recurring items are backed out of net income and this measure is restricted to income from continuing operations only also referred to as normalized income Some markets Japan for example apply reported net income including any and all extraordinary items Recent accounting changes in still other markets particularly Southeast Asia have resulted in a reclassification of ext
102. are due to be announced ON DATASTREAM User Guide Version 5 0 DPSI2CV DPSI3CV DPSI4CV DPSI2DN DPSISDN DPSI4DN DPSI2DAW DPSI3D4W DPSI4D4W DPSI2DNW DPSISDNW DPSIADNW DPSI2HI DPSI3HI DPSI4HI DPSI2LO DPSI3LO DPSI4LO DPSI2MD DPSISMD DPSI4MD DPSI2MN DPSISMN DPSI4MN DPSI2NE DPSI3NE DPSI4NE DPSI2SD DPSI3SD DPSIASD DPSI2UP DKI3UP DPSI4UP DPSI2U4W DPSI3U4W DPSIAUAW DPSI2UPW DKISUPW DPSIAUPW DPSI2YR DPSISYR DPSIAYR Page 89 of 142 Earnings Before Goodwill EBGI1CV e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11MN 100 EBGI1DN Number of INT1 estimates down since last monthly values EBGI1D4W Number of INT1 estimates down since the weekly values four weeks ago EBGI1DNW Number of INT1 estimates down since last weekly values EBGI1HI Highest value of all INT1 estimates for a particular company EBGI1LO Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company EBGI1MN Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast EBGHSD Standard deviation of all the INT1 estimates that make up the consensus EBGHUP Number of INT1 estimates up since last monthly values EBGI1U4W Number of INT
103. ates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast INC2DINCAW INC3DINC4W INC4DINC4W INC5DINC4W INC2UP INC3UP INC4UP INCSUP INC2UPW INC3UPW INC4UPW INC5UPW INC2UP4W INC3UP4W INC4UP4W INCSUPAW INC2NET INC3NET INC5NET INC2XD INC3XD INC4XD INC5XD INC2XDW INC3XDW INC4XDW INC5XDW INC2XD4W INC3XD4W INC4XD4W INC5XD4W INC2XU INC3XU INC4XU INC5XU INC2XUW INC3XUW INC4XUW INC5XUW INC2XU4W INCSXUAW INC4XU4W INC5XU4W INC2NE INC3NE INC4NE INC5NE ON DATASTREAM User Guide Version 5 0 Page 65 of 142 Reported Net Income NER NER1MN NER1D FONER NEROYR NER1CV RONER NER1HI NER1LO NER1MD NER1SD NER1FD12 A NER NER MN NERE MN NERE MD NERE SD NER1DN NER1DNW Mean Reported Net Income for FY1 Fiscal Year End for NER1MN Last Reported Reported Net Income Fiscal Year End for FONER e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in t
104. ationale for this mid month date comes from earlier days when most brokerage research was released by US Mail on the first of the month The two week lead time was necessary to process print and ship the data to clients Today information is processed overnight and delivered for the start of the next business day The I B E S weekly cycle ends on the Thursday of each week As many brokers have different ratings 5 maintains a standard set of recommendations each with an assigned numeric value Each recommendation received from the contributors is mapped to one of the 5 standard ratings Assigning a numeric value to the broker text enables a consensus recommendation to be calculated The consensus recommendation appears as the mean of the assigned values as well as text The consensus text is determined by rounding the mean value to the nearest integer and matching it to the corresponding 5 text See Unanticipated EPS Return on Assets is a profitability ratio and as such gauges the return on investment of a company Specifically ROA measures a company s operating efficiency regardless of its financial structure in particular without regard to the degree of leverage a company uses and is calculated by dividing a company s net income prior to financing costs l B E S provides both expected and actual ROA data where available Net Income After tax interest cost ROA Return on Assets js Average Total
105. ations It is earnings with depreciation and amortization added back A similar term increasingly used is Funds Available for Distribution FAD which is FFO less capital investments in trust property and the amortization of mortgages provides both expected and actual FFO data where available Fully Reported Earnings per Share are statutory or reported earnings per share defined as net profit on continuous activities divided by the weighted average number of shares outstanding during the period Where a company carries exceptional items or goodwill amortization this measure is post exceptional post goodwill In North America this figure is referred to as GAAP Earnings per Share and is calculated according to Generally Accepted Accounting Principles GAAP which is reported in SEC filings In countries that have adopted International Financial Reporting Standards IFRS this figure will include all items according to IFRS rules Thomson Reuters provides both expected and actual GPS data where available Page 124 of 142 Gross Margin Gross Profit Margin GRM Growth Rate in EPS Through The Current Fiscal Year Highest EPS Estimate Industry IBIND Interim EPS I1MN I2MN etc Interim Period I1 YR I2YR etc Last Fiscal Year FOYR Last Fiscal Year EPS FOEPS Last Price IBP Latest Interim Reporting Date SURDT Long Term Growth Forecasts Lowest EPS Estimate EPS1LO EPS2LO etc l B E S ON
106. c sentiment The Upward revision rate is the ratio of Current EPS estimate amounts for the specified fiscal time period that were increased during the past month to the Number of EPS Estimates It is expressed as a percentage A measure of the rate of return on annual cash dividend income Yield is the ratio of the Annualized Dividend Rate to the Last Price for the Company and is expressed as a percentage Page 130 of 142 Chapter 7 A A AFO A BPS A CAP A CPS A CSH A DPS A EBD A EBG A EBS A EBT A EPS A EPS A EVT A FCF A FFO A GPS A GRM A INC A NAV A NDT A NER A OPR A PRE A PRR A ROA A ROE A SAL A TBV AFO MN AFOOYR AFO1CV AFO1D AFO1DN AFO1DN4W AFO1DNW AFO1FD12 AFO1FD12 AFO1FMN AFO1FNE 30 32 34 38 36 40 46 42 48 44 22 26 50 52 54 56 64 60 62 66 68 70 72 74 76 78 80 30 30 30 30 31 30 111 113 113 INDEX ON DATASTREAM User Guide Version 5 0 AFO1FSD AFO1HI AFO1LO AFO1MD AFO1MN AFO1NE AFO1NET AFO1SD AFO1UP AFO1UPAW AFO1UPW AFO1XD AFO1XD4W AFO1XDW AFO1XU AFO1XU4W AFO1XUW AFOE MD AFOE MN AFOE SD AFOI1CV AFOI1D4W AFOI1DN AFOI1DNW AFOI1HI AFOI1LO AFOI1MN AFOI1NE AFOI1SD AFOI1UAW AFOI1UP ANDIV B BPS MN BPSOYR BPS1CV BPS1D BPS1DN 114 30 30 30 30 31 30 31 31 31 31 31 31 30 30 30 84 84 84 84 84 84 84 84 84 84 84 119 32 32 32 33 BPS
107. consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 FFOI2CV FFOI3CV FFOI4CV FFOI2DN FFOI3DN FFOI4DN FFOI2D4W FFOI3D4W FFOI4D4W FFOI2DNW FFOI4DNW FFOI2HI FFOISHI FFOI4HI FFOI2LO FFOISLO FFOI4LO FFOI2MD FFOI3MD FFOI4MD FFOI2MN FFOISMN FFOIAMN FFOI2NE FFOI3NE FFOIANE FFOI2SD FFOI3SD FFOI4SD FFOI2UP FFOI3UP FFOI4UP FFOI2UAW FFOI3U4W FFOI4U4W FFOI2UPW FFOISUPW FFOIAUPW 2 FFOI4YR Page 96 of 142 GAAP Earnings Per Share GPSH CV GPSHDN GPSHDAW GPSI1 DNW GPSHHI GPSHLO GPSHMD GPSHMN GPSHNE GPSHSD GPSHUP GPSHUAW GPSHUPW GPSI1YR e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation Calculated according to the equation CV I1 SD Absolute value of 11MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values GPSlghest value of all INT1 estimates for a particular company Lowest v
108. ctuals Actual value for GAAP for year ending Forecast GAAP mean for estimate with year ending Time Series GAAP mean for estimate with year ending Static GAAP median for estimate with year ending Static GAAP standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values Number of FY1 estimates down since the weekly values four weeks ago ON DATASTREAM User Guide Version 5 0 GPS2MN GPS3MN GPS4MN GPS5MN GPS2D GPS3D GPS4D GPS5D GPS2CV GPS3CV GPS4CV GPS5CV GPS2HI GPS3HI GPS4HI GPS5HI GPS2LO GPS3LO GPS4LO GPS5LO GPS2MD GPS3MD GPS4MD GPS5MD GPS2SD GPS3SD GPS4SD GPS5SD GPS2DN GPS3DN GPS4DN GPS5DN GPS2DNW GPS3DNW GPS4DNW GPSSDNW GPS2DN4W GPS3DN4W GPS4DN4W GPS5DNAW Page 56 of 142 GPS1UP GPS1UPW GPS1UPAW GPS1NET GPS1XD GPS1XDW GPS1XD4W GPS1XU GPS1XUW GPS1XUAW GPS1NE Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimate
109. ctuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for net income for year ending Forecast Net Income mean for estimate with year ending Time Series Net Income mean for estimate with year ending Static Net Income median for estimate with year ending Static Net Income standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 INC2MN INCSMN INC4MN INC5MN INC2D INC3D INC4D INC5D INC2CV INC3CV INC4CV INC5CV INC2HI INC3HI INC4HI INC5HI INC2LO INC3LO INC4LO INC5LO INC2MD INC3MD INC4MD INC5MD INC2SD INC3SD INC4SD INC5SD INC2DN INC3DN INC4DN INC5DN INC2DNW INC3DNW INC4DNW INC5DNW Page 64 of 142 INC1DNAW INC1UP INC1UPW INC1UP4W INC1NET INC1XD INC1XDW INC1XD4W INC1XU INC1XUW INC1XU4W INC1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estim
110. d Book Value Per Share Fiscal Year End for FOBPS e Coefficient of variation of all the FY1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV BPS1SD Absolute value of BPS1MN 100 Restated reported Book Value Per Share Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Book Value Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Book value per share for year ending HP Forecast Book value mean for estimate with year ending Time Series Book value mean for estimate with year ending Static Book value median for estimate with year ending Static Book value standard deviation with estimate for year ending Static Total Revision data types ON DATASTREAM User Guide Version 5 0 BPS2MN BPS3MN BPSAMN 55 BPS2D BPS3D BPS4D BPS5D BPS2CV BPS3CV BPS4CV BPS5CV BPS2HI BPS3HI BPS4HI BPS5HI BPS2LO BPS3LO BPS4LO BPS5LO BPS2MD BPS3MD BPS4MD BPS5MD BPS2SD BPS3SD BPS4SD BPS5SD Page 32 of 142 BPS1DN BPS1DNW BPS1DN4W BPS1UP BPS1UPW BPS1UPAW BPS1NET BPS1XD BPS1XDW BPS1XD4W BPS1XU
111. d deviation e Calculated according to the equation CV I1 SD Absolute value of 11 MN 100 EBSI1DN Number of INT1 estimates down since last monthly values EBSI1D4W Number of INT1 estimates down since the weekly values four weeks ago EBSHDNW Number of INT1 estimates down since last weekly values EBSI1HI Highest value of all INT1 estimates for a particular company EBSI1LO Lowest value of all INT1 estimates for a particular company EBSIiMD Median value of all INT1 estimates for a company EBSI1MN Mean value of all INT1 estimates for a company EBSHNE Total number of estimates associated with INT1 forecast EBSHSD Standard deviation of all the INT1 estimates that make up the consensus EBSHUP Number of INT1 estimates up since last monthly values EBSHUPAW Number of INT1 estimates up since the weekly values four weeks ago EBSHUPW Number of INT1 estimates up since last weekly values EBSI YR e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced l B E S ON DATASTREAM User Guide Version 5 0 EBSI2CV EBSI3CV EBSI4CV EBSI2DN EBSI3DN EBSI4DN EBSI2D4W EBSI3D4W EBSIADAW EBSI2DNW EBSISDNW EBSIADNW EBSI2HI EBSI3HI EBSI4HI EBSI2LO EBSI3LO EBSI4LO EBSI2MD EBSISMD EBSIAMD EBSI2MN EBSISMN EBSIAMN EBSI2NE EBSI3NE EBSI4NE EBSI2SD EBSI3SD EBSIASD EBSI2UP EBSI3UP EBSIAUP EBSI2U4W EBSISUAW EBSIAUAW EBSI2UPW EBSISUPW EBSIAUP
112. ded companies was introduced on December 16 2004 This requires North American companies to calculate and amortize stock option expenses through the income statement for fiscal years beginning after June 15 2005 Stock option expenses are only included in the EPS mean when the majority of contributing analysts have included the expenses in their estimates A measure of the profitability of the parent Company that is the owner of a group of affiliated corporations The net income from operations of the parent Company and dividends interests royalties etc received from its subsidiaries enter into the computation of Parent company earnings per share Whenever it is appropriate all Current EPS estimates reflect the outlook for Parent company earnings per share only in order to maintain their comparability Pre tax profit is a company s net income before tax expense Where applicable extraordinary items and non recurring charges are subtracted from net income Thomson Reuters provides both expected and actual PRE data where available In Japan companies compliant with Japan Accounting Standards use Recurring Profit The pre tax profit reported by the company inclusive of all amortization and one time charges Also referred to as Pre Tax Profit Reported Excluding for one off cases the GAAP Pre Tax Profit excludes the effect of discontinued operations for all regions The date on which the most recent transaction took place The Price
113. e is replaced by an YY date Actuals Actual value for enterprise value for year ending HP Forecast Enterprise Value mean for estimate with year ending Time Series Enterprise Value mean for estimate with year ending Static Enterprise Value median for estimate with year ending Static Enterprise Value standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 EVT2MN EVT3MN EVT4MN EVT5MN EVT2D EVT3D EVT4D EVT5D EVT4CV EVT5CV EVT2HI EVT5HI EVT2LO EVT3LO EVT4LO EVT5LO EVT2MD EVT3MD EVT4MD EVT5MD EVT2SD EVT3SD EVT4SD EVT5SD EVT2DN EVT3DN EVT4DN EVT5DN EVT2DNW EVT3DNW EVT4DNW EVTSDNW Page 50 of 142 EVT1DNAW EVT1UP EVT1UPW EVT1UPAW EVT1NET EVT1XD EVT1XDW EVT1XDAW EVT1XU EVT1XUW EVT1XUAW EVT1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates
114. e EX DS Mnemonic MKS Industry Code MERCHAN Currency BPN IE S Analyst Agreement Flash 1 Momh Ago StdDev Cv Est StdDev CY Est StdDev CY 1 430 3 670 10 0 834 2423 24 1 510 3 897 2 208 5 089 11 2 092 4 821 24 2 150 4 995 4 033 8 388 17 3 530 7 408 2 15 580 34 655 14 230 Analysis E Single Series Overview Overview of Company Performance Overview of any Series IB EJS Forecast Overview oefficienrt ariation EPS Growth Data 3Months Ago 5MonthsAgo Momentum Data Est StdDev CV Est StdDev CY 5 25 1390 3 729 24 1 580 4 339 Stock Valuation Data 24 24140 5237 22 2 700 6 782 15 3470 7 858 10 5 560 13 248 Analyst Sponsorship Data 2 13680 33382 2 18490 48202 Analyst Agreement Data 3 12 610 2 1 670 Median Data Thomson ONE browser pages Multiple Series Flexible Chart J SOND J FM AM JJ ASONDJ FY COEFF OF VAPN ingle Series Chart FY2 COEFF OF vARN Annual EPS 03 06 31 40 Interim EP S 09 06 ingle Series Report Single Series Data hs Surce TRemsen Datsstrea gt Project Equity Screening Run the request 4 Taking into account the number of estimates the analyst agreement tear sheet gives an indication of the central tendency in the sample showing the degree of agreement amongst analysts Analyst Sponsorship Time Period Not Applicable 20v 15v 10v 5Y Datatype DEFAU e Seren re No
115. e Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast CSH2DN4W CSH3DN4W CSH4DN4W CSH5DNAW CSH2UP CSH3UP CSH4UP CSH5UP CSH2UPW CSH3UPW CSH4UPW CSH5UPW CSH2UP4W CSH3UP4W CSH4UP4W CSH5UP4W CSH2NET CSH3NET CSHANET CSH5NET CSH2XD CSH3XD CSHAXD CSH5XD CSH2XDW CSH3XDW CSHAXDW CSH5XDW CSH2XD4W CSH3XD4W CSH4XD4W CSH5XD4W CSH2XU CSH3XU CSH4XU CSH5XU CSH2XUW CSH3XUW CSH4XUW CSH5XUW CSH2XUAW CSH3XU4W CSHAXUAW CSH5XUAW CSH2NE CSH3NE CSHANE CSH5NE ON DATASTREAM User Guide Version 5 0 Page 37 of 142 Cash Flow per Share CPS CPS1MN CPS1D FOCPS CPSOYR CPS1CV ROCPS CPS1HI CPS1LO CPS1MD CPS1SD CPS1FD12 A CPS CPS MN CPSE MN CPSE MD CPSE SD CPS1DN CPS1DNW CPS1DN4W Mean Cash Flow Per Share for FY1 Fiscal Year End for CPS1MN Last Reported Cash Flow Per Share Fiscal Year End for FOCPS e Coefficient
116. e Series Flexible Chart Single Series Chart Single Series Report Single Series Data Codes and Information Favourites Scenario Testing Equity Screening Enter Me o 5 esi 2 ini Time Period Not Applicable 20 G 15v 10Y 5 3Y Settings Datatype 71 rz am C Base Name 43 MKS MKS Datatype Currency Not Applicable 71 I B E S on Datastream VB E S Ticker MKS DS Mnemonic MKS Industry Code MARKS amp SPENCER GROUP 10 01 07 10 43 Country Code EX MERCHAN Currency BPN VB E S Earnings Momentum Mean Change Period Mean Ests Up Down 1VWVk 4 Vks 3Mths 6Mths 1Year Rv Ratio Flash 1 38 92 29 2 1 0 21 0 45 4 41 6 90 33 44 0 04 39 16 FY2 43 33 23 2 1 0 25 0 66 6 04 8 83 31 89 0 04 43 71 FY3 48 20 17 2 1 0 08 1 16 1 16 9 32 36 35 0 06 FY4 44 90 2 0 0 01 0 01 9 58 19 52 16 61 0 00 LTG 15 09 3 0 0 02 0 02 16 14 14 47 42 46 0 00 INT 1 12 40 INT2 INT3 Reference Data 50 soo Actual Earnings Annual EPS 03 06 31 40 40 600 Last4 09 06 03 06 03 05 06 04 Int EPS 30 400 Growth Rates Surprise Mean Surprise 20 200 SUE Score JASONDJ FMAMJ J ASON DJ FY4 MEAN Price Data FY2 MEAN Datastream Price 696 00 PRICE IBES R H SCALE 9 Change 1Mth 3Mths 6Mths 5 43 2 50 4 74 15 38 Source Thomson Datastrean y Project Eq
117. e greater than other composite forecasts because it incorporates new information more effectively Page 123 of 142 Four Week Rolling Data Free Cash Flow Per Share FCF Fully Diluted Earnings Per Share DILFCT Funds From Operations FFO GAAP Earnings Per Share Fully reported GPS l B E S ON DATASTREAM User Guide Version 5 0 EPS1DN4W EPS1UP4W EPS4DN4W EPSAUPAW All such data items are calculated using a rolling four week time frame as described below The 5 weekly cycle takes place on every Thursday At that point all one month ago values shift to reflect the state of the database as it existed on the Thursday exactly four weeks prior One month percentage change values are then calculated by comparing the current data to this base number For daily products even though the current number may change as daily updates are received the base number will remain the same until the next weekly run when it will shift one week forward For Example if EPS revisions for a company are received on a Monday the one month percent change in the mean is calculated by comparing the current mean and the mean as it existed four weeks AND two days prior If additional revisions were received on Tuesday the period would be four weeks and three days Hence if daily revisions are made on a company the time period used in the one month percentage change calculations may be greater than four weeks However since the base pe
118. e period on the day prior to the Latest Interim Reporting Date for the Company Page 122 of 142 Fiscal Periods FYO FY1 FY2 Five Year Historical EPS Growth YR5GTH Five Year Historical EPS Stability Flash Mean EPS Estimate EPS1FMN EPS1FNE EPS2FMN EPS2FNE etc ON DATASTREAM User Guide Version 5 0 A company s last reported annual earnings period is referred to as FYO The period end dates for all estimated periods are then based on FYO If FYO corresponds to the December 1996 year end the FY1 mean estimate is for December 1997 and the FY2 mean estimate is for the period ended December 1998 The average annual earnings per share growth for a company over the past five years The average annual growth in EPS for the past five years is calculated by measuring the slope of a log linear line fit to the reported earnings It is expressed as a percentage If quarterly data is available the line is fitted to the last 21 observations of rolling four quarter EPS The resultant growth slope is raised to the fourth power to obtain an annualized growth factor If semi annual data is available the curve is fitted to the last 11 observations of the semi annual data The resultant growth slope is raised to the second power to obtain the annual growth factor If only annual observations are available the curve is fitted to the last 6 annual observations 5 time periods and the slope is used to represent the growth
119. e with earnings before goodwill EBG data types Going forwards an increasing proportion of estimates for a given company will be on an IFRS basis During the period in which estimate contributors are making the transition from pre IFRS to IFRS mean estimates will be calculated for all measures based on both pre IFRS estimates and IFRS estimates with the default means always reflecting the majority of contributor submissions Thomson Reuters is therefore implementing the following changes history for the EPS data types has been converted to equate to earnings before goodwill EBG data as far back as EBG data was available for each company history for the EPS data types that predates EBG data availability has been left as EPS post goodwill data Total EPS history has been saved to a new set of data types with the same stem mnemonics and a O suffix For example EPS1MN O gives access to the mean value of all FY1 EPS estimates for a company calculated on a post goodwill basis data types are listed under the relevant sections of this manual e data types will transition to displaying majority IFRS data at the same time as the EPS data types A set of pre IFRS mean data types is available with the default history up to the point at which the majority of contributor estimates become IFRS estimates After this point pre IFRS means will continue to be calculated for as long as estimates on a
120. ean Net Asset Value for FY1 Fiscal Year End for NAV1MN Last Reported Net Asset Value Fiscal Year End for FONAV e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV 96 NAV1SD Absolute value of NAV1MN 100 Restated reported Net Asset Value Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Net Asset Value Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for net asset value for year ending Forecast Net Asset Value mean for estimate with year ending Time Series Net Asset Value mean for estimate with year ending Static Net Asset Value median for estimate with year ending Static Net Asset Value standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 NAV2MN NAV3MN NAV4MN NAV5MN NAV2D NAVSD NAV4D 5 NAV2CV NAV4CV NAV5CV NAV2HI NAV3HI NAV4HI NAV5HI NAV2LO NAV3LO NAV4LO NA
121. easures Adjusted Funds From Operations AFO 2 2 July 2007 Book Value Per Share BPS 7 7 Dec 1996 Capital Expenditure CAP Y Y July 2006 Cash Earnings Per Share CSH Y 7 Jan 1997 Cash Flow Per Share CPS Y V Dec 1994 Dividends Per Share DPS Y Y Dec 1993 Earnings Before Goodwill PS EBG Y Dec 1995 EBIT EBT Y Y May 1999 EBITDA EBD Dec 1998 EBITDA Per Share EBS Y Y May 2004 Enterprise Value EVT 2 Y July 2006 Free Cash Flow Per Share FCF 7 Y July 2007 Funds From Operations PS FFO 7 7 1990 GAAP Earnings Per Share GBS 7 Aug 2003 Gross Margin GRM 7 July 2006 Net Asset Value NAV Y Y May 1999 Net Debt NDT Jul 2000 Net Income INC Y Y Dec 1994 Operating Profit OPR 2 7 1998 Pre tax profit BRS Z Y Dec 1994 Return on Assets ROA Y 7 Aug 1999 Return on Equity ROE 7 Y May 1999 Reported Net Income NER Y Y July 2008 Reported Pre Tax Profit PRR Y Y July 2008 Sales SAL d Y Feb 1996 Tangible Book Value Per Share TBV Y Y July 2008 Recommendations REC 7 1993 Price Target 7 Y Mar 1999 5 ON DATASTREAM User Guide Page 28 of 142 Version 5 0 Countries that display Non per Share PS items in billions Chile Columbia Indonesia Japan Korea Venezuela Here clients can utilize data type IBUNIT this returns a numeric value of either 1 for non per share data in millions or 1 000 for billions This allows comparison of non per share measures across these markets The mnemonics for the data types
122. erms of the standard deviation e Calculated according to the equation CV NER1SD Absolute value of NER1MN 100 Restated reported Reported Net Income Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Reported Net Income Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Reported Net Income for year ending Forecast Reported Net Income mean for estimate with year ending Time Series Reported Net Income mean for estimate with year ending Static Reported Net Income median for estimate with year ending Static Reported Net Income standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 NER2MN NER3MN NER4MN NER5MN NER2D NERSD NER4D NER5D NER2CV NER3CV NER4CV NERSCV NER2HI NER4HI NER5HI NER2LO NER3LO NER4LO NERSLO NER2MD NER4MD NERS5MD NER2SD NERS3SD NER4SD NER5SD NER2DN NERSDN NER4DN NERS5DN NER2DNW NERSDNW NER4DNW NER5DNW Page 66 of 142 NER1DNAW NER1UP NER1UP
123. es up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 EBT2UP EBT3UP EBT4UP EBT5UP EBT2UPW EBT3UPW EBT4UPW EBT5UPW EBT2UP4W EBT3UP4W EBT4UP4W EBTSUPAW EBT2NET EBT3NET EBT4NET EBTSNET EBT2XD EBT3XD EBT4XD EBT5XD EBT2XDW EBTSXDW EBTAXDW EBT5XDW EBT2XD4W EBT3XD4W EBT4XD4W EBT5XD4W EBT2XU EBT3XU EBT4XU EBT5XU EBT2XUW EBT3XUW EBT4XUW EBT5XUW EBT2XU4W EBT3XU4W EBT4XU4W EBT2NE EBT3NE EBT4NE EBT5NE Page 45 of 142 EBITDA Earnings Before Interest Taxes Depreciation and Amortization EBD1MN Mean EBITDA for FY1 EBD1D Fiscal Year End for EBD1MN FOEBD Last Reported EBITDA EBDOYR Fiscal Year End for FOEBD ROEBD Restated reported EBITDA EBD1CV e Coefficient
124. est income components generally include net interest earned on loans reserve deposits and deposits with other banks and net interest earned from interbank money market operations IMMO and marketable securities Net non interest income components generally include net income from fees and commissions net gains from Capital market and foreign exchange operations and net income earned from participations For insurance companies revenue is generally defined as net technical income plus net financial income Net technical income is generally defined as technical income minus technical expenses Technical income components generally include income from premiums and commissions received reinsurer s share of claims paid transferred net technical reserves and reinsurer s share of technical reserves Net financial income is generally defined as financial income minus financial expenses Net financial income components generally include net interest income net dividend income and net foreign exchange gains l B E S provides both expected and actual SAL data where available The description of a homogenous group of industries that make up a major subset of the market l B E S maintains its own proprietary classification system which segregates companies at three different levels Sector Industry Group Sectors are subdivided into Industries which are in turn subdivided into Groups Both the US and non US databases comprise 11 sectors
125. estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 CAP2MN CAP3MN CAP4MN CAP5MN CAP2D CAP3D CAP4D CAP5D CAP2CV CAP3CV CAP4CV CAP5CV CAP2HI CAP3HI CAP4HI CAP5HI CAP2LO CAP3LO CAP4LO CAP5LO CAP2MD CAP3MD CAP4MD CAP5MD CAP2SD CAP3SD CAP4SD CAP5SD CAP2DN CAP3DN CAP4DN CAP5DN CAP2DNW CAP3DNW CAP4DNW CAP5DNW Page 34 of 142 CAP1DNAW CAP1UP CAP1UPW CAP1UPAW CAP1NET CAP1XD CAP1XDW CAP1XDAW CAP1XU CAP1XUW CAP1XUAW CAP1NE Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean
126. estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced EPSI2CV EPSI3CV EPSI4CV EPSI2DN EPSISDN EPSI4DN EPSI2DN4W EPSISDNAW EPSIADNAW EPSI2DNW EPSISDNW EPSIADNW EPSI2HI EPSI4HI EPSI2LO EPSISLO EPSI4LO EPSI2MD EPSISMD EPSIAMD EPSI2MN EPSISMN EPSIAMN EPSI2NE EPSI3NE EPSI4NE EPSI2SD EPSI3SD EPSIASD EPSI2UP EPSI3UP EPSI4UP EPSI2UP4W EPSISUPAW EPSIAUPAW EPSI2UPW EPSISUPW EPSI4UPW EPSI2YR EPSI3YR EPSI4YR B E S ON DATASTREAM User Guide Version 5 0 Page 24 of 142 Historical long term growth YR5GTH e Historical five year growth e The rate of change in reported earnings per share over the five year time intervals terminating on the date of the last fiscal period for which EPS have been announced YR5STB A measure of stability
127. f INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago ON DATASTREAM User Guide Version 5 0 BPSI2CV BKI3CV BKI4CV BPSI2DN BKI3DN BKI4DN BPSI2D4W BPSI3D4W BPSI4D4W BPSI2DNW BPSI3DNW BPSIADNW BPSI2HI BPSISHI BPSI4HI BPSI2LO BPSISLO BPSI4LO BPSI2MD BPSISMD BPSIAMD BPSI2MN BPSISMN BPSIAMN BPSI2NE BJISNE BJIANE BPSI2SD BPSI3SD BPSIASD BPSI2UP BJISUP BPSIAUP BPSI2UAW BPSISUAW BPSIA4UAW Page 85 of 142 Capital Expenditure CAPHCV CAPHDN CAPI1D4W CAPI1DNW CAPHLO CAPHMD CAPHMN CAPHNE CAPHSD CAPHUP CAPHUAW CAPHUPW CAPIH YR e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11 100 Number of INT1 estimates down since last monthly values Nu
128. factor Zero and negative observations are excluded from the calculations Five year earnings per share stability measures the consistency of earnings per share growth over the past five years The lower the number the more uniform growth has been Combined with earnings growth data the stability figure provides a multi dimensional view of earnings growth over the past five years Earnings stability is calculated as the mean absolute percentage difference between actual reported earnings per share and a five year historical EPS growth trend line expressed as a percentage of trend line earnings per share The Five Year Historical EPS Stability is calculated as follows Earnings x Ti rend x i n Stability ps i l n where Earnings xi actual reported earnings for occurrence I Trend xi calculated earnings per b x trend line trend point for the ith period n number of observations A composite forecast of earnings per share for those values of the Current EPS estimate for the specified fiscal time period that have been revised during the past four weeks The Flash mean EPS estimate for a Company is calculated by adding the Current EPS estimates for the specified fiscal time period that have been revised during the past four weeks and dividing this sum by the Number of EPS Estimates that entered into the calculation The accuracy of the Flash mean EPS estimate is expected to b
129. fined set of values is less affected by outlier forecasts The smallest Current EPS estimate for the specified fiscal time period Page 125 of 142 Market Capitalization Mean Absolute Deviation Mean EPS Estimate EPS1MN EPS2MN etc Median EPS Estimate EPS1MD EPS2MD etc Naive Estimate Neglect Net Asset Value NAV Net Debt NDT Net Income INC Reported Net Income NER Next Fiscal Year F2YR Number of EPS Estimates EPS1NE EPS2NE etc l B E S ON DATASTREAM User Guide Version 5 0 The aggregate value of all trading stock for the Company whatever its ownership It is calculated by multiplying Number of shares outstanding by Last Price It is given in millions of currency units See Five Year Historical EPS Stability The arithmetic average of estimates for the fiscal period indicated The mean is calculated as follows n Xx Xi 1 where xi individual analysts forecasts n number of estimates The value that falls in the middle of the defined range of estimates when arranged in ascending order That is the value within the sample that has an equal number of estimates both greater and less than itself If the sample has an equal number of estimates it is the average of the two middle values Median values are less affected by outlier forecasts than mean values See Growth Rate in EPS Through The Current Fiscal Year A measure of the amount of sponsorship by the investment rese
130. in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 EVT2DN4W EVTSDNAW EVT4DN4W EVT5DN4W EVT2UP EVT3UP EVT4UP EVT5UP EVT2UPW EVTSUPW EVT4UPW EVTSUPW EVT2UPAW EVT3UP4W EVT4UP4W EVTSUPAW EVT2NET EVTANET EVTSNET EVT2XD EVT3XD EVT4XD EVT5XD EVT2XDW EVT3XDW EVT4XDW EVT5XDW EVT2XD4W EVT3XD4W EVT4XD4W EVT5XD4W EVT2XU EVT3XU EVT4XU EVT5XU EVT2XUW EVT3XUW EVT4XUW EVT5XUW EVT2XU4W EVT3XU4W EVT4XU4W EVT5XU4W EVT2NE EVT3NE EVT4NE EVT5NE Page 51 of 142 Free Cash Flow per Share FCF FCF1MN FCF1D FOFCF FCFOYR FCF1CV ROFCF FCF1HI FCF1LO FCF1MD FCF1SD FCF1FD12 A FCF FCF MN FCFE MN FCFE MD FCFE SD FCF1DN Mean Free Cash Flow Per Share for FY1 Fiscal Year End for FCF1MN Last Reported Free Cash Flow Per Share Fiscal Year End for FOFCF e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the sta
131. in which the parent Company holds more than 2095 enters into the computation of Consolidated earnings per share Whenever it is appropriate all Current EPS estimates reflect the outlook for Consolidated earnings per share only in order to maintain their comparability The nation where the corporate headquarters for the Company is located The monetary unit in which the earnings per share forecasts results and other related fiscal data are stated The codes issued by the International Standard Organization ISO are used to identify the currencies in most cases The accounting period of twelve months regarded as the latest because there has not yet been an announcement of the Company s annual fiscal results even though the Company may have already closed its books A measure of the difference between primary and fully diluted earnings per share amounts The Dilution factor is expressed as a percentage and is the ratio of Last Fiscal Year to a recalculation of the Last fiscal year EPS by converting all convertible securities Whenever it can be shown that the basis for the Current EPS estimate for the Company is inconsistent with the others that are available it is adjusted by the amount of the Dilution factor to enhance its comparability A corporation s common stock dividends on an annualised basis divided by the weighted average number of common shares outstanding for the year In the U S DPS is calculated before withholding taxes F
132. included the expenses in their estimates With this in mind the following data types will enable clients to retrieve earning figures on both a majority and minority basis determined by whether the estimates include or exclude option expenses Furthermore users can retrieve the number of estimates contributing to either mean Description Mnemonics for other fiscal years Annual data types EPS1MN Mean value of all estimates for a company derived EPS2MN EPS3MN EPSAMN by the majority of contributing analysts EPS5MN EPS1MN E Mean value of all estimates for a company EPS2MN E EPS3MN E expenses in the estimate have been included EPSAMN E EPS5MN E EPS1MN X Mean value of all estimates for a company EPS2MN X EPS3MN X expenses in the estimate have been excluded EPSAMN X 55 I B E S ON DATASTREAM User Guide Page 20 of 142 Version 5 0 Description Mnemonics for other fiscal years EPS1NE E EPS1NE X OBASE1 OBASEN1 EPSHMN E EPSHMN X EPSHNE E EPSHNE X Total number of estimates associated with the forecast that have included expenses in their estimates Total number of estimates associated with the forecast that have excluded expenses in their estimates Option Expense Accounting Basis Option Expense Accounting Basis numeric code Quarterly data types Mean value of all interim estimates for a company expenses in the estimate have been included Mean value of all interim estimates for a compa
133. increased from their previous values over the last week four weeks and month New estimates and multiple estimate changes are not counted in this sum For example if during a four week period an analyst lowers their estimate from 2 50 to 2 10 and then revises that estimate from 2 10 to 2 30 it is counted as one estimate raised because only the immediate prior estimate is used in the calculation A measure of the amount of common stock that can be publicly traded For a U S Company the Number of shares outstanding is the actual Number of shares outstanding less treasury stock For a non U S Company the Number of shares outstanding is generally the actual Number of shares outstanding The Number of shares outstanding is given in millions of shares Operating Profit is the difference between a company s revenues and its costs and expenditures arising directly out of a company s regular operations Operating Profit is calculated before any deductions in income owing to non operating activities generally such items as interest expense corporate tax payments material gains or losses arising from changes in accounting policy and the like and excludes any income derived from outside the firm s regular activities 1 5 provides both expected and actual OPR data where available Displayed in whole number terms millions The Security and Exchange Commission s ruling on the expensing of stock options FAS123 R for US publicly tra
134. ion 5 0 EBS2DN EBS3DN EBS4DN EBS5DN EBS2DNW EBS3DNW EBS4DNW EBSSDNW EBS2DN4W EBS3DN4W EBS4DN4W EBS5DNAW EBS2UP EBS3UP EBS4UP EBS54UP EBS2UPW EBS3UPW EBS4UPW EBSSUPW EBS2UP4W EBS3UP4W EBS4UP4W EBSSUPAW EBS2NET EBS3NET EBS4NET 55 EBS2XD EBS3XD EBS4XD EBS5XD EBS2XDW EBS3XDW EBS4XDW EBS5XDW EBS2XD4W EBS3XD4W EBS4XD4W EBS5XDAW EBS2XU EBS3XU EBS4XU EBS5XU EBS2XUW EBS3XUW EBS4XUW EBS5XUW EBS2XUAW EBS3XU4W EBS4XU4W EBS5XUAW EBS2NE EBS3NE EBS4NE EBS5NE Page 49 of 142 Enterprise Value EVT EVT1MN EVT1D FOEVT EVTOYR ROEVT EVT1HI EVT1LO EVT1MD EVT1SD EVT1FD12 A EVT EVT MN EVTE MN EVTE MD EVTE SD EVT1DN EVT1DNW Mean enterprise value for FY1 Fiscal Year End for EVT1MN Last Reported Enterprise Value Fiscal Year End for FOEVT Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV EVT1SD Absolute value of EVT1MN 100 Restated reported Enterprise Value Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Enterprise Value Estimates and Actuals on a calendar year basis Wher
135. l the FY1 estimates received inthe EPS2FSD EPSI1FSD last four weeks ERSIZESD All other measures measure ID FY1 or FY2 e Annual MN NE SD e nterim I MN I NE IZSD Adjusted Funds From Operations AFO1FMN Mean of all FY1 estimates received in the last four weeks AFO2FMN AFOH FMN AFOI2FMN AFO1FNE Total number of FY1 estimates received in the last four weeks AFO2FNE AFOI1FNE AFOI2FNE l B E S ON DATASTREAM User Guide Page 113 of 142 Version 5 0 AFO1FSD BPS1FMN BPS1FNE BPS1FSD CAP1FMN CAP1FNE CAP1FSD CSH1FMN CSH1FNE CSH1FSD CPS1FMN CPS1FNE CPS1FSD DPS1FMN DPS1FNE DPS1FSD EBG1FMN EBG1FNE Standard deviation of all the FY1 estimates received in the last four weeks Book Value per Share Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Capital Expenditure Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Cash Earnings per Share Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Cash Flow Per Share Mean of
136. last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 PREI2CV PREI3CV PREI4CV PREI2DN PREISDN PREI4DN PREI2DAW PREISDAW PREI4D4W PREI2DNW PREISDNW PREIADNW PREI2HI PREISHI PREI4HI PREI2LO PREI3LO PREI4LO PREI2MD PREISMD PREIAMD PREI2MN PREISMN PREIAMN PREI2NE PREI3NE PREIANE PREI2SD PREI3SD PREI4SD PREI2UP PREISUP PREIAUP PREI2UAW PREISUAW PREI4U4W PREI2UPW PREISUPW PREIAUPW PREI2YR PREISYR PREIAYR Page 104 of 142 Reported Pre Tax Profit PRRHCV PRRHDN PRRHDAW PRRHDNW PRRI1HI PRRHLO PRRHMD PRRHMN PRRHNE PRRHSD PRRHUP PRRHUAW PRRHUPW PRRI1YR e Coefficient of variation of all the INT1 estimates e measure of the spread of the estimates in terms of the standard deviation Calc
137. ll calculations of I B E S PE ratios and dividend yields IBPDTE e Price Date e The date that the price was last amended reviewed e Returned in either American MM DD YY or European DD MM Y Y format ANDIV e Indicated annual dividend e For US companies ANDIV is the last quarterly dividend multiplied by four e Dividend is in the same currency as the earnings forecasts e Displayed to two decimal places SPLDTE The date on which a stock split occurred SPLFCT The adjustment factor applied to the stock s per share values as a result of a stock split l B E S ON DATASTREAM User Guide Page 119 of 142 Version 5 0 Chapter 6 Glossary This glossary is intended to aid your understanding of the financial and statistical data types included or derived in the I B E S database The definitions are arranged alphabetically by name Where appropriate related data types are given in brackets after the glossary entry Linked terms within a definition indicate that the term is itself defined in the glossary Absolute Surprise Annualized Dividend Rate ANDIV Average EPS Estimate EPS1MN EPS2MN etc Adjusted Funds For Operations AFO Book Value Per Share BPS Calendarised Amount Capital Expenditure CAP Cash Earnings Per Share CSH l B E S ON DATASTREAM User Guide Version 5 0 See Unanticiapted EPS An indicated annual dividend payment based on the last quarterly dividend The Annualized dividend rate is calculated by
138. ll the INT1 estimates e measure of the spread of the estimates in terms of the standard deviation Calculated according to the equation CV I1 SD Absolute value of 11MN 100 ROAI1DN Number of INT1 estimates down since last monthly values ROAI1D4W Number of INT1 estimates down since the weekly values four weeks ago ROAHDNW Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company ROAI1LO Lowest value of all INT1 estimates for a particular company ROAHMD Median value of all INT1 estimates for a company ROAHMN Mean value of all INT1 estimates for a company ROAHNE Total number of estimates associated with INT1 forecast ROAI1SD Standard deviation of all the INT1 estimates that make up the consensus ROAI1UP Number of INT1 estimates up since last monthly values ROAI1U4W Number of INT1 estimates up since the weekly values four weeks ago ROAHUPW Number of INT1 estimates up since last weekly values ROAH YR e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced l B E S ON DATASTREAM User Guide Version 5 0 ROAI2CV ROAI3CV ROAI4CV ROAI2DN ROAISDN ROAI4DN ROAI2D4W ROAISDAW ROAI4D4W ROAI2DNW ROAI3DNW ROAI4DNW ROAI2HI ROAISHI ROAI4HI ROAI2LO ROAI3LO ROAI4LO ROAI2MD ROAI3MD ROAI4MD ROAI2MN ROAI3MN ROAI4MN ROAI2NE ROAI3NE ROAI4NE ROAI2SD ROAI3SD
139. ll the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 TBVI2CV TBVISCV TBVI4CV TBVI2DN TBVI3DN TBVI4DN TBVI2D4W TBVI3D4W TBVI4D4W TBVI2DNW TBVISDNW TBVIADNW TBVI2HI TBVISHI TBVI4HI TBVI2LO TBVISLO TBVI4LO TBVI2MD TBVISMD TBVI4MD TBVI2MN TBVI4MN TBVI2NE TBVISNE TBVIANE TBVI2SD TBVISSD TBVI4SD TBVI2UP TBVISUP TBVI4UP TBVI2ZU4W TBVISUAW TBVIAUAW TBVI2UPW TBVISUPW TBVIAUPW TBVI2YR TBVISYR TBVIAYR Page 109 of 142 Recommendations Recommendations are retrievable via both Static and Time Series requests Recommendations history is available from December 2005 going forward RECNO RECCON RECTXT a C SBUY BUY HOLD UPRF SELL Price Target Price Target data types are available under Static and Time series requests Number of recommendations Recommendation consensus Text field translation of RECCON Between 1 amp 1 49 Between 1 5 amp 2 49 Between 2 5 amp 3 49 Between 3 5 amp 4 49 Between 4 5 amp 5 Listed below are Price Target data types PTMN PTNE PTHI PTLO PTUPAW PTDNAW
140. mates for a company EBT1SD Standard deviation of all the FY1 estimates that make up the consensus EBT1FD12 12 month forward EBIT Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals A EBT Actual value for EBIT for year ending Forecast EBT MN EBIT mean for estimate with year ending Time Series EBTE MN EBIT mean for estimate with year ending Static EBIT median for estimate with year ending Static EBTE SD EBIT standard deviation with estimate for year ending Static Total Revision data types EBT1DN Number of FY1 estimates down since last monthly values EBT1DNW Number of FY1 estimates down since last weekly values EBT1DNAW Number of FY1 estimates down since the weekly values four weeks ago l B E S ON DATASTREAM User Guide Version 5 0 EBT2MN EBT3MN EBT4MN 5 EBT2D EBT4D EBT5D EBT2CV EBT3CV EBT4CV EBT5CV EBT2HI EBT5HI EBT2LO EBT3LO EBT4LO EBT5LO EBT2MD EBT3MD EBT4MD EBT5MD EBT2SD EBT3SD EBT4SD EBT5SD EBT2DN EBT3DN EBT4DN EBTS5DN EBT2DNW EBTSDNW EBT4DNW EBT5DNW EBT2DN4W EBTSDNAW EBT4DN4W EBT5DN4W Page 44 of 142 EBT1UP EBT1UPW EBT1UPAW EBT1XD EBT1XDW EBT1XD4W EBT1XU EBT1XUW EBT1XU4W EBT1NE Number of FY1 estimates up since last monthly values Number of FY1 estimat
141. mates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 NERI2CV NERISCV NERI4CV NERI2DN NERISDN NERIADN NERI2D4W NERISDAW NERI4D4W NERI2DNW NERISDNW NERIADNW NERI2HI NERISHI NERI4HI NERI2LO NERISLO NERI4LO NERI2MD NERISMD NERIAMD NERI2MN NERI3MN NERIAMN NERI2NE NERISNE NERI4NE NERI2SD NERISSD NERI4SD NERI2UP NERI3UP NERI4UP NERI2U4W NERI3U4W NERI4U4W NERI2UPW NERISUPW NERI4UPW NERI2YR NERISYR NERI4YR Page 102 of 142 Operating Profit OPRI1CV e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11MN 100 OPRHDN Number of INT1 estimates down since last monthly values OPRI1D4W Number of INT1 estimates down since the weekly values four weeks ago OPRHDNW Number of INT1 estimates down since last weekly values OPRI1HI Highest value of all INT1 estimates for a particular company OPRHLO Lowest value of all INT1 estimates for a particular company OPRI1MD Median value of all INT1 estimates for a company OPRITMN Mean value of all INT1 estimates for a company OPRHNE Total number of estimates associated wi
142. mber of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 CAPI2CV CAPISCV CAPIACV CAPI2DN CAPI3DN CAPIADN CAPI2D4W CAPISDAW l4D4W CAPI2DNW CAPISDNW CAPIADNW CAPI2HI CAPISHI CAPI4HI CAPI2LO CAPI3LO CAPI4LO CAPI2MD CAPI3MD CAPI4MD CAPI2MN CAPISMN CAPI4MN CAPI2NE CAPISNE CAPI4NE CAPI2SD CAPISSD CAPIASD CAPI2UP CAPISUP CAPIAUP CAPI2UAW CAPISUAW CAPIAUAW CAPI2UPW CAPISUPW CAPI4UPW CAPI2YR CAPISYR CAPIAYR Page 86 of 142 Cash Earnings Per Share CSHI1CV CSHH DN CSHI1D4W CSHI1DNW CSHHHI CSHHLO CSHHMD CSHHMN CSHHNE CSHI1SD CSHI1UP CSHI1U4W CSHI1UPW CSHI1YR e Coefficient of variation of all the
143. mnemonic for the reported interim EPS for the interim period before that represented by IP1EPS the period two before INTO that is INT 2 Available mnemonics for other interim periods are listed in the Mnemonics for other interim periods column Descriptions are consistent across all periods for INTO substitute 1 INT 2 or INT 3 in the descriptions given below IOEPS Latest reported interim EPS amp 2 EPSIOYR e The end date of the fiscal period for the last reported EPSIP1YR EPSIP2YR and interim EPS figure INTO EPSIP3YR 0 Returned in either American MM DD YY use IOYR or European DD MM YY use IOEYR format Restated Actuals The following data types enable the retrieval of actual revisions within the mean that have been restated after the initial actuals have been announced Further restated data types can be viewed under the Additional Measures section of this guide Annual data types ROEPS Restated Annual EPS 2 Quarterly data types RIEPS Restated Interim EPS RI1EPS RI2EPS RISEPS RI4EPS 5 ON DATASTREAM User Guide Page 27 of 142 Version 5 0 Chapter 6 Additional measures A number of additional measures are available for 5 fiscal years plus the last reported values where available The table below indicates the measures that are available for each region Please see the glossary for full details of these m
144. monthly production days 16 November 14 December The weekly and daily latest values are not stored historically but overwritten when a subsequent weekly value daily change or the monthly production value is received equest completed Project l B E 5 ON DATASTREAM User Guide Page 16 of 142 Version 5 0 Requesting monthly data at different dates Continuing to look at Marks and Spencer as above if on January 24 you request the data for display on a monthly frequency Datastream takes the data for this current date January 24 and then values from the 24th day of each preceding month so that you will see the following values January 38 99 December 38 84 November 38 75 Requesting the same data on January 1 Datastream takes data for the current date of 1st February and then data for the 1st of each preceding month so that you will see the following values January 38 84 December 38 75 November 37 73 This gives the appearance of the data being retrieved as one month late due to the shift on the previous month s value To ensure that monthly data is always displayed under the same month as the I B E S production date you must specify a START DATE which should be later than the 20th of the month and before the end of the month To ensure that monthly data is always displayed in line with the 5 production cycle ignoring the weekly update you must specify an START DATE of the 20th of the month The data displa
145. multiplying the last quarterly dividend declared by four plus recurring extra or special year end dividends The Annualized dividend rate has empirical validity for a company that pays a consistent amount regularly A composite forecast of earnings per share that distils all available Current EPS estimate data for the specified fiscal time period into a single expectation Gains from combining security analysts forecasts arise from using more information in the aggregate than is used by any individual and from the reduction of individual analysts forecasts error through diversification The Average EPS estimate is commonly known as the consensus forecast It is calculated by the adding the Current EPS estimate data for the specified fiscal time period from all Contributing Firms and dividing this figure by the number of EPS estimats that enter into the calculation The Adjusted Funds from Operations AFFO of a Real Estate Investment Trust REIT though subject to varying methods of computation is generally equal to the trust s funds from operations FFO with adjustments made for recurring capital expenditures used to maintain the quality of the REIT s underlying assets Thomson Reuters will consider Funds Available for Distribution FAD Cash Available for Distribution CAD and Adjusted Funds from Operations AFFO to be used interchangeably Book Value Per Share is the net asset value of a company s securities expressed in per share
146. n e Calculated according to the equation CV PRR1SD Absolute value of PRR1MN 100 Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Reported Pre tax Profits Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for pre tax profits for year ending Forecast Reported Pre tax Profits mean for estimate with year ending Time Series Reported Pre tax Profits mean for estimate with year ending Static Reported Pre tax Profits median for estimate with year ending Static Reported Pre tax Profits standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 PRR2MN PRR3MN PRR4MN PRR5MN PRR2D PRRSD PRR4D PRRSD PRR2CV PRR3CV PRR4CV PRR5CV PRR2HI PRR3HI PRR4HI PRR2LO PRR3LO PRR4LO PRR5LO PRR2MD PRR4MD PRR5MD PRR2SD PRR3SD PRR4SD PRR5SD PRR2DN PRR4DN PRR5DN PRR2DNW PRR38DNW PRR4DNW PRR5DNW Page 72 of 142 PRR1DNAW PRR1UP PRR1UPW PRR1UPAW 1 PRR1XD
147. n High Low Im Chg Est Up Down Flash Mn PER 39 92 40 54 33 30 045 22 2 1 39 16 17 89 43 33 46 50 37 60 0 66 23 2 43 71 16 08 48 20 54 00 37 70 TAS he 2 1 14 45 12 40 15 00 29 36 0 90 0 02 ForLTG read Median instead of Mean Mean Earnings Forecasts amp Price 45 25 JASONDJFMAMJ J ASON DJ FY41 MEAN FY2 MEAN PRICE IBESX R H SCALE Reference Data Actual Earnings Annual EPS 03 06 31 40 Last4 09 06 03 06 03 05 06 04 Int EPS Growth Rates 95 FYO FY1 23 96 FY1 FY2 141 341 Historic 18 12 Market Data Price 696 50 96 Chg 1 mth 0 43 Shares millions 1688 23 Market Cap millions 1175855 00 Annual Dividend 17 22 Dividend Yield 96 247 Source Thomson Datastrea Ready The Overview tear sheet gives an overview of basic I B E S earnings estimates for a company Momentum Datastream Advance Data Category E Datastream series Equities Equity indices Unit trusts Investment trusts Bonds amp convertibles Bond indices amp CDS Economics Exchange rates Interest rates Commodities Derivatives Constituent lists User created Analysis El Single Series Overview Overview of Company Performance Overview of any Series E Forecast Overview EPS Growth Data Momentum Data Stock Valuation Data Analyst Sponsorship Data Analyst Agreement Data Median Data E homson ONE browser pages Multipl
148. n on the Thursday preceding the third Friday of every month at close of business in New York Weekly and daily updates are available but note that only a small proportion of stocks will have a change on any given day All stocks will have a value applied on a weekly basis based on Thursday data Daily updates are available only if there was a change made to one of its values other than price on the previous day If no change has been made the latest data available will be for the previous Thursday No history of weekly or daily updates is available The 5 database is updated the next business day by approximately 0900 hrs GMT Weekly data is updated over the weekend available to view on Datastream on the Monday Obtaining monthly I B E S values on the Datastream research service Below example clarifies the storage of monthly values It shows a Time Series Analysis program output screen for Marks amp Spencer Group data type EPS1 mean earnings per share for the next fiscal year Datastream Advance Data Category From 3M To 00 Series El Datastream series 20 C ASY C AY C sy C av Equities No Equity indices Datatype JEPS Mean Estimate FY1 zl Search n Datatype C ov C 6M G 3M C Base Unit trusts Investment trusts Name e MKS MKS Currency Currency x Eg Bonds amp convertibles Bond indices amp CDS E Economics Actual Values 104 from Start Date MARKS amp
149. ndard deviation e Calculated according to the equation CV FCF1SD Absolute value of FCF1MN 100 Restated reported Free Cash Flow Per Share Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Free Cash Flow Per Share Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Free Cash Flow Per Share for year ending m Forecast Free Cash Flow Per Share mean for estimate with year ending Time Series Free Cash Flow Per Share mean for estimate with year ending Static Free Cash Flow Per Share median for estimate with year ending Static Free Cash Flow Per Share standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values ON DATASTREAM User Guide Version 5 0 FCF2MN FCF3MN FCFAMN FCFAMN FCF2D FCF3D FCF4D FCF5D FCF2CV FCF3CV FCF4CV FCF5CV FCF2HI FCF3HI FCF4HI FCF2LO FCF3LO FCF4LO FCF5LO FCF2MD FCF3MD FCF4MD FCF5MD FCF2SD FCF3SD FCF4SD FCF5SD FCF2DN FCF3DN FCF4DN FCF5DN Page 52 of 142 FCF1DNW FCF1DNAW FCF1UP FCF1UPW FCF1UPAW FCF1NET FCF1XD FCF1XDW FCF1XD4W FCF1XU F
150. nically determined forecast of earnings per share for the specified fiscal time period based on the assumption that the future is a simple extension of the past It is calculated by fitting a least squares growth line to the logarithms of the 20 most quarterly observations of last twelve month EPS The Trend Line EPS Forecast is given by extrapolating the derived growth line to the end of the specified fiscal time period A measure of earnings surprise that shows the amount by which the latest announcement of earnings per share for the Company was better or worse than expected Unanticipated EPS is derived by comparing the latest Interim EPS to the Final Average EPS Estimate for the interim period Absolute surprise is calculated by taking the mathematical difference between the two data items Relative surprise is calculated as the percentage difference between the two data items A third gauge called the Standardized Unanticipated Earnings SUE Score is calculated as the ratio of absolute surprise to Estimate Dispersion The SUE score measures the number of standard deviations the actual reported earnings that differ from the 5 surprise mean estimates for a company for the fiscal period indicated SUE can be used to make probability statements about the likelihood of that particular result occurring The SUE score is calculated as follows _ Actual EPS Surprise mean EPS S tan dard deviation SUE A measure of optimisti
151. ns Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Adjusted Funds From Operations for year ending Forecast Adjusted Funds From Operations mean for estimate with year ending Time Series Adjusted Funds From Operations mean for estimate with year ending Static Adjusted Funds From Operations median for estimate with year ending Static Adjusted Funds From Operations standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 AFO2MN AFO3MN AFO4MN AFO2D AFO4D AF05D AFO2CV AFO4CV AFO5CV AFO2HI AFO4HI AFO2LO AFO4LO AFO5LO AFO2MD AFO3MD AFO4MD AFO5MD AFO2SD AFO3SD AFO4SD AFO5SD AFO2DN AFO4DN AFO5DN AFO2DNW AFO3DNW AFO4DNW AFOSDNW Page 30 of 142 AFO1DNAW AFO1UP AFO1UPW AFO1UPAW AFO1NET AFO1XD AFO1XDW AFO1XD4W AFO1XU AFO1XUW AFO1XU4W AFO1NE forecast Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly
152. ny expenses in the estimate have been excluded Total number of estimates associated with the interim forecast that have included expenses in their estimates Total number of estimates associated with the interim forecast that have excluded expenses in their estimates EPS2NE E EPS3NE E EPSANE E 5 EPS2NE X EPS3NE X EPS4NE X EPS5NE X OBASE2 OBASE4 OBASE5 2 OBASEN4 5 EPSI2MN E EPSI3MN E EPSIAMN E EPSI2MN X EPSISMN X EPSIAMN X EPSI2NE E EPSISNE E EPSIANE E EPSI2NE X EPSISNE X EPSIANE X B E S ON DATASTREAM User Guide Version 5 0 Page 21 of 142 Chapter 5 EPS data types The mnemonics listed in the first column of this table are for fiscal year 1 data types For other fiscal years change the 1 to a 2 3 4 or 5 For example F3CV is the mnemonic for the coefficient of variation of all the FY3 estimates Available mnemonics for other fiscal years are listed in the Mnemonics for other fiscal years column Descriptions are consistent across all fiscal years for FY1 substitute FY2 FY3 FY4 or FY5 in the descriptions given below Description Mnemonics for other periods EPS1 EPS1D PE1 EPS1MN EPS1YR EPS1CV EPS1HI EPS1LO EPS1MD EPS1SD EPS1PER EPS1FD12 A EPS Forecast Mean earnings per share for FY1 next fiscal year end to be reported
153. of I B E S data and are designed to be used as snapshots of companies These reports are available in Datastream Advance from the Overview on a single series tab The reports display the latest values where provided l B E S ON DATASTREAM User Guide Page 9 of 142 Version 5 0 Overview atastream Advance B Data Category E Datastream series Equities Equity indices Unit trusts Investment trusts Bonds amp convertibles Bond indices amp CDS Economics Exchange rates Interest rates Commodities Derivatives Constituent lists User created E Single Series Overview Overview of Company Performance Overview of any Series EIIB E S Forecast Overview EPS Growth Data Momentum Data Stock Valuation Data Analyst Sponsorship Data Analyst Agreement Data Median Data Thomson ONE browser pages Multiple Series Flexible Chart Single Series Chart Single Series Report Single Series Data Codes and Information Favourites Scenario Testing Equity Screening Project Equity Screening Enters I 71 Search Expert Time Period Not Applicable Datatype DEFAULT meme m Ne Name MKS MKS zov 15 107 3v Datatype 2 6M C Base Currency Not Applicable zi V B E S on Datastream VB E S Ticker MKS DS Mnemonic MKS Industry Cade MARKS amp SPENCER GROUP 10 01 07 Country Code MERCHAN Currency V B E S Basic Forecast Data Mea
154. of Thomson reuters com salesenquiry Reuters Thomson Reuters and the Thomson Reuters Read more about our products at logo are registered trademarks and trademarks of Feuterscoriprad ctinfo Thomson Reuters and its affiliated companies Uus Find out how to contact your local office reuters com contacts THOMSON REUTERS Date of issue 22 June 2010
155. of the last five years actual EPS values EPS forecasts by fiscal year Time Series In all the time series data types below ZZ is replaced by a YY date For example FO9MN gives the mean for the forecasts with a fiscal year end in 2009 Note that the F data types do not pad on Datastream This means that when downloading against a list values will only be returned for those companies that have a yearend coincidental with the date for which you are running the enquiry These data types are similar to the F1 F5 data types but are referenced by fiscal year end date and not relative fiscal year For example EPS1MN represents the mean earnings forecast for the current fiscal year e EPSO9MN represents the forecasts made for fiscal years ending in 2009 These data types are available in a time series request EPS CV e Coefficient of variation of estimates for year ending e Calculated from F SD and F MN as for other coefficient of variation data types EPS FYI e Fiscal year indicator associated with fiscal year e For example in October 2005 FOGFYI may return value of FY2 indicating that in October 05 the forecast associated with 2005 was FY2 Highest value of all estimates for year ending e The same data as EPSnHI but accessed by year end date and not data type EPS LO Lowest value of all estimates for year ending e The same data as EPSnLO but accessed by year end date and not data type
156. of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV EBD1SD Absolute value of EBD1MN 100 EBD1HI Highest value of all FY1 estimates for a company EBD1LO Lowest value of all FY1 estimates for a company EBD1MD Median value of all FY1 estimates for a company EBD1SD Standard deviation of all the FY1 estimates that make up the consensus EBD1FD12 12 month forward EBITDA Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals A EBD Actual value for EBITDA for year ending Forecast EBD MN EBITDA mean for estimate with year ending Time Series EBDE MN EBITDA mean for estimate with year ending Static EBDE MD EBITDA median for estimate with year ending Static EBDE SD EBITDA standard deviation with estimate for year ending EE Static Total Revision data types EBD1DN Number of FY1 estimates down since last monthly values EBD1DNW Number of FY1 estimates down since last weekly values ON DATASTREAM User Guide Version 5 0 EBD2MN EBDSMN EBDAMN EBD5MN EBD2D EBDSD EBD4D EBD5D EBD2CV EBD3CV EBD4CV EBD5CV EBD2HI EBD3HI EBD4HI EBD2LO EBD3LO EBD4LO EBD5LO EBD2MD EBD3MD EBD4MD EBD5MD EBD2SD EBD3SD EBD4SD EBD5SD EBD2DN EBD3DN EBD4DN EBD5DN EBD2DNW EBD3DNW EBD4DNW EBDSDNW Page 46 of 142 EBD1DNAW
157. or some non U S companies DPS is calculated after withholding taxes 5 provides both actual and expected DPS data where available A measure of pessimistic sentiment The Downward revision rate is the ratio of the number of Current EPS estimates for the specified fiscal time period that were reduced during the past month to the Number of EPS Estimates The Downward revision rate is expressed as a percentage Page 121 of 142 Earnings Before Goodwill EBG EBIT Earnings Before Interest and Taxes EBT EBITDA Earnings Before Interest Taxes Depreciation and Amortization EBD EBITDA Earnings Before Interest Taxes Depreciation and Amortization Per Share EBS Enterprise Value EVT EPS Estimate Range EPS1HI EPS1LO etc Estimate Dispersion EPS1SD Expected EPS Long Term Growth Rate LTMD Final Average EPS Estimate SURMN l B E S ON DATASTREAM User Guide Version 5 0 EBG measures a company s per share earnings before the amortization of goodwill In some countries France for example goodwill is treated as a part of ordinary income for companies and the amortized component of goodwill is added back to yield earnings before goodwill amortization This is distinguished from the EPS measure which is earnings per share that always deducts the goodwill amount and is thus an expression of per share earnings after goodwill amortization EBG is thus a corporation s net income from continuing operation
158. pany EBTHNE Total number of estimates associated with INT1 forecast EBTHSD Standard deviation of all the INT1 estimates that make up the consensus EBTHUP Number of INT1 estimates up since last monthly values EBTITUP4W Number of INT1 estimates up since the weekly values four weeks ago EBTHUPW Number of INT1 estimates up since last weekly values EBTI1YR e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced l B E S ON DATASTREAM User Guide Version 5 0 EBTI2CV EBTI4CV EBTI2DN EBTI3DN EBTI4DN EBTI2D4W EBTISDAW EBTI4D4W EBTI2DNW EBTISDNW EBTI4DNW EBTI2HI EBTI4HI EBTI2LO EBTISLO EBTI4LO EBTI2MD EBTISMD EBTIAMD EBTI2MN EBTISMN EBTIAMN EBTI2NE EBTISNE EBTIANE EBTI2SD EBTISSD EBTIASD EBTI2UP EBTISUP EBTIAUP EBTI2UPAW EBTISUPAW EBTIAUPAW EBTI2UPW EBTISUPW EBTI4UPW EBTI2YR EBTISYR EBTI4YR Page 91 of 142 Earnings Before Interest Taxes Depreciation and Amortization EBDHCV EBDI1DN EBDI1D4W EBDI1DNW EBDI1HI EBDHLO EBDHMD EBDHMN EBDHNE EBDHSD EBDHUP EBDI1UP4W EBDI1UPW EBDI1YR e Coefficient of variation of all the INT1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I1 SD Absolute value of 11MN 100 Number of INT1 estimates down since last monthly values Number of
159. r per share for year ending Forecast mean for estimate with year ending Time Series EBG mean for estimate with year ending Static median for estimate with year ending Static EBG standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values Number of FY1 estimates down since the weekly values four weeks ago ON DATASTREAM User Guide Version 5 0 EBG2MN EBG3MN EBG4MN EBG5MN EBG2D EBG3D EBG4D ENG5D EBG2CV EBG3CV EBG4CV EBG5CV EBG2HI EBG3HI EBG4HI EBG5HI EBG2LO EBG3LO EBG4LO EBG5LO EBG2MD EBG3MD EBG4MD EBG5MD EBG2SD EBG3SD EBG4SD EBG5SD EBG2DN EBG3DN EBG4DN EBG5DN EBG2DNW EBG3DNW EBG4DNW EBGSDNW EBG2DN4W EBG3DN4W EBG4DN4W EBG5DN5W Page 42 of 142 EBG1UP EBG1UPW EBG1UPAW EBG1NET EBG1XD EBG1XDW EBG1XD4W EBG1XU EBG1XUW EBG1XU4W EBG1NE Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in
160. r Safe a iot itd ee a cese eee ec tet cts ptu ea 88 Dividends Per Share ga u ee reo reser mede ene e uet leaden ede Even CE aep EU Cb v 89 Earnings Before Goodwill m e tetuer sete 90 Earnings Before Interest and 444400 nennen nennen enses 91 Earnings Before Interest Taxes Depreciation and Amortization 92 Earnings Before Interest Taxes Depreciation and Amortization Per Share 93 Enterprise Values ven S TEN t e d co t d cpu 94 Free Gash Flow Per Slalom timete tetigit tet Hi er eo Ite e 95 Funds From ODperall ris test dee cete eL aq hapa 96 GAAP Earnings Per Share cores Qi eee tea pee te ernie ed 97 Gross 98 INet Asset Value 99 Net Debt Ncc c M 100 Netlhcome cbr OU d E E RD E 101 Reported Net INCOME MEER 102 Operating 103 E 104 105 on ASS OTS a 106 Return EQUILY 107 108 Tangible Book Value per
161. r Share for FY1 Fiscal Year End for TBV1MN Last Reported Tangible Book Value per Share Fiscal Year End for FOTBV e Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV TBV1SD Absolute value of TBV1MN 100 Restated reported Tangible Book Value per Share Highest value of all FY1 estimates for a company Lowest value of all FY1 estimates for a company Median value of all FY1 estimates for a company Standard deviation of all the FY1 estimates that make up the consensus 12 month forward Tangible Book Value per Share Estimates and Actuals on a calendar year basis Where is replaced by an YY date Actuals Actual value for Tangible Book Value per Share for year ending HP Forecast Tangible Book value mean for estimate with year ending Time Series Tangible Book value mean for estimate with year ending Static Tangible Book value median for estimate with year ending Static Tangible Book value standard deviation with estimate for year ending Static Total Revision data types Number of FY1 estimates down since last monthly values ON DATASTREAM User Guide Version 5 0 TBV2MN TBV3MN TBV4MN TBVSMN TBV2D TBV3D TBV4D TBV5D TBV2CV TBV3CV TBV4CV TBV5CV TBV2HI TBV3HI TBV4HI TBV5HI TBV2LO TBV3LO TBV4LO TBV5LO TBV2MD
162. r of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 PRE2DN4W PRESDNAW PRE4DN4W PRESDNSW PRE2UP PRE4UP PRESUP PRE2UPW PRE3UPW PRE4UPW PRESUPW PRE2UPAW PRESUPAW PRE4UP4W PRESUP4W PRE2NET PRESNET PRE4NET PRESNET PRE2XD PRESXD PRE4XD PRE5XD PRE2XDW PRE3XDW PRE4XDW PRESXDW PRE2XD4W PRE3XD4W PRE4XD4W PRE5XDAW PRE2XU PRE3XU PRE4XU PRE5XU PRE2XUW PRE3XUW PRE4XUW PRESXUW PRE2XU4W PRE3XU4W PRE5XU4W PRE2NE PRESNE PRE4NE PRESNE Page 71 of 142 Reported Pre tax Profits PRR PRR1MN PRR1D FOPRR PRROYR ROPRR PRR1CV PRR1HI PRR1LO PRR1MD PRR1SD PRR1FD12 A PRR PRR MN PRRE MN PRRE MD PRRE SD PRR1DN PRR1DNW Mean Reported Pre tax Profits for FY1 Fiscal Year End for PRR1MN Last Reported Reported Pre tax Profits Fiscal Year End for FOPRR Restated reported Pre tax Profits Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviatio
163. raordinary versus exceptional items bringing many formerly extraneous items above the net income line I B E S provides both expected and actual net income data where available The net income earned after deducting all expenses including operating and non operating interest expense and income and taxation It is inclusive of all amortization and one time charges Also referred to as Net Profit Reported The accounting period of 12 months that follows the Current fiscal year for the Company The end date of a company s Next fiscal year is expressed as month year The total number of estimates for a company for the specified time period Page 126 of 142 Number of Estimates Lowered Number of Estimates Raised Number of Shares Held IBNOSH Operating Profit OPR Option Expenses Parent Company Earnings Per Share PNTCON Pre Tax Profit PRE Reported Pre Tax Profit PRR Price Date IBPDTE l B E S ON DATASTREAM User Guide Version 5 0 The number of estimates that have been lowered from their previous values over the last week four weeks and month New estimates and multiple estimate changes are not counted in this sum For example if during a four week period an analyst raises their estimate from 1 50 to 1 90 and then lowers that estimate from 1 90 to 1 75 it is counted as one estimate lowered because only the immediate prior estimate is used in the calculation The number of estimates that have been
164. recast EPS2DN EPS3DN EPS4DN EPS5DN EPS2DNW EPS3DNW EPS4DNW EPSBDNW EPS2DN4W EPS3DN4W EPS4DN4W EPS5DNAW EPS2UP EPS3UP EPS4UP EPSSUP EPS2UPW EPS3UPW EPS4UPW EPSSUPW EPS2UP4W EPS3UP4W EPS4UP4W EPSSUPAW EPS2NET EPS3NET EPS4NET 55 EPS2XD EPS3XD EPS4XD EPS5XD EPS2XDW EPS3XDW EPS4XDW EPSS5XDW EPS2XD4W EPS3XD4W EPS4XD4W EPS5XD4W EPS2XU EPS3XU EPS4XU EPS5XU EPS2XUW EPS3XUW EPSAXUW EPS2XU4W EPS3XU4W EPS4XU4W EPS5XU4W EPS2NE EPS3NE EPS4NE EPS5NE l B E 5 ON DATASTREAM User Guide Version 5 0 Page 23 of 142 Quarterly EPS The mnemonics listed in the first column of this table are for the next quarterly period For other fiscal periods change the 1 to a 2 S or 4 Available mnemonics for other quarterly periods are listed in the Mnemonics for other quarterly period column Description Mnemonics for other quarterly periods EPSHCV EPSI1DN EPSHDNAW EPSHDNW EPSHHI EPSHLO EPSHMD EPSHMN EPSHNE EPSHSD EPSHUP EPSHUPAW EPSHUPW EPSH YR e Coefficient of variation of all the INT1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV I SD Absolute value of 11 MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1
165. retrieved using 5 06 Actuals Actuals A EPS Actual value for Earnings per share for year ending Forecast EPSEZZMN Forecast mean for Earning estimate for year ending EPSEZZMD Forecast median for Earning estimate for year ending EPSE SD Forecast standard deviation for Earning estimate for year ending Actual annual EPS The mnemonics listed in the first column of this table are for data types for the last fiscal year reported FYO For earlier fiscal years change the 0 to a P1 P2 or P3 For example FP2EPS is the mnemonic for the reported annual EPS for the fiscal year two years prior to the last one reported the year two years before FYO which is FY 2 Available mnemonics for other fiscal years are listed in the Mnemonics for other fiscal years column Descriptions are consistent across all fiscal years for FYO substitute 1 FY 2 or FY 3 in the descriptions given below FOEPS Reported annual EPS for the last fiscal year FYO EDIEPSMEP2EDSMERSERBRS EPSOYR The end date of the fiscal year for the last reported EPS EPSPTYFESEPSP YRI figure FOEPS EPSPSYR 5 ON DATASTREAM User Guide Page 26 of 142 Version 5 0 Actual interim EPS The mnemonics listed in the first column of this table are for data types for the last interim period reported INTO For earlier interim periods change the 0 to a P1 P2 or For example IP2EPS is the
166. riod is re set every Thursday it will never reach five weeks The number of estimates raised and lowered are calculated in the same manner These estimates include all estimates which have been received but which may have been excluded from the mean calculations for a variety of reasons such as using different accounting rules The data types based on week on week change EPS1DNW EPS1UPW etc work in the same manner The data types based on monthly changes EPS1UP EPS1DN etc are based on the change between 5 monthly periods and are updated on a monthly basis only They are not updated on a daily basis A measure of financial performance calculated as operating cash flow minus capital expenditures Free Cash Flow FCF represents the cash that a company is able to generate after laying out the money required to maintain or expand its asset base A measure of Company profitability that shows the result of potential dilution on the computation of earnings per share amounts Common stock equivalents whose conversion exercise or contingent issuance is potentially dilutive and the Number of shares outstanding enter into the computation of Fully diluted earnings per share A Current EPS estimate is shown as a Fully diluted earnings per share amount whenever there is a need to maintain its comparability with the others for the Company A measure used by real estate and other investment trusts to define the cash flow from trust oper
167. s before goodwill amortization divided by the weighted average number of shares outstanding l B E S provides both expected and actual EBG data where available Represents the earnings of a company before interest expense and income taxes paid As such EBIT is a gauge of corporate earnings before any debt servicing to creditors including bondholders and the payment of corporate taxes It is calculated in general form by taking the pre tax corporate income of a company adding back interest expense on debt and subtracting any interest capitalized I B E S provides both expected and actual EBIT data where available Displayed in whole number terms in millions or billions dependant on domicile of country EBITDA gauges the raw earnings power of a company before debt servicing corporate taxes and any allowances made for depreciation and amortization costs the company faces It is calculated in general form by taking the pre tax corporate income of a company adding back any depreciation and amortization costs charged plus any interest expense debt subtracting any capitalized interest I B E S provides both expected and actual EBITDA data where available Displayed in whole number terms millions EBITDA per share represents EBITDA divided by the weighted average number of shares outstanding Thomson Reuters provides both expected and actual EBS data where available Enterprise Value is calculated as market capitalization plus
168. s four weeks ago AFOHDNW Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company AFOHLO Lowest value of all INT1 estimates for a particular company AFOHMD Median value of all INT1 estimates for a company AFOHMN Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast AFOI1SD Standard deviation of all the INT1 estimates that make up the consensus AFOH UP Number of INT1 estimates up since last monthly values AFOI1U4W Number of INT1 estimates up since the weekly values four weeks ago l B E S ON DATASTREAM User Guide Version 5 0 AFOI2CV BKI3CV BKI4CV AFOI2DN BKI3DN BKI4DN AFOI2D4W AFOI3D4W AFOI4D4W AFOI2DNW AFOISDNW AFOI4DNW AFOI2HI AFOI3HI AFOI4HI AFOI2LO AFOI3LO AFOI4LO AFOI2MD AFOI3MD AFOI4MD AFOI2MN AFOISMN AFOIAMN AFOI2NE BJISNE BJIANE AFOI2SD AFOISSD AFOI4SD AFOI2UP BJISUP AFOI4UP AFOI2U4W AFOI3U4W AFOI4U4W Page 84 of 142 Book Value Per Share BPSHCV BPSI1DN BPSHDAW BPSHDNW BPSI1HI BPSHLO BPSIiMD BPSHMN BPSHNE BPSHSD BPSHUP BPSHUAW e Coefficient of variation of all the INT1 estimates e Ameasure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV BPSI1SD Absolute value of BPSI1MN 100 Number of INT1 estimates down since last monthly values Number o
169. s in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast GPS2UP GPS3UP GPS4UP GPS5UP GPS2UPW GPS3UPW GPS4UPW GPSS5UPW GPS2UP4W GPS3UP4W GPS4UP4W GPS5UPAW GPS2NET GPS3NET GPSANET GPS5NET GPS2XD GPS3XD GPS4XD GPS5XD GPS2XDW GPS3XDW GPS4XDW GPS5XDW GPS2XD4W GPS3XD4W GPS4XD4W GPS5XD4W GPS2XU GPS3XU GPS4XU GPS5XU GPS2XUW GPS3XUW GPS4XUW GPSS5XUW GPS2XU4W GPS3XU4W GPS4XU4W GPS5XUAW GPS2NE GPS3NE GPS4NE GPS5NE ON DATASTREAM User Guide Version 5 0 Page 57 of 142 Gross Margin GRM GRM1MN Mean Gross Margin for FY1 GRM1D Fiscal Year End for GRM1MN FOGRM Last Reported Gross Margin GRMOYR Fiscal Year End for FOGRM ROGRM Restated reported Gross Margin GRM1CV e Coefficient of variation of all the FY1 estimates e measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV GRM1SD Absolute value of GRM1MN 100 GRM1HI Highest value of all FY1 estimates for a company GRM1LO Lowest value of all FY1 estimates for a company GRM1MD Median value of all F
170. sted for all stock splits and dividends The accounting period of less than 12 months typically quarterly or semi annually for the Company over which fiscal results are announced The previous accounting period of 12 months for which the books of the Company have been closed and its annual fiscal results already announced The earnings per share for the Company announced for the Last Fiscal Year Last fiscal year EPS is expressed in general on a primary basis excluding extraordinary items and discontinued operations and is adjusted for all stock splits and dividends The most recent transaction price Last price figures are rounded so that they can be expressed in terms of the nearest whole unit of the Currency The date on which the latest announcement of interim earnings results was made The date is expressed as day month Long Term Growth Forecasts are received directly from contributing analysts they are not calculated by 5 While different analysts apply different methodologies the Long Term Growth Forecast generally represents an expected annual increase in operating earnings over the company s next full business cycle In general these forecasts refer to a period of between three to five years Due to the variance in methodologies for Long Term Growth calculations 5 recommends the median value for Long Term Growth Forecast as opposed to the mean value The median value defined as the middle value in a de
171. t monthly values ON DATASTREAM User Guide Version 5 0 DPS2MN DPS3MN DPS4MN DPS5MN DPS2D DPS3D DPS4D DPS5D DPS2CV DPS3CV DPS4CV DPS5CV DPS2HI DPS3HI DPS4HI DPS5HI DPS2LO DPS3LO DPS4LO DPS5LO DPS2MD DPS3MD DPS4MD DPS5MD DPS2SD DPS3SD DPS4SD DPS5SD DPS2DN DPS3DN DPS4DN DPS5DN Page 40 of 142 DPS1DNW DPS1DN4W DPS1UP DPS1UPW DPS1UP4W DPS1NET DPS1XD DPS1XDW DPS1XD4W DPS1XU DPS1XUW DPS1XU4W DPS1NE Number of FY1 estimates down since last weekly values Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast DPS2DNW DPS3DNW DPS4DN
172. terms The calculation of BPS in general form involves taking the total assets of a company and subtracting all intangible assets as well as current and long term liabilities and dividing by the weighted average number of shares outstanding An aggregate number for the specified data item Because the annual accounting period is not the same for all companies a calendarisation procedure is used to enhance the comparability of the comapy data that is being aggregated Depending on the calendar month of production and the current fiscal year end date for the Company the average EPS estimate for the Current fiscal year is assigned to either the previous present following or succeeding calendar year time period Funds used by a company to acquire or upgrade physical assets such as property industrial buildings or equipment or the amount used during a particular period to acquire or improve long term assets such as property plant or equipment Cash Earnings per Share is a company s net income plus depreciation plus amortization of goodwill intangibles and prepaid assets non cash items divided by weighted or diluted number of shares outstanding Thomson Reuters provides both expected and actual CSH data where available Page 120 of 142 Cash Flow Per Share CPS Change in the current EPS estimate Coefficient of Variation EPS1CV etc Company NAME Consensus Forecast Consolidated Earnings Per Share PNTCON Coun
173. tes down since last monthly values ON DATASTREAM User Guide Version 5 0 FFO2MN FFO3MN FFO4MN FFOS5MN FFO2D FFO3D FFO4D FF05D FFO2CV FFOSCV FFO4CV FFO5CV FFO2HI FFO4HI FFOSHI FFO2LO FFO3LO FFO4LO FFO5LO FFO2MD FFO3MD FFO4MD FFO5MD FFO2SD FFOSSD FFO4SD FFO5SD FFO2DN FFO3DN FFO4DN FFO5DN Page 54 of 142 FFO1DNW FFO1DNAW FFO1UP FFO1UPW FFO1UPAW FFO1NET FFO1XD FFO1XDW FFO1XD4W FFO1XU FFO1XUW FFO1XU4W FFO1NE Number of FY1 estimates down since last weekly values Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast
174. tes to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 FCFI2CV FCFI3CV FCFI4CV FCFI2DN FCFI3DN FCFI4DN FCFI2D4W FCFI3D4W FCFI4DAW FCFI2DNW CKISDNW FCFI4DNW FCFI2HI FCFI3HI FCFI4HI FCFI2LO FCFISLO FCFI4LO FCFI2MD FCFI3MD FCFI4MD FCFI2MN FCFISMN FCFI4MN FCFI2NE FCFI3NE FCFI4NE FCFI2SD FCFI3SD FCFI4SD FCFI2UP FCFI3UP FCFI4UP FCFI2U4W FCFI3U4W FCFI4UAW FCFI2UPW FCFISUPW FCFIAUPW FCFI2YR FCFI3YR FCFI4YR Page 95 of 142 Funds From Operations FFOHCV FFOI1DN FFOHDAW FFOHDNW FFOHHI FFOHLO FFOHMD FFOHMN FFOHNE FFOHSD FFOHUP FFOHUAW FFOHUPW FFOIYR e Coefficient of variation of all the INT1 estimates e measure of the spread of the estimates in terms of the standard deviation Calculated according to the equation CV I1 SD Absolute value of 11MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the
175. tes to the quarterly period for which results are due to be announced SALI2CV SALI3CV SALI4CV SALI2DN SALI3DN SALI4DN SALI2D4W SALISDAW SALI4D4W SALI2DNW SALISDNW SALI4DNW SALI2HI SALISHI SALI4HI SALI2LO SALISLO SALI4LO SALI2MD SALI3MD SALI4MD SALI2MN SALISMN SALI4MN SALI2NE SALI3NE SALI4NE SALI2SD SALI3SD SALI4SD SALI2UP SALISUP SALI4UP SALI2UAW SALISUAW SALI4U4W SALI2UPW SALISUPW SALIAUPW SALI2YR SALISYR SALIAYR ON DATASTREAM User Guide Version 5 0 Page 108 of 142 Tangible Book Value per Share TBVI1CV TBVI1DN TBVI1D4W TBVI1DNW TBVI1HI TBVI1LO TBVH MD TBVH MN TBVHNE TBVHSD TBVHUP TBVHUAW TBVHUPW e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV TBVH SD Absolute value of TBVI1MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of a
176. th INT1 forecast OPRHSD Standard deviation of all the INT1 estimates that make up the consensus OPRHUP Number of INT1 estimates up since last monthly values OPRHUAW Number of INT1 estimates up since the weekly values four weeks ago OPRHUPW Number of INT1 estimates up since last weekly values OPRI1YR e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced l B E S ON DATASTREAM User Guide Version 5 0 OPRI2CV OPRISCV OPRI4CV OPRI2DN OPRI3DN OPRI4DN OPRI2D4W OPRISDAW I4DAW OPRI2DNW OPRISDNW OPRI4DNW OPRI2HI OPRI3HI OPRI4HI OPRI2LO OPRI3LO OPRI4LO OPRI2MD OPRI3MD OPRI4MD OPRI2MN OPRISMN OPRI4MN OPRI2NE OPRISNE OPRI4NE OPRI2SD OPRISSD OPRI4SD OPRI2UP OPRI3UP OPRI4UP OPRI2U4W OPRISUAW OPRI4U4W OPRI2UPW OPRI3UPW OPRI4UPW OPRI2YR OPRISYR OPRI4YR Page 103 of 142 Pre Tax Profit PREI CV PREHDAW PREHDNW PREI1HI PREHLO PREHMD PREHNE PREHSD PREHUP PREHUAW PREHUPW PREI YR e Coefficient of variation of all the INT1 estimates e A measure of the spread of the estimates in terms of the standard deviation Calculated according to the equation CV I1 SD Absolute value of 11MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since
177. the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 EBG2UP EBG3UP EBG4UP EBG5UP EBG2UPW EBG3UPW EBG4UPW EBGSUPW EBG2UP4W EBG3UP4W EBG4UP4W EBG5UPAW EBG2NET EBG3NET EBG4NET EBGSNET EBG2XD EBG3XD EBG4XD EBG5XD EBG2XDW EBG3XDW EBG4XDW EBG5XDW EBG2XD4W EBG3XD4W EBG4XD4W EBG5XD4W EBG2XU EBG3XU EBG4XU EBG5XU EBG2XUW EBG3XUW EBG4XUW EBG5XUW EBG2XU4W EBG3XU4W EBG4XU4W EBG5XUAW EBG2NE EBG3NE EBG4NE EBG5NE Page 43 of 142 EBIT Earnings Before Interest and Taxes EBT1MN Mean EBIT for FY1 EBT1D Fiscal Year End for EBT1MN FOEBT Last Reported EBIT EBTOYR Fiscal Year End for FOEBT EBT1CV Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV EBT1SD Absolute value of EBT1MN 100 ROEBT Restated reported EBIT Highest value of all FY1 estimates for a company EBT1LO Lowest value of all FY1 estimates for a company EBT1MD Median value of all FY1 esti
178. timates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Pre tax Profit Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Reported Pre tax Profit Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Return On Assets Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Return On Equity Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Sales Mean of all FY1 estimates received in the last four weeks Total number of FY1 estimates received in the last four weeks Standard deviation of all the FY1 estimates received in the last four weeks Tangible Book Value Per Share ON DATASTREAM User Guide Version 5 0 OPR2FMN OPRI1FMN OPRI2FMN OPR2FNE OPRI1FNE OPRI2FNE OPR2FSD OPRI1FSD OPRI2FSD PRE2FMN PREI1FMN PREI2FMN PRE2FNE PREHFNE PREI2FNE PRE2FSD
179. troduced in 1971 as a tool for investors in U S markets 5 has expanded to 22 000 companies in more than 80 countries I B E S collects earnings estimates from analysts associated with 1 200 research firms globally l B E S on Datastream what is available Datastream Premium Package subscribers will be able to access current 5 data 18 months covering all 28 measures at no additional cost to the base package Available Measures Users will have access to 28 measures for multiple fiscal years including EPS sales and net income A full list of available measures is listed below Earnings Per Share EPS GAAP Earnings Per Share GPS Earnings Before Goodwill EBG Cash Flow Per Share CPS Book Value Per Share BPS Cash Earnings Per Share CSH Dividend Per Share DPS Funds From Operations FFO Long Term Growth LTG Target Price PTG Return on Equity ROE Return on Assets ROA Gross Margin GRM Adjusted Funds From Operations AFO Reported Net Income NER Tangible Book Value Per Share TBV Revenue SAL Earnings Before Interest Taxes Depreciation and Amortization EBD Earnings Before Interest Taxes Depreciation and Amortization per share EBS Net Income INC Earnings Before Interest and Taxes EBT Operating Profit OPR Profit Before Taxes PRE Net Debt NDT Net Asset Value NAV Enterprise Value EVT Capital Expenditure CAP Recommendations 12 month forward Free Cash
180. try IBCTRY Currency IBCUR Current Fiscal Year EPS1YR Dilution Factor DILFCT Dividends Per Share DPS Downward Revision Rate l B E S ON DATASTREAM User Guide Version 5 0 A corporation s cash flow from operations before investing and financing divided by the weighted average number of common shares outstanding for the year Investing includes the sale or purchase of land factories buildings etc Financing includes dividend payments loan proceeds and sale of stock 5 expects to provide both actual and expected CPS data where available The difference between the Current EPS estimate for the specified fiscal time period and the amount for the data item on the previous month s production date A measure of the relative scatter about the Average EPS Estimate in the values for the Current EPS estimates for the specified fiscal time period For a Company it is the ratio of Estimate Dispersion to the Average EPS estimate The generalised form of the equation used to calculate the coefficient of variation is Coefficient of variation Standard deviation Absolute value of mean 100 The name of the individual firm that is the issuer of the equity security contained in the B E S database See Average EPS Estimate A measure of profitability of a group of affiliated corporations that treats the group as a single unit The net income from operations of the parent Company of subsidiaries and of firms
181. type C 2Y C 6M G 3M Base Unit trusts Investment trusts Name MKS MKS Currency Local Currency Bonds amp convertibles Bond indices amp CDS E Economics DATASTRE AM EQUITIES 12 01 07 9 48 Exchange rates MARKS amp SPENCER GROUP Interest rates Mnemonic MKS Geography Code UK Industry Group BDRET Local Code 3127489 Exchange London Sector GHRET Commodities 19 Derivatives Current Price 689 50 09 32 12 Mth Range High 736 50 4 1 07 Low 480 75 24 1 06 12mth 40 9 Fin Yr LocStd 1mth 1 1 Price Change El Single Series Overview Overview of Company Performar Dividend Rate Relative to FT ALLSH 2 5 Dividend Yield Overview of any Series 26 896 S E I B E 5 i Forecast Overview EPS Growth Data Dividend Cover 11639 85M Div Last Fin Year Last Div P aid INT 6 30 Pay Date 12 01 07 XD Date 1541 06 Market Value Price and Index rebased Momentum Data e Stock valuation Data Pre Tax Prof Publ EPS Analyst Sponsorship Data CashEPS Analyst Agreement Data Mktto Bk Val Median Data ROE 95 Thomson ONE browser pages No Shares Issue 1688158 000s Multiple Series Flexible Chart ites dos 21781 ur Single Series Chart Single Series Report
182. uide Version 5 0 EBS2MN EBS3MN EBS4MN EBS4MN EBS2D EBS3D EBS4D EBS5D EBS2CV EBS3CV EBS4CV EBS5CV EBS2HI EBS3HI EBS4HI EBS5HI EBS2LO EBS3LO EBS4LO EBS5LO EBS2MD EBS3MD EBS4MD EBS5MD EBS2SD EBS3SD EBS4SD EBS5SD Page 48 of 142 EBS1DN EBS1DNW EBS1DN4W EBS1UP EBS1UPW EBS1UPAW EBS1NET EBS1XD EBS1XDW EBS1XD4W EBS1XU EBS1XUW EBS1XU4W EBS1NE Number of FY1 estimates down since last monthly values Number of FY1 estimates down since last weekly values Number of FY1 estimates down since the weekly values four weeks ago Number of FY1 estimates up since last monthly values Number of FY1 estimates up since last weekly values Number of FY1 estimates up since the weekly values four weeks ago Total number of estimates including those excluded from the Mean associated with FY1 forecast Revision data types within the mean Number of FY1 estimates in the mean down since last monthly values Number of FY1 estimates in the mean down since last weekly values Number of FY1 estimates in the mean down since the weekly values four weeks ago Number of FY1 estimates in the mean up since last monthly values Number of FY1 estimates in the mean up since last weekly values Number of FY1 estimates in the mean up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Vers
183. uity Screening Request completed The momentum tear sheet gives an indication of earnings estimate direction over set periods I B E S ON DATASTREAM User Guide Version 5 0 Page 10 of 142 Stock Evaluation Datastream Advance FET x File Edit view Tool B M 2 m EB 4 ms 25 MKS 1 8 E 5 Stock Valuatio gt Data Category Enter us Search v Expert Time period Not Applicable Settings Series Datastream series 20 15 10 5Y Equities No x Equity indices Datatype gt M Datatype 2 Base Unit trusts MKS MKS Currency Not Applicable 71 Investment trusts Bonds amp convertibles Bond indices amp CDS E Economics Exchange rates Interest rates Commodities Derivatives on Datastream 3 11 01 07 MARKS amp SPENCER GROUP I B E S Ticker MKS Country Code EX DS Mnemonic MKS Industry Code MERCHAN Currency BPN WBE Valuation PER Based Historical PER Mean High Low 3Mth Mth 1Yr Analysis 16 96 20 65 15 97 14 93 16 40 14 78 18 28 14 57 13 65 14 56 12 73 18 24 13 49 12 95 13 53 12 30 20 28 14 53 14 46 12 42 El Single Series Overview ooo Overview of Company Performance Overview of any Series Mean Annual EP S 03 06 31 40 LTG 1 INT2 INT3 INT4 Annual PER 21 89 76 09 interim EPS 09 06 amp I
184. ulated according to the equation CV PRRI1SD Absolute value of PRRI1MN 100 Number of INT1 estimates down since last monthly values Number of INT1 estimates down since the weekly values four weeks ago Number of INT1 estimates down since last weekly values Highest value of all INT1 estimates for a particular company Lowest value of all INT1 estimates for a particular company Median value of all INT1 estimates for a company Mean value of all INT1 estimates for a company Total number of estimates associated with INT1 forecast Standard deviation of all the INT1 estimates that make up the consensus Number of INT1 estimates up since last monthly values Number of INT1 estimates up since the weekly values four weeks ago Number of INT1 estimates up since last weekly values e End date of quarterly period 1 INT1 e Relates to the quarterly period for which results are due to be announced ON DATASTREAM User Guide Version 5 0 PRRI2CV PRRI3CV PRRI4CV PRRI2DN PRRISDN PRRI4DN PRRI2D4W PRRISDAW PRRI4D4W PRRI2DNW PRRISDNW PRRI4DNW PRRI2HI PRRISHI PRRI4HI PRRI2LO PRRI3LO PRRI4LO PRRI2MD PRRISMD PRRI4MD PRRI2MN PRRI3MN PRRI4MN PRRI2NE PRRI3NE PRRI4NE PRRI2SD PRRISSD PRRIASD PRRI2UP PRRISUP PRRI4UP PRRI2U4W PRRISUAW PRRI4U4W PRRI2UPW PRRISUPW PRRIAUPW PRRI2YR PRRISYR PRRIAYR Page 105 of 142 Return on Assets ROAI1CV e Coefficient of variation of a
185. up since the weekly values four weeks ago Total number of estimates in the mean associated with FY1 forecast ON DATASTREAM User Guide Version 5 0 CAP2DNAW CAP3DN4W CAP4DN4W CAP5DN4W CAP2UP CAP3UP CAP4UP CAP5UP CAP2UPW CAP3UPW CAP4UPW CAP5UPW CAP2UP4W CAP3UP4W CAP4UP4W CAP5UP4W CAP2NET CAP3NET CAP4NET CAP5NET CAP2XD CAP3XD CAP4XD CAP5XD CAP2XDW CAP3XDW CAP4XDW CAP5XDW CAP2XD4W CAP3XD4W CAP4XD4W CAP5XD4W CAP2XU CAP3XU CAP4XU CAP5XU CAP2XUW CAP3XUW CAP4XUW CAP5XUW CAP2XU4W CAP3XU4W CAP5XU4W CAP2NE CAP3NE CAP4NE CAP5NE Page 35 of 142 Cash Earnings per Share CSH CSH1MN CSH1D FOCSH CSHOYR CSH1CV ROCSH CSH1HI CSH1LO CSH1MD CSH1SD CSH1FD12 A CSH CSH MN CSHE MN CSHE MD CSHE SD CSH1DN CSH1DNW Mean Cash Earnings Per Share for FY1 Fiscal Year End for CSH1MN Last Reported Cash Earnings Per Share Fiscal Year End for FOCSH Coefficient of variation of all the FY1 estimates e A measure of the spread of the estimates in terms of the standard deviation e Calculated according to the equation CV CSH1SD Absolute value of CSH1MN 100 Restated reported Cash Earnings Per Share Highest value of all FY1 estimates for a Company Lowest value of all FY1 estimates for a Company Median value of all FY1 estimates for a Company Standard deviation of all the FY1 estimates that make up the consensus
186. yed will then be identical with that shown by other I B E S historical products Dummy Mnemonics to display the latest daily weekly and monthly values A series has been set up to display the date of the last daily weekly and monthly values for both summary and aggregates These mnemonics should be used in conjunction with the TIME data type IDCT 31449W Date of last daily updated IBES summary value IBWT 31449X Date of last weekly updated IBES summary value IMCT 31450D Date of last monthly updated IBES summary value IAMT 31450F Date of last monthly updated IBES aggr value I B E S ON DATASTREAM User Guide Page 17 of 142 Version 5 0 Chapter 3 Company related items IBCTRY e Country of security e The country where the corporate headquarters of the company is located IBCUR e Currency of estimates IBCTRY e The 5 code for the currency in which estimates are provided e BCUR is the ISO code in most cases IBGRP e Group code for the company IBSCT IBIND e A subset of an industry Code assignment and classification are made by I B E S IBIND e Industry code for the company IBGRP IBSCT e Anindustry is a collection of companies with similar business lines Code assignment and classification are made by 5 IBSCT e Stock sector code for the company IBGRP IBIND e Major subset of the market from a collection of similar industries Code assignment and classification are made by I B E S IBTKR e Ticker NAME

User Guide - Department of Financial Management and Capital

Contents

Download Pdf Manuals

Related Search

Related Contents