Ace - AI Tutor
Ask Our Educators
Textbooks
My Library
Flashcards
Scribe - AI Notes
Notes & Exams
Download App
Juhi Singhal

Juhi S.

Divider

Questions asked

ANSWERED

Jennifer Stoner verified

Numerade educator

Question 28 28. Consider the "Cash Flow Available for Debt Repayment" (CFADR) metric in the Cash Flow Projections and Debt Schedule of an LBO model. The statements below list similarities and differences between this metric and "Free Cash Flow" (FCF), as it is normally defined in 3-statement models. TWO of the statements below list similarities or differences that are INCORRECT. Select BOTH incorrect statements to get this question correct. a. Both CFADR and FCF deduct the Net Interest Expense but not the Optional Principal Repayments on New Debt used to fund the LBO. Incorrect. b. FCF is a component of CFADR, along with an addition for the Beginning Cash, a deduction for the Minimum Cash, and a deduction for Mandatory Principal Repayments. c. FCF is capital structure-neutral, but CFADR is not because it changes throughout the LBO holding period as the company repays its Debt balance. d. The annual Change in Debt should equal the annual CFADR, but it never equals the annual FCF. Correct answer.

View Answer
divider
INSTANT ANSWER

Quevites 23 answit Aeper limate: Inwuen/CTM asian \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & 1. & \( \square \) & \( \checkmark \) & & & ? \\ \hline\( { }^{*} \) & (- 4 & \( \square \) & ? & & & & & & & -1in \\ \hline a & \multicolumn{10}{|l|}{\( \longrightarrow \)} \\ \hline a & & ? & & 1 & teat & 40 & 5 & ans & \( \Delta \) & 4 ans \\ \hline a & & ? & & & tivis & ans & & ant & & ang \\ \hline\( \stackrel{\rightharpoonup}{*} \) & & ? & & & ins & ina & & ant & & a*es \\ \hline\( * \) & thentery & ? & & & an & * & & ? & & \( = \) \\ \hline 8 & ? & ? & & & an & an & & - & & anis \\ \hline\( \stackrel{\rightharpoonup}{*} \) & & \( \stackrel{+}{*} \) & & & & 3 & & \( = \) & & \( = \) \\ \hline\( \stackrel{8}{8} \) & & \( \stackrel{2}{*} \) & & & P. & +8 & & \( = \) & & ? \\ \hline\( \Delta \) & thation & \( \stackrel{2}{*} \) & & & ? & \( \operatorname{nit} \) & & & & + \\ \hline+ & antilu & in & & & & ant & & 1a-2 & & atart \\ \hline\( \stackrel{\rightharpoonup}{+} \) & & & & & & & & & & \\ \hline\( \underset{*}{*} \) & ithatar & ** & & & +ins & ansis & & mm & & anse \\ \hline\( \stackrel{\Delta}{-} \) & tantent & ** & & & unar & \( t= \) & & ana & & ane: \\ \hline * & & & & & & & & & & \\ \hline ? & \multicolumn{10}{|l|}{ Arevtris } \\ \hline 8 & & ? & & & Pint & ans & & \( 1+8 \) & & angi. \\ \hline a & mature & ? & & & an & an & & an & & ant \\ \hline a & & & & & \( a+ \) & an & & ana & & an \\ \hline\( a \) & interestatesing & ? & & & An & 8 an & & \( a \) an & & and \\ \hline a & ingent & ? & & & iat & inat & & ant & & mit \\ \hline a & & ? & & & ant & 0 & & san & & \( \operatorname{an} \) \\ \hline a & & it & & & & 128 & & rit & & ? \\ \hline & intruntare & + & & & -4 & me & & & & \\ \hline * & ? & & & & & & & & & \\ \hline 4 & 1aturation & ? & & & & inal & & atan & & ata \\ \hline\( \stackrel{2}{*} \) & & & & & exis & \nis & & ans & & anes \\ \hline & ingentere & ? & & & 19: & ave & & in & & a* \\ \hline\( \Delta \) & anation & ? & & & at & \( \therefore \) & & & & at \\ \hline * & atigerermat & ? & & & at & at & & \( \stackrel{2}{* *} \) & & \\ \hline & & ? & & & ?? & anil & & init & & mingrint \\ \hline * & ithererteienterato & in & & & *a & min & & an & & min \\ \hline * & intere & ? & & & ? & B & & 82 & & ? \\ \hline B & & IE & & & & & & & & \\ \hline ? & interey & ? & & & \( y=4 \) & ans & & anal & & Desi \\ \hline & Hectetay & ? & & & inay. & ? & & & & P2 \\ \hline\( = \) & -1) & is & & ? & \( = \) & \( 1= \) & r & a*a & 4 & anes \\ \hline \multicolumn{11}{|l|}{ e } \\ \hline\( = \) & 3tar & \( \underset{\sim}{*)} \) & & & & & & & & \\ \hline * & atantar & \( += \) & & & \( \stackrel{2}{r+} \) & \( \Rightarrow \) & & at & & \( a+ \) \\ \hline\( = \) & averation & and & & & \( \Delta \) & \( \Delta \) & & at & & +2 \\ \hline \multicolumn{11}{|l|}{ = } \\ \hline ? & and & N= & & 1 & + & \( = \) & 5 & \( = \) & 1 & a \\ \hline \multicolumn{11}{|l|}{\( \stackrel{+}{*} \)} \\ \hline \% & angerant & \( y= \) & & 1 & +0 & a* & 4 & am & + & ** \\ \hline \% & anatien; & \in & & 1 & +2 & \( = \) & \ & an & 9 & 4 \\ \hline ? & *ivitation & \( * \) & & & min & me & & min & & mat \\ \hline \multicolumn{11}{|l|}{ ? } \\ \hline & & vien & & it & ? & as & in & mint & i & an \\ \hline * & & ninar & & 8 & \( \rightarrow \) & ? & 1 & m & 3 & sing \\ \hline\( = \) & & \( * \) & & & * & + & & & & mint \\ \hline \end{tabular} purs whes hark thase lewil wis owswilativalyligh lyntyles. Incistall. Cumat arese.

