Worldscope

Worldscope

Last updated: 4/26/05

Provides standardized financial statement data, calculated ratios, weekly and monthly market price data, extensive per share data, security and market data, product and geographic segment data, and textual profile data on quoted companies worldwide. Four major templates are offered - Industrial, Insurance, Banks and Other Financial - to facilitate comparisons between companies and industries within and across national boundaries. Active coverage represents approximately 95% of global market capitalization.

Overview

Source Name: WS4

Update Frequency: Daily (M-F) by 9a

Supported Symbols: Ticker, CUSIP, SEDOL, ISIN

Permissioning: Dataworks Enterprise login required

Request Syntax

TICKER=XXX SEDOL=XXX ISIN=XXX CUSIP=XXXX (in any combination)

Note: ticker is not advised to be used alone as duplicate tickers are possible. To make sure you are getting the right company, please use a unique identifier such as CUSIP, SEDOL or ISIN.

Examples:

TICKER=MSFT

TICKER=AOL SEDOL= 2588173

CUSIP=594918104 ISN=US00184A1051 SEDOL= 2588173

TICKER=AOL ISN= US5949181045

CUSIP=00184A105 SEDOL=2712165

Sample Response

Please note that the output below is a small sample cut from the overall response. So it doesnt provide all items that came back in the response.

- <Record xmlns="http://xml.thomson.com/financial/v1/tools/distribution/dataworks/enterprise/2003-07/">

<Instrument>TICKER=MSFT</Instrument>

<Tag />

<StatusType>Connected</StatusType>

- <Fields>

<AccountsPayable-1Y>1573</AccountsPayable-1Y>

<AccountsPayable-2Y>1208</AccountsPayable-2Y>

<AccountsPayable-3Y>1188</AccountsPayable-3Y>

<AccountsPayable-4Y>1083</AccountsPayable-4Y>

<AccountsPayable-5Y>874</AccountsPayable-5Y>

<AccountsPayable-6Y>759</AccountsPayable-6Y>

<AccountsPayable-7Y>721</AccountsPayable-7Y>

<AccountsPayable-8Y>808</AccountsPayable-8Y>

<AccountsPayable-9Y>563</AccountsPayable-9Y>

<AccountsReceivableDays-1Y>57.7407</AccountsReceivableDays-1Y>

<AccountsReceivableDays-2Y>55.84347</AccountsReceivableDays-2Y>

<AccountsReceivableDays-3Y>49.2481</AccountsReceivableDays-3Y>

<AccountsReceivableDays-4Y>43.08677</AccountsReceivableDays-4Y>

<AccumulatedDepreciation-1Y>3855</AccumulatedDepreciation-1Y>

<AccumulatedDepreciation-2Y>3623</AccumulatedDepreciation-2Y>

<AccumulatedDepreciation-3Y>2966</AccumulatedDepreciation-3Y>

<AccumulatedDepreciation-4Y>2411</AccumulatedDepreciation-4Y>

<AddressCity>Redmond</AddressCity>

<AddressCountry>UNITED STATES</AddressCountry>

<AddressStateProvince>WASHINGTON</AddressStateProvince>

<AddressStreet>One Microsoft Way</AddressStreet>

<AdjustmentFactor-1Y>1</AdjustmentFactor-1Y>

<AdjustmentFactor-2Y>2</AdjustmentFactor-2Y>

<AdjustmentFactor-3Y>2</AdjustmentFactor-3Y>

<AdjustmentFactor-4Y>2</AdjustmentFactor-4Y>

<BusinessDescription>Client acctd for 31% of fis 2004 revs; Info Worker, 29%; Server & Tools, 23%; Home & Ent, 8%; MSN, 6% & Bus Solution & Other, 3%</BusinessDescription>

<BusinessDescriptionExtended>Microsoft Corporation. The Group's principal activity is to develop, manufacture, license and support a wide range of software products for a multitude of computing devices. The software products include scalable operating systems for servers, personal computers and intelligent devices; server applications for client or server environments; information worker productivity applications; business solutions applications and software development tools. The Group also provides consulting and product support services. The Group trains and certifies system integrators and developers. The Group sells the Xbox video game console and games, PC games and peripherals. The online businesses are MSN subscription and the Internet products and services. The Group acquired Lookout Software LLC on 16-Jul-2004, GIANT Company Software Inc on 16-Dec-2004 and Sybari Software Inc on 08-Feb-2005.</BusinessDescriptionExtended>

<EBIT-1Y>14794</EBIT-1Y>

<EBIT-2Y>11605</EBIT-2Y>

<EBIT-3Y>11684</EBIT-3Y>

<EBIT-4Y>14275</EBIT-4Y>

