S&P CAPITAL IQ'S EXCEL PLUG-IN v.8.x: FREQUENTLY USED FORMULAS

S&P CAPITAL IQ'S EXCEL PLUG-IN v.8.x: FREQUENTLY USED FORMULAS

Cash And Equivalents Short Term Investments Total Cash & ST Investments Accounts Receivable Total Receivables Inventory Total Current Assets Gross Property, Plant & Equipment Net Property, Plant & Equipment Long-term Investments Total Intangibles Total Assets Accounts Payable Short-term Borrowings Current Portion of Long Term Debt Curr. Port. of Cap. Leases Total Current Liabilities Long-Term Debt Capital Leases Minority Interest Total Liabilities Total Pref. Equity Common Stock Retained Earnings Treasury Stock Total Common Equity Total Equity Total Liabilities And Equity

BALANCE SHEET

= IQ_CASH_EQUIV = IQ_ST_INVEST = IQ_CASH_ST_INVEST = IQ_AR = IQ_TOTAL_RECEIV = IQ_INVENTORY = IQ_TOTAL_CA = IQ_GPPE = IQ_NPPE = IQ_LT_INVEST = IQ_GW_INTAN = IQ_TOTAL_ASSETS = IQ_AP = IQ_ST_DEBT = IQ_CURRENT_PORT_DEBT = IQ_CURRENT_PORT_LEASES = IQ_TOTAL_CL = IQ_LT_DEBT = IQ_CAPITAL_LEASES = IQ_MINORITY_INTEREST = IQ_TOTAL_LIAB = IQ_PREF_EQUITY = IQ_COMMON = IQ_RE = IQ_TREASURY = IQ_TOTAL_COMMON_EQUITY = IQ_TOTAL_EQUITY = IQ_TOTAL_LIAB_EQUITY

Supplemental Items Filing Date Period Date Shares Outstanding on Filing Cover Shares Outstanding on Balance Sheet Date Total Shares Out. On Filing Date Total Shares Outstanding on BS Date Book Value/Share Tangible Book Value Tangible Book Value/Share Total Debt Total Current Debt Total Non-Current Debt Net Debt Total Capitalization Full Time Employees

= IQ_FILINGDATE_BS = IQ_PERIODDATE_BS = IQ_OUTSTANDING_FILING_DATE = IQ_OUTSTANDING_BS_DATE = IQ_TOTAL_OUTSTANDING_FILING_DATE = IQ_TOTAL_OUTSTANDING_BS_DATE = IQ_BV_SHARE = IQ_TBV = IQ_TBV_SHARE = IQ_TOTAL_DEBT = IQ_TOTAL_DEBT_CURRENT = IQ_TOTAL_DEBT_NON_CURRENT = IQ_NET_DEBT = IQ_TOTAL_CAP = IQ_FULL_TIME

Total Revenues Cost Of Revenues Cost Of Goods Sold Gross Profit Selling General & Admin Exp. R & D Exp. Depreciation & Amort. Amort. of Goodwill and Intangibles Operating Income Net Interest Exp. EBT Excl Unusual Items Total Unusual Items EBT Incl Unusual Items Income Tax Expense Earnings from Cont. Ops. Earnings of Discontinued Ops. Extraord. Item & Account. Change Net Income Pref. Dividends and Other Adj. Merger/Restructuring Costs NI to Common Incl Extra Items NI to Common Excl Extra Items Basic EPS Basic EPS Excl. Extra Items Weighted Avg. Basic Shares Out. Diluted EPS Diluted EPS Excl Extra Itmes Weighted Avg. Diluted Shares Out. Normalized Basic EPS Normalized Diluted EPS

INCOME STATEMENT

= IQ_TOTAL_REV = IQ_COST_REV = IQ_COGS = IQ_GP = IQ_SGA_SUPPL = IQ_RD_EXP = IQ_DA_SUPPL = IQ_GW_INTAN_AMORT = IQ_OPER_INC = IQ_NET_INTEREST_EXP = IQ_EBT_EXCL = IQ_TOTAL_UNUSUAL = IQ_EBT = IQ_INC_TAX = IQ_EARNING_CO = IQ_DO = IQ_EXTRA_ACC_ITEMS = IQ_NI = IQ_PREF_DIV_OTHER = IQ_MERGER_RESTRUCTURE = IQ_NI_AVAIL_INCL = IQ_NI_AVAIL_EXCL = IQ_BASIC_EPS_INCL = IQ_BASIC_EPS_EXCL = IQ_BASIC_WEIGHT = IQ_DILUT_EPS_INCL = IQ_DILUT_EPS_EXCL = IQ_DILUT_WEIGHT = IQ_EPS_NORM = IQ_DILUT_EPS_NORM

