Capiq Formula Sheet

Includes income statement balance sheet cash flow statement supplemental line items and ratios for a selected company with a dropdown to choose period type and order of periods most recent on the leftmost or rightmost column.

Capiq formula sheet. They are known for top notch customer service and actually answering questions sometimes walking you through how to build formulas if needed. Here are various forms of contact if you don t have a direct contact already. Double click the sheet tab enter a new name for the worksheet and press. Right click the sheet tab and select.

We would like to show you a description here but the site won t allow us. Right click the sheet tab and select. The capital iq platform provides research data and analysis on private public. S p capital iq s excel plug in.

Ciq excel cheat sheet june 2012 free download as pdf file pdf text file txt or view presentation slides online. Using formulas if you are one to rely more on memory there is formula nomenclature your can write to bring in these pieces of data. Capiq excel plug in formula builder basics. Capiq short for capital iq is a market intelligence platform designed by standard poor s s p.

86 10 6569 2745 australia. Client support hong kong. The platform is widely used in many areas of corporate finance including investment banking equity research asset management and more. This formula will produce a net capital expenditure number meaning if there are any dispositions of pp e in the period they will lower the value of capex that is calculated with the formula.

On subsequent tabs it allows users to view common size income statement and balance sheet data input company. 65 6530 6546 japan. 257157748 ciq excel cheat sheet june 2012. Not all fields are available to all data types so you may want to wrap your formulas with iferror formulas if you are comparing separate data types ie currency wouldn t have the employee count field available to it.

81 3 4550 8272 china. Frequently used formulas balance sheet income statement cash flow statement cash and equivalents iq cash equiv total revenues iq total rev net income iq ni cf short term investments iq st invest cost of revenues iq cost rev depreciation amort total iq da cf total cash st investments iq cash st invest cost of goods sold iq cogs asset. Hedge fund business plan. 852 2533 3565 singapore.