Finance Coursework: Private Equity Fund Distribution Waterfall Excel Model

Posted Under: Finance

Ask A Question
Viewed 19
Private Equity Class homework: build an PE fund distribution waterfall excel model. Should not use hard coding in excel. All input data are in blue, output or link data are in black. Attached is the homework requirement and useful material.

This order does not have tags, yet.

P r i v a t e E q u i t y Fu n d D i s t r i b u t i o n Wa t e r f a l l P E F i n a n c e P r i v a t e E q u i t y Fu n d S t r u c t u r e P E F i n a n c e 3 Fund Economics- Main Entities - Full investment discretion - Responsible for management services - Determines and reports quarterly fund valuation - Has fiduciary duty and duty of care to LPs The investors in the fund are comprised of two entities: o Limited Partners (vast majority of investors) o General Partner (entity formed to manage the fund) General Partner Limited Partner - No involvement of the daily management of fund - Limited liability o Limited to amount committed to fund - Normally has priority over GP’s in fund distributions 4 Fund Economics- Main Entities General Partners must invest their own capital into the funds that they raise o Expected to put up money to (have “skin in the game”) o Percentage is variable and market driven. o The more capital the GP commits the better sign for the LPs o The GP’s investment is treated as an LP investment with regards to distributions (i.e. if the GP commits 5% of the capital, it is entitled to 5% of LP distributions) o However, the GPs commitment is not subject to management fees. Note: References to LP distributions in this deck include distributions to the LPs and to the GP as an LP Fund Structure - Main Entities 5 Private Equity Fund (LP or LLC) Limited Partners (Outside Investors) General Partner (LLC) Investment Individual Fund Managers: Partners and Employees of Management Company Pro Rata Net Distributions Drawdowns Carried Interest Carried Interest & Pro Rata Distributions Company A Company B Company C Company D Portfolio Distributions Managem ent Fees Pro Rata Net Distributions Drawdowns Managem ent Company: PE Firm Management Services Management Fees Management Services Drawdowns Fu n d L i f e P E F i n a n c e 7 Fund Life Overview Fund-Raising Period Drawdown(Investment Period) Post Investment Period Extension Investors commit capital to fund Capital is called from investors over a time as investments are made Distributions: Cash Flows back to Investors Existing portfolio investments Only occurs with vote of approval from LPs 6-24 months 4-6 years 4-6 years The period the launch of the fundraising and final closing of investor commitments The GP has the discretion to draw-down capital and make investments The GP may draw-down capital to invest in existing portfolio companies but cannot make new investments GP can request extra time to exit the final portfolio companies, and wind-up. 1-2 years Note: There are often several closings, but the fund may begin operating after the first closing R E A L I Z A T I O N S , R E T U R N S & E X I T S 8 Fund Life: Drawdowns During Investment Period The capital that is committed by limited partners to a private equity fund, “Committed Capital”, is not invested immediately but rather drawn-down and invested over time as investments are identified. Funds are drawn-down on a “just in time basis” because otherwise this capital would be idle and reduce IRRs Vintage Year: The first year that the private equity fund draws down or calls committed capital Capital Call: The legal right of the fund to demand a portion of the money committed to it by an investor. Glossary Investors are free to do whatever they want with the committed capital until they receive a draw-down notice (aka “capital call”), after which they must send-in a prorated share of the investment, normally within a 2-week period GP identifies an investment opportunity NOTICE Investors receive a draw-down notice 9 Fund Life: Drawdowns during Investment Period What happens to the uninvested committed capital? Any committed capital that is undrawn by the end of the investment period is released (i.e., capital is never drawn). o LPs are no longer subject to capital calls on uninvested, committed capital. o Undrawn committed capital has no impact on IRR. 10 Fund Life: Post Investment Period Once the investment period has expired, the fund will be no longer make investments (except follow-on investments) and will focus on creating value in its portfolio companies and on exiting its investments. o The fund is a self-liquidating entity: it makes investments and eventually exits them and returns the proceeds to its investors via distributions o Some funds have recycling provision that allow them to re-invest distribution proceeds that were generated (normally) within 18 months of the underlying investment or throughout the investment period generally. 11 Fund Life: Post Investment Period (Continued) Note: If the fund managers don't expect to recover any value from a particular investment, it must be ‘written-off’. Write-off’s have negative IRRs. o Proceeds are distributed to LPs and GPs as determined by the limited partnership agreement (“LPA”), the main governing document in PE fund. o By the end of the fund life, the GP must have divested all the deals and returned all proceeds to its investors. o If the fund requires a timeline extension, they must request it from its LPs o This is a better alternative than having a “fire sale” based on timing Fu n d Fe e s P E F i n a n c e 13 Fund Fees: Investment Period The GP is paid for services it provides to the fund o Management fee o Used to pay operating expenses of PE fund/firm o Tends to be circa 1% for large funds and 2% for smaller funds o During the Investment Period, it is paid as a function of Committed Capital at the start of the fund o Remains constant throughout the Investment Period. o Carried Interest o Success fee (20% of realized fund profit) o Realized Fund Profits = Cumulative distributions – cumulative management fees – cumulative capital contributions o M&A fee (for closing a deal) o Monitoring fee o Exit fee Charged to the portfolio companies but eventually returned to LP via a reduction in the management fee. 14 Fund Fees: Post Investment Period o At the expiration of the Investment Period, management fees step down to about .5%-1% and normally become a function of Invested Capital rather than Committed Capital o Invested Capital = cost basis of capital contributions o Invested Capital is reduced by the cost basis of every distribution and write-off o Every share that is sold has a cost basis attached to it. o Dividend and interest distributions do not affect Invested Capital because no shares, and therefore no cost basis, is being sold. o If an investment is written-off, its cost basis is removed from Invested capital o Invested Capital should equal zero at the end of the fund-life. o Therefore, management fees will decline throughout the post-investment period as investments are exited 15 Management Fee Over the Fund Life Investment Period Step d ow n Post Investment Period Note: Once the fund is past the investment period, the GP’s attention is divided between the current fund and its successor fund and the management fees from the successor fund will likely make-up for the fee reduction in the current fund. M a n a g e m e n t F e e s Note: The step-down is a vertical line because when the fund flips from the Investment Period to the Post Investment Period, the fee % declines AND the basis flips from Committed Capital to the (probably) lower Invested Capital Fee = 0 Time 16 PE Fund Returns PE fund returns are shown on a gross and net basis o Gross returns = returns generated by the fund before deductions for management fees, carried interest, and fund expenses. o Gross multiple of money (“MoM” or “MoIC”) = (cumulative fund distributions + NAV of remaining portfolio)/ (cumulative capital contributions) o Gross IRR = portfolio or fund level IRR = IRR implicit in cash flows above. 17 PE Fund Returns (Continued) o Net returns = returns generated to LPs, i.e., gross returns minus management fees, carried interest and fund expenses. o Net MoM or MoIC = (cumulative fund distributions to LP + NAV of remaining portfolio adjusted for carry payable on NAV)/(capital contributions by LPs) o Net IRR = IRR to LPs (based on net cash flows above) o LPs assess fund performance based on net IRR/MoM o A large gap between gross and net returns signifies large fees collected by GPs 18 Post Investment Period Fund Life: Illustration Capital Returned Capital Invested C a sh F lo w Time (years) Investment Period Manager “calls” call from investors Investments are realized, cash is returned to investors 19 The J Curve Net IRR N et R et u rn s Time (years) Note: In the early stages of a fund life, the management fees may exceed the portfolio value write-ups, putting the fund in a net loss position. As such, net returns tend to be negative at the very beginning of the fund life. D i s t r i b u t i o n Wa t e r f a l l s P E F i n a n c e 21 Distribution Waterfall Overview Once the fund sells a company, what does it do with the proceeds it collects? o Distribution waterfalls determine the split of each distribution between LPs and the GP. o The specific terms of the distribution waterfall are documented in the fund’s LPA. o Waterfall provisions broadly fall into one of two categories: so-called American or European or 22 American Versus European Waterfalls American European GPs of the fund may not collect carried interest until the limited partners have received all their capital contributions, including management fees, plus a pre-determined rate of return (the “Preferred Rate” or “Hurdle Rate”). GP’s may collect carried interest from profits generated by individual investments as these are exited. The fund need not have returned the LPs aggregate fund capital contributions before such carry distributions are made. GP favorable LP favorable 23 American Waterfall: Issues o Carried interest is distributed to the GP on profitable investments regardless of losses that may be incurred on subsequent investments o This creates the risk of excessive carry payments: i.e., carry payments might ultimately exceed 20% of fund profits if positive returns from early distributions are subsequently eroded by poor deals. 24 American Waterfall: Risk of Excess ive Carry Payments to GP Example: A fund exits its first deal at a profit but exits its second deal at a loss. By paying carried interest on a deal-by- deal basis, GP payout might ultimately exceed the 20% of total fund profit. There are two mechanisms used to mitigate this risk: ESCROW ACCOUNT o A portion of the carry distribution is placed into an ESCROW account as a reserve for potential future losses CLAWBACK CLAUSE o After the end of the fund life, excessive carry payments can be clawed-back by the GP and returned to the LPs o It can be difficult to collect claw-backs. 25 European Waterfall Overview Note: Hurdle rates are generally 8% because this was the risk-free rate at the time they were introduced. LPs demanded at minimum the risk-free rate of return before GPs could collect carried interest. The hurdle rate has mostly remained at 8% despite significant reductions in the risk-free rate. o GP does not receive carried interest until all the LPs capital contributions including management fees are returned and the LPs earn a realized net IRR equal to the hurdle rate o Management fees are repaid to the LPs through portfolio exits distributions. Therefore, management fees function as non-recourse advances on the carried interest. 26 European Waterfall Steps STEP 1: Return of LP Contributed Capital Distribution of 100% of exit proceeds to LP’s until each of them has received 100% of its aggregate contributed capital for investments, management fees, and fund expenses Step 2: Hurdle Rate Distribution of 100% of exit proceeds to LPs until a they have earned an 8% realized (hurdle rate) IRR. During this phase, the fund has generated a profit and therefore owes carried interest to the GP. Step 3: GP Catch Up Distribution of 100% of exit proceeds to the GP until it receives carried interest equal to 20% of accumulated fund profits (i.e. the owed but unpaid carry from Step 2) Step 4: 80/20 Split Distribution of remaining exit proceeds in the ratio of 80% to the fund’s LP’s and 20% to the GP. As a result, at the end of the fund life, carried interest will equal 20% of realized fund profit provided the net IRR exceeds the hurdle rate. 27 European Waterfall: Hurdle Rate o Realized IRR to LPs (net IRR) the must exceed the hurdle rate before the GP can be paid carried interest o Each time there is a distribution, the net realized IRR is calculated to assess whether hurdle rate has been reached. o Only when that net IRR crosses the hurdle rate can the fund pay carry to the GP, initially as a catch-up payment o Net IRR calculation is based on the amount and timing of capital contributions made and distributions received by the LPs Note: Carried interest is calculated based on capital invested, not committed, so it is possible for the fund to temporarily exceed the 8% hurdle rate and subsequently fall below it if all the committed capital is not yet invested 28 Management Fee Return on Principal 8% Rate of Return Distribution To LP Before Catch Up Distribution To GP to Catch Up Catch-Up (Carry paid to GP) Prior Distributions( to LPs) European Waterfall: Catchup Period Note: The GPs will continue collecting management fees after the catch-up has been achieve and will continue to return such management fees to the LPs with every subsequent distribution. The catch-up clause is designed to compensate the General Partner on a fund’s total realized profit, not just the profits in excess of the hurdle rate. Once the hurdle rate has been achieved, the General Partner receives 100% of fund distributions until it has “caught up” to 20% of realized fund profits. 29 European Waterfall LP Payoff Curve 0 1 2 3 4 5 6 7 8 9 10 0 1 2 3 4 5 6 7 8 9  Capital Distributed By the Fund Am ou nt R ec ei ve d by L im ite d Pa rt ne rs Eve ry D olla r Of Dis trib utio n Is Pai d To L P U ntil Hu rdle Ra te I s Re ach ed (Slo pe = 1) Catch Up Period. Marginal Distributions to LPs = 0. (Slope = 0) GP g ets 2 0% a nd LP g ets 8 0% (Slo pe = .8) Slide 1 Slide 2 Slide 3 Slide 4 Slide 5 Slide 6 Slide 7 Slide 8 Slide 9 Slide 10 Slide 11 Slide 12 Slide 13 Slide 14 Slide 15 Slide 16 Slide 17 Slide 18 Slide 19 Slide 20 Slide 21 Slide 22 Slide 23 Slide 24 Slide 25 Slide 26 Slide 27 Slide 28 Slide 29
Explanations and Answers 0

No answers posted

Post your Answer - free or at a fee

Login to your tutor account to post an answer

Posting a free answer earns you +20 points.


NB: Post a homework question for free and get answers - free or paid homework help.

Get answers to: Finance Coursework: Private Equity Fund Distribution Waterfall Excel Model or similar questions only at Tutlance.

Related Questions