View Answer
divider
ANSWERED

Jennifer Stoner verified

Numerade educator

Question 26 26. You have built a simple LBO model based on the acquisition of a private, family-held company in Germany for 10x EBITDA with a sale for 10x EBITDA in Year 5. The deal uses Senior Bank Debt for 3x EBITDA, 1x EBITDA worth of Seller's Notes, and a 1x EBITDA Shareholder Loan (like Preferred Stock but with tax-deductible PIK Interest). Currently, your firm expects to earn an 18% IRR over 5 years on this deal, but it would like to earn at least a 20% IRR. Based on the model excerpt below, what is the MOST VIABLE way to boost the IRR into this range? Debt Repayment: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 (+) Beginning Cash: 2 2 2 2 2 (-) Min Cash: (2) (2) (2) (2) (2) (+) Free Cash Flow: 23 27 31 35 40 (-) Mandatory Repayments: (14) (20) (27) (34) (19) CF Avail. For Debt Repayment: 9 6 4 2 21 CF Used for Debt Repayment: (9) (6) (4) (2) - Ending Cash: 2 2 2 2 2 23 Debt Balances: Senior Bank Debt: 135 112 86 55 19 - Seller's Notes: 45 49 52 57 61 66 Shareholder Loan: 45 50 56 63 71 79 Exit Enterprise Value: - - - - - 716 (-) Senior Bank Debt: - - - - - - (-) Seller's Notes: - - - - - (75) (+) Cash: - - - - - 23 Exit Equity Value: - - - - - 664 Mgmt Equity: (28) - - - - 66 Earnout Paid to Mgmt: - - - - - 15 Proceeds to Mgmt: (28) - - - - 82 Proceeds to Sponsor: (253) - - - - 582 Sponsor Multiple: 2.3 x Sponsor IRR: 18% a. Increase the Debt used to fund the deal, as the company can clearly afford more than 3x EBITDA of Senior Bank Debt. b. Remove the Seller's Note and Shareholder Loan and assume 5x Debt / EBITDA for the Senior Bank Debt, as the lower interest rates will improve cash flows. c. Negotiate for lower mandatory repayments on the Senior Bank Debt in exchange for a higher interest rate, which should also improve cash flows. d. Assume that the exit multiple is higher than 10x because of the company's FCF growth and improved FCF conversion over this period.

View Answer
divider
INSTANT ANSWER

