first year associate just starting out at my buy-side gig. obviously we have our standard model checks just like anyone else, but am curious if any of the more experience associates out here have picked up any useful model checks / tricks that you use to sanity check your work (esp when it's late and you've been staring at numbers for too long). thanks in advance
| +44 | Future of PE | 8 | 1h |
| +25 | Hardest time I have ever seen to be a GP | 3 | 3d |
| +20 | How to Get on Career Track / Stay Post ASO years | 6 | 1d |
| +19 | Weighing exit from LMM PC/PE | 4 | 1d |
| +18 | Healthcare PE | 7 | 8h |
| +15 | KKR comp for Principal | 20 | 8h |
| +11 | Reality of the move from LMM to MM | 2 | 6d |
| +9 | LMM/MM PE London | 5 | 1d |
| +9 | PE Behaviorals Feedback | 1 | 6d |
| +9 | MBA and Private Equity | 3 | 2d |
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.
Cumulative levered free cash flow = change in net debt (+ equity funding)
Should add this will show 99% of model busts
Cumulative levered free cash flow before mandatory and optional prepayments of debt, correct (i.e., FCF (unlevered FCF - cash interest payments)? Also, you should substract PIK from the levered FCF (if any), no? Otherwise you have the mismatch between actual cash flows and net debt which includes PIK.
Something like this was gonna be my answer - when I learned about this I was so amazed... I use this for very quick and dirty models where I don't have a full BS
What do you include in net debt since there are different ways you can calculate it?
Can you share an xls example? Thanks
Also another pro tip, leave some fake check lines that do random things in the model. When the vp is reviewing it, they’ll spend a lot less time grilling you if they see those
Few to add:
- For things like funds flows, helpful to have a global check that aggregates all of the checks throughout the document, so you don't have to manually go look for busts on all the various tabs
- This wasn't quite the question but a random tip that I've adopted as a reviewer of work - I'm often tasked with confirming that figures tie (e.g., main model vs. ripped out lender model) or haven't changed across versions. I find it helpful to just highlight large amounts of data (e.g., full quarterly P&L for multiple years) and sum via the Excel preview in the corner, then compare to the equivalent source file, rather than spot-checking certain cells or adding an A minus B calc off to the side and messing up my margin area.
What are your standard checks? Sorry newbie here
Not analysts.
Make sure the balance sheet balances.
Illo rerum nemo quos magnam provident optio. Quia maiores eum ratione temporibus atque rerum quae.
Dolorem consectetur eos illo ratione nulla autem omnis rerum. Repellendus maxime corrupti dolores praesentium autem nihil. Aut quam ea perspiciatis quisquam. Non id odit quo repellat unde aspernatur. At dignissimos aut natus quibusdam iure aut. Similique ullam provident tempore consequatur commodi vel.
Sint voluptatem aut et. Eaque alias est quam tempore officiis repellendus quia fugit. Repudiandae vel voluptatem ex quod odio ipsum et. Enim tempora error reprehenderit libero quo.
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...