Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribedimage text in transcribed

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: o The fund expects to hold the company for five years. o Comparable analysis puts the company value at 5xEBITDA o We have been able to negotiate a Term A loan at 3.5x LTM EBITDA (10% interest rate) o We have been able to negotiate a high-yield loan for 0.5x LTM EBITDA at a 15% interest rate. o 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? 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? 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: o The fund expects to hold the company for five years. o Comparable analysis puts the company value at 5xEBITDA o We have been able to negotiate a Term A loan at 3.5x LTM EBITDA (10% interest rate) o We have been able to negotiate a high-yield loan for 0.5x LTM EBITDA at a 15% interest rate. o 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? 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Entrepreneurial Finance

Authors: Marco Da Rin, Thomas Hellmann

8th Edition

0199744750, 9780199744756

More Books

Students also viewed these Accounting questions