Question 27 27. You have built a "cash flow only" LBO model for the buyout of a Japanese healthcare services company (Nichiigakkan). The purchase multiple is 5.6x EEITDA, and the deal uses 3x EEITDA for the Term Loans, Ix EiITDA for the Subordinated Notes, and tx EBITDA for Mezzanine financing. In the Debt Schedule of the model, you use the formula shown in the screenahot below for the Revolver Repayments and Drawdowns. Is this formula correct? For clarity, here is it in text as well: \[ =*(F(1155>0, M i N(155,1157) / 1155) \] \( +2 \) \( + \) 6 8 \( \square \) II 8 1 in B ?4 1? 14 be 14 14) 14 145 18? 14 1. 14 in 14 18 +14 174 145 \( 1+3 \) (1) 14 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{11}{|l|}{ atenget frati } \\ \hline & \( \Delta \) & & ant & anition & & anit & & 120 & & 14\% \\ \hline finuther & T & & \( 4+2 \) & hath & & 14 & & 4ant & & t \\ \hline lewistate & 5 & & hant & 1ant & & hani. & & fant & & 1.25 \\ \hline & 4 & & nant & hant & & han & & Mant & & Pan \\ \hline theserien & * & & & 37.3th & & 343 & & natar & & ?? \\ \hline Calt & 4 & & 175 & 1ate & & 13Tm & & Hint & & 17 \\ \hline \\ \hline & 4 ? & 4 & atare a & 2are & 4 & mane & 3 & ?? & 3 & Ans \\ \hline plheetah fiom & 84 & & |alili & BAe & & ? & & 14ate & & 14 ? \\ \hline & It & & That & \7\2 & & & & & & ?? \\ \hline & 84 & & & & & & & ? |eE & & |atien \\ \hline & 4 ? & & & 2.185 & & stat & & 12.189 & & 2414 \\ \hline tap terotier & 4 at & & 1 & 1244 & & Hay & & \( * \) & & \( * \) \\ \hline & 84 & (1) & Antar & 1417\% & & & & 3 & & \\ \hline tiet tisutain & & & 8+14 & & & \( * \) & & \( * \) & & * \\ \hline \end{tabular} b. Yes - i produces the correct numbers, and there is no better way to set up this formula. c. This formula produces the correct numbers, but it could be expressed more simply as: \#-MiN(155,/157). d. No - it is best practice to separate the Revolver Draws and Repayments into separate lines in L9O models.

View Answer
divider
INSTANT ANSWER

Question 30 30. Consider the Returns Calculations in the LBO model shown in the image below, which includes Earn-Out Payments to the management team of \( \$ 15 \) million, \( \$ 20 \) million, and \( \$ 25 \) million in Years 3, 4, and 5, respectively, based on EBITDA targets. The private equity firm is considering offering management a \( 5 \% \) Options Pool rather than these Earn-Outs. The Initial Investor Equity here was approximately \( \mathbf{\$ 9 4 0} \) million, and the exarcise price of the options will be linked to this Initial Investor Equity figure. The four statements below describe the differences between these incentive schemes. TWO of the statements are correct, and the other two are incorrect. Select BOTH correct statements to get this question correct. Larger Image: https://quiz-breakingintowallstreet-com.s3.us-east-1.amazonaws.com/CFM-Quiz= Images/CFM-30.jpg \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Eatatat falmbime } & \multirow[b]{2}{*}{ Beit } & \multirow[b]{2}{*}{ Fin } & \multicolumn{5}{|l|}{ Pathates } \\ \hline & & & bea & miz & An & Fi4 & ant \\ \hline H.ewisal Yea. & a & & 1.) & 34 & 19 & 44 & 40 \\ \hline (aw0a Regeres & 5 & & & & 4543 & 36 & 20 \\ \hline terby tiwevis. & im & & & & vase & neE & nese \\ \hline sentes & 3m & & & & s*).4 & sis: & \\ \hline infiamatr & t & & & & 45. & Bns & 48. \\ \hline sen evimpras viay & in & & & & sient & B,Mis & PA, \( 10 \% \) \\ \hline & \( 5 M \) & & & & 364 & 148 & 1614 \\ \hline & \( 3 / i n \) & & & & & & \\ \hline (a) Tial faveli & (M) & & & & (2.M0? & (2.1928) & itiony \\ \hline & \( 3 i n \) & & & & iverid & |casin! & (tivali \\ \hline (b) Sariesithy bianavy & \( { }^{\text {(M }} \) & & & & (54) 4 ) & (May) & \( (\mathrm{Ma}) / \) \\ \hline 6? bate vyes & in & & & & 1.325 & \( 4(23) \) & p.1942 \\ \hline \\ \hline sidyla & t & & & & Mis & \( 48: \) & 49. \\ \hline (54) & N & & & & 1015 & 44.84 & \( 3 \% 4 \) \\ \hline \\ \hline \multicolumn{8}{|l|}{ Mourenserifosves fyedy } \\ \hline 1atiel intient & \( 5 M \) & (30u| & & & & & \\ \hline (i) Bencias Breval) & 619 & & - & , & & 160 & ma \\ \hline & 5 & & - & & 43 & 38.8 & 245 \\ \hline Tete Geve Hinas & 1 M & & \( \checkmark \) & + & 6*3 & 28.8 & 3**3. \\ \hline Mabiula & 6 & A23 & & & & & \\ \hline (4). & * & anisi & & & & & \\ \hline \end{tabular} a. The 5\% Options Pool has a higher upfront cost for the PE firm but costs less in the holding period since the options are only paid out once rather than in 3 consecutive years. b. Both the Eam-Outs and the Options Pool reduce the PE firm's ownership in the company in the exit year. c. An Optians Poal is sensitive to the Exit Multiple and the Exit EBITDA, while the EarnOuts depend only on the EBITDA in the holding period. d. To make a rough estimate for the relative costs, you could compare the total Earn-Out payments here to \( 5 \% \) * (Exit Equity Value \( =\$ 940 \) million), assuming that the Exit Equity Value exceeds \( \$ 940 \) millian.

