Essay Writer » Essay Blog » Business Essays Help » Private Equity Individual Assignment

Private Equity Individual Assignment

Question 1 (3 points)

What are the key difference between VC (Venture Capital) Private Equity and Buyout (LBO) Private Equity ?

Question 2 (8 points, 4 points each)

Interesting Microsoft transactions took or are taking place recently. Let’s find out about the actual prices/multiples paid (as per data available on the announcement date). Using publicly available information (and publicly available financial statements) your task is to calculate LTM (last twelve months) transaction multiples (/Revenue; /EBITDA; /EBIT) for:

1. Microsoft’s (proposed) acquisition of Activision Blizzard (announced on January 18th 2022);

2. Microsoft’s (completed) acquisition of Nuance Communications (announced on April 12th 2021);

Show your calculations. We are interested in FV/EBITDA; FV/EBIT, FV/Revenue multiples.

Question 3 (2 points)

Describe a typical acquisition capital structure in Leveraged Buyout transactions?

Question 4 (2 points)

Comment on the validity of the definitions of Minority Interests (MI) & Minority Interests Provisions (MIP) listed below ?

MI – Asset item showing our minority ownership in an entity > 50% owned by someone else.

MIP – Portion of the  net income ( losses) of  entities that are > 50% owned by someone else.

Question 5 (2 points)

You are looking at a potential LBO target. It has no debt on its balance sheet, What impact will this fact have on expected returns (increase, decrease, no impact) to the financial investor?, and why ?

Question 6 (3 points)

ROE can be expressed in terms of ROIC (Effect of leverage).

  1. How ?, show the relationship between the two performance metrics.
  2. Explain the key conclusions (from Equity/Private Equity perspective) that flow out of the relationship.

Question 7 (3 points)

What is the difference between bank debt and high-yield debt?

Question 8 (2 points)

In an LBO transaction, is it possible for debt investors to get a higher return than the PE sponsor firm? Why or why not ?

Question 9 (2 points)

Explain the difference between contractual and structural subordination ?

Question 10 (3 points)

List/describe three initiatives buyer can undertake post buyout closing that are completely under his/her control. Explain how each will either lead to value creation or will prevent value destruction.

Question 11 (2 points)

From a Private Equity (Seller) perspective, list (in bullet points) key advantages and key disadvantages in arriving at the final equity price by using the Locked Box (vs. Completion Accounts) mechanisms.

Question 12 (2 points)

In a standard SPA (Share Purchase Agreement) …

  1. What is a “ covenant” ? Give example of one.
  2. What is a “ indemnity” ? Give example of one.

Question 13 (2 points)

Discuss the relative merits, strengths and weaknesses, (from the selling PE perspective) between exiting an investment via a sale to a financial buyer and a leveraged recapitalization.

Question 14 (7 points)

At closing there is a (verifiable) shortage in the Employee Pension Fund of $50.

Target owns 90% of a subsidiary company with a market capitalization (assume at closing) of $100.

Signing of the SPA is anticipated for June 30th 2023;

Closing of the transaction is anticipated for October 31st 2023 and the B/S data (above) are as expected at closing;

Closing W/C balance is equal to 1x the LTM average. LTM average is what both parties agreed to.

Verification of Company financials at closing showed that the average monthly Capex & Marketing spent between signing and closing was 50% of the $6/month agreed to and listed as a covenant to in the SPA).

Parties have agreed that within a week after closing the Buyer will make to a $20 bonus payment to the current/exiting management team.

Between Signing and Closing the business generates $10/month of FCF which is accumulating on the Balance Sheet.

Assuming that the seller and the buyer are both rational individuals and that they will manage to negotiate what economically belongs to each of them … what will be the:

1. Price listed in the SPA;

2. Will it (point 1 just above) be a Firm Value or Equity Value price listed in the SPA?

3. Ultimate price or price/share paid to the seller at/around closing.

Question 15 (7 points)

Basic LBO model.

Fill in the empty cells in the LBO model shown below (all other cells have been properly filled in).

