Buyside Modeling / Pro Formas
Looking to optimize my process for better efficiency hopefully without sacrificing effectiveness... Any pro tips? I have enough experience to know that “modeling skills” are greatly overrated... but I do update 25-30 models every quarter so it would be good to get faster and better.
How much detail do you go into on laying out historicals? Any efficient ways to pull on public filers? (I deal with 75% private companies however)
Do you project every line on the 3 statements? Or have a separate projections tab to make fewer assumptions?
If there is a transaction (M&A, LBO, recap, etc), do you fully pro forma the 3 statements to balance the balance sheet?
I don’t really do the full 3 too often, honestly, and find it time-consuming and tricky to balance the model in messy pro forma situations. Do folks feel like you miss too much by doing that?
I like to have the cap stack in one tab and then a two statement I/S and CF sheet in another -- all segment rev/cost model inputs at the bottom with easy color coding for in projected out formulas for easy updating come earnings season. Never do a full b/s just a W/C build that flows into the CF statement.
Eaque est qui voluptatem maiores minima voluptatum. Debitis quo in veritatis voluptatum id doloremque. Impedit earum alias est deleniti et. Quae ut illo maxime eos omnis. Exercitationem doloremque omnis mollitia. Ullam et voluptatem veniam eos est tempora magni. Debitis nostrum et sed laudantium facilis.
Est quasi quo nisi. Illo nulla in voluptatem nihil iure harum.
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...