Valuing an Entity with Buy-Manage-Sell Model -- Value to all Stakeholders Introduction Just Q Tips (JQT)...

Transcribed Image Text:

Valuing an Entity with Buy-Manage-Sell Model -- Value to all Stakeholders Introduction Just Q Tips (JQT) is a profitable, debt free entity, operating in steady-state forever. Despite this, the economy is in recession, which has depressed the price of JQT's stock. Your Equity/Debt investor team is considering buying it and restructuring its debt. The asking price for 100% of the firm's stock is: Your team believes that an optimal capital structure for the firm would be: If your team proceeds with the Just Q Tips transaction: - The equity investors will pay (1-D)/(D+E)% of the purchase price from their own funds. - Just Q Tips will take out a long-term loan at the moment of close, provided by the debt investors on the team, to pay the current owners the rest of the purchase price. - The equity investors will operate Just Q Tips in its recapitalized steady-state for three years. - At the end of this time: 100% of the stock will be resold for an estimated and the loan will be terminated. (Principal will be repaid). $200.00 MM 70% D/(D+E) $72.0000 MM Financing Structure PP (D+E) = D + E = CAP tot D / (D + E) = WD D E Key Rates Income Tax rate ro re = Market's view of Enterprise Value WACC Free Cash Flows FCF (D+E) = NOPAT-A Working Capital + Deprec - CAPX Partial Income Statement, NOPAT and FCFs ($MM UON) Revenue - Depreciation - Other Expenses = EBIT - Tax on EBIT = NOPAT - A Working Capital + Depreciation - CAPX = FCF (D+E) Existing As purchased $200.0 $200.0 0.0% $0.0 $200.0 Existing D = $0.0 $100.00 ($60.00) ($30.00) $10.00 Existing As purchased 35.000% 35.000% 7.000% 10.000% 4.800% 7.530% 4.800% 6.80900% ($3.50) $6.50 $0.00 $60.00 a b ($60.00) $6.50 d 70.0% Purchased $100.00 ($60.00) ($30.00) $10.00 ? ? ? ? As A competing Equity/Debt investor team (CT for short) is also considering buying JQT. CT agrees with your assumptions and approach except that a) they believe that JQT's optimal capital structure is b) 100% of the stock (calculated with CT's D/(D+E) ratio) will be resold for an estimated Question 6 What is CT's estimated SP(D+E) = Resale price of stock plus loan principal repayment? Question 7 60% D/(D+E) Using these numbers, what is CT's estimate of JQT's Enterprise Value? $96.00 MM 1 pts 1 pts Assume for this question (irrespective of answers to any other questions) that CT's Estimate of Sp(D+E) is $205.20 and CT's Estimate of JQT's FCF(D+E) is $6.825. Question 8 What is the Market's view of JQT's pre-purchase Enterprise Value? (IE: how much would it cost to purchase all of JQT's stock and pay off all its debt, before any purchase/restructuring by your firm or by CT?). Question 9 1 pts 1 pts Assume for this question (irrespective of answers to any other questions) that CT's estimate of of JQT's Enterprise Value is $194.94 Using this number, what is the NPV of this Buy/Manage/Sell project to CT's Equity/Debt Team? Question 10 Based on CT's estimated NPV for this project, should CT go ahead with it? Answer Y, N or Can't Determine, and provide one reason. U No Yes Can't Determine Because the NPV > 0 Because the NPV < 0 Because we cannot determine the IRR Because we do not know the opportunity cost of capital. Because the project is too risky Valuing an Entity with Buy-Manage-Sell Model -- Value to all Stakeholders Introduction Just Q Tips (JQT) is a profitable, debt free entity, operating in steady-state forever. Despite this, the economy is in recession, which has depressed the price of JQT's stock. Your Equity/Debt investor team is considering buying it and restructuring its debt. The asking price for 100% of the firm's stock is: Your team believes that an optimal capital structure for the firm would be: If your team proceeds with the Just Q Tips transaction: - The equity investors will pay (1-D)/(D+E)% of the purchase price from their own funds. - Just Q Tips will take out a long-term loan at the moment of close, provided by the debt investors on the team, to pay the current owners the rest of the purchase price. - The equity investors will operate Just Q Tips in its recapitalized steady-state for three years. - At the end of this time: 100% of the stock will be resold for an estimated and the loan will be terminated. (Principal will be repaid). $200.00 MM 70% D/(D+E) $72.0000 MM Financing Structure PP (D+E) = D + E = CAP tot D / (D + E) = WD D E Key Rates Income Tax rate ro re = Market's view of Enterprise Value WACC Free Cash Flows FCF (D+E) = NOPAT-A Working Capital + Deprec - CAPX Partial Income Statement, NOPAT and FCFs ($MM UON) Revenue - Depreciation - Other Expenses = EBIT - Tax on EBIT = NOPAT - A Working Capital + Depreciation - CAPX = FCF (D+E) Existing As purchased $200.0 $200.0 0.0% $0.0 $200.0 Existing D = $0.0 $100.00 ($60.00) ($30.00) $10.00 Existing As purchased 35.000% 35.000% 7.000% 10.000% 4.800% 7.530% 4.800% 6.80900% ($3.50) $6.50 $0.00 $60.00 a b ($60.00) $6.50 d 70.0% Purchased $100.00 ($60.00) ($30.00) $10.00 ? ? ? ? As A competing Equity/Debt investor team (CT for short) is also considering buying JQT. CT agrees with your assumptions and approach except that a) they believe that JQT's optimal capital structure is b) 100% of the stock (calculated with CT's D/(D+E) ratio) will be resold for an estimated Question 6 What is CT's estimated SP(D+E) = Resale price of stock plus loan principal repayment? Question 7 60% D/(D+E) Using these numbers, what is CT's estimate of JQT's Enterprise Value? $96.00 MM 1 pts 1 pts Assume for this question (irrespective of answers to any other questions) that CT's Estimate of Sp(D+E) is $205.20 and CT's Estimate of JQT's FCF(D+E) is $6.825. Question 8 What is the Market's view of JQT's pre-purchase Enterprise Value? (IE: how much would it cost to purchase all of JQT's stock and pay off all its debt, before any purchase/restructuring by your firm or by CT?). Question 9 1 pts 1 pts Assume for this question (irrespective of answers to any other questions) that CT's estimate of of JQT's Enterprise Value is $194.94 Using this number, what is the NPV of this Buy/Manage/Sell project to CT's Equity/Debt Team? Question 10 Based on CT's estimated NPV for this project, should CT go ahead with it? Answer Y, N or Can't Determine, and provide one reason. U No Yes Can't Determine Because the NPV > 0 Because the NPV < 0 Because we cannot determine the IRR Because we do not know the opportunity cost of capital. Because the project is too risky