Recently started in PE from more of an operations consulting background so am not super familiar with CapIQ and PitchBook. My firm has both and just wondering if there's a way to autmoatically pull the 3 financial statements into excel quarterly for the past few years?
Can anyone give a brief explanation on how to do this - I think it's possible, but not 100% sure.
| +134 | Restructuring: Anti-climactic Experience | 36 | 3h |
| +109 | IB Net Worth / Savings Check | 51 | 3h |
| +99 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 25 | 1h |
| +81 | Stop sleeping on UBS - it’s pretty good | 28 | 1h |
| +52 | 2026 VAULT PRESTIGE RANKINGS | 30 | 4m |
| +39 | AI + Financial Modelling | 12 | 1d |
| +31 | Hardest interview experiences? | 16 | 1d |
| +28 | Summer before college | 17 | 18h |
| +26 | Current State of UBS in North America | 8 | 2d |
| +23 | Cold apply for FT recruiting? | 5 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Bump
Call the capIQ helpline, they are super helpful and will explain it to you
Unnecessary
Why?
Super easy- pull up the company page > go to financials / valuation on the left side panel > click on income statement > select the time range you'd like > select the "quarterly" function on the period type > close to the top of the page should be a "download financials" button, click on that. I'll say this- I never trust CIQ for my financials, especially income statement items. There's a lot of adjustments / reclassifications that are made in their financial statements. I always hard code my financials from 10ks and 10qs. It takes more time, but at least you know you're getting the correct information rather than some adjustment made by CIQ that you can't explain.
Don't rely too much on these.
I download the CapIQ and audit by checking with the 10Q and 10K. Sometimes you need to make minor adjustments, sometimes you need a complete overhaul then you might as well directly hard code from financials. It depends. You can decide after comparing the CapIQ and 10k initially since sometimes it’s not necessary.
Another tip for OP is that you can expand the line items with the + icon on the name. For example, CapIQ will reclassify OpEx and consolidate SG&A, you can expand to see the breakdown of S, G&A. The expansion/drop down will appear in the downloaded.xls file as well.
It will always depend on the circumstance - line items specific to the industry you might want to look out for and don’t want them to be reclassified by CapIQ.
Quo recusandae aliquid aut aspernatur natus. Dolores eveniet dicta iusto odit aliquam omnis numquam dolores. Eos nobis vero esse natus.
Voluptatem rerum voluptatem omnis quasi saepe. Ea repellendus molestiae hic sint accusamus officiis nam excepturi. Numquam neque provident ratione autem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...