LBO Banking Analysis Assignment Help

LBO Banking Analysis Assignment Help
LBO Banking Analysis Assignment Help
1) Using the assumptions below, calculate ValueCo’s enterprise value and equity
purchase price
($ in millions)
Assumptions
LTM 9/30/2019 EBITDA $700.0
Entry EBITDA Multiple 8.0x
Total Debt 1,500.0
Cash and Cash Equivalents 250.0
a. Calculate enterprise value
_______________________________________________________________
b. Calculate equity purchase price
_______________________________________________________________
LBO Banking Analysis Assignment Help
2) Using the enterprise value and equity purchase price determined in the prior
question, as well as the following assumptions, complete the sources and
uses table and answer the following questions (round numbers to nearest
decimal point)
($ in millions)
Assumptions
New Revolver Size (undrawn at close) $250.0
Senior Secured Leverage 4.0x
Total Leverage 5.2x
Equity Contribution 35.0%
Cash on Hand 250.0
Tender/Call Premiums* 20.0
Financing Fees 100.0
Other Fees and Expenses 30.0
*Assume ValueCo’s debt is fully refinanced
CHAPTER 5
170 CHAPTER 5 QUESTIONS
($ in millions)
Sources of Funds Uses of Funds
Revolving Credit Facility A) Purchase ValueCo Equity
Term Loan B B) Repay Existing Debt
Senior Notes C) Tender/Call Premiums
Equity Contribution D) Financing Fees
Cash on Hand Other Fees and Expenses
Total Sources E) Total Uses
LBO Banking Analysis Assignment Help
a. Determine ValueCo’s pro forma revolver balance
_______________________________________________________________
b. Calculate the term loan B principal amount
_______________________________________________________________
c. Calculate the senior notes principal amount
_______________________________________________________________
d. Calculate the sponsor’s equity contribution
_______________________________________________________________
e. Determine the total sources amount
_______________________________________________________________
LBO Analysis 171
3) Given the sources and uses of funds determined in the prior question, as well
as the opening balance sheet below, complete the pro forma balance sheet at
closing and answer the related questions (showing all adjustments)
($ in millions)
Balance Sheet
Opening
2019
LBO Banking Analysis Assignment Help
Adjustments Pro Forma
– 2019
Cash and Cash Equivalents $250.0
Accounts Receivable 450.0
Inventories 600.0
Prepaids and Other Current Assets 175.0
Total Current Assets $1,475.0 A)
Property, Plant and Equipment, net 2,500.0
Goodwill 1,000.0 B)
Intangible Assets 875.0
Other Assets 150.0
Deferred Financing Fees –
Total Assets $6,000.0 C)
Accounts Payable 215.0
Accrued Liabilities 275.0
Other Current Liabilities 100.0
Total Current Liabilities $590.0
Revolving Credit Facility –
Term Loan A –
Term Loan B –
Term Loan C –
Existing Term Loan 1,000.0
2nd Lien –
Senior Notes –
Existing Senior Notes 500.0
Senior Subordinated Notes –
Other Debt –
Deferred Income Taxes 300.0
Other Long-Term Liabilities 110.0
Total Liabilities $2,500.0 D)
Noncontrolling Interest –
Shareholders’ Equity 3,500.0
Total Shareholders’ Equity $3,500.0
Total Liabilities and Equity $6,000.0 E)
Balance Check 0.000 0.000
172 CHAPTER 5 QUESTIONS
a. Calculate ValueCo’s pro forma current assets balance
_______________________________________________________________
b. Calculate pro forma goodwill
_______________________________________________________________
c. Calculate pro forma total assets
_______________________________________________________________
d. Calculate pro forma total liabilities
_______________________________________________________________
e. Calculate pro forma shareholders’ equity
_______________________________________________________________
4) Using the LBO financing structure previously determined, as well as the
assumptions below, calculate ValueCo’s pro forma interest expense and
appropriate coverage and leverage ratios at transaction closing
Having a hard time figuring out how to do your assignment?
Ask our experts for help and get it done in no time!