View Answer
divider
INSTANT ANSWER

Question 26 26. You have built a simple LBO model based on the acquisition of a private, family-held company in Germany for 10x EBITDA with a sale for 10x EBITDA in Year 5. The deal uses Senior Bank Debt for 3x EBITDA, 1x EBITDA worth of Seller's Notes, and a 1x EBITDA Shareholder Loan (like Preferred Stock but with tax-deductible PIK Interest). Currently, your firm expects to earn an \( 18 \% \) IRR over 5 years on this deal, but it would like to earn at least a \( 20 \% \) IRR. Based on the model excerpt below, what is the MOST VIABLE way to boost the IRR into this range? A B 0 E F G H 1 1 Year 5 5 Debt Repayment: Year 0 Year 1 Year 2 Year 3 Year 4 54 55 56 57 58 59 60 61 62 63 64 65 65 67 75 76 77 78 79 80 81 82 83 84 85 86 \begin{tabular}{|c|c|c|c|c|c|c|} \hline (+) Beginning Cash: & & 2 & 2 & 2 & 2 & 2 \\ \hline (-) Min Cash: & & (2) & (2) & (2) & (2) & (2) \\ \hline (+) Free Cash Flow: & & 23 & 27 & 31 & 35 & 40 \\ \hline (-) Mandatory Repayments: & & (14) & (20) & (27) & (34) & (19) \\ \hline CF Avail. For Debt Repayment: & & 9 & 6 & 4 & 2 & 21 \\ \hline CF Used for Debt Repayment: & & (9) & (6) & (4) & (2) & - \\ \hline Ending Cash: & 2 & 2 & 2 & 2 & 2 & 23 \\ \hline \multicolumn{7}{|l|}{ Debt Balances: } \\ \hline Senior Banik Debt: & 135 & 112 & 86 & 55 & 19 & \\ \hline Seller's Notes: & 45 & 49 & 52 & 57 & 61 & 66 \\ \hline Shareholder Loan: & 45 & 50 & 56 & 63 & 71 & 79 \\ \hline Exit Enterprise Value: & & - & \( \cdot \) & - & - & 716 \\ \hline (-) Senior Bank Debt: & & - & - & - & - & - \\ \hline\( (-) \) Seller's Notes: & & - & - & - & - & (75) \\ \hline (t) Cash: & & * & . & . & . & 23 \\ \hline Evit Equity Value: & & - & - & - & - & 664 \\ \hline Mgmt Equity: & (28) & - & - & - & - & 66 \\ \hline Earnout Paid to Mgmt: & & \( \cdot \) & \( \cdot \) & - & - & 15 \\ \hline Proceeds to Mgmt: & (28) & \( \cdot \) & * & \( \cdot \) & \( \cdot \) & 82 \\ \hline Proceeds to Sponsor: & (253) & * & * & * & * & 582 \\ \hline Sponsor Multiple: & \( 2.3 \times \) & & & & & \\ \hline Sponsor IRR: & \( 18 \% \) & & & & & \\ \hline \end{tabular} a. Increase the Debt used to fund the deal, as the company can clearly afford more than 3x EBITDA of Senior Bank Debt. b. Remove the Seller's Note and Shareholder Loan and assume Ex Debt / EBITDA for the Senior Bank Debt, as the lower interest rates will improve cash flows. c. Negotiste for lower mandatory repayments on the Senior Bank Debt in exchange for a higher interest rate, which should also improve cash flows. d. Assume that the exit multiple is higher than 10x because of the company's FCF growth and improved FCF conversion over this period.