Supplemental Items EBITDA EBITDA (Incl. Equity Inc. from Affiliates) EBITA EBIT EBITDAR Net Rental Expense Normalized Net Income Same Store Sales Growth % Effective Tax Rate Payout Ratio Interest On Long Term Debt Total Current Taxes Total Deferred Taxes

= IQ_EBITDA = IQ_EBITDA_EQ_INC = IQ_EBITA = IQ_EBIT = IQ_EBITDAR = IQ_NET_RENTAL_EXP_FN = IQ_NI_NORM = IQ_SAME_STORE = IQ_EFFECT_TAX_RATE = IQ_PAYOUT_RATIO = IQ_INT_EXP_LTD = IQ_CURR_TAXES = IQ_DEFERRED_TAXES_TOTAL

CASH FLOW STATEMENT

Net Income Depreciation & Amort., Total Asset Writedown & Restructuring Costs Stock-Based Compensation Net Cash From Discontinued Ops. Change In Accounts Receivable Change In Inventories Change in Acc. Payable Change in Unearned Rev. Change in Inc. Taxes Change in Def. Taxes Cash from Ops. Capital Expenditure Sale of Property, Plant, and Equipment Cash Acquisitions Divestitures Sale (Purchase) of Intangible assets Net Cash from Investments Cash from Investing Short Term Debt Issued Long-Term Debt Issued Total Debt Issued Short Term Debt Repaid Long-Term Debt Repaid Total Debt Repaid Issuance of Common Stock Repurchase of Common Issuance of Preferred Stock Repurchase of Preferred Common Dividends Paid Pref. Dividends Paid Common and/or Pref. Dividends Paid Total Dividends Paid Cash from Financing Net Change in Cash

= IQ_NI_CF = IQ_DA_CF = IQ_ASSET_WRITEDOWN_CF = IQ_STOCK_BASED_CF = IQ_DO_CF = IQ_CHANGE_AR = IQ_CHANGE_INVENTORY = IQ_CHANGE_AP = IQ_CHANGE_UNEARN_REV = IQ_CHANGE_INC_TAX = IQ_CHANGE_DEF_TAX = IQ_CASH_OPER = IQ_CAPEX = IQ_SALE_PPE_CF = IQ_CASH_ACQUIRE_CF = IQ_DIVEST_CF = IQ_SALE_INTAN_CF = IQ_INVEST_SECURITY_CF = IQ_CASH_INVEST = IQ_ST_DEBT_ISSUED = IQ_LT_DEBT_ISSUED = IQ_TOTAL_DEBT_ISSUED = IQ_ST_DEBT_REPAID = IQ_LT_DEBT_REPAID = IQ_TOTAL_DEBT_REPAID = IQ_COMMON_ISSUED = IQ_COMMON_REP = IQ_PREF_ISSUED = IQ_PREF_REP = IQ_COMMON_DIV_CF = IQ_PREF_DIV_CF = IQ_COMMON_PREF_DIV_CF = IQ_TOTAL_DIV_PAID_CF = IQ_CASH_FINAN = IQ_NET_CHANGE

Supplemental Items Cash Interest Paid Cash Taxes Paid Net Debt Issued Levered Free Cash Flow Unlevered Free Cash Flow Change in Net Working Capital EBITDA - Capex

= IQ_CASH_INTEREST = IQ_CASH_TAXES = IQ_NET_DEBT_ISSUED = IQ_LEVERED_FCF = IQ_UNLEVERED_FCF = IQ_CHANGE_NET_WORKING_CAPITAL = IQ_EBITDA_CAPEX

Client Support North America: 888.806.5541 / +1.212.438.1070 EMEA: +44.(0)20.7176.1234 Asia-Pacific: +852 2533 3588

S&P CAPITAL IQ'S EXCEL PLUG-IN v.8.x: FREQUENTLY USED FORMULAS

Return on Assets % Return on Equity % Gross Margin % SG&A Margin % EBITDA Margin % Net Income Margin % Levered Free Cash Flow Margin % Accounts Receivable Turnover

Inventory Turnover Current Ratio Quick Ratio Avg Days Sales Outstanding Avg Days Payable Outstanding Total Debt/Equity Total Debt/Capital EBIT / Interest Expense Capex as % of Revenues Total Debt/EBITDA Net Debt/EBITDA

RATIOS

= IQ_RETURN_ASSETS = IQ_RETURN_EQUITY = IQ_GROSS_MARGIN = IQ_SGA_MARGIN = IQ_EBITDA_MARGIN = IQ_NI_MARGIN = IQ_LFCF_MARGIN

