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
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.
Attachments
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 Coursework: Private Equity Fund Distribution Waterfall Excel Model or similar questions only at Tutlance.
Related Questions
- Finance Homework: Private Equity Distribution Waterfall Model
- 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