OFFICE ADD-IN: FREQUENTLY USED FORMULAS

S&P Global Universal Fundamentals Market Data Corporate

Balance Sheet Day Close Price SP_PRICE_CLOSE Entity Name SP_ENTITY_NAME

Cash and Cash Equivalents SP_CASH_EQUIV Intraday Price SP_PRICE_INTRADAY Ticker SP_TICKER
Total Receivables SP_TOTAL_RECEIV Volume W eighted Average Price SP_VWAP Exchange SP_EXCHANGE
Inventories SP_INVENTORIES Market Capitalization SP_MARKETCAP Primary Industry (MI) MI_PRIMARY_INDUSTRY
Total Current Assets SP_CURRENT_ASSETS Total Enterprise Value (SNL) SNL_TEV Primary Industry (CIQ/GICS) IQ_PRIMARY_INDUSTRY
Loans and Investments SP_LOANS_INVESTMENTS Total Enterprise Value (CIQ) IQ_TEV SIC Code SP_SIC_CODE
Property, Plant and Equipment SP_NPPE Shares Outstanding SP_SHARES_OUT State SP_STATE
Total Intangible Assets SP_TOTAL_INTANGIBLES Volume SP_VOLUME Country / Region Name SP_COUNTRY_NAME
Total Assets SP_TOTAL_ASSETS Dividend Yield (%) SP_DIV_YIELD S&P Capital IQ ID SP_CIQ_ID
Total Current Liabilities SP_CURRENT_LIABILITIES LTM Dividends Announced SP_DIV_LTM Company Type SP_COMPANY_TYPE
Total Debt SP_TOTAL_DEBT Company Status SP_COMPANY_STATUS
Noncontrolling Interests SP_NONCONTROLLING_INTS Sample Formulas: Business Description SP_BUSINESS_DESCRIPTION
Total Equity SP_TOTAL_EQUITY =SPG("AMZN", "SP_MARKETCAP") -- Amazon.com, Inc.'s latest Market Capitalization Ownership Structure SP_OWN_STRUCTURE
Tangible Equity SP_TANG_EQUITY =SPG("AMZN", "SP_MARKETCAP", "04/15/2020") -- Market Capitalization as of 4/15/2020
Month of Fiscal Year End SP_MONTH_FYE
Total Debt/ Total Equity (x) SP_DEBT_TO_EQUITY *Exclude the as-of date parameter for latest available Web Address SP_WEBSITE

Income Statement Valuation/Multiples Capital IQ Consensus Estimates

