LBO MODEL

You're an investment banker engaged by Porcupine Tree Company regarding their efforts to complete a significant M&A transaction. One of the things you're evaluating is the value of the company Porcupine Tree Company wishes to acquire. At issue is a measure of uncertainty in your mind regarding the company's projection for 2020; especially the revenue projection. The target company is a global concern, and the foreign currencies in which it transacts its overseas business did strengthen against the dollar. However, your quick math suggests that doesn't explain the total jump in revenues. The financial history and near term projections for the target company are as set out below. These projections were included in a pitch book you received from the target company's investment banker. Much to your surprise, the pitch book does not explain the sudden jump in revenues or any other figures for the projection of 2020. 2016 $500,000 Revenues (000s) Percent Growth EBITDA Depreciation EBIT 2017 $505,000 1.0% $49,000 $10,500 $38,500 2018 $545,000 7.9% 54,000 10,700 $43,300 2019 $535,000 (1.8%) $50,000 $15,000 $35,000 2020P $700,000 30.1% $85,000 $20,000 $65,000 $50,000 $10,000 $40,000 Free Cash Flow $30,000 $28,000 $15,000 $5,000 $50,000 You've set up a telephone call with the investment banker to review the data, including the 2020 projections. 1. What questions will you ask with respect to the four year historical trend and the 2020 projection? 2. What additional information would you likely be requesting to help understand the trends at play? Thinking like an investment banker completing a buy-side valuation of a leveraged acquisition . Your initial responsibility is pure valuation using DCF and IRR concepts. One of the steps will be to calculate the cash flows necessary to complete a DCF valuing the entire company for the purpose of setting a bid price for the acquisition. Another step will be to calculation the cash flows that would be relevant for an IRR computation regarding the equity investment being made. Note: you won't have to calculate value or the IRR on this problem. . You're an investment banker engaged by Porcupine Tree Company regarding their efforts to complete a significant M&A transaction. One of the things you're evaluating is the value of the company Porcupine Tree Company wishes to acquire. At issue is a measure of uncertainty in your mind regarding the company's projection for 2020; especially the revenue projection. The target company is a global concern, and the foreign currencies in which it transacts its overseas business did strengthen against the dollar. However, your quick math suggests that doesn't explain the total jump in revenues. The financial history and near term projections for the target company are as set out below. These projections were included in a pitch book you received from the target company's investment banker. Much to your surprise, the pitch book does not explain the sudden jump in revenues or any other figures for the projection of 2020. 2016 $500,000 Revenues (000s) Percent Growth EBITDA Depreciation EBIT 2017 $505,000 1.0% $49,000 $10,500 $38,500 2018 $545,000 7.9% 54,000 10,700 $43,300 2019 $535,000 (1.8%) $50,000 $15,000 $35,000 2020P $700,000 30.1% $85,000 $20,000 $65,000 $50,000 $10,000 $40,000 Free Cash Flow $30,000 $28,000 $15,000 $5,000 $50,000 You've set up a telephone call with the investment banker to review the data, including the 2020 projections. 1. What questions will you ask with respect to the four year historical trend and the 2020 projection? 2. What additional information would you likely be requesting to help understand the trends at play? Thinking like an investment banker completing a buy-side valuation of a leveraged acquisition . Your initial responsibility is pure valuation using DCF and IRR concepts. One of the steps will be to calculate the cash flows necessary to complete a DCF valuing the entire company for the purpose of setting a bid price for the acquisition. Another step will be to calculation the cash flows that would be relevant for an IRR computation regarding the equity investment being made. Note: you won't have to calculate value or the IRR on this