Question Ask a new Question LBO Model - Questions.xlsx 9 Complete the file named "LBO model - Questions" and use the completed model to answer questions 9 to 20.

LBO Model - Questions.xlsx

9. What is the adjustment amount for identifiable assets? (Round to the nearest integer) Review Later 10,691 7,312 6,875 9,243

10 What is the total debt/EBITDA in 2022 in the base case? 1.9x 1.3x 1.5x 1.7x

11 What is the amount of cash available after revolver pay down in 2023 in the base case? -2,609 -11,972 0 -20,175

12 What is the closing balance for term loan 1 in 2021? 0 32,400 39,600 37,800

13 What is the pro forma closing balance of cash? 71,806 10,000 78,237 16,000

14 What is the unlevered free cash flow in 2024 in the base case? 29,412 24,674 23,611 37,761

15 What is the terminal enterprise value in the upside case? 269,964 224,653 211,286 241,608

16 The sponsor IRR for the upside case is __________ 32.4% 35.6% 30.5% 32.1%

17 What is the NPV of equity value in the base case (assuming the discount rate is the same as the IRR)? 42,197 45,586 38,640 63,940

18 In the downside case, what is the sponsor IRR if the entry EV/EBITDA is 6.5x and the exit EV/EBITDA is 6.0x? 17.6% 14.2% 16.0% 18.1%

19 What is the investor IRR from term loan 1? 5.2% 4.3% 4.7% 5.8%

20 In the base case, what is the sponsor cash-on-cash return if the debt/EBITDA for term loan 1 is 1.75x and the debt/EBITDA for term loan 2 is 2.00x? (Round to one decimal place) Review Later 5.8 5.7 5.0 4.5