Excel model for equity vesting using IRR + MOIC
January 30, 2026
by a searcher from The University of Chicago - Booth School of Business in St. Louis, MO, USA
Hi all,
I'm starting a search and in discussions with potential capital partners. I'm considering both self-funded and traditional search. One area I'm trying to get sharper on is defining return structure/equity vesting for different partner and deal constructs that align incentives and appropriately compensate for investor risk & searcher performance. Would love to model out a few scenarios (e.g. based on different deal sizes, IRR, MOIC, whether self-funded vs traditional search, etc).
Saw this post, which was a good starting point (https://searchfunder.com/post/excel-template-on-the-economics-of-a-traditional-search-fund). Have others modeled equity splits/vesting schedules in xls with blended IRR/MOIC metrics they'd be willing to share or discuss?
Thanks!
Pat
from University of Virginia in Tampa, FL, USA
from Yale University in New Haven, CT, USA