The basic tool of valuation of lbo transactions

Assignment Help Financial Management

Reference no: EM132035037

During our classes so far, we have been building a model that lets us valuate companies in accordance to the Highest and Best Use (HBU) concept. We started with target D/E, which we assumed to be optimal taking industry benchmarks as a proxy for the optimal level of debt to equity ratio. As a result of such operations, the obtained implied debt was not equal to its real value. To deal with the problem, we decided not to present equity valuation using free cash flow to equity technics.

Now we are going to change the way of thinking. We assume now that valuation is going to be performed from the perspective of real debt instead of implied one. This approach should be adopted assuming that valuation is carried out from the perspective of a particular transaction, where there are only two parties involved (i.e. buyer and seller) and, therefore, the assumption of open market existence is not fulfilled. Such situation can be, for example, observed in the case of LBO transactions. To achieve the desired effect, we can easily use Solver and adjust the capital structure in WACC calculation in a way that ensures equivalence between the real and the implied debt. However, PE companies in majority of cases use the FCFE technique as the basic tool of valuation of LBO transactions. Therefore, we need to build a model that will meet the PE funds’ requirements.

Your task is to construct a model that:

1) Makes it possible to estimate FCF for 8 years

2) Starts with the assumed debt and debt repayment schedule

3) Assumes a constant cost of equity

4) Assumes g for FCFE from year 9.

5) Starts the calculation of equity value using FCFE techniques

6) Based on the equity calculations for each year of estimation, makes it possible to estimate WACC, taking into account the real debt repayment schedule

7) Based on p. 6, makes it possible to valuate equity using FCFF and EVA techniques

8) Finishes with pro forma financial statements where assets = equity + liability

To test if your model works, please assume artificial data of an invented company.

Reference no: EM132035037

Questions Cloud

Market research information being obtained is accurate : What are some criteria researchers can use to make sure the market research information being obtained is accurate?

Practice visualizing impact of interest rates : The purpose of this case study is to give you practice visualizing the impact of interest rates and other financing aspects in a vehicle purchasing decision:

Write an email recommending the article : You are going to write an email recommending this article, making sure that the email contains the following: a summary of the articles, focusing.

Promotional channels for their nike free rn flyknit : Does Nike has specific messaging integrated throughout their promotional channels for their Nike Free RN Flyknit? If yes, please share their message.

The basic tool of valuation of lbo transactions : However, PE companies in majority of cases use the FCFE technique as the basic tool of valuation of LBO transactions.

Explain some of the emotional factors : Explain some of the rational considerations consumers have when considering purchasing a new home. Now explain some of the emotional factors.

How much of his first payment will be applied to interest : Your uncle borrows $56,000 from the bank at 10 percent interest over the eight-year life of the loan.

What traits were immediately noticed about harry reynolds : What traits were immediately noticed about Harry Reynolds in the story "Anne Barretta" on pages 161-162 in Reframing Organizations?

What is the npv of this opportunity if the cost of capital : The opportunity requires an initial investment of $9,000 plus an additional investment at the end of the second year of $45,000.

User Account

All Pages