Looking for spreadsheets to help me model out search funds over time

searcher profile

July 28, 2023

by a searcher from Hamilton College in New York, NY, USA

Hey team—

Newbie here. I'm looking for detailed spreadsheets (or a library of spreadsheets) on the search fund P&L structures and models. Best I've found is this: http://www.alyeskaintl.com/wp-content/uploads/2012/07/2020-Search-Fund-Economics.pdf – but, it's really thin on the details.

Not sure if there's a library on searchfunder.com or elsewhere, but would really appreciate not having to try to build from scratch something I somewhat understand.

Appreciate it!

1
9
161
Replies
9
commentor profile
Reply by a searcher
from Temple University
The tricky part about this is that deals are just different enough that you're going to have to customize the model...But if you don't know how to build it, then you're not going to have the confidence that your adjustments are appropriate. That's the age-old modeling dilemma that every banker kindof figures out for themselves...Do you build a really complicated model ONCE that tries to do everything but might not be perfect for each situation, or do you build custom models for every single deal that are short and sweet but do exactly what you want? I've settled on simple models for each deal. Also, building onto someone elses model is asking for trouble becauseyou might not understand how their numbers flow through and truthfully, it's going to take you longer to figure it out than it would to just build your own. That's at all skill levels.

When I build models, I start with a tab for all of my assumptions. Everything references that dynamically. Then I model the income statement, BS, and CFS...Then you can build out your DCF...From there the cap structure, then the S&U. It follows logically...first you spread the financials, then you build the valuation, then you drop that valuation into your deal. Every lender is going to want to see your capitalization and S&U. Those are like the first two tables I look at to know exactly what you're trying to do, so building everything separately means you can copy-paste the tables right into PPT for your lender presentation (LP).
commentor profile
Reply by a professional
in Jaipur, Rajasthan, India
Don't really have any existing spreadsheet or so, but if you might need help with something to build from scratch but struggling to make it in a manner that it gives you information in a consolidated manner, easy to understand, updates automatically and so, I might be able to help.

I won't say I am 100% confident without knowing what you need, but I have spent some good time with spreadsheets and can create good stuff in it.

I can be found at redacted
commentor profile
+7 more replies.
Join the discussion