You are leading a team on a M&A deal. Suddenly your analyst has disappeared and you...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are leading a team on a M&A deal. Suddenly your analyst has disappeared and you have the following unfinished spreadsheet. The acquirer and the target are assumed to have zero growth. Now it is up to you to finish this job. You also believe that the tax rate will be 20% when this merger closes, so you are using 20% as the corporate tax rate in this calculation. Sales Operating Expenses Annual cost savings EBIT EBIT(1-t) Depreciation Gross Plant & Equipment Change in Working Capital Free Cash Flow to Firm Discount rate Firm Value Long term debt Equity value Acquirer 500 200 300 240 40 30 10 240 Target 120 60 60 48 20 40 5 23 8.00% 9% 3000 255.56 1000 100 2000 155.56 Combined 620 260 40 ?1? ??? | | ??? ??? ??? ?2? 8% ??? 1100 ?3? ?1? is ?2? is ?3? is The synergy of this merger is The maximum offer you can make is You are leading a team on a M&A deal. Suddenly your analyst has disappeared and you have the following unfinished spreadsheet. The acquirer and the target are assumed to have zero growth. Now it is up to you to finish this job. You also believe that the tax rate will be 20% when this merger closes, so you are using 20% as the corporate tax rate in this calculation. Sales Operating Expenses Annual cost savings EBIT EBIT(1-t) Depreciation Gross Plant & Equipment Change in Working Capital Free Cash Flow to Firm Discount rate Firm Value Long term debt Equity value Acquirer 500 200 300 240 40 30 10 240 Target 120 60 60 48 20 40 5 23 8.00% 9% 3000 255.56 1000 100 2000 155.56 Combined 620 260 40 ?1? ??? | | ??? ??? ??? ?2? 8% ??? 1100 ?3? ?1? is ?2? is ?3? is The synergy of this merger is The maximum offer you can make is
Expert Answer:
Answer rating: 100% (QA)
To fill in the missing information in the spreadsheet and answer the final questions lets go through the calculations step by step Were given the fina... View the full answer
Related Book For
Organizational Behavior
ISBN: 978-0133507669
16th edition
Authors: Stephen P. Robbins, Timothy A. Judge
Posted Date:
Students also viewed these finance questions
-
You are designing an open box. It will be made from a piece of cardboard that is 16 inches by 20 inches. You will form the box by cutting and folding the four square corners, then folding up sides,...
-
1. Based on the forecasts above, use the spreadsheet below to construct a pro forma income statement for Idexo over the next five years. What is the annual growth rate of the firm's net income over...
-
In Problem 10.16, we projected financial statements for Walmart Stores, Inc. (Walmart) for Years +1 through +5. The data in Exhibits 12.17-12.19 (pages 948-950) include the actual amounts for 2012...
-
In a LVDT, the two secondary voltages a. Are independent of the core position b. Are always in phase quadrature Oc. Vary equally depending on the core position O d. Vary unequally depending on the...
-
An elevator cab is pulled upward by a cable. The cab and its single occupant have a combined mass of 2000 kg. When that occupant drops a coin, its acceleration relative to the cab is 8.00m/s2...
-
Describe how configuration control and change control relate to each other.
-
Find the critical value for the ???? = 0.05 level of significance. Exercises 49 refer to the following data: Electric motors are assembled on four different production lines. Random samples of motors...
-
Joseph is the named insured under a Homeowners 3 policy (special form) with a liability limit of $100,000 per occurrence and a $1000 limit for medical payments to others. For each of the following...
-
A concentric tube heat exchanger having an area of 100 m2 is used to heat 5 kg/s of water that enters the heat exchanger at 50oC. The heating fluid is oil having a specific heat of 2.1 kJ/kg and a...
-
After a series of large project disasters, what country is requiring people to complete a new academic program in project management before leading a large government project? a. Australia b. U.K. c....
-
3. Which section of the Educators Guide to the MTOP refers to using theories of child development, in order to analyse information and plan accordingly? Note the page numbers of this section.
-
What is the common law, and why is it important?
-
What effect did early legal codes have on the modern criminal law?
-
Identify five sources of the criminal law.
-
Explain the goals of the criminal law.
-
In what ways is the criminal law different from the law of criminal procedure?
-
I then gained an insight into the genesis of what might be termed a monosymptomatic hysteria. I found that her right leg became painful during our hypnoses when they involved memories of nursing her...
-
Define cultural intelligence. Cite the books or journal articles you found in Capella's library. Explain why cultural intelligence is important for HR practitioners and other organizational managers.
-
What factors do you think make some organizations ineffective at managing emotions?
-
How is culture transmitted to employees?
-
What are the steps of the conflict process?
-
Examples of random variables used in this chapter included (a) the sex of the next person you meet, (b) the number of times a wireless network fails, (c) the time it takes to commute to school, (d)...
-
An econometrics class has 80 students, and the mean student weight is \(145 \mathrm{lb}\). A random sample of 4 students is selected from the class, and their average weight is calculated. Will the...
-
Suppose that \(Y_{1}, \ldots, Y_{n}\) are i.i.d. random variables with a \(N(1,4)\) distribution. Sketch the probability density of \(\bar{Y}\) when \(n=2\). Repeat this for \(n=10\) and \(n=100\)....
Study smarter with the SolutionInn App