Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the expected IRR on the following leveraged buyout. The target firm can be bought at 7 times EBITDA (LTM) and is expected to be

Calculate the expected IRR on the following leveraged buyout. The target firm can be bought at 7 times EBITDA (LTM) and is expected to be sold at 8 times EBITDA (LTM) after 7 years. The buyout will be financed with 60% debt. The interest on the debt is 12% and the principal will be repaid using cash available for debt repayment in each year. If any debt is left at the end of year 7, it will be fully paid off before the equity holders can be paid. The interest on the debt will be calculated on the ending balance of the previous years debt.

The current financial year (year 0) is about to conclude for the target firm. This year (year 0), the target firm had sales of $150 million. Sales for the target firm are expected to grow by 5% until year 3, after which sales growth will become 1% in perpetuity. The EBITDA margin for the target firm is expected to stay the same at 40%. The target firms existing net plant, property, and equipment is $45 million and will be depreciated to zero in 3 years, using the straight-line method. The target firm will spend 15% of its revenues for each year as capital expenditures. The capital expenditures will be depreciated to zero in 3 years, using the straight-line method. The target firms capital expenditures for any particular year are made at the start of that year. The target firm requires working capital of 30% of sales. Taxes are 20%. The target firm owns no cash right after the buyout. All cash flows occur at the end of the year, except for capital expenditures. (Show your work in Excel. In Excel, show numbers at the two decimal places. Copy-paste your Excel work to your answer document as an image.) (10 marks)

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

Quantitative Financial Risk Management

Authors: Constantin Zopounidis, Emilios Galariotis

1st Edition

1118738187, 978-1118738184

More Books

Students also viewed these Finance questions

Question

2. Are you varying your pitch (to avoid being monotonous)?

Answered: 1 week ago

Question

3. Are you varying your speaking rate and volume?

Answered: 1 week ago