# Question: This problem utilizes information from Problem 10 9 and requires

This problem utilizes information from Problem 10- 9 and requires that the LBO valuation model be constructed. Randy was happy with the anticipated results from the acquisition of Flanders Inc., but he wanted to do some exploratory analysis of the risks involved in the acquisition so that he might be able to anticipate the risks inherent in the investment. He planned to construct a spreadsheet model using the industry- standard LBO valuation model ( using information from Problem 10- 9) and then identify the key sources of risk in the model, constructing what he felt were reasonable characterizations of the probability distributions for each of these variables. Specifically, Randy decided on the following variables (value drivers) and distributional characterizations:

Mark Flanders estimated EBITDA growth to be 10% per year, but this rate is far from certain. Randy decided that he would set the most likely growth rate to be 10%, but he would use a triangular distribution with a minimum value of 0% and a maximum of 15% to characterize the annual rate of growth in EBITDA over the planning period. Randy felt that the rate of growth each year would be related to what happened in the subsequent year, so he decided to impose a .80 correlation on the growth rates for successive years. That is, the correlation between the rate of growth in 2018 and 2017 is estimated to be .80, and so forth.

Another key determinant of the value of the Flanders acquisition is the exit multiple that Clear stone will encounter in five years when it sells the firm. Randy has estimated that they will be able to exit at the same multiple (five) at which they purchase Flanders Inc.; however, this variable is subject to uncertainty. Based on Clear stone’s past experience, Randy estimates a 10% chance of the exit multiple being as low as three times EBITDA, a 20% chance of it being four, a 40% chance of it being five, a 20% chance of it being six, and a 10% chance of it being as high as seven.

a. After incorporating Randy’s two assumptions about the uncertainties in the acquisition of Flanders Inc., what is the mean and median rate of return on Clear stone’s investment in the firm’s equity?

b. What is the probability that the Flanders acquisition will yield a rate of return to Clear stone that is below the firm’s target of 40%?

Mark Flanders estimated EBITDA growth to be 10% per year, but this rate is far from certain. Randy decided that he would set the most likely growth rate to be 10%, but he would use a triangular distribution with a minimum value of 0% and a maximum of 15% to characterize the annual rate of growth in EBITDA over the planning period. Randy felt that the rate of growth each year would be related to what happened in the subsequent year, so he decided to impose a .80 correlation on the growth rates for successive years. That is, the correlation between the rate of growth in 2018 and 2017 is estimated to be .80, and so forth.

Another key determinant of the value of the Flanders acquisition is the exit multiple that Clear stone will encounter in five years when it sells the firm. Randy has estimated that they will be able to exit at the same multiple (five) at which they purchase Flanders Inc.; however, this variable is subject to uncertainty. Based on Clear stone’s past experience, Randy estimates a 10% chance of the exit multiple being as low as three times EBITDA, a 20% chance of it being four, a 40% chance of it being five, a 20% chance of it being six, and a 10% chance of it being as high as seven.

a. After incorporating Randy’s two assumptions about the uncertainties in the acquisition of Flanders Inc., what is the mean and median rate of return on Clear stone’s investment in the firm’s equity?

b. What is the probability that the Flanders acquisition will yield a rate of return to Clear stone that is below the firm’s target of 40%?

## Relevant Questions

CP Venture Partners is looking at the possible investment of $ 1 million in an early-stage company (Startco). Given the stage of the investment, CP requires a 40% annual rate of return. The company earned $ 750,000 in EBITDA ...In 2014, Dub Tarun founded a firm using $ 200,000 of his own money, $ 200,000 in senior (bank) debt, and an additional $ 100,000 in subordinated debt borrowed from a family friend. The senior debt pays 10% interest, while ...Morrison Oil and Gas Company’s (from Problem 11-5) chief financial analyst is Samuel ( Sam) Crawford. Sam completed his analysis, suggesting that the investment is indeed a good one for the company, and presented it to the ...J& B Drilling Company has recently acquired a lease to drill for natural gas in a remote region of southwest Louisiana and southeast area has long been known for oil and gas production, and the company is optimistic about ...Vespar’s senior management team was poised to undertake the clean-coal power plants when they received a call from the chief engineer for the contractor who had been selected to build the initial plant. The engineer had ...Post your question