<EBITDA-1Y>15884</EBITDA-1Y>

<EBITDA-2Y>12619</EBITDA-2Y>

<EBITDA-3Y>12950</EBITDA-3Y>

<EBITDA-4Y>15023</EBITDA-4Y>

<EM-1Y>18.4773526819441</EM-1Y>

<EM-2Y>21.8675251604723</EM-2Y>

<EM-3Y>27.4500965250965</EM-3Y>

<EM-4Y>15.1967732809692</EM-4Y>

<Employees.Footnote>(A ): WORLDWIDE ^</Employees.Footnote>

<Employees-1Y>55000</Employees-1Y>

<Employees-2Y>50500</Employees-2Y>

<Employees-3Y>47600</Employees-3Y>

<Employees-4Y>39100</Employees-4Y>

<EntityName>MICROSOFT CORPORATION</EntityName>

<IncomeBefExtraItemsAndPfdDiv-1Y>9993</IncomeBefExtraItemsAndPfdDiv-1Y>

<IncomeBefExtraItemsAndPfdDiv-2Y>7829</IncomeBefExtraItemsAndPfdDiv-2Y>

<IncomeBefExtraItemsAndPfdDiv-3Y>7721</IncomeBefExtraItemsAndPfdDiv-3Y>

<IncomeBefExtraItemsAndPfdDiv-4Y>9421</IncomeBefExtraItemsAndPfdDiv-4Y>

<IncomeBefExtraItemsAndPfdDiv-5Y>7785</IncomeBefExtraItemsAndPfdDiv-5Y>

<IncomeBefExtraItemsAndPfdDiv-6Y>4490</IncomeBefExtraItemsAndPfdDiv-6Y>

<IncomeBefExtraItemsAndPfdDiv-7Y>3454</IncomeBefExtraItemsAndPfdDiv-7Y>

<IncomeBefExtraItemsAndPfdDiv-8Y>2195</IncomeBefExtraItemsAndPfdDiv-8Y>

<IncomeBefExtraItemsAndPfdDiv-9Y>1453</IncomeBefExtraItemsAndPfdDiv-9Y>

<IncomeBefExtraItemsCFStmt-1Y>9993</IncomeBefExtraItemsCFStmt-1Y>

<IncomeBefExtraItemsCFStmt-2Y>7829</IncomeBefExtraItemsCFStmt-2Y>

<IncomeBefExtraItemsCFStmt-3Y>7721</IncomeBefExtraItemsCFStmt-3Y>

<IncomeBefExtraItemsCFStmt-4Y>9421</IncomeBefExtraItemsCFStmt-4Y>

<IncomeBefIncomeTaxes-1Y>14794</IncomeBefIncomeTaxes-1Y>

<IncomeBefIncomeTaxes-2Y>11605</IncomeBefIncomeTaxes-2Y>

<IncomeBefIncomeTaxes-3Y>11684</IncomeBefIncomeTaxes-3Y>

<IncomeBefIncomeTaxes-4Y>14275</IncomeBefIncomeTaxes-4Y>

<IncomeBefIncomeTaxes-5Y>11891</IncomeBefIncomeTaxes-5Y>

<IncomeBefIncomeTaxes-6Y>7117</IncomeBefIncomeTaxes-6Y>

<IncomeBefIncomeTaxes-7Y>5314</IncomeBefIncomeTaxes-7Y>

<IncomeBefIncomeTaxes-8Y>3379</IncomeBefIncomeTaxes-8Y>

<IncomeBefIncomeTaxes-9Y>2167</IncomeBefIncomeTaxes-9Y>

<IncomeBefPreferredDividends-1Y>9993</IncomeBefPreferredDividends-1Y>

<IncomeBefPreferredDividends-2Y>7829</IncomeBefPreferredDividends-2Y>

<IncomeBefPreferredDividends-3Y>7346</IncomeBefPreferredDividends-3Y>

<IncomeBefPreferredDividends-4Y>9421</IncomeBefPreferredDividends-4Y>

<IncomeBefPreferredDividends-5Y>7785</IncomeBefPreferredDividends-5Y>

<IncomeBefPreferredDividends-6Y>4490</IncomeBefPreferredDividends-6Y>

<IncomeBefPreferredDividends-7Y>3454</IncomeBefPreferredDividends-7Y>

<IncomeBefPreferredDividends-8Y>2195</IncomeBefPreferredDividends-8Y>

<IncomeBefPreferredDividends-9Y>1453</IncomeBefPreferredDividends-9Y>

<IncomeFromContinuingOperations-1Y>9993</IncomeFromContinuingOperations-1Y>