Total Revenue SP_TOTAL_REV TEV/LTM Total Revenue IQ_TEV_TOTAL_REV CIQ Avg Broker Recomendation (Text) SP_AVG_BROKER_REC_TEXT
Cost of Revenue SP_COGS TEV/LTM EBITDA IQ_TEV_EBITDA CIQ Avg Broker Recomendation (#) SP_AVG_BROKER_REC
Selling General & Adm. Expense SP_SGA TEV/LTM EBIT IQ_TEV_EBIT CIQ Mean Price Target SP_PRICE_TARGET
Interest Expense SP_INT_EXP TEV/LTM Unlevered FCF IQ_TEV_UFCF Mean EPS Estimate SP_EPS_EST
Net Income SP_NET_INC Price/LTM EPS IQ_PE Mean Revenue Estimate SP_REV_EST
Net Net Income Attributable to Parent SP_NET_INC_PARENT Price/Book Value IQ_PBV_X Mean EBITDA Estimate SP_EBITDA_EST
Basic EPS after Extra SP_BASIC_EPS_AFTER_EXTRA Price/Tangible Book Value IQ_PTBV_X Mean EBIT Estimate SP_EBIT_EST
Diluted EPS after Extraordinary SP_DILUT_EPS_AFTER_EXTRA =SPG("AMZN", "IQ_PE") -- Amazon.com, Inc.'s latest trailing PE Mean Net Income Estimate SP_NI_EST
Common Dividends Declared per Share SP_COMMON_DIV_DECLARED =SPG("AMZN", "IQ_PE", "04/15/2020") -- trailing PE as of 4/15/2020 Mean Cash Flow per Share Estimate SP_CFPS_EST
EBIT SP_EBIT Forward Trading Multiples:
EBITDA SP_EBITDA TEV/Forward Total Revenue SP_TEV_TOTAL_REV_FWD Non-Periodic Estimate Formulas:
ROAA (%) SP_ROA TEV/Forward EBITDA SP_TEV_EBITDA_FWD =SPG("AMZN", "SP_PRICE_TARGET") -- latest Price Target for Amazon.com, Inc.
ROAE (%) SP_ROE TEV/Forward EBIT SP_TEV_EBIT_FWD '=SPG("AMZN", "SP_PRICE_TARGET", "04/15/2020") -- Price Target as of 4/15/2020
Return on Avg Common Equity (%) SP_ROCE Price/Forward EPS SP_PE_FWD Periodic Estimate Formulas:
Net Income Growth (%) SP_NET_INC_GROWTH =SPG("AMZN", "SP_PE_FWD", "NTM") -- latest forward PE '=SPG("AMZN", "SP_EPS_EST", "FY+1") -- EPS Estimate for next fiscal year
Diluted EPS Growth (%) SP_EPS_AFTER_EXTRA_GROWTH =SPG("AMZN", "SP_PE_FWD", "NTM", "4/15/2020") -- forward PE as of 4/15/2020 '=SPG("AMZN", "SP_EPS_EST", "FY+1", "04/15/2020") -- Estimate as of 4/15/2020
Dividend Growth Rate (%) SP_DIV_GROWTH *Supported periods for forward multiples: NTM, FY+1, FQ+1, FY2021, etc. *Supported periods for estimates: NTM, FY+1, FQ+1, FY2021, etc.

Miscellaneous
Basic SPG Formula: Available Period
Period Ended SP_PERIOD_END Types: Actual Relative
Reported Currency SP_CURRENCY_FINANCIALS CY2018 CY0, CY-1, ...
=SPG("AMZN", "SP_TOTAL_REV", "LTM") Calendar Year FY2018 FY0, FY-1, ...
Fiscal Period SP_FISCAL_PERIOD
Fiscal Year CQ42018 CQ0, CQ-1, ...
Common Shares Outstanding SP_SHARES_OUT_PERIOD_END Calendar Quarter FQ42018 FQ0, FQ-1, ...
Basic Book Value per Share SP_BVPS
Ticker/Identifier Metric Period Fiscal Quarter LTM42018 LTM, LTM-1, ...
Last-Twelve-Months YTD42018 YTD
Basic Tangible Book Value per Share SP_TBVPS Year-To-Date FH12018 FH0
Dividend Payout Ratio SP_PAYOUT_RATIO Advanced SPG Formula:
Note: All parameter support cell-referencing in
=SPG("AMZN", "SP_TOTAL_REV", "LTM", "Options: Curr=GBP, Mag=Billions") addition to direct inputs within the formula:
=SPG(A1, "SP_TOTAL_REV", A2)
A1 = AMZN
Ticker/Identifier Metric Period Optional Items: Currency, Magnitude, N/A Value A2 = LTM
 Capital IQ Fundamentals

Balance Sheet Income Statement Cash Flow

Cash and Equivalents IQ_CASH_EQUIV Total Revenue IQ_TOTAL_REV Net Income - CF IQ_NI_CF
Short Term Investments IQ_ST_INVEST Cost of Revenues IQ_COST_REV Depreciation & Amort., Total IQ_DA_CF
Cash & Short Term Investments IQ_CASH_ST_INVEST Cost Of Goods Sold IQ_COGS Asset Writedown & Restructuring Costs IQ_ASSET_WRITEDOWN_CF
Accounts Receivable IQ_AR Gross Profit IQ_GP Stock-Based Compensation IQ_STOCK_BASED_CF
Total Receivables IQ_TOTAL_RECEIV Selling General & Admin Exp. IQ_SGA_SUPPL Net Cash From Discontinued Ops. IQ_DO_CF
Inventory IQ_INVENTORY R & D Exp. IQ_RD_EXP Change in Acc. Receivable IQ_CHANGE_AR
Total Current Assets IQ_TOTAL_CA Depreciation & Amort. IQ_DA_SUPPL Change In Inventories IQ_CHANGE_INVENTORY
Gross Property, Plant & Equipment IQ_GPPE Amort. of Goodwill and Intangibles IQ_GW_INTAN_AMORT Change in Acc. Payable IQ_CHANGE_AP
Net Property, Plant & Equipment IQ_NPPE Operating Income IQ_OPER_INC Change in Unearned Rev. IQ_CHANGE_UNEARN_REV
Long-term Investments IQ_LT_INVEST Net Interest Exp. IQ_NET_INTEREST_EXP Change In Income Taxes IQ_CHANGE_INC_TAX
Total Goodwill and Intangibles IQ_TOTAL_GW_INTAN EBT Excl Unusual Items IQ_EBT_EXCL Change in Def. Taxes IQ_CHANGE_DEF_TAX
Total Assets IQ_TOTAL_ASSETS Other Unusual Items IQ_OTHER_UNUSUAL_SUPPL Cash from Ops. IQ_CASH_OPER
Accounts Payable IQ_AP EBT Incl. Unusual Items IQ_EBT Capital Expenditure IQ_CAPEX
Short-term Borrowings IQ_ST_DEBT Income Tax Expense IQ_INC_TAX Sale of Property, Plant and Equipment IQ_SALE_PPE_CF
Curr. Port. of LT Debt IQ_CURRENT_PORT_DEBT Earnings from Cont. Ops. IQ_EARNINGS_CONT_OPS Cash Acquisitions IQ_CASH_ACQUIRE_CF
Current Portion of Leases IQ_CURRENT_PORT_LEASES Earnings of Discontinued Ops. IQ_EARNINGS_DISCONTINUED_OPS Divestitures IQ_DIVEST_CF
Total Current Liabilities IQ_TOTAL_CL Extraord. Item & Account. Change IQ_EXTRA_ACC_ITEMS Sale (Purchase) of Intangible assets IQ_SALE_INTAN_CF
Long-Term Debt IQ_LT_DEBT Net Income to Company IQ_NET_INC Invest. in Marketable & Equity Securt. IQ_INVEST_SECURITY_CF
Long-Term Leases IQ_CAPITAL_LEASES Pref. Dividends and Other Adj. IQ_PREF_DIV_OTHER Cash from Investing IQ_CASH_INVEST
Total Liabilities IQ_TOTAL_LIAB Merger & Related Restruct. Charges IQ_MERGER_RESTRUCTURE Short Term Debt Issued IQ_ST_DEBT_ISSUED
Total Minority Interest IQ_MINORITY_INTEREST NI to Common Incl Extra Items IQ_NI_AVAIL_INCL Long-Term Debt Issued IQ_LT_DEBT_ISSUED
Total Preferred Equity IQ_TOTAL_PREF_EQUITY NI to Common Excl. Extra Items IQ_NI_AVAIL_EXCL Total Debt Issued IQ_TOTAL_DEBT_ISSUED
Common Stock IQ_COMMON_STOCK Basic EPS IQ_BASIC_EPS_AFTER_EXTRA Short Term Debt Repaid IQ_ST_DEBT_REPAID
Retained Earnings IQ_RETAINED_EARNINGS Basic EPS Excl. Extra Items IQ_BASIC_EPS_BEFORE_EXTRA Long-Term Debt Repaid IQ_LT_DEBT_REPAID
Treasury Stock IQ_TREASURY Weighted Avg. Basic Shares Out. IQ_AVG_BASIC_SHARES_OUT Total Debt Repaid IQ_TOTAL_DEBT_REPAID
Total Common Equity IQ_TOTAL_COMMON_EQUITY Diluted EPS Incl. Extra Items IQ_DILUT_EPS_AFTER_EXTRA Issuance of Common Stock IQ_COMMON_ISSUED
Total Equity IQ_TOTAL_EQUITY Diluted EPS Excl. Extra Items IQ_DILUT_EPS_BEFORE_EXTRA Repurchase of Common Stock IQ_COMMON_REP
Total Liabilities And Equity IQ_TOTAL_LIAB_EQUITY Weighted Avg. Diluted Shares Out. IQ_AVG_DILUT_SHARES_OUT Issuance of Pref. Stock IQ_PREF_ISSUED
Total Debt IQ_TOTAL_DEBT Normalized Basic EPS IQ_BASIC_EPS_NORM Repurchase of Preferred Stock IQ_PREF_REP
Net Debt IQ_NET_DEBT Normalized Diluted EPS IQ_DILUT_EPS_NORM Common Dividends Paid IQ_COMMON_DIV_CF
Total Capital IQ_TOTAL_CAP Supplemental Items: Pref. Dividends Paid IQ_PREF_DIV_CF
Supplemental Items: EBITDA IQ_EBITDA Common and/or Pref. Dividends Paid IQ_COMMON_PREF_DIV_CF
Filing Date IQ_FINL_FILING_DATE EBITDA Incl Eqty Inc from Affil Excl IQ_EBITDA_EQ_INC_EXCL_OPER_LEASE_ADJ Total Dividends Paid IQ_TOTAL_DIV_PAID_CF
Period Date IQ_PERIOD_END EBITDA, As Reported IQ_EBITDA_REPORTED Cash from Financing IQ_CASH_FINAN
Total Shares Out. On Filing Date IQ_SHARES_OUT_FILING_DATE EBITA IQ_EBITA Net Change in Cash IQ_CASH_NET_CHANGE
Total Shares Out. On BS Date IQ_SHARES_OUT_PERIOD_END EBIT IQ_EBIT Supplemental Items:
Book Value/Share IQ_BVPS EBITDAR IQ_EBITDAR Cash Interest Paid IQ_CASH_INTEREST
Tangible Book Value IQ_TANG_EQUITY As Reported Total Revenue IQ_TOTAL_REV_AS_REPORTED Cash Taxes Paid IQ_CASH_TAXES
Tangible Book Value/Share IQ_TBVPS Total Interest Income, As Reported IQ_INT_INC_TOTAL_REPORTED Net Debt Issued IQ_NET_DEBT_ISSUED
Total Debt IQ_TOTAL_DEBT Total Interest Expense, As Reported IQ_INT_EXPEN_TOTAL_REPORTED Levered Free Cash Flow IQ_LEVERED_FCF
Net Debt IQ_NET_DEBT Net Interest Income, As Reported IQ_NET_INT_INC_REPORTED Unlevered Free Cash Flow IQ_UNLEVERED_FCF
Total Capitalization IQ_TOTAL_CAP Net Rental Expense, Total IQ_NET_RENTAL_EXP_FN Change in Net Working Capital IQ_CHANGE_NET_WORKING_CAPITAL
Net Goodwill IQ_GW_NET Normalized Net Income IQ_NI_NORM
Net Intangibles IQ_INTAN_NET Total Same Store Sales Growth IQ_SAME_STORE_TOTAL As-of Dates for Capital IQ Fundamentals:
Total Leases IQ_TOTAL_LEASES Earnings before Taxes, As Reported IQ_EBT_REPORTED Capital IQ Fundamentals also support an "as-of" parameter allowing you to pull
Total Current Assets, As Reported IQ_TOTAL_CA_REPORTED Effective Tax Rate IQ_EFFECT_TAX_RATE historical financial data as-of a specific date. This applies to both "Actual" and
Total Current Liabilities, As Reported IQ_TOTAL_CL_REPORTED Payout Ratio IQ_PAYOUT_RATIO "Relative" Period types:
Total Shareholders Equity, As Reported IQ_TOTAL_EQUITY_REPORTED Interest on Long-Term Debt IQ_INT_EXP_LTD =SPG("AMZN", "IQ_TOTAL_ASSETS", "FY2018", "6/30/2019")
Part-Time Employees IQ_PART_TIME Total Current Taxes IQ_CURR_TAXES =SPG("AMZN", "IQ_TOTAL_ASSETS", "FY0", "6/30/2019")
Full Time Employees IQ_FULL_TIME Total Deferred Taxes IQ_DEFERRED_TAXES_TOTAL
 SNL Financials Fundamental

Key Financials Banking Media & Communications

Market Capitalization SP_MARKETCAP Net Customer Loans SNL_NET_CUSTOMER_LOANS Radio Content and Broadcasting Revenue SNL_RADIO_CONTENT_BROADCASTING_REV
Total Enterprise Value (SNL) SNL_TEV Total Deposits SNL_TOTAL_DEPOSITS TV/ Cable Network Revenue SNL_TV_TO_CABLE_NETWORK_REV
Total Revenue SNL_TOTAL_REVENUE Tangible Equity SNL_TANG_EQUITY Filmed Entertainment & TV Revenue SNL_FILMED_ENTERTAINMENT_TV_REV
Interest Expense SNL_INT_EXP Net Income SNL_NET_INC Internet Content and Distribution Revenue SNL_INTERNET_CONTENT_DIST_REV
Net Income SNL_NET_INC ROACE SNL_ROCE Content, Broadcasting and Distribution Revenue
SNL_CONTENT_BROADCASTING_DIST_REV
Net Income Attributable to Parent SNL_NET_INC_PARENT ROATCE SNL_ROATCE Magazine Revenue SNL_MAGAZINE_REV
Avg Diluted Shares SNL_AVG_DIL_SHARES Net Loans/ Assets SNL_NET_LOAN_TO_ASSETS Newspaper Revenue SNL_NEWSPAPER_REV
Basic EPS after Extra SNL_BASIC_EPS_AFTER_EXTRA Amortized Loans/ Deposits SNL_AMORT_LOANS_TO_DEPOSITS Book Publishing Revenue SNL_BOOK_PUBLISHING_REV
Diluted EPS after Extraordinary SNL_DILUT_EPS_AFTER_EXTRA Securities/ Assets SNL_SECS_TO_ASSETS Publishing Revenue SNL_PUBLISHING_REV
EBITDA SNL_EBITDA Loans/ Deposits SNL_LOAN_TO_DEP Owned & Operated Radio Stations SNL_OWNED_OPERATED_RADIO_STATIONS
EBIT SNL_EBIT Net Interest Income/ Avg Assets SNL_NET_INT_INC_TO_AVG_ASSETS Number of Radio Stations SNL_NUM_RADIO_STATIONS
Common Dividends Declared per Share SNL_COMMON_DIV_DECLARED Net Interest Margin SNL_NIM Net Radio Revenue SNL_NET_RADIO_REV
Dividend Payout Ratio SNL_PAYOUT_RATIO Tier 1 Common Capital (CET1) Ratio SNL_TIER_1_COMMON_RATIO Basic Subscribers SNL_BASIC_SUBSCRIBERS
Recurring Revenue Growth SNL_REC_REV_GROWTH Tier 1 Ratio SNL_TIER_1_RATIO Digital Subscribers SNL_DIGITAL_SUBSCRIBERS
EPS Growth, before Extraordinary SNL_EPS_GROWTH_BEFORE_EXTRA Total Capital Ratio SNL_TOTAL_CAPITAL_RATIO High Speed Data Subscribers SNL_HIGH_SPEED_DATA_SUBSCRIBERS
EPS Growth, after Extraordinary SNL_EPS_AFTER_EXTRA_GROWTH Insurance Energy (Coal, Gas Utilities, Midstream, Power)
ROAA SNL_ROA Investments SNL_INVESTMENTS Coal Sales Revenue SNL_COAL_SALES_REV
ROAE SNL_ROE Total Policy Reserves SNL_FIN_TOTAL_POLICY_RESV Electric Revenue SNL_ELEC_REV
ROACE SNL_ROCE Total Policy Income SNL_TOTAL_POLICY_INC Oil & Natural Gas Revenue SNL_OIL_NAT_GAS_REV
ROATCE SNL_ROATCE Net Investment Income SNL_NET_INVEST_INC Gas Distribution Revenue SNL_GAS_DIST_REV
Gross Margin SNL_GROSS_MARGIN Total Policy Expense SNL_TOTAL_POLICY_EXP Oil & Gas Exploration & Production SNL_OIL_GAS_EXPLORATION_PRODUCTION
EBITDA Margin SNL_EBITDA_MARGIN Underwriting & Other Expense SNL_UNDERWRITING_OTHER_EXPENSE Oil & Gas Products Sales SNL_OIL_GAS_PRODUCTS_SALES
EBIT Margin SNL_EBIT_MARGIN Gross Premiums W ritten SNL_GPW Oil & Gas Midstream Operating Rev. SNL_OIL_GAS_MIDSTREAM_OPER_REV
Net Income Margin SNL_NET_INC_MARGIN Gross Premiums Earned SNL_GROSS_PREMS_EARNED Energy Operating Revenue SNL_ENERGY_OPER_REV
Recurring EBITDA Margin SNL_REC_EBITDA_MARGIN Ceded Premiums Earned SNL_CEDED_PREMS_EARNED Electric Revenue/ Operating Revenue SNL_ELEC_REV_TO_OPER_REV
EBITDA/ Interest Expense SNL_EBITDA_TO_INT_EXP Net Premiums Earned SNL_NPE Gas Revenue/ Operating Revenue SNL_GAS_REV_TO_OPER_REV
Cash and Cash Equivalents SNL_CASH_EQUIV Loss Ratio SNL_LR Op. & Maint./ Operating Expense SNL_OPS_AND_MAINT_TO_OPER_EXP
Current Assets SNL_CURRENT_ASSETS Expense Ratio SNL_ER Electric Generation/ Operating Expense SNL_ELEC_GEN_TO_OPER_EXP
Net PP&E SNL_NPPE Combined Ratio SNL_CR Gas Cost/ Operating Expense SNL_GAS_COST_TO_OPER_EXP
Total Assets SNL_TOTAL_ASSETS Policy Expense/ Expense SNL_POLICY_EXP_TO_EXP Midstream Revenue/ Operating Revenue SNL_MIDSTREAM_REV_TO_OPER_REV
Total Debt SNL_TOTAL_DEBT Insurance Investment Yield SNL_INSURANCE_INVEST_YLD Midstream Costs/ Operating Expense SNL_MIDSTREAM_COSTS_TO_OPER_REV
Total Equity SNL_TOTAL_EQUITY Financial Services Real Estate
Total Capitalization SNL_TOTAL_CAP Assets Under Management SNL_AUM Gross Depreciable Property SNL_GROSS_DEPRECIABLE_PPTY
Common Shares Outstanding SNL_SHARES_OUT_PERIOD_END Mutual Funds under Management SNL_MUTUAL_FUNDS_UNDER_MGMT Net Property Investment SNL_NET_PPTY_INVEST
Book Value per Share SNL_BVPS AUM Growth SNL_AUM_GROWTH Finance Leases SNL_FIN_LEASES
Tangible Book Value per Share SNL_TBVPS Management Fees/ Avg AUM SNL_MGMT_FEES_TO_AVG_AUM Mortgage Loans SNL_MRTG_LOAN
Total Equity/ Total Assets SNL_EQUITY_TO_ASSETS Loans Originated SNL_LOAN_ORIGINATED Rental Revenue SNL_RENTAL_REV
Total Debt/ Total Equity SNL_DEBT_TO_EQUITY Loans Sold SNL_LOAN_SOLD Rental Net Operating Income SNL_RENTAL_NET_OPER_INC
Total Debt/ Total Capitalization SNL_TOTAL_DEBT_TO_TOTAL_CAP Total Net Loans SNL_NET_LOANS NOI SNL_NOI
Debt/ EBITDA SNL_DEBT_TO_EBITDA Investments SNL_INV_CO_INVEST FFO SNL_FFO_GAAP
Cash Flow from Operating Activities SNL_CASH_OPER Managed Assets SNL_MNGD_ASSETS Adjusted FFO SNL_AFFO
Cash Flow: Capital Expenditures SNL_CAPEX Managed Receiv. for Self and Others SNL_MNGD_RECV_FOR_SELF_OTHERS Gain on Sale of Real Estate SNL_GAIN_ON_SALE_OF_RE
Supplemental Items: Managed NCOs/ Avg Managed Rec SNL_MNGD_NCO_TO_AVG_MNGD_REC FFO Payout (%) SNL_FFO_PAYOUT
Period Ended (mm/dd/yyyy) SNL_PERIOD_END Investments/ Assets SNL_INVEST_TO_ASSETS FFO/ Total Revenue (%) SNL_FFO_TO_TOTAL_REV
Earnings Release Date (mm/dd/yyyy) SNL_EARNINGS_RELEASE_DATE Return on Avg. AUM SNL_RETURN_ON_AVG_AUM Same-store NOI: Change SNL_SS_NOI_CHANGE
Financials Reported Currency Code SNL_CURRENCY_FINANCIALS Return on Avg. Managed Receivables SNL_RETURN_ON_AVG_MNGD_REC Same-store Revenue: Chg. from Prior SNL_SS_REV_CHANGE_FROM_PRIOR
Fiscal Period SNL_FISCAL_PERIOD Return on Avg. Managed Assets SNL_RETURN_ON_AVG_MNGD_ASSETS NAV per Share, as Reported SNL_NAV_PER_SHARE