Reference no: EM133062610

You are an analyst at a private equity firm. You have been tasked with analyzing a leveraged buyout opportunity of a retail company.

Key Assumptions:

• The fund expects to hold the company for five years.
• Comparable analysis puts the company value at 5xEBITDA
• We have been able to negotiate a Term A loan at 3.5x LTM EBITDA (10% interest rate)
• We have been able to negotiate a high-yield loan for 0.5x LTM EBITDA at a 15% interest rate.
• Transaction fees are assumed to be 0.5% of the purchase price.

Company Assumptions:

• The company has an LTM EBITDA of $10 million.
• Management expects the company's EBITDA to grow at 5% per year
• The company has 250k of net debt on its balance sheet.
• The company has a $40 million asset that will be evenly depreciated over 10 years.
• The company will maintain CAPEX spend at $1.1 million per year and will be depreciated over 10 years.
• The company's working capital is projected at 15 days off of EBITDA
• The tax rate is 40%

Show your work done and answer the following questions:

a) What is the purchase price of this firm?

b) What is the equity amount used to purchase this firm?

c) What is the D&A of year 3?

d) What is the changes in WC of year 4?

e) What is the EBIT of year 5?

f) What is the grand total UFCF of the firm?

g) What is the amount of interest after tax of high yield loan?

h) What is the final debt of the firm?

i) What is the net exit equity value the firm?

j) What is the expected IRR of the firm?