Anyone built a financial model that mimics the Stanford Primer's returns?

by a searcher from Harvard University - Harvard Business School

3 years ago

I ran into a few problems trying to match their results.
1) In Structure 2, why do the principals not own more than 30% of common stock if they paid off the entire portion of redeemable preferred equity (RPE)? If RPE was 35% of equity, and is now zero, then the principals should own 30%/(100% - 35%) = 46% of common stock at the time of the sale. What am I missing?
2) What are the interest rates and terms of the loans you used? With Senior Debt @ 4% over 7y and Seller Debt @ 6% over 7y, I get a negative FCF in year 1.

Happy to dive through and discuss the numbers on a call.

8 likes
296 views
15 comments

searcher from Harvard University - Harvard Business School

Feel free to use this model, just make a copy of it to your own drive. It is built to allow different interest rates, loan terms, and any of the scenarios listed in the search fund primer. The numbers don't match theirs exactly but they are pretty close. The 2 sheets let you see the difference of paying the redeemable down first or the loans. If the loan covenants allow it, it is always better to pay the redeemable first since it has a higher interest rate and it will increase investor IRR and therefore the % of common that you receive.

3 years ago | like reply | 3 likes

searcher from Harvard University - Harvard Business School

https://docs.google.com/spreadsheets/d/1Nbky_1NkVjkyW-5ENkcpeFihvdGZYKEOuhhrYaJZnDI/edit?usp=sharing

3 years ago | like reply | 7 likes

More on Searchfunder

Just Closed on My First Deal! Reflections and Takeaways for other Searchers

45,152 transactions are available on Searchfunder (now searchable by keyword)

Now everyone has unlimited IBISWorld access

Family office looking for traditional searchers

Examples of self-funded searcher websites

Investor seeking Self-Funded Search Deals

What are market terms for Seller Notes?

2 Best Ways To Find Motivated Sellers, Off-Market Deals

Searchfunder is an online community and toolkit for searchfunds. Over 80% of those involved in searchfunds maintain a Searchfunder.com account to help them network, problem solve challenges, and keep up with the industry.

We maintain partnerships with database providers that make searching more effective, efficient and affordable along with features that help searchers find deals and investors and vice versa.