FYI: rollover equity refers to the equity stake the seller is retaining (i.e. not selling, not part of the transaction).

I/S, B/S and C/F statement (below) are provided.

Sources of Funds  Cash %PIK %PIK TermsAmount% CapEBITDAMaturity
Revolver7.0%10.02.8%0.3x
Senior Bank Facility6.5%70.019.7%2.3x7 Years
Senior Notes9.0%50.014.1%3.7x10 Years
Sub Notes10.0%10.0%3 Years40.011.3%4.9x10 Years
Senior Preferred14.0%5 Years40.011.3%6.0x10 Years
Total Debt & Preferred210.059.1%
Sponsor Equity120.033.8%
Roll-over Equity0.00.0%
Total Equity120.033.8%9.5x
Existing Cash / Liquid Assets3.0%25.57.2%
Total Sources of Funds100.0%10.2x
          

 

Uses of Funds  Amount% Cap
Purchase of Equity67.5%
Debt / Preferred Refinancing28.1%
Provide Liquidity3.00.8%
Transaction Costs2.0%2.0%
Financing Fees2.5%5.31.5%
Total Uses of Funds100.0%

Pro Forma Ownership  CommonCommonWarrantsFully Diluted
    %%Ownership
Sponsor Equity120.0100.0%
Roll-over Equity0.00.0%0.0%
Sr Preferred7.5%6.3%
Sub Notes2.5%2.1%
Sr Notes
Management10.0%8.3%
Total Equity  120.0100%20%

Balance Sheet Adjustments
    2022 Adjustments 2022
(USD in millions, except otherwise stated)  Actuals Additions Eliminations Pro Forma
Long-term Assets220.0220.0
Intangibles0.0
Investments25.00.0
Working Capital0.00.0
Debtors (Net of Prepayments) A/R25.025.0
Inventory11.011.0
Trade Creditors (Net of Advances) A/P(19.0)(19.0)
Net Working Capital17.017.0
Financial Position
Cash0.53.0(0.5)3.0
New Short Term Debt (Revolver)0.0(10.0)0.0(10.0)
Existing Short Term Debt(25.0)0.025.0
New Bank Facility0.00.0
New Sr Notes0.00.0
New Sub Notes0.00.0
Existing Long Term Debt(75.0)0.0
New Sr Preferred0.0(40.0)0.0(40.0)
Net Debt(99.5)99.5
Deferred Tax Assets (Liability)0.00.0
Other Assets0.70.7
Other Libilities(0.5)(0.5)
Net Assets162.7
Equity & Reserves162.7

IRR Analysis
    Projected Fiscal Year Ending December 31,
(USD in millions, except otherwise stated)  2022PF202320242025202620272028
Dividend Stream / Additional Capital0.00.00.00.00.00.0
Exit Multiple @ 6.0x
Exit in 2026(120.0)0.00.00.0
Exit in 2027(120.0)0.00.00.00.0
Exit in 2028(120.0)0.00.00.00.00.0

 

Income Statement Summary
    Projected Fiscal Year Ending December 31,
(USD in millions, except otherwise stated) 2022A2023202420252026202720282029
Revenues150.0162.0173.3183.7192.9200.6208.7217.0
— growth rate, %8.0%7.0%6.0%5.0%4.0%4.0%4.0%
COGS90.095.6100.5104.7108.0110.4112.7117.2
— gross margin, %40.0%41.0%42.0%43.0%44.0%45.0%46.0%46.0%
Salaries17.019.420.820.219.318.118.819.5
Marketing4.07.37.47.36.26.06.36.5
Other Operating Costs2.04.93.52.82.92.82.72.6
EBITDA37.034.841.248.756.563.468.271.2
— EBITDA margin, %24.7%21.5%23.8%26.5%29.3%31.6%32.7%32.8%
Depreciation & Amortization25.038.936.734.733.234.036.038.0
EBIT12.0(4.1)4.514.023.429.432.233.1
— EBIT margin, %8.0%(2.5%)2.6%7.6%12.1%14.6%15.4%15.3%
Interest Income0.10.00.20.20.00.20.8
Interest Expense(19.6)(20.7)(21.5)(21.6)(20.9)(17.9)(17.5)
EBT(23.6)(16.2)(7.4)1.98.514.416.4
Tax(3.5)(0.5)3.04.97.66.47.1
Net Exceptional Items & Adjustments0.00.00.00.00.00.00.0
Net Income(20.0)(15.7)(10.4)(3.0)0.88.09.3