<IncomeFromContinuingOperations-2Y>7829</IncomeFromContinuingOperations-2Y>

<IncomeFromContinuingOperations-3Y>7721</IncomeFromContinuingOperations-3Y>

<IncomeFromContinuingOperations-4Y>9421</IncomeFromContinuingOperations-4Y>

<IncomeFromContinuingOperations-5Y>7785</IncomeFromContinuingOperations-5Y>

<IncomeFromContinuingOperations-6Y>4490</IncomeFromContinuingOperations-6Y>

<IncomeFromContinuingOperations-7Y>3454</IncomeFromContinuingOperations-7Y>

<IncomeFromContinuingOperations-8Y>2195</IncomeFromContinuingOperations-8Y>

<IncomeFromContinuingOperations-9Y>1453</IncomeFromContinuingOperations-9Y>

<IncomeTaxes-1Y>4733</IncomeTaxes-1Y>

<IncomeTaxes-2Y>3684</IncomeTaxes-2Y>

<IncomeTaxes-3Y>3804</IncomeTaxes-3Y>

<IncomeTaxes-4Y>4854</IncomeTaxes-4Y>

<IncomeTaxes-5Y>4106</IncomeTaxes-5Y>

<IncomeTaxes-6Y>2627</IncomeTaxes-6Y>

<IncomeTaxes-7Y>1860</IncomeTaxes-7Y>

<IncomeTaxes-8Y>1184</IncomeTaxes-8Y>

<IncomeTaxes-9Y>714</IncomeTaxes-9Y>

<IncomeTaxesPayable-1Y>2044</IncomeTaxesPayable-1Y>

<IncomeTaxesPayable-2Y>2022</IncomeTaxesPayable-2Y>

<IncomeTaxesPayable-3Y>1468</IncomeTaxesPayable-3Y>

<IncomeTaxesPayable-4Y>585</IncomeTaxesPayable-4Y>

<IncomeTaxesPayable-5Y>1607</IncomeTaxesPayable-5Y>

<IncomeTaxesPayable-6Y>915</IncomeTaxesPayable-6Y>

<IncomeTaxesPayable-7Y>466</IncomeTaxesPayable-7Y>

<IncomeTaxesPayable-8Y>484</IncomeTaxesPayable-8Y>

<IncomeTaxesPayable-9Y>410</IncomeTaxesPayable-9Y>

<Intangibles-1Y>3512</Intangibles-1Y>

<Intangibles-2Y>1669</Intangibles-2Y>

<OfficerName>William H. Gates III Steven A. Ballmer George Zinn Bradford L. Smith</OfficerName>

<OfficerTitle>Chairman Chief Executive Vice President & Treasurer Senior Vice President, Secretary & General Counsel</OfficerTitle>

<OperatingIncomeAfterDepr-1Y>14238</OperatingIncomeAfterDepr-1Y>

<OperatingIncomeAfterDepr-2Y>12570</OperatingIncomeAfterDepr-2Y>

<OperatingIncomeAfterDepr-3Y>11720</OperatingIncomeAfterDepr-3Y>

<OperatingIncomeAfterDepr-4Y>10937</OperatingIncomeAfterDepr-4Y>

<OperatingIncomeAfterDepr-5Y>9928</OperatingIncomeAfterDepr-5Y>

<OperatingIncomeAfterDepr-6Y>6710</OperatingIncomeAfterDepr-6Y>

<OperatingIncomeAfterDepr-7Y>5130</OperatingIncomeAfterDepr-7Y>

<OperatingIncomeAfterDepr-8Y>3078</OperatingIncomeAfterDepr-8Y>

<OperatingIncomeAfterDepr-9Y>2038</OperatingIncomeAfterDepr-9Y>

<OperatingProfitMargin-1Y>44.23525</OperatingProfitMargin-1Y>

<OperatingProfitMargin-2Y>44.31518</OperatingProfitMargin-2Y>

<OperatingProfitMargin-3Y>46.33144</OperatingProfitMargin-3Y>

<OperatingProfitMargin-4Y>47.64332</OperatingProfitMargin-4Y>

<OtherAssets-1Y>1171</OtherAssets-1Y>

<OtherAssets-2Y>942</OtherAssets-2Y>

<PriceToBookRatioClose-1Y>4.22227</PriceToBookRatioClose-1Y>

<PriceToBookRatioClose-2Y>4.92633</PriceToBookRatioClose-2Y>

<PriceToBookRatioClose-3Y>7.80658</PriceToBookRatioClose-3Y>

<PriceToBookRatioClose-4Y>5.07981</PriceToBookRatioClose-4Y>

<PriceToSalesClose-1Y>9.25343665266987</PriceToSalesClose-1Y>