Excel Add-in for IPT

Field names & corresponding Keywords

The below table gives you the keyword corresponding to fields available in Infront Functions.

Balance Sheet

Keyword

Name

CASHSTINV

Cash and Short Term Investments

ACCRECEIV

Accounts Receivables

STINVEST

Stock Inventories, Inventories

TOTCURRASSETS

Total Current Assets

FIXEDASSETS

Fixed Assets, Net Property Plant and Equipment

INTANG

Goodwill and Intangibles

OTHLTASSETS

Other Long Term Assets

TOTASSETS

Total Assets

ACCPAYABLE

Accounts Payable

TOTCURRLIAB

Total Current Liabilities

TOTLTDEBT

Total Long Term Interest Bearing Debt

MINORINTBS

Minority Interests (balance sheet)

PROVISIONS

Provisions

TOTLIABDEBT

Total Liabilities and Debt

PREFSHARES

Preferred Shares, Preferred Stock

BOOKVALUE

Book Value, Total Shareholders equity

TOTLIABEQU

Total Liabilities and Equity

CASHEQUIV

Cash and equivalents

TOTINVSEC

Total investments securities

INVUNCONSOLSUBS

Investments in unconsolidated subsidiaries

NETLOANS

Net loans

OTHASSETS

Other assets

TOTDEPOSITS

Total deposits

OTHLIAB

Other liabilities

LTINVOTH

Long term investments other

AFFILIATES

Affiliates

TOTPOLICYLIAB

Total policy liabilities

PROVRISKCHARG

Provision for risks and charges

DEFTAXLIAB

Deferred tax liabilities

SHORTTERMINV

Short term investments

PREPAYADV

Prepayment and advances

OTHCURRASSETS

Other current assets

LEASINVPROP

Leasing and investment properties

STDEBT

Short term debt

CURRPORTLTDEBT

Current portion of long term debt

TAXPAYABLE

Taxes payable

OTHCURRLIAB

Other current liabilities

LTDEBT

Total long term debt

CONVBONDLEASELIAB

Convertible bonds and lease liabilities

OTHLTDEBT

Other long term debt

REDPREFSHARES

Redeemable preferred shares

COMMONSHARES

Common stock, shares

PARTICIPSHARES

Participation stock, shares

TREASURYSHARES

Treasury stock, shares

ADDPAIDINCAP

Additional paid in capital

LEGALRESERV

Legal reserves

SHAREHOLDRESERV

Shareholders' reserves

RETAINEARNINGS

Retained earnings

OTHEQU

Other equity

MINORITIESEQU

Minorities in shareholders' equity

Cash Flows

Keyword

Name

CFOPER

Cash Flow from Operations

CFINVEST

Cash Flow from Investing Activities

CFFIN

Cash Flow from Financing Activities

NETCHG

Net Change cash

CAPEX

Capital Expenditures

FREECF

Free Cash Flow