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

Question

Ask a new Question

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

What is the total debt/EBITDA in 2022 in the base case?

1.9x

1.3x

1.5x

1.7x

What is the amount of cash available after revolver pay down in 2023 in the base case?

-2,609

-11,972

-20,175

What is the closing balance for term loan 1 in 2021?

32,400

39,600

37,800

What is the pro forma closing balance of cash?

71,806

10,000

78,237

16,000

What is the unlevered free cash flow in 2024 in the base case?

29,412

24,674

23,611

37,761

What is the terminal enterprise value in the upside case?

269,964

224,653

211,286

241,608

The sponsor IRR for the upside case is __________

32.4%

35.6%

30.5%

32.1%

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

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%

What is the investor IRR from term loan 1?

5.2%

4.3%

4.7%

5.8%

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

CoursHeroTranscribedText: Question 1 The daily volume of a brokerage company follows a normal distribution. The director wants to estimate the daily volume negotiated. a) What size should have a...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Consider the following information: Rate of Return if State Occurs State of Economy Boom :57 Bust of Economy .66 .34 Probability of State Stock A .09 .13 Stock B Stock C .03 .19 .24 -.04 a. What is...

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...

9 Review Later 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...

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...

Publication 15 Withholding for Federal Income Tax can be calculated using one of two methods. The first, covered in this section of the exercise, is the Percentage Method. Everett Kelly is married...

This is a comprehensive payroll problem that must be completed in the Excel worksheet provided. I have attached the excel template and the IRS Publication 15 Document that is needed to complete the...

Publication 15 In this step, you will use the Wage Bracket Method to calculate withholding. In this method, you do not need to calculate withholding allowances, but there are fairly-low limits as to...

How much does the value of IWPI-Spain, viewed as a stand-alone firm, change if the royalty fee is increased by 1% and the overhead allocation fee is reduced by 1%? What is the change in value to...

Why is a mission statement important to an organization?

When two or more CPA firms are involved in the audit of group financial statements, the unmodified opinion audit report is ______ modified to include reference to CPA firms considered component...

Falkon Corp. reported the following amounts in the share- holders' equity section of its December 31, 2016 statement of financial position: During 2017, the company had the following transactions...

Falkon Corp. reported the following amounts in the shareholders' equity section of its December 31, 2013 statement of financial position: Preferred shares, $8 dividend (10,000 shares authorized,...

Reef Office Supplies is interested in estimating the cost involved in hiring new employees. The following information is available regarding the costs of operating the Human Resource department at...

On January 1, 20X5, Par Ltd. purchased 80% of the voting shares of Sub Ltd. for $ 906,400. The SFP of Sub Ltd. on that date was as follows: The accounts receivable, inventory, and current liabilities...

Design a feedback form for Nicks restaurant customers using an ecommerce Web site.

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

1. Discuss the sport commitment model as a way to develop sport commitment and persistence and to counter sport withdrawal. What is the most critical aspect of this model and how can it be developed?

8. From a practical perspective, discuss steps you as a coach or parent can take to make sure that extrinsic motivation does not have the undesirable effect of reducing an athletes intrinsic...

1. How do you think situation-specific selfconfidence can be best developed in athletes? Provide a model and a theory.