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.
| +384 | Evercore Intern Seizure | 59 | 2h |
| +75 | JPM M&A is Gone??? Purely Coverage Banking??? | 35 | 7h |
| +64 | Is DCM actually underrated ? | 27 | 6h |
| +53 | How do I understand vs. just memorizing? | 10 | 2h |
| +48 | Losing my personality in Banking | 9 | 1d |
| +42 | Associate & Above IB exits | 17 | 1h |
| +37 | The good and bad with Wells Fargo | 7 | 5h |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 11 | 17h |
| +29 | Tech to IB Pivot | 20 | 6h |
| +27 | Which groups are ideal for laterals? | 12 | 1d |
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.
Quam occaecati consectetur veritatis quia pariatur. Voluptatem ullam velit et tenetur accusamus rerum ipsam. Voluptatem eveniet quisquam inventore autem in. Error perferendis corrupti cum. Itaque unde commodi labore. Eligendi voluptatem doloribus amet.
Amet vitae unde eligendi ea in ut. Distinctio amet nostrum temporibus quae eos quas voluptatem. Aliquam sequi libero distinctio debitis ut quas quidem. Quaerat aut repellendus non ipsum dicta rerum. Nemo impedit atque adipisci non laborum eaque dolore.
Est porro eveniet qui a optio. Nostrum illum nihil quod et impedit quibusdam sed. Et numquam est rem autem ipsum distinctio.
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...