Balance Sheet Statement Summary
    Projected Fiscal Year Ending December 31,
(USD in millions, except otherwise stated) 2022PF2023202420252026202720282029
Long-term Assets220.0215.5208.2197.9189.1179.5167.8154.2
Intangibles82.778.373.969.565.160.756.351.9
Investments0.00.00.00.00.00.00.00.0
Working Capital
Debtors (Net of Prepayments)25.024.825.726.928.429.730.832.1
Inventory11.010.510.610.710.810.711.011.3
Trade Creditors (Net of Advances)(19.0)(15.8)(16.8)(17.4)(18.0)(18.4)(18.8)(19.3)
Net Working Capital17.019.519.620.221.222.023.024.0
Financial Position
Cash3.01.50.010.50.00.011.839.5
New Short Term Debt (Revolver)(10.0)(16.1)(8.3)0.00.00.00.00.0
Existing Short Term Debt0.00.00.00.00.00.00.00.0
New Bank Facility(70.0)(70.0)(70.0)(70.0)(37.1)(12.4)0.00.0
New Sr Notes(50.0)(50.0)(50.0)(50.0)(50.0)(50.0)(50.0)(50.0)
New Sub Notes(40.0)(44.0)(48.4)(53.2)(53.2)(53.2)(53.2)(53.2)
Existing Long Term Debt0.00.00.00.00.00.00.00.0
New Sr Preferred(40.0)(45.6)(52.0)(59.3)(67.6)(77.0)(77.0)(77.0)
Net Debt(207.0)(224.2)(228.7)(222.0)(207.9)(192.7)(168.4)(140.8)
Deferred Tax Assets (Liability)0.03.54.11.0(3.9)(5.0)(6.2)(7.5)
Other Assets0.70.70.70.70.70.70.70.7
Other Libilities(0.5)(0.5)(0.5)(0.5)(0.5)(0.5)(0.5)(0.5)
Net Assets112.992.977.266.863.864.772.782.0
Equity & Reserves112.992.977.266.863.864.772.782.0

Cash Flow Statement Summary
    Projected Fiscal Year Ending December 31,
(USD in millions, except otherwise stated) 2022PF2023202420252026202720282029
EBITDA37.034.841.248.756.563.468.271.2
Cash Interest Income0.10.00.20.20.00.20.8
Cash Interest Expense(10.0)(9.9)(9.3)(13.3)(11.4)(17.9)(17.5)
Cash Tax0.00.00.0(0.0)(6.5)(5.2)(5.8)
Net Change in WC / Other CA(2.5)(0.0)(0.7)(1.0)(0.8)(1.0)(1.0)
CAPEX(30.0)(25.0)(20.0)(20.0)(20.0)(20.0)(20.0)
Extraordinary Cash Items0.00.00.00.00.00.00.0
Change in Cash before Financing(7.6)6.218.822.424.724.327.6
Financed by
Equity Issue / (Buy Back or Dividend)0.00.00.00.00.00.00.0
Debt Issue / (Retirement)6.1(7.7)(8.3)(32.9)(24.7)(12.4)0.0
Total Financing6.1(7.7)(8.3)(32.9)(24.7)(12.4)0.0
Change in Cash for the Period(1.5)(1.5)10.5(10.5)0.011.827.6
Cash BoP3.01.50.010.50.00.011.8
Cash EoP1.50.010.50.00.011.839.5

 

Last Updated on July 27, 2023

Don`t copy text!
Scroll to Top