Does anyone have a Search Fund acquisition model they could share?
May 20, 2021
by a searcher from Emory University in Chicago, IL, USA
May 20, 2021
by a searcher from Emory University in Chicago, IL, USA
from The University of Chicago in Chicago, IL, USA
I'm exploring a free offer (or something close to it) to first few Searchers on SF.
The product is highly interactive for what-if analysis and decision making for M&A transactions. The two products are:
1) A pro-forma financial model: The product provides pro-forma financials, cash flow after debt-service and IRR. Some of the inputs are: S Corp, vs C Corp., Asset vs. Stock purchase, different types of financing options, etc. Purchase multiple and exit multiples are inputs. Output values are cash flow after debt-service and IRR.
2) A valuation model: Here, the output is a) purchase multiple and b) buyer's required $ equity. The program runs pro-forma financials with all the inputs described in #1 above but under different values of a) and b). It determines the one (and there exists only one) combination of a) and b) that simultaneously satisfies multiple requirements of all the parties in an M&A transactions; these requirements are seller expectations, buyer expectations (IRR and minimize equity), lender expectations of debt service, availability of debt and equity capital. taxation, business's need for working capital & CapX, etc.
Feel free to reach me. redacted & ###-###-#### .
from Cornell University in Toronto, ON, Canada
https://docs.google.com/spreadsheets/d/1o8ZOiIhflXzIfbkif58jEqndy_ixfjWImBOxjIc9TnU/edit#gid=0
This model is the foundation of what I now use for quick analysis of Search Fund opportunities. Just check it for hard-coded cells and make any adjustments that you need/want. It's also worth noting that this model matches some of the material from the latest Stanford GSB Search Fund primer if you've looked through that.