= IQ_AR_TURNS = IQ_INVENTORY_TURNS = IQ_CURRENT_RATIO = IQ_QUICK_RATIO = IQ_DAYS_SALES_OUT = IQ_DAYS_PAYABLE_OUT = IQ_TOTAL_DEBT_EQUITY = IQ_TOTAL_DEBT_CAPITAL = IQ_EBIT_INT = IQ_CAPEX_PCT_REV = IQ_TOTAL_DEBT_EBITDA = IQ_NET_DEBT_EBITDA

GROWTH (Up to 10 years of growth)

Total Revenues, 1 Yr Growth %

= IQ_TOTAL_REV_1YR_ANN_GROWTH

Gross Profit, 1 Yr Growth %

= IQ_GP_1YR_ANN_GROWTH

EBITDA, 1 Yr Growth %

= IQ_EBITDA_1YR_ANN_GROWTH

EBIT, 1 Yr Growth %

= IQ_EBIT_1YR_ANN_GROWTH

Net Income, 1 Yr Growth %

= IQ_NI_1YR_ANN_GROWTH

Normalized Net Income, 1 Yr Growth % Diluted EPS before Extra, 1 Yr Growth %

= IQ_NI_NORM_1YR_ANN_GROWTH = IQ_EPS_1YR_ANN_GROWTH

Common Equity, 1 Yr Growth %

= IQ_COMMON_EQUITY_1YR_ANN_GROWTH

Inventory, 1 Yr Growth %

= IQ_INV_1YR_ANN_GROWTH

Total Assets, 1 Yr Growth %

= IQ_TOTAL_ASSETS_1YR_ANN_GROWTH

Tangible Book Value, 1 Yr Growth % Cash from Operations, 1 Yr Growth %

= IQ_TBV_1YR_ANN_GROWTH = IQ_CFO_1YR_ANN_GROWTH

Capital Expenditures, 1 Yr Growth % Levered Free Cash Flow, 1 Yr Growth %

= IQ_CAPEX_1YR_ANN_GROWTH = IQ_LFCF_1YR_ANN_GROWTH

Unlevered Free Cash Flow, 1 Yr Growth %

= IQ_UFCF_1YR_ANN_GROWTH

Dividend per Share, 1 Yr Growth %

= IQ_DPS_1YR_ANN_GROWTH

CAPITAL STRUCTURE

Total Commercial Paper

= IQ_CP

Total Revolving Credit

= IQ_RC

Total Term Loans Total Sr. Bonds and Notes

= IQ_TERM_LOANS = IQ_SR_BONDS_NOTES

Total Sub. Bonds and Notes Cap. Leases (Incl. Curr. Portion)

= IQ_SUB_BONDS_NOTES = IQ_CAPITAL_LEASES_TOTAL

Other Borrowings

= IQ_OTHER_DEBT

Total Principal Due

= IQ_TOTAL_PRINCIPAL

Total Senior Debt

= IQ_SR_DEBT

Total Senior Debt (% of Total Debt) Total Sub. Debt

= IQ_SR_DEBT_PCT = IQ_TOTAL_SUB_DEBT

Total Convertible Debt

= IQ_CONVERT

Total Short-Term Debt

= IQ_ST_DEBT

Total Short-Term Debt (% of Total Debt)

= IQ_ST_DEBT_PCT

Long-Term Debt (Incl. Cap. Leases) Senior Debt/EBITDA

= IQ_LT_DEBT_CAPITAL_LEASES = IQ_SR_DEBT_EBITDA

Senior Debt/(EBITDA-CAPEX) Total Sub. Debt/ EBITDA

= IQ_SR_DEBT_EBITDA_CAPEX = IQ_TOTAL_SUB_DEBT_EBITDA

Company Name Chinese Short Native Name Business Description Headquarters Primary Industry Number of Shareholders

COMPANY INFORMATION

= IQ_COMPANY_NAME = IQ_CHINESE_SHORT_NATIVE_TICKER = IQ_BUSINESS_DESCRIPTION = IQ_COMPANY_ADDRESS = IQ_PRIMARY_INDUSTRY = IQ_NUMBER_SHAREHOLDERS

Unemployment Rate GDP Real GDP Inflation Rate Budget Spending CPI Consumer Lending

MACROECONOMIC

= IQ_UNEMPLOYMENT_RATE

= IQ_GDP = IQ_GDP_REAL

= IQ_INFLATION_RATE = IQ_BUDGET_SPENDING = IQ_CPI = IQ_CONSUMER_LENDING

