• 066 05/02/2017

    One of the challenges you will encounter building monthly debt schedules is the need to calculate and show interest expense in each month, and then reflect the payment of interest at the end of the quarter. This video provides a helpful approach.

    Click on the icon in the lower right-hand corner of the video player to expand to full screen.

    The template used in the video is available for download: Download Template

    What you will learn in this video:

    1. How to use =MOD() in an =IF() statement to calculate quarterly interest payments.
    2. Multiple uses of the =OR() function.


  • 065 04/28/2017

    This video explains how the =SUM and =OFFSET functions can be combined to write a formula that will sum a specific number of cells. This is especially useful when you are working with monthly data, and showing quarterly and annual periods in a financial model. The video also explains why using the =SUM formula for this purpose can lead to errors.

    Click on the icon in the lower right-hand corner of the video player to expand the view to full screen.

    The template used in the video is available for download: Download Template

    What you will learn in this video:

    1. Why =SUM() has limitations.
    2. How the =OFFSET() function can be used to return arrays.
    3. How to effectively use =SUM and =OFFSET together.
    4. How to use F9 to audit formulas.


  • 064 04/12/2017

    Before discussing the economics, I thought a definition of a fundless sponsor would be helpful. An article in The Economist provided an excellent example: “The typical search-fund principals are MBA graduates from an elite American university, who raise $400,000 or so of “walking around money” from investors, who purchase a stake in the fund for about $40,000 a share. The fund searches for a high-growth, high-margin target, valued at $5m-20m. The fledgling businessmen then hold a second round of acquisition financing, as well as raising debt. Their tenure as bosses lasts until they sell out.” [1]

    The article itself is concise and worth the read. Even the title is appropriate here: “Seek and We Shall Fund: Private Equity for Absolute Beginners.” The only point I would argue is that I have met many fundless sponsors that had very different backgrounds from the MBA graduate background described.


    In negotiations, you will constantly hear what one side believes is “market.” In my opinion, the variance surrounding structures is too great to consider anything standard for a specific transaction. That said, there are generally three components, which listed in order of importance, are as follows:

    Promote - in a transaction this is the equivalent of carried interest. At most private equity funds it is equivalent to 20%. The Limited Partnership Agreement stating how this is earned might read as follows:

    First, 100% of all cash inflows to the Limited Partner ("LP") until the cumulative distributions equal the original capital invested.

    Second, 100% of all cash inflows to the LP until the LP has received a preferred return on the capital invested in step 1.

    Third, a "20% catch-up" to the General Partner ("GP") equivalent to 20% of the distributions realized in step 2 plus the distributions realized in this step.

    Fourth, thereafter, cash flows in excess of distributions made in step 1, 2 and 3 (if any) are distributed 80% to the LP and 20% to the GP.

    Promote Details:

    Of the three components, the promote is probably where I have seen the greatest amount of variation. The variables to consider are as follows:

    Preferred Return: In many transactions the investors are entitled to a preferred return of 8% (although I have seen it dropping in this market) before the fundless sponsor earns a promote. The greater the preferred return, the more difficult it will be for the fundless sponsor to earn a promote.

    The Catch-Up: A catch up kicks in once the investors have received their capital and a preferred return (if there is one). At this stage, all dollars go to the fundless sponsor until the distributions equal the promote. This can be calculated to include all dollars invested, or just the preferred return (this detail can make a significant difference). It is also not uncommon to see a catch up excluded.

    Multiple Hurdles: The fundless sponsor might be willing to start with a smaller promote so long as there is potential to achieve greater upside in the event of a more spectacular outcome. As an example, a fundless sponsor might negotiate a 10% promote at an 8% hurdle rate so long as the fundless sponsor can earn a 30% promote if a 30% IRR is achieved (30% would be the “hurdle rate”).

    There are additional variables to consider surrounding the promote (or carried interest) at a fund, but with a single transaction, those are the primary variables.

    (Note: Promote, the carry and carried interest are all generally used interchangeably.)

    Click here for more examples.

    Management Fee - At a fund this would generally be equivalent to 2% of assets under management (AUM), but for a fundless sponsor the fee is hardly ever tied to AUM. Generally what you will see is a structure calling for the greater of a flat fee or some percent of earnings. It will also typically be capped. For example:

    A management fee will be payable to (insert fundless sponsor) in the amount of the larger of (i) $250 thousand per annum or (ii) 5% of annual EBITDA.

    I provide the figures above as examples of structure, but the figures can vary considerably.

    One-Time Fees - It’s not uncommon to see a closing fee included. This sum can range from $50K to $1M depending on a variety of factors. Some portion of the fee generally gets reinvested in the new entity as well. (I have seen some pretty aggressive pitches including multiple one-time fees where it starts to add up. For example, asking for a closing fee, fees for board seats, fee for a successful exit, etc.) 

    The challenge is that no two transactions will be alike. The fundless sponsor might have strong industry expertise, or be a recent MBA graduate. The deal could be secured under LOI at a very attractive multiple, or in the midst of an auction process. The fundless sponsor might be investing a considerable portion of his own net worth, or taking zero risk. All of these variables, and many others, will influence the outcome.

    If you are considering a career as a fundless sponsor, my advice would be to do as much of the work as possible before negotiating terms. An MBA student with no prior experience will get little attention, but a talented industry veteran with a transaction under LOI at an attractive valuation will have the leverage necessary to negotiate the terms desired (it’s especially true in this market).

    [1] Seek and We Shall Fund: Private Equity for Absolute Beginners



Models are:
A) really boring
B) pretty sweet
C) super important
D) somewhat easy
E) kind of hard
F) fun
G) all of the above



*Answers a, b, c, d, e, f and g are all correct.