Hire Experts For Answers
Order NowRelated Study Services
- Homework Answers
- Coursework writing help
- Term paper writing help
- Writing Help
- Paper Writing Help
- Research paper help
- Thesis Help
- Dissertation Help
- Case study writing service
- Capstone Project Writing Help
- Lab report Writing
- Take my online class
- Take my online exam
- Do my test for me
- Do my homework
- Do my math homework
- Online Assignment Help
- Do my assignment
- Essay Writing Help
- Write my college essay
- Write my essay for me
DESCRIPTION
Posted
Modified
Viewed
18
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.
Attachments
The Waterfall Exercise: B&G II LLC
CPPIB is considering a large commitment to B&G’s new fund, B&G V LLC. This would be CPPIB’s first commitment to a B&G fund. Dudley Dorite, MD at CPPIB, has asked his Associate, Antoine Froid, to assess the performance of B&G’s most recent fully realized fund, the £6.5 billion Fund II, vintage year 2003. Antoine has received the following information from V&W management.
Fund Terms:
Committed Capital: £6.5 billion, including management fees.
GP commitment: 3%
Investment period: 4 years.
Post Investment Period Fund Life: 6 years.
Management fee during investment period: 1.5% of LP committed capital (GP pays no management fee).
Management fee post investment period: 1% of LP Invested Capital.
Carried Interest: 20% of fund profits after return to LPs of 100% of their capital invested plus management fees paid, subject to an 8% annual compounding hurdle rate (IRR) on capital invested plus management fees paid and 100% catch-up by GP until profit split of 80/20 LP/GP is reached (see priority of distributions below).
Priority of distributions: (1) return of capital invested by LPs and GP, then (2) return of management fees to LPs, then (3) to LPs and GP until hurdle rate is met on the capital they have invested and the fees LPs have paid, then (4) to the GP until the GP has received 20% of the fund profits, and finally (5) 80% to the LPs and GPs pro rata to their capital commitments and 20% to the GP in the form of carried interest.
Portfolio
Arsenal Industries: invested £135 million in 2003 and £75 million in 2005. Realized £50 million through a dividend recap in 2006 and £180 million through a sale of the company in 2008.
Chelsea Brewers: Invested £482 in 2003. Sold the company in 2006 and realized £750 million
Everton Shops: Invested £210 million in 2003. Sold the company in 2008 and realized £580 million.
Liverpool Manufacturing: Invested £750 million in 2004. Wrote-off the investment in its entirety in 2008.
Aston Villa Grocers: Invested £175 in 2004 and realized £650 in 2009 through a sale.
Manchester Markets: Invested £350 in 2004 and £150 in 2005. Realized £3.5 billion in 2009 through a sale.
Newcastle Toys: Invested £432 in 2004 and wrote off the investment in its entirety in 2009.
Tottenham: Invested £130 in 2004 and realized £250 in a sale in 2007.
Sunderland plc: Invested £255 in 2005 and an additional £450 in 2006. Realized £1.31 billion through a sale in 2011.
Stoke Bakeries: Invested £187 in 2005 and wrote-off the investment in its entirety in 2008.
West Ham Cafes: Invested £650 in 2005 and realized £150 through a sale in an IPO in 2007. Sold the remaining stake in 2010 for £400.
QPR plc: Invested £322 in 2005, sold a £300 million stake in 2008 and realized an additional £1.55 billion in 2010.
Swansea Trading: Invested £480 in 2006. Sold the company and realized £1.1 billion in 2011.
Crystal Palace Networks: Invested £225 in 2006 and realized £715 million in a sale in 2012.
Leeds Linoleum Linings: Invested £180 in 2006 and realized £400 million in a sale in 2012.
Dudley has asked Antoine to calculate the IRR for each deal as well as the gross and net IRRs and MoM for this fund and to show how much the GP has collected in fees and carry. Dudley would also like to see annual cumulative management fees as a percentage of committed capital and capital invested. Antoine realizes that this will require him to put together a waterfall analysis for the fund. Since the analysis is due the next day, he will have to make certain simplifying assumptions. After discussing it with Dudley, Antoine has decided to assume that all investments and realizations occurred on the last day of the year, that management fees were collected at the end of each year based on the committed or invested capital at the beginning of the year, and that the reduction in Invested Capital for deals with more than one distribution would occur on a pro rata basis with each distribution.
Definitions
Committed Capital: the aggregate capital committed by the fund’s LPs and GPs at the formation of the fund.
Investment period: the period in the fund’s life in which B&G is allowed to make investments and draw-down capital from the LPs. Only, follow-on investments for existing portfolio companies can be made outside the investment period.
Post Investment Period Fund Life: the period in the fund’s life in which B&G is expected to harvest its investments. No additional investments can be made except follow-on investments in existing portfolio companies. After this period, the fund must be liquidated unless an extension is granted by the LPs.
Invested Capital: the amount of capital invested by the fund less the cost basis of realizations (distributions and write-offs). Dividend distributions should be assumed not to reduce invested capital for purposes of this calculation. Note: this is different than the term “capital invested” which refers to the capital invested by the relevant parties and remains unchanged despite distributions.
GP commitment: the amount or percentage of Committed Capital committed by the GP.
Fund profits: The excess of aggregate distributions over the capital invested and management fees paid by LPs and the GP.
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
NB: Post a homework question for free and get answers - free or paid homework help.
Get answers to: Finance Homework: Private Equity Distribution Waterfall Model or similar questions only at Tutlance.
Related Questions
- Excel Finance Modeling With Large Data Set
- Bus 201 Business Statistics Due Sunday 8/28
- Financial Lbo Model Over Excel
- Homework 1 Finc-6320-01. Due Sunday By 11:59Pm Points 10 Submitting A File Upload
- Homework 1 Finc-6320-01. Due Sunday By 11:59Pm Points 10 Submitting A File Upload
- Fmva Final Exam Answers............................................
- Scenario: The Organization You Work For As A Director Of Leadership And Learning Is Looking To Create An Adaptive
- Online Exam In International Financial Management
- Online Exam In International Financial Management
- Online Exam Help In Intternational Financial Management
- Managerial Finance For 6 Weeks
- Managerial Finance For 6 Weeks
- Seeking 6 More Weeks Of Managerial Finance Assistance
- Seeking 6 More Weeks Of Managerial Finance Assistance
- Determining Fair Stock Price Using Pro Forma Model
- Determining Fair Stock Price Using Pro Forma Model
- Determining Fair Stock Price Using Pro Forma Model
- Portfolio Management Exam 66% Bond Questions 34% Single Index Model And Capm
- College Of Financial Planning Crps
- College Of Financial Planning Crps
- Stock Price Comparison Against A Market Index
- Stock Price Comparison Against A Market Index
- Helping With An Online Basic Finance Exam
- Finance Online Assignment -Hw & Quiz
- Statistic Exam For Year 1, Can Someone Pls Help
- Assistance With Assignment On Intro Business Analytics Undergrad Course
- Answer Finance Final Exam Questions
- Taking Final Exam Today For Financial Markets Class
- Personal Finance Question Attached Below
- Doing A Spreadsheet With 4 Tabs
- Fmva Final Exam Help Needed Asap
- Fmva Exam To Be Completed. Any Help Is Appreciated
- Mbs Pricing, Duration And Convexity
- Completing An Online Finance Exam
- Advanced Managerial Finance - Excel Project 2 Fin 4424
- Excel - Finance/Investment Case Study
- Fmva Exam I Want To Pass , This Course Is From Cfi
- Dcf Model And Company Forecast
- I Need Help Solving Part A And B In Excel
- Finance Exam Intro To Basic Finance
- Data Presentation Help With A Math Paper
- The Use Of Excel Functions And Commands For 'Down Town Office Supply'.(Analysis)
- Finance Exam On Tvm, Risk And Return, And Bonds.
- Financial Accounting Assignment 1St Year College
- Weighted Averages In Excel And Questions From Spreadsheet
- Corporate Finance Assignment Comparing Two Competitors
- Corporate Finance Theory Exam
- Introductory Python Programming For Finance
- Financial Statement Cast Study
- Online Exam Assistance With Financial Management