View Answer
divider
INSTANT ANSWER

Queviles as sumatil Meper lempe: I? wipe/CTM.asing \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & +4 & + & 2 & & & & 4 & & 4 & & ( \( { }^{2} \) \\ \hline an & & & & & H-2 & & - & & & & \\ \hline 4 & & (inis & -4i & & -14 & & & & ?? & & [it \\ \hline a & & & & & & & & & & & \\ \hline\( \times \) & Pinise 4 ane & \( \ \) & & 8 & tenay & 4 & \( 4=3 \) & 5 & anata & \( \Delta \) & alinal \\ \hline+ & nomerater & ? & & & 404 & & +204 & & tate & & angis \\ \hline\( = \) & & & & & ensit & & 4ata & & 420 & & a+e.e\% \\ \hline\( = \) & manertater & +2 & & & \( \operatorname{anar} \) & & \( \tan \) & & \( +2+4 \) & & \( 0 \leq 4 \) \\ \hline an & & \( i= \) & & & ati & & enil & & ensis & & ans \\ \hline+ & & +2 & & & & & exat & & +2 & & \\ \hline+ & \( -4+4 y^{+2+4+4} \) & + & & & \( +\sim+ \) & & \( +20+3 \) & & & & \( +2= \) \\ \hline\( = \) & \antrou & + & & & at & & +2 & & mit & & + \\ \hline 4 & antilentar & \( 1= \) & & & ination & & & & +intar & & atar \\ \hline+ & & & & & & & & & & & \\ \hline\( = \) & intatinge & \( 1 * \) & & & Hint & & HEint & & men & & \init \\ \hline\( = \) & & & & & & & & & & & \\ \hline+ & tanter & \( 4= \) & & & tenter & & ane & & \( 4=2 \) & & anev \\ \hline 8 & & & & & & & & & & & \\ \hline a & Premeltal & & & & & & & & & & \\ \hline a & Prenterest bap & +2 & & & Hant & & Bat & & & & hant \\ \hline ? & & +2 & & & eil & & 29 & & inat & & mint \\ \hline an & & \( 4= \) & & & aby & & anal & & anat & & asal \\ \hline\( a \) & & \( 4= \) & & & Bay & & Ant & & An & & ? \\ \hline 0 & etereate & +2 & & & ingey & & ive & & insily & & unat \\ \hline\( \times \) & & \( 1= \) & & & ant & & & & fat & & anal \\ \hline\( \pm \) & Plent & +2 & & & & & \( x^{204} \) & & * & & Pat \\ \hline a & & + & & & \( =7 \). & & ant & & & & \\ \hline\( = \) & \( +2+3+t+2 \) & + & & & & & & & & & \\ \hline 4 & & + & & & Hatit & & & & tant & & atat \\ \hline \% & matristing & & & & ent & & \ans & & inent & & aney \\ \hline+ & & & & & ivising & & ileith & & Pan & & \( \operatorname{lin} \) \\ \hline+ & & 17 & & & 4 ? & & & & ?? & & ?? \\ \hline an & ativaneitarat mintal & \( i= \) & & & ++ & & & & & & \( +4+ \) \\ \hline \ & & \( 1 \times \) & & & +nth & & +PH & & \( +2+3 \) & & \\ \hline \% & intrenterentheiar menter & \( y= \) & & & Bn & & Bnary & & B* & & ? \\ \hline a & & +2 & & & 4 & & 4 & & an & & 87 \\ \hline ?nt & & \( i= \) & & & any & & + & & a & & al \\ \hline in & tatlatu & +2 & & & +2 & & anar & & inger & & 40 \\ \hline E & & \( t= \) & & & latia & & Pisiti & & insian & & \( \min ^{2 n} \) \\ \hline 2 & nation & \( 1 * \) & & 8 & \( 4=4 \) & 8 & \( 4=1 \) & \( \Delta \) & anat & 4 & 4 anes \\ \hline ? & & & & & & & & & & & \\ \hline an & & & & & \int & & aty & & ata & & Pint \\ \hline+ & Bantar & +2 & & & \( +i \) & & \( +i \) & & +4 & & at \\ \hline\( \geq \) & & \( 4+2 \) & & & \( \xrightarrow{4} \) & & 4 & & \( 4-4 \) & & +2 \\ \hline\( = \) & & & & & & & & & & & \\ \hline+ & & Avare & & 8 & \( 1 * \) & 8 & ** & 4 & *9 & 4 & \( 3= \) \\ \hline\( \stackrel{*}{* *} \) & & & & & & & & & & & \\ \hline & & Lites & & 6 & te & 4 & te & 4 & ins & 4 & \( a= \) \\ \hline \ & & \ivis & & 3 & ata & 1 & + & 8 & Ae & 8 & 9 * \\ \hline & & 4 & & & mint & & \( \geqslant+ \) & & ?n & & Bes \\ \hline 8 & & & & & & & & & & & \\ \hline & & biter & & 5 & ais & 5 & \( a+2 \) & 5 & & + & \( += \) \\ \hline ? & & \ing & & 5 & 19 & 5 & \( i= \) & 8 & ta & \( \nabla \) & Bait \\ \hline 3 & & 4 & & & tien & & me & & mm & & n \\ \hline \end{tabular}

View Answer
divider
INSTANT ANSWER

Question 15 15. You have set up Unlevered Free Cash Flow (UFCF) projections for a DCF analyais of a steel manufacturing company based in the U.S., as shown in the image below. A senior banker has reviewed your analysis and flagged TWO potential problems. Which of the statements below describe the most likely potential problems? You must select BOTH correct answers to get this question correct. Larger Image: https:///quiz-breakingintowallstreet-com.s3.us-east-Lamazonaws.com/CFM-QuizImages/CFM-15.jpg \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & \multirow[b]{2}{*}{Hrin} & \multicolumn{5}{|l|}{ *tantal } & \\ \hline & & anitil & & Pintar & & {\( [1 \)} & & rint & & \( y=4 \). & & atict & \( \ 7 \) & \int \\ \hline Branes & Iy & it tran & 3 & \( 4=3 \) & 3 & taney & 3 & \( 2+303 \) & 3 & neseat \( = \) & 3 & thena & 2 arana & 3 3man \\ \hline Nuranarets & * & ?30 & & 3n & & grime & & nox & & nex & & mrie & car & ani \\ \hline & \( I x \) & unis & & 2130 & & unt & & E7 & & easa & & senal & eca & mex \\ \hline Choutiver & \( \div \) & s:8 & & \( 4=8 \) & & 423 & & \( 4= \) & & ses & & 525 & ces & 3* \\ \hline couthers & 4 & ? & & min & & anay. & & 63 & & 345 & & 20\% & 25. & Hen \\ \hline & t3e & (3) & & Fmin & & mis; & & ser) & & Fin & & mex & ans & aner; \\ \hline & \( \int w \) & \( a x 2 \) & & ana 2 & & anat & & ana & & vea & & enes. & enay & anay \\ \hline \\ \hline & 12 & 235 & & 202 & & Delif & & 2xi: & & 238 & & 3245 & 3202 & 3042 \\ \hline & \( * \) & an & & man & & nin/ & & nn & & nan & & an & an. & an \\ \hline H-14artered woes lave. & \( 5= \) & 3 & & \( \Delta \mathrm{cos} \) & & & & at \( y \) & & 2a2 & & ana & 265 & 32.28 \\ \hline & \( * \) & \( 3 n \) & & axary & & nental & & ming & & xim & & thin & xin. & xis \\ \hline & 50 & 304 & & 6a & & sens & & 40 & & nes! & & ret? & anes. & Hesin \\ \hline & 0 & muat & & ant & & manul & & anal & & \( \mathrm{a}^{30} \) & & & \( a \rightarrow 0 \) & any \\ \hline *. Somer & \( * \) & Un & & PIN & & \$0 & & \( 5 \times 2 \) & & Tave & & Tay & Tay & Tavy \\ \hline & 52 & pas & & Fing & & mive & & PIST & & past & & Pase & \( 2+42 \) & 2042 \\ \hline shenes: & 4 & 920 & & ane & & gand & & 9801 & & -1280 & & CHin & anar & Bith \\ \hline & I2 & ti \( =2 \) & 5 & nant & 5 & rata & 5 & m72 & \( t \) & ment & \( t \) & ans & 10 anta & 3 neti \\ \hline Gowet Mer & 5 & (1)3 & & acter & & 5005 & & elstary & & 2015 & & Dat & 20t & Bint \\ \hline \end{tabular} a. The projection period may be too short, as UFCF is still growing quickly by Year \( B \) (far above the perpetuity growth rate typically assumed in the Terminal Period). b. CapEx equals D\&. A in each projected year, even though the company's revenue is growing at \( 8-10 \pi \) annually in most of the projected period. c. Deferred Income Taxes contribute far too much to UFCF in the projected period. d. The Change in Working Capital as a \% of the Change in Revenue is too consiatent in the projected period, it has fluctuated significantly in the historical years, \( s 0 \) it should do that going forward as well.

View Answer
divider
INSTANT ANSWER

34) Consider the Returns Calculations in the LBO model shown below, which includes Earn-Out Payments to the management team of \( \$ 15 \) million, \( \$ 20 \) million, and \( \$ 25 \) million in Years 3,4 , and 5 , respectively, based on EBITDA targets: \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Returns Calculations: } & \multirow[b]{2}{*}{ Units: } & \multirow[b]{2}{*}{ FY20 } & \multicolumn{7}{|l|}{ Projected } \\ \hline & & & FY21 & FY22 & FY23 & \multicolumn{2}{|r|}{ FY24 } & \multicolumn{2}{|r|}{ FY25 } \\ \hline Numerical Year: & \# & & 1.0 & 2.0 & 3.0 & & 4.0 & & 5.0 \\ \hline Earn-Out Payments: & \$M & & & & \$ \( \quad 15.0 \) & \$ & 20.0 & \$ & 25.0 \\ \hline EBITDA Thresholds: & \$M & & & & 600.0 & & 700.0 & & 800.0 \\ \hline EBITDA: & \$M & & & & 687.4 & & 839.3 & & 880.0 \\ \hline (x) Exit Multiple: & \( x \) & & & & \( 9.5 \times \) & & \( 9.0 \times \) & & \( 8.5 \times \) \\ \hline Exit Enterprise Value: & \$M & & & & \( 6,530.7 \) & & \( 7,554.0 \) & & \( 7,479.8 \) \\ \hline\( (+) \) Cash \& Investments: & \$M & & & & 238.6 & & 258.8 & & 282.4 \\ \hline\( (+) \) Net Operating Losses: & \$M & & & & - & & - & & - \\ \hline\( (-) \) Total Debt: & \$M & & & & \( (2,355.4) \) & & \( (2,112.6) \) & & \( (1,799.4) \) \\ \hline\( (-) \) Operating Leases: & \$M & & & & (689.1) & & (593.9) & & (495.3) \\ \hline (-) Noncontrolling Interests: & \$M & & & & (182.2) & & (242.5) & & (309.2) \\ \hline Exit Equity Value: & \$M & & & & \( 3,542.7 \) & & \( 4,863.7 \) & & \( 5,158.2 \) \\ \hline \multicolumn{10}{|l|}{ Project-Level Returns: } \\ \hline Multiple: & \( x \) & & & & \( 3.4 \times \) & & \( 4.6 \times \) & & \( 4.9 \times \) \\ \hline IRR: & \% & & & & \( 50.1 \% \) & & \( 46.8 \% \) & & \( 37.6 \% \) \\ \hline \multicolumn{10}{|l|}{ Returns to Management: } \\ \hline \multicolumn{10}{|l|}{ Management Common Equity: } \\ \hline Initial Investment: & \$M & \( (108.5) \) & & & & & & & \\ \hline\( (+) \) Earn-Out Received: & \$M & & - & - & 15.0 & & 20.0 & & 25.0 \\ \hline (+) Exit Equity Proceeds: & \$M & & - & \( \square \) & - & & - & & 534.6 \\ \hline Total Cash Flows: & \$M & (108.5) & \( \cdot \) & \( \cdot \) & 15.0 & & 20.0 & & 559.6 \\ \hline Multiple: & \( x \) & \( 5.5 \times \) & & & & & & & \\ \hline IRR: & \% & \( 41.6 \% \) & & & & & & & \\ \hline \end{tabular} The private equity firm is considering offering management a 5\% Options Pool rather than these Earn-Outs. The Initial Investor Equity here was approximately \( \$ 940 \) million, and the exercise price of the options will be linked to this Initial Investor Equity figure. Which of the following statement(s) represent(s) the correct ADVANTAGES and DISADVANTAGES of these two incentive schemes? A The 5\% Options Pool would have a higher upfront cost for the PE firm but would cost less in the holding period since the options are only paid out once rather than in 3 consecutive years. B Both the Earn-Outs and the Options Pool would reduce the PE firm's ownership in the company by the exit. C An Options Pool would be sensitive to the Exit Multiple and the Exit EBITDA, while the Earn-Outs depend only on EBITDA in the holding period. D To estimate the relative costs, you could compare the total Earn-Out payments here to 5\%/(1+5\%)* MAX(O, Exit Equity Value \( \$ 940 \) million). E All of the statements above are correct.

View Answer
divider
INSTANT ANSWER

33) Consider the partial Debt Schedule shown below for the leveraged buyout of a company that recently experienced a downturn and expects to recover over the next several years: \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Debt Schedule: } & \multirow[b]{2}{*}{ Units: } & \multirow[b]{2}{*}{ FY20 } & \multicolumn{5}{|l|}{ Projected } \\ \hline & & & FY21 & FY22 & FY23 & FY24 & FY25 \\ \hline Revolver: & & & - & 8.9 & 15.2 & 17.6 & 18.5 \\ \hline Term Loan A: & & & 36.6 & 33.0 & 32.5 & 31.3 & 29.3 \\ \hline Term Loan B: & & & 44.7 & 44.3 & 43.9 & 47.4 & 50.8 \\ \hline Subordinated Notes: & & & 86.8 & 88.5 & 90.3 & 92.1 & 93.9 \\ \hline Total Interest Paid (Cash + PIK): & & & 168.1 & 174.6 & 181.9 & 188.4 & 192.5 \\ \hline \multicolumn{8}{|l|}{ Cash Flow Available for Debt Repayment: } \\ \hline Cash - Beginning of Period: & & & 200.0 & 200.0 & 200.0 & 200.0 & 200.0 \\ \hline\( (+) \) Free Cash Flow: & & & (205.8) & (49.5) & 82.7 & 118.8 & 133.0 \\ \hline\( (-) \) Minimum Cash: & & & (200.0) & \( (200.0) \) & (200.0) & (200.0) & (200.0) \\ \hline Cash Flow Available for Debt Repayment: & & & (295.3) & (139.0) & (6.8) & 29.3 & 43.5 \\ \hline\( (+) \) Revolver Draw / ( - ) Repayment: & & & 295.3 & 139.0 & 6.8 & (29.3) & \( (43.5) \) \\ \hline Cash Flow Available for Term Loan A: & & & - & - & - & - & - \\ \hline (-) Optional Repayments of Term Loan A: & & & \( \checkmark \) & - & \( \checkmark \) & - & \( \checkmark \) \\ \hline Cash Flow Available for Term Loan B: & & & - & - & - & - & - \\ \hline (-) Optional Repayments of Term Loan B: & & & - & - & - & - & - \\ \hline Cash Flow Available for Subordinated Notes: & & & - & - & - & - & - \\ \hline (-) Optional Repayments of Subordinated Notes: & & & - & - & - & - & - \\ \hline\( (-) \) Call Premium Paid: & & & - & - & - & - & - \\ \hline Cash Generated ABOVE Minimum Cash Balance: & & & - & - & - & - & - \\ \hline BoP Revolver: & & & - & 295.3 & 434.3 & 441.1 & 411.8 \\ \hline\( (-) \) Revolver Repayment: & \( 100.0 \% \) & & - & - & - & (29.3) & (43.5) \\ \hline EoP Revolver: & & - & 295.3 & 434.3 & 441.1 & 411.8 & 368.3 \\ \hline \end{tabular} Which of the following answer choices is a CORRECT inference that you can make based on only this Debt Schedule? A This leveraged buyout is unlikely to be viable (i.e., produce an IRR above 20\%) because there is almost no Debt Repayment, and the company's Interest Expense keeps rising until the exit. B If this LBO does produce an acceptable IRR, Debt Repayment is unlikely to be a key source of returns in the model. C The PE firm should use less Debt to fund this leveraged buyout because the company is likely to violate the Leverage Ratio and Interest Coverage Ratio covenants. D While the deal might still produce an IRR above \( 20 \% \), EBITDA Growth is unlikely to be a key source of returns in the model.

View Answer
divider