Avg Broker Recommendation (Text) Avg Broker Recommendation (#) Price Target Est. Annual EPS Growth - 5 Yr Primary EPS Estimate Revenue Estimate EBITDA Estimate EBIT Estimate

Net Income Estimate Cash Flow Per Share Estimate # of Analyst Buy Recomm. # of Analyst Hold Recom. # of Analyst Sell Recom. Estimated Next Earnings Date Next Earnings Date EPS Difference EPS Surprise % Revenue Difference Revenue Surprise %

CONSENSUS ESTIMATES

= IQ_AVG_BROKER_REC = IQ_AVG_BROKER_REC_NO = IQ_PRICE_TARGET = IQ_EST_EPS_GROWTH_5YR = IQ_EPS_EST = IQ_REVENUE_EST = IQ_EBITDA_EST

= IQ_EBIT_EST = IQ_NI_EST = IQ_CFPS_EST = IQ_EST_NUM_BUY = IQ_EST_NUM_HOLD = IQ_EST_NUM_SELL = IQ_EST_NEXT_EARNINGS_DATE = IQ_NEXT_EARNINGS_DATE = IQ_EST_EPS_DIFF = IQ_EST_EPS_SURPRISE_PERCENT = IQ_EST_REV_DIFF = IQ_EST_REV_SURPRISE_PERCENT

TEV/Total Revenues TEV/EBITDA TEV/EBIT TEV/Unlevered FCF Market Cap/Levered FCF P/Diluted EPS before extra P/BV P/TangBV P/ Sales Forward Trading Multiples TEV/Forward Total Revenue TEV/Forward EBITDA TEV/Forward EBIT P/Forward Diluted EPS before extra PEG Ratio P/Forward CFPS

VALUATION

= IQ_TEV_TOTAL_REV = IQ_TEV_EBITDA = IQ_TEV_EBIT = IQ_TEV_UFCF = IQ_MARKET_CAP_LFCF = IQ_PE_EXCL = IQ_PBV = IQ_PTBV = IQ_PRICE_SALES

= IQ_TEV_TOTAL_REV_FWD = IQ_TEV_EBITDA_FWD = IQ_TEV_EBIT_FWD = IQ_PE_EXCL_FWD = IQ_PEG_FWD = IQ_PRICE_CFPS_FWD

Issue Name Issuer Issuer Parent Ticker Symbol Issuer Ticker Symbol Amount Outstanding Maturity Date Offering Coupon Offering Date Offering Price Security Type Security Level YTW YTW Date STW Offering Yield Principal Amount Current Price Callable Feature

FIXED INCOME

= IQ_ISSUE_NAME = IQ_ISSUER = IQ_ISSUER_PARENT_TICKER = IQ_ISSUER_TICKER = IQ_AMT_OUT = IQ_MATURITY_DATE = IQ_OFFER_COUPON = IQ_OFFER_DATE = IQ_OFFER_PRICE = IQ_SECURITY_TYPE = IQ_SECURITY_LEVEL = IQ_YTW = IQ_YTW_DATE = IQ_STW = IQ_OFFER_YIELD = IQ_PRINCIPAL_AMT = IQ_BOND_PRICE = IQ_CALLABLE

Today's Date

Pricing Date Stock Exchange Last Sale Price

Close Price Dividend Adjusted Day Close Price Volume Weighted Average Price 52 Week High Price 52 Week High Date Daily Volume Daily Value Traded Market Capitalization Enterprise Value Shares Outstanding 5 Year Beta 5 Year Price Volatility Fund NAV Dividend Yield Latest Annualized Dividend Per Share

MARKET DATA

= CIQGETDATE(IQ_TODAY) = IQ_PRICEDATE = IQ_EXCHANGE

= IQ_LASTSALEPRICE = IQ_CLOSEPRICE = IQ_CLOSEPRICE_ADJ = IQ_VWAP = IQ_YEARHIGH = IQ_YEARHIGH_DATE = IQ_VOLUME = IQ_VALUE_TRADED = IQ_MARKETCAP = IQ_TEV = IQ_SHARESOUTSTANDING = IQ_BETA_5YR = IQ_PRICE_VOL_HIST_5YR = IQ_FUND_NAV = IQ_DIVIDEND_YIELD = IQ_ANNUALIZED_DIVIDEND

S&P Long-Term Company Rating S&P Long-Term Company Rating Date S&P Outlook/Credit Watch S&P Long Term Security Rating S&P Security Rating Date S&P Security Rating Action

CREDIT RATINGS

= IQ_SP_LC_LT = IQ_SP_LC_DATE_LT = IQ_SP_OUTLOOK_WATCH = IQ_SP_ISSUE_LT = IQ_SP_ISSUE_DATE = IQ_SP_ISSUE_ACTION

CIQ FUNCTIONS

Pricing Financials Multiples Dividends Average Value Function (Dates) Average Value Function (Period) Average Value Function (Finan. Metric) High Value Function (Dates) High Value Function (Period) Low Value Function (Dates)

= CIQRANGE(T,Market Item, D1, D2) = CIQRANGE(T,Financial Metric, Period, D2) = CIQRANGE(T,Multiple Metric, Period, D1, D2) = CIQRANGE(T, Divident Metric, D1, D2) = CIQAVG(T, Market Item, D1, D2) = CIQAVG (T, Market Item, Period) = CIQAVG (T, Financial Metric, Period, D2) = CIQHI(T, Market Item, D1, D2) = CIQHI(T, Market Item,Period) = CIQLO(T, Market Item, D1, D2)

Low Value Function (Period) Percent Change Function

= CIQLO(T, Market Item,Period) = CIQPC(T, Market Item, D1, D2)

Percent Change Function (Period)

= CIQPC(T, Market Item,Period)

News Headline Key Development ID Event ID Quick Comps * T = Ticker Input, D1 = Start Date, D2 = End Date

= CIQRANGE(T,IQ_NEWS,Start Rank,End Rank) = CIQRANGE(T,IQ_KEY_DEV_ID,D1,D2,Category(ies)) = CIQRANGE(T,IQ_EVENT_ID,D1,D2,Category(ies)) = CIQRANGE(T,IQ_QUICK_COMP,Start Rank,End Rank)

COMPANY INFO Institutional Holder Institutional Holder Total Shares Insider Holder Insider Holder Total Shares Holder Name Holder CIQ ID Holder Total Shares Mutal Fund Name Mutal Fund Shares Held Mututal Fund % of Shares Outstanding

RANGE FUNCTIONS*

= IQ_INSTITUTIONAL_OWNER = IQ_INSTITUTIONAL_SHARES = IQ_INSIDER_OWNER = IQ_INSIDER_SHARES = IQ_HOLDER_NAME = IQ_HOLDER_CIQID = IQ_HOLDER_SHARES = IQ_HOLDER_FUND_NAME = IQ_HOLDER_FUND_SHARES = IQ_HOLDER_FUND_PERCENT

COMPANY INFO- Private Equity

All Direct Investments All Direct Investments CIQ ID Fund Families Recent Funds Fund Name Fund Size (USD) Limited Partner Industries of Interest Equity Investment- Min(mm-USD) FINANCIALS- Segments

= IQ_INVESTMETNS_ALL = IQ_INVESTMETNS_ALL_ID = IQ_PE_FUND_FAMILIES = IQ_RECENT_FUNDS = IQ_PE_FUND_NAME = IQ_PE_FUND_SIZE = IQ_LIMITED_PARTNERS = IQ_INVEST_CRITERIA_INDUSTRY = IQ_INVEST_CRITERIA_EQUITY_MIN

Business Segment Description

= IQ_BUS_SEG_DESCRIPTION

Business Segment Name

= IQ_BUS_SEG_NAME

Business Segment Revenue

= IQ_BUS_SEG_REV

Business Segment Assets

= IQ_BUS_SEG_ASSETS

Geographic Segment Name

= IQ_GEO_SEG_NAME

Geographic Segment Revenue

= IQ_GEO_SEG_REV

Geographic Segment Assets

= IQ_GEO_SEG_ASSETS

TRANSACTIONS- List

Index Constituents

= IQ_CONSTITUENTS

All Transactions

= IQ_TRANSACTION_LIST

M&A Transactions

= IQ_TRANSACTION_LIST_MA

Equity Indentifiers

= IQ_EQUITY_LIST

Fixed Income Indentifiers

= IQ_FIXED_INCOME_LIST

Bond Identifiers

= IQ_BOND_LIST

Preferred Security Indentifiers

= IQ_PREFERRED_LIST

Bank Loan Identifiers

= IQ_BANK_LOAN_LIST

Credit Default Swap Identifiers

= IQ_CDS_LIST

*Please refer to the front page for the syntax of CIQRANGE formula

Client Support North America: 888.806.5541 / +1.212.438.1070 EMEA: N+o4r4th.(0A)m2e0r.i7c1a7: 868.182.83046.5541 / +1.212.438.1070 Asia-PaEcMifiEc:A+: 8+4542.(205)2303.73157868.1234

Asia-Pacific: +852 2533 3588

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

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

Google Online Preview   Download