S&P Capital IQ's Excel Plug-in v.8.x - Frequently Used Formulas - Balance Sheet, Income Statement and Cash Flow Ratios

Sep 12, 2026

A formula reference for S&P Capital IQ’s Excel plug-in, organizing commonly used IQ_ functions by financial statement sections. The guide lists Balance Sheet items, Income Statement metrics, Cash Flow components, and additional Supplemental fields, each mapped to concise Excel formulas. It also provides key ratio formulas such as return on assets, return on equity, and gross margin, enabling consistent spreadsheet analysis across equity, debt, earnings, and cash generation lines.

LanguageEnglish

CategoryPresentations

FormatPDF

Pages2

Reading Time1 min

AccessFree to download

Balance Sheet

Income Statement

Cash Flow Statement

Ratios

S&P CAPITAL IQ'S EXCEL PLUG-IN v.8.x: FREQUENTLY USED FORMULAS | BALANCE SHEET | | --- | | Cash And Equivalents = IQ_CASH_EQUIV
Short Term Investments = IQ_ST_INVEST
Total Cash & ST Investments = IQ_CASH_ST_INVEST
Accounts Receivable = IQ_AR
Total Receivables = IQ_TOTAL_RECEIV
Inventory = IQ_INVENTORY
Total Current Assets = IQ_TOTAL_CA
Gross Property, Plant & Equipment = IQ_GPPE
Net Property, Plant & Equipment = IQ_NPPE
Long-term Investments = IQ_LT_INVEST
Total Intangibles = IQ_GW_INTAN
Total Assets = IQ_TOTAL_ASSETS
Accounts Payable = IQ_AP
Short-term Borrowings = IQ_ST_DEBT
Current Portion of Long Term Debt = IQ_CURRENT_PORT_DEBT
Curr. Port. of Cap. Leases = IQ_CURRENT_PORT_LEASES
Total Current Liabilities = IQ_TOTAL_CL
Long-Term Debt = IQ_LT_DEBT
Capital Leases = IQ_CAPITAL_LEASES
Minority Interest = IQ_MINORITY_INTEREST
Total Liabilities = IQ_TOTAL_LIAB
Total Pref. Equity = IQ_PREF_EQUITY
Common Stock = IQ_COMMON
Retained Earnings = IQ_RE
Treasury Stock = IQ_TREASURY
Total Common Equity = IQ_TOTAL_COMMON_EQUITY
Total Equity = IQ_TOTAL_EQUITY
Total Liabilities And Equity = IQ_TOTAL_LIAB_EQUITY
Supplemental Items
Filing Date = IQ_FILINGDATE_BS
Period Date = IQ_PERIODDATE_BS
Shares Outstanding on Filing Cover = IQ_OUTSTANDING_FILING_DATE
Shares Outstanding on Balance Sheet Date = IQ_OUTSTANDING_BS_DATE
Total Shares Out. On Filing Date = IQ_TOTAL_OUTSTANDING_FILING_DATE
Total Shares Outstanding on BS Date = IQ_TOTAL_OUTSTANDING_BS_DATE
Book Value/Share = IQ_BV_SHARE
Tangible Book Value = IQ_TBV
Tangible Book Value/Share = IQ_TBV_SHARE
Total Debt = IQ_TOTAL_DEBT
Total Current Debt = IQ_TOTAL_DEBT_CURRENT
Total Non-Current Debt = IQ_TOTAL_DEBT_NON_CURRENT
Net Debt = IQ_NET_DEBT
Total Capitalization = IQ_TOTAL_CAP
Full Time Employees = IQ_FULL_TIME | | INCOME STATEMENT | | --- | | Total Revenues = IQ_TOTAL_REV
Cost Of Revenues = IQ_COST_REV
Cost Of Goods Sold = IQ_COGS
Gross Profit = IQ_GP
Selling General & Admin Exp. = IQ_SGA_SUPPL
R & D Exp. = IQ_RD_EXP
Depreciation & Amort. = IQ_DA_SUPPL
Amort. of Goodwill and Intangibles = IQ_GW_INTAN_AMORT
Operating Income = IQ_OPER_INC
Net Interest Exp. = IQ_NET_INTEREST_EXP
EBT Excl Unusual Items = IQ_EBT_EXCL
Total Unusual Items = IQ_TOTAL_UNUSUAL
EBT Incl Unusual Items = IQ_EBT
Income Tax Expense = IQ_INC_TAX
Earnings from Cont. Ops. = IQ_EARNING_CO
Earnings of Discontinued Ops. = IQ_DO
Extraord. Item & Account. Change = IQ_EXTRA_ACC_ITEMS
Net Income = IQ_NI
Pref. Dividends and Other Adj. = IQ_PREF_DIV_OTHER
Merger/Restructuring Costs = IQ_MERGER_RESTRUCTURE
NI to Common Incl Extra Items = IQ_NI_AVAIL_INCL
NI to Common Excl Extra Items = IQ_NI_AVAIL_EXCL
Basic EPS = IQ_BASIC_EPS_INCL
Basic EPS Excl. Extra Items = IQ_BASIC_EPS_EXCL
Weighted Avg. Basic Shares Out. = IQ_BASIC_WEIGHT
Diluted EPS = IQ_DILUT_EPS_INCL
Diluted EPS Excl Extra Itmes = IQ_DILUT_EPS_EXCL
Weighted Avg. Diluted Shares Out. = IQ_DILUT_WEIGHT
Normalized Basic EPS = IQ_EPS_NORM
Normalized Diluted EPS = IQ_DILUT_EPS_NORM
Supplemental Items
EBITDA = IQ_EBITDA
EBITDA (Incl. Equity Inc. from Affiliates) = IQ_EBITDA_EQ_INC EBITA = IQ_EBITA
EBIT = IQ_EBIT
EBITDAR = IQ_EBITDAR
Net Rental Expense = IQ_NET_RENTAL_EXP_FN
Normalized Net Income = IQ_NI_NORM
Same Store Sales Growth % = IQ_SAME_STORE
Effective Tax Rate = IQ_EFFECT_TAX_RATE
Payout Ratio = IQ_PAYOUT_RATIO
Interest On Long Term Debt = IQ_INT_EXP_LTD
Total Current Taxes = IQ_CURR_TAXES
Total Deferred Taxes = IQ_DEFERRED_TAXES_TOTAL | | CASH FLOW STATEMENT | | --- | | Net Income = IQ_NI_CF
Depreciation & Amort. , Total = IQ_DA_CF
Asset Writedown & Restructuring Costs = IQ_ASSET_WRITEDOWN_CF
Stock-Based Compensation = IQ_STOCK_BASED_CF
Net Cash From Discontinued Ops. = IQ_DO_CF
Change In Accounts Rece

FAQs

What balance sheet formula mappings are included in the guide?

The guide lists Balance Sheet mappings such as Cash and Equivalents, Accounts Receivable, Inventory, Total Current Assets, Gross/Net Property Plant & Equipment, Total Assets, Total Liabilities, and key equity items, each tied to IQ_ function names.

Which income statement items and supplemental fields are provided?

It includes Total Revenues, Cost of Revenues, Cost of Goods Sold, Gross Profit, SG&A, R&D, depreciation and amortization, operating income, earnings before/after unusual items, income tax expense, net income, EPS variations, and supplemental items like EBITDA and related measures.

How are cash flow and ratio formulas presented?

Cash flow section formulas cover operating, investing, and financing cash components such as net income adjustments, capex, debt issued/repaid, dividends paid, and free cash flow. Ratios are given as standalone formula examples, including return on assets, return on equity, gross margin, and related percentage measures.

Sep 12, 2026

Upload by McGucket