Question

Ask a new Question

9

Complete the file named "LBO model - Questions" and use the completed model to answer questions 9 to 20.

LBO Model - Questions.xlsx

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